presented by equilibrium sept 2012 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Presented By Equilibrium Sept, 2012 PowerPoint Presentation
Download Presentation
Presented By Equilibrium Sept, 2012

Loading in 2 Seconds...

play fullscreen
1 / 11

Presented By Equilibrium Sept, 2012 - PowerPoint PPT Presentation


  • 110 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


Download Now 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/
slide5
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
slide11

Acknowledgements

equilibrium