The City of Calgary Transportation Department embarked on a process of developing protocols for the implementation of a collision records system primarily for two reasons. First, there was a business need to replace the current system due to the pending decommissioning of the mainframe application, and secondly the opportunity to expand technically, beyond a record repository and develop a consistent, comprehensive, technically robust application that would allow for proactive management and analysis. In this way the city of Calgary could continue to implement procedures needed to improve safety and to ensure viability and integration between the land use planning, transportation, and operations processes.