The City of Tacoma’s Department of Public Utilities had a thorny challenge. Each quarter, the City must collect and analyze large volumes of surface water-flow and chemical analytical data and report its findings to the Washington State Department of Ecology (Ecology).
Each reporting cycle, the City’s water quality lab provides the raw data for the reports in a series of spreadsheets. City staff had to process the raw data, re-enter it into different spreadsheets and produce the report according to Ecology specifications. This unwieldy process required nearly three months and three full-time staff to complete.
The City hoped to find a solution that would streamline the project and free up time to more fully evaluate and draw conclusions from the data, but it had limited IT resources to implement a technology solution. City staff discussed the challenge with a GeoEngineers scientist who specializes in water-quality issues, and he suggested that the City engage GeoEngineers’ Applied Technology team to evaluate the challenge.
GeoEngineers’ Applied Technology team brought the City’s water quality, IT and lab staff together for a Rapid Assessment Workshop, a one-day discussion to identify objectives, data sources and wishes and match these needs with available software products and platforms. From this discussion, the City confirmed that it wanted a solution that streamlined the reporting process, was independent of any specific software product (and related licensing fees) and had a minimal impact on its small IT staff.
GeoEngineers’ solution effectively addressed the City's concerns:
The new automated system works seamlessly, reducing the time required to produce reports by at least half.