The Environmental Monitoring Database (EMD) was first developed in March 2003 to store lake, river, estuary, and ocean data. The goal was to standardize the wide variety of data sets into one database system built according to existing national data standards for use in surface water quality assessments. Ultimately, the database was needed to meet EPA’s STORET reporting requirements and the subsequent Water Quality Exchange (WQX).
It has a similar format to the EPA’s: organizations (data owners) can have many monitoring projects which can share stations (monitoring locations). Activities (samples, measurements and/or observations) take place at stations.
The EMD has expanded over the years to include groundwater, soil and air data with contributions from the Site Remediation, Superfund, and Air programs as well as data from agencies outside of the DES such as the Department of Transportation, University of New Hampshire, and Upper Merrimack Monitoring Program. Other organizations with New Hampshire monitoring data are encouraged to contribute data to this database. The goal of the database has been expanded toward developing a statewide repository of environmental monitoring data.
Data can be submitted through the OneStop Provider web page. Providers must pre-register and obtain approval to upload data. Typically this approval process takes less than a day or two. Data is submitted for stations and activities using Microsoft Excel templates. These templates contain information on the required format and domain lists as well an example of a data record. When templates are uploaded via a web interface, the data is automatically checked for validity and error messages (if any) are displayed detailing the row, column, and problem. Once a file passes validation, it is further reviewed by DES data management staff. If approved, it is incorporated into the database and the provider is notified of the inclusion. If there is a problem, the file is rejected and the provider is notified of what is needed to correct the file and encouraged to resubmit. If an organization would like to contribute data but is lacking resources to use the templates or needs assistance, please contact Deb Soule at (603) 271-8863 or [email protected].Data can also be retrieved from the EMD through the EMD’s OneStop retrieval web page. Once the type of data to query is selected (grab samples or time series results from automated data loggers), a query form appears. Guidance on querying the database is provided via links at the top of the respective query forms. For data to be returned, it must meet all of the query parameters entered. If conflicting specifications (such as searching for estuarine type stations and data for a particular lake) are entered, no data will be returned. Results are returned in a spreadsheet that can be opened via a web browser or saved as an Excel file. The available query is intended for general querying of the EMD. Site remediation professionals should note that a query specifically designed to report contaminated site data is under development. If query assistance is needed, please contact Deb Soule at (603) 271-8863 or [email protected].