View In:   ArcGIS Online Map Viewer

Parent Layer: Sewer Line

Name: Abandoned and Removed Pipe

Display Field: cpsubnetworkname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: b14d060e2fec4479b195b65db50508aa

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1128.497176

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 2449021.188867311
YMin: 508358.2479520507
XMax: 2507463.77605014
YMax: 545803.4986191473
Spatial Reference: 102749  (2286)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ASSETTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [38, 115, 0, 255]
Width: 1
Default Label: Other
UniqueValueInfos:
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 2
• Value: 1
  Label: Collector Gravity Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 2
• Value: 2
  Label: Interceptor Gravity Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 2
Transparency: 70
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [38, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2400.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSETTYPE

Fields:

• lastmaintdate ( type: esriFieldTypeDate, alias: Last Maintenance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastmaintdate )
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset group, editable: true, nullable: false, defaultValue: 0, modelName: ASSETGROUP, required: true )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: false, defaultValue: 0, modelName: ASSETTYPE, required: true )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association status, editable: false, nullable: false, defaultValue: 0, modelName: ASSOCIATIONSTATUS, required: true , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is connected, editable: false, nullable: false, defaultValue: 2, modelName: ISCONNECTED, required: true , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• FROMDEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: From device terminal, editable: true, nullable: false, defaultValue: 0, modelName: FROMDEVICETERMINAL, required: true , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...19 more... )
• TODEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: To device terminal, editable: true, nullable: false, defaultValue: 0, modelName: TODEVICETERMINAL, required: true , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...19 more... )
• CREATIONDATE ( type: esriFieldTypeDate, alias: Creation date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATIONDATE, required: true )
• CREATOR ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATOR, required: true )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE, required: true )
• UPDATEDBY ( type: esriFieldTypeString, alias: Updated by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: UPDATEDBY, required: true )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• cpsubnetworkname ( type: esriFieldTypeString, alias: cpsubnetworkname, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: cpsubnetworkname, required: true )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTEDSUBNETWORKNAME, required: true )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting subnetwork name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTINGSUBNETWORKNAME, required: true )
• systemsubnetworkname ( type: esriFieldTypeString, alias: systemsubnetworkname, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: systemsubnetworkname, required: true )
• sewershedsubnetworkname ( type: esriFieldTypeString, alias: sewershedsubnetworkname, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: sewershedsubnetworkname, required: true )
• diameter ( type: esriFieldTypeDouble, alias: Size/Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• linertype ( type: esriFieldTypeSmallInteger, alias: Liner Type, editable: true, nullable: true, defaultValue: null, modelName: linertype )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: downelev )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: upelev )
• slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: slope )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 0, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: ownedby )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: maintby )
• tracerwire ( type: esriFieldTypeSmallInteger, alias: Tracer Wire, editable: true, nullable: true, defaultValue: null, modelName: tracerwire )
• measuredlength ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: measuredlength )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: 0, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...4 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: 0, modelName: spatialconfidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• cptraceability ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, editable: true, nullable: true, defaultValue: null, modelName: cptraceability , Coded Values: [1: Traceable] , [2: Not Traceable] )
• cpoverride ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, editable: true, nullable: true, defaultValue: null, modelName: cpoverride , Coded Values: [1: Traceable] , [2: Not Traceable] )
• material ( type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: material )
• bondedinsulated ( type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, editable: true, nullable: true, defaultValue: null, modelName: bondedinsulated , Coded Values: [1: Bonded] , [2: Insulated] )
• mainshape ( type: esriFieldTypeSmallInteger, alias: Main Shape, editable: true, nullable: true, defaultValue: null, modelName: mainshape )
• source_assetpk ( type: esriFieldTypeDouble, alias: AssetPK, editable: true, nullable: true, defaultValue: null, modelName: source_assetpk )
• source_nodeus ( type: esriFieldTypeString, alias: NodeUS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: source_nodeus )
• source_nodeds ( type: esriFieldTypeString, alias: NodeDS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: source_nodeds )
• source_address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: source_address )
• source_layer ( type: esriFieldTypeString, alias: Layer, editable: true, nullable: true, length: 254, defaultValue: null, modelName: source_layer )
• source_length_ft ( type: esriFieldTypeDouble, alias: Length_ft, editable: true, nullable: true, defaultValue: null, modelName: source_length_ft )
• source_dia_inches ( type: esriFieldTypeDouble, alias: Dia_inches, editable: true, nullable: true, defaultValue: null, modelName: source_dia_inches )
• source_material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 254, defaultValue: null, modelName: source_material )
• source_other ( type: esriFieldTypeString, alias: Other, editable: true, nullable: true, length: 254, defaultValue: null, modelName: source_other )
• source_assetid ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: source_assetid )
• source_ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: source_ownedby , Coded Values: [1: City of Pullman - CoP] , [2: Private - PVT] , [10: Washington State University - WSU] , ...1 more... )
• source_maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: source_maintby , Coded Values: [1: City of Pullman - CoP] , [2: Private - PVT] , [10: Washington State University - WSU] , ...1 more... )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: false, nullable: true, defaultValue: 6, modelName: VALIDATIONSTATUS, required: true , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
• lifecyclestatusdate ( type: esriFieldTypeDate, alias: Lifecycle Status Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lifecyclestatusdate )
• locationdescription ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: locationdescription )
• upstream_assetid ( type: esriFieldTypeString, alias: Upstream Asset ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: upstream_assetid )
• downstream_assetid ( type: esriFieldTypeString, alias: Downstream Asset ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: downstream_assetid )
• og_usetype ( type: esriFieldTypeString, alias: OG - Pipe Use Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: og_usetype )
• Shape__Length ( type: esriFieldTypeDouble, alias: shape_Length, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )

Types:

ID: 0
Name: Unknown
Domains:
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• lifecyclestatus:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
• cptraceability:
  Inherited
• cpoverride:
  Inherited
• bondedinsulated:
  Inherited
• source_ownedby:
  Inherited
• source_maintby:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  ASSETGROUP: 1
  lastmaintdate: null
  ASSETTYPE: 0
  upstream_assetid: null
  locationdescription: null
  FROMDEVICETERMINAL: 0
  downstream_assetid: null
  source_material: null
  source_dia_inches: null
  source_length_ft: null
  designtype: 0
  diameter: 0
  slope: null
  assetid: null
  ownedby: 1
  maintby: 1
  notes: null
  spatialsource: 0
  cpoverride: null
  source_assetid: null
  source_other: null
  og_usetype: null
  TODEVICETERMINAL: 0
  lifecyclestatusdate: null
  source_layer: null
  source_maintby: null
  source_ownedby: null
  linertype: 0
  downelev: null
  upelev: null
  lifecyclestatus: 8
  installdate: null
  tracerwire: 0
  measuredlength: null
  spatialconfidence: 0
  cptraceability: null
  material: 0
  bondedinsulated: null
  mainshape: 0
  source_assetpk: null
  source_nodeus: null
  source_nodeds: null
  source_address: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Collector Gravity Main
Domains:
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• lifecyclestatus:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
• cptraceability:
  Inherited
• cpoverride:
  Inherited
• bondedinsulated:
  Inherited
• source_ownedby:
  Inherited
• source_maintby:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Collector Gravity Main
  Description:
  Prototype:
  ASSETGROUP: 1
  lastmaintdate: null
  ASSETTYPE: 1
  upstream_assetid: null
  locationdescription: null
  FROMDEVICETERMINAL: 0
  downstream_assetid: null
  source_material: null
  source_dia_inches: null
  source_length_ft: null
  designtype: 0
  diameter: 0
  slope: null
  assetid: null
  ownedby: 1
  maintby: 1
  notes: null
  spatialsource: 0
  cpoverride: null
  source_assetid: null
  source_other: null
  og_usetype: null
  TODEVICETERMINAL: 0
  lifecyclestatusdate: null
  source_layer: null
  source_maintby: null
  source_ownedby: null
  linertype: 0
  downelev: null
  upelev: null
  lifecyclestatus: 8
  installdate: null
  tracerwire: 0
  measuredlength: null
  spatialconfidence: 0
  cptraceability: null
  material: 0
  bondedinsulated: null
  mainshape: 0
  source_assetpk: null
  source_nodeus: null
  source_nodeds: null
  source_address: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Interceptor Gravity Main
Domains:
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• lifecyclestatus:
  Inherited
• spatialsource:
  Inherited
• spatialconfidence:
  Inherited
• cptraceability:
  Inherited
• cpoverride:
  Inherited
• bondedinsulated:
  Inherited
• source_ownedby:
  Inherited
• source_maintby:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Interceptor Gravity Main
  Description:
  Prototype:
  ASSETGROUP: 1
  lastmaintdate: null
  ASSETTYPE: 2
  upstream_assetid: null
  locationdescription: null
  FROMDEVICETERMINAL: 0
  downstream_assetid: null
  source_material: null
  source_dia_inches: null
  source_length_ft: null
  designtype: 0
  diameter: 0
  slope: null
  assetid: null
  ownedby: 1
  maintby: 1
  notes: null
  spatialsource: 0
  cpoverride: null
  source_assetid: null
  source_other: null
  og_usetype: null
  TODEVICETERMINAL: 0
  lifecyclestatusdate: null
  source_layer: null
  source_maintby: null
  source_ownedby: null
  linertype: 0
  downelev: null
  upelev: null
  lifecyclestatus: 8
  installdate: null
  tracerwire: 0
  measuredlength: null
  spatialconfidence: 0
  cptraceability: null
  material: 0
  bondedinsulated: null
  mainshape: 0
  source_assetpk: null
  source_nodeus: null
  source_nodeds: null
  source_address: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: CREATIONDATE
• Creator Field: CREATOR
• Edit Date Field: LASTUPDATE
• Editor Field: UPDATEDBY

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata