As Orlando measured heavy rainfall events, the city's Streets and Stormwater Division began to look for ways to turn its data into an actionable asset.
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 70 monitoring stations for lakes and waterways, and have 23 rainfall stations collecting data by telemetry over a cellular network. The Streets and Stormwater Division keeps 2 million people safe from flooding during heavy summer rainfalls and periodic tropical events.
Electronic Evolution for Monitoring
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.
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 said, “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 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, the city in 2019 chose to make rainfall and stage information available to the public through https://hydrology.orlando.gov/.
“The new platform has boosted the value of our monitoring operations by making it easy to share data with citizens and actionable to professionals”, said 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.
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,” said 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,” Lee added. “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.”
Expanding Water Quality Data
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, citizens 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.
The city’s team now has time to catch up on important administrative tasks and work on plans to incorporate storm water 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,” Lee said. ”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.”
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 & Stormwater Division. Having timely and accurate information to empower better, faster decision-making helps guarantee public safety and government compliance.