Layer: SWInlets_Local (ID:2)

View In: Map Viewer

Name: SWInlets_Local

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Closed-System stormwater drainage structures (inlets, manholes, junctions, etc.) that connect stormwater pipes.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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"29a328582da7ab7e72183964de16acec","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABXUlEQVQokaWTP0gCARSHv+GgwiQiwqyhP4JQBIGY4ORe2BANQUtFmK3RXkI0t5nhELRF20Vr2CJk3qgUoi11SUjEUbgVz+4OqTshessN976P937vTuEfpXR4FwcSwCbw9Bc43jNMRunDMMrcAmEngeIGjq2Tm9jiXksS01VngeIGegK8XUVZi5xy1u3DqGV5NAVFJ9gGvZO8VtPMNusM3qyyFDnhXBpqWXuCYjv8C/QEeDHuMEYWKViC/gi6lmgJFgDVgjNDcxRlx/cKHgGnDyg8XxIOblPq8vEhTf559IEoWiPfuoIN79WyZMQsDQK2BzG6woM8tSSxRp5P83z22Meyh4w0vsHFVArt5wlKu4R0lV4gZaXeHpiEEDZDQQQzh99BVdMEa1n8Jqi6ncoSqM063tAROQHL+yxbIXW6sy2QD+O6gt8oE3QC3WAp2SlslMkAO05gJ9gSyM/hWl8kXoXACbyocQAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

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)
StrctType (type: esriFieldTypeString, alias: StructureType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Catch Basin: Catch Basin], [Drop Inlet: Drop Inlet], [Curb Inlet: Curb Inlet], ... 4 more ...)
StrctLoc (type: esriFieldTypeString, alias: StructureLocation, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Street: Street], [Parking Area: Parking Area], [Walkway: Walkway / Patio], ... 5 more ...)
IsAccsble (type: esriFieldTypeString, alias: IsAccessible, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable], ... 1 more ...)
IsFunctng (type: esriFieldTypeString, alias: IsFunctioning, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable], ... 1 more ...)
StrctCndn (type: esriFieldTypeString, alias: FunctionalCondition, 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: ConditionIssue, 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 ...)
IsConfSpc (type: esriFieldTypeString, alias: IsConfinedSpace, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable], ... 1 more ...)
StrctMatrl (type: esriFieldTypeString, alias: StructureMaterial, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Concrete: Conrete], [Brick: Brick], [Plastic: Plastic], ... 3 more ...)
StrctShape (type: esriFieldTypeString, alias: StructureShape, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Rectangular: Rectangular], [Round: Round], [Other: Other], ... 1 more ...)
HasSteps (type: esriFieldTypeString, alias: HasSteps, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable], ... 1 more ...)
Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
RefElev (type: esriFieldTypeDouble, alias: ReferenceElevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
RefDepth (type: esriFieldTypeDouble, alias: Depth(ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
Invert (type: esriFieldTypeDouble, alias: Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
NumGrates (type: esriFieldTypeSmallInteger, alias: NumberGrates, SQL Type: sqlTypeOther, nullable: true, editable: true)
GrateLen (type: esriFieldTypeDouble, alias: GrateLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
GrateWdth (type: esriFieldTypeDouble, alias: GrateWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
NumThroats (type: esriFieldTypeSmallInteger, alias: NumberThroats, SQL Type: sqlTypeOther, nullable: true, editable: true)
ThroatHght (type: esriFieldTypeDouble, alias: ThroatHeight, SQL Type: sqlTypeOther, nullable: true, editable: true)
ThroatWdth (type: esriFieldTypeDouble, alias: ThroatWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
DtAssessed (type: esriFieldTypeDate, alias: DateAssessed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
AsmntCmnts (type: esriFieldTypeString, alias: AssessmentComments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
HPosAccrcy (type: esriFieldTypeString, alias: HorizontalAccuracy, 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: VerticalAccuracy, 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: DataSource, 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: ProjectNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
YrInstall (type: esriFieldTypeSmallInteger, alias: YearInstalled, SQL Type: sqlTypeOther, nullable: true, editable: true)
YrDiscnt (type: esriFieldTypeSmallInteger, alias: YearDiscontinued, SQL Type: sqlTypeOther, nullable: true, editable: true)
YrsService (type: esriFieldTypeSmallInteger, alias: YearsInService, SQL Type: sqlTypeOther, nullable: true, editable: true)
YrsLifeCyc (type: esriFieldTypeSmallInteger, alias: YearsServiceLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
YrRplcmnt (type: esriFieldTypeSmallInteger, alias: ReplacementYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
CstInstall (type: esriFieldTypeInteger, alias: InstallationCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
CstRplcmnt (type: esriFieldTypeInteger, alias: ReplacementCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
HyplnkPath (type: esriFieldTypeString, alias: HyperlinkPath, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
HyplnkFile (type: esriFieldTypeString, alias: HyperlinkFile, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
NumCnctns (type: esriFieldTypeSmallInteger, alias: NumConnectedPipes, SQL Type: sqlTypeOther, 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)
AddlPipes (type: esriFieldTypeString, alias: AddlPipes, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
AsmntBy (type: esriFieldTypeString, alias: AsmntBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/24/2025 12:42:43 PM

Schema Last Edit Date: 6/24/2025 12:42:43 PM

Data Last Edit Date: 6/24/2025 12:42:43 PM

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