MO 2017 Wells Shp by US Government | Healthcare

About this Dataset

MO 2017 Wells Shp

This data set provides information about wells in the State of Missouri. The parent data set is the Wellhead Information Management System (WIMS) database that is maintained by the Missouri Department of Natural Resources (DNR), Missouri Geological Survey (MGS), Geological Survey Program (GSP), Wellhead Protection Section (WHP). The WIMS database resulted from implementation of the Water Well Drillers Law of 1985. The information about well location, well ownership, well completion date, well construction, well yield, static water level, and borehole stratigraphy was provided by well drillers as required by state statute RSMo 256.600-256.640. Wells drilled prior to July of 1987 are not included in this data set. A WIMS Well Search is also available online at http://dnr.mo.gov/mowells/publicLanding.do

These data were formally named MO_2015_Wells_shp.zip which have been removed from MSDIS at MO Office of Administration request.
Organization: State of Missouri
Last updated: 2024-04-12T17:14:33.797744
Tags: dnr, drinking-water, epa, natural-resources, water, water-well-drillers-law, wellhead, wells

Tables

Table 1

@usgov.state_of_missouri_mo_2017_wells_shp.table_1

16.75 MB
238281 rows
40 columns


CREATE TABLE table_1 (
  "ref_num" BIGINT,
  "the_geom" VARCHAR,
  "date_compl" VARCHAR,
  "cert_num" VARCHAR,
  "well_num" VARCHAR,
  "well_type" VARCHAR,
  "well_use" VARCHAR,
  "subdiv_1" VARCHAR,
  "subdiv_2" VARCHAR,
  "subdiv_3" VARCHAR,
  "twn_num" BIGINT,
  "twn_dir" VARCHAR,
  "rng_num" BIGINT,
  "rng_dir" VARCHAR,
  "sctn_num" BIGINT,
  "cnty_fips" BIGINT,
  "drill_area" VARCHAR,
  "elev" BIGINT,
  "total_dpth" DOUBLE,
  "casing_l" DOUBLE,
  "swl" DOUBLE,
  "well_yield" DOUBLE,
  "from_1" BIGINT,
  "to_1" BIGINT,
  "form_1" VARCHAR,
  "from_2" BIGINT,
  "to_2" BIGINT,
  "form_2" VARCHAR,
  "from_3" BIGINT,
  "to_3" BIGINT,
  "form_3" VARCHAR,
  "from_4" BIGINT,
  "to_4" BIGINT,
  "form_4" VARCHAR,
  "from_5" BIGINT,
  "to_5" BIGINT,
  "form_5" VARCHAR,
  "from_6" BIGINT,
  "to_6" BIGINT,
  "form_6" VARCHAR
);