Going beyond all the common functions that most folks use PostGIS for. Delving into advanced use cases and using PostGIS in production workloads.
PostGIS, sitting on top of Postgresql, is by most metrics, the most popular spatial database. Many videos are online about how to install and use PostGIS....many are from prior FOSS4G conferences and do a good job in getting you to understand the basics. Most of them, however, only scratch the surface when it comes to the power that can be wielded with PostGIS. This workshop seeks to explore a wide array of functions that may not be used on a regular basis or are outside the scope of common spatial queries. These include, but are not limited to: - Linear Referencing - Clustering - Using rasters - Vector Tiles There will also be an emphasis on using PostGIS in production, so there will be some usage of other software products (for example: Martin Vector tile server or pg_featureserv or pg_tileserv ). Consideration will also be given to the ecosystem around PostGIS (For example: ogr_fdw) **Book your ticket here:** https://ti.to/osgeo-oceania/foss4g-sotm-oceania-2023-workshops. *A total of 25 spaces are available.*
Speakers: Rhys Stewart