About this Dataset

Drinking Fountain

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.

Life_Cycle_Code = Active

Refresh Cycle: Weekly

Feature Class: DPR.EAM_Drinking_Fountain_PT
Organization: City of Seattle
Last updated: 2025-02-28T23:46:09.109267
Tags: common-data-layers, drinking-fountain, parks, seattle-gis-open-data, spr

Tables

Table 1

@usgov.city_of_seattle_drinking_fountain_56f7e.table_1

46.72 kB
216 rows
30 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "park_name" VARCHAR,
  "drinking_fountain_material" VARCHAR,
  "equipment_description" VARCHAR,
  "life_cycle_code" VARCHAR,
  "drinking_fountain_type" VARCHAR,
  "water_shutoff_location" VARCHAR,
  "accessible_model_amwo" VARCHAR  -- Accessible Model (AMWO),
  "dog_bowl_amwo" VARCHAR  -- Dog Bowl (AMWO),
  "bottle_filler_amwo" VARCHAR  -- Bottle FIller (AMWO),
  "installation_year_or_date" DOUBLE  -- Installation Year (or Date),
  "current_status_amwo" VARCHAR  -- Current Status (AMWO),
  "reason_off_amwo" VARCHAR  -- Reason Off (AMWO),
  "reason_for_closure_amwo" VARCHAR  -- Reason For Closure (AMWO),
  "latitude_point_y_amwo" DOUBLE  -- Latitude (Point Y) (AMWO),
  "longitude_point_x_amwo" DOUBLE  -- Longitude (Point X) (AMWO),
  "council_district" BIGINT,
  "park_maintenance_district" VARCHAR,
  "rse_index_priority_score" VARCHAR,
  "pma_id" DOUBLE,
  "amwo_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "spatial_data_quality_level" VARCHAR,
  "globalid" VARCHAR,
  "gis_creator" VARCHAR,
  "gis_create_date" VARCHAR,
  "gis_editor" VARCHAR,
  "gis_editor_date" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);