Electronic Data DeliverablesiThe Importance of

Receiving Your Site and Project Data  Electronically


Note: This appendix to  the Ground  Water Forum's fact sheet, "Electronic  Data  Deliverables:  The Im-
portance of Receiving  Your Site and Project  Data  Electronically," provides supplemental information.

What to request in electronic data deliverables (EDD)

Data generated by or submitted to the Agency need to be in a format that is universally accepted by
most database or image processing software. Numerical data can be submitted in a text (comma or tab
delimited) or similar file format. Image files can be submitted in a PDF, JPG, GIF, or similar file format.To
the extent possible, a non-proprietary format for electronic data submissions is preferred to ensure that
the data can be read not only today but in the future, and not be tied to specific vendors or subcontractors.

Note that individual Regions or programs may have more specific EDD specifications. Consequently,
agencies or contractors submitting EDDs to EPA need to consult with their EPA project manager regarding
the required EDD file format.


How  Electronic Data are Shared  in the  Regulatory Environment
         EPA's Environmental
        Response Team (ERT)
        Contractor (EPA)
          Consultant (PRP)
U.S.Army Corps of Engineers
      (USAGE)
    Technical Support Staff
   Outside Agencies
                                                                           Page I  of 4

-------
Examples of Data to be Submitted Electronically

Site Map:
•   Preference is for GIS layer file or computer-aided design (CAD) format with all relevant surface
    features; however, PDF or other file format may be acceptable.

Boring Logs and Well Construction Details:
•   X,X and Z coordinates, and location ID.
•   Ground surface elevation, top of casing elevation, depth to lithologic units, lithologic descriptions,
    depth to well construction material, well construction material type, diameter of casing, drilling
    method, well development information, etc.
•   Field test data [e.g., photoionization detector (PID), field x-ray fluorescence (XRF),
    immunoassay etc.].
•   Aquifer slug test or pump test data.
•   Geophysical test data.

Location Data:
•   X,X and Z coordinates.
•   Coordinate system  and projection in  use.

Water Level Data:
•   Location ID and X,X and Z coordinates.
•   Depth to water.
•   Date and time of measurement.
•   Measurement equipment or system used.

Laboratory Data:
•   Chain-of-custody information, e.g., sample collection information (date/time collected, sample
    matrix, etc.), preservatives used, sample containers used, and condition after transport, etc.
•   Lab results, e.g., analyses performed, parameters reported, analytical results, and analytical  method
    detection and reporting limits, etc.
•   QA/QC information, e.g., detection limits, QA/QC standard failures, laboratory narrative regarding
    non-compliance, etc.

Electronic Reports:
•   Complete electronic copies of all project documents and reports.
•   Complete electronic copies of all sampling field books and laboratory log books.
                                                                                        Page 2 of 4

-------
Links to Select State and EPA EDD  Guidance

The following organizations and programs are using Staged Electronic Data Deliverable (SEDD)
as the electronic format for the delivery of laboratory analytical data:

•    EPA [Contract Laboratory Program (CLP), Remedial Action Contracts (RACs), Superfund Technical
    Assessment and Response Team (START) contracts, Great Lakes National Program Office (GLNPO)
    Great Lakes Legacy Act Program]
•    U.S.Army Corps of Engineers [Formerly Used Defense Sites (FUDS), Military Munitions Response
    Program (MMRP)]
•    U.S. Department of Energy (Pantex Site, Amarillo.TX)
•    South Carolina Department of  Health and Environmental Control (Pilot Projects in the Bureau of
    Land and Waste Management and Bureau of Water)

SEDD is a uniform format for electronic delivery of analytical data for environmental programs.
More on SEDDs can be found at:
http://www.epa.gov/superfund/programs/clp/sedd-geninfo.htm

The following EPA Regions and states provide EDD guidance online:

EPA Region 2:
http://www.epa.gov/region02/superfund/medd.htm
EPA Region 3:
http://www.epa.gov/reg3hwmd/edd/index.htm
EPA Region 4:
http://www.epa.gov/region4/waste/sf/edd/edd.html
EPA Region 5:
http://www.epa.gov/region5superfund/edman/index.html
USAGE - New England District:
http://www.nae.usace.army.mil/reg/Dredging/RIM/edd.htm
California State Water Resources Control Board:
http://www.waterboards.ca.gov/water_issues/programs/ust/electronic_submittal/report_rqmts.shtml
Colorado Department of Public Health and Environment:
http://www.cdphe.state.co.us/hm/samsmain.htm
Louisiana Department of Environmental Quality:
http://www.deq.louisiana.gov/portal/LinkClick.aspx?fileticket=YeutTjisGwo%3D&tabid=2839
Minnesota Pollution Control Agency:
http://www.pca.state.mn.us/index.php/water/water-monitoring-and-reporting/storet/storet-redesign.html
Montana Department of  Environmental Quality:
http://deq.mt.gov/wqinfo/datamgmt/MTEWOX.mcpx
                                                                                     Page 3 of 4

-------
New Jersey Department of Environmental Protection:
http://www.state.nj.us/dep/srp/hazsite/news/2010090 l_file_format_change.htm
New York State Department of Environmental Conservation:
http://www.dec.ny.gov/chemical/62440.html
Texas Commission on Environmental Quality:
http://www.tceq.net/remediation/teds/teds.html
West Virginia Department of Environmental Protection:
http://www.dep. wv.gov/insidedep/Documents/4525_WVDEPEDD%20V2.2.pdf
Washington  Department of Ecology:
http://www.ecy.wa.gov/programs/tcp/data_submittal/Data_Requirements.htm
Data Interchange for Geotechnical and GeoEnvironmental Specialists (DIGGS):
http://www.diggsml.com/


Future Goals

The EPA Ground Water Forum recognizes that individual regional offices and units within regional offices
may  have different databases and  EDD requirements. The Ground Water Forum supports a consistent
EDD format among all EPA Regions and units in the future. A consistent EDD format would provide for
more efficient and transparent inter- and intra-agency data sharing, yet would allow each office to continue
to maintain its own database and enable the possibility of a future national database.

This effort is encouraged for use by other agencies and programs beyond EPA for ease of potential data sharing.


Glossary

Coordinates - A set of values represented by the letters x, y and optionally z or m (measure), that define
a position within  a  spatial reference. Coordinates are used to represent locations in space relative to
other locations.

Electronic Data  Deliverable  (EDD) - An  electronic  tabular format for  sharing,  manipulating,  and
using data.

Location - Uniquely identified point, typically at or below the ground surface, that can be identified spatially
by an x, y, and z coordinate.

Matrix - Describes the medium from which the sample was taken, such as drinking water,  non-potable
water, saline/estuarine water, soil, air, biological tissue, etc.
   United States                  Office of Solid Waste and         EPA 542-F-11-010
   Environmental Protection      Emergency Response            April 2011
   Agency                       (5203P)                         www.epa.gov/tio/tsp

                                                                                        Page 4 of 4

-------