About this Dataset

Public Wells

Public wells used to determine Source Water Protection capture zone areas. The data are derived from the Iowa Geological and Water Survey Geologic Sample database and supplemented with derived aquifer properties and attributes required for preparing simple groundwater flow models. *This layer is a copy with reduced attribute fields and simplified symbology.

For further information the metadata for this layer can be viewed at: ftp://ftp.igsb.uiowa.edu/gis_library/ia_state/hydrologic/ground_waters/source_water/sourcewater_wells.html.
Organization: State of Iowa
Last updated: 2024-04-12T12:46:55.892276

Tables

Table 1

@usgov.state_of_iowa_public_wells_8e02d.table_1

1.16 MB
7,279 rows
47 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "pwsid" BIGINT,
  "name_owner" VARCHAR,
  "local_name" VARCHAR,
  "tin_wsf_id" BIGINT,
  "wl_status" VARCHAR,
  "twp" BIGINT,
  "rge" BIGINT,
  "e_w" VARCHAR,
  "sec" BIGINT,
  "ql_qs" VARCHAR,
  "utm_x" DOUBLE,
  "utm_y" DOUBLE,
  "loc_ed_src" VARCHAR,
  "elev_acc" VARCHAR,
  "drl_date" VARCHAR,
  "aquifer" VARCHAR,
  "conf_uncon" VARCHAR,
  "swp_suscep" VARCHAR,
  "swl_ft" BIGINT,
  "pwl_ft" BIGINT,
  "spc_gpm_ft" DOUBLE,
  "t_ft2_d" DOUBLE,
  "k_ft_d" DOUBLE,
  "pmp_ed_dte" VARCHAR,
  "editor" VARCHAR,
  "hlink" VARCHAR,
  "geosamid" BIGINT,
  "local_id" VARCHAR,
  "pwsid_aqfr" VARCHAR,
  "wuwellid" BIGINT,
  "tag_id" BIGINT,
  "loc_acc" VARCHAR,
  "loc_ed_dte" VARCHAR,
  "elev_ft" BIGINT,
  "wl_dpth_ft" DOUBLE,
  "cs_dpth_ft" BIGINT,
  "cs_diam_in" DOUBLE,
  "aq_thk_ft" BIGINT,
  "pmp_dte" VARCHAR,
  "pmptst_hr" DOUBLE,
  "pmptst_gpm" DOUBLE,
  "t_method" VARCHAR,
  "ave_wl_gpd" BIGINT,
  "ed_dte" VARCHAR,
  "comment" VARCHAR
);