County improves watershed monitoring tools & reporting, engages community during population growth
Pierce County Planning & Public Works
Pierce County, WA
Outdated database constrained the stormwater utility's ability to store growing amount of data and differing data formats, limiting both usage of watershed data and public accessibility. Modern database harmonizes data types, enables deeper data analysis, and invites data exploration by residents.
Initial: 227 Thousand USD
O&M: 34 Thousand USD
General Fund/Existing Public Funds
Operational since 2018
Pierce County's Planning & Public Works Department needed to upgrade its systems to better monitor the water supply and enhance public outreach.
With Seattle's hiring boom in recent years, the Puget Sound region was welcoming as many as 200 people a day during its peak.
Water quality has declined in most areas of Pierce County as the population and development have grown over the past century. The most common water quality concerns in Pierce County streams are high levels of bacteria, nitrogen and phosphorus, elevated summer temperatures, and low dissolved oxygen concentrations.
Pierce County wanted to manage population growth and not compromise the quality of life for its residents and businesses. Like many utilities, Planning and Public Works had legacy databases of long-term hydrologic and water quality data that could not automatically migrate data from a variety of sources, verify data or make data easily accessible to users. The once effective systems were almost 20 years old. Servers and custom-built databases were no longer supported.
A new solution was needed to address the department’s goals of preventing polluted stormwater from entering the water supply in addition to reducing flood risk. Moreover, a system compatible with evolving technologies would help the County maintain public safety, meet regulatory requirements and enhance public outreach.
The county's new water software enables staff to better monitor the water supply and meet future data needs without further investment.
WISKI enables local governments to future-proof water data storage and processing.
The flexible architecture grows with an agency's needs in terms of data volume and technological innovation. The system was selected because it enables the County to meet future data needs without additional cost from the developer.
In the present, the solution enables the County to use limited resources with maximum efficiency. Data of different time steps are consolidated into one repository that also manages metadata, ensuring more data integrity and discoverability by environmental analysts and planners.
As more and diverse water quality data are collected, automated quality checks test new information streaming into today’s system, which automatically records all data transactions. A full audit log traces software users authorized to edit erroneous data points and why and when changes were made.
APIs enable multi-department data consumers to use GIS as well as python scripting to analyze data and interpret information without the requirement of learning an unfamiliar software.
Staff environmental scientists & specialists are able to integrate hydrological, water quality sampling and biosurvey datasets -- increasing data usability and doing deeper analysis.
Time-savings and higher level of data quality result from application of standardized quality assurance and quality control procedures. Both automated and manual protocols are used.
Ability to enrich public outreach and engagement efforts with the addition of an interactive web portal; visitors can filter, view tables and graphs, and export approved data
Scientists & modelers who inform decisions now face fewer demands on time from data loss, silos or outdated IT. Instead, they focus on detecting and responding to environmental threats.
The neighboring stormwater utility Snohomish County Surface Water Management (SWM) also uses the solution, so peers are able to discuss regional challenges & share best software practices.
Who Should Consider
Water agencies near fast-growing metros who have diverse water quality monitoring program data stored separately and unable to efficiently/fully use info for public safety & engagement as well as regulation.
Last UpdatedMar 25th, 2022
More resources about this case study