About this Dataset

Surface Water Drinking Water Source Areas

This data layer is an element of the Oregon GIS Framework. This map includes Oregon Department of Environmental Quality (DEQ) and Oregon Department of Human Services’ (DHS) Drinking Water Program Source Water Assessment results for community and non-transient non-community public water systems (PWS) for surface water systems that were active in June 1999 (when Oregon's Source Water Assessment Plan was approved by EPA). Subsequently, post-1999 systems have been added including some non-community systems.
Organization: State of Oregon
Last updated: 2024-02-09T16:05:43.681886
Tags: 1999, 1999-source-water-assessment-plan, admin-boundaries, biosphere, community-water-systems, deq, drinking-water, drinking-water-protection, drinking-water-source-areas, drinking-water-surface-water-intakes-and-source-areas, inland-waters, land-surface, modern, non-transient-non-community-water-systems, north-america, oregon, public-water-systems, state-of-oregon, surface-water-protection, surface-water-source-areas, united-states-of-america, watersheds

Tables

Table 1

@usgov.state_of_oregon_surface_water_drinking_water_source_areas.table_1

82.66 KB
261 rows
49 columns


CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "perimeter" DOUBLE,
  "area" DOUBLE,
  "acres" DOUBLE,
  "delinsqmi" DOUBLE,
  "tinwsys_is" BIGINT,
  "pws_id" BIGINT,
  "pws_name" VARCHAR,
  "pws_label" VARCHAR,
  "tinwsys_d" VARCHAR,
  "tinwsf_is" VARCHAR,
  "tinwsf_nam" VARCHAR,
  "tinwsf_wat" VARCHAR,
  "src_label" VARCHAR,
  "dws_id" VARCHAR,
  "oregon_dwp" BIGINT,
  "city" VARCHAR,
  "cnty_name" VARCHAR,
  "epa_method" VARCHAR,
  "or_method" VARCHAR,
  "comments" VARCHAR,
  "fips_cnty" BIGINT,
  "or_cnty_nu" BIGINT,
  "tinwsys_st" VARCHAR,
  "utm_zone" BIGINT,
  "sdwis_link" VARCHAR,
  "upstrm_cd" BIGINT,
  "upstrmpwss" VARCHAR,
  "dwnstrm_cd" BIGINT,
  "assessment" VARCHAR,
  "subbasin" BIGINT,
  "subbasin_n" VARCHAR,
  "huc12_nhd" VARCHAR,
  "huc12_wbd" VARCHAR,
  "wrd_basin" VARCHAR,
  "date_del" VARCHAR,
  "initials_d" VARCHAR,
  "date_dig" TIMESTAMP,
  "initials_1" VARCHAR,
  "date_proc" VARCHAR,
  "initials_p" VARCHAR,
  "method" VARCHAR,
  "comment" VARCHAR,
  "huc4_edit" VARCHAR,
  "separate" VARCHAR,
  "sqmi" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);