New FME Tools for Cityworks Integrations
Summary
Working closely with a number of North American municipalities (both new and existing FME users), we have been exploring this domain in earnest, researching and prototyping application integrations for common data systems. With one foot still in the GIS realm, the template workflow also pulls street centrelines from an ArcGIS Server Feature Service, which are spatially joined to the incoming Cityworks data and attached as an entity to the work order being processed through the REST API. Of course, FME could connect to any number of databases or formats, spatial or non-spatial, so the beauty of this integration is that it has the potential to mix numerous applications or data silos, whether they are for asset management, permitting, GIS, finance, engineering, or something else! For example, you might want to reduce manual data entry by making a series of Cityworks API calls (creating parent and child work orders, adding tasks, etc. Since many of their planned integrations rely on cloud-based systems and web APIs rather than on-premises data warehouses, and because the overhead to get started is so low, turned out to be the perfect solution for the city.