citydata-mesaaz-gov/water-valve-maintenance-9rhp-xjhb

  • asset management
  • maintenance
  • utilities
  • valve maintenance
  • valves
  • + 2

Water Valve Maintenance

Water Valve Maintenance

This data represents all information concerning valves maintained by the Water Resources department.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Maintenance Month Datemaintenance_month_datemaintenance_month_dateCalendar dateDate maintenance was performed
Valve Locationvalve_locationvalve_locationTextStreet name the feature is situated in from WSYSVALVE table
Serial NumberserialserialTextSerial number
Revision DaterevdaterevdateCalendar dateDate feature was last updated in GIS
ManufacturermfgmfgTextManufacturer
Maintenance Datemaint_datemaint_dateCalendar dateSystem Valve Maintenance Date
Document LinkdoclinkdoclinkTextDocument link, currently not used
Date AddedadddateadddateCalendar dateDate feature was added to GIS
ASB YearasbyearasbyearTextYear feature record drawing was completed
Valve NumvalvenovalvenoTextSystem valve number
User who AddedadduseradduserTextUserID of editor who added feature
Valve Object IDvalve_objectidvalve_objectidNumberUnique SDE ID from WSYSVALVE table
Service ZoneservicezoneservicezoneTextService zone
Valve IDwvalveidwvalveidTextForeign Key for joining to FacilityID in WSysValve table
Valve SizevalvesizevalvesizeNumberSize of the valve
Asset IDassetidassetidTextCity Quarter; pulled from WQSRevis feature class
City SectioncitysectioncitysectionNumberCity Section; Pulled from WQSRevis feature class
Warranty DatewarrantydatewarrantydateCalendar dateShould be warranty date, but field not populated
Valve Tagvalve_tagvalve_tagTextConcatenated values from VALVESEC and VALVENUM from WSYSVALVE table
TurnsturnsturnsNumberNumber of turns to open/close System Valve
Make of Valvemake_1make_1TextSystem Valve Make
Valve Property Locationvalveproperty_locationvalveproperty_locationTextSystem Valve location ties from WTValveProp table
RemarksremarksremarksTextGeneral information about a equipment not captured elsewhere
Facility IDfacilityidfacilityidTextUnique object ID
CommentscommentscommentsTextGeneral information about a feature not captured elsewhere
Maintenance Monthmaintenance_monthmaintenance_monthTextMonth maintenance was performed
Valve Property Object IDvalveproperty_objectidvalveproperty_objectidNumberUnique SDE ID from WTValveProp table
Symbol ScalesymscalesymscaleNumberSymbol scale
Symbol RotationsymrotsymrotNumberSymbol rotation
User who RevisedrevuserrevuserTextUserID of editor who last updated feature
Plan ReferenceplanrefplanrefTextSource reference number
Valve NumbervalvenumvalvenumTextSystem Valve Number from from WSYSVALVE table
Legacy IDlegacyidlegacyidTextHistoric ID of the feature
Install DateinstalldateinstalldateCalendar dateDate of installation
Valve Property Tagvalveproperty_tagvalveproperty_tagTextConcatenated values from VALVESEC and VALVENUM from WTValveProp table
Owner IDowneridowneridTextWho owns the feature
SubTypesubtypesubtypeNumberFeature type
ModelmodelmodelTextModel number
Valve SectionvalvesecvalvesecNumberSystem valve section
Maintenance Yearmaintenance_yearmaintenance_yearTextYear maintenance was performed
Flag CodeflagcdflagcdTextExtra field used for setting scale in detail boxes
DepthdepthdepthTextDepth to nut on Fire Hydrant Valve
Operational StatusopstatusopstatusNumberOperation status; InActive is the default value; after the Letter of Acceptance or Record Drawing is received, this is changed to Active
Valve ConditionconditionconditionTextNumeric value assigned to some features reflecting the condition of the asset
EnclosureenclosureenclosureNumberType of enclosure a feature is located inside of
Symbol NamesymnamesymnameTextSymbol name, Once was a required field for EMS Viewer; not sure we still need this field
Normal PositionnormposnormposTextNormal position; indicates if water flows or is stopped at the location
Condition DateconditiondateconditiondateTextDate of condition assessment
System IntertiesysintertiesysintertieTextSystem Valve Intertie, yes or no
Rehab TyperehabtyperehabtypeTextLining material type (i.e. copper, metal, etc…)
EnabledenabledenabledNumberIdentifies features that are included in the network
PermaLogpermalogpermalogTextSystem Valve Permalog, yes or no
Rehab YearrehabyearrehabyearTextYear lining work was done
Open DirectionopendiropendirTextSystem Valve open direction
Valve StatusvalvestatusvalvestatusTextSystem Valve is normally open or closed
Rehab ReferencerehabrefrehabrefTextPlan reference for lining project
Plan StatusplanstatusplanstatusTextStatus of the source (Permitted, AsBuilt)
City QuartercityquartercityquarterTextCity Section; Pulled from WQSRevis feature class

Upstream Metadata