Name: Water Fire Hydrant

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b4e612f210de4cb2a63462bd626a6080

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 9030

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: 491985.13007345796
XMax: 1405401.391236782
YMax: 534695.8279692233
Spatial Reference: 102723  (3735)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• LEGACYID ( type: esriFieldTypeString, alias: CityWorks LegacyID, 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 )
• WFID ( type: esriFieldTypeString, alias: Fire Hydrant ID, length: 10 )
• WFMANUF ( type: esriFieldTypeString, alias: Manufacturer, length: 4 , Coded Values: [D: Darling] , [M: Meuller] , [OTH: Other] , ...8 more... )
• WFENGCAP ( type: esriFieldTypeString, alias: Cap Indicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• WFVALVE ( type: esriFieldTypeString, alias: Valve Indicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• ANGLE ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8 )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
• INSTALLER ( type: esriFieldTypeString, alias: INSTALLER, length: 4 , Coded Values: [CITY: City of Hamilton] , [CONT: Contractor] , [OTH: Other] )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, length: 15 , Coded Values: [A: Active] , [I: Inactive] )
• WFFLOW ( type: esriFieldTypeDouble, alias: Flow )
• WATERTRACEWEIGHT ( type: esriFieldTypeInteger, alias: Water Trace Weight )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 50 )
• MANUFACTUREDATE ( type: esriFieldTypeString, alias: Manufacture Date, length: 5 )
• GPS ( type: esriFieldTypeString, alias: Needs GPS?, length: 4 , Coded Values: [Y: Yes] , [N: No] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
• ENGINECOMPANY ( type: esriFieldTypeInteger, alias: Engine Company )
• PIPEID ( type: esriFieldTypeString, alias: PIPEID, length: 30 )
• FH_FAC ( type: esriFieldTypeString, alias: FH_FAC, length: 10 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• 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 )
• OperationalStatus ( type: esriFieldTypeString, alias: OperationalStatus, length: 255 )
• StaticPSI ( type: esriFieldTypeDouble, alias: StaticPSI )
• ResidualPSI ( type: esriFieldTypeDouble, alias: ResidualPSI )
• Pitot ( type: esriFieldTypeDouble, alias: Pitot )
• DeviceUsed ( type: esriFieldTypeDouble, alias: DeviceUsed )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient )
• FlowMins ( type: esriFieldTypeDouble, alias: FlowMins )
• FlowBaseline ( type: esriFieldTypeDouble, alias: FlowBaseline )
• GallonsUsed ( type: esriFieldTypeDouble, alias: GallonsUsed )
• OperationComments ( type: esriFieldTypeString, alias: OperationComments, length: 255 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• FlushDate ( type: esriFieldTypeDate, alias: FlushDate, length: 8 )
• FlowDate ( type: esriFieldTypeDate, alias: FlowDate, length: 8 )
• BarCode ( type: esriFieldTypeString, alias: Bar Code, length: 20 )
• Private ( type: esriFieldTypeString, alias: Private, length: 10 , Coded Values: [Y: Yes] , [N: No] )
• LDH ( type: esriFieldTypeString, alias: LDH Connection, length: 20 , Coded Values: [A: 4.5"] , [B: STORZ] , [C: Other] , ...1 more... )
• MAINTCONCERN ( type: esriFieldTypeString, alias: Maintenance Concern, length: 25 , Coded Values: [A: Does Not Come On] , [B: Cannot Turn Off] , [C: Too Hard to Operate] , ...5 more... )
• COMPLETED ( type: esriFieldTypeString, alias: Inspection Completed, length: 5 , Coded Values: [Y: Yes] , [N: No] )
• DATEINSPECTED ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• PrivateSymbol ( type: esriFieldTypeSmallInteger, alias: PrivateSymbol )
• INSPECTIONCOMMENTS ( type: esriFieldTypeString, alias: Inspection Comments, length: 50 )
• FlowPrevious ( type: esriFieldTypeDouble, alias: Previous Year Flow )
• SMALLHEADCONNECTION ( type: esriFieldTypeString, alias: Small Diameter Head Connection, length: 50 , Coded Values: [Hamilton: 2.5" Hamilton Threads] , [National: 2.5" National Pipe Threads] , [Other: Other] )
• INSPECTIONINITIALS ( type: esriFieldTypeString, alias: Inspected By Initials, length: 10 )
• PSIPrevious ( type: esriFieldTypeDouble, alias: Previous Year PSI )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata