Photo of a microscope

Environmental and Geographic Analysis Database (EGAD)

To view PDF files, get Adobe Acrobat Reader here . If you have problems viewing PDF files, please contact R&WM Webmaster.

Introduction

The Maine Environmental and Geographic Analysis Database (EGAD) (formerly known as the Environmental and Groundwater Analysis Database) was originally designed to store site and water quality information and currently includes spatially located data for 39 different types of potential and actual sources of contamination to groundwater in Maine. Access to comprehensive up-to-date analytical data allows DEP to assess trends in regional ground water quality and quantity. It also improves automated analysis and map-making capability including rapid access to information for emergency response to hazardous materials spills. Detailed well and analytical information in the database is used by staff to design remedial action at hazardous spill sites. It is also used by staff to evaluate potential for cumulative impacts of real estate development on ground water quality.

Recent efforts to expand and improve EGAD have involved the inclusion of data from the Bureau of Land & Water Quality including the addition of 10 Biological and Surface Water Sampling site types.  This is in addition to the data that continues to be included from the Bureau of Remediation & Waste Management. To encapsulate the new addition of data from Land & Water Quality  and to acknowledge the spatial (GIS) component of the data, EGAD is now known as the Environmental and Geographic Analysis Database, as data in EGAD now includes a broad range of environmental data including physical, chemical, biological and spatial data.

Contacts

Electronic Data Deliverable (EDD) and EGAD Questions, please contact:

Tracy Krueger (207) 287-5767 Tracy.Krueger@maine.gov
BRWM EGAD Data Manager

Emily Zimmermann (207) 446-1003 Emily.Zimmermann@maine.gov
BLWQ EGAD Data Manager

Mark Holden (207)-215-1691 Mark.K.Holden@maine.gov
EGAD Site Data Manager

John Lynam (207)-287-8426 John.Lynam@maine.gov
EGAD Spatial Data Manager

Electronic Data Deliverable (EDD) Law

The EDD is a required standard template for laboratory and field data submittals to EGAD. Authority for this requirement is granted under Maine's Uniform Electronic Transaction Act, 10 M.R.S.A. §9418 (2) (A). The ME DEP Groundwater Database EDD version 4.0 (ME DEP GWDB EDD v4.0) was the standard used in the past. On October 1, 2007, ME DEP EDD Version 5.0 was released, and EDD Version 5.1 was released on June 10, 2010. The most current update, EDD version 5.2 was released on May 2, 2011. Either Version 5.0, 5.1 or 5.2 should be used for all data submissions.

EDD Version 5.2

  • EDD Quick Reference Guide (PDF format) has been updated. The quick reference guide is designed to help outline special considerations when completing the EDD.
  • EDD v5.2 Template for import into EGAD (Excel format) workbook containing EDD Info, EDD template for all chemical, field and physical measurement data and Data Elelment Dictionary.
  • EGAD Lookup Tables (Excel 2010 format) contains all the lookup tables and their values contained in the EGAD Database. These values should be used to fill in the appropriate fields in the EDD file for submittal. The EGAD Lookup Tables are updated frequently as additional LUP values are added so check back often for the most up to date EGAD Lookup Tables.
  • EDD Examples (Excel format) contains examples of EDDs filled out for different types of data including Laboratory, Field, Water Level & Flow, Non-Sample Data, and data for Samples Taken but Not Analyzed.
  • Frequently Asked Questions (FAQs) About ME DEP EGAD EDDv5.2

The Department of Environmental Protection requires that all laboratory data submittals to EGAD include the associated quality control (QC) sample results in the EDD. This will avoid a separate request for the QC results and will help avoid unnecessary QC questions from the Department, while demonstrating that proper QC measures were taken in the course of sampling and analysis. These include: field blanks, trip blanks, field duplicates, surrogates (in % recovery with units “%”), lab control samples (LCS) (in % recovery with units “%”), lab control sample duplicates (LCSD) (in both % recovery with units “%” and relative % difference in units “RPD”) method/lab blanks, matrix spikes (MS) (in % recovery with units “%”), and matrix spike duplicates (MSD) (in both % recovery with units “%” and relative % difference in units “RPD”). This table can be used as a reference for assigning the correct SAMPLE_TYPE and SAMPLE_TYPE_QUALIFIER codes for these samples in the EDD.

EGAD EDD QC Sample Reference Table
Type of Sample SAMPLE_TYPE SAMPLE_TYPE_QUALIFIER
Normal Environmental Sample Sample matrix
(e.g. GW, SL, etc)
N
Field Duplicate Same as associated Normal sample
(e.g. GW, SL, etc)
D
Lab Duplicate Same as associated Normal sample
(e.g. GW, SL, etc)
L
Matrix Spike Same as associated Normal sample
(e.g. GW, SL, etc)
M
Matrix Spike Duplicate Same as associated Normal sample
(e.g. GW, SL, etc)
P
Field Blank FB QC
Lab Blank (Method Blank) LB QC
Trip Blank TB QC
Equipment Blank EB QC
Instrument Blank IB QC
Filter Blank FL QC
Lab Control Sample LCS QC
Lab Control Sample Duplicate LCS L

Sign up to be added to our mailing list.

GIS Data Collection - guidance for submittal of spatial data to DEP

EGAD Map Data

The EGAD Site locations, showing threats to groundwater and on-going environmental monitoring, can be viewed using Google Earth

EGAD Data Disclaimer

EGAD (Environmental Geographic Analysis Database) is a public information resource provided by the Maine DEP. The State of Maine and InforME make every effort to ensure that published information is accurate and current.  Neither the State of Maine, nor any agency, officer, or employee of the State of Maine warrants the accuracy, reliability or timeliness of any information published on the Maine.gov website, nor endorses any products or services linked from this system, and shall not be held liable for any losses caused by reliance on the accuracy, reliability or timeliness of such information.  Portions of the information are subject to revisions, corrections, and updates.  Any person or entity that relies on any information obtained from this system does so at their own risk.

Data in the EGAD system data go through various levels of quality assurance/quality control procedures before being accepted by the DEP to meet project requirements.  However, the DEP makes no guarantee as to the accuracy, reliability, timeliness or completeness of the data.  To ensure data authenticity, original laboratory analytical reports and field sheets should be consulted.  As an aid to data interpretation, EGAD supplemental materials such as the data dictionary and LUP tables should be consulted.  The DEP does not assume any responsibility for the nature in which EGAD data are used, either in their raw form or in the form of derived products.  When using EGAD data, the following citation should be provided: Maine Department of Environmental Protection, EGAD (Environmental Geographic Analysis Database), http://www.maine.gov/dep/maps-data/egad/, (date accessed).

Types of Sites in EGAD

EGAD contains data from a number of different sites including sites with Land Use Activities which are Potential and/or Actual Sources of Contamination and sites where Biological and Surface Water Sampling is conducted. Below is a link to an excel file containing definitions for all of the current EGAD Site Types.

EGAD Site Type Definitions (Excel format)

Related Programs