GOT DATA? A MASSIVE EFFORT TO COLLECT AND MANAGE DATA WILL GIVE MODELERS AND MUNICIPALITIES THE UPPER HAND WHEN DEALING WITH REGULATORS
Abstract:The City of Columbus, Ohio is developing their Long Term Control Plan. A portion of the work consisted of a large, intensive data collection effort, gathering information about the local rivers, stormwater system, combined sewer system, separate sewer system, and wastewater treatment plants. Data collected ranges from mussel surveys on the local rivers to flow monitoring in the combined sewer system. One of the particularly challenging aspects of the projects was achieving stability in the dissolved oxygen calibration for water quality measurement devices installed at 34 locations in area rivers. The dissolved oxygen calibration would drift toward saturation, and then above saturation, during deployment. Tests were conducted to determine the source of the calibration error using aerated tap-water baths. In the end, thicker membranes and longer burn-in time before calibration helped solve this problem and reduce drift in the sensors during deployment. Bacteria concentration was also a parameter of concern. It was found that stormwater was a major bacteria contributor to local streams, and helped increase the stream concentrations above State of Ohio water quality standards, even upstream of the combined sewer system. This immense data collection effort will help the City characterizing the receiving streams in Central Ohio and developing their Long Term Control Plan for CSOs.
With a number of different sources being subjected to many different tests, an intelligent database was needed in order to store all the data so that it would be readily accessible to quality assurance personnel and modelers. The Malcolm Pirnie developed Time Series Analyzer (TSA) program was used to import, check, modify, graph and export the data. An important feature of TSA is that it records any changes to the data, along with the date, time, reason, and individual who made the changes. This maintains the integrity of the original values while recording any changes and their source. This application also adds value to the data because it makes the data more readily accessible, more organized, and in the end provides an electronic deliverable for the City to incorporate with their current database.
Document Type: Research Article
Publication date: 2005-01-01
More about this publication?
- Proceedings of the Water Environment Federation is an archive of papers published in the proceedings of the annual Water Environment Federation® Technical Exhibition and Conference (WEFTEC® ) and specialty conferences held since the year 2000. These proceedings are not peer reviewed. A subscription to the Proceedings of the Water Environment Federation includes access to most papers presented at the annual WEF Technical Exhibition and Conference (WEFTEC) and other conferences held since 2000. Subscription access begins 12 months after the event and is valid for 12 months from month of purchase. A subscription to the Proceedings of the Water Environment Federation is included in Water Environment Federation (WEF) membership.
WEF Members: Sign in (right panel) with your IngentaConnect user name and password to receive complimentary access. Access begins 12 months after the conference or event
- Subscribe to this Title
- Membership Information
- About WEF Proceedings
- WEFTEC Conference Information
- Learn about the many other WEF member benefits and join today
- Ingenta Connect is not responsible for the content or availability of external websites