New Open Data Portal

Now you can search, filter, and visualize datasets with maps or charts – right in your browser. Export data or consume them using an application programming interface (API).

The Legacy Open Data catalogue and its datasets will remain available until early fall (exact date to be announced).

Questions and comments? Contact us

Water (fire) hydrants attributes

  • ID: hydrant identifier in the format WH-A99-999 where WH stands for Water Hydrant, A99 is the grid, and the first of the last three numbers is 0 for distribution or transmission subsystem, 1 for Dedicated Fire Protection, 8 for Musqueam owned, and 9 for a private hydrant. The last two 9’s are a sequence number.
  • LATITUDE: Measurement in degrees from the equator, with positive values going north and negative values going south
  • LONGITUDE: Measurement in degrees from the Zero Meridian, with positive values going east and negative values going west
  • SUBSYSTEM: the subsystem where DSTR is distribution; TRNS is transmission; and DFPS is dedicated fire protection
  • CODE: is the manufacturer
  • COVWATERHYDRANTUNITTYPE: hydrant model
  • DISTANCEFROMCORNER: distance in meters to the nearest street corner
  • FEEDERLEN: distance in meters from the hydrant to the hydrant control valve
  • DIR: direction of hydrant lateral
  • LINE: direction of hydrant lateral
  • COLOR: Red indicates < 500 Imperial Gallons Per Minute (GPM); Yellow indicates 500 - 1000 IMPERIAL GPM; Green indicates 1000 - 1500 IMPERIAL GPM; Blue indicates > 1500 IMPERIAL GPM; White indicates a PRIVATE HYDRANT
  • INCOMM: in commission yes or no
  • CHR0: contains no data
  • CHR1: contains no data
  • STREET_NUMBER: Number assigned to the street where the hydrant is located
  • STREET: location plus address or intersection for example WS 123 Madeup Street – means west side in front of 123 Madeup Street; if an intersection it will be the corner and the street and cross street for example NEC Madeup Street & Madeup Drive which means north east corner on Madeup Street where the cross street is Madeup Drive
  • OLDHYDNUM: old hydrant number
  • CASTSUB: sub designation for example Stanley Park
  • OOCDATE: last out of commission date
  • OOCNOTES: last out of commission notes in mm/dd/yyyy format
  • INSTDATE1: date hydrant was installed in mm/dd/yyyy format
  • ORACLEID: identifier in Oracle database
  • ACTIVE: all hydrants in this data set are in service
  • REMARKS: any special notes
  • FIREUSEONLY: a ‘Y’ (yes) means not available for special use due to a special condition such as releasing water from the hydrant will set off fire alarms at nearby schools, etc.
  • STATUS: all hydrants in this data set are in service
  • COMPRESSION: a ‘Yes’ means this is a compression valve type hydrant, if ‘N’ means a gate valve type hydrant
  • ADDDTTM: the date the hydrant was added to the database in mm/dd/yyyy format
  • ADDBY: the person or operation that added the hydrant
  • TIMECREATED: the time the records was added in hh:mm (AM or PM) format
  • MODBY: the last person/operation that modified the record
  • TIMEMODIFIED: the time the record was last modified in hh:mm (AM or PM) format
  • FEATURE_ID: GIS internal number
  • UNITID: Infrastructure management internal number

Return to Water (fire) hydrants