Presented by equilibrium sept 2012
Download
1 / 11

Presented By Equilibrium Sept, 2012 - PowerPoint PPT Presentation


  • 109 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Presented By Equilibrium Sept, 2012' - quyn-gray


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Presented by equilibrium sept 2012

WQX

Presented By Equilibrium

Sept, 2012


Purpose
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
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


Storet
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/


WQX

  • Framework for data submission to STORET

    • http://www.epa.gov/storet/wqx/index.html

  • Water Quality Exchange

    • National Environmental Information Exchange Network


Tasks
Tasks

  • Task 1: Initiate User Interface with Database

  • Task 2: Inputting Data into WQX Database

  • Task 3: Orientation of ANRC Staff

  • Task 4: Reporting


Uploading the data
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


Retrieval of data
Retrieval of Data

  • http://www.epa.gov/storet/

  • Querying data

  • http://www.epa.gov/storet/otherapps.html

  • E-mail confirmation

  • Opening Data in Excel


Trouble shooting
Trouble Shooting

  • Dictionary provided with Template

    • Outline

    • Allowable values

    • http://www.epa.gov/storet/faq.html

    • http://www.epa.gov/storet/storet_helpdesk.html


Acknowledgements

equilibrium


ad