Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

NewYorkCity_StreetTreeCensus_2005

urik-ndegEnvironment49 columns
Citywide street tree data from the 2005 Street Tree Census, conducted partly by volunteers organized by NYC Parks & Recreation. Trees were inventoried by address, and were collected from 2005-2006. Data collected includes tree species, diameter, condition.
View on NYC Open Data↗

Quality

B82.1 / 100

From a 500-row sample across 49 columns.

completeness100/ 25% weight
consistency87/ 20% weight
accuracy91/ 20% weight
timeliness11/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • 2005 Street Tree Census0.81
    joins onstatusinf_lightsvert_tgrd+44
  • 1995 Street Tree Census0.59
    joins onlongitudeaddresslatitude+2
  • layer_10.50
    joins onthe_geomzip_citystate+10
  • 2015 Street Tree Census - Blockface Data0.47

Geography

Mappable — Socrata point column `the_geom`.

Open on the map →

Sample rows

tree_dbhcen_yearthe_geomaddresstree_locpit_typesoil_lvlstatusspc_latinspc_commonvert_othervert_pgrd
6200540.63265, -74.000241139 57 STREETFrontSidewalk PitLevelGoodPYRUS CALLERYANAPEAR, CALLERYNoNo
62005

Columns

49 queryable · 49 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
tree_dbhinteger—0%345
cen_yearcategorical—0%200520060of 3
the_geomcoordinate—0%{'coordinates': [-77.519…{'coordinates': [-73.825…{'coordinates': [-74.187…
addresstext—0%2605 FLATBUSH AVENUE EXT…201 EDWARD CURRY AVENUE

Query this from your own app

GET /api/datasets/urik-ndeg
GET /api/datasets/urik-ndeg/quality
GET /api/datasets/urik-ndeg/related
GET /api/columns?dataset=urik-ndeg
joins onzip_citystatest_assem+9
  • 2015 Street Tree Census - Tree Data0.39
    joins onstatuszip_citytree_dbh+18
  • Forestry Work Orders0.28
    joins onlongitudelatitudezipcode+1
  • Energy Usage From DOE Buildings0.28
    joins onlongitudelatitudenta
  • Natural Gas Consumption by ZIP Code - 20100.28
  • 40.62008, -73.90145
    2220 BERGEN AVENUE
    Across
    Sidewalk Pit
    Level
    Good
    PLATANUS ACERIFOLIA
    LONDON PLANETREE
    No
    No
    13200540.61800, -73.899112360 BERGEN AVENUEFrontContinuous PitLevelGoodACER PLATANOIDES CRIMSON KINGMAPLE, NORWAY-CR KNGNoNo
    13200540.61969, -73.901002254 BERGEN AVENUEAcrossSidewalk PitLevelGoodPLATANUS ACERIFOLIALONDON PLANETREENoNo
    15200540.61832, -73.899472332 BERGEN AVENUEAcrossSidewalk PitLevelGoodPLATANUS ACERIFOLIALONDON PLANETREENoNo
    21200540.61609, -73.902042361 EAST 72 STREETFrontSidewalk PitLevelPoorPLATANUS ACERIFOLIALONDON PLANETREENoNo
    19200540.61423, -73.902422409 EAST 70 STREETFrontContinuous PitLevelGoodPLATANUS ACERIFOLIALONDON PLANETREENoNo
    11200540.61846, -73.915901481 EAST 63 STREETFrontLawnLevelExcellentPLATANUS ACERIFOLIALONDON PLANETREENoNo
    14200540.61849, -73.915931461 EAST 63 STREETFrontLawnLevelExcellentACER PLATANOIDES CRIMSON KINGMAPLE, NORWAY-CR KNGNoNo
    3200540.63242, -73.999871163 57 STREETFrontLawnLevelGoodCRATAEGUS SPECIESHAWTHORN, OTHERNoYes

    Showing 12 of 49 columns. All of them are listed below.

    138-84 63 AVENUE
    tree_loccategorical—0%FrontSideAcrossof 9
    pit_typecategorical—0%Sidewalk PitLawnContinuous Pitof 3
    soil_lvlcategorical—0%LevelAboveBelowof 3
    statuscategorical—0%GoodExcellentPoorof 4
    spc_latintext—0%PLATANUS ACERIFOLIAACER PLATANOIDESPYRUS CALLERYANA
    spc_commontext—0%LONDON PLANETREEMAPLE, NORWAYPEAR, CALLERY
    vert_othercategorical—0%NoYesof 2
    vert_pgrdcategorical—0%NoYesof 2
    vert_tgrdcategorical—0%NoYesof 2
    vert_wallcategorical—0%NoYesof 2
    horz_blckcategorical—0%NoYesof 2
    horz_gratecategorical—0%NoYesof 2
    horz_plantcategorical—0%NoYesof 2
    horz_othercategorical—0%NoYesof 2
    sidw_crackcategorical—0%NoYesof 2
    sidw_raisecategorical—0%NoYesof 2
    wire_htapcategorical—0%NoYesof 2
    wire_primecategorical—0%NoYesof 2
    wire_2_ndcategorical—0%NoYesof 2
    wire_othercategorical—0%NoYesof 2
    inf_canopycategorical—0%NoYesof 2
    inf_guardcategorical—0%NoYesof 2
    inf_wirescategorical—0%NoYesof 2
    inf_pavingcategorical—0%NoYesof 2
    inf_outletcategorical—0%NoYesof 2
    inf_shoescategorical—0%NoYesof 2
    inf_lightscategorical—0%NoYesof 2
    inf_othercategorical—0%NoYesof 2
    trunk_dmgcategorical—1%NoneTrunk WoundTorn Barkof 4
    zipcodeinteger—0%103121031410309
    zip_citytext—2%BrooklynStaten IslandBronx
    cb_numinteger—0%503413407
    borocodecategorical—0%430of 5
    boronamecategorical—0%QueensBrooklyn5of 5
    cncldistinteger—0%511923
    st_senateinteger—0%241115
    ntatext—4%SI01QN46SI54
    st_asseminteger—0%62260
    nta_nametext—4%Annadale-Huguenot-Prince…Bayside-Bayside HillsGreat Kills
    boro_ctinteger—0%040892004157101
    statetext—0%New Yorkof 1
    latitudefloat—0%040.693684953340.6256126489
    longitudefloat—0%0-73.9833391559-74.1473106299
    x_spinteger—0%01032648932058
    y_spinteger—0%0208809162068