Data Explorer for Learning, Visualization, and Export (DELVE) for CA DWR

To achieve compliance with AB 1755, DWR needed to design and deploy a database system, and they also needed to design and implement process workflows related to data management, quality control, and documentation. The solution we delivered, known as Data Explorer for Learning, Visualization, and Export (DELVE), provides the foundation for a standardized statewide platform with access for the public and integrations for regional water districts and other stakeholders.

The ESA Technology Services group developed the DELVE system to store and facilitate access to valuable environmental data collected by DWR, while allowing for the visualization of that data in an intuitive interface. DELVE will serve as the long-term repository for existing and future data sets, including fisheries, biotelemetry, hydrodynamic, water quality, and other sources.

DELVE facilitates data sharing through API integrations with the CNRA Open Data Portal, enabling DWR to operate and maintain a statewide integrated water data platform. The solution additionally establishes data standards for common structures—including acoustic telemetry, acoustic Doppler current profiler (ADCP), and water quality time series data—and equips DWR with automated QA/QC tools, including configurable visualizations of structured data.