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

Upstream Metadata