430 likes | 647 Views
United Arab Emirates University College of Engineering Graduation project (2). In Depth Investigation of Road Crashes in Al Ain. Instructor: Dr. A.Mehmood Aisha Ali Obaid 200309637 Eiman Abdulla Ali 200210179
E N D
United Arab Emirates University College of Engineering Graduation project (2) In Depth Investigation of Road Crashes in Al Ain Instructor: Dr. A.Mehmood Aisha Ali Obaid 200309637 Eiman Abdulla Ali 200210179 MahraDarwish Abdulla 200309604 Mouza Abdulla Al Hebsi 200310921
Outline • Introduction • Objective and Scope • Methodology • Conclusion
Introduction • This project focuses on the road safety problem in Al Ain. The city of Al-Ain is the fourth largest city in the UAE. The population of Al Ain has increased about 23 percent from 2005 to 2007(from 421948 to 520000). Location map of Al Ain
Due to enormous increase in the population, the traffic volume increased substantially. • Total number of crashes increased about 15 percent from 2005 to 2007 (from 830 to 961) • Total number of fatal crashes increased about 63 percent from 2005 to 2007 (From 203 to 331).
Objective and Scope • The objective of this project is to investigate the road crash data of Al Ain to identify the causes of crashes. • Following tasks are carried out to achieve this objective: • Collecting the time- series road crash data of Al Ain • Preparing the data for analysis including translation from Arabic to English language • Analyzing road crash data using Microsoft Excel and TransCAD
Methodology • In Graduation Project 1 (GP1) most of time spent in collecting data, translating data, preparing data for analysis and literature review regarding different statistical methods for analyzing road crash data. • In Graduation Project 2 (GP2) statistical techniques were applied to identify the significance of factors contributing to road crashes.
Data Collection The collected data cover a wide range of factors, these factors are : • Degree of injury • Causes of road crashes • Road name • Age of driver • Police station where road crash occurred • Type of road crashes • City districts where road crash occurred
The map of Al Ain that has name of zones, roads, intersections and other information was obtained from Al Ain Municipality which shown on figure.
Data Manipulation • The data provided by the MoI was in Arabic language in MS Excel format that included whole Emirate of Abu Dhabi. The data related to Al Ain for three years was separated and then translated into English.
The screen shot of actual data of one year (2007) The translated data for Al Ain (2007)
Preliminary Data Analysis • Some indicators such as total number of road crashes and fatal crash rate per 100,000 populations were plotted over the years 2005 to 2007.
Total number of crashes in Al Ain (2005- 2007)
Fatal crash rate per 100000 populations in Al Ain (2005- 2007)
Percentage of crashes due to sudden deviation from (2005 – 2007)
Percentage of crashes due to lack of knowledge in driving from (2005 – 2007)
Number of road crashes by age groups in Al Ain (2005 – 2007)
Spatial analysis of road crashes Data corresponding to each zone of Al Ain Geographic features of Al Ain zones
There are 58 zones. Only the first 30 zones (from Al Masoudi to Central District) were chosen. The other zones from 31 to 58 in table (2) are not considered because road crash data for these zones was not consistent with the GIS map.
Displaying location of crashes • The coordinates defining location of road crashes were not available in the data. The information available related to location of road crashes were the name of road and the district name or closest intersection where crash were occurred.
The steps followed to estimate the location of crashes are: • Step 1. • A layer of points was created in Trans CAD where each point represented a zone of Al Ain • In this point layer Trans CAD automatically generated coordinates (longitude and latitude) for each point • The points layer was saved in .dbf format to open it in MS Excel.
Thirty points and their coordinates in each zone during 2005
Step 2. • In MS Excel the data related to crashes was organized based on zone IDs similar to the IDs in the point layer • The road crash data was copied to point layer based on matching the IDs of zones • The point layer file was opened in TransCAD • The coordinates were copied depend on the number of street surrounding each zone and then two new columns added, one for number of crashes and the other one for name of street
ID, coordinate, name of street and number of crashes during 2005 Location of crashes by road during 2005
*each point moved manually close/on the road. Location of crashes by road during 2005
Another method • Another layer created to show each road crash as one specific point. This layer made to show all information from the MoI data about each road crash in TransCAD. Each point represents one specific crash.
table shows all information for each point such as ID, coordinate, name of street, age, cause of crash, degree of injury, etc. Each point represents one specific crash Road crashes and information for each crash during 2007
For simplicity, thirty zones were divided in to 7 groups depending on the number of crashes. Seven groups, each one contain 3 to 5 zones
Number of road crashes by age groups in Al Ain (2005 – 2007)
Number of road crashes by degree of injury in Al Ain (2005 – 2007)
Number of road crashes by causes of crashes in Al Ain (2005 – 2007)
Relation between traffic safety and economic growth in the UAE • The relationship between traffic safety and economic growth derives from a number of different components. Economic growth trigger the expansion on infrastructure and the possibility of traffic crash. Also, economic growth is a condition in order to prevent traffic crashes. On the other hand, a well-developed infrastructure with a low rate of crashes is beneficial for the economic growth
Conclusion • Final Results of the project • Critical Groups ( groups with higher crashes) • Critical Roads ( roads with higher crashes ) • Critical Factors affecting on Road Crashes • Causes • Age Group
1) Critical Groups ( groups with higher crashes) Group 2 which includes ( Al Qattara, Al Jimi, Al Towayya, Al Khabisi, and Al Masoudi). • Center of Al Ain. • More activity places (Al Qattara club, Malls, Universities, Hospitals, Court, etc). • High population (High Traffic Volume).