ArcGIS REST Services Directory
Login
Home
>
services
>
StreetLevy
>
WaterDateInstalled (MapServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (StreetLevy/WaterDateInstalled)
Layers:
Layer:
Before 1940
(0)
Name:
Before 1940
Display Field:
LEGACYID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
85469fa0e4a9420ab11f894f7cd7a150
Copyright Text:
Default Visibility: true
MaxRecordCount:
10000
Supported Query Formats:
JSON, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 1368836.7079387307
YMin: 488836.085526526
XMax: 1405401.391236782
YMax: 534824.5545613468
Spatial Reference: 102723 (3735)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
INSTALLATIONDATE
Field 2:
null
Field 3:
null
Field Delimiter:
,
Default Symbol:
N/A
Default Label:
null
UniqueValueInfos:
Value:
1/1/1900
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1907
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1908
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1910
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1914
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1919
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1920
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1929
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1930
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1934
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Value:
1/1/1939
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 127, 127, 255]
Width:
1
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
SUBTYPECD
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
ENABLED
( type: esriFieldTypeSmallInteger, alias: ENABLED ,
Coded Values:
[0: False] , [1: True] )
LEGACYID
( type: esriFieldTypeString, alias: CityWorks Legacy ID, length: 20 )
WARRANTYDATE
( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
ASSETID
( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
CREATIONUSER
( type: esriFieldTypeString, alias: Creation User, length: 50 )
DATECREATED
( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
DATEMODIFIED
( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
LASTUSER
( type: esriFieldTypeString, alias: Last User, length: 50 )
SUBTYPECD
( type: esriFieldTypeInteger, alias: Subtype )
WADIA
( type: esriFieldTypeDouble, alias: Diameter ,
Coded Values:
[2: 2"] , [3: 3"] , [6: 6"]
, ...11 more...
)
WAMATL
( type: esriFieldTypeString, alias: Material, length: 4 ,
Coded Values:
[PE: Polyethylene] , [CI: Cast Iron] , [CO: Concrete]
, ...9 more...
)
PRESSZONE
( type: esriFieldTypeString, alias: Water Pressure System, length: 10 ,
Coded Values:
[D: 817 System] , [T: 817 Transmission] , [G: 875 System]
, ...10 more...
)
SERVICE_STATUS
( type: esriFieldTypeString, alias: Service Status, length: 15 ,
Coded Values:
[A: Active] , [I: Inactive] )
FIELDMEASUREDLENGTH
( type: esriFieldTypeDouble, alias: Field Measured Length )
WORKORDERID
( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
INSTALLATIONDATE
( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
CONDITIONCODE
( type: esriFieldTypeString, alias: Condition, length: 1 ,
Coded Values:
[G: Good] , [A: Average] , [P: Poor] )
LOCATIONDESCRIPTION
( type: esriFieldTypeString, alias: Location Description, length: 64 )
LOCATIONCONFIDENCELEVEL
( type: esriFieldTypeString, alias: Location Confidence, length: 1 ,
Coded Values:
[H: High] , [M: Medium] , [L: Low] )
CATHODICPROTECTIONIND
( type: esriFieldTypeString, alias: Cathodic Protection Indicator, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
BURIEDDEPTHINCHES
( type: esriFieldTypeInteger, alias: Buried Depth (Inches) )
INSTALLER
( type: esriFieldTypeString, alias: INSTALLER, length: 4 ,
Coded Values:
[CITY: City of Hamilton] , [CONT: Contractor] , [HO: Home Owner]
, ...2 more...
)
OWNER
( type: esriFieldTypeString, alias: OWNER, length: 15 ,
Coded Values:
[CITY: City of Hamilton] , [OTH: Other] )
MSLINK
( type: esriFieldTypeInteger, alias: Legacy GIS System Key )
MAPID
( type: esriFieldTypeInteger, alias: Legacy Map ID )
PIPE_LENGTH
( type: esriFieldTypeDouble, alias: Legacy GIS System Length )
WATERTRACEWEIGHT
( type: esriFieldTypeInteger, alias: Water Trace Weight )
OPERATINGPRESSURE
( type: esriFieldTypeInteger, alias: Operating Pressure )
DRAWINGID_REF
( type: esriFieldTypeString, alias: DRAWING/REF_ID, length: 10 )
DRAWIG_ID_REF_ID
( type: esriFieldTypeString, alias: DRAWING, length: 50 )
SUBDIVISION_DRAWINGS
( type: esriFieldTypeString, alias: Subdivision Drawings, length: 75 )
COMMENTS
( type: esriFieldTypeString, alias: COMMENTS, length: 250 )
FACILITYID
( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
LOCATION
( type: esriFieldTypeString, alias: LOCATION, length: 100 )
BEDDING_TYPE
( type: esriFieldTypeString, alias: Bedding, length: 15 ,
Coded Values:
[NATIVE: Native Soil] , [703 Modified: Modified Sand] , [SAND: Sand] )
WRAPPED
( type: esriFieldTypeString, alias: Wrapped, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
LINED
( type: esriFieldTypeString, alias: Lined, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
REHABDATE
( type: esriFieldTypeDate, alias: REHAB DATE, length: 8 )
FIREFLOWPROBLEM
( type: esriFieldTypeString, alias: Problematic Fire Flow, length: 3 ,
Coded Values:
[Y: Yes] , [N: No] )
BREAKCOUNT
( type: esriFieldTypeSmallInteger, alias: Break Count )
PIPECLASSCONDITION
( type: esriFieldTypeSmallInteger, alias: Pipe Class Age Condition )
BREAKRATECONDITION
( type: esriFieldTypeSmallInteger, alias: Break Rate Condition )
CRITICALITYREASON
( type: esriFieldTypeString, alias: Criticality Reason, length: 50 )
RISK
( type: esriFieldTypeDouble, alias: RISK FACTOR )
PIPECLASS
( type: esriFieldTypeDouble, alias: PIPECLASS )
CRITICALITY
( type: esriFieldTypeDouble, alias: CRITICALITY )
REPLACEMENTYEAR
( type: esriFieldTypeInteger, alias: REPLACEMENT YEAR )
WM_FAC
( type: esriFieldTypeString, alias: WM_FAC, length: 10 )
GLOBALID
( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
FROMVALVE
( type: esriFieldTypeString, alias: FROMVALVE, length: 25 )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
ADDRESS
( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
SHAPE_Length
( type: esriFieldTypeDouble, alias: SHAPE_Length )
Types:
ID: 2
Name: Raw
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 3
Name: Sludge
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 5
Name: Lagoon/Decant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 6
Name: Fire Hydrant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 1
Name: Potable
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 4
Name: Transmission
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
Layer:
1940 - 1970
(1)
Name:
1940 - 1970
Display Field:
LEGACYID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
85469fa0e4a9420ab11f894f7cd7a150
Copyright Text:
Default Visibility: true
MaxRecordCount:
10000
Supported Query Formats:
JSON, geoJSON
Min Scale:
72225
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 1368836.7079387307
YMin: 488836.085526526
XMax: 1405401.391236782
YMax: 534824.5545613468
Spatial Reference: 102723 (3735)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
INSTALLATIONDATE
Field 2:
null
Field 3:
null
Field Delimiter:
,
Default Symbol:
N/A
Default Label:
null
UniqueValueInfos:
Value:
1/1/1940
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1941
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1942
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1943
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1945
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1946
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1947
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1948
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1949
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1950
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1951
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1952
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1953
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1954
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1955
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1956
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1957
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1958
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1959
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1960
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1961
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1962
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1963
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1964
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1965
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1966
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1967
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1968
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1969
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Value:
1/1/1970
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[255, 255, 115, 255]
Width:
1
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
SUBTYPECD
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
ENABLED
( type: esriFieldTypeSmallInteger, alias: ENABLED ,
Coded Values:
[0: False] , [1: True] )
LEGACYID
( type: esriFieldTypeString, alias: CityWorks Legacy ID, length: 20 )
WARRANTYDATE
( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
ASSETID
( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
CREATIONUSER
( type: esriFieldTypeString, alias: Creation User, length: 50 )
DATECREATED
( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
DATEMODIFIED
( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
LASTUSER
( type: esriFieldTypeString, alias: Last User, length: 50 )
SUBTYPECD
( type: esriFieldTypeInteger, alias: Subtype )
WADIA
( type: esriFieldTypeDouble, alias: Diameter ,
Coded Values:
[2: 2"] , [3: 3"] , [6: 6"]
, ...11 more...
)
WAMATL
( type: esriFieldTypeString, alias: Material, length: 4 ,
Coded Values:
[PE: Polyethylene] , [CI: Cast Iron] , [CO: Concrete]
, ...9 more...
)
PRESSZONE
( type: esriFieldTypeString, alias: Water Pressure System, length: 10 ,
Coded Values:
[D: 817 System] , [T: 817 Transmission] , [G: 875 System]
, ...10 more...
)
SERVICE_STATUS
( type: esriFieldTypeString, alias: Service Status, length: 15 ,
Coded Values:
[A: Active] , [I: Inactive] )
FIELDMEASUREDLENGTH
( type: esriFieldTypeDouble, alias: Field Measured Length )
WORKORDERID
( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
INSTALLATIONDATE
( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
CONDITIONCODE
( type: esriFieldTypeString, alias: Condition, length: 1 ,
Coded Values:
[G: Good] , [A: Average] , [P: Poor] )
LOCATIONDESCRIPTION
( type: esriFieldTypeString, alias: Location Description, length: 64 )
LOCATIONCONFIDENCELEVEL
( type: esriFieldTypeString, alias: Location Confidence, length: 1 ,
Coded Values:
[H: High] , [M: Medium] , [L: Low] )
CATHODICPROTECTIONIND
( type: esriFieldTypeString, alias: Cathodic Protection Indicator, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
BURIEDDEPTHINCHES
( type: esriFieldTypeInteger, alias: Buried Depth (Inches) )
INSTALLER
( type: esriFieldTypeString, alias: INSTALLER, length: 4 ,
Coded Values:
[CITY: City of Hamilton] , [CONT: Contractor] , [HO: Home Owner]
, ...2 more...
)
OWNER
( type: esriFieldTypeString, alias: OWNER, length: 15 ,
Coded Values:
[CITY: City of Hamilton] , [OTH: Other] )
MSLINK
( type: esriFieldTypeInteger, alias: Legacy GIS System Key )
MAPID
( type: esriFieldTypeInteger, alias: Legacy Map ID )
PIPE_LENGTH
( type: esriFieldTypeDouble, alias: Legacy GIS System Length )
WATERTRACEWEIGHT
( type: esriFieldTypeInteger, alias: Water Trace Weight )
OPERATINGPRESSURE
( type: esriFieldTypeInteger, alias: Operating Pressure )
DRAWINGID_REF
( type: esriFieldTypeString, alias: DRAWING/REF_ID, length: 10 )
DRAWIG_ID_REF_ID
( type: esriFieldTypeString, alias: DRAWING, length: 50 )
SUBDIVISION_DRAWINGS
( type: esriFieldTypeString, alias: Subdivision Drawings, length: 75 )
COMMENTS
( type: esriFieldTypeString, alias: COMMENTS, length: 250 )
FACILITYID
( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
LOCATION
( type: esriFieldTypeString, alias: LOCATION, length: 100 )
BEDDING_TYPE
( type: esriFieldTypeString, alias: Bedding, length: 15 ,
Coded Values:
[NATIVE: Native Soil] , [703 Modified: Modified Sand] , [SAND: Sand] )
WRAPPED
( type: esriFieldTypeString, alias: Wrapped, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
LINED
( type: esriFieldTypeString, alias: Lined, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
REHABDATE
( type: esriFieldTypeDate, alias: REHAB DATE, length: 8 )
FIREFLOWPROBLEM
( type: esriFieldTypeString, alias: Problematic Fire Flow, length: 3 ,
Coded Values:
[Y: Yes] , [N: No] )
BREAKCOUNT
( type: esriFieldTypeSmallInteger, alias: Break Count )
PIPECLASSCONDITION
( type: esriFieldTypeSmallInteger, alias: Pipe Class Age Condition )
BREAKRATECONDITION
( type: esriFieldTypeSmallInteger, alias: Break Rate Condition )
CRITICALITYREASON
( type: esriFieldTypeString, alias: Criticality Reason, length: 50 )
RISK
( type: esriFieldTypeDouble, alias: RISK FACTOR )
PIPECLASS
( type: esriFieldTypeDouble, alias: PIPECLASS )
CRITICALITY
( type: esriFieldTypeDouble, alias: CRITICALITY )
REPLACEMENTYEAR
( type: esriFieldTypeInteger, alias: REPLACEMENT YEAR )
WM_FAC
( type: esriFieldTypeString, alias: WM_FAC, length: 10 )
GLOBALID
( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
FROMVALVE
( type: esriFieldTypeString, alias: FROMVALVE, length: 25 )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
ADDRESS
( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
SHAPE_Length
( type: esriFieldTypeDouble, alias: SHAPE_Length )
Types:
ID: 2
Name: Raw
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 3
Name: Sludge
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 5
Name: Lagoon/Decant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 6
Name: Fire Hydrant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 1
Name: Potable
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 4
Name: Transmission
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
Layer:
After 1970
(2)
Name:
After 1970
Display Field:
LEGACYID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
85469fa0e4a9420ab11f894f7cd7a150
Copyright Text:
Default Visibility: true
MaxRecordCount:
10000
Supported Query Formats:
JSON, geoJSON
Min Scale:
72225
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 1368836.7079387307
YMin: 488836.085526526
XMax: 1405401.391236782
YMax: 534824.5545613468
Spatial Reference: 102723 (3735)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
INSTALLATIONDATE
Field 2:
null
Field 3:
null
Field Delimiter:
,
Default Symbol:
N/A
Default Label:
null
UniqueValueInfos:
Value:
1/1/1971
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1972
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1973
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1974
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1975
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1976
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1977
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1978
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1979
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1980
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1981
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1982
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1983
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1984
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1985
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1986
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1987
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1988
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1989
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1990
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1991
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1992
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1993
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1994
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1995
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1996
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1997
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1998
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/1999
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2000
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2001
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2002
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2003
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2004
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2005
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2006
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2007
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2008
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2009
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2010
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2011
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2012
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2013
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/1/2014
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
1/18/2010
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
10/13/2008
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
10/21/2014
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
11/1/2002
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
12/1/2010
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
2/1/1950
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
2/1/2010
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
8/31/2008
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
9/1/2008
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
9/1/2009
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
9/1/2010
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Value:
9/15/2010
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[163, 255, 115, 255]
Width:
1
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
SUBTYPECD
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
ENABLED
( type: esriFieldTypeSmallInteger, alias: ENABLED ,
Coded Values:
[0: False] , [1: True] )
LEGACYID
( type: esriFieldTypeString, alias: CityWorks Legacy ID, length: 20 )
WARRANTYDATE
( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
ASSETID
( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
CREATIONUSER
( type: esriFieldTypeString, alias: Creation User, length: 50 )
DATECREATED
( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
DATEMODIFIED
( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
LASTUSER
( type: esriFieldTypeString, alias: Last User, length: 50 )
SUBTYPECD
( type: esriFieldTypeInteger, alias: Subtype )
WADIA
( type: esriFieldTypeDouble, alias: Diameter ,
Coded Values:
[2: 2"] , [3: 3"] , [6: 6"]
, ...11 more...
)
WAMATL
( type: esriFieldTypeString, alias: Material, length: 4 ,
Coded Values:
[PE: Polyethylene] , [CI: Cast Iron] , [CO: Concrete]
, ...9 more...
)
PRESSZONE
( type: esriFieldTypeString, alias: Water Pressure System, length: 10 ,
Coded Values:
[D: 817 System] , [T: 817 Transmission] , [G: 875 System]
, ...10 more...
)
SERVICE_STATUS
( type: esriFieldTypeString, alias: Service Status, length: 15 ,
Coded Values:
[A: Active] , [I: Inactive] )
FIELDMEASUREDLENGTH
( type: esriFieldTypeDouble, alias: Field Measured Length )
WORKORDERID
( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
INSTALLATIONDATE
( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
CONDITIONCODE
( type: esriFieldTypeString, alias: Condition, length: 1 ,
Coded Values:
[G: Good] , [A: Average] , [P: Poor] )
LOCATIONDESCRIPTION
( type: esriFieldTypeString, alias: Location Description, length: 64 )
LOCATIONCONFIDENCELEVEL
( type: esriFieldTypeString, alias: Location Confidence, length: 1 ,
Coded Values:
[H: High] , [M: Medium] , [L: Low] )
CATHODICPROTECTIONIND
( type: esriFieldTypeString, alias: Cathodic Protection Indicator, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
BURIEDDEPTHINCHES
( type: esriFieldTypeInteger, alias: Buried Depth (Inches) )
INSTALLER
( type: esriFieldTypeString, alias: INSTALLER, length: 4 ,
Coded Values:
[CITY: City of Hamilton] , [CONT: Contractor] , [HO: Home Owner]
, ...2 more...
)
OWNER
( type: esriFieldTypeString, alias: OWNER, length: 15 ,
Coded Values:
[CITY: City of Hamilton] , [OTH: Other] )
MSLINK
( type: esriFieldTypeInteger, alias: Legacy GIS System Key )
MAPID
( type: esriFieldTypeInteger, alias: Legacy Map ID )
PIPE_LENGTH
( type: esriFieldTypeDouble, alias: Legacy GIS System Length )
WATERTRACEWEIGHT
( type: esriFieldTypeInteger, alias: Water Trace Weight )
OPERATINGPRESSURE
( type: esriFieldTypeInteger, alias: Operating Pressure )
DRAWINGID_REF
( type: esriFieldTypeString, alias: DRAWING/REF_ID, length: 10 )
DRAWIG_ID_REF_ID
( type: esriFieldTypeString, alias: DRAWING, length: 50 )
SUBDIVISION_DRAWINGS
( type: esriFieldTypeString, alias: Subdivision Drawings, length: 75 )
COMMENTS
( type: esriFieldTypeString, alias: COMMENTS, length: 250 )
FACILITYID
( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
LOCATION
( type: esriFieldTypeString, alias: LOCATION, length: 100 )
BEDDING_TYPE
( type: esriFieldTypeString, alias: Bedding, length: 15 ,
Coded Values:
[NATIVE: Native Soil] , [703 Modified: Modified Sand] , [SAND: Sand] )
WRAPPED
( type: esriFieldTypeString, alias: Wrapped, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
LINED
( type: esriFieldTypeString, alias: Lined, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
REHABDATE
( type: esriFieldTypeDate, alias: REHAB DATE, length: 8 )
FIREFLOWPROBLEM
( type: esriFieldTypeString, alias: Problematic Fire Flow, length: 3 ,
Coded Values:
[Y: Yes] , [N: No] )
BREAKCOUNT
( type: esriFieldTypeSmallInteger, alias: Break Count )
PIPECLASSCONDITION
( type: esriFieldTypeSmallInteger, alias: Pipe Class Age Condition )
BREAKRATECONDITION
( type: esriFieldTypeSmallInteger, alias: Break Rate Condition )
CRITICALITYREASON
( type: esriFieldTypeString, alias: Criticality Reason, length: 50 )
RISK
( type: esriFieldTypeDouble, alias: RISK FACTOR )
PIPECLASS
( type: esriFieldTypeDouble, alias: PIPECLASS )
CRITICALITY
( type: esriFieldTypeDouble, alias: CRITICALITY )
REPLACEMENTYEAR
( type: esriFieldTypeInteger, alias: REPLACEMENT YEAR )
WM_FAC
( type: esriFieldTypeString, alias: WM_FAC, length: 10 )
GLOBALID
( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
FROMVALVE
( type: esriFieldTypeString, alias: FROMVALVE, length: 25 )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
ADDRESS
( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
SHAPE_Length
( type: esriFieldTypeDouble, alias: SHAPE_Length )
Types:
ID: 2
Name: Raw
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 3
Name: Sludge
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 5
Name: Lagoon/Decant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 6
Name: Fire Hydrant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 1
Name: Potable
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 4
Name: Transmission
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
Layer:
Unknown
(3)
Name:
Unknown
Display Field:
LEGACYID
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
85469fa0e4a9420ab11f894f7cd7a150
Copyright Text:
Default Visibility: true
MaxRecordCount:
10000
Supported Query Formats:
JSON, geoJSON
Min Scale:
72225
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 1368836.7079387307
YMin: 488836.085526526
XMax: 1405401.391236782
YMax: 534824.5545613468
Spatial Reference: 102723 (3735)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
INSTALLATIONDATE
Field 2:
null
Field 3:
null
Field Delimiter:
,
Default Symbol:
N/A
Default Label:
null
UniqueValueInfos:
Value:
Label:
Description:
Symbol:
Style:
esriSLSSolid
Color:
[0, 168, 132, 255]
Width:
1
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
SUBTYPECD
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
ENABLED
( type: esriFieldTypeSmallInteger, alias: ENABLED ,
Coded Values:
[0: False] , [1: True] )
LEGACYID
( type: esriFieldTypeString, alias: CityWorks Legacy ID, length: 20 )
WARRANTYDATE
( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
ASSETID
( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
CREATIONUSER
( type: esriFieldTypeString, alias: Creation User, length: 50 )
DATECREATED
( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
DATEMODIFIED
( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
LASTUSER
( type: esriFieldTypeString, alias: Last User, length: 50 )
SUBTYPECD
( type: esriFieldTypeInteger, alias: Subtype )
WADIA
( type: esriFieldTypeDouble, alias: Diameter ,
Coded Values:
[2: 2"] , [3: 3"] , [6: 6"]
, ...11 more...
)
WAMATL
( type: esriFieldTypeString, alias: Material, length: 4 ,
Coded Values:
[PE: Polyethylene] , [CI: Cast Iron] , [CO: Concrete]
, ...9 more...
)
PRESSZONE
( type: esriFieldTypeString, alias: Water Pressure System, length: 10 ,
Coded Values:
[D: 817 System] , [T: 817 Transmission] , [G: 875 System]
, ...10 more...
)
SERVICE_STATUS
( type: esriFieldTypeString, alias: Service Status, length: 15 ,
Coded Values:
[A: Active] , [I: Inactive] )
FIELDMEASUREDLENGTH
( type: esriFieldTypeDouble, alias: Field Measured Length )
WORKORDERID
( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
INSTALLATIONDATE
( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
CONDITIONCODE
( type: esriFieldTypeString, alias: Condition, length: 1 ,
Coded Values:
[G: Good] , [A: Average] , [P: Poor] )
LOCATIONDESCRIPTION
( type: esriFieldTypeString, alias: Location Description, length: 64 )
LOCATIONCONFIDENCELEVEL
( type: esriFieldTypeString, alias: Location Confidence, length: 1 ,
Coded Values:
[H: High] , [M: Medium] , [L: Low] )
CATHODICPROTECTIONIND
( type: esriFieldTypeString, alias: Cathodic Protection Indicator, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
BURIEDDEPTHINCHES
( type: esriFieldTypeInteger, alias: Buried Depth (Inches) )
INSTALLER
( type: esriFieldTypeString, alias: INSTALLER, length: 4 ,
Coded Values:
[CITY: City of Hamilton] , [CONT: Contractor] , [HO: Home Owner]
, ...2 more...
)
OWNER
( type: esriFieldTypeString, alias: OWNER, length: 15 ,
Coded Values:
[CITY: City of Hamilton] , [OTH: Other] )
MSLINK
( type: esriFieldTypeInteger, alias: Legacy GIS System Key )
MAPID
( type: esriFieldTypeInteger, alias: Legacy Map ID )
PIPE_LENGTH
( type: esriFieldTypeDouble, alias: Legacy GIS System Length )
WATERTRACEWEIGHT
( type: esriFieldTypeInteger, alias: Water Trace Weight )
OPERATINGPRESSURE
( type: esriFieldTypeInteger, alias: Operating Pressure )
DRAWINGID_REF
( type: esriFieldTypeString, alias: DRAWING/REF_ID, length: 10 )
DRAWIG_ID_REF_ID
( type: esriFieldTypeString, alias: DRAWING, length: 50 )
SUBDIVISION_DRAWINGS
( type: esriFieldTypeString, alias: Subdivision Drawings, length: 75 )
COMMENTS
( type: esriFieldTypeString, alias: COMMENTS, length: 250 )
FACILITYID
( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
LOCATION
( type: esriFieldTypeString, alias: LOCATION, length: 100 )
BEDDING_TYPE
( type: esriFieldTypeString, alias: Bedding, length: 15 ,
Coded Values:
[NATIVE: Native Soil] , [703 Modified: Modified Sand] , [SAND: Sand] )
WRAPPED
( type: esriFieldTypeString, alias: Wrapped, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
LINED
( type: esriFieldTypeString, alias: Lined, length: 1 ,
Coded Values:
[Y: Yes] , [N: No] )
REHABDATE
( type: esriFieldTypeDate, alias: REHAB DATE, length: 8 )
FIREFLOWPROBLEM
( type: esriFieldTypeString, alias: Problematic Fire Flow, length: 3 ,
Coded Values:
[Y: Yes] , [N: No] )
BREAKCOUNT
( type: esriFieldTypeSmallInteger, alias: Break Count )
PIPECLASSCONDITION
( type: esriFieldTypeSmallInteger, alias: Pipe Class Age Condition )
BREAKRATECONDITION
( type: esriFieldTypeSmallInteger, alias: Break Rate Condition )
CRITICALITYREASON
( type: esriFieldTypeString, alias: Criticality Reason, length: 50 )
RISK
( type: esriFieldTypeDouble, alias: RISK FACTOR )
PIPECLASS
( type: esriFieldTypeDouble, alias: PIPECLASS )
CRITICALITY
( type: esriFieldTypeDouble, alias: CRITICALITY )
REPLACEMENTYEAR
( type: esriFieldTypeInteger, alias: REPLACEMENT YEAR )
WM_FAC
( type: esriFieldTypeString, alias: WM_FAC, length: 10 )
GLOBALID
( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
SHAPE
( type: esriFieldTypeGeometry, alias: SHAPE )
FROMVALVE
( type: esriFieldTypeString, alias: FROMVALVE, length: 25 )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
ADDRESS
( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
SHAPE_Length
( type: esriFieldTypeDouble, alias: SHAPE_Length )
Types:
ID: 2
Name: Raw
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 3
Name: Sludge
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 5
Name: Lagoon/Decant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 6
Name: Fire Hydrant
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 1
Name: Potable
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited
ID: 4
Name: Transmission
Domains:
ENABLED:
Inherited
WADIA:
Inherited
WAMATL:
Inherited
PRESSZONE:
Inherited
SERVICE_STATUS:
Inherited
CONDITIONCODE:
Inherited
LOCATIONCONFIDENCELEVEL:
Inherited
CATHODICPROTECTIONIND:
Inherited
INSTALLER:
Inherited
OWNER:
Inherited
BEDDING_TYPE:
Inherited
WRAPPED:
Inherited
LINED:
Inherited
FIREFLOWPROBLEM:
Inherited