Automating Crime Data to Import into GIS
Using FME, we have been able to take raw data from our records management system for Police (which is in a propriety Linux system) and be able to transform it into our ArcGIS SDE environment for online mapping applications. The crimes data does not have a coordinate system or any other spatial data associated with it except addresses- FME helps us add the spatial component to be able to use it for our web map services. With additional help from FME Server, we automated this process to run nightly and to be able to give us email notifications when the workbench succeeds or fails.
City of Auburn
FME World Tour 2016