Name: PWS SRC Source Capacity
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

PWS SRC Source Capacity

PWS SRC's whose source capacity is less than 20 gal/min
Organization: State of Washington
Last updated: 2020-11-10T17:21:27.068403
Tags: drought, source-capacity

Tables

Table 1

@usgov.state_of_washington_pws_src_source_capacity.table_1

448.1 kB
8,292 rows
23 columns

CREATE TABLE table_1 (
  "f" VARCHAR,
  "ws_id" VARCHAR,
  "ws_name" VARCHAR,
  "srcnum" BIGINT,
  "srcname" VARCHAR,
  "srctype" VARCHAR,
  "srcuse" VARCHAR,
  "wria_num" BIGINT,
  "welldepth" DOUBLE,
  "src_capacity" DOUBLE,
  "susceptibility" VARCHAR,
  "county" VARCHAR,
  "ownership" VARCHAR,
  "ft_respop" BIGINT,
  "maxtotalpop" BIGINT,
  "resconn" BIGINT,
  "total_conn" BIGINT,
  "qtr_qtr" VARCHAR,
  "township" DOUBLE,
  "section" DOUBLE,
  "range" VARCHAR,
  "latlongmethod" VARCHAR,
  "location_1" VARCHAR
);