Layer: Water Mains (ID:0)

View In: Map Viewer

Name: Water Mains

Display Field: WATMAINID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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:

Drawing Info:

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

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)
WATMAINID (type: esriFieldTypeInteger, alias: WATMAINID, SQL Type: sqlTypeOther, nullable: true, editable: true)
STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ACTIVE: ACTIVE], [ABANDONED: ABANDONED], [UNKNOWN: UNKNOWN])
PRESSURE_ZONE (type: esriFieldTypeString, alias: PRESSURE_ZONE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [BRESLAU NORTH: BRESLAU NORTH], [BRESLAU SOUTH: BRESLAU SOUTH], [BRIDGEPORT: BRIDGEPORT], ... 14 more ...)
ROADSEGMENTID (type: esriFieldTypeInteger, alias: ROADSEGMENTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAP_LABEL (type: esriFieldTypeString, alias: MAP_LABEL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CATEGORY (type: esriFieldTypeString, alias: CATEGORY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [TREATED: TREATED], [UNTREATED: UNTREATED], [UNKNOWN: UNKNOWN])
PIPE_SIZE (type: esriFieldTypeInteger, alias: PIPE_SIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [19: 19], [25: 25], [38: 38], ... 15 more ...)
MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AC: AC - ASBESTOS CEMENT], [CI: CI - CAST IRON], [COP: COP - COPPER], ... 10 more ...)
LINED (type: esriFieldTypeString, alias: LINED, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [UNKNOWN: UNKNOWN])
LINED_DATE (type: esriFieldTypeDate, alias: LINED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LINED_MATERIAL (type: esriFieldTypeString, alias: LINED_MATERIAL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CEMENT: CEMENT], [EPS: EPS - EPOXY STRUCTURAL], [HDPE: HDPE - HIGH DENSITY POLYETHYLENE], ... 1 more ...)
INSTALLATION_DATE (type: esriFieldTypeDate, alias: INSTALLATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ACQUISITION (type: esriFieldTypeString, alias: ACQUISITION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [DONATED: DONATED], [PURCHASED: PURCHASED])
CONSULTANT (type: esriFieldTypeString, alias: CONSULTANT, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
OWNERSHIP (type: esriFieldTypeString, alias: OWNERSHIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CAMBRIDGE: CAMBRIDGE], [KITCHENER: KITCHENER], [MTO: MTO], ... 10 more ...)
BRIDGE_MAIN (type: esriFieldTypeString, alias: BRIDGE_MAIN, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y - YES], [N: N - NO], [U: U - UNKNOWN])
BRIDGE_DETAILS (type: esriFieldTypeString, alias: BRIDGE_DETAILS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
CRITICALITY (type: esriFieldTypeInteger, alias: CRITICALITY, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: -1], [0: 0], [1: 1], ... 9 more ...)
REL_CLEANING_AREA (type: esriFieldTypeString, alias: REL_CLEANING_AREA, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 4 more ...)
REL_CLEANING_SUBAREA (type: esriFieldTypeString, alias: REL_CLEANING_SUBAREA, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 49 more ...)
UNDERSIZED (type: esriFieldTypeString, alias: Undersized, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y - YES], [N: N - NO], [U: U - UNKNOWN])
SHALLOW_MAIN (type: esriFieldTypeString, alias: Shallow Main, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y - YES], [N: N - NO], [U: U - UNKNOWN])
CONDITION_SCORE (type: esriFieldTypeDouble, alias: Condition Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
OVERSIZED (type: esriFieldTypeString, alias: OVERSIZED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y - YES], [N: N - NO], [U: U - UNKNOWN])
CLEANED (type: esriFieldTypeString, alias: CLEANED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

OVERSIZED: N
CLEANED: N
STATUS: ACTIVE
PRESSURE_ZONE: UNKNOWN
CATEGORY: TREATED
PIPE_SIZE: 0
MATERIAL: XXX
LINED: NO
LINED_MATERIAL: NONE
ACQUISITION: DONATED
OWNERSHIP: KITCHENER
BRIDGE_MAIN: N
CRITICALITY: -1
REL_CLEANING_AREA: 0
CONDITION_SCORE: -1
REL_CLEANING_SUBAREA: 0
UNDERSIZED: N
SHALLOW_MAIN: N

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/25/2025 8:46:39 AM

Schema Last Edit Date: 7/25/2025 8:46:39 AM

Data Last Edit Date: 7/25/2025 8:46:39 AM

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