Home

APRAD User Manual ,Vers. 1.1, May 2002

1. 213 214 215 216 217 The killed male drivers of light goods vehicles aged 25 64 years data field is greater than the killed drivers of light goods vehicles aged 25 64 years data field The killed male drivers of light goods vehicles aged 65 years amp more data field is greater than the killed drivers of light goods vehicles aged 65 years amp more data field The killed male drivers of light goods vehicles of unknown age data field is greater than the killed drivers of light goods vehicles of unknown age data field The killed male drivers of heavy goods vehicles aged 0 5 years data field is greater than the killed drivers of heavy goods vehicles aged 0 5 years data field The killed male drivers of heavy goods vehicles aged 6 9 years data field is greater than the killed drivers of heavy goods vehicles aged 6 9 years data field The killed male drivers of heavy goods vehicles aged 10 14 years data field is greater than the killed drivers of heavy goods vehicles aged 10 14 years data field The killed male drivers of heavy goods vehicles aged 15 17 years data field is greater than the killed drivers of heavy goods vehicles aged 15 17 years data field The killed male drivers of heavy goods vehicles aged 18 20 years data field is greater than the killed drivers of heavy goods vehicles aged 18 20 years data field The killed male drivers of heavy goods vehicles ag
2. Browse for Setup exe of the Analysis Version on CDROM 3 Please click on the Open button the selected path and program should appear in the Run dialogue as in the figure below The letter for the drive may be different depending on the name of your CD ROM drive Run HE Type the name of a program folder document or Internet resource and Windows will open it for pou Open XA Setup exe Cancel Browse Fig 4 Run Dialogue with the specified Setup exe program 4 Please click on the OK button the Analysis Version setup program will start see Fig 1 APRAD Analysis Version Setup Then please follow the instruction on the screen You will be prompted to select the destination path and the name of the program group for the Analysis Version 1 2 Usage After the installation is completed please select the icon APRAD Data Analysis Version which should appear in the APRAD program group on you Programs Task Bar The APRAD Data Analysis program will start with the Opening Page 1 2 1 Opening Page The Opening Page is the welcome page that will be displayed every time you start the APRAD program If the Open button is pressed the Start Menu will appear next And if the Close button is pressed the program will be terminated APRAD Analysis Version Escap Road Safety Database Transport Communications Tourism and Infrastructure DevelopmentPivisron Economic and Social Commission for Asia and th
3. E Tio 10 First Page Previous Page Next Page Last Page Zoom Print Export Mail Fig 41 Data Input Print Preview 40 2 2 6 Data Consistency Check After the data key in stage has been completed the data can be checked for entry errors by using the Data Consistency Check function Each year in the year range provided can be selected for checking If there are any data inconsistencies according to the predefined consistency rules see Annex Ill error messages will be displayed see Fig 42 below APRAD Input Version Data Consistency Check GE Please click Check button Country China E Year 1991 Database consistency information of country China year 1991 generated at 4 01 2002 5 43 17 PM Note Data inconsistencies are reported only for those consistency rules where all data fields have a value If any data field of a specific consistency rule is blank either by omission or due to non availability the respective error message if for data inconsistency will not be displayed Please see the following error messages for data inconsistency NONE 4 Print Gancel Fig 41 Example for the Data Consistency Check Page 2 2 7 Data Export After the data key in stage has been completed the updated national data file needs to be send back to ESCAP for incorporation into the regional database The Data Export function creates a Microsoft Access 97 database file with the fil
4. 10 14 KIHV1517D 15 17 KIHV1820D 18 20 KIHV2124D 21 24 KIHV2564D 25 64 KIHV6599D UNKWN KILLED DRIVERS KIBUOO05D 10 14 15170 15 17 KIBU1820D 18 20 KIBU2124D 21 24 KIBU2564D 25 64 KIBUG6599D UNKWN BUSES AGED AGE KIPC6599D KILV2124D 21 24 KILV2564D 25 64 gt O m KILLED DRIVERS KIHV0005D er KIOMV1014D 10 14 KIOMV1517D 15 17 KIOMV1820D 18 20 KIOMV2124D 21 24 KIOMV2564D 25 64 UNKWN AGE KILLED DRIVERS KIUVOO05D 0 5 KIUVOGO9D KIUV1014D 10 14 KIUV1517D 15 17 KIUV2124D 21 24 KIUV2564D 25 64 KIUV6599D 65 KIUVUAD UNKWN UNKNOWN VEH AGE TYPE AGED KIUV1820D 18 20 54 Field label Field Field label Field Field label Field Field label Field Field label Field Field label Field Field label Field Field label Field Field label name name name name name name name name 2nd 2nd 2nd 2nd 2nd 2nd 2nd 2nd part part part part part part part part Driver and Pedestrian Fatalities by Age Group and Sex KIPE1014M 10 14 KIPE1517M 15 17 KIPE1820M 18 20 KIPE2124M 21 24 KIPE2564M 25 64 KIPEG599M KIBC1014DM 10 14 KIBC1517DM 15 17 KIBC1820DM 118 20 KIBC2124DM 21 24 KIBC2564DM 25 64 KIBC6599DM KI2W1014DM 10 14 KI2W1517DM 15 17 KI2W1820DM 18 20 KI2W2124DM 21 24 KI2W2564DM 25 64 KI2W6599DM KIPEUAM KILLED MALE KIPEO005M 0 5 KIPEO609M PEDESTR AGED KILLED MALE KIBCO005DM KIBCOG09DM DRIVERS BICYCLES KILLED
5. 2 2 5 Data Key In itr Een 37 2 2 6 Data Consistency 41 2 2 7 Data Exp n n c HE thee eM in 41 ANNEXES d ERBEN etos emo bie 43 Annex 1 APRAD Data 45 Annex Il Standard Data Definitions sees 57 Annex III Consistency Checkered iaieiiea mene 65 Annex IV Legal Notice x 3 2 vio cir aii PIE E I I rine een RR 91 Introduction The APRAD Asia Pacific Road Accident Database software is a relational database software based on Microsoft Access Its acts as a tool for ESCAP and its member countries to develop update maintain and manage the road accident database for Asia Pacific in a joint and cooperative manner The APRAD package contains three different versions with different access levels and security options Data Analysis Version The Analysis Version will be distributed together with a regional database file to all ESCAP member countries and is for all recognized users Its main feature is to produce various data outputs from the latest updated database such as reports tables and graphs This is to assist member countries to monitor and analyze the national road safety situation and to assess it in comparison with other countries All output results can be exported saved into various file formats for use with other software Data Input Version The Input Version will also be
6. Field label 1st part name name name name name name name 2nd 2nd 2nd 2nd 2nd 2nd 2nd part part part part part part part KILLED KIPEO005 0 5 KIPE1014 10 14 KIPE1517 15 17 1820 18 20 2124 21 24 KIPE2564 KIPE6599 65 KIPEUA UNKWN PEDESTRIANS AGE KIBCO005 0 5 KIBCO609 KIBC1014 10 14 KIBC1517 15 17 1820 18 20 KIBC2124 21 24 KIBC2564 KIBC6599 65 KIBCUA UNKWN BICYCLISTS AGE E ud KILLED OCC S 2 KI2W0005 0 5 KI2W1014 10 14 KI2W1517 15 17 KI2W1820 21 24 KI2W6599 65 KI2ZWUA UNKWN KILLED OCC S 3 KI3WO005 0 5 KI3W0609 KI3W1014 10 14 KI3W1517 15 17 KI3W1820 18 20 KI3W2124 21 24 KI3W2564 KI3W6599 65 KIBGWUA JUNKWN WHEELER AGED AGE 2564 25 64 KIPC6599 65 KIPCUA UNKWN AGE KILV2564 25 64 KILV6599 65 KILVUA UNKWN AGE KILLED OCC S KIHVO0005 0 5 KIHVO609 KIHV1014 10 14 KIHV1517 15 17 KIHV1820 18 20 KIHV2124 21 24 KIHV2564 25 64 KIHV6599 65 KIHVUA UNKWN HGV S AGED AGE KILLED OCC S KIBUOO005 0 5 KIBUO609 KIBU1014 10 14 KIBU1517 15 17 1820 18 20 KIBU2124 21 24 KIBU2564 25 64 KIBU6599 65 KIBUUA UNKWN BUSES AGED AGE KILLED OCC S KIOMVOOO5 0 5 KIOMV1014 10 14 KIOMV 1517 15 17 KIOMV1820 18 20 KIOMV2124 21 24 KIOMV2564 25 64 KIOMV6599 65 KIOMVUA JUNKWN OTHER MOTOR AGE VEH S AGED KILLED OCC S KIUVOOO5 0 5 KIUVO609 KIUV
7. The killed drivers of buses aged 25 64 years data field is greater than the killed occupants of buses aged 25 64 years data field The killed drivers of buses aged 65 years amp more data field is greater than the killed occupants of buses aged 65 years amp more data field The killed drivers of buses of unknown age data field is greater than the killed occupants of buses of unknown age data field The killed drivers of other motor vehicles aged 0 5 years data field is greater than the killed occupants of other motor vehicles aged 0 5 years data field The killed drivers of other motor vehicles aged 6 9 years data field is greater than the killed occupants of other motor vehicles aged 6 9 years data field The killed drivers of other motor vehicles aged 10 14 years data field is greater than the killed occupants of other motor vehicles aged 10 14 years data field The killed drivers of other motor vehicles aged 15 17 years data field is greater than the killed occupants of other motor vehicles aged 15 17 years data field 80 142 143 144 145 146 147 148 149 150 151 152 The killed drivers of other motor vehicles aged 18 20 years data field is greater than the killed occupants of other motor vehicles aged 18 20 years data field The killed drivers of other motor vehicles aged 21 24 years data field is greater than the killed occupants of
8. Trends Trends Casualty Accidents Eatalities by Context Eatalities by Road User Type by Age Group Fig 11 Trends Menu Page Risk Values Page There are three buttons in the Hisk Values Menu They are Accidents and Casualties Fatalities by Age Group Context per Population and Fatalities by Context per Vehicle Fleet Kilometrage buttons Each button will lead to a query page that will ask the user for necessary information in order to generate a report and or graph output For all buttons the select 1 year and any countries query 15 page will be displayed For details please see Section 1 2 3 Query and Output Pages below APRAD Analysis Version Risk Values iof XI Fig 12 Risk Values Menu Page 1 2 3 Query and Output Pages In this section the query pages for each selected output will be described There are various queries that can be divided into three groups as follows a Query for Standard Output The queries in this group will be displayed when output from Standard Output group is selected see Data Analysis Menu Page There are three queries as follows Select 1 year and any countries This query will be shown when one of the outputs from the list below is selected General Data Menu gt Reference Values Accidents and Casualties Menu gt Accidents Accidents and Casualties Menu gt Casualties Risk Values Menu gt Accidents and C
9. Year following Western calendar Area Area in Square Kilometers a Population Population APRAD Data Definition Unless otherwise specified population figures are as of mid year following the standard UN practice for population data Population by age group individual year APRAD Data Definition For example Population aged 0 5 years this includes the total population figures of the age groups up to 5 years as of mid year Similarly for individual years for example Population aged 15 years this is the total population of the individual age of 15 years as of mid year b Road Network Road network APRAD Data Definition The network length of a particular road category expressed in kilometers Public roads APRAD Data Definition Public roads are those roads generally available for vehicle operation and owned by the Government 57 Motorways APRAD Data Definition Motorways Expressways roads designed and built for high speed vehicular movement with separate limited access carriageway for two directions of traffic High speed means speeds higher than those permitted on normal urban or non urban roads National Highways APRAD Data Definition National roads are roads of a lesser standard than motorways but which permit speeds higher than urban speed limits generally lower than motorways These are primarily arterial roads linking major population centers and regions in different parts of
10. registered trademarks are the property of their respective owners Redistributable Microsoft Data Access Components MDAC and Microsoft Data Engine MSDE technology as part of the Software are the Copyright of Microsoft Corporation and are provided royalty free under the conditions of and in compliance with the Microsoft End User License Agreement EULA with the APRAD software developer to United Nations ESCAP None of the APRAD Products provided may be reproduced or transmitted in whole or in part in any form or by any means electronic or mechanical including photocopying recording or the use of any information storage and retrieval system except as provided for in the Terms and Conditions of Use below without permission in writing from ESCAP To request such permission and for further enquiries contact the Transport Communications 91 Tourism and Infrastructure Development Division United Nations ESCAP UN Building Bangkok 10200 Thailand e mail tctidd unescap un org 2 TERMS AND CONDITIONS OF USE Installing copying or otherwise using the APRAD Software and Products constitutes an agreement with the following terms and conditions a The United Nations ESCAP maintains the APRAD Products as a free service to ESCAP member and associate member governments their National APRAD Coordinating Agencies and other agencies responsible for road safety as well as to additional institutions and in
11. 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown age is not equal to the killed occupants of other motor vehicles data field The sum of the fatalities data fields killed occupants of unknown vehicles aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown age is not equal to the killed occupants of unknown unspecified vehicle type data field 74 75 76 TT 78 79 80 81 82 83 84 85 86 DRIVER FATALITIES BY VEHICLE TYPE AND AGE GROUP The killed drivers of bicycles aged 0 5 years data field is greater than the killed bicyclists aged 0 5 years data field The killed drivers of bicycles aged 6 9 years data field is greater than the killed bicyclists aged 6 9 years data field The killed drivers of bicycles aged 10 14 years data field is greater than the killed bicyclists aged 10 4 years data field The killed drivers of bicycles aged 15 17 years data field is greater than the killed bicyclists aged 15 17 years data field The killed drivers of bicycles aged 18 20 years data field is greater than the killed bicyclists aged 18 20 years data field The killed drivers of bicycles aged 21 24 years data field is greater than the killed bicyclists aged 21 24 years data field The
12. 35 36 37 38 39 40 41 42 The sum of the fatalities aged 25 34 years data fields by sex killed males aged 25 34 years and killed females aged 25 34 years is not equal to the all killed aged 25 34 years data field The sum of the fatalities aged 35 44 years data fields by sex killed males aged 35 44 years and killed females aged 35 44 years is not equal to the all killed aged 35 44 years data field The sum of the fatalities aged 45 54 years data fields by sex killed males aged 45 54 years and killed females aged 45 54 years is not equal to the all killed aged 45 54 years data field The sum of the fatalities aged 55 59 years data fields by sex killed males aged 55 59 years and killed females aged 55 59 years is not equal to the all killed aged 55 59 years data field The sum of the fatalities aged 60 64 years data fields by sex killed males aged 60 64 years and killed females aged 60 64 years is not equal to the all killed aged 60 64 years data field The sum of the fatalities aged 65 years amp more data fields by sex killed males aged 65 years amp more and killed females aged 65 years amp more is not equal to the all killed aged 65 years amp more data field The sum of the fatalities unknown age data fields by sex killed males of unknown age and killed females of unknown is not equal to the all killed of unknown age data field The sum o
13. For pie graphs only the first of the selected data types will be displayed however for all selected countries 26 2 1 Installation 2 1 1 System Requirements with Microsoft Windows 95 98 or higher operating system CD ROM Drive for Installation from CD ROM Hard Disk at least 20 Mbytes free space Mouse 2 1 2 Program Setup The installation package is on one CD ROM The installation CD ROM is ready for Auto Play If your system is configured for Auto Play please continue with the Auto Play Setup Method section below If not please continue with the Manual Browse and Run Setup Method further down To configure your system for Auto Play enabled please see your Microsoft Windows user manual a Auto Play Setup Method 1 After you insert the installation CD ROM the APRAD Input Version Setup Page should appear automatically as in Figure 27 see next page 2 Follow the instruction on screen You will be prompted to select the destination path and the name of the program group for the Input Version 29 APAAD Input Version Setup E Welcome to the APRAD Input Version installation program Setup cannot install system files or update shared files if they are in use Before proceeding we recommend that you close any applications you may be running Fig 27 APRAD Input Version Setup b Manual Browse and Run Setup Method 1 After you insert the installation CD ROM
14. UNKNOWN UNSPECIFIED ROADS NUMBER OF CASUALTY ACCIDENTS AT DAYTIME 06 00 17 59HRS NUMBER OF CASUALTY ACCIDENTS AT NIGHTTIME 18 00 05 59HRS NUMBER OF CASUALTY ACCIDENTS AT UNKNOWN UNSPECIFIED TIME NUMBER OF CASUALTY ACCIDENTS ON WET ROADS NUMBER OF CASUALTY ACCIDENTS ON DRY ROADS NUMBER OF CASUALTY ACCIDENTS ON UNKNOWN UNSPECIFIED SURFACE CONDITION 48 Field Field Name al Casualties TOTAL NUMBER OF KILLED AND INJURED ROAD USERS KIPC KILLED OCCUPANTS OF PASSENGER CARS STATION WAGONS ETC UP TO 9 SEATS KILV KILLED OCCUPANTS OF LIGHT GOODS VEHICLES UP TO 3 5 TONS MAX PERMISSIBLE WEIGHT KIHV KILLED OCCUPANTS OF HEAVY GOODS VEHICLES gt 3 5 TONS MAX PERMISSIBLE WEIGHT KIBU KILLED OCCUPANTS OF BUSES 10 AND MORE SEATS KIOMV KILLED OCCUPANTS OF OTHER MOTOR VEHICLES KIUV KILLED OCCUPANTS OF UNKNOWN UNSPECIFIED VEHICLE TYPE 49 Label KILLED IN DAYTIME 06 00 17 59HRS Kur DRY KINI KILLED AT NIGHTTIME 18 00 05 59HRS KIUT KILLED AT UNKNOWN UNSPECIFIED TIME KIWET KILLED ON WET ROADS KIDRY KILLED ON DRY ROADS KIUW KILLED ON UNKNOWN UNSPECIFIED ROAD SURFACE CONDITION 50 Field name Field label 1st part Fatalities by Age Group and Sex KILLED AGED 0 5 YEARS 0005 ALL 0005M MALE 0005F 0609F 1014F 1517F 1820F Kl 2124F 2534F 3544F KI_4554F FEMALE 5559F FEMALE 6064F
15. aged 18 years 19 years and 20 years is not equal to the killed males aged 18 20 years data field The sum of the fatalities data fields killed males aged 0 5 years 6 9 years and 10 14 years is not equal to the killed males aged 0 14 years data field The sum of the fatalities data fields killed males aged 15 17 years 18 20 years and 21 24 years is not equal to the killed males aged 15 24 years data field The sum of the fatalities data fields killed males aged 25 34 years 35 44 years 45 54 years 55 59 years and 60 64 years is not equal to the killed males aged 25 64 years data field The sum of the fatalities data fields killed females aged 15 years 16 years and 17 years is not equal to the killed females aged 15 17 years data field The sum of the fatalities data fields killed females aged 18 years 19 years and 20 years is not equal to the killed females aged 18 20 years data field The sum of the fatalities data fields killed females aged 0 5 years 6 9 years and 10 14 years is not equal to the killed females aged 0 14 years data field 72 63 64 65 66 67 68 69 The sum of the fatalities data fields killed females aged 15 17 years 18 20 years and 21 24 years is not equal to the killed females aged 15 24 years data field The sum of the fatalities data fields killed females aged 25 34 years 35 44 years 45 54 years 55 59 years and
16. aged 21 24 years data field The killed drivers of heavy goods vehicles aged 25 64 years data field is greater than the killed occupants of heavy goods vehicles aged 25 64 years data field The killed drivers of heavy goods vehicles aged 65 years amp more data field is greater than the killed occupants of heavy goods vehicles aged 65 years amp more data field The killed drivers of heavy goods vehicles of unknown age data field is greater than the killed occupants of heavy goods vehicles of unknown age data field The killed drivers of buses aged 0 5 years data field is greater than the killed occupants of buses aged 0 5 years data field The killed drivers of buses aged 6 9 years data field is greater than the killed occupants of buses aged 6 9 years data field 79 131 132 133 134 135 136 137 138 139 140 141 The killed drivers of buses aged 10 14 years data field is greater than the killed occupants of buses aged 10 14 years data field The killed drivers of buses aged 15 17 years data field is greater than the killed occupants of buses aged 15 17 years data field The killed drivers of buses aged 18 20 years data field is greater than the killed occupants of buses aged 18 20 years data field The killed drivers of buses aged 21 24 years data field is greater than the killed occupants of buses aged 21 24 years data field
17. distributed to all member countries as a data input storage tool however only to the authorized national coordinating agencies national focal points Its main purpose is to assist each member country to enter requested national data according to the query input file received from ESCAP the database host manager It also provides a feature to import export query and information files between ESCAP and each member country Full Version This version consists of the main software including all data files and is installed only at ESCAP Its main purpose is to maintain the regional database by i generating the national query information request files for the Input Version distributed previously to each member country 1 i iii incorporating information received from member countries into the database and producing updated regional database files to be distributed to all member countries and utilized through the previously distributed Analysis Version 1 1 Installation 1 1 1 System Requirements with Microsoft Windows 95 98 or higher operating system CD ROM Drive for Installation from CD ROM Hard Disk at least 20 Mbytes free space Mouse 1 1 2 Program Setup The installation package is on one CD ROM The installation CD ROM is ready for Auto Play If your system is configured for Auto Play please continue with the Auto Play Setup Method section below If not please con
18. having a maximum permissible weight of up to 3 5 tons such as pick ups light vans etc Heavy Goods Vehicles more than 3 5 tons maximum permissible weight APRAD Data Definition All registered motorized commercial or goods carrying vehicles rigid or articulated having a maximum permissible weight of more than 3 5 tons such as lorries trucks etc Buses 10 or more seats APRAD Data Definition All registered motorized passenger carrying vehicles having a seating capacity of ten or more persons including driver Other Motor Vehicles APRAD Data Definition Any other registered motorized vehicles not specified above as standard vehicle type but licensed for operation on public roads 59 d Vehicle kilometrage APRAD Data Definition Total annual number of kilometers run per vehicle type or per road category Note These data are used worldwide to calculate accident risks on a vehicle kilometer usage basis If these data are not readily available from records please provide your best estimate of the total annual number of vehicle kilometers run of all vehicles or of all vehicles of a particular vehicle type or on motorways 2 CASUALTY ACCIDENTS a Casualty accidents APRAD Data Definition Casualty accidents are those resulting in injury and or death excluding property damage only accidents b Injury only accidents APRAD Data Definition Injury only accidents are those casualty accidents resulti
19. injured road users data field The total number of killed road users data field is greater than the total number of fatal accidents data field The sum of the fatalities data fields by road user type killed pedestrians killed occupants of bicycles killed occupants of motorized 2 wheelers killed occupants of motorized 3 wheelers killed occupants of passenger cars station wagons etc up to 9 seats killed occupants of light goods vehicles killed occupants of heavy goods vehicles killed occupants of buses 10 and more seats killed occupants other motor vehicles and killed occupants of unknown unspecified vehicle type is not equal to the total number of killed road users data field The sum of the fatalities data fields by location killed inside urban areas killed outside urban areas and killed in unknown unspecified location is not equal to the total number of killed road users data field The sum of the fatalities data fields by road category killed on motorways killed on national highways killed on provincial 68 26 2T 28 29 30 31 32 33 regional roads killed on other roads and killed on unknown unspecified roads is not equal to the total number of killed road users data field The sum of the fatalities data fields by time killed in daytime killed at nighttime and killed at unknown unspecified time is not equal to the total number of killed road us
20. killed drivers of 2 wheelers aged 25 64 years data field The killed male drivers of 2 wheelers aged 65 years amp more data field is greater than the killed drivers of 2 wheelers aged 65 years amp more data field The killed male drivers of 2 wheelers of unknown age data field is greater than the killed drivers of 2 wheelers of unknown age data field The killed male drivers of 3 wheelers aged 0 5 years data field is greater than the killed drivers of 3 wheelers aged 0 5 years data field The killed male drivers of 3 wheelers aged 6 9 years data field is greater than the killed drivers of 3 wheelers aged 6 9 years data field 84 185 186 187 188 189 190 191 192 193 194 195 The killed male drivers of 3 wheelers aged 10 14 years data field is greater than the drivers of 3 wheelers aged 10 14 years data field The killed male drivers of 3 wheelers aged 15 17 years data field is greater than the drivers of 3 wheelers aged 15 17 years data field The killed male drivers of 3 wheelers aged 18 20 years data field is greater than the drivers of 3 wheelers aged 18 20 years data field The killed male drivers of 3 wheelers aged 21 24 years data field is greater than the killed drivers of 3 wheelers aged 21 24 years data field The killed male drivers of 3 wheelers aged 25 64 years data field is greater than the killed drivers of 3 wheelers age
21. killed drivers of bicycles aged 25 64 years data field is greater than the killed bicyclists aged 25 64 years data field The killed drivers of bicycles aged 65 years amp more data field is greater than the killed bicyclists aged 65 years amp more data field The killed drivers of bicycles of unknown age data field is greater than the killed bicyclists of unknown age data field The killed drivers of 2 wheelers aged 0 5 years data field is greater than the killed occupants of 2 wheelers aged 0 5 years data field The killed drivers of 2 wheelers aged 6 9 years data field is greater than the killed occupants of 2 wheelers aged 6 9 years data field The killed drivers of 2 wheelers aged 10 14 years data field is greater than the killed occupants of 2 wheelers aged 10 14 years data field 75 87 88 89 90 91 92 93 94 95 96 97 The killed drivers of 2 wheelers aged 15 17 years data field is greater than the killed occupants of 2 wheelers aged 15 17 years data field The killed drivers of 2 wheelers aged 18 20 years data field is greater than the killed occupants of 2 wheelers aged 18 20 years data field The killed drivers of 2 wheelers aged 21 24 years data field is greater than the killed occupants of 2 wheelers aged 21 24 years data field The killed drivers of 2 wheelers aged 25 64 years data field is greater than the killed oc
22. obscure any proprietary notices labels or marks from the Software or Documentation iii distribute rent loan lease sell sublicense or otherwise transfer all or part of the Software Documentation or any rights granted hereunder to any other person without the prior written consent of United Nations ESCAP All reproduction and distribution must contain all original files including this Legal Notice and all its components f As a condition of use of the APRAD Products the User agrees to indemnify United Nations ESCAP from and against any and all actions claims losses damages liabilities and expenses including attorneys fees arising out of the User s use of the Products including without limitation any claims alleging facts that if true would constitute a breach by the User of these Terms and Conditions If the User is dissatisfied with any Material or Product or with any of the Terms and Conditions of Use the User s sole and exclusive remedy is to discontinue using the APRAD Products 0 All APRAD Products are provided as is without warranty of any kind either express or implied including without limitation warranties of merchantability fitness for a particular purpose and non infringement The United Nations ESCAP specifically does not make any warranties or representations as to the accuracy or completeness of any Materials United Nations ESCAP periodically adds changes improves or updates the Materials with
23. other motor vehicles aged 21 24 years data field The killed drivers of other motor vehicles aged 25 64 years data field is greater than the killed occupants of other motor vehicles aged 25 64 years data field The killed drivers of other motor vehicles aged 65 years amp more data field is greater than the killed occupants of other motor vehicles aged 65 years amp more data field The killed drivers of other motor vehicles of unknown age data field is greater than the killed occupants of other motor vehicles of unknown age data field The killed drivers of unknown vehicles aged 0 5 years data field is greater than the killed occupants of unknown vehicles aged 0 5 years data field The killed drivers of unknown vehicles aged 6 9 years data field is greater than the killed occupants of unknown vehicles aged 6 9 years data field The killed drivers of unknown vehicles aged 10 14 years data field is greater than the killed occupants of unknown vehicles aged 10 14 years data field The killed drivers of unknown vehicles aged 15 17 years data field is greater than the killed occupants of unknown vehicles aged 15 17 years data field The killed drivers of unknown vehicles aged 18 20 years data field is greater than the killed occupants of unknown vehicles aged 18 20 years data field The killed drivers of unknown vehicles aged 21 24 years data field is greater than the killed occupants of u
24. please click Start Menu on the Task Bar and select Run The Hun dialogue will be shown as in the figure below Run REI resource and Windows will open it for you Open Cancel Browse Type the name of a program folder document or Internet Fig 28 Run Dialogue 30 2 Please click on the Browse button The Browse dialogue will be shown as in Fig 29 Browse the installation CD ROM and then select Setup exe Look in a Input V ersion amp Al ei File name Setup exe Open Files of type Programs m Cancel 2 Fig 29 Browse Dialogue Browse for Setup exe of the Input Version on the CD ROM 3 Please click on the Open button the selected path and program should appear in the Run dialogue as in the figure below The letter for the drive may be different depending on the name of your CD ROM drive Hun 21 resource and Windows will open it for you Open X Setup exe E Cancel Browse Fig 30 Run Dialogue with the specified Setup exe program 31 Type the name of a program folder document or Intemet 31 4 Please click on the OK button the Input Version setup program will start see Fig 27 APRAD Input Version Setup Then please follow the instruction on the screen You will be prompted to select the destination path and the name of the program group for the Input Version 32 2 2 Usage After the installation is comple
25. the killed drivers of passenger cars aged 25 64 years data field The killed male drivers of passenger cars aged 65 years amp more data field is greater than the killed drivers of passenger cars aged 65 years amp more data field The killed male drivers of passenger cars of unknown age data field is greater than the killed drivers of passenger cars of unknown age data field The killed male drivers of light goods vehicles aged 0 5 years data field is greater than the killed drivers of light goods vehicles aged 0 5 years data field The killed male drivers of light goods vehicles aged 6 9 years data field is greater than the killed drivers of light goods vehicles aged 6 9 years data field The killed male drivers of light goods vehicles aged 10 14 years data field is greater than the killed drivers of light goods vehicles aged 10 14 years data field The killed male drivers of light goods vehicles aged 15 17 years data field is greater than the killed drivers of light goods vehicles aged 15 17 years data field The killed male drivers of light goods vehicles aged 18 20 years data field is greater than the killed drivers of light goods vehicles aged 18 20 years data field The killed male drivers of light goods vehicles aged 21 24 years data field is greater than the killed drivers of light goods vehicles aged 21 24 years data field 86 207 208 209 210 211 212
26. unspecified location is not equal to the total number of casualty accidents injury and death data field The sum of the casualty accident data fields by road category number of casualty accidents on motorways number of casualty accidents on national highways number of casualty accidents on provincial regional roads number of casualty accidents on other roads is not equal to the total number of casualty accidents injury and death data field The sum of the casualty accident data fields by time number of casualty accidents at daytime number of casualty accidents at nighttime and number of casualty accidents at 67 19 20 21 22 23 24 25 unknown unspecified time is not equal to the total number of casualty accidents injury and death data field The sum of the casualty accident data fields by road surface condition number of casualty accidents on wet roads number of casualty accidents on dry roads and number of casualty accidents on unknown unspecified surface condition is not equal to the total number of casualty accidents injury and death data field CASUALTIES The total number of killed and injured road users data field is greater than the total number of casualty accidents injury and death data field The sum of the casualties data fields total number injured road users and total number of killed road users is not equal to the total number of killed and
27. year 1 vehicle type and any countries 18 An output result of this query may look like Figure 16 below D Analysis Yersion Densities Densities ES Fig 16 Example output from a select 1 year 1 vehicle type and any countries query Select 3 years and any countries This query will be shown when one of the outputs from the Trends Menu is selected as listed below Trends Menu gt Casualty Accidents Trends Menu gt Fatalities by Context Trends Menu gt Fatalities by Road User Type Trends Menu gt Fatalities by Age Group An example of the query page for Casualty Accidents output may look like Figure 17 see next page 6 APRAD Analysis Version Casualty Accidents Pel EG Fig 17 Example of a Query Page for select 3 years and any countries b Query for Overviews The queries in this group will be displayed when output from the Overviews group is selected see Data Analysis Menu Page There are two queries as follows Regional Report Query Select a year range 1 data type and any countries APRAD Analysis Version Regional Report TOTAL POPULATION POPULATION AGED 0 5 YEARS POPULATION AGED 6 9 YEARS POPULATION AGED 10 14 YEARS POPULATION AGED 15 17 YEARS POPULATION AGED 18 20 YEARS Fig 18 Example of a Regional Report query 20 The Regional Report query and output may look like Figure 18 above and 19 below respectively APRAD Analysis Versi
28. 1014 10 14 KIUV2564 25 64 KIUV6599 65 KIUVUA UNKWN UNKNOWN VEH AGE TYPE AGED 25 64 25 64 KI2W2564 25 64 25 64 KILLED OCC S KILVOOO5 0 5 KILVO609 KILV1014 10 14 KILV1517 15 17 KILV1820 18 20 KILV2124 21 24 LGV S AGED 5 KIUV1517 005 la ia i did 10 14 KIPC1517 15 17 1820 18 20 KIPC2124 21 24 15 17 KIUV1820 18 20 KIUV2124 21 24 53 Field Field Field Field label Field Field label Field Field label Field Field label Field Field label Field Field label name name name name name name name name 2nd 2nd 2nd 2nd 2nd 2nd 2nd 2nd part part part part part part 65 KIBCUAD UNKWN AGE KI2W6599D 65 KI2WUAD UNKWN AGE KIBC1820D 18 20 21240 21 24 KIBC2564D 25 64 KIBC6599D KI2W1820D 18 20 KI2W2124D 21 24 KI2W2564D 25 64 KI3W1820D 18 20 KI3W2124D 21 24 KI3W2564D 25 64 KILLED DRIVERS KIBCOO005D 0 5 KIBCO609D KIBC1014D 10 14 KIBC1517D 15 17 BICYCLES KILLED DRIVERS KI2WO0005D ee KI2W1014D 10 14 KI2W1517D 15 17 KILLED DRIVERS KI3WO0005D KI3W1014D 10 14 KI3W1517D 15 17 KI3W6599D KISWUAD UNKWN AGE KIPCUAD UNKWN AGE KILV6599D 65 KILVUAD UNKWN AGE KILLED DRIVERS KIPC0005D 0 5 KIPCO609D KIPC1014D 10 14 KIPC1517D 15 17 KIPC1820D 18 20 KIPC212D4 21 24 KIPC2564D 25 64 PASS CARS AGED KILLED DRIVERS KILVOOO5D 0 5 KILVO609D KILV1014D 10 14 KILV1517D 15 17 KILV1820D 18 20 LGV S AGED
29. 115 116 117 118 119 The killed drivers of passenger cars aged 65 years amp more data field is greater than the killed occupants of passenger cars aged 65 years amp more data field The killed drivers of passenger cars of unknown age data field is greater than the killed occupants of passenger cars of unknown age data field The killed drivers of light goods vehicles aged 0 5 years data field is greater than the killed occupants of light goods vehicles aged 0 5 years data field The killed drivers of light goods vehicles aged 6 9 years data field is greater than the killed occupants of light goods vehicles aged 6 9 years data field The killed drivers of light goods vehicles aged 10 14 years data field is greater than the killed occupants of light goods vehicles aged 10 14 years data field The killed drivers of light goods vehicles aged 15 17 years data field is greater than the killed occupants of light goods vehicles aged 15 17 years data field The killed drivers of light goods vehicles aged 18 20 years data field is greater than the killed occupants of light goods vehicles aged 18 20 years data field The killed drivers of light goods vehicles aged 21 24 years data field is greater than the killed occupants of light goods vehicles aged 21 24 years data field The killed drivers of light goods vehicles aged 25 64 years data field is greater than the killed occupa
30. 19 years and killed females aged 19 years is not equal to the all killed aged 19 years data field The sum of the fatalities aged 20 years data fields by sex killed males aged 20 years and killed females aged 20 years is not equal to the all killed aged 20 years data field The sum of the individual year fatalities data fields killed aged 15 years 16 years and 17 years is not equal to the killed aged 15 17 years data field The sum of the individual year fatalities data fields killed aged 18 years 19 years and 20 years is not equal to the killed aged 18 20 years data field The sum of the standard age group fatalities data fields killed aged 0 5 years 6 9 years and 10 14 years is not equal to the killed aged 0 14 years data field 71 53 54 55 56 57 58 59 60 61 62 The sum of the standard age group fatalities data fields killed aged 15 17 years 18 20 years and 21 24 years is not equal to the killed aged 15 24 years data field The sum of the standard age group fatalities data fields killed aged 25 34 years 35 44 years 45 54 years 55 59 years and 60 64 years is not equal to the killed aged 25 64 years data field The sum of the fatalities data fields killed males aged 15 years 16 years and 17 years is not equal to the killed males aged 15 17 years data field The sum of the fatalities data fields killed males
31. 60 64 years is not equal to the killed females aged 25 64 years data field FATALITIES BY ROAD USER TYPE AND AGE GROUP The sum of the fatalities data fields killed pedestrians aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown is not equal to the killed pedestrians data field The sum of the fatalities data fields killed bicyclists aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown is not equal to the killed occupants of bicycles data field The sum of the fatalities data fields killed occupants of 2 wheelers aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown is not equal to the killed occupants of 2 wheelers data field The sum of the fatalities data fields killed occupants of 3 wheelers aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown is not equal to the killed occupants of 3 wheelers data field The sum of the fatalities data fields killed occupants of passe
32. 980 The data value will be computed and displayed for each country selected in the first query page If the user selects more than one year or more than one data type for Data1 or Data2 the sum of that selection 23 APRAD Analysis Version Custom Analysis My Report will be used For example if the user wants to find out the Casualties Growth for the period 1980 1983 for two year intervals the selection for Data1 and Data2 may look like Figure 24 below cop abel Costes Growth killed injured 80 81 to 82 83 2 yrs interval r Datal Data Casualties Operate Data TOTAL NUMBER OF KILLED AND INJURED ROAD USERS C None TOTAL NUMBER OF INJURED ROAD USERS Add TOTAL NUMBER OF KILLED ROAD USERS CIKILLED PEDESTRIANS x Subtract Year T1881 C Multiply x vi C Divide 1983 r Data2 Data Casualties r Operation Data C TOTAL NUMBER DF KILLED AND INJURED ROAD USERS None C vj TOTAL NUMBER OF KILLED ROAD USERS CJ KILLED PEDESTRIANS C Subtract 3 Year z Multiply x 1981 C Divide 11982 l Fig 24 Example of a second query page query second data column with multiple data selection for the Custom Analysis From the figure above it can be seen that the user selects two data types and two years each for both Data1 and Data2 The value in Data1 is obtai
33. ECONOMIC AND SOCIAL COMMISSION FOR ASIA AND THE PACIFIC Asia Pacific Road Accident Database APRAD User Manual APRAD Analysis Version Escap Road Safety Database yc y E Transport Communications Tourism and Infrastructure Development Economic and Social Commission for Asia and the Pacific ESCAP e UNITED NATIONS Bangkok Thailand Developed with financial assistance from the Government of Germany through TZ German Technical Cooperation Latest Data Update 21 12 2001 UNITED NATIONS ECONOMIC AND SOCIAL COMMISSION FOR ASIA AND THE PACIFIC Asia Pacific Road Accident Database APRAD User Manual Vers 1 1 May 2002 UNITED NATIONS New York 2001 This publication is part of a series on road safety in the Asia Pacific region So far this consists of e Review of Road Safety in Asia and the Pacific ST ESCAP 1984 e Asia Pacific Road Accident Statistics and Road Safety Inventory ST ESCAP 1815 Road Safety in Asia and the Pacific Report of the ESCAP ADB cum Workshop 2 6 September 1996 Bangkok ST ESCAP 1796 Guidelines on Road Safety Action Plans and Programmes ST ESCAP 1996 Asia Pacific Road Accident Database APRAD User Manual ST ESCAP 2178 ST ESCAP 2178 This publication and the development of the APRAD database and software package were funded by the Government of Germany through GTZ German Technical Cooperation The designations employed and t
34. FEMALE KI_6599F FEMALE UAF FEMALE KILLED AGED 6 9 YEARS 0609 ALL 0609M MALE KILLED AGED 10 14 YEARS 1014 ALL 1014M MALE KILLED AGED 15 17 YEARS 1517 ALL 1517M MALE KILLED AGED 18 20 YEARS 1820 ALL 182 MALE KILLED AGED 21 24 YEARS 2124 ALL 2124M MALE KILLED AGED 25 34 YEARS 2534 ALL 2534M MALE KILLED AGED 35 44 YEARS 3544 ALL 3544M MALE KILLED AGED 45 54 YEARS 4554 ALL 4554M MALE KILLED AGED 55 59 YEARS 5559 ALL 5559 MALE KILLED AGED 60 64 YEARS 6064 ALL 6064M MALE KILLED AGED KI 6599 65 AND MORE ALL 6599M MALE KILLED OF UNKNOWN AGE UAM MALE 51 Field label 0014 0014M 0014F 1524 1524M 1524F 2564 2564M 2564F 1515 1515M 1515F 1616 1616M 1616F 1717 1717M 1717F 1818 1818M 1818F 1919 1919M 1919F 2020 2020M 2020F Field name 1st part KILLED AGED 0 14 YEARS KILLED AGED 15 24 YEARS KILLED AGED 25 64 YEARS KILLED AGED 15 YEARS KILLED AGED 16 YEARS KILLED AGED 17 YEARS KILLED AGED 18 YEARS KILLED AGED 19 YEARS KILLED AGED 20 YEARS 52 Field name Field Field Field label Field Field label Field Field label Field Field label Field Field label Field
35. HECK Note Data inconsistencies are reported only for those consistency rules where all data fields have a value If any data field of a specific consistency rule is blank either by omission or due to non availability the respective error message if any for data inconsistency will not be displayed Please see the following error messages for data inconsistency a GENERAL DATA Population The sum of the standard population age group data fields population aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more is not equal to the total population data field The sum of the optional population age group data fields population aged 0 14 years 15 24 years 25 64 years and 65 years amp more is not equal to the total population data field The sum of the individual year population age data fields population aged 15 years 16 years and 17 years is not equal to the population aged 15 17 years data field The sum of the individual year population age data fields population aged 18 years 19 years and 20 years is not equal to the population aged 18 20 years data field The sum of the standard population age group data fields population aged 0 5 years 6 9 years and 10 14 years is not equal to the population aged 0 14 years data field 65 b c 10 11 12 The sum of the sta
36. IBLE WEIGHT 46 Field Field Name Label NOBU NUMBER OF BUSES 10 AND MORE SEATS INCL DRIVER S SEAT NORE NUMBER OF OTHER MOTOR VEHICLES NOPCLV NUMBER OF PASSENGER CARS amp LIGHT GOODS VEHICLES NOHVBU NUMBER OF HEAVY GOODS VEHICLES AND BUSES KMAL TOTAL KILOMETRAGE OF ALL MOTOR VEHICLES KMMW KILOMETRAGE OF ALL MOTOR VEHICLES ON MOTORWAYS KM2W KILOMETRAGE OF MOTORISED 2 WHEELERS KM3W KILOMETRAGE OF MOTORISED 3 WHEELERS KMPC KILOMETRAGE OF PASSENGER CARS STATION WAGONS ETC UP TO 9 SEATS KMLGV KILOMETRAGE OF LIGHT GOODS VEHICLES UP TO 3 5 TONS MAX PERMISSIBLE WEIGHT KMHGV KILOMETRAGE OF HEAVY GOODS VEHICLES 3 5 TONS MAX PERMISSIBLE WEIGHT KMBU KILOMETRAGE OF BUSES 10 AND MORE SEATS Casualty Accidents IAAL TOTAL NUMBER OF CASUALTY ACCIDENTS INJURY AND DEATH TOTAL NUMBER INJURY ONLY ACCIDENTS FAAL TOTAL NUMBER OF FATAL ACCIDENTS IAUR NUMBER OF CASUALTY ACCIDENTS INSIDE URBAN AREAS 47 Field Label IAOU IAUL IAMW IAPR IAOR IAUKR IAUT IAWET IADRY IAUW Field Name NUMBER OF CASUALTY ACCIDENTS OUTSIDE URBAN AREAS NUMBER OF CASUALTY ACCIDENTS IN UNKNOWN UNSPECIFIED LOCATION NUMBER OF CASUALTY ACCIDENTS ON MOTORWAYS NUMBER OF CASUALTY ACCIDENTS ON NATIONAL HIGHWAYS NUMBER OF CASUALTY ACCIDENTS ON PROVINCIAL REGIONAL ROADS NUMBER OF CASUALTY ACCIDENTS ON OTHER ROADS NUMBER OF CASUALTY ACCIDENTS ON
37. MALE KI2W0005DM KI2WO0609DM KI3WO0005DM KI3W0609DM KI3W1014DM 10 14 KI3W1517DM 15 17 KI3W1820DM 18 20 KI3W2124DM 21 24 KI3W2564DM 25 64 KI3W6599DM 1 1 k i un n KILLED MALE 0 5 KIPCO609DM KIPC1014DM 0 14 KIPC1517DM 15 17 KIPC1820DM 18 20 KIPC2124DM 21 24 KIPC2564DM 25 64 KIPC6599DM 65 DRIVER PASS CARS AGED KILLED MALE KILV0005DM 0 5 KILVO609DM KILV1014DM 10 14 KILV1517DM 15 17 KILV1820DM 18 20 KILV2124DM 21 24 KILV2564DM 25 64 KILV6599DM 65 KILVUADM DRIVERS LGV S AGED iin m li KIBCUADM KI2WUADM KISWUADM KIPCUADM KWN AGE KILLED MALE KIHVOG09DM KIHV1014DM 0 14 KIHV1517DM 15 17 KIHV1820DM 18 20 KIHV2124DM 21 24 KIHV2564DM 25 64 KIHV6599DM KIHVUADM DRIVERS HGV S AGED KILLED MALE KIBUOO05DM KIBUOG09DM KIBU1014DM 10 14 KIBU1517DM 15 17 KIBU1820DM 118 20 KIBU2124DM 21 24 KIBU2564DM 25 64 KIBU6599DM KIOMVO005DM KIOMV1014DM 10 14 KIOMV1517DM 15 17 KIOMV 1820DM 18 20 KIOMV2124DM 21 24 KIOMV2564DM 25 64 KIOMV6599DM KIUVOO05DM KIUVOG09DM KIUV1014DM 110 14 KIUV1517DM 15 17 KIUV1820DM 118 20 KIUV2124DM 9 21 24 KIUV2564DM 25 64 KIUV6599DM 55 KIBUUADM KWN AGE KIOMVUADM UN KWN AGE KIUVUADM KWN AGE Annex APRAD STANDARD DATA DEFINITIONS 1 GENERAL DATA APRAD Data Definition Country Name of the country as per UN standard format Year
38. TATION WAGONS ETC UP TO 3 SEATS NUMBER OF LIGHT GOODS VEHICLES UP TO 3 5 TONS MAX PERMISSIBLE WEIGHT NUMBER OF HEAVY GOODS VEHICLES 3 5 TONS MAX PERMISSIBLE WEIGHT NUMBER OF BUSES 10 AND MORE SEATS INCL DRIVER S SEAT 1 782 900 1 991 400 2 157 500 2 326 300 25 NUMBER OF OTHER MOTORISED VEHICLES sx gt amp Back Previous 10 Next 10 Beport Fig 21 Example of a Country Report output c Query for Selected Output This query is used for generating a Custom Analysis output The Custom Analysis provides the way for users to customize their own analysis and output results There are two types of query pages as described below In the first query page the user can define report title heading of the table or graph the number of data fields columns of the table and a set of countries to be reported The valid range for the number of data fields is from 1 to 10 APRAD Analysis Version Custom Analysis x Countr Y Select number of data fields 2 Vanuatu Title y Report lew Zealand N Select all countries Back Ok Fig 22 Example of the first query page for the Custom Analysis In the output report the number of data fields is the number of data columns In the output graph the number of data fields is the number of data series 22 In the second query page the user can specify the contents of each dat
39. a column There are two main contents for each column column header and column value The column header can be defined in the Label box The column values are obtained through the query selection in the Data1 and Data2 boxes The user can specify the query content for each column after clicking on its tab on the top of this query page APRAD Analysis Version Custom Analysis My Report nf x coz Label Population Growth 1980 1981 r Datal Data Population Operate Data None Constant C POPULATION AGED 0 5 YEARS C POPULATION AGED 6 9 YEARS C Add 0 C POPULATION AGED 10 14 YEARS Subtract Year vi Data2 11982 C Divide 1983 r Data2 Data Population Operation Data Type TOTAL POPULATION None Constant C POPULATION AGED 0 5 YEARS C Add C POPULATION AGED 6 3 YEARS x 0 POPULATION AGED 10 14 YEARS zi C Subtract Year e C Multiply x 1981 C Divide 1982 Fig 23 Example of the second query page query first data column for the Custom Analysis As can be seen from the figure above the user defines the name of the first data column Colt as Population Growth 1980 to 1981 The data value is the result of a mathematical operation linking Data1 and Data2 Data1 Total Population year 1981 operator Subtract 2 and Data2 Total Population year 1
40. an select the graph type and the data series all or a selection of the data of the output 25 The Legend and Data Point data values can be displayed or not by using the toggle buttons The Scale button can be used to toggle the scale between the absolute values mode and the relative values percentage mode If more than ten countries are selected the display will show only ten countries at a time together with a horizontal scroll bar APRAD Analysis Version Reference Values 1980 Of x Please select Data Series and Graph Type to display Reference Values 1980 a 100 4 9 80 70 60 Total population 7 Total area 30 m Total network length of allp 20 Network length of all natior m Network length of all pavec HR Total number of motor vehi Bl Number of motorized 2 whe c B 5 Number of passenger cars 15 S E e E E B country EL Data Series Graph Type Toggle buttons ire Total area Legend Scale Print Current Back Total network length of all public roads eae Network length of all national highways DataPoint Notes For 2D Pie graph only the first selected data series will be displayed Fig 26 Example of a Graph Page The user can use the mouse while pressing the Control key to modify the graph display The graph display can then be printed by clicking the Print Current button Note
41. are many options that can be selected such as zooming printing etc Besides this the report can also be exported saved to another file format or sent by e mail For this option e mail software that provides a MAPI interface must be installed in your computer APRAD Input Version Data Key In 5 x Country China Year 1991 Field Name Value Source Dax fc Source of data T Remark TOTAL NUMBER OF MOTOR VEHICLES 16 576 599 ESCAP Questionnaire 1980 1993 Country Statistical Yearbooks various years ESCAP Statistical Yearbook for Asia and the Pacific NUMBER OF MOTORISED 2 WHEELER 052 00 RT Questionnaire 1990 1993 Country Sta Yearbooks various years ESCAP Statistical Yearbook for Asia and the Pacific NUMBER OF MOTORISED 7 WHEELERS NUMBER OF PASSENGER CARS AY Questionnaire 1980 1993 Country Std Yearbooks STATION WAGONS ETC UP TO9 various years ESCAP Statistical Yearbook for Asia and the Pacific SEATS ROMEER OF LIGHT 70005 VEHICLES UP T0 3 5 TONS MAX PERMISSIBLE WEIGHT FUMEER OF HEAVY GOODS VEHICLES 23 5 TONS MAX PERMISSIBLE WEIGHT NUMBER OF BU TARD SEATS INCL DRIVER S SEAT ROMEER OF UTHER MOTORISED ESCA Quetianie 07 97 Sun Vestodis VEHICLES various years ESCAP Statistical Yearbook for Asia and the Pacific NUMBER OF PASSENGER CARS amp LIGHT 6 061 100 GOODS VEHICLES NUMBER OF HEAVY GOODS VEHI AND BUSES
42. ars data field The killed male drivers of other motor vehicles aged 21 24 years data field is greater than the killed drivers of other motor vehicles aged 21 24 years data field The killed male drivers of other motor vehicles aged 25 64 years data field is greater than the killed drivers of other motor vehicles aged 25 64 years data field The killed male drivers of other motor vehicles aged 65 years amp more data field is greater than the killed drivers of other motor vehicles aged 65 years amp more data field The killed male drivers of other motor vehicles of unknown age data field is greater than the killed drivers of other motor vehicles of unknown age data field The killed male drivers of unknown vehicles aged 0 5 years data field is greater than the killed drivers of unknown vehicles aged 0 5 years data field The killed male drivers of unknown vehicles aged 6 9 years data field is greater than the killed drivers of unknown vehicles aged 6 9 years data field The killed male drivers of unknown vehicles aged 10 14 years data field is greater than the killed drivers of unknown vehicles aged 10 14 years data field 89 240 241 242 243 244 245 The killed male drivers of unknown vehicles aged 15 17 years data field is greater than the killed drivers of unknown vehicles aged 15 17 years data field The killed male drivers of unknown vehicles aged 18 20 ye
43. ars data field is greater than the killed drivers of unknown vehicles aged 18 20 years data field The killed male drivers of unknown vehicles aged 21 24 years data field is greater than the killed drivers of unknown vehicles aged 21 24 years data field The killed male drivers of unknown vehicles aged 25 64 years data field is greater than the killed drivers of unknown vehicles aged 25 64 years data field The killed male drivers of unknown vehicles aged 65 years amp more data field is greater than the killed drivers of unknown vehicles aged 65 years amp more data field The killed male drivers of unknown vehicles of unknown age data field is greater than the killed drivers of unknown vehicles of unknown age data field 90 Annex IV LEGAL NOTICE 1 COPYRIGHT APRAD Copyright 2001 United Nations Economic and Social Commission for Asia and the Pacific United Nations ESCAP Bangkok Thailand All rights reserved Asia Pacific Road Accident Database APRAD APRAD Analysis Version APRAD Input Version APRAD User Manual The APRAD software programs Software database files Database and accompanying written or electronic materials Documentation collectively APRAD Products are the property of United Nations ESCAP and protected by copyright laws Microsoft MS Access MS Visual Basic and MS Windows are trademarks of Microsoft Corporation All other product names and
44. asualties Risk Values Menu gt Fatalities by Age Group Context per Population Risk Values Menu gt Fatalities by Context per Vehicle Fleet Kilometrage An example of the query page for Reference Values output may look like Figure 13 below APRAD Analysis Version Reference Values DPR Korea Hong Kong China Macau China Mongolia Republic of Korea Taiwan Prov of China Fig 13 Example of a Query Page for select 1 year and any countries An output result of this query may look like the following Figure14 17 APRAD Analysis Version Reference Values olx Reference Yalues 1982 Country Total population Total area Total network length of all public roads Network length 1024582000 DPR Korea 18901000 120410 Macau China Mongolia 1758000 Report Graph Fig 14 Example output from a select 1 year and any countries query gt Select 1 year 1 vehicle type and any countries This query will be shown when output is selected as General Data Menu Densities and the query page may look like Figure 15 below APRAD Analysis Version Densities Please Select Y ear 1562 J Please Select Vehicle Please Select Country China DPR Korea Hong Kong China Macau China Mongolia Republic of Korea Taiwan Prov of China Select all countries Fig 15 Example of a Query Page for select 1
45. consistency of the data input can be checked by using the Data Consistency Check function and an updated national data file can the be send back to ESCAP by using the Data Export function After using the Data Export function the Start Menu will be back in the first state as shown in Fig 34a For details please see the following Sections APRAD Input Version START Menu ojx Data S i Data Consistency Check Data Export APRAD Input Version START Menu OL x i vr 2 Data Key In v Data Consistency Check 020 Data Export Fig 34 Start Menu Page before importing the data request file b after importing the data request file 35 2 21 Data Input File Import When the Data Import function is selected the user will be prompted to import the country specific data request query input file received from ESCAP The import file is a Microsoft Access 97 database file with the filename being the name of the specific country and a selected year or year range as suffix APRAD Input Version Data Import Ea Please click button to select database to import Path Browse Fig 35 Data Import Dialogue By typing the name of the national import file and its path into the Path box or by using the Browse button to find in A drive or E drive and then select the file to be imported The following import information will then be displayed If
46. cupants of 2 wheelers aged 25 64 years data field The killed drivers of 2 wheelers aged 65 years amp more data field is greater than the killed occupants of 2 wheelers aged 65 years amp more data field The killed drivers of 2 wheelers of unknown age data field is greater than the killed occupants of 2 wheelers of unknown age data field The killed drivers of 3 wheelers aged 0 5 years data field is greater than the killed occupants of 3 wheelers aged 0 5 years data field The killed drivers of 3 wheelers aged 6 9 years data field is greater than the killed occupants of 3 wheelers aged 6 9 years data field The killed drivers of 3 wheelers aged 10 14 years data field is greater than the killed occupants of 3 wheelers aged 10 14 years data field The killed drivers of 3 wheelers aged 15 17 years data field is greater than the killed occupants of 3 wheelers aged 15 17 years data field The killed drivers of 3 wheelers aged 18 20 years data field is greater than the killed occupants of 3 wheelers aged 18 20 years data field 76 98 99 100 101 102 103 104 105 106 107 108 The killed drivers of 3 wheelers aged 21 24 years data field is greater than the killed occupants of 3 wheelers aged 21 24 years data field The killed drivers of 3 wheelers aged 25 64 years data field is greater than the killed occupants of 3 wheelers aged 25 64
47. d 25 64 years data field The killed male drivers of 3 wheelers aged 65 years amp more data field is greater than the killed drivers of 3 wheelers aged 65 years amp more data field The killed male drivers of 3 wheelers of unknown age data field is greater than the killed drivers of 3 wheelers of unknown age data field The killed male drivers of passenger cars aged 0 5 years data field is greater than the killed drivers of passenger cars aged 0 5 years data field The killed male drivers of passenger cars aged 6 9 years data field is greater than the killed drivers of passenger cars aged 6 9 years data field The killed male drivers of passenger cars aged 10 14 years data field is greater than the killed drivers of passenger cars aged 10 14 years data field The killed male drivers of passenger cars aged 15 17 years data field is greater than the killed drivers of passenger cars aged 15 17 years data field 85 196 197 198 199 200 201 202 203 204 205 206 The killed male drivers of passenger cars aged 18 20 years data field is greater than the killed drivers of passenger cars aged 18 20 years data field The killed male drivers of passenger cars aged 21 24 years data field is greater than the killed drivers of passenger cars aged 21 24 years data field The killed male drivers of passenger cars aged 25 64 years data field is greater than
48. dividuals concerned about road accidents Users The information presented herein is for informative purposes only The United Nations ESCAP grants permission to Users to download and copy the data information and documents collectively Materials included in the Software for the Users official or personal non commercial use without any right to resell or redistribute them or to compile or create derivative works thereof b The United Nations ESCAP administers the Database All Materials in this Database appears subject to the present Terms and Conditions c Unless expressly stated otherwise the data and information in the Database are those of the various National APRAD Coordinating Agencies or a number of other sources compiled by staff members and consultants to the United Nations Secretariat or its affiliates The inclusion in the Database does not necessarily represent any expression of opinion by the United Nations or its member states d National APRAD Coordinating Agencies may in whole reproduce or transmit and distribute as deemed appropriate the APRAD Analysis Version Software the Database and the Documentation provided that this Legal Notice Copyright and Terms and Conditions of Use 92 appear in all copies electronic or mechanical and any supporting documentation e However no User may i reverse engineer de compile or disassemble the Software or modify it in any way ii remove alter or
49. e Pacific ESCAP e UNITED NATIONS Bangkok Thailand Developed with financial assistance from the Government of Germany through GTZ German Technical Cooperation Software Version 1 0 Latest Data Update 2 Fig 5 Opening Page 1 2 2 Overview of all Menu Pages The menu structure of the APRAD Analysis Version is shown in the figure below Start Menu Data Analysis Menu Standard Output General Data Menu Reference Values Query Densities Query Standard Output Accidents and Casualties Menu Accidents Query Casualties Query Standard Output Trends Menu Casualty Accidents Query Fatalities by Context Query Fatalities by Road User Type Query Fatalities by Age Group Query Standard Output Risk Values Menu Accidents and Casualties Query Fatalities by Age Group Context per Population Query Fatalities by Context per Vehicle Fleet Kilometrage Query Overviews Regional Report Query Overviews Country Report Query Selected Output Custom Analysis Query Fig 6 Menu structure tree of the APRAD Analysis Version From the structure tree it can be seen that each of the non terminal nodes is a menu page and each of the terminal nodes is a query page All menu pages will be shown below The query pages will be shown in the following Section 1 2 3 Query and Output Pages Start Menu Page In the Start Menu of the Analysis Version only the Data Analysis feature is provided If the Data Analysis button is clicked the Data A
50. ed 21 24 years data field is greater than the killed drivers of heavy goods vehicles aged 21 24 years data field The killed male drivers of heavy goods vehicles aged 25 64 years data field is greater than the killed drivers of heavy goods vehicles aged 25 64 years data field The killed male drivers of heavy goods vehicles aged 65 years amp more data field is greater than the killed drivers of heavy goods vehicles aged 65 years amp more data field 87 218 219 220 221 222 223 224 225 226 22T 228 The male drivers of heavy goods vehicles of unknown age data field is greater than the killed drivers of heavy goods vehicles of unknown age data field The killed male drivers of buses aged 0 5 years data field is greater than the killed drivers of buses aged 0 5 years data field The killed male drivers of buses aged 6 9 years data field is greater than the killed drivers of buses aged 6 9 years data field The killed male drivers of buses aged 10 14 years data field is greater than the killed drivers of buses aged 10 14 years data field The killed male drivers of buses aged 15 17 years data field is greater than the killed drivers of buses aged 15 17 years data field The killed male drivers of buses aged 18 20 years data field is greater than the killed drivers of buses aged 18 20 years data field The killed male drivers of b
51. ename being the country name with a selected year or year range as suffix 41 When the Data Export button is pressed the export file dialogue see Fig 43 will be shown and the user will be prompted to select path and destination to save the export file APRAD Input Version Data Export Please select country and year China m Please click button to select path to save Path Browse Fig 43 Data Export Dialogue When the export path is specified and the Ok button is pressed the export function will process and save the export file to the specified destination For further processing i e updating of the full database which can only be done by ESCAP the export file will need to be sent either as an e mail attachment to tctidd unescap un org or copied to a diskette and mailed to Transport Communications Tourism and Infrastructure Development Division United Nations ESCAP UN Building Rajadamnern Nok Ave Bangkok 10200 Thailand 42 Annex APRAD DATA FORMAT Label 45 Label INNH NETWORK LENGTH OF ALL NATIONAL HIGHWAYS LENGTH OF ALL NATIONAL HIGHWAYS NLPR NETWORK LENGTH OF ALL PROVINCIAL REGIONAL ROADS NOPC NUMBER OF PASSENGER CARS STATION WAGONS ETC UP TO 9 SEATS NOLGV NUMBER OF LIGHT GOODS VEHICLES UP TO 3 5 TONS MAX PERMISSIBLE WEIGHT NOHGV NUMBER OF HEAVY GOODS VEHICLES 3 5 TONS MAX PERMISS
52. ers data field The sum of the fatalities data fields by road surface condition killed on wet roads killed on dry roads and killed on unknown unspecified road surface condition is not equal to the total number of killed road users data field FATALITIES BY AGE GROUP AND SEX The sum of the fatalities aged 0 5 years data fields by sex killed males aged 0 5 years and killed females aged 0 5 years is not equal to the all killed aged 0 5 years data field The sum of the fatalities aged 6 9 years data fields by sex killed males aged 6 9 years and killed females aged 6 9 years is not equal to the all killed aged 6 9 years data field The sum of the fatalities aged 10 14 years data fields by sex killed males aged 10 14 years and killed females aged 10 14 years is not equal to the all killed aged 10 14 years data field The sum of the fatalities aged 15 17 years data fields by sex killed males aged 15 17 years and killed females aged 15 17 years is not equal to the all killed aged 15 17 years data field The sum of the fatalities aged 18 20 years data fields by sex killed males aged 18 20 years and killed females aged 18 20 years is not equal to the all killed aged 18 20 years data field The sum of the fatalities aged 21 24 years data fields by sex killed males aged 21 24 years and killed females aged 21 24 years is not equal to the all killed aged 21 24 years data field 69 34
53. f the fatalities aged 0 14 years data fields by sex killed males aged 0 14 years and killed females aged 0 14 years is not equal to the all killed aged 0 14 years data field The sum of the fatalities aged 15 24 years data fields by sex killed males aged 15 24 years and killed females aged 15 24 years is not equal to the all killed aged 15 24 years data field 70 43 44 45 46 4T 48 49 50 51 52 The sum of the fatalities aged 25 64 years data fields by sex killed males aged 25 64 years and killed females aged 25 64 years is not equal to the all killed aged 25 64 years data field The sum of the fatalities aged 15 years data fields by sex killed males aged 15 years and killed females aged 15 years is not equal to the all killed aged 15 years data field The sum of the fatalities aged 16 years data fields by sex killed males aged 16 years and killed females aged 16 years is not equal to the all killed aged 16 years data field The sum of the fatalities aged 17 years data fields by sex killed males aged 17 years and killed females aged 17 years is not equal to the all killed aged 17 years data field The sum of the fatalities aged 18 years data fields by sex killed males aged 18 years and killed females aged 18 years is not equal to the all killed aged 18 years data field The sum of the fatalities aged 19 years data fields by sex killed males aged
54. he Opening Page is the welcome page that will be displayed every time you start the APRAD program If the Open button is pressed the Start Menu will appear next And if the Close button is pressed the program will be terminated APRAD Input Version Escap Road Safety Database Transport Communications Tourism and Infrastructure DevelopmentPivisron Economic and Social Commission for Asia and the Pacific ESCAP UNITED NATIONS Bangkok Thailand Developed with financial assistance from the Government of Germany through GTZ German Technical Cooperation Software Version 1 0 Latest Data Update 21 12 2001 Fig 33 Opening Page 34 2 2 3 Start Menu Page In the Start Menu of the Input Version there are four functions to be selected They are Data Import Data Key In Data Consistency Check and Data Export Fig 34 shows two states of the Start Menu At the start of the Input Version only the Data Import button is activated see Fig 34a This compels the user to import the country specific data request input file received from ESCAP either on diskette or together with a new software version on CD ROM through the Data Import function After the data request input file is imported the Data Key In Data Consistency Check and Data Export buttons will be activated instead as shown in Fig 34b The data requested by ESCAP can then be entered by using the Data Key In function After the data storage has been completed the
55. he presentation of the material in this report do not imply the expression of any opinion whatsoever on the part of the secretariat of the United Nations concerning the legal status of any country territory city or area or of its authorities or concerning the delimitation of its frontiers or boundaries This report has been issued without formal editing CONTENTS INTRODUCTION oer ene 1 PART 1 APRAD ANALYSIS VERSION 3 1 1 Installation 2 5 1 1 1 System 5 1 1 2 Program Setup eee i erm einn 5 1 2 Usage 9 Opening Page 9 1 2 2 Overview of all Menu 10 1 2 3 Query and Output 16 t amp d ierat erit 25 1 2 5 25 PART 2 INPUT 27 2 1 Installation mE E 29 2 1 1 System 29 2 1 2 Program Setup sse 29 2 2 BECOME 33 2271 LOGIN ee ie 33 2 2 2 Opening 34 2 2 3 Start Menu 35 2 24 Data Input File 36
56. l Yearbooks WAGONS ETC UP TO 3 SEATS NUMBER OF LIGHT GOODS VEHICLES UP TO 3 5 TONS MAX PERMISSIBLE WEIGHT NUMBER OF HEAVY GOODS VEHICLES 23 5 TONS MAX PERMISSIBLE WEIGHT NUMBER OF BUSES 10 AND MORE SEATS T INCL DRIVER S SEA NUMBER OTHER MOTORISED VEHICLES 5 972 000 ESCAP Questionnaire 1980 1993 amp xj Print Undo Delete Fig 39 Data Key In Page In the Data Key In Page the input data fields of the data category and year selected in the Data Key In Menu will be displayed together with the previous year values For entering data use the mouse to click the selected line for data input A dialogue box will appear and prompt for input In the Data Input dialogue box data values and sources can then be entered If a line already contains data from ESCAP s earlier survey they can be modified or deleted if necessary If any data are accidentally deleted this can be undone for the last step only by using the Undo Delete button on the Data Key In Page APRAD Input Version Data Input Iof x Field code KIPE1014M Field name KILLED MALE PEDESTRIANS AGED 10 14 YEARS m Please enter value and source of data Value Source of Data Nea Save Fig 40 Data Input Dialogue 39 The keyed in data can be printed by pressing the Print button in the Data Key In Page A Report Page will be displayed as in Fig 41 below In this view there
57. l ask the user for necessary information in order to generate a report table and or graph output For Reference Values the select 1 year and any countries query page will be displayed For Densities the select 1 year 1 vehicle type and any countries query page will be displayed For details please see Section 1 2 3 Query and Output Pages APRAD Analysis Version General Data EG Fig 9 General Data Menu Page Accidents and Casualties Menu Page There are two buttons in the Accidents and Casualties Menu They are the Accidents and Casualties buttons Each button will lead to a query page that will ask the user for necessary information in order to generate a report and or graph output For both the select 1 year and any countries query page will be displayed For details please see Section 1 2 3 Query and Output Pages APRAD Analysis Version Accidents and E3 Fig 10 Accidents and Casualties Menu Page 14 Trends Menu Page There are four buttons in the Trends Menu They are the Casualty Accidents Fatalities by Context Fatalities by Road User Type and Fatalities by Age Group buttons Each button will lead to a query page that will ask the user for necessary information in order to generate a report and or graph output For all buttons the select 3 years and any countries query page will be displayed For details please see Section 1 2 3 Query and Output Pages APRAD Analysis Version
58. lities by Road User Type and Age Group Fatalities by Vehicle Type and Age Group Driver Fatalities by Vehicle Type and Age Group Driver and Pedestrian Fatalities by Age Group and Sex Country China Year 1991 Area 9 327 420 sq km Casualties Population Casualties Road Network Fatalities by Age Group and Sex Vehicles Fatalities by Road User Type and Age Group Kilometrage Driver Fatalities by Vehicle Type and Age Group m Accidents Casualty Accidents Driver and Pedestrian Fatalities by Age Group and Sex APRAD Standard National Data Data Definitions Definitions Fig 38 Data Key In Menu Page Furthermore there are two additional buttons The APRAD Standard Data Definitions button will display the standard data definitions as used requested by APRAD and the National Data Definitions button will display a dialogue box for each country to specify national variations to the definitions of the data requested for APRAD 38 b Data Key In Page APRAD Input Version Data Key In Of x Country China Year 1991 Vehicles Please click any cell to edit Data field Source of data Remark TOTAL NUMBER OF MOTOR VEHICLES 16 576 599 ESCAP Questionnaire 1980 1993 NUMBER OF MOTORISED 2 WHEELERS 4 213 000 5 052 000 Country Statistical Yearbooks NUMBER OF MOTORISED 3 WHEELERS NUMBER OF PASSENGER CARS STATION ESCAP Questionnaire 1980 1993 5513600 6 061 100 Country Statistica
59. lled male pedestrians aged 25 64 years data field is greater than the killed pedestrians aged 25 64 years data field 82 163 164 165 166 167 168 169 170 171 172 173 The killed male pedestrians aged 65 years amp more data field is greater than the killed pedestrians aged 65 years amp more data field The killed male pedestrians of unknown age data field is greater than the killed pedestrians of unknown age data field The killed male drivers of bicycles aged 0 5 years data field is greater than the killed drivers of bicycles aged 0 5 years data field The killed male drivers of bicycles aged 6 9 years data field is greater than the killed drivers of bicycles aged 6 9 years data field The killed male drivers of bicycles aged 10 14 years data field is greater than the killed drivers of bicycles aged 10 4 years data field The killed male drivers of bicycles aged 15 17 years data field is greater than the killed drivers of bicycles aged 15 17 years data field The killed male drivers of bicycles aged 18 20 years data field is greater than the killed drivers of bicycles aged 18 20 years data field The killed male drivers of bicycles aged 21 24 years data field is greater than the killed drivers of bicycles aged 21 24 years data field The killed male drivers of bicycles aged 25 64 years data field is greater than
60. nalysis Menu will be shown APRAD Analysis Version START Menu BE Eg Fig 7 Start Menu Page Data Analysis Menu Page In the Data Analysis Menu there are seven buttons for selecting various outputs and one button for viewing the APRAD Data Definitions APRAD Analysis Version Data Analysis Mel Fig 8 Data Analysis Menu Page The output selection buttons are divided into three groups They are Standard Output Overviews and Selected Output In the Standard Output group there are four buttons When clicked the associated sub menu pages will be shown General Data button General Data Menu Accident and Casualties button Accident and Casualties Menu Trends button Trends Menu Risk Values button Risk Values Menu In the Overviews group there are two buttons When clicked the associated query pages will be shown Regional Report button Regional Report Query Country Report button Country Report Query In the Selected Output group there is only one button which when clicked will show the associated query page Custom Analysis button Custom Analysis Query For each sub menu page please see below For each query page please see Section 1 2 3 Query and Output Pages General Data Menu Page There are two buttons in the General Data Menu They are the Reference Values and Densities buttons Each button will lead to a query page that wil
61. ndard population age group data fields population aged 15 17 years 18 20 years and 21 24 years is not equal to the population aged 15 24 years data field The sum of the standard population age group data fields population aged 25 34 years 35 44 years 45 54 years 55 59 years and 60 64 years is not equal to the population aged 25 64 years data field Road Network The sum of the network length data fields by road category network length of all motorways all national highways all provincial regional roads and all other roads is not equal to the total network length of all public roads data field The sum of the network length data fields by road surface type network length of all paved roads and all unpaved roads is not equal to the total network length of all public roads data field Vehicles The sum of the vehicle data fields by vehicle type number of motorized 2 wheelers number of motorized 3 wheelers number of passenger cars station wagons etc up to 9 seats number of light goods vehicles number of heavy goods vehicles number of buses 10 or more seats including drivers seat and number of other motor vehicles is not equal to the total number of motor vehicles data field The sum of the vehicle data fields by vehicle type group number of passenger cars and light goods vehicles number of heavy goods vehicles and buses number of motorized 2 wheelers number of 3 wheelers and number of othe
62. ned through summing up Total Number of Injured Only Road Users years 1982 and 1983 and Total Number of Killed Road Users years 1982 and 1983 The value in Data2 is obtained through summing up Total Number of Injured Only Road Users years 1980 and 1981 and Total Number of Killed Road Users years 1980 and 1981 The column value is then calculated through the mathematical operation Subtract i e Data1 Data2 Note If any of the data in a multiple data selection query does not have a value in the database the total will not be shown to avoid misinterpretation of incomplete incorrect results 24 1 2 4 Report Page In every output page there is a Report button When the Report button is clicked the Report Page will be displayed as in the figure below In this view many options can be selected such as zooming printing etc Besides this the current result can also be exported saved to another file format or sent by e mail For this e mail sending option an e mail software that provides MAPI interface must be installed in your system APRAD Analysis Version Reference Values Gl 58 of 58 Total 58 First Page Previous Page Next Page Last Page Zoom Print Export Mail Fig 25 Example of a Report Page 1 2 5 Graph Page In every output page except the Country Report output there is a Graph button When the Graph button is pressed the Graph Page of that output will be displayed The user c
63. ng only in personal injury as reported Personal injuries are injuries sustained by persons involved in road traffic accidents as a direct consequence of those accidents Fatal accidents APRAD Data Definition Fatal accidents are those casualty accidents resulting in death within 30 days of the accident Definitions of fatality accidents vary however from country to country due to different reporting procedures For example fatal accidents are defined as deaths occurring at the site of the accident or within 7 days or within 30 days of the accident Note Please indicate the definition currently applied in the space provided for national data definitions 60 3 OTHER DEFINITIONS a Urban areas APRAD Data Definition Urban areas are those built up areas with due to population concentrations generally lower traffic speeds than overland roads and high pedestrian and non motorized traffic Definitions designations of urban areas tend to be different for most countries based for example on population concentrations specific road signs speed limits or administrative boundaries Note Please indicate the definition currently applied in the space provided for national data definitions b Unknown unspecified location APRAD Data Definition For accident data where no area inside or outside urban area of accident occurrence was reported recorded Unknown unspecified roads APRAD Data Definition For accide
64. nger cars aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 73 70 71 72 7 74 45 54 years 55 59 years 60 64 years and 65 years amp and unknown age is not equal to the killed occupants of passenger cars data field The sum of the fatalities data fields killed occupants of light goods vehicles aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown is not equal to the killed occupants of light goods vehicles data field The sum of the fatalities data fields killed occupants of heavy goods vehicles aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years and 65 years amp more and unknown is not equal to the killed occupants of heavy goods vehicles data field The sum of the fatalities data fields killed occupants of buses aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years 25 34 years 35 44 years 45 54 years 55 59 years 60 64 years 65 years amp more and unknown age is not equal to the killed occupants of buses data field The sum of the fatalities data fields killed occupants of other motor vehicles aged 0 5 years 6 9 years 10 14 years 15 17 years 18 20 years 21 24 years
65. nknown vehicles aged 21 24 years data field 81 153 154 155 156 157 158 159 160 161 162 The killed drivers of unknown vehicles aged 25 64 years data field is greater than the killed occupants of unknown vehicles aged 25 64 years data field The killed drivers of unknown vehicles aged 65 years amp more data field is greater than the killed occupants of unknown vehicles aged 65 years amp more data field The killed drivers of unknown vehicles of unknown age data field is greater than the killed occupants of unknown vehicles of unknown age data field DRIVER AND PEDESTRIAN FATALITIES BY AGE GROUP AND SEX The killed male pedestrians aged 0 5 years data field is greater than the killed pedestrians aged 0 5 years data field The killed male pedestrians aged 6 9 years data field is greater than the killed pedestrians aged 6 9 years data field The killed male pedestrians aged 10 14 years data field is greater than the killed pedestrians aged 10 4 years data field The killed male pedestrians aged 15 17 years data field is greater than the killed pedestrians aged 15 17 years data field The killed male pedestrians aged 18 20 years data field is greater than the killed pedestrians aged 18 20 years data field The killed male pedestrians aged 21 24 years data field is greater than the killed pedestrians aged 21 24 years data field The ki
66. nt data where no accident location was reported recorded d Daytime APRAD Data Definition Generally the time interval between sunrise and sunset The daytime defined for data recording purposes is the time interval 06 00 hours to 17 59 hours e Nighttime APRAD Data Definition Generally the time interval between sunset and sunrise The nighttime defined for data recording purposes is the time interval 18 00 hours to 05 59 hours f Unknown unspecified time APRAD Data Definition For accident data where no time of accident occurrence was reported recorded 61 9 Wet road APRAD Data Definition Roads with wet surface conditions at the time of accident h Dry road APRAD Data Definition Roads with dry surface conditions at the time of accident i Unknown unspecified road surface condition APRAD Data Definition For accident data where no surface condition wet or dry of accident occurrence was reported recorded 4 CASUALTIES a Casualties APRAD Data Definition Casualties are persons killed or injured in road traffic accidents where they are drivers or passengers of vehicles pedestrians or bystanders b Fatalities APRAD Data Definition Fatalities are person killed in road traffic accidents or injured resulting in death within 30 days of the accident where they are drivers or passengers of vehicles pedestrians or bystanders Note Data included in APRAD up to 1993 94 for fatalities by age g
67. nts of light goods vehicles aged 25 64 years data field The killed drivers of light goods vehicles aged 65 years amp more data field is greater than the killed occupants of light goods vehicles aged 65 years amp more data field The killed drivers of light goods vehicles of unknown age data field is greater than the killed occupants of light goods vehicles of unknown age data field 78 120 121 122 123 124 125 126 127 128 129 130 The killed drivers of heavy goods vehicles aged 0 5 years data field is greater than the killed occupants of heavy goods vehicles aged 0 5 years data field The killed drivers of heavy goods vehicles aged 6 9 years data field is greater than the killed occupants of heavy goods vehicles aged 6 9 years data field The killed drivers of heavy goods vehicles aged 10 14 years data field is greater than the killed occupants of heavy goods vehicles aged 10 14 years data field The killed drivers of heavy goods vehicles aged 15 17 years data field is greater than the killed occupants of heavy goods vehicles aged 15 17 years data field The killed drivers of heavy goods vehicles aged 18 20 years data field is greater than the killed occupants of heavy goods vehicles aged 18 20 years data field The killed drivers of heavy goods vehicles aged 21 24 years data field is greater than the killed occupants of heavy goods vehicles
68. on Regional Report Population TOTAL POPULATION 996134000 1010101989 1024582000 1039551999 1054911000 1070575000 1086551999 18260000 18581000 18301000 19221000 19549000 19888000 20239000 5039000 5144000 5237000 5318000 5390000 5456000 5516000 320000 330000 360000 390000 420000 Fig 19 Example of a Regional Report output gt Country Report Query Select a year range multiple data types within 1 data category and 1 countr The Country Report query and output may look like Figures 20 and 21 below APRAD Analysis Version Country Report n x Country Data Field Vehicles ha Hewes China NUMBER OF HEAVY GOODS VEHICLES TRUCKS GREATER THAN 1 TONNE MASSAWEIGHT Macau China NUMBER OF BUSES MORE THAN 8 SEATS NUMBER OF OTHER MOTORISED VEHICLES NUMBER OF PASSENGER CARS amp LIGHT GOODS VEHICLES OF HEAVY GOODS VEHICLES TRUCKS AND BUSES Brunei Darussalam Cambodia IV Select at data fields Select Year Begin End 1980 155 Fig 20 Example of a Country Report query 21 APRAD Analysis Version Country Report Gf x China Vehicles 1980 1981 1982 1983 TOTAL NUMBER OF MOTOR VEHICLES 3 803 400 4 436 800 5 061 699 5 677 300 661 NUMBER OF MOTORISED 2 WHEELERS NUMBER OF MOTORISED 3 WHEELERS 245 000 385 199 525 399 665 600 8t NUMBER OF PASSENGER CARS S
69. out prior notice h The APRAD Database contains data from various information providers be they the National APRAD Coordinating Agencies the United Nations or its affiliates or a number of other sources While making its best efforts in compiling and presenting the data and information contained in the Database the United Nations does not represent or endorse the accuracy or reliability of any information provided by any information provider any User or any other person or entity Reliance upon any 93 such information shall be at the User s own risk Neither the United Nations nor its affiliates nor any of their respective agents employees information or content providers shall be liable to any User or anyone else for any inaccuracy error omission interruption deletion defect alteration or use of any content herein or for its timeliness or completeness nor shall they be liable for any failure of performance or computer virus regardless of cause or for any damages resulting thereof i Under no circumstances shall the United Nations ESCAP be liable for any loss damage liability or expense incurred or suffered that is claimed to have resulted out of or in connection with the use or performance of the APRAD Software Database or Documentation including without limitation any fault error omission interruption or delay with respect thereto The use of the Products is at the User s sole risk Under no circums
70. r motor vehicles is not equal to the total number of motor vehicles The sum of the vehicle data fields number of passenger cars station wagons etc up to 9 seats and number of light goods vehicles is not equal to the total number of passenger cars and light goods vehicles data field 66 13 d 14 15 16 17 18 The sum of the vehicle data fields number of heavy goods vehicles and number of buses 10 or more seats including driver s seat is not equal to the total number of heavy goods vehicles and buses data field Vehicle kilometrage The sum of the kilometrage data fields by vehicle type kilometrage of motorized 2 wheelers kilometrage motorized 3 wheelers kilometrage of passenger cars station wagons etc up to 9 seats kilometrage of light goods vehicles kilometrage of heavy goods vehicles and kilometrage of buses 10 or more seats including driver s seat is not equal to the total kilometrage of all motor vehicles data field CASUALTY ACCIDENTS The sum of the casualty accident data fields total number injury only accidents and total number of fatal accidents is not equal to the total number of casualty accidents injury and death data field The sum of the casualty accident data fields by location number of casualty accidents inside urban areas number of casualty accidents outside urban areas and number of casualty accidents in unknown
71. roup and sex for the age groups 0 14 15 24 25 64 65 and more may include down factored casualties i e persons killed and injured by age group and sex Similarly data for the age groups 25 64 65 and more may actually comprise figures for the age groups 25 59 60 and more The definitions of fatality vary from country to country due to differences in reporting For example fatal accidents are defined as deaths occurring at the site of the accident or within 7 days or within 30 days of the accident Note 62 Please indicate the definition currently applied in the space provided for in the National Data Definitions Casualties by vehicle type road category APRAD Data Definition The definitions of vehicle type or road category are identical to those given before in Sections 1b and 1c Casualties are persons injured and or killed in that vehicle type or on that road category during the accident d Pedestrians APRAD Data Definition Pedestrians are persons walking standing on the road or footpath sidewalk at the time of accident They cannot be the drivers or occupants of motor vehicles nor the riders or drivers of bicycles see definition below or animal drawn vehicles e Bicycles APRAD Data Definition The definition of bicycle includes all two or three wheeled non motorized vehicles based on a cycle pedal for example bicycle tri cycle or cycle rickshaw pedicab etc 63 Annex lll CONSISTENCY C
72. tances including but not limited to negligence shall the United Nations or its affiliates be liable for any direct indirect incidental special or consequential damages however caused and regardless of the theory of liability even if the United Nations ESCAP has been advised of the possibility of such damages 3 DISCLAIMERS The designations employed and the presentation of the Material do not imply the expression of any opinion whatsoever on the part of United Nations ESCAP concerning the legal status of any country territory city or area or of its authorities or concerning the delimitation of its frontiers or boundaries The term country as used in the Products also refers as appropriate to territories or areas For lack of space the following abbreviations of names of countries or areas have been used in the Materials DPR Korea for Democratic People s Republic of Korea 94 Islamic Rep of Iran for Islamic Republic of Iran Lao PDR for Lao People s Democratic Republic Micronesia for Federated States of Micronesia Taiwan Prov of China for Taiwan Province of China The designations developed and developing regions are intended for statistical and analytical convenience and do not necessarily express a judgment about the stage reached by a particular country or area in the development process 95
73. ted please select the icon APRAD Input Version which should appear in the APRAD program group on your Programs Task Bar The APRAD Data Input program will start with the Login 2 2 1 Login The Login dialogue will be displayed every time you start the APRAD Program Please type in the correct password and press the OK button in order to use the program If an incorrect password is entered more than 3 times the program will be terminated If the Cancel button is pressed the program will also be terminated The default password is Authorized Agency which later can be changed by using the Change Password button APRAD Input Version Login Lx User Name Authorized amp gency T Password ees Fig 31 Login Dialogue For changing the password first the current password must be entered and then the Change Password button pressed The Change Password dialogue will then be shown as in Fig 32 below im APRAD Input Version Change Password Eg ex New password PW Confirm new password Fig 32 Change Password Dialogue 33 To change the password type in the new password in the New password text box retype it in the Confirmation new password text box and press the OK button If new password and its confirmation are identical the new password will be kept Otherwise an error message will be shown and both new password and its confirmation must be entered again 2 2 2 Opening Page T
74. the killed drivers of bicycles aged 25 64 years data field The killed male drivers of bicycles aged 65 years amp more data field is greater than the killed drivers of bicycles aged 65 years amp more data field The killed male drivers of bicycles of unknown age data field is greater than the killed drivers of bicycles of unknown age data field 83 174 175 176 177 178 179 180 181 182 183 184 The killed male drivers of 2 wheelers aged 0 5 years data field is greater than the killed drivers of 2 wheelers aged 0 5 years data field The killed male drivers of 2 wheelers aged 6 9 years data field is greater than the killed drivers of 2 wheelers aged 6 9 years data field The killed male drivers of 2 wheelers aged 10 14 years data field is greater than the killed drivers of 2 wheelers aged 10 14 years data field The killed male drivers of 2 wheelers aged 15 17 years data field is greater than the killed drivers of 2 wheelers aged 15 17 years data field The killed male drivers of 2 wheelers aged 18 20 years data field is greater than the killed drivers of 2 wheelers aged 18 20 years data field The killed male drivers of 2 wheelers aged 21 24 years data field is greater than the killed drivers of 2 wheelers aged 21 24 years data field The killed male drivers of 2 wheelers aged 25 64 years data field is greater than the
75. the country Provincial regional roads APRAD Data Definition Provincial regional roads are roads of generally lower design standards In non urban areas they link population centers within a province or region Other roads APRAD Data Definition All other roads not specified in above categories include mostly urban streets and minor roads Paved roads APRAD Data Definition Paved roads are those with a bituminous asphalt concrete or cement concrete pavement surface Unpaved roads APRAD Data Definition Unpaved roads include gravel topped or earth topped roads and all other surface types not included under above standard paved types Vehicles Motor Vehicles APRAD Data Definition All registered engine powered vehicles of various types 58 Motorized 2 wheelers APRAD Data Definition All registered engine powered two wheeled vehicles including either two stroke or four stroke engines Motorized 3 wheelers APRAD Data Definition All registered engine powered three wheeled vehicles e g Tuk Tuks Autos Motor Rickshaws Auto Tempos etc Passenger Cars Station Wagons etc up to 9 seats APRAD Data Definition All registered motorized four wheeled passenger vehicles having a seating capacity of nine persons or less including driver Light Goods Vehicles up to 3 5 tons maximum permissible weight APRAD Data Definition All registered motorized commercial or goods carrying vehicles
76. the user presses the Ok button and confirms the import function will process the selected import file APRAD Input Version Data Import Iof xi Please click button to select database to import Path China 1 998 2000 mdb Browse Country and Year to import Country China Year 1998 2000 Back Fig 36 Data Import dialogue with a selected import file sample 2 2 5 Data Key In Immediately after installation this function will not be available If the user tries to use this function without first importing the query file from ESCAP a warning dialogue will appear If the Data Key In button is pressed in the Start Menu the Data Key In dialogue will appear as in Fig 37 The pre selected country will be shown and if the input file comprises a year range a specific year can be selected to enter the data requested by ESCAP APRAD Input Version Data Key Mi EG m Please select country and year Please select country hina Please select year E Fig 37 Data Key In Dialogue After the Ok button is pressed the Data Key In Menu will be shown a Data Key In Menu Page In the Data Key In Menu see Fig 38 next page there are three main input categories as follows 1 General Data Population Road Network Vehicles Vehicle Kilometrage 2 Accidents Casualty Accidents 37 3 Casualties Casualties Fatalities by Age and Sex Fata
77. tinue with the Manual Browse and Run Setup Method further down To configure your system for Auto Play enabled please see your Microsoft Windows user manual a Auto Play Setup Method 1 After you insert the installation CD ROM the APRAD Analysis Version Setup Page should appear automatically as in Figure 1 see next page 2 Follow the instruction on screen You will be prompted to select the destination path and the name of the program group for the Analysis Version Analysis Version Setup E Welcome to the APRAD Analysis Version installation program Setup cannot install system files or update shared files if they are in use Before procee we recommend that you close any applications you may m Fig 1 APRAD Analysis Version Setup b Manual Browse and Run Setup Method 1 After you insert the installation CD ROM please click Start Menu on the Task Bar and select Run The dialogue will be shown as in the figure below Run RIES Type the name of a program folder document or Internet resource and Windows will open it for you Open Cancel Browse Fig 2 Run Dialogue 6 2 Please click on the Browse button The Browse dialogue will be shown as in Figure 3 Browse the installation CD ROM and then select Setup exe Browse 2 Lookin Anais Es File name s etup exe Files of type Programs Cancel 2 Fig 3 Browse Dialogue
78. uses aged 21 24 years data field is greater than the killed drivers of buses aged 21 24 years data field The killed male drivers of buses aged 25 64 years data field is greater than the killed drivers of buses aged 25 64 years data field The killed male drivers of buses aged 65 years amp more data field is greater than the killed drivers of buses aged 65 years amp more data field The killed male drivers of buses of unknown age data field is greater than the killed drivers of buses of unknown age data field The killed male drivers of other motor vehicles aged 0 5 years data field is greater than the killed drivers of other motor vehicles aged 0 5 years data field 88 229 230 231 232 233 234 235 236 23T 238 239 The killed male drivers of other motor vehicles aged 6 9 years data field is greater than the killed drivers of other motor vehicles aged 6 9 years data field The killed male drivers of other motor vehicles aged 10 14 years data field is greater than the killed drivers of other motor vehicles aged 10 14 years data field The killed male drivers of other motor vehicles aged 15 17 years data field is greater than the killed drivers of other motor vehicles aged 15 17 years data field The killed male drivers of other motor vehicles aged 18 20 years data field is greater than the killed drivers of other motor vehicles aged 18 20 ye
79. years data field The killed drivers of 3 wheelers aged 65 years amp more data field is greater than the killed occupants of 3 wheelers aged 65 years amp more data field The killed drivers of 3 wheelers of unknown age data field is greater than the killed occupants of 3 wheelers of unknown age data field The killed drivers of passenger cars aged 0 5 years data field is greater than the killed occupants of passenger cars aged 0 5 years data field The killed drivers of passenger cars aged 6 9 years data field is greater than the killed occupants of passenger cars aged 6 9 years data field The killed drivers of passenger cars aged 10 14 years data field is greater than the killed occupants of passenger cars aged 10 14 years data field The killed drivers of passenger cars aged 15 17 years data field is greater than the killed occupants of passenger cars aged 15 17 years data field The killed drivers of passenger cars aged 18 20 years data field is greater than the killed occupants of passenger cars aged 18 20 years data field The killed drivers of passenger cars aged 21 24 years data field is greater than the killed occupants of passenger cars aged 21 24 years data field The killed drivers of passenger cars aged 25 64 years data field is greater than the killed occupants of passenger cars aged 25 64 years data field 109 110 111 112 113 114

APRAD User Manual ,Vers. 1.1, May 2002

Contents

Download Pdf Manuals

Related Search

Related Contents