The goal of this project was to provide a way to visualize traffic accidents within the Washington and Clackamas counties in Oregon. This map has a heatmap overlay of every traffic accident, injury or non-injury incident, between the years 2014 and 2016. This allows the user to view hotspots in both counties which can help identify problematic intersections or determine if fire stations are located appropriately around the county with relation to traffic accident incidents. This data was provided by the Washington County Consolidated Communications Agency (WCCCA).
This was created during Fall 2021 as the semester project for Dr. Jia Zou's Database Management (CSE412) course at Arizona State University.
PostgreSQL >= 12.9
PHP >= 8.0
- Dynamically generated heatmap
- Heatmap filtering by area, date, or both
- Data table of mapped incidents with units assigned
- Adjustable heatmap extrema and radius
- Create a Postgres database
- Import the provided database in Database/psql_database.backup
This can be done with this by running pg_restore in the root direcotry of the project ex.
pg_restore --dbname=dbname --verbose backup/psql_database.backup - Copy config.php.example to config.php, open it, and edit the database connection configuration.
