Vancouver Street Trees attributes

  • TREE_ID: Numerical ID
  • CIVIC_NUMBER: Street address of the site at which the tree is associated with
  • STD_STREET: Street name of the site at which the tree is associated with
  • NEIGHBOURHOOD_NAME: Neighborhood in which the tree is located
  • CELL: The location of a tree on a site (explanation provided below)
  • ON_STREET: The name of the street at which the tree is physically located on
  • ON_STREET_BLOCK: The street block at which the tree is physically located on
  • STREET_SIDE_NAME: The street side which the tree is physically located on (Even, Odd or Median (Med))
  • ASSIGNED: Indicates whether the address is made up to associate the tree with a nearby lot (Y=Yes or N=No)
  • HEIGHT_RANGE_ID: 0-10 for every 10 feet (e.g., 0 = 0-10 FT, 1=10-20,…,10 = 100+ FT)
  • DIAMETER: DBH in inches (DBH stands for diameter of tree at breast height)
  • DATE_PLANTED: The date of planting in YYYYMMDD format. Data for this field may not be available for all trees.
  • PLANT_AREA: B = behind sidewalk, G = in tree grate, N = no sidewalk, C = cutout, a number indicates boulevard width in feet
  • ROOT_BARRIER: Root barrier installed (Y = Yes, N = No)
  • CURB: Curb presence (Y = Yes, N = No)
  • CULTIVAR_NAME: Cultivar name
  • GENUS_NAME: Genus name
  • SPECIES_NAME: Species name
  • COMMON_NAME: Common name

Explaining the Concept of the Cell, Assigned Address and On Street

Cells provide a way for City staff to assign a relative position to trees on an addressed site. Cells represent a logical division around a given lot. Cell numbering begins from the front-right of lot and continues in a counter-clockwise direction. 24 cells are defined on a given lot. Cells may also extend to medians around the property in which case cell numbering may extend up to 48.

Cells are elastic according to a lots size and shape. The following scenario (based on the pictorial below) shows how trees are addressed with respect to their cell position:

  • Trees in cells 1-24 will have address 1243 Street A
  • Trees in cells 1-7 are on the 1,000 block of Street A with street_side_name=ODD
  • Trees in cells 8-13 are on the 3,000 block of Street B with street_side_name=EVEN
  • Trees in cells 25-31 will have address 1243 Street A with assigned = Y and street_side_name=MED (for median)
  • Trees in traffic circles will have cell number zero (0)

Trees in cells pictorial

Return to Vancouver Street Trees