Using Leaflet, D3.js, SQLite, and Flask
Group project analyzing the Washington, DC private security camera rebate/voucher programs. Are the cameras being placed in the neighborhoods that have the highest crime rates? Do the cameras have any effect on the overall crime rates?
This project uses over 70,000 data records which were collected via geoJSON/API query and by CSV download. The data was cleaned and normalized using Python and Pandas and stored in a SQLite database. The data was analyzed looking for relationships and trends.
Visualizations include:
Searchable, sortable data table of per-district camera spend and counts
Visit the full live site, hosted on Heroku https://dccrimecams.herokuapp.com/welcome.