To build an interactive crime dashboard, you will need to collect data to build a database. Then, you will query the data and add widgets to allow users to modify the queries without needing to code. Lastly, you will graph and map the query results.
To build the components for a crime dashboard, we will use the City of Albuquerque's open data. Albuquerque has datasets for crime incidents, as well as area commands and beats. By combining the areas with incidents, you will be able to report on two geographic areas. You could then extend the analysis using neighborhood associations or any other boundary—Census blocks, groups, or tracts, and get demographic information as well.
Note
You can find links to the data on the main open data site located at: http://www.cabq.gov/abq-data/. Scroll to the bottom of the page and look for the Safety Data Sets heading.
