Name: Water Service

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

Max. Scale: 0

Default Visibility: false

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1368556.99901047
YMin: 492651.960474074
XMax: 1405227.27194063
YMax: 534812.543553337
Spatial Reference: 102723 (3735)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[10,147,252,255],"width":1},"label":"","description":""},"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:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

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: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 10 more ...)
• WAMATL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [PE: Polyethylene], [CI: Cast Iron], [DI: Ductile Iron], ... 8 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])
• 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: 32, nullable: true, editable: true, Coded Values: [CITY: City of Hamilton], [OTH: Other])
• PIPE_LENGTH (type: esriFieldTypeDouble, alias: Legacy GIS System Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WAUSE (type: esriFieldTypeString, alias: WAUSE, SQL Type: sqlTypeOther, length: 50, 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)
• 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)
• WS_FAC (type: esriFieldTypeString, alias: WS_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)

Templates:

Name: Water Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• SUBTYPECD: 1

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