1 / 0

WQX Web and FIFRA Data

WQX Web and FIFRA Data. Larry Theller, ABE, Purdue University Leighanne Hahn, OISC March 22, 2012. 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

khalil
Download Presentation

WQX Web and FIFRA Data

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 Data

    Larry Theller, ABE, Purdue University Leighanne Hahn, OISC March 22, 2012
  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)
  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.
  4. CDX NODE WEB STORET 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 Purdue-OISC WQX NODE Network Design Interim Production Server Rollover to: ECN 8-Core Red Hat Server laptops Oracle Development (Test) computer Templeton.ecn 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 Interim Production Server
  7. WQX_Web_User_Guide_v2.0.pdf
  8. WQX_Web_User_Guide_v2.0.pdf
  9. Project Name Monitoring Locations 2011 Activity - Results 2010Activity - Results 2009 Activity - Results http://www.epa.gov/storet/wqx/products/WQX_factsheet.pdf
  10. Sample XML for monitoring location upload.
  11. In this typical spreadsheet layout, the measurements are in columns, and each set of samples from a location is a row.
  12. The columns need to pivot so each measurement becomes one row, and the data collection notes need to be replicated for each measurement.
  13. 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.
  14. 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
  15. Load and Flow Duration Curves
  16. The End
More Related