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

 
External

Water Hydrants

  • asset management
  • fire
  • hydrant
  • maintenance
  • utilities
  • And 4 more...

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
Outlet Size Oldoutlet_size_oldoutlet_size_oldTextFire Hydrant Outlet Size Old
Plan Statusplan_statusplan_statusTextStatus of the source (Permitted, AsBuilt)
Facility IDfacility_idfacility_idTextUnique object ID
Valve Statusvalve_statusvalve_statusTextFire Hydrant valve status
Open Directionopen_directionopen_directionTextOpen Direction for Fire Hydrant Valve
Rehab Typerehab_typerehab_typeTextLining material type
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
Rehab Referencerehab_referencerehab_referenceTextPlan reference for lining project
City Sectioncity_sectioncity_sectionNumberCity Section; Pulled from WQSRevis feature class
Asset IDasset_idasset_idTextUnique Equipment ID
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
Maintenance Month Datemaintenance_month_datemaintenance_month_dateCalendar dateDate maintenance was performed
Valve Makevalve_makevalve_makeTextFire Hydrant valve make
Valve Locationvalve_locationvalve_locationTextFire Hydrant valve location ties
Revision Daterevision_daterevision_dateCalendar dateDate feature was last updated in GIS
Maintenance Datemaintenance_datemaintenance_dateCalendar dateFire Hydrant Maintenance Date
Hydrant Numberhydrant_numberhydrant_numberTextHydrant Number
Date Addeddate_addeddate_addedCalendar dateDate feature was added to GIS
Plan Referenceplan_referenceplan_referenceTextSource reference number
Water Hydrant Property Object IDwaterhydrantproperty_objectidwaterhydrantproperty_objectidNumberUnique SDE ID in Water Hydrant Property Table
ASB Yearasb_yearasb_yearTextYear feature record drawing was completed
Ancillary Roleancillary_roleancillary_roleTextSource or Sink
LatitudelatitudelatitudeNumberLatitude of water hydrant or maintenance performed
RemarksremarksremarksTextGeneral information about equipment not captured elsewhere
Install Dateinstall_dateinstall_dateCalendar dateDate of installation
Full Addressfull_addressfull_addressTextFull Address
CommentscommentscommentsTextGeneral information about a feature not captured elsewhere
Revision Userrevision_userrevision_userTextUserID of editor who last updated feature
Document Linkdocument_linkdocument_linkTextDocument link, currently not used
Water Hydrant IDwater_hydrant_idwater_hydrant_idTextForeign Key for joining to FacilityID in WHydrant table
LocationlocationlocationTextStreet name the feature is situated in
Hydrant Sizehydrant_sizehydrant_sizeNumberBarrel size of the hydrant
Condition Assessment Datecondition_assessment_datecondition_assessment_dateTextDate of condition assessment
LongitudelongitudelongitudeNumberLongitude of water hydrant or maintenance performed
Hydrant Sectionhydrant_sectionhydrant_sectionNumberHydrant Section
TAGtagtagTextConcatenated values from Hydrant Section AND Hydrant Number
Symbol Rotationsymbol_rotationsymbol_rotationNumberSymbol rotation
User Addeduser_addeduser_addedTextUserID of Editor who added feature
Fire Hydrant Makefire_hydrant_makefire_hydrant_makeTextFire Hydrant Make
Legacy IDlegacy_idlegacy_idTextHistoric ID of the feature
DepthdepthdepthTextDepth to nut on Fire Hydrant Valve
Maintenance Monthmaintenance_monthmaintenance_monthTextMonth maintenance was performed
Symbol Namesymbol_namesymbol_nameTextSymbol name, once was a required field for EMS Viewer; not sure we still need this field
Fire Hydrant Numberfire_hydrant_numberfire_hydrant_numberTextFire Hydrant No
Symbol Scalesymbol_scalesymbol_scaleNumberSymbol scale
SubTypesubtypesubtypeNumberFeature type
Flag Codeflag_codeflag_codeTextExtra field used for setting scale in detail boxes
GeolocationgeolocationgeolocationPointThe geocoded location of the hydrant
EnabledenabledenabledNumberIdentifies features that are included in the network
ClassclassclassTextIdentifies standard vs non-standard hydrants
ShapeshapeshapeTextType of object (point, line, polygon, etc.)
Valve Turnsvalve_turnsvalve_turnsNumberFire Hydrant valve turns
Pipe Sizepipe_sizepipe_sizeNumberSize of the pipe
Mesa Census Tracts To City Boundary:@computed_region_fcpr_wj2n:@computed_region_fcpr_wj2nNumber

Upstream Metadata