Spatial SQL, the Modern Data Stack, and PostGIS

Matt Forrest from Carto brings us 'Spatial SQL, the Modern Data Stack, and PostGIS'.
SQL, and in turn spatial SQL, is fast becoming the leading language for analytics. More tools are adopting it from data warehouses, to DuckDB, to dbt, and beyond. I believe that PostGIS is and will be the central tool to any modern GIS infrastructure. In this talk we will show practical and ready to implement examples of how using PostGIS with emerging tools can help you get the most out of spatial SQL.
Slides:
docs.google.com/presentation/...

[@pythonGIS]

Fantastic video! Thanks Matt!

[@jerrittcollord]

In the DuckDB FTS example, the note that results may not have the words "flash" or "flood" is misleading... it looks like the index was built on EPISODE_NARRATIVE but EVENT_NARRATIVE was retrieved and indeed may not contain "flash" or "flood".

[@JamesDavidSmith]

How do we install the H3 extensions for PostGIS?