About this Dataset

Picnic Tables

Developed by Seattle Parks & Recreation (DPR) to quantify and categorize areas of DPR maintenance for analysis and planning purposes. Some areas of maintenance extend beyond the boundaries of DPR property.

Refresh Cycle: Weekly

Feature Class: DPR.EAM_Picnic_Table_PT
Organization: City of Seattle
Last updated: 2025-02-28T23:24:31.588714
Tags: common-data-layers, parks, picnic-tables, seattle-gis-open-data, spr

Tables

Table 1

@usgov.city_of_seattle_picnic_tables_e2039.table_1

140.6 kB
1,363 rows
46 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "park_name" VARCHAR,
  "table_size" VARCHAR,
  "table_pad" VARCHAR,
  "table_material" VARCHAR,
  "asset_code" DOUBLE,
  "life_cycle_code" VARCHAR,
  "picnic_table_id" DOUBLE,
  "table_foundation" VARCHAR,
  "seating_capacity" DOUBLE,
  "accessibility" VARCHAR,
  "next_to_grill" VARCHAR,
  "permanent_waste_management" VARCHAR,
  "scenic_view" VARCHAR,
  "public_notes" VARCHAR,
  "comments" VARCHAR,
  "service_status" VARCHAR,
  "table_is_reservable" VARCHAR,
  "description_amwo" VARCHAR  -- Description (AMWO),
  "year_amwo" VARCHAR  -- Year (AMWO),
  "location_id_amwo" VARCHAR  -- Location ID (AMWO),
  "life_cycle_status_code_amwo" VARCHAR  -- Life Cycle Status Code (AMWO),
  "latitude_amwo" VARCHAR  -- Latitude (AMWO),
  "longitude_amwo" VARCHAR  -- Longitude (AMWO),
  "point_x" VARCHAR,
  "point_y" VARCHAR,
  "council_district" BIGINT,
  "park_maintenance_district" VARCHAR,
  "rse_priority" VARCHAR,
  "weblink_1" VARCHAR,
  "weblink_2" VARCHAR,
  "res_txt1" VARCHAR,
  "res_txt2" VARCHAR,
  "res_li" VARCHAR,
  "res_dbl" VARCHAR,
  "pma_id" DOUBLE,
  "amwo_id" VARCHAR,
  "spatial_data_quality_level" VARCHAR,
  "globalid" VARCHAR,
  "gis_creator" VARCHAR,
  "gis_create_date" VARCHAR,
  "gis_editor" VARCHAR,
  "gis_edit_date" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);