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.

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)
Vincent Picavet (1)

(1) Oslandia, France

Level

3 - Medium. Advanced knowledge is recommended.

Requirements for the Attendees

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

Having access to a postgis cluster would be a plus.

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: