By Isabelle Chenier, Aquatic Informatics
The City of Orlando Streets and Stormwater Division is responsible for maintaining and improving drainage facilities to prevent flooding and ensure all receiving water bodies meet state and federal water quality standards. They oversee upwards of 100 lakes within the city and approximately 147 drainage wells with seventy monitoring stations for lakes and waterways, and have twenty-three rainfall stations collecting data by telemetry over a cellular network. The Streets and Stormwater Division keeps two million people safe from flooding during heavy summer rainfalls and periodic tropical events.
COLLECTING DATA TO MAKE BETTER DECISIONS
As cities move to more electronic monitoring and automation there is an enormous amount of water data received on a daily basis, which can be extremely cumbersome to access and manage across all the departments. The City of Orlando’s existing data management was largely done in Excel and lacked any form of data defensibility. Additionally, the current system and quality assurance/quality control (QA/QC) process were labor intensive, preventing capacity for program expansion.
In recent years, the city has experienced more high-intensity rain events that have caused localized flooding during the summer rain season. These events coincide with an increase in the number of customer complaints that demand immediate response to ensure citizen safety and welfare. As the city was able to measure these rainfall events, they began to look for ways to turn this data into an actionable asset. To do this they would need a robust data management and decision support system that would allow them to expand their monitoring program, provide data defensibility, streamline data management and QA/QC, and help them turn their data into practical insights.
EVALUATING FLOOD DATA WITHOUT THE DELAY
The city implemented Aquarius to manage their data and publish information to all stakeholders. By connecting to sensors in real time, the software automatically imports and integrates data, giving operators a continuous stream of central intelligence without manual input. The platform keeps permanent records of original data and data quality is tracked with qualifiers and quality grades, giving operators the ability to compare raw and corrected data on a single chart and defend or retrace data with an automatic audit log. Operators can centrally manage data from all monitoring network locations, ensuring a single source of truth from disparate data sources.
Hensley Henry, Aquarius administrator for the city, who was responsible for setting up and configuring the system, says, “In the past, evaluating the impact of these heavy rain events required multiple spreadsheets and hours of manual effort. Now, with the push of a button, the software can create and retrieve customized intensities to evaluate isolated street flooding and protect the city against liability.”
The program can calculate derived data in real-time and run rating curves, calculate aggregates, and fill gaps in a matter of seconds. It is also capable of building more sophisticated multi-input time-series models. Aquarius pulls historical statistics and can visualize all types of data in different forms, including meteorological data.
“The new platform has boosted the value of our monitoring operations by making it easy to share data with citizens and actionable to professionals”, says Richard Lee, stormwater assistant division manager for the City of Orlando. Meaningful context (e.g., lake elevation criteria) and comparisons with historical data help transform current data into information and provide better insights during episodic events to guide management actions. By utilizing alerts and notifications based on custom levels, the city is proactively forecasting potential problems.
ESTIMATION REPLACED WITH EFFICIENCY
Internally, this means the overall efficiency for the team has improved. “We are able to trust the timely delivery of data, enabling us to be proactive, not reactive, and eliminate ad hoc data requests,” says Lee. Efficiency has improved as the guesswork is removed from field visits.
“We now know what to look for and how to respond based on the data. For example, a lot of rain in a certain area is likely to cause street flooding because of debris obstructing storm drains. Reviewing the data allows us to determine if the flooding is caused by an under designed system, or if it is simply an occurrence due to mother nature. For this case, we will dispatch crews to the area before we get customer complaints,” concludes Lee.
Flooding can also give rise to water quality issues. The city is in the process of expanding its water quality data management through the same platform which will then give stakeholders and citizens access to things like nutrient levels, bacteria counts and turbidity. At a glance citizen will be able to assess the health of Orlando’s water bodies. Alerts can be set so stakeholders can react to elevated E. coli values and be made aware of nitrogen, phosphorus, and chlorophyll concentrations that exceed the state’s surface water quality standards. Stakeholders will be able to evaluate the system quicker and develop management tools to help improve the water quality.
WORKING FAST MEANS WORKING SMART
The city’s team now has time to catch up on important administrative tasks and work on plans to incorporate stormwater flow data into Time-Series. This tool allows the city to centralize vast amounts of hydrologic time series data, discrete measurement data and complex river gauging measurements from various locations. It makes it easy to integrate, import, and enter data quickly, so they can effectively manage all their environmental information on one platform. Aquarius has a unique portfolio of features for real-time sanity checking, error detection, data cleaning, and rating shift management.
“At some point in the future, we would also like to add contour elevations in order to correlate lake stages with topographic, bathymetric, and basic water quality information for general purposes. Having this information will allow us to set the flooding levels at each location and have a better handle on the stage, area and discharge characteristics for each lake,” says Lee.
Maintaining and operating the city’s roadways and right-of-ways and ensuring efficient and safe transit on all city streets and pedestrian ways, as well as maintaining and improving the city’s drainage facilities, all falls on the shoulders of the Streets and Stormwater Division. Having timely and accurate information to empower better, faster decision-making helps guarantee public safety and government compliance.
PUBLIC DATA FOR THE PUBLIC GOOD
The data is easily accessible in real-time through an online dashboard for all stakeholders to prioritize and focus their efforts where needed. To broaden the sharing of data, in 2019 the city chose to make rainfall and stage information available to the public through the website hydrology.orlando.gov.
FOR MORE INFORMATION
Isabelle Chenier is strategic accounts manager at Aquatic Informatics. Aquatic Informatics provides software solutions that address critical water data management, analytics, and compliance challenges for the rapidly growing water industry. Water monitoring agencies worldwide trust Aquatic Informatics to acquire, process, model, and publish water information in real time. For more information, visit www.aquaticinformatics.com.
MODERN PUMPING TODAY, December 2020
Did you enjoy this article?
Subscribe to the FREE Digital Edition of Modern Pumping Today Magazine!