United States Traffic Accident Analysis.

Database Administrator & Backend Developer | Web Application | PHP & SQL
3 developers | 5 months | May 2020

Description.

"USTAA" is a data analysis website for traffic accidents in the United States, utilizing an Oracle Database 12c. The site is written in PHP with embedded SQL, enabling fast querying of over 5 million rows of data.
My contributions included developing and managing the accident database, writing SQL queries, and integrating those queries into the PHP codebase.

A landing page for USTAA detailing a number of accident trends numerically and visually

More Images.

A screenshot of the USTAA landing page showing the Top 5 County Accident Rates in the United States

A screenshot of the USTAA Custom Report's Trending Traffic Events By Location, specifically showing a graph of traffic events in Miami, Florida, in 2017 and 2018

A screenshot of the USTAA Custom Report's Comparisons of Traffic Events between Cities, comparing traffic events in Los Angeles and Atlanta by Accidents per Land Area in 2019

A screenshot of the USTAA's FAQ page showing the number of tuples in each database table, totaling to 5,481,902 records

A screenshot of the USTAA landing page as a logged in user, showing the Top 5 County Accident Rates in Georgia

A screenshot of USTAA's Accident Analysis page for the user's home state of Georgia, including showing the comparison of accidents in the daytime versus the nighttime, where the nighttime accidents are consistently much higher

A screenshot of USTAA's Accident Analysis page showing the number of accidents in Georgia that have occurred on Interstates versus other roads, where other roads has a much higher percentage

A screenshot of USTAA's Custom Reports page showing the comparison of Traffic Events in Los Angeles versus Atlanta by quantity in 2019

A screenshot of USTAA's Custom Reports page comparing weather-related traffic events between Miami and Charlotte in 2018