PWS SRC Source Cap And Well Depth by US Government | Environmental and Climate Sciences

About this Dataset

PWS SRC Source Cap And Well Depth

PWS SRCs whose source capacity is less than 20 gal/min and well depth is less than 50ft.
Organization: State of Washington
Last updated: 2020-11-10T17:20:46.220045
Tags: drought, source-capacity, well-depth

Tables

Table 1

@usgov.state_of_washington_pws_src_source_cap_and_well_depth.table_1

68.48 KB
985 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" BIGINT,
  "src_capacity" DOUBLE,
  "susceptibility" VARCHAR,
  "county" VARCHAR,
  "ownership" VARCHAR,
  "ft_respop" BIGINT,
  "maxtotalpop" BIGINT,
  "resconn" BIGINT,
  "total_conn" BIGINT,
  "qtr_qtr" VARCHAR,
  "township" BIGINT,
  "section" DOUBLE,
  "range" VARCHAR,
  "latlongmethod" VARCHAR,
  "location_1" VARCHAR
);