Ajax Analytics Provides Visibility Into Air Quality With IoT
“If we’re going to make critical decisions for our world, we should be doing it based on facts and data.” - Brent Buck, CEO at Ajax Analytics
Ajax Analytics works with environmental sensors that monitor industrial emissions. Their goal is to develop a true picture of air quality around industrial and urban activities.
A spin-off from a Colorado State University research program, Ajax secured their first large customer late in 2018. The City and County of Broomfield wanted visibility into air quality and emissions data in the face of urban oil and gas extraction operations. Ajax agreed to take the project on.
In only 2-3 months, Ajax would need to pull together a research-friendly frontend interface for all the device-collected data in their network. To make things harder, the environmental sensors weren’t uniform—they would be dealing with several different devices and data structures.
“We didn’t want to slap something together that wasn’t scalable; we wanted to invest in a great foundation for a future platform. So we started looking for partners who could build high quality, quickly, using the best-available modern technologies.” - Brent Buck, CEO at Ajax Analytics
Their search brought them to Trek10.
Ajax needed to build a platform that could pull in data from IoT environmental sensors, put it into a canonical format (accounting for a variety of sources and formats), and store it in a series of data lakes.
They knew they were on a short timeline, and they needed a development partner who could work autonomously to get the job done.
“With B- or C-player companies, I’d have to give high-fidelity mockups of the architecture before they’d build it. But Trek10 really stepped up to the plate. They designed it and got it done.” - Brent Buck
Trek10 spent two days onsite with the Ajax team, talking through business needs and the pros and cons of different architecture choices.
They needed to figure out how much data was coming in from each device, how the device would be secured, and how best to establish a connection with the device and AWS.
By the end of the design discussions, they had decided on the following architecture:
They would use AWS IoT Core to connect devices to and send data into AWS. For devices that couldn’t connect directly to the cloud, they would dump their data into a file and send it to AWS via a file upload on S3. The data processing—mapping dev IDs to customers, standardizing units—would be done with Kinesis Firehose and an AWS Lambda function. All the data would be stored in PostgreSQL and accessed via an AppSync API.
For the frontend, S3 would use the AppSync API to get data from PostgreSQL and render it.
“Trek10 cares about what we’re trying to accomplish on a business level. We don’t just talk bits and bytes, we talk about the goals of our business and product to inform every technical decision we make.” - Brent Buck
Bringing in the Data
Trek10 had eight weeks to build out datapoint connectors, auto-scaling endpoints, a data warehouse that Ajax could feed with multiple data sources, and wrap it all up in a clean, modern front end.
That was for the bare minimum code base. Trek10 also worked to implement monitoring, alerts, and a solid foundation Ajax would need to keep building on the system in the future.
“Trek10 did a fantastic job building out the core foundation of our products. I can’t believe how much forethought and effort they put into this.” - Brent Buck
The application went into production on schedule and provided a clean, easy-to-use interface for researchers and citizens. Trek10 is still actively working with the Ajax team, planning out new features. For instance, Ajax wants the app to be able to surface insights from the data using AI and machine learning.
First of Its Kind
Brent Buck, President and CEO of Ajax Analytics, says that nothing has been done like this for environmental data before, anywhere in the world.
“There’s a boatload of data out there, but it’s never pulled into a format your average citizen can understand. What Trek10 has given us the ability to do is pull data from all these different sources and get it into a system where we can start making sense of data to find the operational changes that provide real ROI toward a cleaner and healthier environment.” - Brent Buck
While the solution was first developed for the City and County of Broomfield, the data is now used by the Colorado Department of Public Health and Environment and a number of companies in the industry who want visibility into how they’re doing.
“If we’re going to make critical decisions for our world, we should be doing it based on facts and data.” - Brent Buck