View In:   ArcGIS Online Map Viewer

Parent Layer: Abandoned Sewer

Name: Abandoned Sewer Pipe

Display Field: PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 9d6e410c990140ceafbd3402360dabe6

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 100000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -1.055867280095803E7
YMin: 3813907.594834009
XMax: -1.0537968460270416E7
YMax: 3842521.44265494
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 4
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSETID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STATUS , Coded Values: [ACTIVE: ACTIVE] , [ABANDONED: ABANDONED] , [INACTIVE: INACTIVE] )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROJECT_NAME )
• ENG_JOB_NO ( type: esriFieldTypeString, alias: ENG_JOB_NO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ENG_JOB_NO )
• OWNER ( type: esriFieldTypeInteger, alias: OWNER, editable: true, nullable: true, defaultValue: 1, modelName: OWNER , Coded Values: [0: 0] , [1: CITY OF LONGVIEW] , [5: CITY OF LONGVIEW PARKS] , ...3 more... )
• DATE_INSTALLED ( type: esriFieldTypeDate, alias: DATE_INSTALLED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_INSTALLED )
• YEAR_INSTALLED ( type: esriFieldTypeSmallInteger, alias: YEAR_INSTALLED, editable: true, nullable: true, defaultValue: null, modelName: YEAR_INSTALLED )
• ABANDONMENT_DATE ( type: esriFieldTypeDate, alias: ABANDONMENT DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ABANDONMENT_DATE )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0: UNKNOWN] , [1: 1"] , [1.5: 1.5"] , ...30 more... )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH , Range: [0, 21120] )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL , Coded Values: [AC: ASBESTOS CEMENT] , [BR: BRICK] , [CAS: CAST IRON] , ...21 more... )
• ID_NO ( type: esriFieldTypeString, alias: ID_NO, editable: true, nullable: true, length: 32, defaultValue: null, modelName: ID_NO )
• TYPE ( type: esriFieldTypeInteger, alias: TYPE, editable: true, nullable: true, defaultValue: 1, modelName: TYPE , Coded Values: [1: GRAVITY] , [3: SIPHON] , [4: UNKNOWN] , ...2 more... )
• SERVICE_AREA ( type: esriFieldTypeString, alias: SERVICE_AREA, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SERVICE_AREA )
• SLOPE ( type: esriFieldTypeDouble, alias: SLOPE, editable: true, nullable: true, defaultValue: null, modelName: SLOPE )
• MODEL ( type: esriFieldTypeInteger, alias: MODEL, editable: true, nullable: true, defaultValue: null, modelName: MODEL , Coded Values: [0: 0] , [1: YES] , [2: NO] , ...1 more... )
• MANNING_N ( type: esriFieldTypeDouble, alias: MANNING_N, editable: true, nullable: true, defaultValue: 0, modelName: MANNING_N , Coded Values: [0.009: .009] , [0.01: .010] , [0.012: .012] , ...3 more... )
• CITY_NAME ( type: esriFieldTypeString, alias: CITY_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY_NAME , Coded Values: [BS: BIG SANDY] , [CL: CLARKSVILLE CITY] , [EM: EAST MOUNTAIN] , ...18 more... )
• PIPE_SHAPE ( type: esriFieldTypeString, alias: PIPE_SHAPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIPE_SHAPE , Coded Values: [C: CIRCULAR] )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 200, defaultValue: null, modelName: COMMENT )
• LOCATION_CODE ( type: esriFieldTypeString, alias: LOCATION_CODE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION_CODE , Coded Values: [A: MAIN HIGHWAY - URBAN] , [B: MAIN HIGHWAY - RURAL] , [C: LIGHT HIGHWAY] )
• UPSTREAM_MANHOLE ( type: esriFieldTypeString, alias: UPSTREAM_MANHOLE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UPSTREAM_MANHOLE )
• DOWNSTREAM_MANHOLE ( type: esriFieldTypeString, alias: DOWNSTREAM_MANHOLE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DOWNSTREAM_MANHOLE )
• UPSTREAM_CLEANOUT ( type: esriFieldTypeString, alias: UPSTREAM_CLEANOUT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UPSTREAM_CLEANOUT )
• DOWNSTREAM_CLEANOUT ( type: esriFieldTypeString, alias: DOWNSTREAM_CLEANOUT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DOWNSTREAM_CLEANOUT )
• UPSTREAM_LIFTSTATION ( type: esriFieldTypeString, alias: UPSTREAM_LIFTSTATION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UPSTREAM_LIFTSTATION )
• DOWNSTREAM_LIFTSTATION ( type: esriFieldTypeString, alias: DOWNSTREAM_LIFTSTATION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DOWNSTREAM_LIFTSTATION )
• BEGIN_DEVICE_EID ( type: esriFieldTypeInteger, alias: BEGIN_DEVICE_EID, editable: true, nullable: true, defaultValue: null, modelName: BEGIN_DEVICE_EID )
• END_DEVICE_EID ( type: esriFieldTypeInteger, alias: END_DEVICE_EID, editable: true, nullable: true, defaultValue: null, modelName: END_DEVICE_EID )
• LF_ABANDONMENT_EID ( type: esriFieldTypeString, alias: LF ABANDONMENT ENTRY ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LF_ABANDONMENT_EID )
• LF_ASBUILT_EID ( type: esriFieldTypeString, alias: LF ASBUILT ENTRY ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LF_ASBUILT_EID )
• LF_SKETCH_EID ( type: esriFieldTypeString, alias: LF SKETCH ENTRY ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LF_SKETCH_EID )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LINKED_IMAGES ( type: esriFieldTypeString, alias: LINKED_IMAGES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LINKED_IMAGES )
• ABANDONMENT_LINK ( type: esriFieldTypeString, alias: ABANDONMENT_LINK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Abandonment_Link )
• OLD_MATERIAL ( type: esriFieldTypeInteger, alias: OLD_MATERIAL, editable: true, nullable: true, defaultValue: null, modelName: OLD_MATERIAL , Coded Values: [6: CIP] , [5: DIP] , [4: HDPE] , ...4 more... )
• OLD_DIAMETER ( type: esriFieldTypeInteger, alias: OLD_DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: OLD_DIAMETER , Coded Values: [0: 0] , [1: 1"] , [105: 1.5"] , ...30 more... )
• STATUS_old ( type: esriFieldTypeInteger, alias: STATUS, editable: true, nullable: true, defaultValue: 1, modelName: STATUS , Coded Values: [1: ACTIVE] , [2: ABANDONED] , [0: 0] , ...1 more... )
• oldDIAMETER ( type: esriFieldTypeInteger, alias: oldDIAMETER, editable: true, nullable: true, defaultValue: null, modelName: oldDIAMETER , Coded Values: [21: 2''] , [1: 3"] , [2: 4"] , ...18 more... )
• CAP_ASSET_NO ( type: esriFieldTypeString, alias: CAP ASSET NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CAP_ASSET_NO )

Templates:

• Name: Abandoned Sewer Pipe
  Description:
  Prototype:
  oldDIAMETER: null
  STATUS_old: 1
  ASSETID: null
  ENABLED: 1
  STATUS: null
  PROJECT_NAME: null
  ENG_JOB_NO: null
  OWNER: 1
  DATE_INSTALLED: null
  YEAR_INSTALLED: null
  ABANDONMENT_DATE: null
  DIAMETER: null
  LENGTH: null
  MATERIAL: null
  ID_NO: null
  TYPE: 1
  SERVICE_AREA: null
  SLOPE: null
  MODEL: null
  MANNING_N: 0
  CITY_NAME: null
  PIPE_SHAPE: null
  COMMENT: null
  LOCATION_CODE: null
  UPSTREAM_MANHOLE: null
  DOWNSTREAM_MANHOLE: null
  UPSTREAM_CLEANOUT: null
  DOWNSTREAM_CLEANOUT: null
  UPSTREAM_LIFTSTATION: null
  DOWNSTREAM_LIFTSTATION: null
  BEGIN_DEVICE_EID: null
  END_DEVICE_EID: null
  LF_ABANDONMENT_EID: null
  LF_ASBUILT_EID: null
  LF_SKETCH_EID: null
  OLD_DIAMETER: null
  OLD_MATERIAL: null
  ABANDONMENT_LINK: null
  LINKED_IMAGES: null
  CAP_ASSET_NO: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• DownStreamManhole (2) -- Related To: Manhole (13)
• UpStream Manhole (3) -- Related To: Manhole (13)
• DownStream Cleanout (4) -- Related To: Cleanout (15)
• UpStream Cleanout (5) -- Related To: Cleanout (15)
• DownStream LiftStation (0) -- Related To: Lift Station (12)
• UpStream LiftStation (1) -- Related To: Lift Station (12)

Capabilities: Query,Create,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata