Standards-based Integration and Delivery of USGS and EPA STORET Biomonitoring Data via the Water Quality Data Portal

Citation

Langseth, M.L., Chang, M.Y., Carlino, Jennifer, Bellmore, J.R., Birch, D.D., Bradley, Joshua, Bristol, R.S., Buscombe, D.D., Duda, J.J., Everette, A.L., Graves, T.A., Greenwood, M.M., Govoni, H.S., Henkel, H.S., Hutchison, V.B., Jones, B.K., Kern, Tim, Lacey, Jennifer, Lamb, R.M., Lightsom, F.L., Long, J.L., Saleh, R.A., Smith, S.W., Soulard, C.E., Viger, R.J., Warrick, J.A., Wesenberg, K.E., Wieferich, D.J., and Winslow, L.A., 2016, Community for Data Integration 2015 annual report: U.S. Geological Survey Open-File Report 2016–1165, 57 p., http://dx.doi.org/10.3133/ofr20161165.

Summary

The purpose of this project was to test and develop first-generation biological data integration and retrieval capabilities for the Water Quality Portal (National Water Quality Monitoring Council, [n.d.]) using the Water Quality Exchange (WQX) data exchange standard (Environmental Information eXchange Network, 2016). The Water Quality Portal (Portal) is a significant national water data distribution node that is aligned with the vision of the Open Water Data Initiative (Advisory Committee on Water Information, [n.d.]). The Portal is sponsored by the USGS, the EPA, and the National Water Quality Monitoring Council. The WQX data exchange standard is a mature standard widely adopted within the water quality monitoring community and is [...]

Summary

The purpose of this project was to test and develop first-generation biological data integration and retrieval capabilities for the Water Quality Portal (National Water Quality Monitoring Council, [n.d.]) using the Water Quality Exchange (WQX) data exchange standard (Environmental Information eXchange Network, 2016). The Water Quality Portal (Portal) is a significant national water data distribution node that is aligned with the vision of the Open Water Data Initiative (Advisory Committee on Water Information, [n.d.]). The Portal is sponsored by the USGS, the EPA, and the National Water Quality Monitoring Council. The WQX data exchange standard is a mature standard widely adopted within the water quality monitoring community and is used to support data flows into EPA’s STORET data warehouse. The WQX standard also provides the data integration framework for physical-chemical water quality data currently served by the Water Quality Portal. The standard supports taxon abundance data including population census, frequency class, group summaries, individual results, biological index scores, and biological scoring metrics, but prior to the inception of this project, the Portal did not deliver those types of data.

The specific objective of this project was to integrate and deliver fish community data from two large Federal data sources: (1) the USGS BioData system and (2) USEPA STORET. The processes, tooling, and experience gained can then be applied to incorporate additional biological data from these and other sources.

Accomplishments

This project team successfully developed the ability for the public to retrieve BioData and STORET fish community data from the Water Quality Portal Web site (fig. 18). This was accomplished in July 2015 and provides access to over 680,000 BioData and STORET fish abundance records for over 13,000 sites. As of February 2016, over 11,000 download requests have included BioData fish community data.

Note: This description is from the Community for Data Integration 2015 Annual Report.

Contacts

Principal Investigator :: Peter M Ruhl
Cooperator/Partner :: James M Kreft, Charles Kovatch
CMS Group :: Community for Data Integration - CDI

Attached Files

sorting

Metadata First

Recent First

Alphabetical

Click on title to download individual files attached to this item.

figure18.png “Workflow for retrieving BioData and STORET fish community data ”		544.19 KB	image/png

Related External Resources

Type: Web Application

National Water Quality Monitoring Council's Water Quality Data Portal	http://waterqualitydata.us/portal/

Type: Citation

National Water Quality Monitoring Council, [n.d.], Water quality portal: U.S. Geological Survey and Environmental Protection Agency, accessed February 29, 2016 (content no longer available)	http://waterqualitydata.us/
Environmental Information eXchange Network, 2016, Water Quality Exchange—WQX: Environmental Information eXchange Network, accessed February 29, 2016, at	http://www.exchangenetwork.net/data-exchange/wqx/
Advisory Committee on Water Information, [n.d.], Open water data initiative overview: Water Information Coordination Program, accessed on March 29, 2016, at	http://acwi.gov/spatial/owdi/

Project Extension

projectStatus	Completed

Standards-based Integration and Delivery of USGS and EPA STORET Biomonitoring Data via the Water Quality Data Portal

Citation

Summary

Summary

Accomplishments

Contacts

Attached Files

sorting

Metadata First

Recent First

Alphabetical

Project Extension

Preview Image

Communities

Tags

Provenance

Item Actions

View Item as ...

Save Item as ...

View Item...

Citation

Summary

Summary

Accomplishments

Contacts

Attached Files sorting Metadata First Recent First Alphabetical

Related External Resources

Project Extension

Preview Image

Communities

Tags

Provenance

Item Actions

View Item as ...

Save Item as ...

View Item...

Attached Files

sorting

Metadata First

Recent First

Alphabetical