Let's version some data
2021-09-27, 14:00–18:00, Isabel Allende

Sometimes data is not enough, and we need metadata : we want to know how and by whom it has been produced, altered, updated.

We also want to track history of the data, be able to go back in time, and even sometimes deal with different versions of the same data.

There are numerous technical solutions to cover these needs. We will present some opensource solutions and the associated ecosystem : PostgreSQL mechanisms (triggers), qgis-versioning, pg-version, fastversion and others.

We will put this into practice by:

  • reviewing uses cases and the solutions most adapted to each of them, from simple timestamps to full-fledged history maintenance
  • testing basic usage of these tools
  • use some of these tools (for instance qgis-versioning) to try to work collaboratively on a map.

Don't forget to register before we run out of tickets!


Sometimes data is not enough, and we need metadata : we want to know how and by whom it has been produced, altered, updated.

We also want to track history of the data, be able to go back in time, and even sometimes deal with different versions of the same data.

There are numerous technical solutions to cover these needs. We will present some opensource solutions and the associated ecosystem : PostgreSQL mechanisms (triggers), qgis-versioning, pg-version, fastversion and others.

We will put this into practice by:

  • reviewing uses cases and the solutions most adapted to each of them, from simple timestamps to full-fledged history maintenance
  • testing basic usage of these tools
  • use some of these tools (for instance qgis-versioning) to try to work collaboratively on a map.

Authors and Affiliations

Augustin Trancart (1)
Julien Cabiécès (1)

(1) Oslandia, France

Level

3 - Medium. Advanced knowledge is recommended.

Requirements for the Attendees

A computer with the latest release of qgis. A recent postgis database. An internet connection.

A virtualbox VM suitable for the workshop can be downloaded at https://share.oslandia.net/public/9a2ceb

Engineer at Oslandia since 2016 and historically a full-stack developer, my main area of interest are:

  • 3D Gis application in the browser (webgl)
  • And everything you can do with PostgreSQL and PostGIS.
This speaker also appears in: