Mastering PostGIS and OpenStreetMap

The ultimate guide to help learn and master spatial data wrangling with PostGIS, PostgreSQL and OpenStreetMap.

Inside the Book Buy Author Blog

Inside the Book

You will learn

  • Quering with spatial SQL
  • How to load, clean and use OpenStreetMap data
  • PostGIS and PostgreSQL tips and tricks
  • pgRouting
  • Performance considerations

Real data

Many learning tools use prepared, sanitized, and unrealistic data sets for teaching. Unfortunately, that approach glosses over the reality of working with real-world data: it's messy!

This book uses real data along with all its messy quality issues on purpose.


The book includes the data to download that matches examples in the book. Data used is a real OpenStreetMap extract from August 16, 2020 covering the State of Colorado.

Code examples throughout the book are included as full SQL scripts as easy downloads! This makes it easy to follow along and learn with the book.

While you wait

The book is in the final steps before publishing. It should be available later in 2021! Add your email address below to be notified when it is released.

Head over to our blog and read more than two dozen posts covering how I use PostGIS, Postgres and OpenStreetMap .


Enter your email address to join the mailing list! This list receives email updates on the book and special promotions.

About the Author

Hi! My name is Ryan Lambert and I have worked professionally with PostgreSQL, PostGIS and OpenStreetMap for nearly a decade. My database experience started with MySQL, MS SQL and Oracle DB starting a few years prior to discovering the PostGIS ecosystem. My interest in technology is tightly coupled with my passion for education and sharing my excitement!

I started writing technical content for RustProof Labs' blog in 2013. In the time since I have continued writing about a range of technology, though the majority of my content for at least a couple years has been focused on PostgreSQL, PostGIS and OpenStreetMap.

I maintain a few open source projects that are illustrated and explored throughout the book. PgDD (PostgreSQL Data Dictionary) enables easy access through simple SQL queries against easy to remember views. PgOSM transforms and cleans OpenStreetMap data loaded via osm2pgsql. SRID bounding boxes is a table of polygons associated with a few thousand of the most common SRIDs used within PostGIS. The goal of each of these projects is to make it easier to understand and use the technology covered withing the book.