{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"PostGIS","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/6e65a3c7\"></iframe>","width":"100%","height":180,"duration":3191,"description":"Nik and Michael are joined by Regina Obe and Paul Ramsey to discuss PostGIS.\n \nHere are some links to things they mentioned:\nRegina Obe https://postgres.fm/people/regina-obe\nPaul Ramsey https://postgres.fm/people/paul-ramsey\nPostGIS https://postgis.net\nMobilityDB https://github.com/MobilityDB/MobilityDB\npgRouting https://github.com/pgRouting/pgrouting\nGoogle BigQuery GIS public alpha blog post https://cloud.google.com/blog/products/data-analytics/whats-happening-bigquery-integrated-machine-learning-maps-and-more\nPostGIS Day 2025 talk recordings https://www.youtube.com/watch?v=wuNO_cW2g-0&list=PLavJpcg8cl1EkQWoCbczsOjFTe-SHg_8m\npg_lake https://github.com/Snowflake-Labs/pg_lake\nGeoParquet https://geoparquet.org\nST_DWithin https://postgis.net/docs/ST_DWithin.html\nPostgres JSONB Columns and TOAST: A Performance Guide https://www.snowflake.com/en/engineering-blog/postgres-jsonb-columns-and-toast\nFOSS4G https://foss4g.org\nOpenStreetMap https://www.openstreetmap.org\nPgDay Boston https://2026.pgdayboston.org\nSKILL.md file https://github.com/postgis/postgis/blob/68dde711039986b47eb62feda45bb24b13b0ea37/doc/SKILL.md\nProduction query plans without production data (blog post by Radim Marek) https://boringsql.com/posts/portable-stats\nPostgreSQL: Up and Running, 4th Edition (by Regina Obe, Leo Hsu) https://www.oreilly.com/library/view/postgresql-up-and/9798341660885\n\n~~~\nWhat did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!\n\n~~~\nPostgres FM is produced by:\nMichael Christofides, founder of pgMustard\nNikolay Samokhvalov, founder of Postgres.ai\n\nWith credit to:\nJessie Draws for the elephant artwork","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}