Grow Pittsburgh Food Gardens by US Government | Finance and Economics

About this Dataset

Grow Pittsburgh Food Gardens

Food growing locations registered with Grow Pittsburgh. Data includes community gardens, community farms, schoolyard gardens, or urban farms. This data is included in Grow Pittsburgh's Grower's Map
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:34.114299
Tags: civic-vitality, environment, farms, food, gardens, health, healthy-food, land-use, properties, property, school-gardens, sustainability, vacant-land

Tables

Food Gardens December 2017

@usgov.allegheny_county_city_of_pitts_grow_pittsburgh_food_gardens.food_gardens_december_2017

15.39 KB
80 rows
11 columns


CREATE TABLE food_gardens_december_2017 (
  "urban_grower" VARCHAR,
  "grower_id" BIGINT,
  "category" VARCHAR,
  "url" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Food Gardens Data Dictionary

@usgov.allegheny_county_city_of_pitts_grow_pittsburgh_food_gardens.food_gardens_data_dictionary

5.57 KB
9 rows
5 columns


CREATE TABLE food_gardens_data_dictionary (
  "field_name" VARCHAR,
  "field_description" VARCHAR,
  "example" VARCHAR,
  "additional_information" VARCHAR,
  "unnamed_4" VARCHAR
);