View In:   ArcGIS Online Map Viewer

Name: Hydrant

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Locations of all public, private, and University owned fire hydrants within the City of Ann Arbor or otherwise connected to the City's drinking water network.

Copyright Text: City of Ann Arbor Public Services

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -248.02436807751656
YMin: 5290.24729026854
XMax: 2.65702675947351E7
YMax: 1151789.6944615245
Spatial Reference: 2253  (2253)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 57, 143, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 1
  Label: WHydrantST
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 158, 137, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: FACILITYID )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• PRESSURESYSTEM ( type: esriFieldTypeString, alias: PressureSystem, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureSystem , Coded Values: [GED: Geddes] , [GRA: Gravity] , [NEHIPRZ: Northeash High Individual Pressure Reduced Zone] , ...10 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• SUBTYPE ( type: esriFieldTypeInteger, alias: SUBTYPE, editable: true, nullable: false, defaultValue: 1, modelName: SUBTYPE )
• INSTALLCONTRACTOR ( type: esriFieldTypeString, alias: InstallContractor, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InstallContractor , Coded Values: [3S: 3-S Construction] , [AA: City of Ann Arbor Engineering] , [AAE: AAE] , ...358 more... )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASBUILTNUMBER )
• DATAORIGIN ( type: esriFieldTypeString, alias: DataOrigin, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DataOrigin , Coded Values: [ASBUILT: Asbuilt] , [CDWG: Construction Drawing] , [EST: Estimate] , ...7 more... )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 10, defaultValue: AA, modelName: Owner , Coded Values: [AA: Ann Arbor] , [PB: Private-Billable] , [PNB: Private-Non-Billable] , ...4 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• Z_COORD ( type: esriFieldTypeDouble, alias: Z_COORD, editable: true, nullable: true, defaultValue: null, modelName: Z_COORD )
• TURNDIRECTION ( type: esriFieldTypeString, alias: TurnDirection, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TurnDirection , Coded Values: [R: Right (Clockwise)] , [L: Left (CounterClockwise)] , [O: Other] , ...1 more... )
• BRANCHLENGTH ( type: esriFieldTypeDouble, alias: BRANCHLENGTH, editable: true, nullable: true, defaultValue: null, modelName: BRANCHLENGTH )
• BRANCHSIZE ( type: esriFieldTypeDouble, alias: BranchSize, editable: true, nullable: true, defaultValue: null, modelName: BranchSize , Coded Values: [4: 4"] , [6: 6"] , [8: 8"] , ...4 more... )
• COMPANIONVALVESIZE ( type: esriFieldTypeDouble, alias: CompanionValveSize, editable: true, nullable: true, defaultValue: null, modelName: CompanionValveSize , Coded Values: [0.5: .5"] , [0.75: .75"] , [1: 1"] , ...24 more... )
• COMPANIONVALVETYPE ( type: esriFieldTypeString, alias: CompanionValveType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CompanionValveType , Coded Values: [AIR: Air] , [AIRGAP: AirGap] , [AIRRELEASE: AirRelease] , ...18 more... )
• COMPANIONNUMBEROFTURNS ( type: esriFieldTypeString, alias: COMPANIONNUMBEROFTURNS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COMPANIONNUMBEROFTURNS )
• COMPANIONOPERATINGDIRECTION ( type: esriFieldTypeString, alias: CompanionOperatingDirection, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CompanionOperatingDirection , Coded Values: [R: Right (Clockwise)] , [L: Left (CounterClockwise)] , [O: Other] , ...1 more... )
• COMPANIONVALVELOCATION ( type: esriFieldTypeString, alias: COMPANIONVALVELOCATION, editable: true, nullable: true, length: 60, defaultValue: null, modelName: COMPANIONVALVELOCATION )
• HYDRANTMAKE ( type: esriFieldTypeString, alias: HydrantMake, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HydrantMake , Coded Values: [AM: American] , [AFC: American Flow Control] , [CL: Clow] , ...20 more... )
• MAKESIZELOCATION ( type: esriFieldTypeString, alias: COMPANIONVALVEMAKE, editable: true, nullable: true, length: 32, defaultValue: null, modelName: MAKESIZELOCATION )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 32, defaultValue: null, modelName: Inspector , Coded Values: [100: A AJAM] , [50: A OLESKI] , [51: ADAM BALL] , ...90 more... )
• DEPTHBURIED ( type: esriFieldTypeDouble, alias: DEPTHBURIED, editable: true, nullable: true, defaultValue: null, modelName: DEPTHBURIED )
• HUBOPENING ( type: esriFieldTypeDouble, alias: HubOpening, editable: true, nullable: true, defaultValue: null, modelName: HubOpening , Coded Values: [2: 2"] , [4.5: 4.5"] , [5: 5"] , ...7 more... )
• VALVEOPENING ( type: esriFieldTypeDouble, alias: ValveOpening, editable: true, nullable: true, defaultValue: null, modelName: ValveOpening , Coded Values: [6: 6"] , [-1: Other] , [0: Unknown] , ...6 more... )
• HYDRANTGATE ( type: esriFieldTypeString, alias: HydrantGate, editable: true, nullable: true, length: 20, defaultValue: G, modelName: HydrantGate , Coded Values: [G: Gated] , [NG: Not Gated] , [OTH: Other] , ...1 more... )
• CreatedUser ( type: esriFieldTypeString, alias: CreatedUser, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CreatedUser )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• DateModified ( type: esriFieldTypeDate, alias: DateModified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• ModifiedUser ( type: esriFieldTypeString, alias: ModifiedUser, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ModifiedUser )
• BranchMaterial ( type: esriFieldTypeString, alias: BranchMaterial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BranchMaterial , Coded Values: [DI: Ductile Iron] , [CI: Cast Iron] , [PVC: PVC] , ...3 more... )
• Modifications ( type: esriFieldTypeString, alias: Modifications, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Modifications )
• ProjectFunding ( type: esriFieldTypeString, alias: ProjectFunding, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectFunding , Coded Values: [City: City] , [Grant: Grant] , [Develop: Developer Donatated Infrastructure] , ...2 more... )
• PMDistrict ( type: esriFieldTypeString, alias: PMDistrict, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PMDistrict , Coded Values: [Geddes 1: Geddes 1] , [Geddes 2: Geddes 2] , [Gravity 1: Gravity 1] , ...32 more... )
• Pressure ( type: esriFieldTypeDouble, alias: Pressure, editable: true, nullable: true, defaultValue: null, modelName: Pressure )
• HydrantExtension ( type: esriFieldTypeString, alias: HydrantExtension, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydrantExtension )
• PressureDate ( type: esriFieldTypeDate, alias: PressureDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PressureDate )
• WaterFillLocation ( type: esriFieldTypeString, alias: WaterFillLocation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterFillLocation , Coded Values: [Y: Yes] , [N: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: 1
Name: WHydrantST
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PRESSURESYSTEM:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• OWNER:
  Inherited
• TURNDIRECTION:
  Inherited
• BRANCHSIZE:
  Inherited
• COMPANIONVALVESIZE:
  Inherited
• COMPANIONVALVETYPE:
  Inherited
• COMPANIONOPERATINGDIRECTION:
  Inherited
• HYDRANTMAKE:
  Inherited
• INSPECTOR:
  Inherited
• HUBOPENING:
  Inherited
• VALVEOPENING:
  Inherited
• HYDRANTGATE:
  Inherited
• BranchMaterial:
  Inherited
• PMDistrict:
  Inherited
• WaterFillLocation:
  Inherited
Templates:
• Name: WHydrantST
  Description:
  Prototype:
  ROTATION: null
  WaterFillLocation: null
  ANCILLARYROLE: 0
  ENABLED: 1
  FACILITYID:
  LOCATION: null
  INSTALLDATE: null
  PRESSURESYSTEM: null
  SUBTYPE: 1
  INSTALLCONTRACTOR: null
  ASBUILTNUMBER: null
  DATAORIGIN: null
  OWNER: AA
  COMMENTS: null
  X_COORD: null
  Y_COORD: null
  Z_COORD: null
  TURNDIRECTION: null
  BRANCHLENGTH: null
  BRANCHSIZE: null
  COMPANIONVALVESIZE: null
  COMPANIONVALVETYPE: null
  COMPANIONNUMBEROFTURNS: null
  COMPANIONOPERATINGDIRECTION: null
  COMPANIONVALVELOCATION: null
  HYDRANTMAKE: null
  MAKESIZELOCATION: null
  INSPECTOR: null
  DEPTHBURIED: null
  HUBOPENING: null
  VALVEOPENING: null
  HYDRANTGATE: G
  CreatedUser: null
  DateCreated: null
  DateModified: null
  ModifiedUser: null
  BranchMaterial: null
  Modifications: null
  ProjectFunding: null
  PMDistrict: null
  Pressure: null
  HydrantExtension: null
  PressureDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata