Improving Mid-Pacific Region Programs' water quality data management to enhance user access, analysis and decision-support

Project ID: 7124
Principal Investigator: Laurel Dodgen
Research Topic: Water Quality
Funded Fiscal Years: 2017, 2018, 2019 and 2020
Keywords: None

Research Question

This research project intends to address the following questions:
a) How can BOR-MP-DEA better support the environmental data needs of internal/external stakeholders?
b) How can BOR-MP-DEA information be centralized and integrated with time-series capabilities and with GIS capabilities?
c) How can BOR-MP-DEA information be enhanced to integrate BOR - wide 'open water data' efforts?

Need and Benefit

The BOR-MP-DEA generates large volumes of information (data/documents) in support of environmental compliance programs. This information is stored in multiple platforms (database, shared drives) which are mostly being used as repositories with limited or no capability to integrate data in time-series and associate data/documents to geographical information services (e.g. GIS Portal, TESSEL). To enhance the current capability while integrating BOR-wide ongoing data management efforts (e.g. RISE,RWIS, BOR DRUPAL) it is necessary to upgrade the EMD internal user interface from Microsoft Access to Oracle and to complete the EMD external user interface transition from Adobe Cold Fusion to PHP. It is necessary to develop a BOR-MP-DEA database to centralize environmental documentation using DRUPAL capability and it is necessary to explore the integration of the various databases into the web based BOR GIS application.

Contributing Partners

Contact the Principal Investigator for information about partners.

Research Products

Bureau of Reclamation Review

The following documents were reviewed by experts in fields relating to this project's study and findings. The results were determined to be achieved using valid means.

Improving California-Great Basin Region Program's Water Quality Data Management to Enhance User Access, Analysis and Decision-Support (final, PDF, 919.6MB)
By Laurel Dodgen, Richard Stack, Tiago S Oliveira
Report completed on September 30, 2021

This research product summarizes the research results and potential application to Reclamation's mission.


Return to Research Projects

Last Updated: 6/22/20