Name: Maintenance Pipes

Display Field: CountyName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

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: -84.4207032016104
YMin: 33.7618187816193
XMax: -75.4217435560486
YMax: 36.6143990737152
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[168,0,0,255],"width":3.75,"type":"esriSLS","style":"esriSLSSolid"}},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PermId (type: esriFieldTypeInteger, alias: Permanent ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeId (type: esriFieldTypeString, alias: Pipe ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Division (type: esriFieldTypeSmallInteger, alias: Division, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 14])
• CountyName (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Alamance: Alamance], [Alexander: Alexander], [Alleghany: Alleghany], ... 97 more ...)
• MaintSctn (type: esriFieldTypeSmallInteger, alias: Maintenance Section, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
• RouteSystem (type: esriFieldTypeString, alias: Route System, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Interstate: Interstate], [Primary: Primary], [Secondary: Secondary])
• RouteClass (type: esriFieldTypeSmallInteger, alias: Route Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Interstate], [2: US Route], [3: NC Route], ... 3 more ...)
• RouteQualifier (type: esriFieldTypeSmallInteger, alias: Route Qualifier, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Alternate], [2: Bypass], ... 5 more ...)
• RouteNumber (type: esriFieldTypeInteger, alias: Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 9999])
• RouteInventory (type: esriFieldTypeSmallInteger, alias: Route Inventory, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Inventory], [4: Southbound], [6: Westbound], ... 2 more ...)
• RouteName (type: esriFieldTypeString, alias: Route Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RouteId (type: esriFieldTypeString, alias: RouteID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Milepost (type: esriFieldTypeDouble, alias: Milepost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InLatitude (type: esriFieldTypeDouble, alias: Inlet Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InLongitude (type: esriFieldTypeDouble, alias: Inlet Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutLatitude (type: esriFieldTypeDouble, alias: Outlet Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutLongitude (type: esriFieldTypeDouble, alias: Outlet Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeType (type: esriFieldTypeString, alias: Pipe Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [Concrete: Concrete], [CMP: CMP], [Aluminum: Aluminum], ... 5 more ...)
• PipeLiner (type: esriFieldTypeString, alias: Pipe Liner, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [None: None], [Spincast: Spincast], [Plastic Sliplining: Plastic Sliplining], ... 4 more ...)
• DrainageSystem (type: esriFieldTypeString, alias: Drainage System, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Both Ends Open: Both Ends Open], [Closed System at Inlet: Closed System at Inlet], [Closed System at Outlet: Closed System at Outlet], ... 2 more ...)
• PipeSize (type: esriFieldTypeString, alias: Pipe Size Inches, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [12: 12], [15: 15], [18: 18], ... 7 more ...)
• BrlCount (type: esriFieldTypeString, alias: Barrel Count, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 4 more ...)
• InCrwnToBed (type: esriFieldTypeString, alias: Inlet Crown to Bed Feet, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2: 2], [2.5: 2.5], [3: 3], ... 9 more ...)
• OutCrwnToBed (type: esriFieldTypeString, alias: Outlet Crown to Bed Feet, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [2: 2], [2.5: 2.5], [3: 3], ... 9 more ...)
• Skew (type: esriFieldTypeString, alias: Pipe Skew, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• LengthFeet (type: esriFieldTypeDouble, alias: Length Feet, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [10 - 20000])
• YearBuilt (type: esriFieldTypeSmallInteger, alias: Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1900 - 2050])
• LocIssue (type: esriFieldTypeString, alias: Location Issue, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [None: None], [Outlet Not Accessible: Outlet Not Accessible], [Outlet Not Found: Outlet Not Found], ... 3 more ...)
• AssmtDate (type: esriFieldTypeDate, alias: Assessment Date, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• AssmtInitials (type: esriFieldTypeString, alias: Assessment Initials, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• AssmtYear (type: esriFieldTypeSmallInteger, alias: Last Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1900 - 2050])
• CreationDateHold (type: esriFieldTypeDate, alias: Create Date Hold, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EditDateHold (type: esriFieldTypeDate, alias: Last Edit Date Hold, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FtrDescription (type: esriFieldTypeString, alias: Material and Type Description, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: MaintenancePipes
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Relationships:

• MaintenancePipeHistorical (0) -- Related To: Maintenance Pipe Historical (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2025 6:54:39 PM

Schema Last Edit Date: 7/23/2025 11:39:49 AM

Data Last Edit Date: 7/23/2025 6:54:39 PM

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