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

Posts in OpenStreetMap

Newest to oldest.

Can you use ltree for Nested Place Data?

Published February 29, 2024, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap

Load the Right Amount of OpenStreetMap Data

Published August 24, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS, OpenStreetMap, PgOSM-Flex

Postgres 15: Explain Buffer now with Temp Timings

Published June 24, 2023, Ryan Lambert
Categories: PostgreSQL, Performance, PostGIS, OpenStreetMap, PgOSM-Flex

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, pgRouting, Video

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