Abstract
Many great visualization techniques, such as kernel density mapping, can help us map and analyze crime concentrations. However, sometimes, it may be more beneficial to visualize crime concentrations along a linear network, such as a bus route or subway/underground line. Law enforcement agencies could use this to target resources at particular hot spots. To map these hot spots, we can use hot routes. Hot routes enable crimes to be mapped along sections of a linear network using thematic mapping (colour and line width).
An excellent tutorial illustrates hot routes, using R, for the Bakerloo Line on the London Underground. Using Python, we'll use the example described in that tutorial and apply it to SingleStore DB. In a previous article, we have already seen one approach to model and store the London Underground network in SingleStore DB.