Layer: Water Main (ID:21)

View In: Map Viewer

Name: Water Main

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

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"PRESSZONE","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,170,0,255],"width":2},"value":"A","label":"1040 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3.4},"value":"Z","label":"1040 Transmission","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[250,52,17,255],"width":2},"value":"D","label":"817 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3.4},"value":"T","label":"817 Transmission","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2},"value":"G","label":"875 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[38,115,0,255],"width":2},"value":"H","label":"885 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,0,255],"width":2},"value":"F","label":"890 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[85,255,0,255],"width":2},"value":"E","label":"920 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":2},"value":"C","label":"940 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3.4},"value":"W","label":"940 Transmission","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":2},"value":"B","label":"980 System","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":3.4},"value":"X","label":"980 Transmission","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,92,230,255],"width":1.5},"value":"U","label":"Unknown","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":[{"labelPlacement":"esriServerLinePlacementAboveAlong","where":null,"labelExpression":"[WADIA] CONCAT \" \" CONCAT [WAMATL]","useCodedValues":true,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,0,0,255],"haloSize":2,"font":{"family":"Calibri","size":11,"style":"normal","weight":"bold","decoration":"none"}},"minScale":4515,"maxScale":0}]}
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: GLOBALID

Type ID Field: PRESSZONE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ENABLED (type: esriFieldTypeSmallInteger, alias: ENABLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
LEGACYID (type: esriFieldTypeString, alias: CityWorks Legacy ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
WARRANTYDATE (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ASSETID (type: esriFieldTypeString, alias: CityWorks AssetID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DATECREATED (type: esriFieldTypeDate, alias: DATECREATED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DATEMODIFIED (type: esriFieldTypeDate, alias: DATEMODIFIED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
WADIA (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: 2"], [3: 3"], [6: 6"], ... 11 more ...)
WAMATL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [PE: Polyethylene], [CI: Cast Iron], [CO: Concrete], ... 9 more ...)
PRESSZONE (type: esriFieldTypeString, alias: Water Pressure System, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [D: 817 System], [T: 817 Transmission], [G: 875 System], ... 10 more ...)
SERVICE_STATUS (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [A: Active], [I: Inactive])
FIELDMEASUREDLENGTH (type: esriFieldTypeDouble, alias: Field Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
INSTALLATIONDATE (type: esriFieldTypeDate, alias: INSTALLATIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CONDITIONCODE (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [G: Good], [A: Average], [P: Poor])
LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
LOCATIONCONFIDENCELEVEL (type: esriFieldTypeString, alias: Location Confidence, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [H: High], [M: Medium], [L: Low])
CATHODICPROTECTIONIND (type: esriFieldTypeString, alias: Cathodic Protection Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
BURIEDDEPTHINCHES (type: esriFieldTypeInteger, alias: Buried Depth (Inches), SQL Type: sqlTypeOther, nullable: true, editable: true)
INSTALLER (type: esriFieldTypeString, alias: INSTALLER, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [CITY: City of Hamilton], [CONT: Contractor], [HO: Home Owner], ... 2 more ...)
OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [CITY: City of Hamilton], [OTH: Other])
MSLINK (type: esriFieldTypeInteger, alias: Legacy GIS System Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAPID (type: esriFieldTypeInteger, alias: Legacy Map ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
PIPE_LENGTH (type: esriFieldTypeDouble, alias: Legacy GIS System Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
OPERATINGPRESSURE (type: esriFieldTypeInteger, alias: Operating Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRAWINGID_REF (type: esriFieldTypeString, alias: DRAWING/REF_ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
DRAWIG_ID_REF_ID (type: esriFieldTypeString, alias: DRAWING, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SUBDIVISION_DRAWINGS (type: esriFieldTypeString, alias: Subdivision Drawings, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
BEDDING_TYPE (type: esriFieldTypeString, alias: Bedding, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [NATIVE: Native Soil], [703 Modified: Modified Sand], [SAND: Sand])
WRAPPED (type: esriFieldTypeString, alias: Wrapped, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
LINED (type: esriFieldTypeString, alias: Lined, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
REHABDATE (type: esriFieldTypeDate, alias: REHAB DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
FIREFLOWPROBLEM (type: esriFieldTypeString, alias: Problematic Fire Flow, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
BREAKCOUNT (type: esriFieldTypeSmallInteger, alias: Break Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
PIPECLASSCONDITION (type: esriFieldTypeSmallInteger, alias: Pipe Class Age Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
BREAKRATECONDITION (type: esriFieldTypeSmallInteger, alias: Break Rate Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRITICALITYREASON (type: esriFieldTypeString, alias: Criticality Reason, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
RISK (type: esriFieldTypeDouble, alias: RISK FACTOR, SQL Type: sqlTypeOther, nullable: true, editable: true)
PIPECLASS (type: esriFieldTypeDouble, alias: PIPECLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRITICALITY (type: esriFieldTypeDouble, alias: CRITICALITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPLACEMENTYEAR (type: esriFieldTypeInteger, alias: REPLACEMENT YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
WM_FAC (type: esriFieldTypeString, alias: WM_FAC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
FROMVALVE (type: esriFieldTypeString, alias: FROMVALVE, SQL Type: sqlTypeOther, length: 25, 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)
ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: A

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: Z

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: D

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: T

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: G

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: H

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: F

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: E

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: C

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: W

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: B

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: X

Field Name: ENABLED
Inherited
Field Name: WADIA
Inherited
Field Name: WAMATL
Inherited
Field Name: PRESSZONE
Inherited
Field Name: SERVICE_STATUS
Inherited
Field Name: CONDITIONCODE
Inherited
Field Name: LOCATIONCONFIDENCELEVEL
Inherited
Field Name: CATHODICPROTECTIONIND
Inherited
Field Name: INSTALLER
Inherited
Field Name: OWNER
Inherited
Field Name: BEDDING_TYPE
Inherited
Field Name: WRAPPED
Inherited
Field Name: LINED
Inherited
Field Name: FIREFLOWPROBLEM
Inherited

ENABLED: 1
SUBTYPECD: 1
PRESSZONE: U

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2021 1:18:47 AM

Schema Last Edit Date: 4/15/2021 1:18:47 AM

Data Last Edit Date: 4/15/2021 1:18:47 AM

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