| OVERVIEW AND CONCEPTS | |
| OVERVIEW OF ENVIRONMENTAL DATA MANAGEMENT | |
| Concern for the environment | |
| The Computer Revolution | |
| Convergence - Environmental data management | |
| Concept of Data vs. Information | |
| EMS vs. EMIS vs. EDMS | |
| SITE DATA MANAGEMENT CONCEPTS | |
| Purpose of data management | |
| Types of data storage | |
| Responsibility for data management | |
| Understanding the data | |
| RELATIONAL DATA MANAGEMENT THEORY | |
| What is relational data management? | |
| History of relational data management | |
| Data normalization | |
| Structured Query Language | |
| Benefits of normalization | |
| Automated normalization | |
| DATA CONTENT | |
| Data content overview | |
| Project technical data | |
| Project administrative data | |
| Project document data | |
| Reference data | |
| Document management | |
| SYSTEM DESIGN AND IMPLEMENTATION | |
| GENERAL DESIGN ISSUES | |
| Database management software | |
| Database location options | |
| Distributed vs. centralized databases | |
| The data model | |
| Data access requirements | |
| Government EDMS systems | |
| Other issues | |
| DATABASE ELEMENTS | |
| Hardware and software components | |
| Units of data storage | |
| Databases and files | |
| Tables ("databases") | |
| Fields (columns) | |
| Records (rows) | |
| Queries (views) | |
| Other database objects | |
| THE USER INTERFACE | |
| General user interface issues | |
| Conceptual guidelines | |
| Guidelines for specific elements | |
| Documentation | |
| IMPLEMENTING THE DATABASE SYSTEM | |
| Designing the system | |
| Buy or build? | |
| Implementing the system | |
| Managing the system | |
| ONGOING DATA MANAGEMENT ACTIVITIES | |
| Managing the workflow | |
| Managing the data | |
| Administering the system | |
| GATHERING ENVIRONMENTAL DATA | |
| SITE INVESTIGATION AND REMEDIATION | |
| Overview of environmental regulations | |
| The Investigation and Remediation Process | |
| Environmental Assessments and Environmental Impact Statements | |
| GATHERING SAMPLES AND DATA IN THE FIELD | |
| General sampling issues | |
| Soil | |
| Sediment | |
| Groundwater | |
| Surface water | |
| Decontamination of equipment | |
| Shipping of samples | |
| Air | |
| Other media | |
| Overview of parameters | |
| ENVIRONMENTAL LABORATORY ANALYSIS | |
| Laboratory workflow | |
| Sample preparation | |
| Analytical methods | |
| Other analysis issues | |
| MAINTAINING THE DATA | |
| IMPORTING DATA | |
| Manual entry | |
| Electronic import | |
| Tracking imports | |
| Undoing an import | |
| Tracking quality | |
| EDITING DATA | |
| Manual editing | |
| Automated editing | |
| MAINTAINING AND TRACKING DATA QUALITY | |
| QA vs. QC | |
| The QAPP | |
| QC samples and analyses | |
| Data quality procedures | |
| Database support for data quality and usability | |
| Precision vs. Accuracy | |
| Protection from loss | |
| DATA VERIFICATION AND VALIDATION | |
| Types of data review | |
| Meaning of Verification | |
| Meaning of Validation | |
| The verification and validation process | |
| Verification and validation checks | |
| Software assistance with verification and validation | |
| MANAGING MULTIPLE PROJECTS AND DATABASES | |
| One file or many? | |
| Sharing data elements | |
| Moving between databases | |
| Limiting site access | |
| USING THE DATA | |
| DATA SELECTION | |
| Text-based queries | |
| Graphical selection | |
| Query-by-form | |
| REPORTING AND DISPLAY | |
| Text output | |
| Formatted reports | |
| Formatting the result | |
| Interactive output | |
| Electronic distribution of data | |
| GRAPHS | |
| Graph overview | |
| General concepts | |
| Types of graphs | |
| Graph examples | |
| Curve fitting | |
| Graph theory | |
| CROSS SECTIONS, FENCE DIAGRAMS, AND 3-D DISPLAYS | |
| Lithologic and wireline logs | |
| Cross sections | |
| Profiles | |
| Fence diagrams and stick displays | |
| Block Diagrams and 3-D displays | |
| MAPPING AND GIS | |
| Mapping concepts | |
| Mapping software | |
| Displaying data | |
| Contouring and modeling | |
| Specialized displays | |
| STATISTICS AND ENVIRONMENTAL DATA | |
| Statistical concepts | |
| Types of statistical analyses | |
| Outliers and comparison with limits | |
| Toxicology and risk assessment | |
| INTEGRATION WITH OTHER PROGRAMS | |
| Export - import | |
| Digital output | |
| Export - import advantages and disadvantages | |
| Direct connection | |
| Data warehousing and data mining | |
| Data integration | |
| PROBLEMS, BENEFITS, AND SUCCESSES | |
| AVOIDING PROBLEMS | |
| Manage expectations | |
| Use the right tool | |
| Prepare for problems with the data | |
| Plan project administration | |
| Increasing the chance of a positive outcome | |
| SUCCESS STORIES | |
| Financial benefits | |
| Technical benefits | |
| Subjective benefits | |
| THE FUTURE OF ENVIRONMENTAL DATA MANAGEMENT | |
| APPENDICES | |
| NEEDS ASSESSMENT EXAMPLE | |
| DATA MODEL EXAMPLE | |
| Introduction | |
| Conventions | |
| Primary Tables | |
| Lookup tables | |
| Reference tables | |
| Utility tables | |
| DATA TRANSFER STANDARD | |
| Purpose | |
| Database background information | |
| Data content | |
| Acceptable file formats | |
| Submittal requirements | |
| Non-conforming data | |
| THE PARAMETERS | |
| Inorganic parameters | |
| Organic parameters | |
| Other parameters | |
| Method reference | |
| EXERCISES | |
| Database redesign exercise | |
| Data normalization exercise | |
| Group discussion - data management and your organization | |
| Database redesign exercise solution | |
| Data normalization exercise solution | |
| Database software exercises | |
| GLOSSARY | |
| BIBLIOGRAPHY | |
| INDEX |
