Combined dataset of all wells with uniform attributes from detailed individual well databases. This dataset is intended to serve as a metadata-level well database. Large overlaps are known to exist among databases; however, all are preserved as found in order to preserve program-specific information. For example a well may derive geologic data from the Geologic Sampling Points database, public water supply data from the SDWIS Wells database and Water Allocation information from the Water Use (WACOP) database. Each of these will be represented by a record within this dataset.
This dataset has the following 11 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Well ID | wellid | text | 2173310 2122 11 1646 1890 view top 100 |
Well Type | well_type | text | Private well tracking system IGS Well Database Wells registered for testing Registered abandoned wells Permitted private wells view top 100 |
Owner Name | owner_name | text | Unknown Iowa Geological Survey Igs Usgs Gsb view top 100 |
County | county | text | Buchanan Howard Pottawattamie Delaware Winneshiek view top 100 |
Location Description | location | text | TN, R, S T76N, R2W, S30 T96N, R22W, S23 T97N, R3W, S24 T88N, R5W, S23 view top 100 |
Location Estimate | est_loc_ac | text | nom. +/- 25m. Calc. +/- 140m. Calc. +/- 285m. Calc. +/- 470 ft. Calc. +/- 230 ft. view top 100 |
Well Depth (ft) | depth | text | unkn 100 200 150 30 view top 100 |
Other Information | other_info | text | Status: Active Status: Plugged Drilling method: Drilled; Known well depth Status: Active Logged Drilling method: Drilled; Well depth is uncertain view top 100 |
Construction Permit Date | c_p_date | text | n.a. unkn 1/1/1950 1/1/1940 1/1/1960 view top 100 |
Hyperlink | hlink | text | no hyperlink http://programs.iowadnr.gov/wateruse/ https://programs.iowadnr.gov/sourcewater/SystemDetail.aspx?pwsid=5715093 https://programs.iowadnr.gov/sourcewater/SystemDetail.aspx?pwsid=7048001 https://programs.iowadnr.gov/sourcewater/SystemDetail.aspx?pwsid=8400722 view top 100 |
the_geom | the_geom | point | {"coordinates":[-90.69552169823307,42.54654148252197],"type":"Point"} {"coordinates":[-92.63080833810527,41.15449155631787],"type":"Point"} {"coordinates":[-90.81520079144424,41.46003201409505],"type":"Point"} {"coordinates":[-93.72375900057024,42.70602200010501],"type":"Point"} {"coordinates":[-93.13647699949043,43.13850399967858],"type":"Point"} view top 100 |