Dissertation project where cycling crashes in Edinburgh are analysed in a cycling route. This is a reproducible method intended to be applicable in other scenarios. This code represent the data access and cleaning stages from the methodology. Data agreggation and map making are done in QGIS, using the .gpkg outcome from this code. final_dissertation.Rmd is a script for accessing and cleaning collision and casualty data from the city of Edinburgh final_dissertation_test.Rmd is a script for accessing and cleaning collision and casualty data from the city of London