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)
Return to Vancouver Street Trees