citydata-mesaaz-gov/water-hydrants-r7t3-nh2k
 
Readme
Updated 7 hours ago
Indexed 3 hours ago

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
Water Hydrant IDwater_hydrant_idwater_hydrant_idTextForeign Key for joining to FacilityID in WHydrant table
Valve Turnsvalve_turnsvalve_turnsNumberFire Hydrant valve turns
Valve Locationvalve_locationvalve_locationTextFire Hydrant valve location ties
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
Install Dateinstall_dateinstall_dateCalendar dateDate of installation
Full Addressfull_addressfull_addressTextFull Address
ClassclassclassTextIdentifies standard vs non-standard hydrants
ASB Yearasb_yearasb_yearTextYear feature record drawing was completed
Date Addeddate_addeddate_addedCalendar dateDate feature was added to GIS
Symbol Rotationsymbol_rotationsymbol_rotationNumberSymbol rotation
LocationlocationlocationTextStreet name the feature is situated in
Revision Userrevision_userrevision_userTextUserID of editor who last updated feature
Hydrant Sectionhydrant_sectionhydrant_sectionNumberHydrant Section
Facility IDfacility_idfacility_idTextUnique object ID
Maintenance Month Datemaintenance_month_datemaintenance_month_dateCalendar dateDate maintenance was performed
Maintenance Monthmaintenance_monthmaintenance_monthTextMonth maintenance was performed
Valve Makevalve_makevalve_makeTextFire Hydrant valve make
Water Hydrant Property Object IDwaterhydrantproperty_objectidwaterhydrantproperty_objectidNumberUnique SDE ID in Water Hydrant Property Table
Hydrant Numberhydrant_numberhydrant_numberTextHydrant Number
EnabledenabledenabledNumberIdentifies features that are included in the network
LatitudelatitudelatitudeNumberLatitude of water hydrant or maintenance performed
Plan Referenceplan_referenceplan_referenceTextSource reference number
DepthdepthdepthTextDepth to nut on Fire Hydrant Valve
Legacy IDlegacy_idlegacy_idTextHistoric ID of the feature
Flag Codeflag_codeflag_codeTextExtra field used for setting scale in detail boxes
Document Linkdocument_linkdocument_linkTextDocument link, currently not used
Fire Hydrant Numberfire_hydrant_numberfire_hydrant_numberTextFire Hydrant No
Symbol Scalesymbol_scalesymbol_scaleNumberSymbol scale
Condition Assessment Datecondition_assessment_datecondition_assessment_dateTextDate of condition assessment
City Sectioncity_sectioncity_sectionNumberCity Section; Pulled from WQSRevis feature class
Ancillary Roleancillary_roleancillary_roleTextSource or Sink
LongitudelongitudelongitudeNumberLongitude of water hydrant or maintenance performed
SubTypesubtypesubtypeNumberFeature type
Maintenance Datemaintenance_datemaintenance_dateCalendar dateFire Hydrant Maintenance Date
CommentscommentscommentsTextGeneral information about a feature not captured elsewhere
Rehab Typerehab_typerehab_typeTextLining material type
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
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