Name: Pipe

Display Field: PIPEDIAMETER

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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.</SPAN></P><P STYLE="margin:7 0 7 0;"><SPAN /></P><P><SPAN /></P></DIV></DIV></DIV>

Service Item Id: 5fcf2d7629324109ba5800bf88e0fe62

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: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 18000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: 9
• Value: CULVERT
  Label: Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 9
• Value: BRIDGE
  Label: Bridge
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIAMETER] CONCAT "''"
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [PIPEDIAMETER] CONCAT "''" CONCAT NEWLINE CONCAT [NUM_PIPES]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [WIDTH] CONCAT "' X " CONCAT [HEIGHT] CONCAT "'" CONCAT NEWLINE CONCAT [NUM_PIPES]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIAMETER] CONCAT "''"
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: "NULL"
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.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: false
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SUBTYPE_CLASS ( type: esriFieldTypeSmallInteger, alias: SubType Class )
• PIPE_TYPE ( type: esriFieldTypeString, alias: Pipe Type, length: 50 , Coded Values: [PIPE: Pipe] , [CULVERT: Culvert] , [BRIDGE: Bridge] )
• UPINVERTDEPTH ( type: esriFieldTypeDouble, alias: Up Depth )
• UPINVUNRELIABLE ( type: esriFieldTypeString, alias: Up Unreliable, length: 50 , 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 )
• DNINVUNRELIABLE ( type: esriFieldTypeString, alias: Down Unreliable, length: 50 , 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, length: 50 , Coded Values: [CIRCULAR: Circular] , [ARCHED: Arched] , [ELLIPTICAL: Elliptical] , ...2 more... )
• PIPEMATERIAL ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [RCP: Reinforced Concrete] , [CMP: Corrugated Metal] , [CPP: Corrugated Plastic] , ...9 more... )
• PIPEDIAMETER ( type: esriFieldTypeString, alias: Diameter, length: 50 , Coded Values: [10: 10] , [12: 12] , [15: 15] , ...25 more... )
• HEIGHT ( type: esriFieldTypeDouble, alias: Height )
• WIDTH ( type: esriFieldTypeDouble, alias: Width )
• NUM_PIPES ( type: esriFieldTypeString, alias: Number of Pipes, length: 50 , Coded Values: [SINGLE: Single] , [DOUBLE: Double] , [TRIPLE: Triple] , ...3 more... )
• UPEND_CONDITION ( type: esriFieldTypeString, alias: Up End Cond., length: 50 , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...8 more... )
• UPEND_INACCESSIBLE ( type: esriFieldTypeString, alias: Up Inaccess., length: 50 , 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, length: 254 )
• UPEND_STNDRDCOMMENTS ( type: esriFieldTypeString, alias: Up Comments List, length: 254 , 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., length: 50 , Coded Values: [GOOD: Good] , [FAIR: Fair] , [POOR: Poor] , ...8 more... )
• DNEND_INACCESSIBLE ( type: esriFieldTypeString, alias: Down Inaccess., length: 50 , 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, length: 254 )
• DNEND_STNDRDCOMMENTS ( type: esriFieldTypeString, alias: Dn Comments List, length: 254 , 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, length: 8 )
• CONSTR_DATE ( type: esriFieldTypeDate, alias: Construction Date, length: 8 )
• CONNECTIVITY ( type: esriFieldTypeString, alias: Connectivity, length: 50 , Coded Values: [OBSERVED: Observed] , [ASSUMED: Assumed] , [UNKNOWN: Unknown] )
• INVENTORY_STATUS ( type: esriFieldTypeString, alias: Inventory Status, length: 50 , Coded Values: [DGPS: Differential GPS Located] , [GPS OBSCURED: GPS Located with Obscured View - Low Quality] , [DISTANCE-BEARING OFFSET: Distance - Bearing Offset] , ...6 more... )
• ATTRIBUTE_DATA_SOURCE ( type: esriFieldTypeString, alias: Attribute Source, length: 100 , Coded Values: [OBSERVED BUT SUPPLEMENTED BY HAZEN AND SAWYER INVENTORY DATA: Observed but Supplemented by Hazen-Sawyer Inventory Data] , [OBSERVED BUT SUPPLEMENTED BY DEWBERRY INVENTORY DATA: Observed but Supplemented by Dewberry Inventory] , [OBSERVED BUT SUPPLEMENTED BY AS-BUILT OR OTHER PLAN DRAWINGS: Observed but Supplemented by As-Built of Other Plan Drawings] , ...9 more... )
• SPATIAL_DATA_SOURCE ( type: esriFieldTypeString, alias: Spatial Source, length: 100 , Coded Values: [ASSUMED - HAZEN AND SAWYER INVENTORY: Assumed - Hazen and Sawyer Inventory] , [ASSUMED - DEWBERRY AND DAVIS INVENTORY: Assumed - Dewberry and Davis Inventory] , [ASSUMED - AS-BUILT OR OTHER PLAN DRAWINGS: Assumed - As-Built or Other Plan Drawings] , ...7 more... )
• TAG_DEWBERRY ( type: esriFieldTypeInteger, alias: Source Tag )
• GPS_ID ( type: esriFieldTypeString, alias: GPS Unit ID, length: 50 , Coded Values: [ProXR0220208195: ProXR0220208195] , [GRS1_599-0076: GRS1_599-0076] , [GRX1_673-01187: GRX1_673-01187] , ...3 more... )
• STORM_ID ( type: esriFieldTypeString, alias: StormID, length: 100 )
• TAG ( type: esriFieldTypeInteger, alias: Tag )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Lat ( type: esriFieldTypeDouble, alias: Lat )
• Long ( type: esriFieldTypeDouble, alias: Long )
• EAMID ( type: esriFieldTypeString, alias: EAMID, length: 15 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• EAMDescription ( type: esriFieldTypeString, alias: EAMDescription, length: 50 )
• UPEndStID ( type: esriFieldTypeString, alias: UPEndStID, length: 15 )
• DNEndStID ( type: esriFieldTypeString, alias: DNEndStID, length: 15 )
• SHAPE.len ( type: esriFieldTypeDouble, alias: SHAPE.len )
• EAMComments ( type: esriFieldTypeString, alias: EAMComments, length: 200 )
• EAMUpCondition ( type: esriFieldTypeString, alias: EAMUpCondition, length: 50 , Coded Values: [GOOD: GOOD] , [FAIR: FAIR] , [POOR: POOR] , ...8 more... )
• EAMDownCondition ( type: esriFieldTypeString, alias: EAMDownCondition, length: 50 , Coded Values: [GOOD: GOOD] , [FAIR: FAIR] , [POOR: POOR] , ...8 more... )
• InhouseMaintType ( type: esriFieldTypeString, alias: InhouseMaintType, length: 50 )
• InhouseMaintDate ( type: esriFieldTypeDate, alias: InhouseMaintDate, length: 8 )
• InhouseMaintNotes ( type: esriFieldTypeString, alias: InhouseMaintNotes, length: 100 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata