From a 500-row sample across 45 columns.
stateboronameborocode+10stateboronameborocode+10stateboronametree_dbh+21binbblspc_latinMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| tree_id | block_id | created_at | tree_dbh | stump_diam | curb_loc | status | health | spc_latin | spc_common | steward | guards |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 180683 | 348711 | 2015-08-27T00:00:00.000 | 3 | 0 | OnCurb | Alive | Fair | Acer rubrum | red maple | None | None |
| 200540 | 315986 | 2015-09-03T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
tree_id | integer | Unique identification number for each tree point. | 0% | 478 |
block_id | integer | Identifier linking each tree to the block in the blockface table/shapefile that it is mapped on. | 0% | 204850602362208115 |
created_at | datetime | The date tree points were collected in the census software. | 0% | 2015-10-27T00:00:00.0002015-10-13T00:00:00.0002015-10-26T00:00:00.000 |
tree_dbh | integer | 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 | 0% |
GET /api/datasets/uvpi-gqnh GET /api/datasets/uvpi-gqnh/quality GET /api/datasets/uvpi-gqnh/related GET /api/columns?dataset=uvpi-gqnh
census_tractbinbbl+4census_tractbinbbl+4census_tractbinbbl+4| 21 |
| 0 |
| OnCurb |
| Alive |
| Fair |
| Quercus palustris |
| pin oak |
| None |
| None |
| 204026 | 218365 | 2015-09-05T00:00:00.000 | 3 | 0 | OnCurb | Alive | Good | Gleditsia triacanthos var. inermis | honeylocust | 1or2 | None |
| 204337 | 217969 | 2015-09-05T00:00:00.000 | 10 | 0 | OnCurb | Alive | Good | Gleditsia triacanthos var. inermis | honeylocust | None | None |
| 189565 | 223043 | 2015-08-30T00:00:00.000 | 21 | 0 | OnCurb | Alive | Good | Tilia americana | American linden | None | None |
| 190422 | 106099 | 2015-08-30T00:00:00.000 | 11 | 0 | OnCurb | Alive | Good | Gleditsia triacanthos var. inermis | honeylocust | 1or2 | Helpful |
| 190426 | 106099 | 2015-08-30T00:00:00.000 | 11 | 0 | OnCurb | Alive | Good | Gleditsia triacanthos var. inermis | honeylocust | 1or2 | Helpful |
| 208649 | 103940 | 2015-09-07T00:00:00.000 | 9 | 0 | OnCurb | Alive | Good | Tilia americana | American linden | None | None |
| 209610 | 407443 | 2015-09-08T00:00:00.000 | 6 | 0 | OnCurb | Alive | Good | Gleditsia triacanthos var. inermis | honeylocust | None | None |
| 192755 | 207508 | 2015-08-31T00:00:00.000 | 21 | 0 | OffsetFromCurb | Alive | Fair | Platanus x acerifolia | London planetree | None | None |
Showing 12 of 45 columns. All of them are listed below.
432stump_diam | integer | Diameter of stump measured through the center, rounded to the nearest inch. | 0% | 045 |
curb_loc | categorical | Location of tree bed in relationship to the curb; trees are either along the curb (OnCurb) or offset from the curb (OffsetFromCurb) | 0% | OnCurbOffsetFromCurbof 2 |
status | categorical | Indicates whether the tree is alive, standing dead, or a stump. | 0% | AliveStumpDeadof 3 |
health | categorical | Indicates the user's perception of tree health. | 5% | GoodFairPoorof 3 |
spc_latin | text | Scientific name for species, e.g. "Acer rubrum" | 5% | Platanus x acerifoliaGleditsia triacanthos va…Pyrus calleryana |
spc_common | text | Common name for species, e.g. "red maple" | 5% | London planetreehoneylocustCallery pear |
steward | categorical | Indicates the number of unique signs of stewardship observed for this tree. Not recorded for stumps or dead trees. | 5% | None1or23or4of 4 |
guards | categorical | 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. | 5% | NoneHelpfulHarmfulof 4 |
sidewalk | categorical | Indicates whether one of the sidewalk flags immediately adjacent to the tree was damaged, cracked, or lifted. Not recorded for dead trees and stumps. | 5% | NoDamageDamageof 2 |
user_type | categorical | This field describes the category of user who collected this tree point's data. | 0% | TreesCount StaffVolunteerNYC Parks Staffof 3 |
problems | text | — | 5% | NoneStonesBranchLights |
root_stone | categorical | Indicates the presence of a root problem caused by paving stones in tree bed | 0% | NoYesof 2 |
root_grate | categorical | Indicates the presence of a root problem caused by metal grates in tree bed | 0% | NoYesof 2 |
root_other | categorical | Indicates the presence of other root problems | 0% | NoYesof 2 |
trunk_wire | categorical | Indicates the presence of a trunk problem caused by wires or rope wrapped around the trunk | 0% | NoYesof 2 |
trnk_light | categorical | Indicates the presence of a trunk problem caused by lighting installed on the tree | 0% | NoYesof 2 |
trnk_other | categorical | Indicates the presence of other trunk problems | 0% | NoYesof 2 |
brch_light | categorical | Indicates the presence of a branch problem caused by lights (usually string lights) or wires in the branches | 0% | NoYesof 2 |
brch_shoe | categorical | Indicates the presence of a branch problem caused by sneakers in the branches | 0% | NoYesof 2 |
brch_other | categorical | Indicates the presence of other branch problems | 0% | NoYesof 2 |
address | text | Nearest estimated address to tree | 0% | 106 CROSS BAY BOULEVARD2 TELEPORT DRIVE2350 FOREST HILL ROAD |
zipcode | integer | Five-digit zipcode in which tree is located | 0% | 103121031410306 |
zip_city | text | City as derived from zipcode. This is often (but not always) the same as borough. | 0% | BrooklynStaten IslandBronx |
cb_num | integer | Community board in which tree point is located | 0% | 503413407 |
borocode | categorical | Code for borough in which tree point is located: 1 (Manhattan), 2 (Bronx), 3 (Brooklyn), 4 (Queens), 5 (Staten Island) | 0% | 435of 5 |
boroname | categorical | Name of borough in which tree point is located | 0% | QueensBrooklynStaten Islandof 5 |
cncldist | integer | Council district in which tree point is located | 0% | 511950 |
st_assem | integer | State Assembly District in which tree point is located | 0% | 622664 |
st_senate | integer | State Senate District in which tree point is located | 0% | 241115 |
nta | text | This is the NTA Code corresponding to the neighborhood tabulation area from the 2010 US Census that the tree point falls into. | 0% | SI01SI54QN46 |
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. | 0% | Annadale-Huguenot-Prince…Great KillsBayside-Bayside Hills |
boro_ct | integer | This is the boro_ct identifyer for the census tract that the tree point falls into. | 0% | 502080150176005020803 |
state | text | All features given value 'New York' | 0% | New Yorkof 1 |
latitude | float | Latitude of point, in decimal degrees | 0% | 40.6603593840.6109770940.689461 |
longitude | float | Longitude of point, in decimal degrees | 0% | -73.76103529-74.15686098-73.95680062 |
x_sp | float | X coordinate, in state plane. Units are feet. | 0% | 1050549.648940697.4014996243.4593 |
y_sp | float | Y coordinate, in state plane. Units are feet | 0% | 179953.5509161910.8114190562.4395 |
council_district | integer | — | 1% | 511950 |
census_tract | integer | — | 1% | 20801176198 |
bin | integer | — | 1% | 400000030000002000000 |
bbl | integer | — | 1% | 205141012041537500201009720001 |