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

2005 Street Tree Census

29bw-z7pjEnvironment63 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

B80.4 / 100

From a 500-row sample across 59 columns.

completeness100/ 25% weight
consistency81/ 20% weight
accuracy97/ 20% weight
timeliness0/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • 1995 Street Tree Census0.70
    joins onaddress:@computed_region_f5dn_yrerbbl+9
  • 2015 Street Tree Census - Tree Data0.36
    joins onst_assemaddressnta+21
  • Forestry Work Orders0.35
    joins on:@computed_region_f5dn_yrerntaobjectid+10
  • Energy Usage From DOE Buildings0.31

Geography

Mappable — Socrata point column `location_1`.

Open on the map →

Sample rows

objectidcen_yeartree_dbhaddresstree_locpit_typesoil_lvlstatusspc_latinspc_commonvert_othervert_pgrd
592373200561139 57 STREETFrontSidewalk PitLevelGoodPYRUS CALLERYANAPEAR, CALLERYNoNo
59237420056

Columns

54 queryable · 53 profiled

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

FieldTypeDescriptionNullValues
objectidinteger—0%8478356161331090787
cen_yearcategorical—0%200520060of 3
tree_dbhinteger—0%345
addresstext—0%2605 FLATBUSH AVENUE EXT…201 EDWARD CURRY AVENUE138-84 63 AVENUE
tree_loccategorical

Query this from your own app

GET /api/datasets/29bw-z7pj
GET /api/datasets/29bw-z7pj/quality
GET /api/datasets/29bw-z7pj/related
GET /api/columns?dataset=29bw-z7pj
joins onntabbllatitude+3
  • ARCHIVED - NYC Greenthumb Community Gardens0.31
    joins onaddressntabbl+4
  • Forestry Tree Points0.31
    joins on:@computed_region_f5dn_yrerobjectid:@computed_region_efsh_h5xi+3
  • Food Scrap Drop-Off Locations in NYC0.29
    joins on:@computed_region_f5dn_yrerbbl:@computed_region_efsh_h5xi+6
  • DSNY Litter Basket Inventory0.29
    joins on:@computed_region_f5dn_yrerobjectid:@computed_region_efsh_h5xi+5
    • 2220 BERGEN AVENUE
    Across
    Sidewalk Pit
    Level
    Good
    PLATANUS ACERIFOLIA
    LONDON PLANETREE
    No
    No
    5923752005132360 BERGEN AVENUEFrontContinuous PitLevelGoodACER PLATANOIDES CRIMSON KINGMAPLE, NORWAY-CR KNGNoNo
    5923762005132254 BERGEN AVENUEAcrossSidewalk PitLevelGoodPLATANUS ACERIFOLIALONDON PLANETREENoNo
    5923772005152332 BERGEN AVENUEAcrossSidewalk PitLevelGoodPLATANUS ACERIFOLIALONDON PLANETREENoNo
    5923782005212361 EAST 72 STREETFrontSidewalk PitLevelPoorPLATANUS ACERIFOLIALONDON PLANETREENoNo
    5923792005192409 EAST 70 STREETFrontContinuous PitLevelGoodPLATANUS ACERIFOLIALONDON PLANETREENoNo
    5923802005111481 EAST 63 STREETFrontLawnLevelExcellentPLATANUS ACERIFOLIALONDON PLANETREENoNo
    5923812005141461 EAST 63 STREETFrontLawnLevelExcellentACER PLATANOIDES CRIMSON KINGMAPLE, NORWAY-CR KNGNoNo
    592382200531163 57 STREETFrontLawnLevelGoodCRATAEGUS SPECIESHAWTHORN, OTHERNoYes

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

    —
    0%
    FrontSideAcrossof 9
    pit_typecategorical—0%Sidewalk PitLawnContinuous Pitof 4
    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_2ndcategorical—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—0%NoneTrunk WoundTorn Barkof 5
    zipcodetext—0%103121031410309
    zip_citytext—2%BrooklynStaten IslandBronx
    cb_numinteger—0%503413407
    borocodecategorical—0%435of 5
    boronamecategorical—0%QueensBrooklyn5of 5
    cncldistinteger—0%511923
    st_asseminteger—0%62260
    st_senateinteger—0%241115
    ntatext—0% SI01QN46
    nta_nametext—0% Annadale-Huguenot-Prince…Bayside-Bayside Hills
    boro_ctinteger—18%408920041571014157901
    statetext—0%New Yorkof 1
    latitudefloat—0%040.6936849540.62561265
    longitudefloat—0%0-73.98333916-74.14731063
    x_spinteger—0%01032648932058
    y_spinteger—0%0208809162068
    objectid_1integer—0%415390461061366961
    census_tractinteger—4%17619820801
    bininteger—8%400000030000002000000
    bblinteger—8%205141012010097200014067150002
    location_1coordinate———