--- title: PostGIS Day 2022 description: Join us November 17th for PostGIS Day. Call for Papers open through Oct 7th. image: https://info.crunchydata.com/hubfs/PostGIS%20Day_PostGISDay.png --- # **![banner_LinkedIn](https://info.crunchydata.com/hs-fs/hubfs/banner_LinkedIn.png?width=748&name=banner_LinkedIn.png)** # **PostGIS Day 2022** # Event Summary A [short summary](https://blog.crunchydata.com/blog/postgis-day-2021?hsLang=en) of the 2022 event is published on the Crunchy Data Blog. # Presentations & Links to Videos   | [Full playlist](https://youtube.com/playlist?list=PLesw5jpZchudJTmRukWO1eP5-6zPpIm5x)   | | --- | | [How to Prepare a Graph for pgRouting](https://youtu.be/aiZ5OtB8vS0) [Vicky Vergara, GeoRepublic](https://youtu.be/aiZ5OtB8vS0) | | [GiST Index Building in PostgreSQL 15](https://youtu.be/TG28lRoailE) [Aliaksandr Kalenik, Kontur](https://www.youtube.com/watch?v=TG28lRoailE&list=PLesw5jpZchudJTmRukWO1eP5-6zPpIm5x&index=3) | | [Property Data Management with PostGIS, PostgreSQL, QGIS and QField](https://youtu.be/8KCV09z3fA4) [Victor Idakwo, De-Vicks Geospatial](https://youtu.be/8KCV09z3fA4) | | [PostGIS for Conservation Planning and Supply Chain Impact Analysis: Case Studies from Marxan Cloud and LandGriffon](https://youtu.be/Va7Jpca7YTs) [Alicia Arenzana, Alex Larrañaga, Elena Palao, and Andrea Rota from Vizzuality](https://youtu.be/Va7Jpca7YTs) | | [Simple and Fast OGC API Servers for PostGIS with TiFeatures and TiMVT](https://youtu.be/kE4NqLiCOUg) [Vincent Sarago, DevelopmentSeed](https://youtu.be/kE4NqLiCOUg) | | [Building an Asset Inventory Database Using PostGIS: The Case of Giswater](https://youtu.be/0RafCtvkV1U) [Xavier Torret, BGEO OPEN GIS](https://youtu.be/0RafCtvkV1U) | | [Kart: A Practical Tool for Versioning Geospatial Data](https://youtu.be/_7ETwmMlUtY) [Robert Coup, Koordinates](https://youtu.be/_7ETwmMlUtY) | | [Build Beautiful Isochrone Maps Using PostGIS and QGIS](https://youtu.be/DA8pMg8cYNE) [Samweli Mwakisambwe](https://youtu.be/DA8pMg8cYNE) | | [Building a Telecommunications Design System with QGIS and PostGIS](https://youtu.be/7ocRcV_ErTI) [Justin Chang, MOBIA Technology Innovations](https://youtu.be/7ocRcV_ErTI) | | [PostGIS and QGIS in an Enterprise Environment: A Telecom Design Case Study](https://youtu.be/huhUhf1kcEY) [Cliff Patterson, Luna Geospatial & Dane Wilson, DFX Technical Services](https://youtu.be/huhUhf1kcEY) | | [Managing and Joining Multiple Geospatial Layers](https://youtu.be/oDCg4rLs8YQ) [Chris Wade, National Flood Insurance Program](https://youtu.be/oDCg4rLs8YQ) | | [Once upon a database... Telling stories with PostGIS and QGIS](https://youtu.be/nCNobf7kyLg) [Bonny Mcclain](https://youtu.be/nCNobf7kyLg) | | [A Tour of the PostGIS Extended Family of Extensions](https://youtu.be/Hx17Ia7wn6Y) [Regina Obe, Paragon Corporation ](https://youtu.be/Hx17Ia7wn6Y) | | [Speedrunning the Open Street Map osm2pgsql Loader](https://youtu.be/BCMnu7xay2Y) [Greg Smith, Crunchy Data ](https://youtu.be/BCMnu7xay2Y) | | [Serving STAC Metadata with PostgreSQL using PgSTAC](https://youtu.be/3NYpcgwTQfg) [David Bitner, Development Seed](https://youtu.be/3NYpcgwTQfg) | | [Route the Interesting Things (Not Just Roads!) with OpenStreetMap](https://youtu.be/uydAoMaReos) [Ryan Lambert, RustProof Labs](https://youtu.be/uydAoMaReos) | | [How the USDA is Putting PostGIS to Work in the Dynamic Soils Hub](https://youtu.be/26cNVbHwEUE) [Jason Nemecek, USDA](https://youtu.be/26cNVbHwEUE)   | | [Skating to Where The Puck Is Going To Be: Why SQL is the Future of Full-Stack Analytics](https://youtu.be/5Zg8j9X2f-Y) [Brian Timoney, The Timoney Group](https://youtu.be/5Zg8j9X2f-Y) | | [Triangles, Hulls, and Coverages: New and Planned Functions for Processing Polygons in PostGIS](https://youtu.be/hpWqhqZSYAI) [Martin Davis, Crunchy Data](https://youtu.be/hpWqhqZSYAI) | | [From ETL to ELT: Transforming Geospatial Data Processing with PostGIS and dbt](https://youtu.be/QBJY0jdnou0) [Zachary Deziel, Anagraph](https://youtu.be/QBJY0jdnou0) | | [Making Production Vector Tiles Simple with db2vector](https://youtu.be/wR6a_JzukiE) [Brendan Farrell, Clockwork Micro](https://youtu.be/wR6a_JzukiE) | | [Building Dynamic Data Flows with Koop and PostGIS](https://youtu.be/2FDlanzNvlI) [Dan O'Neill](https://youtu.be/2FDlanzNvlI) | | [Web Sockets and Real-Time Updates for Postgres with pg\_eventserv](https://youtu.be/Z_nOzHmpY8M) [Paul Ramsey, Crunchy Data](https://youtu.be/Z_nOzHmpY8M) |   ## What is PostGIS Day? PostGIS Day is part of [Geography Awareness Week](https://www.nationalgeographic.org/education/programs/geography-awareness-week/) and serves to highlight the features and uses of the PostGIS spatial database as a part of the GIS ecosystem. PostGIS Day is observed the day after [GIS Day](https://www.gisday.com/), for obvious reasons. Spatial data is everywhere these days, and PostGIS is frequently used to manage that data. Logistics, precision agriculture, insurance, risk analysis and many more industries can or are working with spatial data. PostGIS Day is a chance to learn how others are making use of PostGIS, pick up some tips and tricks, and share our stories about bringing this excellent tool into your organizations.   ## **Need More PostGIS now?** [Crunchy Data PostGIS Blogs](https://www.crunchydata.com/blog/topic/spatial) [PostGIS Day Videos 2021](https://www.youtube.com/playlist?list=PLesw5jpZchudjKjwvFks-gAbz9ZZzysFm)  [PostGIS Day Videos 2020](https://www.youtube.com/playlist?list=PLesw5jpZchufVkPcwGYpiiijThFcPNlz_) [PostGIS Day Videos 2019](https://www.youtube.com/playlist?list=PLesw5jpZchudjfkx3vggVmJAOSBH7m4nj) [mailto:info@crunchydata.com](mailto:info@crunchydata.com)