CrimeDaddy

Website with Heatmap

Inspiration

The increasing levels of crime in San Francisco make it more dangerous than ever to go out. We wanted to create something that could help people stay safe whenever and wherever, while also understanding the exact nature of crime in their city.

What it does

Our web app displays data straight from San Francisco's police department to highlight where crime occurs most commonly in the city. Additionally, users can submit their emails and get notified about crime in the area in real time.

How we built it

Using a PostgreSQL database to store the information, we used a basic webstack to display the the location of crime occurrences in a heatmap, with the option of filtering by year and crime severity. We used a Python script to detect when new data comes in and notify subscribers via email. Crime severity is determined by OpenAI using the fields given by police reports.

Challenges we ran into

At first, we wanted to text message users, as that is a very convenient form of communication. However, after realizing that we would have to pay for the service, or wait 6 weeks to get verified, we transitioned to using emails. Additionally, we struggled to integrate Neurelo as we couldn't find a use for it beyond the typical database uses.

Accomplishments that we're proud of

We successfully implemented a nice-looking heat map for users to look at, and are very pleased with how it looks. Also, we're proud of the responsiveness of our email notifications.

What we learned

We learned a lot about database creation and manipulation, and also used coding languages we never learned more. Overall, our full-stack experience leveled up a lot more.