| OBJECTID |
OBJECTID |
NUMBER |
ESRI system maintained integer field used to uniquely identify rows in tables in a geodatabase. Note that OBJECTIID values change upon export or import of the data and should not be used as a primary field for searching or identifying records. |
|
|
|
| TREEID |
Tree ID |
NUMBER |
Tree identifier. Created through a database trigger |
|
|
|
| CIVIC_NO |
Closest Civic No |
NUMBER |
Integer value. Civic address of the feature. |
|
|
|
| STREET |
Street |
VARCHAR2 |
Street name of the feature based on the STREET MASTER Table. |
RoadName |
|
401 LON OFFRAMP; YARWOOD PL; YELLOW BIRCH DR; YORK ST; YOUNG ST; YULE PL; ZEFFER PL; ZELLER CRES; ZELLER CRT; ZELLER DR ...See GIS for a complete list... |
| LOCATION |
Location |
VARCHAR2 |
Open text field that describes the location of the feature in more detail. |
TreeLocation |
|
BOULEVARD; CEMETERY; CENTRE MEDIAN; CITY PARK; GOLF COURSE; HARDSCAPE; NATURAL AREA; OTHER MAINTAINED LOCATION; OTHER UN-MAINTAINED LOCATION; RAISED PLANTER |
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
TreeStatus |
ACTIVE |
ACTIVE; FIELD MISTAKE - DELETE; PLANNED PLANTING; POTENTIAL PLANTING; REMOVED |
| STATUS_DATE |
Status Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| OWNERSHIP |
Ownership |
VARCHAR2 |
Asset Owner: Who owns the feature, Generally Government agencies such as CITY, REGION and MTO and private citizens and businesses shown as PUBLIC. This usually relates to the property the asset sits on. |
TreeOwnership |
CITY |
CITY; CITY < 50%; CITY > 50% TO 99%; PRIVATE |
| CATEGORY |
Map Class |
VARCHAR2 |
GIS mapping category used for symbolizing maps. Categories of trees are set in the Tree species domain table |
TreeCategory |
|
Amur; Pawpaw; Pear; Pine; Poplar; Serviceberry; Small Tree; Spruce; Tamarack; Willow ...See GIS for a complete list... |
| SPECIES_NAME |
Species Name |
VARCHAR2 |
The common name of the tree |
TreeSpeciesName |
|
Deborah Norway Maple; Willow; Winged Elm; Winter King Hawthorn; Witch Hazel; Yellow Birch; Yellow Buckeye; Yellowwood; Yew; Zelkova 'Wireless' ...See GIS for a complete list... |
| SPECIES_LATIN |
Species Latin |
VARCHAR2 |
The Latin name of the tree. It is automatically filled in based on the Species Name from the Tree Species Domain table |
TreeSpeciesLatin |
|
Abies balsamea; Sorbus alnifolia; Sorbus americana; Sorbus aucuparia; Sorbus x hybrida; Syringa reticulata 'Ivory Silk'; Syringa vulgaris; Taxodium distichum; Taxus species; Thuja occidentalis ...See GIS for a complete list... |
| SPECIES_CODE |
Species Code |
VARCHAR2 |
The species code of the tree. It is automatically filled in based on the Species Name from the Tree Species Domain table |
TreeSpeciesCode |
|
SAAM; ULXAC; ULXFR; ULXHO; ULXNE; ULXPI; ULXTR; UNKN; ZESE; ZESESCH ...See GIS for a complete list... |
| OVERHEAD_HYDRO |
Type of Hydro above tree |
VARCHAR2 |
Type of overhead hydro found adjacent to tree. Initial values where entered using a script based on hydro layers |
TreeOverheadHydro |
None |
House service; None; Single phase; Three phase |
| LANDUSE |
AMANDA Land use |
VARCHAR2 |
AMANDA land use category of the property tree is located on |
ParcelCategory |
|
AGRICULTURAL; COMMERCIAL; ERROR; INDUSTRIAL; INSTITUTIONAL; MIXED USE; RECREATIONAL; RESIDENTIAL; ROW; UTILITY |
| DEVELOPMENT_AGE |
Development Age |
VARCHAR2 |
Development Age based on nearby parcels and subdivision plans |
|
|
|
| PARCELID |
Parcel ID |
NUMBER |
Reference Parcel ID that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| ROADSEGMENTID |
Roadsegment ID |
NUMBER |
Reference ROADSEGMENTID that the feature is located in. The value is generated from a spatial join process. |
|
|
|
| PARK |
Park |
VARCHAR2 |
Name of the park the tree is located in. Note that parks do not extend in to the road allowance so data must be manually checked |
ParkName |
|
ABRAM STAUFFER GREEN; WOODFIELD COURT WOODLAND; WOODSIDE GREEN; WOODSIDE NATIONAL HISTORIC PARK (FEDERAL); WOODSIDE PARK; WOOLNER - SWP; WOOLNER WOODS; WOOLWICH STREET WOODLOT; YELLOW BIRCH PARK; ZELLER PARK ...See GIS for a complete list... |
| WARD |
Ward |
NUMBER |
Reference Ward that the feature is located in. The value is either manually entered or generated from a spatial join process. |
WardCodedValues |
|
|
| PLANNING_COMMUNITY |
Planning Community |
VARCHAR2 |
GIS maintained field. Reference Planning Community that the feature is located in. The value is either manually entered or generated from a spatial join process. |
PlanningCommunity |
|
Auditorium (14); Central Frederick (13); Civic Centre (2); Laurentian West (28); Mill Courtland Woodside Park (5); Pioneer Tower East (40); Pioneer Tower West (41); Rosenberg (54); Southdale (17); Vanier (25) ...See GIS for a complete list... |
| SUB_WATERSHED |
Sub-Watershed |
VARCHAR2 |
Sub watershed number the tree is located in |
StmSubwatershed |
|
ALDER CREEK; NONE; NORTH STRASBURG CREEK; UNNAMED CATCHMENT 1; UNNAMED CATCHMENT 2; UNNAMED CATCHMENT 3; UNNAMED CATCHMENT 4; UPPER SCHNEIDER CREEK; VOISIN CREEK; WESTMOUNT CREEK ...See GIS for a complete list... |
| MAP_DBH_CM |
Mapping DBH (cm) |
NUMBER |
GIS Mapping field used for symbolizing maps. It is the diameter of the tree at breast height (1.3 m above the ground) in centimetres. If the diameter cannot be taken at that height, take the DBH at the closest point below the branching. Updated by the latest measurement inspection through the database. |
|
|
|
| GIS_NOTES |
Notes |
VARCHAR2 |
Open text field for outlining any problems or to highlight special characteristics of the feature specific to GIS. |
|
|
|
| ROOT_PATHWAYS |
Root Pathways |
VARCHAR2 |
Information about if the tree was planted with rootpathways under hard structures such a sidewalks and walkways |
YesNoOnly |
Y |
No; Yes |
| SOIL_VOLUME_M3 |
Soil Volume (m3) |
NUMBER |
Soil volume around tree planting in cubic metres |
|
|
|
| PLANTED_BY |
Planted by |
VARCHAR2 |
Department or contractor that planted the tree |
TreePlantedBy |
|
CONTRACTOR - BOMAR LANDSCAPING; CONTRACTOR - CAMBRIDGE GARDEN CENTRE; CONTRACTOR - COPPER HILL GROUP; CONTRACTOR - JOHNS NURSERY LTD; CONTRACTOR - KLOMPS LANDSCAPING INC; CONTRACTOR - THE GORDON COMPANY; CONTRACTOR - TWIN CITY INTERLOC INC; FORESTRY; RESIDENT; UNKNOWN ...See GIS for a complete list... |
| MONTH_PLANTED |
Month Planted |
VARCHAR2 |
Month tree was planted |
TreeMonth |
|
AUGUST; DECEMBER; JANUARY; JULY; JUNE; MAY; NOVEMBER; OCTOBER; SEPTEMBER; UNKNOWN ...See GIS for a complete list... |
| YEAR_PLANTED |
Year Planted |
NUMBER |
Year Tree was planted. Only filled in for new trees, we have no history on older trees |
|
|
|
| STOCK_TYPE |
Stock Type |
VARCHAR2 |
Type of stock planted |
TreeStockType |
|
BALL AND BURLAP; BAREROOT; CONTAINER; UNKNOWN; WIRE BASKET |
| STOCK_SIZE |
Stock Size |
VARCHAR2 |
Size of stock planted. There are mixed units because the ones in cm are based on a height measurement (smaller tree stock), and the mm are based on a diameter measurement similar to DBH, but taken at a lower distance from the ground. |
TreeStockSize |
|
200 cm; 250 cm; 30 mm; 40 mm; 50 mm; 60 mm; 70 mm; 80 mm; < 30 mm |
| WARRANTYDATE |
Warranty Date |
TIMESTAMP(6) |
Warranty date of the tree. |
|
|
|
| INITIAL_ACCEPTANCE_DATE |
Initial Warranty Acceptance Date |
TIMESTAMP(6) |
Date warrany initial acceptance was given |
|
|
|
| FINAL_ACCEPTANCE_DATE |
Final Warranty Acceptance Date |
TIMESTAMP(6) |
Date warrany final acceptance was given |
|
|
|
| HEIGHT_ESTM_LIDAR_2014_M |
Estimated tree height from 2014 LiDAR (m) |
NUMBER |
Height estimate of tree as derived from 2014 LiDAR |
|
|
|
| HEIGHT_ESTM_LIDAR_2019_M |
Estimated tree height from 2019 LiDAR (m) |
NUMBER |
Height estimate of tree as derived from 2019 LiDAR |
|
|
|
| CREATE_BY |
Create By |
VARCHAR2 |
Database maintained field. Updates to the user name that created the feature. Update takes place when the feature is created. |
|
|
|
| CREATE_DATE |
Creation Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current data/time. Update takes place when the feature is created. |
|
|
|
| CREATE_YEAR |
Year Created |
VARCHAR2 |
Year the tree record was create. This is a database maintained feild |
|
|
|
| CREATE_MONTH |
Month Created |
VARCHAR2 |
Month the tree record was create. This is a database maintained feild |
TreeMonth |
|
AUGUST; DECEMBER; JANUARY; JULY; JUNE; MAY; NOVEMBER; OCTOBER; SEPTEMBER; UNKNOWN ...See GIS for a complete list... |
| UPDATE_BY |
Update By |
VARCHAR2 |
Database maintained field. Updates to the user name that most recently updated either an attribute or the geometry of the feature. Update takes place when the feature is created and/or changed. |
|
|
|
| UPDATE_DATE |
Update Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current data/time when an attribute or the geometry of the feature is changed. Update takes place when the feature is created and/or changed. |
|
|
|
| SOURCE |
Source |
VARCHAR2 |
GIS maintained field. Source EDRA (Electronic Document Registration Application) document number, or name of department or specific staff member that the information came from. |
TreeSource |
|
Cityworks Request; Correction; Road Reconstruction; Tree Inventory; Tree Planting Project |
| SOURCE_DATE |
Source Date |
TIMESTAMP(6) |
GIS maintained field. Date of the source document or information. |
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| TAG1 |
Tag1 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| GLOBALID |
GLOBALID |
CHAR |
ESRI system maintained field. It is a UUID (Universal Unique Identifier) in which values are automatically assigned by the geodatabase when a table row is created. |
|
|
|
| INSPECTED_YEAR |
Last Year tree was inspected |
VARCHAR2 |
Last year inspected, the year is transfered to this layer from tree inspection layer through a mobile app |
|
|
|
| SPECIES_GENUS |
SPECIES_GENUS |
VARCHAR2 |
Genus of tree |
|
|
|
| YEAR_PRUNED |
Last year tree was pruned |
NUMBER |
Last year tree was pruned as transfered from CW closed Work orders |
|
|
|
| PRUNING_BLOCK |
PRUNING_BLOCK |
NUMBER |
10 year planning cycle for tree pruning based on agregated planning communities |
|
|
|
| PRUNING_SUBBLOCK |
PRUNING_SUBBLOCK |
NUMBER |
Sequence of streets from west to east across pruning blocks to create smaller pruning areas |
|
|
|
| PRUNING_ROUTE |
PRUNING_ROUTE |
NUMBER |
Punning route + pruning block to create a route |
|
|
|
| HEIGHT_ESTM_LIDAR_2025_M |
HEIGHT_ESTM_LIDAR_2025_M |
NUMBER |
|
|
|
|
