1 / 25

WQX Web and FIFRA Data EPA Region 5 pre-SFIREG meeting WQX demonstration

WQX Web and FIFRA Data EPA Region 5 pre-SFIREG meeting WQX demonstration . Larry Theller, ABE, Purdue University Leighanne Hahn, OISC Conference Call April 19, 2012 from 1:00 - 2:30 central time ( 2:00 - 3:30 eastern time).

hedia
Télécharger la présentation

WQX Web and FIFRA Data EPA Region 5 pre-SFIREG meeting WQX demonstration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WQX Web and FIFRA DataEPA Region 5pre-SFIREG meeting WQX demonstration Larry Theller, ABE, Purdue University Leighanne Hahn, OISC Conference Call April 19, 2012 from 1:00 - 2:30 central time (2:00 - 3:30 eastern time). The conference call number is 866-299-3188, conference code 7193131.

  2. WQX and FIFRA Data • What is WQX • How is it used • Original concept for data upload • Current “state of the art” data loader • Process flow • Data loader upgrades created for this project • Future Tool (2 year NEIEN project) OISCWQX

  3. WQX as Framework • The Water Quality Exchange (WQX) is a framework that makes it easier for States, Tribes, and others to submit and share water quality monitoring data over the Internet. • States, Tribes and other organizations can now submit data directly to the publicly-accessible STORET Data Warehouse using the WQX framework. • WQX will eventually replace the distributed STORET, the STORET Data Entry Module, Reports Module, and STORET Import Module or SIM as the primary means of submitting water quality monitoring data to EPA. OISC WQX

  4. CDX NODE WEB STORET OISC WQX http://www.epa.gov/storet/wqx/products/WQX_factsheet.pdf

  5. Win 2003 Server Proposed, Tested, but Not Implemented MySQL Backup of Prod. database abe2k3s2 Main Development Server Red Hat Entp MySQL Data Loader Test Query Test Authenticated QUERY to CDX abeip867 Ubuntu MySQL 2008 Purdue-OISC WQX NODE Design Interim Production Server Rollover to: ECN 8-Core Red Hat Server laptops Oracle Development (Test) computer Templeton.ecn 5 Permanent Production Server

  6. Spreadsheet of results Staging Excel Authenticated upload to staging database 1 OISC CDX QC done and Reformat to XML Current WQX Web Design Authenticated XML upload to CDX 2 6

  7. OISC WQX WQX_Web_User_Guide_v2.0.pdf

  8. OISC WQX

  9. WQX_Web_User_Guide_v2.0.pdf OISC WQX

  10. Project Name Monitoring Locations 2011 Activity - Results 2010Activity - Results 2009 Activity - Results OISC WQX http://www.epa.gov/storet/wqx/products/WQX_factsheet.pdf

  11. Sample XML for monitoring location upload. OISC WQX

  12. In this typical spreadsheet layout, the measurements are in columns, and each set of samples from a location is a row. OISC WQX 12

  13. The columns need to pivot so each measurement becomes one row, and the data collection notes need to be replicated for each measurement. OISC WQX

  14. OISC WQX

  15. The pink colored tab is used to export data for upload; The yellow tabs to set-up the input data; The green tabs provide a linked reference for documented elements in WQX. OISC WQX

  16. OISC WQX

  17. OISC WQX

  18. OISC WQX

  19. OISC WQX

  20. OISC WQX

  21. New Tool under development • Load and Flow Duration Curve (LDC) • Upload of flow data from USGS • Upload of water quality data from USGS • Upload of water quality data from WQX Current Grant: WQX data in Action OISC WQX

  22. OISC WQX

  23. OISC WQX

  24. Load and Flow Duration Curves OISC WQX

  25. The End OISC WQX

More Related