View In:   ArcGIS Online Map Viewer

Name: Pipe Inlet-Outlet

Display Field: IO_STRUCURE_TYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Feature class StormwaterPipeIO stores geometry and attributes of constructed pipe end features within the City of Wilmington; the dataset provides information about location and type of inlet/outlet structures associated with closed system stormwater conveyance features. 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: 2315794.8399535567
YMin: 140052.86707022786
XMax: 2360832.577633798
YMax: 189709.4117858112
Spatial Reference: 103122  (6543)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PIPE_IO_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: PIPE INLET
  Label: Pipe Inlet
  Description: N/A
  Symbol:
  
• Value: PIPE OUTLET
  Label: Pipe Outlet
  Description: N/A
  Symbol:
  
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_IO_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_IO_TYPE ( type: esriFieldTypeString, alias: Pipe Inlet-Outlet Feature Type, editable: true, nullable: true, length: 50, defaultValue: PIPE OUTLET, modelName: PIPE_IO_TYPE , Coded Values: [PIPE INLET: Pipe Inlet] , [PIPE OUTLET: Pipe Outlet] , [OTHER: Other] , ...1 more... )
• IO_STRUCURE_TYPE ( type: esriFieldTypeString, alias: Inlet-Outlet Structure Type, editable: true, nullable: true, length: 50, defaultValue: PROJECTED FROM FILL, modelName: IO_STRUCURE_TYPE , Coded Values: [HEAD-ENDWALL: Headwall/Endwall] , [PROJECTED FROM FILL: Projected from Fill] , [MITERED: Mitered] , ...6 more... )
• PIPE_MATERIAL ( type: esriFieldTypeString, alias: Pipe Material, editable: true, nullable: true, length: 50, defaultValue: RCP, modelName: PIPE_MATERIAL , Coded Values: [RCP: Reinforced Concrete] , [CMP: Corrugated Metal] , [CPP: Corrugated Plastic] , ...9 more... )
• PIPE_DIAMETER ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIPE_DIAMETER , 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-Culverts, editable: true, nullable: true, length: 50, defaultValue: SINGLE, modelName: NUM_PIPES , Coded Values: [SINGLE: Single] , [DOUBLE: Double] , [TRIPLE: Triple] , ...3 more... )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: GOOD, modelName: CONDITION , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...8 more... )
• INACCESSIBLE ( type: esriFieldTypeString, alias: Inaccessible Reason, editable: true, nullable: true, length: 50, defaultValue: NA, modelName: INACCESSIBLE , Coded Values: [OVERGROWN: Overgrown] , [FILLED WTIH SEDIMENT OR DEBRIS: Filled with sediment or debris] , [FILLED WITH WATER: Filled with water] , ...19 more... )
• DRY_FLOW ( type: esriFieldTypeString, alias: Dry Flow?, editable: true, nullable: true, length: 50, defaultValue: NO, modelName: DRY_FLOW , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] )
• NPDES ( type: esriFieldTypeString, alias: NPDES Point, editable: true, nullable: true, length: 50, defaultValue: NOT MONITORED, modelName: NPDES , Coded Values: [UNKNOWN: Unknown] , [NPDES OUTFALL: NPDES Outfall verified] , [NPDES INDUSTRIAL: NPDES Industrial Outfall verified] , ...4 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENTS )
• STANDARD_COMMENTS ( type: esriFieldTypeString, alias: Standard Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STANDARD_COMMENTS , 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... )
• 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: VRS_RTK, 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 INLET
Name: Pipe Inlet
Domains:
• PIPE_IO_TYPE:
  Inherited
• IO_STRUCURE_TYPE:
  Inherited
• PIPE_MATERIAL:
  Inherited
• PIPE_DIAMETER:
  Inherited
• NUM_PIPES:
  Inherited
• CONDITION:
  Inherited
• INACCESSIBLE:
  Inherited
• DRY_FLOW:
  Inherited
• NPDES:
  Inherited
• STANDARD_COMMENTS:
  Inherited
• CONNECTIVITY:
  Inherited
• INVENTORY_STATUS:
  Inherited
• PHOTO:
  Inherited
• ATTIBUTE_DATA_SOURCE:
  Inherited
• SPATIAL_DATA_SOURCE:
  Inherited
• GPS_ID:
  Inherited
• EAMInaccessible:
  Inherited
• EAMIOStructureType:
  Inherited
• EAMCondition:
  Inherited
• EAMNPDES:
  Inherited
Templates:
• Name: Pipe Inlet
  Description:
  Prototype:
  WIDTH: 99
  HEIGHT: 99
  NPDES: NOT MONITORED
  INVENTORY_STATUS: VRS_RTK
  Lat: null
  PIPE_IO_TYPE: PIPE INLET
  CONNECTIVITY: OBSERVED
  NUM_PIPES: SINGLE
  PIPE_DIAMETER: null
  STANDARD_COMMENTS: null
  DRY_FLOW: NO
  CONDITION: GOOD
  IO_STRUCURE_TYPE: PROJECTED FROM FILL
  COMMENTS: null
  INACCESSIBLE: NA
  SUBTYPE_CLASS: null
  TAG: 0
  Long: null
  PIPE_MATERIAL: RCP
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: PIPE OUTLET
Name: Pipe Outlet
Domains:
• PIPE_IO_TYPE:
  Inherited
• IO_STRUCURE_TYPE:
  Inherited
• PIPE_MATERIAL:
  Inherited
• PIPE_DIAMETER:
  Inherited
• NUM_PIPES:
  Inherited
• CONDITION:
  Inherited
• INACCESSIBLE:
  Inherited
• DRY_FLOW:
  Inherited
• NPDES:
  Inherited
• STANDARD_COMMENTS:
  Inherited
• CONNECTIVITY:
  Inherited
• INVENTORY_STATUS:
  Inherited
• PHOTO:
  Inherited
• ATTIBUTE_DATA_SOURCE:
  Inherited
• SPATIAL_DATA_SOURCE:
  Inherited
• GPS_ID:
  Inherited
• EAMInaccessible:
  Inherited
• EAMIOStructureType:
  Inherited
• EAMCondition:
  Inherited
• EAMNPDES:
  Inherited
Templates:
• Name: Pipe Outlet
  Description:
  Prototype:
  WIDTH: 99
  HEIGHT: 99
  NPDES: NOT MONITORED
  INVENTORY_STATUS: VRS_RTK
  Lat: null
  PIPE_IO_TYPE: PIPE OUTLET
  CONNECTIVITY: OBSERVED
  NUM_PIPES: SINGLE
  PIPE_DIAMETER: null
  STANDARD_COMMENTS: null
  DRY_FLOW: NO
  CONDITION: GOOD
  IO_STRUCURE_TYPE: PROJECTED FROM FILL
  COMMENTS: null
  INACCESSIBLE: NA
  SUBTYPE_CLASS: null
  TAG: 0
  Long: null
  PIPE_MATERIAL: RCP
  
  Drawing Tool: esriFeatureEditToolPoint

---

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