DataJam - NYC TreesCount! 2015 Data Dictionary, final release
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEF
1
FieldField Name as it appears in DatasetData Field SourceTypeDescriptionNotes
2
Unique Tree ID Numbertree_idAutomatically generated by 2015 census softwareLong IntegerUnique identification number for each tree point.This number is automatically assigned by the TreesCount software and is used to identify the tree point. It specifically identifies data entered by a specific user on a specific survey, not the tree itself - so if a survey is found to be inaccurate and the block is re-surveyed, the ID numbers assigned to each tree point will not be re-used. Note that the identification number assigned to each tree is not consistent between surveys, so this number cannot be used to join a tree from the 2015 census to the same tree from 2005 or 1995.
3
Identification number of the blockface that the tree is mapped onblock_idUser collected data in the 2015 censusLong IntegerIdentifier linking each tree to the block in the blockface table/shapefile that it is mapped on.At the beginning of each block survey, the user chooses the blockface on which they are mapping. The tree points collected during this survey are applied to a geographic feature called a blockface, which is a slightly simplified curb line that usually represents the curb line for one side of a street between two intersections.
4
Date trees were mappedcreated_atAutomatically generated by 2015 census softwareDateThe date tree points were collected in the census software.In the event trees were mapped on paper and entered into the software at a later time, this date is for the time data entry was completed. The same creation date is applied to all trees on a given block.
5
Diameter at breast height of treetree_dbhUser collected data in the 2015 census, subsequently processedShort IntegerDiameter of the tree, measured at approximately 54" / 137cm above the ground. Data was collected for both living and dead trees; for stumps, use stump_diamBecause standard measuring tapes are more accessible than forestry-specific measuring tapes designed to measure diameter, users originally measured tree circumference in the field. To better match other forestry datasets, this circumference value was subsequently divided by 3.14159 to transform it to diameter. Both the field measurement and processed value were rounded to the nearest whole inch.
6
Diameter of stumpstump_diamUser collected data in the 2015 censusShort IntegerDiameter of stump measured through the center, rounded to the nearest inch.Only applies to records where "status" is "Stump." Diameter can be directly measured on stumps since a flat cross-section is accessible.
7
Whether tree is along or offset from the curbcurb_locUser collected data in the 2015 censusDomain Values:
OnCurb
OffsetFromCurb
Location of tree bed in relationship to the curb; trees are either along the curb (OnCurb) or offset from the curb (OffsetFromCurb)A tree identified as being on the curb will have the point placed 2.5 feet from the blockface line; a tree identified as being offset will have the point placed 12 feet from the curb line.
8
Tree StatusstatusUser collected data in the 2015 censusDomain Values:
Alive
Dead
Stump
Indicates whether the tree is alive, standing dead, or a stump.
9
Tree HealthhealthUser collected data in the 2015 censusDomain Values:
Good
Fair
Poor
Indicates the user's perception of tree health.Field left blank if the tree is dead or stump.
10
Scientific / latin name of tree speciesspc_latinUser collected data in the 2015 censusTextScientific name for species, e.g. "Acer rubrum"For a list of common tree species found and planted in New York City, visit:
https://www.nycgovparks.org/trees/street-tree-planting/species-list
11
Common name of tree speciesspc_commonUser collected data in the 2015 censusTextCommon name for species, e.g. "red maple"For a list of common tree species found and planted in New York City, visit:
https://www.nycgovparks.org/trees/street-tree-planting/species-list
12
Number of signs of stewardship observedstewardUser collected data in the 2015 censusDomain Values:
1or2
3or4
4orMore
None
Indicates the number of unique signs of stewardship observed for this tree. Not recorded for stumps or dead trees.Information on how users were trained to identify signs of stewardship can be found in the 'Training' Section of http://treescount.nycgovparks.org or in the training PDF found here: https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
Below is a short list of the most common examples of what counts as one stewardship activity:
-Helpful tree guards that do not appear professionally installed
-Mulch or woodchips
-Intentionally-planted flowers or other plants
-Signs related to care of the tree or bed, other than those installed by Parks
-Decorations (not including wires or lights added to the tree)
-Seating in the tree bed, usually as part of the tree guard
-Viewing someone performing a stewardship activity during the survey
13
Presence and type of tree guardguardsUser collected data in the 2015 censusDomain Values:
Harmful
Helpful
None
Unsure
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.Values Harmful, Helpful, and Unsure all indicate that a tree guard is present. A tree guard is considered 'helpful' if it doesn't impede water getting to the tree and does not raise the soil level or trap debris in the pit. A full description of helpful and harmful tree guards can be found here: https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
14
Sidewalk damage immediately adjacent to treesidewalkUser collected data in the 2015 censusDomain Values:
Damage
NoDamage
Indicates whether one of the sidewalk flags immediately adjacent to the tree was damaged, cracked, or lifted. Not recorded for dead trees and stumps.Refer to the training PDF for more information on how users were instructed to define sidewalk damage:
https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
15
Category of user who collected this tree pointuser_typeAutomatically generated by 2015 census software, processedDomain Values:
Volunteer
TreesCount Staff
NYC Parks Staff
This field describes the category of user who collected this tree point's data.A 'volunteer' is an unpaid individual who participated in the tree census without being professionally affiliated to NYC Parks. This can include independent mappers, mapping event participants, and members or staff of census partner groups.
'TreesCount Staff' are paid staff hired specifically to assist in the 2015 Street Tree Census, and includes paid data collection staff, event staff, and support staff.
'NYC Parks Staff' are full or part time staff working for NYC Parks who were not explicitly hired to assist with the tree census. All users who identified as Parks Staff are included in this category, whether their participation was part of their paid duties or on their own time.
16
Root problems caused by paving stones in the tree bedroot_stoneUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of a root problem caused by paving stones in tree bedFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
17
Root problems caused by metal gratesroot_grateUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of a root problem caused by metal grates in tree bedFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
18
Presence of other root problemsroot_otherUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of other root problemsFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
19
Trunk problems caused by rope or wirestrunk_wireUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of a trunk problem caused by wires or rope wrapped around the trunkFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
20
Trunk problems caused by lightstrnk_lightUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of a trunk problem caused by lighting installed on the treeFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
21
Presence of other trunk problemstrnk_otherUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of other trunk problemsFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
22
Branch problems caused by lights or wiresbrch_lightUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of a branch problem caused by lights (usually string lights) or wires in the branchesFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
23
Branch problems caused by shoesbrch_shoeUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of a branch problem caused by sneakers in the branchesFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
24
Presence of other branch problemsbrch_otherUser collected data in the 2015 census, subsequently processedDomain Values:
Yes
No
Indicates the presence of other branch problemsFor more information about this issue, consult the training PDF available at https://treescount.nycgovparks.org/static/training/TreesCount2015Training.pdf
25
Estimated street address of treeaddressGeocoded based on tree point locationTextStreet address tree is estimated to be nearestThis field is generated by joining a tree point's geometric location to the nearest address point, using the publicly-available DOITT Address Point file found here: https://data.cityofnewyork.us/City-Government/NYC-Address-Points/4iq4-tuhq
26
Zipcode tree point is inzipcodeGeocoded based on tree point locationLong IntegerFive-digit zipcode tree is located in. Note that zipcode is derived by comparing the tree's physical location to a zipcode polygon file, not geocoded using the estimated address.
27
City, as derived from zipcodezip_cityGeocoded based on tree point locationTextCity as derived from zipcode. This is often (but not always) the same as borough. This is also the 'Post Office Name,' or PO_NAME in the original zipcode file.
28
Community board tree point is incb_numGeocoded based on tree point locationShort IntegerCommunity board tree point falls in. Note that community board is derived by comparing the tree's physical location to a community board polygon file, not geocoded using the estimated address.
29
Numeric code of borough tree is inborocodeGeocoded based on tree point locationShort Integer Domain values:
1 (Manhattan)
2 (Bronx)
3 (Brooklyn)
4 (Queens)
5 (Staten Island)
Borough tree point falls in
30
Name of borough tree point is inboronameGeocoded based on tree point locationDomain Values:
Manhattan
Bronx
Brooklyn
Queens
Staten Island
Borough tree point falls in
31
New York City Council District tree point is incncldistGeocoded based on tree point locationShort IntegerCouncil district tree point falls in
32
State Assembly District tree point is inst_assemGeocoded based on tree point locationShort IntegerState Assembly District tree point is in
33
State Senate District tree point is inst_senateGeocoded based on tree point locationShort IntegerState Senate District tree point is in
34
Neighborhood Tabulation Area CodentaGeocoded based on tree point locationTextThis is the NTA Code corresponding to the neighborhood tabulation area from the 2010 US Census that the tree point falls into.
35
Neighborhood tabulation area namenta_nameGeocoded based on tree point locationTextThis is the NTA name corresponding to the neighborhood tabulation area from the 2010 US Census that the tree point falls into.This is intended to help users of this dataset who would like to aggregate trees by neighborhood.
36
Census Tractboro_ctGeocoded based on tree point locationLong IntegerThis is the boro_ct identifyer for the census tract that the tree point falls into.Geocoding for census tract uses the census tracts developed by the Department of City Planning, which are slightly adjusted to better align ot the street grid. That file is available here: https://data.cityofnewyork.us/City-Government/2010-Census-Tracts/fxpq-c8ku
37
StatestateField Calculated for All ValuesTextAll features given value 'New York'
38
Latitude of tree pointlatitudeAutomatically generated by 2015 census softwareDoubleLatitude of point, in decimal degreeslatitude of the point in the coordinate system GCS_WGS_1984. In decimal degrees. This coordinate is appropriate for use in web mapping software.
39
Longitude of tree pointlongitudeAutomatically generated by 2015 census softwareDoubleLongitude of point, in decimal degreeslongitude of the point in the coordinate system GCS_WGS_1984. In decimal degrees. This coordinate is appropriate for use in web mapping software.
40
X coordinate of tree pointx_spAutomatically generated by 2015 census softwareDoubleX coordinate, in state plane. Units are feet.X coordinate of point in the coordinate system NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet. This is the coordinate system used by a majority of geographic data files available on the NYC open data portal. For more information about state plane, visit http://www.ngs.noaa.gov/TOOLS/spc.shtml
41
Y coordinate of tree pointy_spAutomatically generated by 2015 census softwareDoubleY coordinate, in state plane. Units are feetY coordinate of point in the coordinate system NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet. This is the coordinate system used by a majority of geographic data files available on the NYC open data portal. For more information about state plane, visit http://www.ngs.noaa.gov/TOOLS/spc.shtml
Loading...
 
 
 
Trees
Blockfaces