About this Dataset

P-Patch

The P-Patch Community Gardening Program is made up of community managed open spaces throughout Seattle where gardeners use small plots of land to grow organic food, flowers, and herbs. All P-Patch gardens are open to the public to enjoy and are utilized as communal spaces, restorative spaces, learning and idea incubators, and venues for community gatherings. For more information, please see the Department of Neighborhoods P-Patch Community Gardening.

Displays data from DON.PPATCH. Labels are based on the attribute NAME. Each p-patch has an URL attribute, please use to find more information about specific p-patch.

Updated as needed, last update April 2025.
Organization: City of Seattle
Last updated: 2025-02-28T23:48:53.801116
Tags: community-gardening, department-of-neighborhoods, garden, gis, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_p_patch.table_1

23.62 kB
86 rows
19 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "site_id" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "dept" VARCHAR,
  "program" VARCHAR,
  "program_no" DOUBLE,
  "assgnbydon" DOUBLE,
  "url" VARCHAR,
  "numplots" DOUBLE,
  "date_estab" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "size_sqft" DOUBLE,
  "in_row" VARCHAR,
  "location" VARCHAR,
  "affiliation" VARCHAR,
  "affiliation_url" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);