Name: SWPipes_Local

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The stormwater pipes later includes all the available stormwater pipes including pipes that are not in-use. The data in this layer includes the pipe slope, upstream and downstream inverts of the pipe and the respective manholes. Feature class developed in May 2018 under Task Order #9 – Enterprise GIS – Utilities (Stormwater Pilot – Phase 2). NCSU Project# 201722020

Copyright Text: ESP Associates, Inc. Neal Banerjee, PE, CFM (Project Manager) 803-835-0890

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2081025.86756331
YMin: 716303.261811227
XMax: 2100475.63378181
YMax: 756996.729964808
Spatial Reference: 102719 (2264)
Vertical Spatial Reference: 105703 (6360)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2}},"scaleSymbols":true,"transparency":50,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• USFeatID (type: esriFieldTypeString, alias: USFeatID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DSFeatID (type: esriFieldTypeString, alias: DSFeatID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PipeType (type: esriFieldTypeString, alias: PipeType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Pipe System: Pipe System], [Culvert: Culvert], [Assumed: Assumed], ... 1 more ...)
• PipeShape (type: esriFieldTypeString, alias: PipeShape, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Round: Round], [Rectangular: Rectangular], [Arch: Arch], ... 3 more ...)
• PipeMatrl (type: esriFieldTypeString, alias: PipeMatrl, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [RCP: Concrete], [CMP: Corrugated Metal], [CPP: Corrugated Plastic], ... 7 more ...)
• PipeWidth (type: esriFieldTypeDouble, alias: PipeWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeHght (type: esriFieldTypeDouble, alias: PipeHght, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsFunctng (type: esriFieldTypeString, alias: IsFunctng, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable], ... 1 more ...)
• PipeCndn (type: esriFieldTypeString, alias: PipeCndn, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Good: Good - No Issues], [Fair: Fair - Needs Minor Maintenance], [Poor: Poor - Needs Maintenance], ... 5 more ...)
• CndtnIssue (type: esriFieldTypeString, alias: CndtnIssue, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Obstruction: Obstruction], [Minor Structural Issue: Minor Structural Issue (e.g. cracking)], [Major Structural Issue: Major Structural Issue (e.g. crushed)], ... 5 more ...)
• USRefDepth (type: esriFieldTypeDouble, alias: USRefDepth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DSRefDpth (type: esriFieldTypeDouble, alias: DSRefDpth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USInvert (type: esriFieldTypeDouble, alias: USInvert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DSInv (type: esriFieldTypeDouble, alias: DSInv, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DtAssessed (type: esriFieldTypeDate, alias: DtAssessed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AsmntCmnts (type: esriFieldTypeString, alias: AsmntCmnts, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• HPosAccrcy (type: esriFieldTypeString, alias: HPosAccrcy, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Survey Grade: Survey Grade (subfoot)], [Mapping Grade: Mapping Grade (submeter)], [Aerial/Topo Derived: Aerial / Topo Derived], ... 3 more ...)
• VPosAccrcy (type: esriFieldTypeString, alias: VPosAccrcy, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Survey Grade: Survey Grade (subfoot)], [Mapping Grade: Mapping Grade (submeter)], [Aerial/Topo Derived: Aerial / Topo Derived], ... 3 more ...)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NCSU: NCSU], [NCDOT: NCDOT], [City: City], ... 7 more ...)
• MaintainBy (type: esriFieldTypeString, alias: MaintainBy, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NCSU: NCSU], [NCDOT: NCDOT], [City: City], ... 7 more ...)
• DataSrc (type: esriFieldTypeString, alias: DataSrc, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• SourceID (type: esriFieldTypeString, alias: SourceID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• IsEnabled (type: esriFieldTypeString, alias: IsEnabled, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable], ... 1 more ...)
• SCMID (type: esriFieldTypeString, alias: SCMID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PrjNo (type: esriFieldTypeString, alias: PrjNo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YrInstall (type: esriFieldTypeSmallInteger, alias: YrInstall, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YrDiscnt (type: esriFieldTypeSmallInteger, alias: YrDiscnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YrsService (type: esriFieldTypeSmallInteger, alias: YrsService, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YrsLifeCyc (type: esriFieldTypeSmallInteger, alias: YrsLifeCyc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YrRplcmnt (type: esriFieldTypeSmallInteger, alias: YrRplcmnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CstInstall (type: esriFieldTypeInteger, alias: CstInstall, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CstRplcmnt (type: esriFieldTypeInteger, alias: CstRplcmnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HasCCTV (type: esriFieldTypeString, alias: HasCCTV, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable], ... 1 more ...)
• DtCleaned (type: esriFieldTypeDate, alias: DtCleaned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• HyplnkPath (type: esriFieldTypeString, alias: HyplnkPath, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• HyplnkFile (type: esriFieldTypeString, alias: HyplnkFile, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreatedDt (type: esriFieldTypeDate, alias: CreatedDt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastEditBy (type: esriFieldTypeString, alias: LastEditBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LastEditDt (type: esriFieldTypeDate, alias: LastEditDt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DRAWINGLINK (type: esriFieldTypeString, alias: Drawing Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IsAccessible (type: esriFieldTypeString, alias: IsAccessible, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AsmntBy (type: esriFieldTypeString, alias: AsmntBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: SWPipes_Local
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/24/2025 12:24:04 PM

Schema Last Edit Date: 6/24/2025 12:24:04 PM

Data Last Edit Date: 6/24/2025 12:24:04 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat