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.

In this workshop, we build a full cartographic application from scratch, putting pg_tileserv and pg_featureserv into action. Our front-end GUI will be based on OpenLayers and we will see how to code a web cartographic app step by step :

• data integration into PostGIS
• Setting up pg_tileserv
• A web cartographic app with OpenLayers
• Advanced usage of pg_tileserv
• Enriching the application with OpenLayers
• Leveraging pg_featureserv
• Enjoy the result !

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.