Road accidents in the state of Tamil Nadu (TN) have seen a 25 percent reduction in fatalities from 13.39 for every 10,000 vehicles in 2006 to 10.09 in 2010. All thanks to a DBMS called Tamil Nadu Road Accident Data Management System (TNRADMS).
This analysis engine which can create accident reports at the snap of a finger has replaced the cumbersome paper-based reports and inaccurate data-metrics which were only used for reporting in assembly/parliament queries.
The objective was to digitise accident records with easy-to-use software and reduce road accidents. The plan is a part of a project undertaking by the state called Tamil Nadu Road Sector Project (TNRSP).
The TN government approved a comprehensive Road Safety Action Plan put forth by TNRSP and developed the Road Accident Data Management System (RADMS) in 2009. This was developed at a cost of Rs. 2.20 Crores (about $500,000) with funding from World Bank and software support from Kerala-based IBS Software Services.
RADMS has been deployed in 1400 police stations across Tamil Nadu and personnel at each station have been trained in its use. Kumar, Deputy Project Director - TNRSP, said, "The system links three departments Police, Transport and Highways who update accident details as and when they happen."
The system provides reports that give information to analyse the cause of the accident, and helps police officials take preventive measures.
What does each police station need to access the web-based RADMS? A basic computer with a regular internet connection. In absence of internet connectivity, a RADMS Lite software installation is available for capturing records.
The data entered is integrated into a server, which uses PostGreSQL 8.2 running in Proliant ML150 G3 Server, Quad-core Intel Xeon Processor, 4GB RAM and 120GB storage disk, on a daily/weekly basis. Also, the digital maps on the system are based on Geographic Information Systems (GIS).
Explaining the procedure of recording accident details, Kumar added, "Whenever an accident occurs the data has to be uploaded to the system within 24 hours to the respective Police Station. The policeman on duty has to simultaneously file the First Information Report (FIR) and add details to a web-based Accident Record Form (ARF) on the bilingual (English and Tamil) RADMS."
IBS Software Services was roped in by the TN government to create a powerful data management system. In collaboration with VIC Roads Australia, IBS created the TNRADMS. Rajeev P, Project Manager-IBS said, "The system provides various reports that give information to analyse the cause of the accident and helps them (police officials) take various preventive measures. Implementing these preventive measures systematically helps reduce accidents at various places and thereby reduce the overall ratio."
Inspiring the Country
According to a recent report, the success of TNRADMS has inspired the Union road transport and highways ministry of India to implement a similar system in the rest of the country. The ministry is in the process of customising the software to their specific needs.