Webinar: Exploring OpenStreetMap from PostGIS: Tools and Queries (3/6)

Below is the recording of my Exploring OpenStreetMap from PostGIS: Tools and Queries webinar from January 28, 2020. This is the third in a series of six covering how I work with PostGIS and OpenStreetMap.

I had a great time presenting this session, I hope having this recording available is helpful. Below the video is a list the links showing throughout the slides.

Recording

Series complete

This webinar series is completed. See the intro page for the schedule and links to other videos in the series.

Downloads

The SQL script used for the demo:

• Demo Code (SQL)

Note: Queries in the above SQL code expect Colorado's OpenStreetMap data is loaded. See the previous session for that process overview.

Links

Links from the slides in the order they appeared.

• https://dbeaver.io/
• https://www.qgis.org/
• https://blog.rustprooflabs.com/2018/01/db-anti-pattern
• https://www.red-gate.com/simple-talk/sql/database-administration/ten-common-database-design-mistakes/
• https://www.sqlstyle.guide/#naming-conventions
• https://github.com/rustprooflabs/pgosm

Summary

Need help with your PostgreSQL servers or databases? Want a speaker on the technologies and data I am excited about? Contact us to start the conversation!