City of Coquitlam

The City of Coquitlam uses smart city initiatives to enhance business operations and customer service.

The City of Coquitlam is one of the fastest-growing municipalities in the province of British Columbia, Canada. With over 150,000 residents, the city is dedicated to providing exceptional services for its citizens through smart city initiatives and technology-driven strategies.

With their recycling and garbage collection, the city saw an opportunity to speed up service requests. The program used a third party to distribute carts, and for billing, it used various applications, including IBM Maximo and Tempest.

The city wanted to find a way to automate processing requests and creating work orders, but they also needed a solution that could automatically update residents' utility bills.

How they made it possible – no code required.

Having already implemented FME to solve diverse data integration challenges across multiple departments, the City of Coquitlam knew it could build on its success.

They created an FME workflow that parses Maximo for active service requests (such as the exchange of garbage or organics carts), and creates a work order spreadsheet that is sent to the vendor. Once updated work orders are returned from the vendor and entered into Maximo, FME automatically modifies the resident's utility bill in Tempest to reflect changes in cost.

By fully automating integration processes and removing data silos, the City of Coquitlam sees significant improvement in data integrity and accessibility between its internal teams and external vendors. Their team is equipped with actionable insight that enables service requests to be addressed quickly while minimizing potential manual errors in billing. With FME, the time taken by staff to complete cart transactions has been greatly reduced.

Coquitlam is the 6th largest city in British Columbia, with over 150,000 residents and more than 80 municipal parks.

“Whenever I need to integrate or create different types of documents and gather information from various databases and make updates, I rely on FME as it makes the integration of multiple formats quite easy.” – Andrew Philipp, City of Coquitlam