About this Dataset

GreenThumb Site Visits

Data Dictionary: https://docs.google.com/spreadsheets/d/1ItvGzNG8O_Yj97Tf6am4T-QyhnxP-BeIRjm7ZaUeAxs/edit#gid=1499621902

GreenThumb provides programming and material support to over 550 community gardens in New York City. NYC Parks GreenThumb staff visit all active community gardens under the jurisdiction of NYC Parks once each calendar year, subject to staff capacity. These site visits typically occur during the summer months and representatives of licensed garden groups are invited to attend. During these site visits, NYC Parks GreenThumb staff observe and record quantitative and qualitative information related to the physical status of the garden, as well as its ongoing operation, maintenance, and programming. This information is used by NYC Parks GreenThumb to inform maintenance needs at the garden and to help NYC Parks GreenThumb understand the needs of garden groups so that we can plan accordingly. In addition, this information is necessary for NYC Parks GreenThumb to confirm that publicly accessible community gardens under its jurisdiction are being operated in safe manner and in accordance with the NYC Parks GreenThumb License Agreement and applicable NYS and NYC laws and regulations. NYC Parks GreenThumb may conduct additional site visits as deemed necessary.
Organization: City of New York
Last updated: 2021-08-07T17:55:06.904806
Tags: greenthumb

Tables

Table 1

@usgov.city_of_new_york_greenthumb_site_visits.table_1

31.54 KB
352 rows
35 columns


CREATE TABLE table_1 (
  "parksid" VARCHAR,
  "inspectionid" BIGINT,
  "nexttoanothergarden" VARCHAR,
  "totalfencelength" DOUBLE,
  "totalsidewalkarea" DOUBLE,
  "totalsidewalklength" DOUBLE,
  "onsiteservice" VARCHAR,
  "hydrantw_in15ft" VARCHAR,
  "hydrantongardenside" VARCHAR,
  "rainharvesting" BOOLEAN,
  "raingallons" DOUBLE,
  "solarpanels" BOOLEAN,
  "compostsystem" VARCHAR,
  "composttumblers" VARCHAR,
  "nonfoodplants" VARCHAR,
  "food" BOOLEAN,
  "openlawnorcommunalarea" VARCHAR,
  "pavedarea" BOOLEAN,
  "treesingarden" BOOLEAN,
  "fruittrees" BOOLEAN,
  "streettrees" VARCHAR,
  "emptytreepits" VARCHAR,
  "murals" VARCHAR,
  "blankshed" VARCHAR,
  "parkssign" VARCHAR,
  "chickens" BOOLEAN,
  "pond" VARCHAR,
  "fishinpond" VARCHAR,
  "turtles" VARCHAR,
  "aquaponics" BOOLEAN,
  "farmersmarket" BOOLEAN,
  "csapickup" BOOLEAN,
  "composting" VARCHAR,
  "greenhouse" VARCHAR,
  "structureforseasonextension" BOOLEAN
);