by Monte McDonald, Senior Information Systems Engineer
Our world is filled with data of all kinds. There are an unlimited number of events that can be measured and recorded and when analyzed, provide us a wealth of information about our environment. Riverside’s core business is helping people make decisions using all this data and information. The key to making these decisions is being able to capture, store, and analyze these streams of data over time. Enter time series software.
Riverside has years of experience working with software packages that provide tools to store and analyze time series data. One of our favorites is AQUARIUS Time Series by Aquatic Informatics (AI). Riverside began working with AQUARIUS about four years ago for one of our large clients, The City of New York. AQUARIUS provided the platform for the data analysis, but we wanted to push it further, including real-time data collection, automated gap filling, and quality control routines. Not only did we become experts with the software, but also since we’re engineers, we had to dig a little deeper.
We became very good at understanding the underlying data architecture and began using the application program interface (API) to push AQUARIUS to do things not feasible using the already robust graphical interface. AI recognized our capabilities and began to introduce us to clients using AQUARIUS who had unique problems to solve and would require deeper integration with their business processes than could be achieved with an off-the-shelf solution. One of those clients is the Massachusetts Water Resource Authority (MWRA).
For MWRA, we used AQUARIUS as a foundation to build a robust Water Quality Reporting System that automates data acquisition, flagging, and EPA and DEP reporting, freeing up their staff to focus on other aspects of their jobs instead of running reports. Leveraging that experience allowed Riverside to become the first certified AQUARIUS integrator.
We are currently helping the British Columbia Ministry of Environment get their snow and groundwater data moved into AQUARIUS and integrating the tool into their core business processes. AQUARIUS is an extremely valuable tool and, combined with Riverside’s vast experience with systems integration and our deep understanding of environmental science, we can create great solutions for our customers.