RustProof Labs: blogging for education (logo)

Webinar: PostGIS Queries and Performance (4/6)

By Ryan Lambert -- Published February 16, 2020

Below is the recording of my PostGIS Spatial Queries and Performance Tuning webinar from February 11, 2020. This is the fouth 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

Continue Reading

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

By Ryan Lambert -- Published February 09, 2020

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

Continue Reading

Webinar: Load PostGIS with osm2pgsql (2/6)

By Ryan Lambert -- Published January 27, 2020

Below is the recording of my Load PostGIS with osm2pgsql webinar from January 14, 2020. This is the second 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

Continue Reading

Webinar: Intro to PostGIS and OpenStreetMap (1/6)

By Ryan Lambert -- Published January 09, 2020

Below is the recording of my Getting Started with PostGIS and OpenStreetMap webinar from December 11, 2019. This is the first 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

Continue Reading

Updated for 2020: Load OpenStreetMap data to PostGIS

By Ryan Lambert -- Published January 04, 2020

I originally wrote about how to load OpenStreetMap data into PostGIS just under one year ago. Between then and now, 364 days, a number of major changes have occurred in the form of new versions of all the software involved. Due to the combination of changes I decided to write an updated version of the post. After all, I was no longer able to copy/paste my own post as part of my procedures!

The goal of this post is to cover the typical machine and configuration I use to load OpenStreetMap data into PostGIS with the latest versions. The first part of the post covers the how of setting up and loading OpenStreetMap data to PostGIS. The second portion explains a bit of the reasoning of why I do things this way. The latest versions of the software at this time are:

  • PostgreSQL 12
  • PostGIS 3
  • osm2pgsql 1.2

This post is part of the series PostgreSQL: From Idea to Database.

Changes to software

PostgreSQL 12, PostGIS 3, and osm2pgsql 1.2 are all new releases since the original post. The original used Postgres 11, PostGIS 2.5 and osm2pgsql 0.94. If you just look at the version numbers they may look like small increases, but the whole package is chock-full of improvements!

If you can upgrade to the latest and greatest, I recommend you do so!

Continue Reading

<-- Older Posts          Newer Posts -->