Welcome to NormanPD Incident Data Visualizer
The Norman, Oklahoma police department regularly reports incidents, arrests, and other activities. This data is available as daily incident summary reports on their website. This web application allows you to upload these reports in CSV or PDF format or provide URLs to these files.
We process and visualize this data to help identify trends, such as peak times for incidents and high-incident areas. These insights can aid in crime prevention, resource allocation, and public safety improvements. You can also download the augmented data to perform your own analysis or integrate it with other tools.
Project Workflow
Upload Data
Upload incident reports in CSV, PDF, or URLs.
Supported formats: CSV, PDF, URLs. Ensure files are from the Norman, Oklahoma police department daily incident summary from their website.
Files should include fields: Date/Time, Incident Number, Location, Nature, Incident ORI.
Process and Augment
Processes files/URLs to fetch and augment incident reports.
Tools used: SQL for storage, Google Maps API for geocoding, Open-Meteo for weather.
Augmented fields: Day of the Week, Time of Day, Weather, Location Rank, Side of Town, Incident Rank, EMSSTAT status.
Visualizer
Visualize data with various charts and plots.
Used Plotly and WMO code images to create interactive visualizations
Visualizations include: 'day of week plot', 'time-of-day plot', 'weather plot', 'top incidents plot', 'top locations plot', 'side of town plot', and 'EMSSTAT' plot.
Download Data
Download the augmented data in CSV format.
Includes fields: 'Day of the Week', 'Time of Day', 'Weather', 'Location', 'Location Rank', 'Side of Town', 'Incident Rank', 'Nature', 'EMSSTAT'.