Readme
Updated 15 days ago
‧ Indexed 3 hours ago
2015 Street Tree Census - Tree Data
Street tree data from the TreesCount! 2015 Street Tree Census, conducted by volunteers and staff organized by NYC Parks & Recreation and partner organizations. Tree data collected includes tree species, diameter and perception of health. Accompanying blockface data is available indicating status of data collection and data release citywide.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| census tract | census_tract | census_tract | Number | |
| zip_city | zip_city | zip_city | Text | City as derived from zipcode. This is often (but not always) the same as borough. |
| community board | cb_num | cb_num | Number | Community board in which tree point is located |
| borough | boroname | boroname | Text | Name of borough in which tree point is located |
| cncldist | cncldist | cncldist | Number | Council district in which tree point is located |
| st_assem | st_assem | st_assem | Number | State Assembly District in which tree point is located |
| st_senate | st_senate | st_senate | Number | State Senate District in which tree point is located |
| nta | nta | nta | Text | This is the NTA Code corresponding to the neighborhood tabulation area from the 2010 US Census that the tree point falls into. |
| nta_name | nta_name | nta_name | Text | This is the NTA name corresponding to the neighborhood tabulation area from the 2010 US Census that the tree point falls into. |
| boro_ct | boro_ct | boro_ct | Number | This is the boro_ct identifyer for the census tract that the tree point falls into. |
| state | state | state | Text | All features given value 'New York' |
| latitude | latitude | latitude | Number | Latitude of point, in decimal degrees |
| longitude | longitude | longitude | Number | Longitude of point, in decimal degrees |
| x_sp | x_sp | x_sp | Number | X coordinate, in state plane. Units are feet. |
| y_sp | y_sp | y_sp | Number | Y coordinate, in state plane. Units are feet |
| council district | council_district | council_district | Number | |
| bin | bin | bin | Number | |
| bbl | bbl | bbl | Number | |
| brch_light | brch_light | brch_light | Text | Indicates the presence of a branch problem caused by lights (usually string lights) or wires in the branches |
| trnk_other | trnk_other | trnk_other | Text | Indicates the presence of other trunk problems |
| trnk_light | trnk_light | trnk_light | Text | Indicates the presence of a trunk problem caused by lighting installed on the tree |
| trunk_wire | trunk_wire | trunk_wire | Text | Indicates the presence of a trunk problem caused by wires or rope wrapped around the trunk |
| root_other | root_other | root_other | Text | Indicates the presence of other root problems |
| root_stone | root_stone | root_stone | Text | Indicates the presence of a root problem caused by paving stones in tree bed |
| problems | problems | problems | Text | |
| user_type | user_type | user_type | Text | This field describes the category of user who collected this tree point's data. |
| sidewalk | sidewalk | sidewalk | Text | Indicates whether one of the sidewalk flags immediately adjacent to the tree was damaged, cracked, or lifted. Not recorded for dead trees and stumps. |
| guards | guards | guards | Text | Indicates whether a guard is present, and if the user felt it was a helpful or harmful guard. Not recorded for dead trees and stumps. |
| steward | steward | steward | Text | Indicates the number of unique signs of stewardship observed for this tree. Not recorded for stumps or dead trees. |
| spc_common | spc_common | spc_common | Text | Common name for species, e.g. "red maple" |
| spc_latin | spc_latin | spc_latin | Text | Scientific name for species, e.g. "Acer rubrum" |
| health | health | health | Text | Indicates the user's perception of tree health. |
| status | status | status | Text | Indicates whether the tree is alive, standing dead, or a stump. |
| curb_loc | curb_loc | curb_loc | Text | Location of tree bed in relationship to the curb; trees are either along the curb (OnCurb) or offset from the curb (OffsetFromCurb) |
| stump_diam | stump_diam | stump_diam | Number | Diameter of stump measured through the center, rounded to the nearest inch. |
| tree_dbh | tree_dbh | tree_dbh | Number | Diameter of the tree, measured at approximately 54" / 137cm above the ground. Data was collected for both living and dead trees; for stumps, use stump_diam |
| created_at | created_at | created_at | Calendar date | The date tree points were collected in the census software. |
| block_id | block_id | block_id | Number | Identifier linking each tree to the block in the blockface table/shapefile that it is mapped on. |
| tree_id | tree_id | tree_id | Number | Unique identification number for each tree point. |
| borocode | borocode | borocode | Number | Code for borough in which tree point is located: 1 (Manhattan), 2 (Bronx), 3 (Brooklyn), 4 (Queens), 5 (Staten Island) |
| root_grate | root_grate | root_grate | Text | Indicates the presence of a root problem caused by metal grates in tree bed |
| brch_shoe | brch_shoe | brch_shoe | Text | Indicates the presence of a branch problem caused by sneakers in the branches |
| brch_other | brch_other | brch_other | Text | Indicates the presence of other branch problems |
| address | address | address | Text | Nearest estimated address to tree |
| postcode | zipcode | zipcode | Number | Five-digit zipcode in which tree is located |
Upstream Metadata