Mastering PostGIS and OpenStreetMap

Data Used in Book

Mastering PostGIS and OpenStreetMap is bundled with an OpenStreetMap data extract for Colorado. This source file is used for all queries throughout the book.

Real data

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

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!


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.

Mastering PostGIS and OpenStreetMap 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.