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

Posts in PgOSM-Flex

Newest to oldest.

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

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

Postgres Data Dictionary for everyone

Published January 04, 2022, Ryan Lambert
Categories: PostgreSQL, Data Dictionary, 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