1 / 16

Water Quality Exchange and Web Tools

Water Quality Exchange and Web Tools. Utah Monitoring Council February 25 th , 2010 Presented by James Harris Division of Water Quality. DWQ Database. EPA ceased support of STORET database in Fall 2009 DWQ needs new database solution

yardan
Download Presentation

Water Quality Exchange and Web Tools

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. Water Quality Exchangeand Web Tools Utah Monitoring Council February 25th, 2010 Presented by James Harris Division of Water Quality

  2. DWQ Database • EPA ceased support of STORET database in Fall 2009 • DWQ needs new database solution • Share data and management tools with outside cooperators • Move from desktop program to web client

  3. Ambient Water Quality Management System (AWQMS) • Migrated data • Delivered database solution in late 2009 • Created test environment • Currently installing on DEQ servers

  4. Interagency Project Team • AWQMS Core Application • EPA • IL, MN, UT • National Park Service • Graphs and Reports • EPA Region VIII • WQX Export • Region VIII Tribes

  5. Expanding on WQX Web • CDX Web • Online Registration • Log In • AWQMS Import Module • Log In • Import Flat File • Apply Defaults & Translations • Validate & Correct • Migrate to AWQMS Database • WQX Web • Import Flat File • Apply Defaults & Translations • Validate & Correct • Export XML • WQX • Load XML File • Update Database • Processing Report • Node Client • Submit • Get Status • Download CDX Node • AWQMS • Edit/QA the Data • Reporting • Graphing • Export XML • State Node • Submit • Get Status • Download

  6. AWQMS Components • Batch Import (WQX Web) • Data Entry / Update Pages • Graphs and Reports • WQX Export • Integrated Node Client

  7. Benefits • Excel -> AWQMS -> WQX • Real Time Data Analysis and Reporting • Only Requires a Web Browser & Internet Connection • Remote Access

  8. http://awqmsut.goldsystems.com/

  9. Exchange Network Grant • 2009 DWQ received and EN grant • Web tools and database customization • Integration with field PDAs • Reporting, mapping and graphing tools • Web client for Monitoring Council members • Link to Assessment DataBase (ADB) for integrated reporting

  10. www.waterquality.utah.gov

  11. www.waterquality.utah.gov/Monitoring/Council

  12. www.waterquality.utah.gov/Monitoring/Council

  13. Monitoring Council Listserv

  14. Subscribe-deq-wqmonitoringcouncil@list.utah.gov Monitoring Council Listserv

  15. Web Tools and Resources • What do you want to see? • What data analysis and web tools would be helpful? • SOPs, QAPPs, etc. • Training materials • Forums?

More Related