Building a Water Well Database for GIS Analysis

1. Building a Water Well Database for GIS Analysis By A. Wayne Jones, Kelly A. Barrett Ohio Department of Natural Resources Division of Water

2. Objectives • Transfer of well log data from paper to database • Edit well log database • Convert flatline files to GIS dataset • TIN Modeling • Create and support Division of Water products

3. Software Used • Microsoft Access and Excel (2002) • Oracle 10G Release 1 • Flotiva from Workiviti (8-1-6) • Arc Map, Arc Catalog, Arc Toolbox (9.1) (Spatial Analyst, 3-D Analyst) • Arc Workstation (9.1)

5. Building a Water Well Database for GIS Analysis • Well log locations from field locating • Over 800,000 well log records • Less than 200,000 have coordinates • Geocoded 3 counties with excellent results

6. Building a Water Well Database for GIS Analysis • Digitized point files on CD for each county • Verify with well log database • location map year • township code • location number • location area

11. Building a Water Well Database for GIS Analysis • Microsoft Access 2000 is the front end to Oracle database

12. Digital Line Graphs USGS Digital Line Graph • Downloaded from Ohio Center for Mapping • 1:24,000 scale • Hypsography layer • During AML dlg file recodes major and minor codes (Elevation items are defined)

13. Building a Water Well Database for GIS Analysis AML Menu for Recoding DLG items

14. Building a Water Well Database for GIS Analysis

15. Converting DLG to TIN

16. Building a Water Well Database for GIS Analysis • TINSPOT defines surface elevation at each well location • Arc TINSPOT Command in Arc Workstation • TINSPOT uses the interpolated elevation from the TIN model to define the elevation at the location of the point coverage • Water table elevation is calculated by subtracting static water level from surface elevation

17. Applications for Digital Data • Potentiometric surface mapping • Shapefiles of XY well log data with query capacity • Grid modelling

19. Building a Water Well Database for GIS Analysis

20. Building a Water Well Database for GIS Analysis • Microsoft Access table as a .DBF4 export to create shapefile • Multiple Query Options on shapefile • All sand and gravel wells (left) • All bedrock wells • All wells in particular quadrangle Franklin County

21. Building a Water Well Database for GIS Analysis • Create a spatial query around a feature • Select by attribute or select by location • All the sand and gravel wells within 1 mile of the Darby Creek (left) • All bedrock wells within 10 miles of US 71

22. Building a Water Well Database for GIS Analysis Create a buffer “1 mile radius” from the intersections of 2 streets or any point location (right) Popular query from environmental consulting firms

23. Building a Water Well Database for GIS Analysis • Potentiometric Surface contours • Converted to a TIN Model • TIN converted to raster • Raster calculator to subtract grids • Darby Creek watershed poster

24. Thanks!! • Ken Pendley, Rick Archer, Jim Raab, Mike Angle, ODNR, Division of Water • Shashi Srivastava, Oracle Database Administrator, ODNR, Office of Information Technology • Mark Anstaett, GIMS programmer, Office of Information Technology • Financial Support provided by the Ohio Department of Transportation