Layer 1 by US Government | Demographics and Population Studies

About this Dataset

Layer 1

Blockface data from the TreesCount! 2015 Street Tree Census, conducted by volunteers and staff organized by NYC Parks & Recreation and partner organizations. Blockface data includes tree counts and data collection status by block. Accompanying street tree data is available, indicating tree-level details such as tree species, size and other characteristics.
Organization: City of New York
Last updated: 2024-02-09T16:21:21.252700
Tags: census, dpr, parks, trees, treescount

Tables

Table 1

@usgov.city_of_new_york_layer_1.table_1

33.07 KB
18 rows
30 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "block_id" BIGINT,
  "block_stat" VARCHAR,
  "trees" BIGINT,
  "surv_date" VARCHAR,
  "group_name" VARCHAR,
  "cb_num" BIGINT,
  "borocode" BIGINT,
  "boroname" VARCHAR,
  "cncldist" BIGINT,
  "st_assem" BIGINT,
  "st_senate" BIGINT,
  "nta" VARCHAR,
  "nta_name" VARCHAR,
  "boro_ct" BIGINT,
  "zipcode" BIGINT,
  "zip_city" VARCHAR,
  "state" VARCHAR,
  "start_x_sp" DOUBLE,
  "start_y_sp" DOUBLE,
  "mid_x_sp" DOUBLE,
  "mid_y_sp" DOUBLE,
  "end_x_sp" DOUBLE,
  "end_y_sp" DOUBLE,
  "start_lat" DOUBLE,
  "start_long" DOUBLE,
  "mid_lat" DOUBLE,
  "mid_long" DOUBLE,
  "end_lat" DOUBLE,
  "end_long" DOUBLE
);