About this Dataset

1995 Street Tree Census

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.
Organization: City of New York
Last updated: 2020-11-10T17:04:01.646503
Tags: census, inventory, parks, recreation, trees, volunteers

Tables

Table 1

@usgov.city_of_new_york_1995_street_tree_census.table_1

27.62 MB
516,989 rows
30 columns

CREATE TABLE table_1 (
  "recordid" BIGINT,
  "address" VARCHAR,
  "house_number" DOUBLE,
  "street" VARCHAR,
  "postcode_original" BIGINT,
  "community_board_original" BIGINT,
  "site" VARCHAR,
  "species" VARCHAR,
  "diameter" BIGINT,
  "condition" VARCHAR,
  "wires" VARCHAR,
  "sidewalk_condition" VARCHAR,
  "support_structure" VARCHAR,
  "borough" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "cb_new" BIGINT,
  "zip_new" BIGINT,
  "censustract_2010" DOUBLE,
  "censusblock_2010" DOUBLE,
  "nta_2010" VARCHAR,
  "segmentid" BIGINT,
  "spc_common" VARCHAR,
  "spc_latin" VARCHAR,
  "location" VARCHAR,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE
);