If you are experiencing problems downloading PDF or HTML fulltext, our helpdesk recommend clearing your browser cache and trying again. If you need help in clearing your cache, please click here . Still need help? Email help@ingentaconnect.com

GOT DATA? A MASSIVE EFFORT TO COLLECT AND MANAGE DATA WILL GIVE MODELERS AND MUNICIPALITIES THE UPPER HAND WHEN DEALING WITH REGULATORS

$17.50 plus tax (Refund Policy)

Buy Article:

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

DOI: http://dx.doi.org/10.2175/193864705783866748

Publication date: January 1, 2005

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.

    WEF Members: Sign in (right panel) with your IngentaConnect user name and password to receive complimentary access.
  • Subscribe to this Title
  • Membership Information
  • About WEF Proceedings
  • WEFTEC Conference Information
  • ingentaconnect is not responsible for the content or availability of external websites

Tools

Favourites

Share Content

Access Key

Free Content
Free content
New Content
New content
Open Access Content
Open access content
Subscribed Content
Subscribed content
Free Trial Content
Free trial content
Cookie Policy
X
Cookie Policy
ingentaconnect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more