Building and Using a Groundwater Database is an introductory book that focuses on the fundamentals of groundwater database use. It is an excellent guide for people who collect and use groundwater quality data, hydrogeological data, and general geological data, as well as people who are required to prepare information about groundwater resources for others to use. The book also serves as a textbook for computer-based hydrogeology courses. Many university courses now make use of computerized groundwater data, yet no textbook exists to guide students in database use.
Building and Using a Groundwater Database provides detailed information regarding the steps and perspectives required to create a database and use it for groundwater management, land use practices, planning, cleanups, site investigations, and general hydrogeologic reporting. The book is structured to take the reader from the foundations of database development through maintenance and everyday use of the database. Actual examples from selected case studies are used to illustrate database principles. This book is unique in that it deals with the management and structuring of groundwater data, as opposed to the collection and interpretation of data. It illustrates how database software managers can be integrated with groundwater software tools. Building and Using a Groundwater Database provides consultants, engineers, public officials, university instructors, local and municipal water utilities, and banking and loan institutions with a clear, concise guide to using groundwater databases.
Table of Contents
Part 1: Getting Started: Why and What Size 1. Groundwater Databases and Groundwater Protection 2. A Solution 3. The Bureaucracy 4. Getting Started at a Local Level Part 2: Database Backbone: Information from the Well Log 5. The Well Construction Record 6. Well Construction Data: Minimum Elements 7. Data Quality Decided at the Local Level Part 3: Methods: Mechanics of Well Log Mapping 8. Locating the Well 9. Mapping Systems 10. The Mapping Process Part 4: Tools: Hardware, Software, Experience 11. Rules of Thumb 12. A Minimal System 13. An Ideal System Part 5: Data Entry: Electronic Files 14. General Attributes of Electronic Databases 15. Selecting the Best Database Manager 16. Designing Your Database 17. Special Features of a Groundwater Database 18. An Example Well Construction Database 19. The Team Approach to Data Entry Part 6: Geology Of The Database Unit: What's Down There 20. The Cross-Section 21. An Example 22. The Static Water Level Contour Map 23. Groundwater Models 24. An Example Model: Aquipro 25. Summary of Tools for Studying Geology of the Database Part 7: The Water Chemistry Database: Measuring Water Quality 26. Selecting the Sites for Sampling 27. Review of the Data Part 8: Entry of Chemistry Results: Electronic Files 28. Common Issues in Groundwater Chemistry Databases 29. Groundwater Chemistry Minimum Data Elements Analysis of Data: How to Interpret the Results 30. Profiling the Water Chemistry 31. Statistics 32. Graphic Profiles 33. Geographic Distribution Part 9: Management of the Database: Electronic Libraries. Impact: Practical Uses