The City of Auburn needed to convert raw crimes data from their proprietary Linux system for use in their ArcGIS SDE environment for online mapping applications.
Their crimes data does not have a coordinate system or any other spatial data aside from addresses. Using FME Desktop, they created a workflow that adds the spatial component to the data, transforms the data for public viewing, performs quality assurance and control checks, renames attributes, and translates the output for the destination system. They then implemented FME Server to automate the process to run nightly, and provide email notifications regarding the workflow’s success.
Implementing FME was a major improvement over their Python scripts. They can easily updates codes and field changes, others can edit the workflows even with minimal knowledge of FME, FME Server logs and alerts task success and failure, and the friendly user interface makes setup easy.
The City of Auburn is located in the state of Washington, USA.