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

Posts in PostGIS

Newest to oldest.

Pre-conference Session Materials: GIS Data, Queries, and Performance

Published November 12, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS, Performance

See you at PASS Data Community Summit!

Published October 15, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS, pgrx

Geocode Addresses with PostGIS and Tiger/LINE

Published October 10, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS

Setup Geocoder with PostGIS and Tiger/LINE

Published October 08, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS

Load the Right Amount of OpenStreetMap Data

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

Getting started with MobilityDB

Published August 15, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS, MobilityDB, pgRouting

Postgres 15: Explain Buffer now with Temp Timings

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

Using v4 of the Postgres H3 extension

Published May 22, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS, H3

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

Accuracy of Geometry data in PostGIS

Published April 15, 2023, Ryan Lambert
Categories: PostgreSQL, PostGIS

Postgres is Relational Plus

Published February 03, 2023, Ryan Lambert
Categories: PostgreSQL, #PGSQLPhriday, PostGIS

Relational and Non-relational Data: PGSQL Phriday #005

Published January 23, 2023, Ryan Lambert
Categories: PostgreSQL, #PGSQLPhriday, PostGIS

Postgres and Software Development: PGSQL Phriday #004

Published January 06, 2023, Ryan Lambert
Categories: PostgreSQL, #PGSQLPhriday, PostGIS

Stubbing toes with <code>auto_explain</code>

Published December 20, 2022, Ryan Lambert
Categories: PostgreSQL, Performance, PostGIS

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

Book Release! Mastering PostGIS and OpenStreetMap

Published October 01, 2022, Ryan Lambert
Categories: PostgreSQL, PostGIS, Performance, pgRouting

H3 indexes for performance with PostGIS data

Published June 24, 2022, Ryan Lambert
Categories: PostgreSQL, PostGIS, Performance, H3

Using Uber's H3 hex grid in PostGIS

Published April 24, 2022, Ryan Lambert
Categories: PostgreSQL, PostGIS, H3

Permissions required for PostGIS

Published December 01, 2021, Ryan Lambert
Categories: PostgreSQL, PostGIS, Security

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

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

PostGIS Trajectory: Space plus Time

Published November 29, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, GIS, QGIS, pgRouting

Find your local SRID in PostGIS

Published November 04, 2020, Ryan Lambert
Categories: PostgreSQL, PostGIS, GIS

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

PostgreSQL at RustProof Labs: 2019 in Review

Published December 28, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS

Upgrading to Postgres 12 and PostGIS 3

Published December 15, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS

Postgres 12 Generated Columns and PostGIS

Published December 12, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS

PostgreSQL 12 and PostGIS 3 Initial Review

Published November 13, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS, Performance

Scaling osm2pgsql: Process and costs

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

Create vector layers using PostGIS and QGIS

Published August 04, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS, QGIS

Installing PostgreSQL and PostGIS from source

Published July 11, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS, Raspberry Pi

Geometry viewer added to DBeaver

Published June 13, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS

Fixed: XML data and pg_dump

Published May 02, 2019, Ryan Lambert
Categories: PostgreSQL, PostGIS

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

PostGIS: Tame your spatial data (Part 2)

Published December 01, 2018, Ryan Lambert
Categories: Performance, PostGIS, PostgreSQL

Geometry viewer added to pgAdmin 4

Published September 13, 2018, Ryan Lambert
Categories: PostgreSQL, PostGIS

PostGIS: Tame your spatial data (Part 1)

Published July 06, 2018, Ryan Lambert
Categories: PostgreSQL, Performance, PostGIS

GIS - It's All About the Data

Published April 11, 2015, Ryan Lambert
Categories: GIS, PostGIS

Colorado Unemployment: Making the Maps

Published January 18, 2015, Ryan Lambert
Categories: PostGIS, GIS