Name: Water Fire Hydrant

Display Field: ASSETID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 4515

Max. Scale: 0

Default Visibility: false

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1368836.70793873
YMin: 491985.83349745
XMax: 1405401.39123678
YMax: 534693.440833226
Spatial Reference: 102723 (3735)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"9b348a62f331ed83f2eff829c85185fa","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAUdJREFUKJGNz79L1WEUx/FXcuEBf2LicKcCaRAxyEwwsXBod4twslHclEzoX2jtP3CIAgejoaVZiIggB7PQ6VLhjZCuHFBr8PuNr5fH8AMHnvPhvM/5PDUZ1ev1kUajca3sU0qtiHjTPlfLwc1mcx5LZR8Re7h6IfiiysF9jyPujmIQP/GOy+vUP9H4H9zzgpdTjFfNCXomef6I+9UFJbwLq/TfpjcX8QbTD9h+wj6klB6W8BVOz10qjF94i2kMFN443U5LRHSeiV09+QELeIbZwhtsS3MGblXet7CGsYrXzMEppafwNeLeTa53oBMzbcOf2U4pbRSxv9SKxzIc0/WezTFGOirQH3xk54Q7EfEtG3uZ32tMvmJziOEuHGKLVi9Ti3w/988wx0FK6XVEDFfsH9rALFzouKhSR7mhLBwRK1g5Z/E//QW7YlugatL4bgAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

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)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: ENABLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• LEGACYID (type: esriFieldTypeString, alias: CityWorks LegacyID, 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)
• WFID (type: esriFieldTypeString, alias: Fire Hydrant ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• WFMANUF (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [D: Darling], [M: Meuller], [OTH: Other], ... 8 more ...)
• WFENGCAP (type: esriFieldTypeString, alias: Cap Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• WFVALVE (type: esriFieldTypeString, alias: Valve Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• ANGLE (type: esriFieldTypeDouble, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSTALLATIONDATE (type: esriFieldTypeDate, alias: INSTALLATIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 15, 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], [OTH: Other])
• SERVICE_STATUS (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [A: Active], [I: Inactive])
• WFFLOW (type: esriFieldTypeDouble, alias: Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MODEL (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MANUFACTUREDATE (type: esriFieldTypeString, alias: Manufacture Date, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GPS (type: esriFieldTypeString, alias: GPS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ENGINECOMPANY (type: esriFieldTypeInteger, alias: Engine Company, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPEID (type: esriFieldTypeString, alias: PIPEID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FH_FAC (type: esriFieldTypeString, alias: FH_FAC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• OperationalStatus (type: esriFieldTypeString, alias: OperationalStatus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StaticPSI (type: esriFieldTypeDouble, alias: StaticPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ResidualPSI (type: esriFieldTypeDouble, alias: ResidualPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pitot (type: esriFieldTypeDouble, alias: Pitot, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeviceUsed (type: esriFieldTypeDouble, alias: DeviceUsed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Coefficient (type: esriFieldTypeDouble, alias: Coefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowMins (type: esriFieldTypeDouble, alias: FlowMins, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlowBaseline (type: esriFieldTypeDouble, alias: FlowBaseline, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GallonsUsed (type: esriFieldTypeDouble, alias: GallonsUsed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OperationComments (type: esriFieldTypeString, alias: OperationComments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlushDate (type: esriFieldTypeDate, alias: FlushDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FlowDate (type: esriFieldTypeDate, alias: FlowDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BarCode (type: esriFieldTypeString, alias: Bar Code, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Private (type: esriFieldTypeString, alias: Private, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• LDH (type: esriFieldTypeString, alias: LDH Connection, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [A: 4.5"], [B: STORZ], [C: Other], ... 1 more ...)

Templates:

Name: Water Fire Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ENABLED: 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