View In:   ArcGIS Online Map Viewer

Name: SewerPipe (Asbuilt)

Display Field: PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Contains field updates of sewer pipe point locations.

Service Item Id: 3da841db98394bcaa5f44866afacc846

Copyright Text: Creation of this dataset utilized source data from the City of Longview.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 24000.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.0554630194825336E7
YMin: 3823798.913946222
XMax: -1.0543643305412684E7
YMax: 3839603.9875623398
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: TYPE
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 2
  Label: Force Main
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [132, 0, 168, 255]
  Width: 4
• Value: 1
  Label: Gravity
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 4
• Value: 3
  Label: Siphon
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 4
• Value: 4
  Label: Unknown
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 4
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: TYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• UPDATE_STATUS ( type: esriFieldTypeInteger, alias: UPDATE STATUS, editable: true, nullable: true, defaultValue: 0, modelName: UPDATE_STATUS , Coded Values: [0: IN PROGRESS] , [1: QC READY] , [2: QC APPROVED] , ...1 more... )
• UPDATE_NOTES ( type: esriFieldTypeString, alias: UPDATE NOTES, editable: true, nullable: true, length: 250, defaultValue: null, modelName: UPDATE_NOTES )
• 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 )
• 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... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 2
Name: 2
Domains:
• UPDATE_STATUS:
  Inherited
• ENABLED:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• DIAMETER:
  Inherited
• LENGTH:
  Inherited
• MATERIAL:
  Inherited
• TYPE:
  Inherited
• MODEL:
  Inherited
• MANNING_N:
  Inherited
• CITY_NAME:
  Inherited
• PIPE_SHAPE:
  Inherited
• LOCATION_CODE:
  Inherited
• OLD_MATERIAL:
  Inherited
• OLD_DIAMETER:
  Inherited
• STATUS_old:
  Inherited
• oldDIAMETER:
  Inherited
Templates:
• Name: Force Main
  Description:
  Prototype:
  oldDIAMETER: null
  ASSETID: null
  ENG_JOB_NO: null
  ID_NO: null
  MODEL: null
  OLD_DIAMETER: null
  UPDATE_STATUS: 0
  UPDATE_NOTES: null
  ENABLED: 1
  STATUS: null
  PROJECT_NAME: null
  OWNER: 1
  DATE_INSTALLED: null
  YEAR_INSTALLED: null
  ABANDONMENT_DATE: null
  DIAMETER: null
  LENGTH: null
  MATERIAL: null
  TYPE: 2
  SERVICE_AREA: null
  SLOPE: 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
  STATUS_old: 1
  OLD_MATERIAL: null
  ABANDONMENT_LINK: null
  LINKED_IMAGES: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: 1
Domains:
• UPDATE_STATUS:
  Inherited
• ENABLED:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• DIAMETER:
  Inherited
• LENGTH:
  Inherited
• MATERIAL:
  Inherited
• TYPE:
  Inherited
• MODEL:
  Inherited
• MANNING_N:
  Inherited
• CITY_NAME:
  Inherited
• PIPE_SHAPE:
  Inherited
• LOCATION_CODE:
  Inherited
• OLD_MATERIAL:
  Inherited
• OLD_DIAMETER:
  Inherited
• STATUS_old:
  Inherited
• oldDIAMETER:
  Inherited
Templates:
• Name: Gravity
  Description:
  Prototype:
  oldDIAMETER: null
  ASSETID: null
  ENG_JOB_NO: null
  ID_NO: null
  MODEL: null
  OLD_DIAMETER: null
  UPDATE_STATUS: 0
  UPDATE_NOTES: null
  ENABLED: 1
  STATUS: null
  PROJECT_NAME: null
  OWNER: 1
  DATE_INSTALLED: null
  YEAR_INSTALLED: null
  ABANDONMENT_DATE: null
  DIAMETER: null
  LENGTH: null
  MATERIAL: null
  TYPE: 1
  SERVICE_AREA: null
  SLOPE: 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
  STATUS_old: 1
  OLD_MATERIAL: null
  ABANDONMENT_LINK: null
  LINKED_IMAGES: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: 3
Domains:
• UPDATE_STATUS:
  Inherited
• ENABLED:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• DIAMETER:
  Inherited
• LENGTH:
  Inherited
• MATERIAL:
  Inherited
• TYPE:
  Inherited
• MODEL:
  Inherited
• MANNING_N:
  Inherited
• CITY_NAME:
  Inherited
• PIPE_SHAPE:
  Inherited
• LOCATION_CODE:
  Inherited
• OLD_MATERIAL:
  Inherited
• OLD_DIAMETER:
  Inherited
• STATUS_old:
  Inherited
• oldDIAMETER:
  Inherited
Templates:
• Name: Siphon
  Description:
  Prototype:
  oldDIAMETER: null
  ASSETID: null
  ENG_JOB_NO: null
  ID_NO: null
  MODEL: null
  OLD_DIAMETER: null
  UPDATE_STATUS: 0
  UPDATE_NOTES: null
  ENABLED: 1
  STATUS: null
  PROJECT_NAME: null
  OWNER: 1
  DATE_INSTALLED: null
  YEAR_INSTALLED: null
  ABANDONMENT_DATE: null
  DIAMETER: null
  LENGTH: null
  MATERIAL: null
  TYPE: 3
  SERVICE_AREA: null
  SLOPE: 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
  STATUS_old: 1
  OLD_MATERIAL: null
  ABANDONMENT_LINK: null
  LINKED_IMAGES: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: 4
Domains:
• UPDATE_STATUS:
  Inherited
• ENABLED:
  Inherited
• STATUS:
  Inherited
• OWNER:
  Inherited
• DIAMETER:
  Inherited
• LENGTH:
  Inherited
• MATERIAL:
  Inherited
• TYPE:
  Inherited
• MODEL:
  Inherited
• MANNING_N:
  Inherited
• CITY_NAME:
  Inherited
• PIPE_SHAPE:
  Inherited
• LOCATION_CODE:
  Inherited
• OLD_MATERIAL:
  Inherited
• OLD_DIAMETER:
  Inherited
• STATUS_old:
  Inherited
• oldDIAMETER:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  oldDIAMETER: null
  ASSETID: null
  ENG_JOB_NO: null
  ID_NO: null
  MODEL: null
  OLD_DIAMETER: null
  UPDATE_STATUS: 0
  UPDATE_NOTES: null
  ENABLED: 1
  STATUS: null
  PROJECT_NAME: null
  OWNER: 1
  DATE_INSTALLED: null
  YEAR_INSTALLED: null
  ABANDONMENT_DATE: null
  DIAMETER: null
  LENGTH: null
  MATERIAL: null
  TYPE: 4
  SERVICE_AREA: null
  SLOPE: 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
  STATUS_old: 1
  OLD_MATERIAL: null
  ABANDONMENT_LINK: null
  LINKED_IMAGES: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,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   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata