Great Lakes Restoration Initiative CEC database
A collaborative effort to monitor and assess potential exposure and effects of Chemicals of Emerging Concern on aquatic and other wildlife in the Great Lakes, funded as part of the Great Lakes Restoration Initiative (GLRI). This database includes environmental contaminant occurrence data and biological indicator data from Army Corps of Engineers, NOAA, US EPA, US FWS, and USGS. The full MySQL database is available for download and specific queried views are available as flat files. For more information, please contact Norman Adkins (adkins.norman@epa.gov).
The Space team has made the following datasets and collections publicly available. You must be a logged-in member of the Space to access all the datasets and collections.
Datasets
Viewing most recent datasets View All Datasets
Data Counts Views
Summary views showing the record counts by tab type. UNION of iacs, surveillance, gene_expression, metabolomics for all agencies.
GLRI Schema Views
Views showing the tables, columns, and view dependencies.
Synthesis Views
Views showing detailed measured data over multiple agencies. UNION of IACS surveillance gene_expression and metabolomics. Biological, water chemistry, and sediment chemistry queries.
Taxonomy View
A view joining the Taxonomy tables.
Measurement View
A view joining the measurement tables.
IACS Views
Integrated Assessment Case Studies (IACS) views joining multiple tables of measured data over multiple agencies. USGS Tree Swallow data, FWS Fathead minnow and Mussel data, EPA Fathead minnow data.
Chemical View
A view joining the chemical tables
Gene Expression Views
Contains a view joining the gene tables and views containing gene expression measured results. USACE Fathead Minnow data.
Metabolomics Views
Contains metabolomics detailed views and metabolite view. EPA Targeted HepG2, USGS Tree Swallow, NOAA Mussel data.
Collections
Viewing most recent collections View All Collections
GLRI Database Export Collection
Contains the MySQL Database export files. Used when importing to a new MySQL database.
GLRI Data Collection
Contains datasets for table data and for views by each category of data.
The following datasets have been published through this Space and any affiliated Spaces.