1 / 16

Water & Wastewater Data Management

Water & Wastewater Data Management. NTLAS Chapter Meeting July 21 st , 2009 Scott Dorner Hach Company. Water & Wastewater Data Management. Water and Wastewater Utilities need to analyze and report on a wide range of data sets including: Lab (LIMS, outside Labs)

kolton
Download Presentation

Water & Wastewater Data Management

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 & Wastewater Data Management NTLAS Chapter Meeting July 21st, 2009 Scott Dorner Hach Company

  2. Water & Wastewater Data Management • Water and Wastewater Utilities need to analyze and report on a wide range of data sets including: • Lab (LIMS, outside Labs) • Process (SCADA/Historians, data loggers) • Field (Operator benchsheets and logs) • Plant Maintenance (CMMS) • Miscellaneous (USGS, Weather, EPA …)

  3. Laboratory Information Management System (LIMS) • Typically produces 20% - 40% of the data for the Utility • Sample Scheduling • Sample Login and Tracking (Chain of Custody) • Enter/Verify Results • Report Results (Certificate of Analysis) • Instrument Interfacing • QC Analysis

  4. Commercial Off The Shelf (COTS) LIMS Vendors ATL – SampleMaster, Bulldog http://www.atlab.com Perkin Elmer – Labworks www.labworks.com LabVantage – Sapphire www.labvantage.com Several others including Tribal, Labsoft, etc…

  5. SCADA (Supervisory Control And Data Acquisition) • Typically produces 20% - 30% of the data for the Utility • Collects data from field/online devices such as PLC’s/RTU’s • Allows Users to control pumps, blowers, etc…, change set points in PLC’s. • Human Machine Interface (HMI) gives users a real time view of the process • Alarms on real time conditions • Logs data to Historians

  6. SCADA HMI Example • Collects data from field devices such as PLC’s/RTU’s • Allows Users to control devices, change set points in PLC’s. • Gives users a real time view of the process

  7. SCADA Vendors • GE Fanuc – iFix (formerly Intellution) • Wonderware – InTouch • Rockwell – RsView 32, RsView SE • Systems are usually implemented by System Integrators who program the PLC’s, connect 4-20MA, and design the HMI Screens

  8. Historians • Logs Raw Data down to the millisecond from the SCADA system • Offers “open” database for retrieval and analysis. • Official record that cannot be changed. • Buzzwords – SQL, ODBC, OLE DB, Data Compression • Typically comes with the HMI software

  9. Water Information Management • Combining the data from other systems which are typically islands or silos of data • Allow entry of operator log sheets. 10-40% of data. • Perform calculations – Loading, CT ratios, Weekly Averages, handle data qualifiers, 10%-15% of data • Produce regulatory and process analysis reports • Excel is often used to combine and calculate the data • Users spend hours copying/reentering data, preparing reports, troubleshooting data • Database management systems such as Oracle, Microsoft SQL Server, Access… are the better approach

  10. Spreadsheets vs Databases • Spreadsheets have no multiuser ability • Spreadsheets have no audit trail. • Difficult to perform calculations with data qualifiers, moving averages, etc… • Databases have an unlimited capacity (analyzing years of data is easy) • Hidden costs in spreadsheets. Users spend hours copying/reentering data, preparing reports, troubleshooting data, fixing broken links • A spreadsheet is a great one-time analysis tool

  11. WIMS Vendors • Hach WIMS (formerly OPS SQL) www.hach.com/im • Operator 10 by Allmaxwww.operator10.com • Microsoft Excel • Custom Development by Consulting Engineers

  12. Texas Wastewater Regulatory Reporting • Texas eDMR and NetDMR • NetDMR replaces eDMR (STEERS) program starting in July 2009 for all Texas Pollutant Discharge Elimination System permittees. Allows users to electronically sign and submit water quality discharge-monitoring reports (DMRs) to the TCEQ. See http://www.tceq.state.tx.us/compliance/netdmr/netdmr.htmlfor more information on the Texas eReporting system.  • A comma separated values (CSV) file that contains summary values similar to the DMR (NPDES Form):

  13. Texas Wastewater Regulatory Reporting • Enter data using the state’s web site • Hach WIMS provides a straight forward way to produce the file.

  14. Texas Drinking Water Regulatory Reporting • Excel files provided by the state to be filled out: • Surface Water Monthly Operating Report • Total organic carbon monthly operating report • etc… • See www.tceq.state.tx.us/permitting/water_supply/pdw/swmor/swmor/index_monitoring.html • User must fill out these forms and submit.

  15. Texas Drinking Water Regulatory Reporting Hach WIMS provides a tool to map your data to the form.

  16. Questions? Go to: http://www.opssys.com/instantkb/article.aspx?id=12418 To download or review a copy of this presentation.

More Related