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

1995 Street Tree Census

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

Quality

C75.5 / 100

From a 500-row sample across 35 columns.

completeness98/ 25% weight
consistency69/ 20% weight
accuracy96/ 20% weight
timeliness0/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • 2005 Street Tree Census0.70
    joins onbbl:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+9
  • NewYorkCity_StreetTreeCensus_20050.59
    joins onlatitudeaddressspc_common+2
  • Food Scrap Drop-Off Locations in NYC0.33
    joins onbbl:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+8
  • Forestry Work Orders0.32
    joins on

Geography

Mappable — Socrata point column `location`.

Open on the map →

Sample rows

recordidaddresshouse_numberstreetzip_originalcb_originalsitespeciesdiameterconditionwiressidewalk_condition
1245 E 17 ST245E 17 ST10003106FrontPLAC8UnknownNoneNA
280 N MOORE ST80

Columns

30 queryable · 29 profiled

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

FieldTypeDescriptionNullValues
recordidintegerA unique identifier for each record in the table. Does not correspond to other datasets or identify the tree itself.0%415390461061366961
addresstextAddress of the tree.0%761 JANSEN ST255 LUTON AV83-015 KEW GARDENS RD
house_numberintegerNumerical portion of the address.43%21520
streettextStreet where address for tree is located.0%BROADWAY78 ST5 AV

Query this from your own app

GET /api/datasets/kyad-zm4j
GET /api/datasets/kyad-zm4j/quality
GET /api/datasets/kyad-zm4j/related
GET /api/columns?dataset=kyad-zm4j
bbl
:@computed_region_92fq_4b7q
:@computed_region_yeji_bk3q
+6
  • Forestry Tree Points0.32
    joins on:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q:@computed_region_efsh_h5xi+3
  • 2015 Street Tree Census - Tree Data0.32
    joins onbbllatitudeaddress+5
  • ARCHIVED - NYC Greenthumb Community Gardens0.31
    joins onbbllatitudeaddress+3
  • DSNY Litter Basket Inventory0.30
    joins on:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q:@computed_region_efsh_h5xi+5
    • N MOORE ST
    10013
    101
    Side
    ACPL
    7
    Good
    None
    Good
    380 N MOORE ST80N MOORE ST10013101SideACPL6GoodNoneGood
    480 N MOORE ST80N MOORE ST10013101SideACPL7ExcellentNoneGood
    580 N MOORE ST80N MOORE ST10013101SideACPL6GoodNoneGood
    680 N MOORE ST80N MOORE ST10013101SideSOJA6GoodNoneGood
    780 N MOORE ST80N MOORE ST10013101SideACPL7ExcellentNoneGood
    880 N MOORE ST80N MOORE ST10013101SideACPL7PoorNoneGood
    980 N MOORE ST80N MOORE ST10013101SideSOJA4PoorNoneGood
    1080 N MOORE ST80N MOORE ST10013101SideACPL7PoorNoneGood

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

    zip_original
    integer
    The zip code originally geocoded to the address using LION 02A
    0%
    103121031411385
    cb_originalintegerThe community board originally geocoded to the address using LION 02A0%503413407
    sitecategoricalThis field clarifies the position relative to the address for trees not located in the front of buildings.0%FrontSideAdjacentof 14
    speciestextSpecies of the tree using a four-letter code, comprised of the first two letters of the genus followed by the first two letters of the species.0%ACPLPLACQUPA
    diameterintegerDiameter of the tree as measured at approximately 4.5 feet from the ground.0%436
    conditioncategoricalOverall tree condition.0%GoodExcellentPoorof 10
    wirescategoricalWhether the tree is located under utility wires0%NoneYesSecondaryof 3
    sidewalk_conditioncategoricalWhether the tree roots have lifted the adjacent sidewalk.0%GoodRaisedNAof 3
    support_structurecategoricalWhether the tree has support structures installed.0%NoneStakes / WiresGuard Stranglingof 4
    boroughcategoricalBorough where tree was recorded.0%QueensBrooklynStaten Islandof 5
    xfloatX coordinate of point in the NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet coordinate system, geocoded using LION 02A0%1931577.56371034344.665
    yfloatY coordinate of point in the NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet coordinate system, geocoded using LION 02A0%1130501.5326200582.2901
    longitudefloatLongitude of point in decimal degrees as geocoded using LION 02A0%1-74.189463-73.81929
    latitudefloatLatitude of point in decimal degrees as geocoded using LION 02A0%140.52471540.717087
    cb_newintegerCommunity Board geocoded to the address using Geosupport 11.40%503413407
    zip_newintegerZip Code geocoded to the address using Geosupport 11.40%01031210314
    censustract_2010integer2010 Census Tract geocoded to the address using Geosupport 11.45%17619820801
    censusblock_2010integer2010 Census Block geocoded to the address using Geosupport 11.45%200010002001
    nta_2010textNeighborhood Tabulation Area geocoded to the address using Geosupport 11.40%UnknownSI01QN55
    segmentidintegerLION SegmentID geocoded to the address using Geosupport 11.40%0278349596
    spc_commontextThis is the common name for the species of this tree.0%MAPLE, NORWAYLONDON PLANETREEOAK, PIN
    spc_latintextThis is the latin/scientific name for the species of this tree.0%ACER PLATANOIDESPLATANUS ACERIFOLIAQUERCUS PALUSTRIS
    locationcoordinate———
    council_districtinteger—46%515046
    bininteger—50%300000020000001000000
    bblinteger—50%205141012010097200015066080055