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:
XMin: 535355.9397
YMin: 4801431.5386
XMax: 549736.3132
YMax: 4816466.5372
Spatial Reference: 26917 (26917)
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:
IsSystemMaintained : True
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:
Name: Water Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Attributes:
- 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