DEVELOPMENT OF AN ACCIDENT DATABASE SYSTEM FOR HIGHWAY SAFETY

Abstract

The number of vehicles has been increasing day by day which has led to a drastic increase in the number of accidents. The development and the maintenance of the highways and roads hasn’t kept up the pace with it and is far below par. There is a huge number of accidents that are occurring on the exact same place and that could have been avoided with proper safety measures. Outdated (conventional) methods are still being used. In this project, an Accident Database System “ACCIDAT” is developed to overcome most of the challenges related to Highway safety. No such system exists in the country at the moment. The aim is to automate (digitalize) the accident reporting process to make the system robust and efficient, Employ the statistics (DATA) acquired from the Accident Database for making regulations to ensure efficient safety management. Firstly, the RTA (Road Traffic Accident) data for Rawalpindi Region was acquired from Rescue 1122, as they are the first respondents at an accident site. That data was analyzed for extracting useful variables and information that can help us take necessary highway safety measures. Then, the database system was developed. The Accident database system (named ACCIDAT) consists of two applications (android and desktop) and a database server. The android (mobile) app will be used by the Rescue 1122 workers or any respondents at an accident site. It fetches all the important information like pinpoint location, exact time and date, weather conditions etc. automatically with a single click. The other info e.g. patient credentials etc. can be added later. This data is then uploaded to the database with a single click. Whole process merely takes half a minute. The desktop app has two portals. One for the hospitals to add medical related data e.g. iv Injury severity, type etc. and the other for the Data Analysis. The analysis portal is well-equipped with almost every feature that helps a transportation engineer extract valuable information. It can be used to find out the most accident-prone areas, possible reasons of accidents there etc. within minutes. The transportation engineer can then visit that site manually and suggest safety measures. The RTA data previously obtained was entered in the database to check the validity and the usability of the accident database system. The copyrights for the Accident Database system have been attained and if need be, it will be given to higher authorities for implementation and use nationwide. To conclude, this Accident database system, if implemented, will replace the old (conventional) methods of data acquisition and will allow the transportation engineers and authorities to take necessary Highway safety measures instantly, which will ultimately result in a significant decrease in fatalities due to road accidents.