Q-MOKA: A QGIS-Based Application for Managing and Analyzing Traffic Accidents
2024-07-04 , GEOCAT (301)

The presentation will discuss Q-MOKA, a GIS application developed in collaboration with the Hellenic Ministry of Infrastructure and Transportation to manage and analyze traffic accidents along the Greek Primary and Transeuropean Road Network. Q-MOKA addresses the challenges of the existing Traffic Accident Registry, which lacked geospatial referencing and robust data validation. Built around QGIS and Postgres/PostGIS, Q-MOKA offers several key functionalities:

• Network Model: Supports multiple linear referencing systems for accurate accident location representation.

• Dual-Carriageway Management: Ensures consistent linear referencing even during network realignments.

• Flexible Accident Location: Records accidents by X,Y coordinates or route/offset, maintaining synchronization between the two methods.

• Linear and Point Data Management: Allows creation and editing of additional linear and point event data relevant to the Agency (e.g., number of lanes, speed limits).

• Geographic Mapping: Provides route-level accident mapping based on the recording service.

• Custom QGIS Forms: Facilitates data entry and management through user-friendly forms.

The presentation will delve into the technical aspects of Q-MOKA, including its database structure, configuration options, and potential future enhancements. By offering a robust and user-friendly platform for traffic accident management and analysis, Q-MOKA contributes to improved road safety and informed decision-making in Greece.

Keywords: Traffic accident, GIS, QGIS, PostgreSQL, PostGIS, linear referencing

See also: The presentation of our talk about the application Q-MOKA (6.0 MB)

I'm a graduate of the School of Spatial Planning and Development, of the Faculty of Engineering, of Aristotle University of Thessaloniki. I hold a Master's Degree in Spatial Planning and Regional Development.

My decision to chose Engineering as a professional career, was highly influenced by my father who himself was a Surveying Engineer. After the completion of my studies, I teamed up with several companies which specialized in the Cadastre Sector. Through these experiences I managed to upgrade my skills in the process of land registration, Photogrammetry and land surveying with GNSS technology and unmanned aircraft systems (UAV).

I joined the family of Consortis in 2020. The company gave me the chance to extensively work on the Geospatial and GIS sector.

Born and raised in Thessaloniki. Graduated from the Department of Topography and Geoinformatics Engineering of International Hellenic University and now a postgraduate student in Applied Informatics of University Of Macedonia.
In February 2020 I started my internship at Consortis Geospatial in the Geoinformatics department, where I remain as an employee after its completion until today. Since my internship and my collaboration with the department, I have expanded my knowledge in GIS and Photogrammetry, as well as an intermediate level of knowledge in Databases, Web and Software Developing. I have also worked with Civil and Surveying Engineering firms in the construction sector on public and private projects.