citydata-mesaaz-gov/water-hydrants-r7t3-nh2k

  • asset management
  • fire
  • hydrant
  • maintenance
  • utilities
  • + 4

Water Hydrants

Water Hydrants

This dataset represents all information concerning water hydrants maintained by the City of Mesa.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Symbol Rotationsymbol_rotationsymbol_rotationNumberSymbol rotation
LocationlocationlocationTextStreet name the feature is situated in
Hydrant Sectionhydrant_sectionhydrant_sectionNumberHydrant Section
Hydrant Numberhydrant_numberhydrant_numberTextHydrant Number
City Sectioncity_sectioncity_sectionNumberCity Section; Pulled from WQSRevis feature class
Date Addeddate_addeddate_addedCalendar dateDate feature was added to GIS
LatitudelatitudelatitudeNumberLatitude of water hydrant or maintenance performed
Water Hydrant IDwater_hydrant_idwater_hydrant_idTextForeign Key for joining to FacilityID in WHydrant table
Install Dateinstall_dateinstall_dateCalendar dateDate of installation
Full Addressfull_addressfull_addressTextFull Address
Valve Makevalve_makevalve_makeTextFire Hydrant valve make
Fire Hydrant Numberfire_hydrant_numberfire_hydrant_numberTextFire Hydrant No
Document Linkdocument_linkdocument_linkTextDocument link, currently not used
DepthdepthdepthTextDepth to nut on Fire Hydrant Valve
Ancillary Roleancillary_roleancillary_roleTextSource or Sink
LongitudelongitudelongitudeNumberLongitude of water hydrant or maintenance performed
Maintenance Month Datemaintenance_month_datemaintenance_month_dateCalendar dateDate maintenance was performed
SubTypesubtypesubtypeNumberFeature type
Maintenance Datemaintenance_datemaintenance_dateCalendar dateFire Hydrant Maintenance Date
CommentscommentscommentsTextGeneral information about a feature not captured elsewhere
Legacy IDlegacy_idlegacy_idTextHistoric ID of the feature
Maintenance Monthmaintenance_monthmaintenance_monthTextMonth maintenance was performed
Plan Referenceplan_referenceplan_referenceTextSource reference number
Valve Turnsvalve_turnsvalve_turnsNumberFire Hydrant valve turns
TAGtagtagTextConcatenated values from Hydrant Section AND Hydrant Number
Revision Daterevision_daterevision_dateCalendar dateDate feature was last updated in GIS
RemarksremarksremarksTextGeneral information about equipment not captured elsewhere
Revision Userrevision_userrevision_userTextUserID of editor who last updated feature
Valve Locationvalve_locationvalve_locationTextFire Hydrant valve location ties
EnabledenabledenabledNumberIdentifies features that are included in the network
Condition Assessment Datecondition_assessment_datecondition_assessment_dateTextDate of condition assessment
ClassclassclassTextIdentifies standard vs non-standard hydrants
ASB Yearasb_yearasb_yearTextYear feature record drawing was completed
Rehab Typerehab_typerehab_typeTextLining material type
Water Hydrant Property Object IDwaterhydrantproperty_objectidwaterhydrantproperty_objectidNumberUnique SDE ID in Water Hydrant Property Table
GeolocationgeolocationgeolocationPointThe geocoded location of the hydrant
User Addeduser_addeduser_addedTextUserID of Editor who added feature
Asset IDasset_idasset_idTextUnique Equipment ID
Fire Hydrant Makefire_hydrant_makefire_hydrant_makeTextFire Hydrant Make
Flag Codeflag_codeflag_codeTextExtra field used for setting scale in detail boxes
Facility IDfacility_idfacility_idTextUnique object ID
Symbol Scalesymbol_scalesymbol_scaleNumberSymbol scale
ShapeshapeshapeTextType of object (point, line, polygon, etc.)
Hydrant Sizehydrant_sizehydrant_sizeNumberBarrel size of the hydrant
Symbol Namesymbol_namesymbol_nameTextSymbol name, once was a required field for EMS Viewer; not sure we still need this field
Plan Statusplan_statusplan_statusTextStatus of the source (Permitted, AsBuilt)
Valve Statusvalve_statusvalve_statusTextFire Hydrant valve status
Open Directionopen_directionopen_directionTextOpen Direction for Fire Hydrant Valve
Fire Hydrant Modelfire_hydrant_modelfire_hydrant_modelTextFire Hydrant Model
City Quartercity_quartercity_quarterTextCity Quarter; pulled from WQSRevis feature class
Service Zoneservice_zoneservice_zoneTextService zone
Outlet Sizeoutlet_sizeoutlet_sizeTextHydrant outlet size
Operation Statusoperation_statusoperation_statusNumberOperation status; InActive is the default value; after the Letter of Acceptance or Record Drawing is received, this is changed to Active
Water Hydrant Object IDwaterhydrant_objectidwaterhydrant_objectidNumberUnique SDE ID
PSIpsipsiNumberFire Hydrant PSI
Outlet Size Oldoutlet_size_oldoutlet_size_oldTextFire Hydrant Outlet Size Old
Rehab Referencerehab_referencerehab_referenceTextPlan reference for lining project
Warranty Datewarranty_datewarranty_dateTextShould be warranty date, but field not populated
Condition of Assetcondition_of_assetcondition_of_assetTextNumeric value assigned to some features reflecting the condition of the asset
Owner IDowner_idowner_idTextWho owns the feature
Maintenance Yearmaintenance_yearmaintenance_yearTextYear maintenance was performed
Rehab Yearrehab_yearrehab_yearTextYear lining work was done
Pipe Sizepipe_sizepipe_sizeNumberSize of the pipe
Mesa Census Tracts To City Boundary:@computed_region_fcpr_wj2n:@computed_region_fcpr_wj2nNumber

Upstream Metadata