RustProof Labs: blogging for education (logo)
My book Mastering PostGIS and OpenStreetMap is available!

Posts in OpenStreetMap

Newest to oldest.

Track performance differences with pg_stat_statements

Published May 06, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex, #PGSQLPhriday, Performance

PgOSM Flex for Production OpenStreetMap data

Published April 21, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Route the Interesting things (Not just roads) with OpenStreetMap

Published November 16, 2022, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap

Routing with Lines through Polygons

Published October 23, 2022, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex, pgRouting

Better OpenStreetMap data using PgOSM Flex 0.6.0

Published October 04, 2022, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Find missing crossings in OpenStreetMap with PostGIS

Published November 07, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

(Webinar) Routing with PostGIS and OpenStreetMap

Published October 04, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex, Video

Identify OpenStreetMap changes with Postgres

Published August 30, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Timescale, Compression and OpenStreetMap Tags

Published August 20, 2021, Ryan Lambert
Categories: PostgreSQL, OpenStreetMap, PgOSM-Flex, Timescale

OpenStreetMap to PostGIS is getting lighter

Published May 01, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

(Webinar) OpenStreetMap to PostGIS: Easier and Better!

Published March 31, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex, Video

Round Two: Partitioning OpenStreetMap

Published February 26, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

First Review of Partitioning OpenStreetMap

Published February 21, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Partition OpenStreetMap data in PostGIS

Published February 16, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Why Partition OpenStreetMap data?

Published February 14, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Better OpenStreetMap places in PostGIS

Published January 23, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Improved OpenStreetMap data structure in PostGIS

Published January 03, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Hands on with osm2pgsql's new Flex output

Published December 10, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Postgres 13 Performance with OpenStreetMap data

Published October 19, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap

Pi 4 Performance: PostgreSQL and PostGIS

Published March 14, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, Raspberry Pi

Webinar: PostGIS Advanced Features (6/6)

Published February 29, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, Video

Webinar: Postgres 12 and PostGIS 3 (5/6)

Published February 26, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, Video

Webinar: PostGIS Queries and Performance (4/6)

Published February 16, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, Video

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

Published February 09, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, Video

Webinar: Load PostGIS with osm2pgsql (2/6)

Published January 27, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, Video

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

Published January 09, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, Video

Updated for 2020: Load OpenStreetMap data to PostGIS

Published January 04, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap

Scaling osm2pgsql: Process and costs

Published October 15, 2019, Ryan Lambert
Categories: PostgreSQL, OpenStreetMap, PostGIS, Performance

Low Power Computing with Raspberry Pi

Published February 25, 2019, Ryan Lambert
Categories: Raspberry Pi, PostgreSQL, PostGIS, OpenStreetMap

PgOSM transformations explained

Published February 21, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap

osm2pgsql on a Raspberry Pi

Published January 29, 2019, Ryan Lambert
Categories: PostgreSQL, OpenStreetMap, PostGIS, Raspberry Pi

PgOSM: Transform OpenStreetMap data in PostGIS

Published January 25, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap

Load OpenStreetMap data to PostGIS

Published January 06, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap

Small Community, Big Changes -- The Impact of a Mapping Party

Published April 16, 2016, Ryan Lambert
Categories: OpenStreetMap

Introduction to the Go Map!! App

Published March 04, 2016, Ryan Lambert
Categories: OpenStreetMap

Contributing to OpenStreetMap is "Maptastic!"

Published November 17, 2015, Ryan Lambert
Categories: GIS, OpenStreetMap