About this Dataset

NewYorkCity StreetTreeCensus 2005

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.
Organization: City of New York
Last updated: 2024-02-09T16:43:47.924247
Tags: census, dpr, parks, recreation, trees

Tables

Table 1

@usgov.city_of_new_york_newyorkcity_streettreecensus_2005.table_1

28.77 MB
592,372 rows
49 columns

CREATE TABLE table_1 (
  "tree_dbh" BIGINT,
  "cen_year" BIGINT,
  "the_geom" VARCHAR,
  "address" VARCHAR,
  "tree_loc" VARCHAR,
  "pit_type" VARCHAR,
  "soil_lvl" VARCHAR,
  "status" VARCHAR,
  "spc_latin" VARCHAR,
  "spc_common" VARCHAR,
  "vert_other" VARCHAR,
  "vert_pgrd" VARCHAR,
  "vert_tgrd" VARCHAR,
  "vert_wall" VARCHAR,
  "horz_blck" VARCHAR,
  "horz_grate" VARCHAR,
  "horz_plant" VARCHAR,
  "horz_other" VARCHAR,
  "sidw_crack" VARCHAR,
  "sidw_raise" VARCHAR,
  "wire_htap" VARCHAR,
  "wire_prime" VARCHAR,
  "wire_2nd" VARCHAR,
  "wire_other" VARCHAR,
  "inf_canopy" VARCHAR,
  "inf_guard" VARCHAR,
  "inf_wires" VARCHAR,
  "inf_paving" VARCHAR,
  "inf_outlet" VARCHAR,
  "inf_shoes" VARCHAR,
  "inf_lights" VARCHAR,
  "inf_other" VARCHAR,
  "trunk_dmg" VARCHAR,
  "zipcode" BIGINT,
  "zip_city" VARCHAR,
  "cb_num" BIGINT,
  "borocode" BIGINT,
  "boroname" VARCHAR,
  "cncldist" BIGINT,
  "st_senate" BIGINT,
  "nta" VARCHAR,
  "st_assem" BIGINT,
  "nta_name" VARCHAR,
  "boro_ct" BIGINT,
  "state" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "x_sp" BIGINT,
  "y_sp" BIGINT
);