Using FME to Manipulate Various Sources of Data for Traffic Collision Spatio-temporal Correlation Analysis

It is of interest to explore the spatial correlation between traffic collisions and other types of available data, for example demographic and economic information, land-use, license premises and weather. To effectively prepare the data for further analysis, the City of Edmonton Office of Traffic Safety used a series of extract-transform and load (ETL) tools provided by FME. This presentation will introduce three key ETL processes performed with FME: 1) manipulate roadway GIS data for network-based spatial analysis; 2) build spatial connection between various sources of data; 3) effectively prepare the proper format of spatial data to establish advanced spatial statistics.