View In:   ArcGIS Online Map Viewer

Name: Storm Pipes

Display Field: PIPEUSE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 02d49f12cc7b413094ed52477c71e222

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 1171466.6214525774
YMin: 1252011.3447609916
XMax: 1208036.1621584967
YMax: 1289395.829046987
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Owner
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: DNVL
  Label: Danville
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 14
• Value: DVSD
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 14
• Value: IDOT
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 14
• Value: OTHR
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 14
• Value: PRVT
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 14
• Value: VA
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 14
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Owner

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PIPEUSE ( type: esriFieldTypeString, alias: Use of Sewer, editable: true, nullable: true, length: 20, defaultValue: SS, modelName: PipeUse , Coded Values: [SS: Sanitary] , [SW: Stormwater] , [PR: Processes] , ...4 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Pipe Material, editable: true, nullable: true, length: 5, defaultValue: VCP, modelName: Material , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...26 more... )
• CROSXSHAP ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CrosXShap , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
• SPCOND ( type: esriFieldTypeString, alias: Pipe Special Condition, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SPCond , Coded Values: [OU: Outside Drop Upper] , [OL: Outside Drop Lower] , [IU: Inside Drop Upper] , ...4 more... )
• PINVU ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: PInvU )
• PINVD ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: PInvD )
• PSCONDU ( type: esriFieldTypeString, alias: Pipe Seal Condition US, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSCondU , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• PSCONDD ( type: esriFieldTypeString, alias: Pipe Seal Condition DS, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSCondD , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• SYSOWNER ( type: esriFieldTypeString, alias: System Owner, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SysOwner , Coded Values: [DNVL: Danville] , [PRVT: Private] , [DVSD: Danville Sanitary District] , ...3 more... )
• PIPEID ( type: esriFieldTypeString, alias: Pipe Segment Reference, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PipeID )
• MHNOUS ( type: esriFieldTypeString, alias: Upstream manhole number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MHNoUS )
• MHNODS ( type: esriFieldTypeString, alias: Downstream manhole number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MHNoDS )
• RIMINVUS ( type: esriFieldTypeDouble, alias: Upstream Rim to Invert, editable: true, nullable: true, defaultValue: null, modelName: RimInvUS )
• RIMINVDS ( type: esriFieldTypeDouble, alias: Downstream Rim to Invert, editable: true, nullable: true, defaultValue: null, modelName: RimInvDS )
• INSTLDATE ( type: esriFieldTypeDate, alias: Year Constructed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstlDate )
• REHBDATE ( type: esriFieldTypeDate, alias: Year Rehabilitated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RehbDate )
• APN ( type: esriFieldTypeSmallInteger, alias: Asset Priority Number, editable: true, nullable: true, defaultValue: null, modelName: APN )
• LROOTCUT ( type: esriFieldTypeDate, alias: Last Root Cut, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LRootCut )
• LJETDATE ( type: esriFieldTypeDate, alias: Last Jet Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LJetDate )
• LHRBDATE ( type: esriFieldTypeDate, alias: Last Herbicide Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LHrbDate )
• LDGRDATE ( type: esriFieldTypeDate, alias: Last Degrease Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LDgrDate )
• LTELDATE ( type: esriFieldTypeDate, alias: Last Televise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LTelDate )
• TAPENO ( type: esriFieldTypeString, alias: Tape / Media No_, editable: true, nullable: true, length: 24, defaultValue: null, modelName: TapeNo )
• POF ( type: esriFieldTypeDouble, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: POF )
• COF ( type: esriFieldTypeDouble, alias: Criticality of Failure, editable: true, nullable: true, defaultValue: null, modelName: COF )
• LCLNDATE ( type: esriFieldTypeDate, alias: Last Cleaned Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LCLNDATE )
• FLOWTYPE ( type: esriFieldTypeString, alias: Flow Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FLOWTYPE )
• Owner ( type: esriFieldTypeString, alias: System Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner , Coded Values: [DNVL: Danville] , [PRVT: Private] , [DVSD: Danville Sanitary District] , ...3 more... )
• Basin ( type: esriFieldTypeString, alias: Basin, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Basin )
• Sub_Basin ( type: esriFieldTypeString, alias: Sub-Basin, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sub_Basin )
• OBJID ( type: esriFieldTypeInteger, alias: OBJID, editable: true, nullable: true, defaultValue: null, modelName: OBJID )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, required: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 2, modelName: SUBTYPE )
• PIPEDIA ( type: esriFieldTypeSmallInteger, alias: Pipe Diameter, editable: true, nullable: true, defaultValue: null, modelName: PIPEDIA2 )
• City ( type: esriFieldTypeString, alias: City Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ssCityName , Coded Values: [COD: City of Danville] )
• LOCCODE ( type: esriFieldTypeString, alias: Location Code, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SurfaceType , Coded Values: [A: Main highway- urban] , [C: Light highway] , [D: Easement/ Right of way] , ...12 more... )
• PIPECLASS ( type: esriFieldTypeString, alias: Pipe Classification, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPECLASS , Coded Values: [CS: Collector] , [FM: Force Main] , [IS: Interceptor] , ...2 more... )
• PIPEDIA_T ( type: esriFieldTypeString, alias: PIPEDIA_T, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PIPEDIA_T )
• LNMETHOD ( type: esriFieldTypeString, alias: Lining Method, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LNMETHOD , Coded Values: [CP: Cured in Place] , [FF: Fold and Form or Deform/Reform] , [SN: Segmented Panel] , ...3 more... )
• SurfType ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SurfType , Coded Values: [A: Asphalt] , [B: Concrete / Pavement] , [C: Concrete Collar] , ...3 more... )
• MHNOUS_old ( type: esriFieldTypeString, alias: MHNOUS_old, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MHNOUS_old )
• MHNODS_old ( type: esriFieldTypeString, alias: MHNODS_old, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MHNODS_old )
• PIPEID_old ( type: esriFieldTypeString, alias: PIPEID_old, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPEID_old )
• Abandoned ( type: esriFieldTypeString, alias: Abandoned, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Abandoned , Coded Values: [N: No] , [Y: Yes] )
• AddInfo ( type: esriFieldTypeString, alias: Additional Info, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AddInfo )
• rjnPIPEID ( type: esriFieldTypeString, alias: RJN PIPEID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: rjnPIPEID )
• lastEditedDate ( type: esriFieldTypeDate, alias: Last Edited Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastEditedDate )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, required: true, nullable: true, defaultValue: null, modelName: Shape.STLength() )

Types:

ID: DNVL
Name: Danville
Domains:
• PIPEUSE:
  Inherited
• MATERIAL:
  Inherited
• CROSXSHAP:
  Inherited
• SPCOND:
  Inherited
• PSCONDU:
  Inherited
• PSCONDD:
  Inherited
• SYSOWNER:
  Inherited
• Owner:
  Inherited
• Enabled:
  Inherited
• City:
  Inherited
• LOCCODE:
  Inherited
• PIPECLASS:
  Inherited
• LNMETHOD:
  Inherited
• SurfType:
  Inherited
• Abandoned:
  Inherited
Templates:
• Name: DNVL
  Description:
  Prototype:
  lastEditedDate: null
  rjnPIPEID: null
  PIPEUSE: SS
  MATERIAL: VCP
  CROSXSHAP: null
  SPCOND: null
  PINVU: null
  PINVD: null
  PSCONDU: null
  PSCONDD: null
  SYSOWNER: null
  PIPEID: null
  MHNOUS: null
  MHNODS: null
  RIMINVUS: null
  RIMINVDS: null
  INSTLDATE: null
  REHBDATE: null
  APN: null
  LROOTCUT: null
  LJETDATE: null
  LHRBDATE: null
  LDGRDATE: null
  LTELDATE: null
  TAPENO: null
  POF: null
  COF: null
  LCLNDATE: null
  FLOWTYPE: null
  Owner: DNVL
  Basin: null
  Sub_Basin: null
  OBJID: null
  Enabled: 1
  AddInfo: null
  SUBTYPE: 2
  PIPEDIA: null
  City: null
  LOCCODE: null
  PIPECLASS: null
  PIPEDIA_T: null
  LNMETHOD: null
  SurfType: null
  MHNOUS_old: null
  MHNODS_old: null
  PIPEID_old: null
  Abandoned: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: DVSD
Name: Other
Domains:
• PIPEUSE:
  Inherited
• MATERIAL:
  Inherited
• CROSXSHAP:
  Inherited
• SPCOND:
  Inherited
• PSCONDU:
  Inherited
• PSCONDD:
  Inherited
• SYSOWNER:
  Inherited
• Owner:
  Inherited
• Enabled:
  Inherited
• City:
  Inherited
• LOCCODE:
  Inherited
• PIPECLASS:
  Inherited
• LNMETHOD:
  Inherited
• SurfType:
  Inherited
• Abandoned:
  Inherited
Templates:
• Name: DVSD
  Description:
  Prototype:
  lastEditedDate: null
  rjnPIPEID: null
  PIPEUSE: SS
  MATERIAL: VCP
  CROSXSHAP: null
  SPCOND: null
  PINVU: null
  PINVD: null
  PSCONDU: null
  PSCONDD: null
  SYSOWNER: null
  PIPEID: null
  MHNOUS: null
  MHNODS: null
  RIMINVUS: null
  RIMINVDS: null
  INSTLDATE: null
  REHBDATE: null
  APN: null
  LROOTCUT: null
  LJETDATE: null
  LHRBDATE: null
  LDGRDATE: null
  LTELDATE: null
  TAPENO: null
  POF: null
  COF: null
  LCLNDATE: null
  FLOWTYPE: null
  Owner: DVSD
  Basin: null
  Sub_Basin: null
  OBJID: null
  Enabled: 1
  AddInfo: null
  SUBTYPE: 2
  PIPEDIA: null
  City: null
  LOCCODE: null
  PIPECLASS: null
  PIPEDIA_T: null
  LNMETHOD: null
  SurfType: null
  MHNOUS_old: null
  MHNODS_old: null
  PIPEID_old: null
  Abandoned: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: IDOT
Name: Other
Domains:
• PIPEUSE:
  Inherited
• MATERIAL:
  Inherited
• CROSXSHAP:
  Inherited
• SPCOND:
  Inherited
• PSCONDU:
  Inherited
• PSCONDD:
  Inherited
• SYSOWNER:
  Inherited
• Owner:
  Inherited
• Enabled:
  Inherited
• City:
  Inherited
• LOCCODE:
  Inherited
• PIPECLASS:
  Inherited
• LNMETHOD:
  Inherited
• SurfType:
  Inherited
• Abandoned:
  Inherited
Templates:
• Name: IDOT
  Description:
  Prototype:
  lastEditedDate: null
  rjnPIPEID: null
  PIPEUSE: SS
  MATERIAL: VCP
  CROSXSHAP: null
  SPCOND: null
  PINVU: null
  PINVD: null
  PSCONDU: null
  PSCONDD: null
  SYSOWNER: null
  PIPEID: null
  MHNOUS: null
  MHNODS: null
  RIMINVUS: null
  RIMINVDS: null
  INSTLDATE: null
  REHBDATE: null
  APN: null
  LROOTCUT: null
  LJETDATE: null
  LHRBDATE: null
  LDGRDATE: null
  LTELDATE: null
  TAPENO: null
  POF: null
  COF: null
  LCLNDATE: null
  FLOWTYPE: null
  Owner: IDOT
  Basin: null
  Sub_Basin: null
  OBJID: null
  Enabled: 1
  AddInfo: null
  SUBTYPE: 2
  PIPEDIA: null
  City: null
  LOCCODE: null
  PIPECLASS: null
  PIPEDIA_T: null
  LNMETHOD: null
  SurfType: null
  MHNOUS_old: null
  MHNODS_old: null
  PIPEID_old: null
  Abandoned: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: OTHR
Name: Other
Domains:
• PIPEUSE:
  Inherited
• MATERIAL:
  Inherited
• CROSXSHAP:
  Inherited
• SPCOND:
  Inherited
• PSCONDU:
  Inherited
• PSCONDD:
  Inherited
• SYSOWNER:
  Inherited
• Owner:
  Inherited
• Enabled:
  Inherited
• City:
  Inherited
• LOCCODE:
  Inherited
• PIPECLASS:
  Inherited
• LNMETHOD:
  Inherited
• SurfType:
  Inherited
• Abandoned:
  Inherited
Templates:
• Name: OTHR
  Description:
  Prototype:
  lastEditedDate: null
  rjnPIPEID: null
  PIPEUSE: SS
  MATERIAL: VCP
  CROSXSHAP: null
  SPCOND: null
  PINVU: null
  PINVD: null
  PSCONDU: null
  PSCONDD: null
  SYSOWNER: null
  PIPEID: null
  MHNOUS: null
  MHNODS: null
  RIMINVUS: null
  RIMINVDS: null
  INSTLDATE: null
  REHBDATE: null
  APN: null
  LROOTCUT: null
  LJETDATE: null
  LHRBDATE: null
  LDGRDATE: null
  LTELDATE: null
  TAPENO: null
  POF: null
  COF: null
  LCLNDATE: null
  FLOWTYPE: null
  Owner: OTHR
  Basin: null
  Sub_Basin: null
  OBJID: null
  Enabled: 1
  AddInfo: null
  SUBTYPE: 2
  PIPEDIA: null
  City: null
  LOCCODE: null
  PIPECLASS: null
  PIPEDIA_T: null
  LNMETHOD: null
  SurfType: null
  MHNOUS_old: null
  MHNODS_old: null
  PIPEID_old: null
  Abandoned: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: PRVT
Name: Other
Domains:
• PIPEUSE:
  Inherited
• MATERIAL:
  Inherited
• CROSXSHAP:
  Inherited
• SPCOND:
  Inherited
• PSCONDU:
  Inherited
• PSCONDD:
  Inherited
• SYSOWNER:
  Inherited
• Owner:
  Inherited
• Enabled:
  Inherited
• City:
  Inherited
• LOCCODE:
  Inherited
• PIPECLASS:
  Inherited
• LNMETHOD:
  Inherited
• SurfType:
  Inherited
• Abandoned:
  Inherited
Templates:
• Name: PRVT
  Description:
  Prototype:
  lastEditedDate: null
  rjnPIPEID: null
  PIPEUSE: SS
  MATERIAL: VCP
  CROSXSHAP: null
  SPCOND: null
  PINVU: null
  PINVD: null
  PSCONDU: null
  PSCONDD: null
  SYSOWNER: null
  PIPEID: null
  MHNOUS: null
  MHNODS: null
  RIMINVUS: null
  RIMINVDS: null
  INSTLDATE: null
  REHBDATE: null
  APN: null
  LROOTCUT: null
  LJETDATE: null
  LHRBDATE: null
  LDGRDATE: null
  LTELDATE: null
  TAPENO: null
  POF: null
  COF: null
  LCLNDATE: null
  FLOWTYPE: null
  Owner: PRVT
  Basin: null
  Sub_Basin: null
  OBJID: null
  Enabled: 1
  AddInfo: null
  SUBTYPE: 2
  PIPEDIA: null
  City: null
  LOCCODE: null
  PIPECLASS: null
  PIPEDIA_T: null
  LNMETHOD: null
  SurfType: null
  MHNOUS_old: null
  MHNODS_old: null
  PIPEID_old: null
  Abandoned: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: VA
Name: Other
Domains:
• PIPEUSE:
  Inherited
• MATERIAL:
  Inherited
• CROSXSHAP:
  Inherited
• SPCOND:
  Inherited
• PSCONDU:
  Inherited
• PSCONDD:
  Inherited
• SYSOWNER:
  Inherited
• Owner:
  Inherited
• Enabled:
  Inherited
• City:
  Inherited
• LOCCODE:
  Inherited
• PIPECLASS:
  Inherited
• LNMETHOD:
  Inherited
• SurfType:
  Inherited
• Abandoned:
  Inherited
Templates:
• Name: VA
  Description:
  Prototype:
  lastEditedDate: null
  rjnPIPEID: null
  PIPEUSE: SS
  MATERIAL: VCP
  CROSXSHAP: null
  SPCOND: null
  PINVU: null
  PINVD: null
  PSCONDU: null
  PSCONDD: null
  SYSOWNER: null
  PIPEID: null
  MHNOUS: null
  MHNODS: null
  RIMINVUS: null
  RIMINVDS: null
  INSTLDATE: null
  REHBDATE: null
  APN: null
  LROOTCUT: null
  LJETDATE: null
  LHRBDATE: null
  LDGRDATE: null
  LTELDATE: null
  TAPENO: null
  POF: null
  COF: null
  LCLNDATE: null
  FLOWTYPE: null
  Owner: VA
  Basin: null
  Sub_Basin: null
  OBJID: null
  Enabled: 1
  AddInfo: null
  SUBTYPE: 2
  PIPEDIA: null
  City: null
  LOCCODE: null
  PIPECLASS: null
  PIPEDIA_T: null
  LNMETHOD: null
  SurfType: null
  MHNOUS_old: null
  MHNODS_old: null
  PIPEID_old: null
  Abandoned: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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