Skip to main content


Buy Article:

$17.50 plus tax (Refund Policy)

Or sign up for a free trial


The Miami-Dade Water and Sewer Department (MDWASD) is the 5th largest water and sewer utility in the United States. MDWASD, inclusive of the municipalities it serves, has a very complex wastewater collection and transmission system consisting of over 2000 pump stations, 1000 miles of force mains, and 4000 miles of gravity sewers. A Peak Flow Management Study, which includes the construction of a hydraulic computer model of this system, was mandated as part of an EPA settlement agreement. As part of this agreement, MDWASD was required to install supervisory Control and Data Acquisition (SCADA) telemetry on all of the pump stations it owns. Presently, SCADA is installed on 85% of the stations. MDWASD has recognized the benefit of SCADA as a long-term, data collection, system. This data proved useful when MDWASD reviewed major storm events during 1998 and 1999 to quantify rainfall dependent infiltration and inflow (RDII) and to determine the relationship between rainfall and RDII.

This paper presents the MS Access application developed to quantify the individual pump station's RDII response. Spreadsheet applications were first employed but the volume of data overwhelmed the spreadsheet capacity. MS Access was chosen because of its availability and ease of use. Novice MS Access users can implement this application and customize it at will. Once RDII is quantified in a digital database format, a myriad of relationships can be developed. The biggest advantage to this application to the engineering community is that the RDII can be quantified, related to rainfall, and documented for pre- and post-rehabilitation analyses.

Document Type: Research Article


Publication date: 2000-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.

    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
  • Ingenta Connect is not responsible for the content or availability of external websites
  • Access Key
  • Free ContentFree content
  • Partial Free ContentPartial Free content
  • New ContentNew content
  • Open Access ContentOpen access content
  • Partial Open Access ContentPartial Open access content
  • Subscribed ContentSubscribed content
  • Partial Subscribed ContentPartial Subscribed content
  • Free Trial ContentFree trial content
Cookie Policy
Cookie Policy
Ingenta Connect 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