Case Study: Commonwealth of Massachusetts achieves lightning-fast address matching with Last Call Media

Commonwealth of Massachusetts delivers address matching in under 10 minutes with Last Call Media

The Commonwealth of Massachusetts needed to reconcile millions of inconsistently formatted addresses from various sources into a single canonical format. Their internal database was difficult to query and using an external service was too costly. Last Call Media was engaged to address this challenge with a custom API solution.

Last Call Media built a highly scalable ETL tool that normalizes and imports data into an AWS RDS database in under 10 minutes, a process that previously took hours. They then created a serverless API endpoint that leverages libpostal to parse address inputs and query the database for matches. This solution delivers precise address matching for the Commonwealth, with most API responses returning in under 500 milliseconds, at a very small cost.

Commonwealth of Massachusetts