To learn more about web development and working with data from MySQL databases and pulling said data onto a webpage.
What it does
It doesn't do much, but that doesn't matter to me (I'm just glad I learned a lot). In its current state, it shows a few criminal statistics, such as the Top 10 Crimes, the Top 10 Victims, the Top 10 Criminals, and all crime in the dataset by date.
How I built it
I used Sinatra with bootstrap to quickly get a website up, imported the .CSV files into MySQL with a LOAD DATA INFILE function, and used Highcharts to present specific data with SQL queries stored in Views.
Challenges I ran into
Accomplishments that I'm proud of
What I learned
Above. I knew nothing about web design/creation or database management, and have learned some of each.
What's next for Clarity Criminal Activity and Intel
I might look into criminal activity prediction, and try to match up my algorithm to the data provided by Clarity here at the end. I'll also look into creating a more robust website that can enable users to determine even more info regarding criminal activity.