Name: PipeMain_test

Display Field: AssetID

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: -8621894.7586
YMin: 4514160.0415
XMax: -8616115.6496
YMax: 4517301.0622
Spatial Reference: 102100 (3857)

Drawing Info:

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

HasZ: true

HasM: true

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Enabled (type: esriFieldTypeInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBARREL (type: esriFieldTypeDouble, alias: NUMBARREL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [RCP: RCP], [CMP: CMP], [HDPE: HDPE], ... 4 more ...)
• FEAT_TYPE (type: esriFieldTypeString, alias: FEAT_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private], [NCDOT: DOT])
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Inspection (type: esriFieldTypeString, alias: Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Dylan Kirk: Dylan Kirk ], [Ike Archer: Ike Archer], [Gavan Nicholson: Gavan Nicholson ])
• Comments_Workorder_s (type: esriFieldTypeString, alias: Comments / Workorder #s, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Sediment_Debris_Accumulation (type: esriFieldTypeString, alias: Sediment & Debris Accumulation , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [n/a: 0], [Minor: 1], [Moderate : 2], ... 1 more ...)
• IDDE (type: esriFieldTypeString, alias: IDDE, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Unlikely: 0], [Potential: 1], [Suspect: 2], ... 1 more ...)
• Mainteance_Concerns (type: esriFieldTypeString, alias: Maintenance Concerns, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [n/a: 0], [Minor: 1], [Moderate: 2], ... 1 more ...)
• Install_yr (type: esriFieldTypeInteger, alias: Install_yr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Diameter (type: esriFieldTypeInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ConditionOverall (type: esriFieldTypeSmallInteger, alias: Condition Overall, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Good], [2: 2. Fair], [3: 3. Poor], ... 1 more ...)
• AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Blockage (type: esriFieldTypeSmallInteger, alias: Blockage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Good], [2: 2. Fair], [3: 3. Poor], ... 1 more ...)
• Cracking (type: esriFieldTypeSmallInteger, alias: Cracking, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Good], [2: 2. Fair], [3: 3. Poor], ... 1 more ...)
• Corrosion (type: esriFieldTypeSmallInteger, alias: Corrosion, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Good], [2: 2. Fair], [3: 3. Poor], ... 1 more ...)
• PipeDistortion (type: esriFieldTypeSmallInteger, alias: Pipe Distortion, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Good], [2: 2. Fair], [3: 3. Poor], ... 1 more ...)
• Joints (type: esriFieldTypeSmallInteger, alias: Joints, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Good], [2: 2. Fair], [3: 3. Poor], ... 1 more ...)
• last_inspector (type: esriFieldTypeString, alias: Last Inspector, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_inspectionid (type: esriFieldTypeString, alias: Last Inspection ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_inspectiondate (type: esriFieldTypeDate, alias: Last Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_comment (type: esriFieldTypeString, alias: Last Comment Provided, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_observable (type: esriFieldTypeString, alias: Observable as of the last inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• AssetType (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: PipeMain_test
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FEAT_TYPE: MAIN -
• AssetType: PipeMain

Relationships:

• View Inspections (0) -- Related To: Inspections_test (100)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/1/2026 7:30:23 PM

Schema Last Edit Date: 6/10/2026 12:43:42 PM

Data Last Edit Date: 7/1/2026 7:30:23 PM

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