I live on the Westside in Saint Paul. I can never find good crime maps of Saint Paul, and the public data access spreadsheets from the city are really buggy and hard to work with. I figured if I was having trouble navigating these resources, others would be too. Building this app, it was still very difficult to work with the data that the city provides, and I had to do a lot of cleanup to get the data usable for mapping on this app. I have spent many hours correcting incorrect data. I also utilized google Geo-location API to store coordinates for plotting on leaflet map component. The front end is build using React with Next.js with server less functions calling a MongoDB cluster containing the massaged crime data. A separate app exists to get, massage, and load up the MongoDB cluster. The crime map is also mobile friendly!
Crime map with drop down to sort by years and months for most recent years for more granularity.
Filtering by neighborhood, crime type, and date
Spiderweb feature that organizes crimes that happen at the same coordinates.
Details for each crime on click or tap
Heat map feature that changes colors of more dense clusters of data points.
Producation app with real users over the last 3 months
