12-02, 14:00–18:00 (America/Belem), Room Açaí (C Block)
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 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
- Rasters analytics
- Vector Tiles
There will also be an emphasis on exposing PostGIS data and functions to the web, to this end, there will be some usage of other software products (for example: Martin Vector tile server or pg_featureserv or pg_tileserv or PostgREST). Consideration will also be given to the ecosystem around PostGIS (For example: ogr_fdw)
Rhys is a cofounder and spatial data architect of Auchindown, a small company in Jamaica that deals in all things spatial.
Rhys has over 15 years of experience analyzing, identifying and transforming spatial data into useful information and business insights helping companies to leverage data to make informed decisions. He has been using Postgresql/PostGIS since versions 8.0/pre 1.
He has a keen interest in using PostGIS in the electric utility space and is the developer behind https://lvwr.io which is a power delivery modeling and management cloud solution that is built on the PRAM Stack.