Antoine Riche

Antoine came across OSM in 2014 and this changed his life. In just a few weeks he turned from a GIS developer to an OpenStreetMap consultant, and founded Carto’Cité. Antoine works with SNCF since 2016, and conducted the detailed mapping of 436 railway stations with a team of 6 mappers.

Antoine is a member of OSM France and organised several voluntary projects in Nantes where he lives.

Carto’Cité is a funding member of the french Fédération des professionnels OpenStreetMap (FPOSM).


OpenStreetMap username:

naomap


Session

08-28
16:45
20min
How Carto’Cité maintains OSM data for 436 train stations efficiently using PostGIS and QGIS
Antoine Riche

SNCF Transilien has mapped with great details 436 train stations in the Greater Paris area. This work was conducted in several stages, between 2018 and 2022. An application using this data helps travelers to find their way inside and around railway stations. The app displays multi-level floor plans, enables users to find equipments and services, and provides indoor/outdoor routing with an option to use elevators rather than stairways.

Ensuring these services function properly requires to maintain the data. This means both updating it when a station or its neighbourhood has changed, and preserving the high quality of the data. The latter is achieved by checking changes to the data inside and around railway stations. This moderation work is achieved through an innovative process that enables us to :
- compare the data for each station between 2 dates freely defined
- detect and classify changes that need to be checked
- apply a whitelist to avoid checking one's own changes
- review those changes and produce a report

We set up a project that is based on PostGIS and QGIS, makes use of osmium and osm2pgsql, and requires a small amount of SQL code to detect changes. This project enables us to efficiently moderate the data changes that can impact the SNCF app.

This talk will present our methodology, which can be replicated and adapted to all sorts of OSM data, along with a few helpful tricks.

Data Analysis & Data Model
Talks III - Amphi Cauchy (Carnot)