Name: Water Hydrant

Display Field: ASSETID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Devices that allow fire fighters to attach hoses to the distribution network. Also used to flush main lines, and test pressure.

Service Item Id: c3182cfeb25645a2a7c110de9f497451

Copyright Text: City of Mercer Island

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1290119.0000020266
YMin: 194585.8000034988
XMax: 1302325.485409394
YMax: 220369.98957951367
Spatial Reference: 2926  (2926)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [SHORTID] CONCAT NEWLINE CONCAT [PSI_MEASURED]
Use Coded Values: true
Symbol:
Color: [255, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Calibri
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 20 )
• SHORTID ( type: esriFieldTypeString, alias: SHORTID, length: 20 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• FEATURESTATUS ( type: esriFieldTypeString, alias: FEATURESTATUS, length: 20 , Coded Values: [Active: Active] , [Abandoned: Abandoned] , [Removed: Removed] , ...7 more... )
• BARRELDIAMETER ( type: esriFieldTypeDouble, alias: BARRELDIAMETER )
• HYDMAINVALVEDIAM ( type: esriFieldTypeDouble, alias: HYDMAINVALVEDIAM )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 30 , Coded Values: [Mercer Island: Mercer Island] , [Mercer Island (by Easement): Mercer Island (by Easement)] , [Private: Private] , ...9 more... )
• YEARINSTALL ( type: esriFieldTypeSmallInteger, alias: YEARINSTALL )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: OPERATIONALAREA, length: 30 , Coded Values: [398_Reservoir: 398_Reservoir] , [456_First Hill: 456_First Hill] , [Shorewood Seattle Supply: Shorewood Seattle Supply] , ...37 more... )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 130 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• NUMBEROFPORTS ( type: esriFieldTypeSmallInteger, alias: NUMBEROFPORTS )
• QUICKCOUPLINGS ( type: esriFieldTypeSmallInteger, alias: QUICKCOUPLINGS , Coded Values: [0: False] , [1: True] )
• BLUEREFLECTOR ( type: esriFieldTypeSmallInteger, alias: BLUEREFLECTOR , Coded Values: [0: False] , [1: True] )
• FOOTVALVEDISTANCE ( type: esriFieldTypeDouble, alias: FOOTVALVEDISTANCE )
• FOOTVALVETURNS ( type: esriFieldTypeDouble, alias: FOOTVALVETURNS )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 20 , Coded Values: [Eddy: Eddy] , [M&H: M&H] , [Mueller: Mueller] , ...7 more... )
• MODEL ( type: esriFieldTypeString, alias: MODEL, length: 30 )
• STEMPLACEMENT ( type: esriFieldTypeString, alias: STEMPLACEMENT, length: 30 , Coded Values: [Center Stem: Center Stem] , [Offset Stem (Corey): Offset Stem (Corey)] , [Unknown: Unknown] , ...1 more... )
• HYDRANTBURY ( type: esriFieldTypeDouble, alias: HYDRANTBURY )
• WAMAINDIAMETER ( type: esriFieldTypeDouble, alias: WAMAINDIAMETER , Coded Values: [-1: Other] , [0: Unknown] , [0.625: 5/8"] , ...31 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION )
• ACCESSIBILITY ( type: esriFieldTypeString, alias: ACCESSIBILITY, length: 100 )
• PSI_MEASURED ( type: esriFieldTypeDouble, alias: PSI_MEASURED )
• PSI_MEASUREDATE ( type: esriFieldTypeDate, alias: PSI_MEASUREDATE, length: 8 )
• CHLORINE_MEASURED ( type: esriFieldTypeDouble, alias: CHLORINE_MEASURED )
• CHLORINE_MEASUREDATE ( type: esriFieldTypeDate, alias: CHLORINE_MEASUREDATE, length: 8 )
• FIREFLOW_MEASURED ( type: esriFieldTypeInteger, alias: FIREFLOW_MEASURED )
• FIREFLOW_MEASUREDATE ( type: esriFieldTypeDate, alias: FIREFLOW_MEASUREDATE, length: 8 )
• FIREFLOW_MODELED_2013 ( type: esriFieldTypeInteger, alias: FIREFLOW_MODELED_2013 )
• FIREFLOW_MODELED_2015 ( type: esriFieldTypeInteger, alias: FIREFLOW_MODELED_2015 )
• FIREFLOW_MODELED_2017 ( type: esriFieldTypeInteger, alias: FIREFLOW_MODELED_2017 )
• FIREFLOW_MODELED_2019 ( type: esriFieldTypeInteger, alias: FIREFLOW_MODELED_2019 )
• PSI_MDD_MODELED_2015 ( type: esriFieldTypeDouble, alias: PSI_MDD_MODELED_2015 )
• PSI_MDD_MODELED_2017 ( type: esriFieldTypeInteger, alias: PSI_MDD_MODELED_2017 )
• PSI_MDD_MODELED_2019 ( type: esriFieldTypeInteger, alias: PSI_MDD_MODELED_2019 )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, length: 8 )
• LIFEEXPECTANCY ( type: esriFieldTypeSmallInteger, alias: LIFEEXPECTANCY )
• REMAININGLIFE ( type: esriFieldTypeSmallInteger, alias: REMAININGLIFE )
• COF ( type: esriFieldTypeSmallInteger, alias: COF )
• POF ( type: esriFieldTypeSmallInteger, alias: POF )
• BRE ( type: esriFieldTypeSmallInteger, alias: BRE )
• UPDATESOURCE ( type: esriFieldTypeString, alias: UPDATESOURCE, length: 255 )
• UPDATEBY ( type: esriFieldTypeString, alias: UPDATEBY, length: 20 )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, length: 8 )
• DOCFETCH ( type: esriFieldTypeString, alias: DOCFETCH, length: 255 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
• MAPGRID ( type: esriFieldTypeString, alias: MAPGRID, length: 10 )
• INSPPROGRESS ( type: esriFieldTypeString, alias: INSPPROGRESS, length: 50 )
• FIREFLOW_MODELED_2022 ( type: esriFieldTypeInteger, alias: FIREFLOW_MODELED_2022 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata