Master Spatial SQL
Unlock the power of Spatial SQL with this comprehensive guide
About the Book
Learn how to use Spatial SQL to analyze and manipulate geographic data. This book covers everything from basic spatial queries to advanced spatial analysis techniques all using SQL. Even if you don't know how SQL, this book starts from the beginning all the way to advanced queries.
What's in the book
INTRODUCTION
Why SQL?
CHAPTER 1
The evolution to modern GIS, why spatial SQL matters, and the spatial SQL landscape today
CHAPTER 2
Setting up
Installing PostGIS with Docker on any operating system
CHAPTER 3
Thinking in SQL
How to move from desktop GIS to SQL and learn how to structure queries independently
CHAPTER 4
The basics of SQL
Import data to PostgreSQL and PostGIS, SQL data types, and core SQL operations
CHAPTER 5
Advanced SQL
Statistical functions, joins, window functions, managing data, and user-defined functions
CHAPTER 6
Using the GEOMETRY
Working with GEOMETRY and GEOGRAPHY data, data manipulation, and measurements
CHAPTER 7
Spatial relationships
Spatial joins, distance relationships, clustering, and overlay functions
CHAPTER 8
Spatial analysis
Recreate common spatial analysis "toolbox" tools all in spatial SQL
CHAPTER 9
Advanced analysis
Data enrichment, line of sight, kernel density estimation, and more
CHAPTER 10
Raster data
Importing, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGIS
CHAPTER 11
Suitability analysis
Importing, analyzing, interpolating, and using H3 spatial indexes with raster data in PostGIS
CHAPTER 12
Routing with pgRouting
Routing for cars and bikes, travel time isochrones, and traveling salesperson problem
CHAPTER 13
Spatial data science
Spatial autocorrelation, location allocation, and create territories with PySAL in PostGIS
CONCLUSION
Sign up for updates and release information
Join the LocatePress newsletter for updates and information about the book