Datasets in Space Great Lakes Restoration Initiative CEC database
The Space team has made the following datasets publicly available.
Data Counts Views
Summary views showing the record counts by tab type. UNION of iacs, surveillance, gene_expression, metabolomics for all agencies.
- 0 18 0 714 6
GLRI Schema Views
Views showing the tables, columns, and view dependencies.
- 0 4 0 870 7
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.
- 0 17 0 762 6
Taxonomy View
A view joining the Taxonomy tables.
- 0 1 0 727 8
Measurement View
A view joining the measurement tables.
- 0 1 0 671 6
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.
- 0 62 0 693 3
Chemical View
A view joining the chemical tables
- 0 2 0 750 5
Gene Expression Views
Contains a view joining the gene tables and views containing gene expression measured results. USACE Fathead Minnow data.
- 0 14 0 669 6
Metabolomics Views
Contains metabolomics detailed views and metabolite view. EPA Targeted HepG2, USGS Tree Swallow, NOAA Mussel data.
- 0 11 0 670 5
Location View
A view joining the location tables.
- 0 1 0 589 4
Surveillance Views
Contains views of Surveillance data joined to the needed tables. Contains multiple agencies. NOAA mussel data, USGS water and sediment chemistry.
- 0 27 0 543 4
GLRI Data Model
The entity relationship diagrams and the GLRI MySQL data modeler file.
- 0 10 0 799 5