Stathis Petridis
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.
Sessions
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