About this Dataset

Park Bench

Track locations of fixed Park Benches within parks for maintenance and jurisdiction purposes. This database will contains bench categories, named (donation) benches, and material construction of the bench. This data will be used in Mobile and Web applications.

Please set the LifeCycleStatusTxt = Active (to avoid getting decommissioned or proposed benches.)

Refresh Cycle: Weekly

Feature Class: DPR.EAM_BENCH_PT
Organization: City of Seattle
Last updated: 2025-02-28T23:46:55.247069
Tags: common-data-layers, park-bench, parks, seattle-gis-open-data, spr

Tables

Table 1

@usgov.city_of_seattle_park_bench_254fd.table_1

285.04 kB
3,045 rows
48 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "park_name" VARCHAR,
  "site_name" VARCHAR,
  "bench_category" VARCHAR,
  "bench_material" VARCHAR,
  "bench_length" BIGINT,
  "hardscaped" VARCHAR,
  "bench_program" VARCHAR,
  "plaque_text" VARCHAR,
  "jurisdiction" VARCHAR,
  "maintenance_responsibility" VARCHAR,
  "maintenance_notes" VARCHAR,
  "public_notes" VARCHAR,
  "bench_donor" VARCHAR,
  "year_bench_installed" DOUBLE,
  "donation_start_date" VARCHAR,
  "donation_expire_date" VARCHAR,
  "life_cycle_code" 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,
  "pma_id" DOUBLE,
  "amwo_id" VARCHAR,
  "globalid" VARCHAR,
  "spatial_data_quality_level" VARCHAR,
  "bench_res_txt1" DOUBLE,
  "bench_res_txt2" VARCHAR,
  "bench_res_li" VARCHAR,
  "bench_res_dbl" VARCHAR,
  "link_1" VARCHAR,
  "link_2" VARCHAR,
  "link_3" VARCHAR,
  "link_4" VARCHAR,
  "created_user" VARCHAR,
  "created_date" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);