Estuary-Wide Data Repository for the Delta Environmental Data to Understand a California Estuary

The Sacramento-San Joaquin Delta (Delta) is the backdrop for some of the most pressing water supply and natural resource management issues facing California. To navigate such matters comprehensively with transparency, and rigor, it is important to ensure broad dissemination of data. An Environmental Data Summit held in 2014 created a new era in information management and knowledge discoveries, and shed light on challenges associated with the use of disparate datasets. The Delta Environmental Data for the Understanding a California Estuary (DEDUCE), a collaborative project, builds upon the Data Summit vision and initiated a forum to integrate disparate data from multiple sources and legacy data that are currently not in any of the State’s data sharing systems.

DEDUCE expanded the existing infrastructure to house water quality data from the Delta to address management questions by identifying and collecting high priority data according to rigorous business rules and mapping these data to a central system. This important step of harmonizing the data improves its interoperability and increases the access to and exchange of high-quality environmental data. DEDUCE facilitates the upload, aggregation and display of data in tools such as those created under the auspices of the California Water Quality Monitoring Council, including EcoAtlas and My Water Quality Portals, and CD3: Contaminant Data Display and Download tool for accessing and visualizing data comparable to State standards.

DEDUCE achieved collecting and uploading the legacy and toxic contaminant data, and established design standards to exchange future datasets from the initial data storage or database to California Environmental Data Exchange Network (CEDEN). This data integration effort created accurate, accessible, and synthesized data for scientists and decision-makers as a foundation to inform management actions with the best available science.