Layer: Water Pipe Potable (ID:0)

View In: Map Viewer

Name: Water Pipe Potable

Display Field: sapobjectid

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

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[50,57,146,255],"width":1.5}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: true

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)
SAPOBJECTID (type: esriFieldTypeString, alias: SAP Object ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
CLASS (type: esriFieldTypeString, alias: Class, SQL Type: sqlTypeOther, length: 18, nullable: false, editable: true)
GIS_USER_STATUS (type: esriFieldTypeString, alias: User Status, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
OBJECT_TYPE (type: esriFieldTypeString, alias: Object Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
GIS_SYSTEM_STATUS (type: esriFieldTypeString, alias: System Status, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
WATER_CATEGORY (type: esriFieldTypeString, alias: Water Category, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [POTABLE: Potable], [NON-DRINKING: Potable Wtr in purple A+ pipe], [RECYCLED A: Rec water pipes-class A water], ... 1 more ...)
WATER_PIPE_USE (type: esriFieldTypeString, alias: Pipe Usage, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [RETICULATION: Reticulation Pipe (Default)], [TRUNK: Trunk Water Main], [CONDUIT: Service Conduit], ... 3 more ...)
WATER_PIPE_CLASS (type: esriFieldTypeString, alias: Pipe Class, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [SN5000: SN5000], [SN8000: SN8000], [SN10000: SN10000], ... 36 more ...)
WATER_PIPE_MATERIAL (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [CI: Cast Iron], [CONC: Concrete], [DI: Ductile Iron], ... 18 more ...)
WATER_PIPE_LINING (type: esriFieldTypeString, alias: Pipe Lining, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [FBC: Fusion Bonded Coated], [CL: Cement Lined - Normal], [CL_SR: Cement Ln - Sulphate Resistant], ... 6 more ...)
WATER_PIPE_PROTECTION (type: esriFieldTypeString, alias: Pipe Protection, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [TBA: TBA], [FBC: Fusion Bonded Coated], [FBE: Fusion Bonded Epoxy], ... 11 more ...)
WATER_PIPE_EMBEDMENT (type: esriFieldTypeString, alias: Pipe Embedment, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [TYPE A: WSAA - Type A], [TYPE B: WSAA - Type B], [TYPE C: WSAA - Type C], ... 21 more ...)
ALIGNMENT_M (type: esriFieldTypeDouble, alias: Alignment (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
DIAMETER_MM (type: esriFieldTypeDouble, alias: Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
JOINT_TYPE (type: esriFieldTypeString, alias: Joint Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [TBA: TBA], [RR: Rubber Ring - Default Value], [SWJ: Solvent Welded Joint (PVC)], ... 7 more ...)
GRADIENT (type: esriFieldTypeDouble, alias: Gradient, SQL Type: sqlTypeOther, nullable: true, editable: true)
DEPTH_M (type: esriFieldTypeDouble, alias: Depth (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
LENGTH_M (type: esriFieldTypeDouble, alias: Length (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
RELINING_MATERIAL (type: esriFieldTypeString, alias: Relining Material, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [CONCRETE: Concrete], [CURED IN-PLACE PIPE: Cured in-place pipe], [POLY VINYL CHLORIDE: Poly Vinyl Chloride], ... 7 more ...)
RELINING_LENGTH_M (type: esriFieldTypeDouble, alias: Relining Length (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
RELINING_DATE (type: esriFieldTypeDate, alias: Relining Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
FROM_SAPID (type: esriFieldTypeString, alias: From SAP ID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
TO_SAPID (type: esriFieldTypeString, alias: To SAP ID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
FUNCTIONAL_LOC (type: esriFieldTypeString, alias: Functional Location, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SUPERORD_EQUIP (type: esriFieldTypeString, alias: Superordinate Equipment, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
GIS_DESCRIPTION (type: esriFieldTypeString, alias: GIS Description, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
RELINING_INTERNAL_DIAMETER_MM (type: esriFieldTypeDouble, alias: Relining Internal Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
GCW_JOINT_TYPE (type: esriFieldTypeString, alias: GCW Joint Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [RR: Rubber Ring - Default Value], [SWJ: Solvent Welded Joint (PVC)], [WJ: Welded Joint (Mild Steel Pipe)], ... 5 more ...)
Shape__Length (type: esriFieldTypeDouble, alias: Geometric Length (m), SQL Type: sqlTypeDouble, nullable: true, editable: true)

Templates:

CLASS: WATER_PIPE
OBJECT_TYPE: WTPP
GIS_EQUIPMENT_CATEGORY: W
RE_ENRICH: NO

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/10/2026 11:36:54 PM

Schema Last Edit Date: 5/10/2026 11:26:59 PM

Data Last Edit Date: 5/10/2026 11:36:54 PM

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