Augustin Trancart

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.


Building a cartographic web application with pg_tileserv and pg_featureserv
Augustin Trancart, Vincent Picavet

There are some new GIS kids on the block : pg_tileserv and pg_featureserv are GO components allowing you to serve GIS data to build cartographic web applications.

Pg_tileserv let you take any data stored in PostGIS, and easily stream vector tiles to the web.

Pg_featureserv also takes your data from PostGIS. It implements the latest OGC API for Features ( OGC APIF ) standards and make it simple to provide a interoperable API for your front-end application.

These components take full advantage of the underlying PostgreSQL/PostGIS database to provide efficient features with a very simple mechanism.

Easy to set-up, easy to use and powerful, they are now part of the de-facto stack for GIS web developers.

We present these components and showcase an example to demonstrate their simplicity and efficiency.

Versioning in 2021: when and how you should do it
Augustin Trancart, Vincent Picavet

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 speak about different possible use-cases for data versioning and which technical solution is the most adapted, from simple data timestamp to full-fledged history needs.

The talk will be illustrated with some real-world cases.

Buenos Aires