1 / 11

Presented By Equilibrium Sept, 2012

WQX. Presented By Equilibrium Sept, 2012. Purpose. Demonstrate the ability to utilize STORET/WQX Submit water quality data to database for sharing with state, federal, and private organizations Retrieve data from database. Background. STORET (Storage and Retrieval) EPA Data Warehouse

quyn-gray
Download Presentation

Presented By Equilibrium Sept, 2012

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 Presented By Equilibrium Sept, 2012

  2. Purpose • Demonstrate the ability to utilize STORET/WQX • Submit water quality data to database for sharing with state, federal, and private organizations • Retrieve data from database

  3. Background • STORET (Storage and Retrieval) EPA Data Warehouse • Water quality, biological, physical • State, federal, universities, private organizations • WQX (Water Quality Exchange) Framework for submission to STORET • Environmental sampling, analysis, results

  4. STORET • Short for Storage and Retrieval • EPA Data Warehouse for water quality, biological, and physical data used by state and federal agencies, universities, private citizens, and many others. • http://www.epa.gov/storet/

  5. WQX • Framework for data submission to STORET • http://www.epa.gov/storet/wqx/index.html • Water Quality Exchange • National Environmental Information Exchange Network

  6. Tasks • Task 1: Initiate User Interface with Database • Task 2: Inputting Data into WQX Database • Task 3: Orientation of ANRC Staff • Task 4: Reporting

  7. Uploading the Data • First – Download excel template file • http://www.epa.gov/storet/wqx/wqxweb_downloads.html • Biological • Chemical • Habitat • Allows user to format data • Utilizes macro in Microsoft Excel

  8. Retrieval of Data • http://www.epa.gov/storet/ • Querying data • http://www.epa.gov/storet/otherapps.html • E-mail confirmation • Opening Data in Excel

  9. Trouble Shooting • Dictionary provided with Template • Outline • Allowable values • http://www.epa.gov/storet/faq.html • http://www.epa.gov/storet/storet_helpdesk.html

  10. Acknowledgements equilibrium

More Related