View In:   ArcGIS Online Map Viewer

Name: Pipe

Display Field: PIPEDIAMETER

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Feature class StormwaterPipe stores geometry and attributes of enclosed constructed pipe conveyance features, culvert crossings, or bridges within the City of Wilmington. Only those features within the public right-of-way are included within this data set. Data set does not provide a complete hydrological or infrastructural portrait of the city; only those examined features with significance within the City’s stormwater infrastructure are included. Furthermore, the layer is composed of data collected by multiple different entities working under different or unknown procedural frameworks across an extended temporal scale, resulting in data quality discrepancies across the dataset. Dataset is intended as a system inventory guide, and is not a complete survey-grade assessment of the City’s stormwater system.

Service Item Id: a3e1a8809871451882b51325ac87b027

Copyright Text: Data collected by several different entities and delivered to City of Wilmington Stormwater Services for further use and distribution. Contributing entities include: City of Wilmington Stormwater Services, City of Wilmington Public Services-Engineering Dept, Survey Section, Dewberry (formerly Dewberry and Davis), McKim and Creed, WK Dickson, Inc, and Woolpert, Inc.

Default Visibility: false

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: 2316066.063820556
YMin: 140052.86707022786
XMax: 2360832.577633798
YMax: 189709.4117858112
Spatial Reference: 103122  (6543)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PIPE_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: PIPE
  Label: Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 7
• Value: CULVERT
  Label: Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 7
• Value: BRIDGE
  Label: Bridge
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 2
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: PIPE_TYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SUBTYPE_CLASS ( type: esriFieldTypeSmallInteger, alias: SubType Class, editable: true, nullable: true, defaultValue: null, modelName: SUBTYPE_CLASS )
• PIPE_TYPE ( type: esriFieldTypeString, alias: Pipe Type, editable: true, nullable: true, length: 50, defaultValue: PIPE, modelName: PIPE_TYPE , Coded Values: [PIPE: Pipe] , [CULVERT: Culvert] , [BRIDGE: Bridge] )
• UPINVERTDEPTH ( type: esriFieldTypeDouble, alias: Up Depth, editable: true, nullable: true, defaultValue: 99, modelName: UPINVERTDEPTH )
• UPINVUNRELIABLE ( type: esriFieldTypeString, alias: Up Unreliable, editable: true, nullable: true, length: 50, defaultValue: NA, modelName: UPINVUNRELIABLE , Coded Values: [NOT FOUND: Not Found] , [FILLED WITH SEDIMENT OR DEBRIS: Filled with Sediment or Debris] , [OVERGROWN: Overgrown] , ...14 more... )
• DNINVERTDEPTH ( type: esriFieldTypeDouble, alias: Down Depth, editable: true, nullable: true, defaultValue: 99, modelName: DNINVERTDEPTH )
• DNINVUNRELIABLE ( type: esriFieldTypeString, alias: Down Unreliable, editable: true, nullable: true, length: 50, defaultValue: NA, modelName: DNINVUNRELIABLE , Coded Values: [NOT FOUND: Not Found] , [FILLED WITH SEDIMENT OR DEBRIS: Filled with Sediment or Debris] , [OVERGROWN: Overgrown] , ...14 more... )
• PIPE_SHP ( type: esriFieldTypeString, alias: Shape, editable: true, nullable: true, length: 50, defaultValue: CIRCULAR, modelName: PIPE_SHP , Coded Values: [CIRCULAR: Circular] , [ARCHED: Arched] , [ELLIPTICAL: Elliptical] , ...2 more... )
• PIPEMATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: RCP, modelName: PIPEMATERIAL , Coded Values: [RCP: Reinforced Concrete] , [CMP: Corrugated Metal] , [CPP: Corrugated Plastic] , ...9 more... )
• PIPEDIAMETER ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIPEDIAMETER , Coded Values: [10: 10] , [12: 12] , [15: 15] , ...25 more... )
• HEIGHT ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: 99, modelName: HEIGHT )
• WIDTH ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: 99, modelName: WIDTH )
• NUM_PIPES ( type: esriFieldTypeString, alias: Number of Pipes, editable: true, nullable: true, length: 50, defaultValue: SINGLE, modelName: NUM_PIPES , Coded Values: [SINGLE: Single] , [DOUBLE: Double] , [TRIPLE: Triple] , ...3 more... )
• UPEND_CONDITION ( type: esriFieldTypeString, alias: Up End Cond., editable: true, nullable: true, length: 50, defaultValue: SEE CONNECTING POINTS, modelName: UPEND_CONDITION , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...8 more... )
• UPEND_INACCESSIBLE ( type: esriFieldTypeString, alias: Up Inaccess., editable: true, nullable: true, length: 50, defaultValue: NA, modelName: UPEND_INACCESSIBLE , Coded Values: [OVERGROWN: Overgrown] , [FILLED WTIH SEDIMENT OR DEBRIS: Filled with sediment or debris] , [FILLED WITH WATER: Filled with water] , ...19 more... )
• UPEND_COMMENTS ( type: esriFieldTypeString, alias: Up Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: UPEND_COMMENTS )
• UPEND_STNDRDCOMMENTS ( type: esriFieldTypeString, alias: Up Comments List, editable: true, nullable: true, length: 254, defaultValue: null, modelName: UPEND_STNDRDCOMMENTS , Coded Values: [TRASH COLLECTION INSERT: Trash Collection Insert] , [ABANDONED: Abandoned - All Pipes Sealed] , [FILLED WITH SEDIMENT OR DEBRIS: Filled with Sediment or Debris] , ...42 more... )
• DNEND_CONDITION ( type: esriFieldTypeString, alias: Down End Cond., editable: true, nullable: true, length: 50, defaultValue: SEE CONNECTING POINTS, modelName: DNEND_CONDITION , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...8 more... )
• DNEND_INACCESSIBLE ( type: esriFieldTypeString, alias: Down Inaccess., editable: true, nullable: true, length: 50, defaultValue: NA, modelName: DNEND_INACCESSIBLE , Coded Values: [OVERGROWN: Overgrown] , [FILLED WTIH SEDIMENT OR DEBRIS: Filled with sediment or debris] , [FILLED WITH WATER: Filled with water] , ...19 more... )
• DNEND_COMMENTS ( type: esriFieldTypeString, alias: Down Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DNEND_COMMENTS )
• DNEND_STNDRDCOMMENTS ( type: esriFieldTypeString, alias: Dn Comments List, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DNEND_STNDRDCOMMENTS , Coded Values: [TRASH COLLECTION INSERT: Trash Collection Insert] , [ABANDONED: Abandoned - All Pipes Sealed] , [FILLED WITH SEDIMENT OR DEBRIS: Filled with Sediment or Debris] , ...42 more... )
• MAPDATE ( type: esriFieldTypeDate, alias: Mapping Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAPDATE )
• CONSTR_DATE ( type: esriFieldTypeDate, alias: Construction Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONSTR_DATE )
• CONNECTIVITY ( type: esriFieldTypeString, alias: Connectivity, editable: true, nullable: true, length: 50, defaultValue: OBSERVED, modelName: CONNECTIVITY , Coded Values: [OBSERVED: Observed] , [ASSUMED: Assumed] , [UNKNOWN: Unknown] )
• INVENTORY_STATUS ( type: esriFieldTypeString, alias: Inventory Status, editable: true, nullable: true, length: 50, defaultValue: SEE CONNECTING POINTS, modelName: INVENTORY_STATUS , Coded Values: [DGPS: Differential GPS Located] , [GPS OBSCURED: GPS Located with Obscured View - Low Quality] , [DISTANCE-BEARING OFFSET: Distance - Bearing Offset] , ...6 more... )
• TAG ( type: esriFieldTypeInteger, alias: Tag, editable: true, nullable: true, defaultValue: 0, modelName: TAG )
• Lat ( type: esriFieldTypeDouble, alias: Lat, editable: true, nullable: true, defaultValue: null, modelName: Lat )
• Long ( type: esriFieldTypeDouble, alias: Long, editable: true, nullable: true, defaultValue: null, modelName: Long )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GLOBAL_ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: PIPE
Name: Pipe
Domains:
• PIPE_TYPE:
  Inherited
• UPINVUNRELIABLE:
  Inherited
• DNINVUNRELIABLE:
  Inherited
• PIPE_SHP:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPEDIAMETER:
  Inherited
• NUM_PIPES:
  Inherited
• UPEND_CONDITION:
  Inherited
• UPEND_INACCESSIBLE:
  Inherited
• UPEND_STNDRDCOMMENTS:
  Inherited
• DNEND_CONDITION:
  Inherited
• DNEND_INACCESSIBLE:
  Inherited
• DNEND_STNDRDCOMMENTS:
  Inherited
• CONNECTIVITY:
  Inherited
• INVENTORY_STATUS:
  Inherited
• ATTRIBUTE_DATA_SOURCE:
  Inherited
• SPATIAL_DATA_SOURCE:
  Inherited
• GPS_ID:
  Inherited
• EAMUpCondition:
  Inherited
• EAMDownCondition:
  Inherited
Templates:
• Name: Pipe
  Description:
  Prototype:
  WIDTH: 99
  HEIGHT: 99
  UPEND_CONDITION: SEE CONNECTING POINTS
  MAPDATE: null
  DNINVERTDEPTH: 99
  INVENTORY_STATUS: SEE CONNECTING POINTS
  UPEND_STNDRDCOMMENTS: null
  SUBTYPE_CLASS: null
  CONNECTIVITY: OBSERVED
  PIPEDIAMETER: null
  UPINVUNRELIABLE: NA
  CONSTR_DATE: null
  UPINVERTDEPTH: 99
  DNINVUNRELIABLE: NA
  DNEND_CONDITION: SEE CONNECTING POINTS
  PIPE_TYPE: PIPE
  PIPE_SHP: CIRCULAR
  NUM_PIPES: SINGLE
  Lat: null
  TAG: 0
  Long: null
  PIPEMATERIAL: RCP
  UPEND_INACCESSIBLE: NA
  UPEND_COMMENTS: null
  DNEND_INACCESSIBLE: NA
  DNEND_COMMENTS: null
  DNEND_STNDRDCOMMENTS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: CULVERT
Name: Culvert
Domains:
• PIPE_TYPE:
  Inherited
• UPINVUNRELIABLE:
  Inherited
• DNINVUNRELIABLE:
  Inherited
• PIPE_SHP:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPEDIAMETER:
  Inherited
• NUM_PIPES:
  Inherited
• UPEND_CONDITION:
  Inherited
• UPEND_INACCESSIBLE:
  Inherited
• UPEND_STNDRDCOMMENTS:
  Inherited
• DNEND_CONDITION:
  Inherited
• DNEND_INACCESSIBLE:
  Inherited
• DNEND_STNDRDCOMMENTS:
  Inherited
• CONNECTIVITY:
  Inherited
• INVENTORY_STATUS:
  Inherited
• ATTRIBUTE_DATA_SOURCE:
  Inherited
• SPATIAL_DATA_SOURCE:
  Inherited
• GPS_ID:
  Inherited
• EAMUpCondition:
  Inherited
• EAMDownCondition:
  Inherited
Templates:
• Name: Culvert
  Description:
  Prototype:
  WIDTH: 99
  HEIGHT: 99
  UPEND_CONDITION: SEE CONNECTING POINTS
  MAPDATE: null
  DNINVERTDEPTH: 99
  INVENTORY_STATUS: SEE CONNECTING POINTS
  UPEND_STNDRDCOMMENTS: null
  SUBTYPE_CLASS: null
  CONNECTIVITY: OBSERVED
  PIPEDIAMETER: null
  UPINVUNRELIABLE: NA
  CONSTR_DATE: null
  UPINVERTDEPTH: 99
  DNINVUNRELIABLE: NA
  DNEND_CONDITION: SEE CONNECTING POINTS
  PIPE_TYPE: CULVERT
  PIPE_SHP: CIRCULAR
  NUM_PIPES: SINGLE
  Lat: null
  TAG: 0
  Long: null
  PIPEMATERIAL: RCP
  UPEND_INACCESSIBLE: NA
  UPEND_COMMENTS: null
  DNEND_INACCESSIBLE: NA
  DNEND_COMMENTS: null
  DNEND_STNDRDCOMMENTS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: BRIDGE
Name: Bridge
Domains:
• PIPE_TYPE:
  Inherited
• UPINVUNRELIABLE:
  Inherited
• DNINVUNRELIABLE:
  Inherited
• PIPE_SHP:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPEDIAMETER:
  Inherited
• NUM_PIPES:
  Inherited
• UPEND_CONDITION:
  Inherited
• UPEND_INACCESSIBLE:
  Inherited
• UPEND_STNDRDCOMMENTS:
  Inherited
• DNEND_CONDITION:
  Inherited
• DNEND_INACCESSIBLE:
  Inherited
• DNEND_STNDRDCOMMENTS:
  Inherited
• CONNECTIVITY:
  Inherited
• INVENTORY_STATUS:
  Inherited
• ATTRIBUTE_DATA_SOURCE:
  Inherited
• SPATIAL_DATA_SOURCE:
  Inherited
• GPS_ID:
  Inherited
• EAMUpCondition:
  Inherited
• EAMDownCondition:
  Inherited
Templates:
• Name: Bridge
  Description:
  Prototype:
  WIDTH: 99
  HEIGHT: 99
  UPEND_CONDITION: SEE CONNECTING POINTS
  MAPDATE: null
  DNINVERTDEPTH: 99
  INVENTORY_STATUS: SEE CONNECTING POINTS
  UPEND_STNDRDCOMMENTS: null
  SUBTYPE_CLASS: null
  CONNECTIVITY: OBSERVED
  PIPEDIAMETER: null
  UPINVUNRELIABLE: NA
  CONSTR_DATE: null
  UPINVERTDEPTH: 99
  DNINVUNRELIABLE: NA
  DNEND_CONDITION: SEE CONNECTING POINTS
  PIPE_TYPE: BRIDGE
  PIPE_SHP: CIRCULAR
  NUM_PIPES: SINGLE
  Lat: null
  TAG: 0
  Long: null
  PIPEMATERIAL: RCP
  UPEND_INACCESSIBLE: NA
  UPEND_COMMENTS: null
  DNEND_INACCESSIBLE: NA
  DNEND_COMMENTS: null
  DNEND_STNDRDCOMMENTS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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 Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata