About this Dataset

GreenThumb Garden Info

GreenThumb provides programming and material support to over 550 community gardens in New York City. The data contains garden information and is part of the GreenThumb Gardens Data Collection.

Data Dictionary: https://docs.google.com/spreadsheets/d/1ItvGzNG8O_Yj97Tf6am4T-QyhnxP-BeIRjm7ZaUeAxs/edit#gid=33327664
Organization: City of New York
Last updated: 2020-12-04T19:26:51.889532

Tables

Table 1

@usgov.city_of_new_york_greenthumb_garden_info.table_1

241.13 kB
630 rows
27 columns

CREATE TABLE table_1 (
  "assemblydist" BIGINT,
  "address" VARCHAR,
  "borough" VARCHAR,
  "communityboard" BIGINT,
  "congressionaldist" BIGINT,
  "coundist" BIGINT,
  "gardenname" VARCHAR,
  "juris" VARCHAR,
  "multipolygon" VARCHAR,
  "openhrsf" VARCHAR,
  "openhrsm" VARCHAR,
  "openhrssa" VARCHAR,
  "openhrssu" VARCHAR,
  "openhrsth" VARCHAR,
  "openhrstu" VARCHAR,
  "openhrsw" VARCHAR,
  "parksid" VARCHAR,
  "policeprecinct" BIGINT,
  "statesenatedist" BIGINT,
  "status" VARCHAR,
  "zipcode" BIGINT,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "censustract" DOUBLE,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "crossstreets" VARCHAR
);