Packt+ | Advance your knowledge in tech

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Newsletter Hub

Free Learning

PostGIS Cookbook

You're reading from PostGIS Cookbook Store, organize, manipulate, and analyze spatial data

Product type Paperback

Published in Mar 2018

Publisher

ISBN-13 9781788299329

Length 584 pages

Edition 2nd Edition

Languages

Python

Tools

PostGIS

Concepts

Geospatial Analysis

Authors (6):

Vincent Mather

Pedro Wightman

Park

Thomas Kraft

Mayra Zurbarán

Corti

+2 more

View More author details

Table of Contents (18) Chapters

Title Page

Packt Upsell

Contributors

Preface

1. Moving Data In and Out of PostGIS FREE CHAPTER

2. Structures That Work

3. Working with Vector Data – The Basics

4. Working with Vector Data – Advanced Recipes

5. Working with Raster Data

6. Working with pgRouting

7. Into the Nth Dimension

8. PostGIS Programming

9. PostGIS and the Web

10. Maintenance, Optimization, and Performance Tuning

11. Using Desktop Clients

12. Introduction to Location Privacy Protection Mechanisms

1. Other Books You May Enjoy

Leave a review - let other readers know what you think

Index

GIS analysis with spatial joins

Joins for regular SQL tables have the real power in a relational database, and spatial joins are one of the most impressive features of a spatial database engine such as PostGIS.

Basically, it is possible to correlate information from different layers on the basis of the geometric relation of each feature from the input layers. In this recipe, we will take a tour of some common use cases of spatial joins.

Getting ready

First, import some data to be used as a test bed in PostGIS. Download the .kmz file containing information about 2012 global earthquakes from the USGS website at http://earthquake.usgs.gov/earthquakes/eqarchives/epic/kml/2012_Earthquakes_ALL.kmz. Save it in the working/chp03 directory (alternatively, you can use the copy of this file included in the code bundle provided with this book).
A .kmz file is a collection of .kml files packaged with the ZIP compressor. Therefore, after unzipping the file (you may need to change the .kmz file extension to...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at ₹800/month. Cancel anytime

Authors (6)

Vincent Mather

Vincent Mather

Stephen Vincent Mather has worked in the geospatial industry for 15 years, having always had a flair for geospatial analyses in general, especially those at the intersection of Geography and Ecology. His work in open-source geospatial databases started 5 years ago with PostGIS and he immediately began using PostGIS as an analytic tool, attempting a range of innovative and sometimes bleeding-edge techniques (although he admittedly prefers the cutting edge).

See other products by Vincent Mather

Pedro Wightman

Pedro Wightman

Pedro M. Wightman is an associate professor at the Systems Engineering Department of Universidad del Norte, Barranquilla, Colombia. With a PhD in computer science from the University of South Florida, he's a researcher in location-based information systems, wireless sensor networks, and virtual and augmented reality, among other fields. Father of two beautiful and smart girls, he's also a rookie writer of short stories, science fiction fan, time travel enthusiast, and is worried about how to survive apocalyptic solar flares.

See other products by Pedro Wightman

Park

Park

Bborie Park has been breaking (and subsequently fixing) computers for most of his life. His primary interests involve developing end-to-end pipelines for spatial datasets. He is an active contributor to the PostGIS project and is a member of the PostGIS Steering Committee. He happily resides with his wife Nicole in the San Francisco Bay Area.

See other products by Park

Thomas Kraft

Thomas Kraft

Thomas J Kraft is currently a Planning Technician at Cleveland Metroparks after beginning as a GIS intern in 2011. He graduated with Honors from Cleveland State University in 2012, majoring in Environmental Science with an emphasis on GIS. When not in front of a computer, he spends his weekends landscaping and in the outdoors in general.

See other products by Thomas Kraft

Mayra Zurbarán

Mayra Zurbarán

Mayra Zurbaran is a Colombian geogeek currently pursuing her PhD in geoprivacy. She has a BS in computer science from Universidad del Norte and is interested in the intersection of ethical location data management, free and open source software, and GIS. She is a Pythonista with a marked preference for the PostgreSQL database. Mayra is a member of the Geomatics and Earth Observation laboratory (GEOlab) at Politecnico di Milano and is also a contributor to the FOSS community.

See other products by Mayra Zurbarán

Corti

Corti

Paolo Corti is an environmental engineer with 20 years of experience in the GIS field, currently working as a Geospatial Engineer Fellow at the Center for Geographic Analysis at Harvard University. He is an advocate of open source geospatial technologies and Python, an OSGeo Charter member, and a member of the pycsw and GeoNode Project Steering Committees. He is a coauthor of the first edition of this book and the reviewer for the first and second editions of the Mastering QGIS book by Packt.

See other products by Corti

Other recommended products

Related to this chapter

Mastering PostGIS

Mastering PostGIS

PostGIS is an open source spatial database system that offers a wider array of spatial analysis function and representation of geometric data types to databases. This book offers a tailored approach to practice common and most complex geo-processing tasks experts do with ease to design efficient GIS systems. Through the course of the book, not only will you learn what are the different data types, spatial querying, indexing and other complex operations on data, but also learn to create an end to end GIS solution. This book aims to teach you how to get maximum out of PostGIS and integrate it with other platforms like Geoserver, Opelayers, Javascript libraries to create a fully analytical GIS application.

May 2017 10h 56m

GeoServer Beginner's Guide

GeoServer Beginner's Guide

GeoServer is an open-source server written in Java that allows users to share, process, and edit geospatial data. This book will guide you through the new features and improvements of GeoServer and will help you get started with it. GeoServer Beginner's Guide gives you a kick-start to build custom maps using your data without the need for costly commercial software licenses and restrictions. Even if you do not have prior GIS knowledge, you will be able to make interactive maps after reading this book.

Oct 2017 12h 48m

Mastering Geospatial Analysis with Python

Mastering Geospatial Analysis with Python

Python comes with many libraries and tools that help you work on geoprocessing tasks without investing in expensive tools. This book introduces you to new libraries that perform geospatial and statistical analysis and data management. It uses examples that explain how Python v3 differs from v2, and solve age-old problems in geospatial analysis.

Apr 2018 14h 40m

Hands-On Geospatial Analysis with R and QGIS

Hands-On Geospatial Analysis with R and QGIS

Managing spatial data has always been challenging and it's getting more complex as the size of data increases. This book is your companion to understand, manage, and analyze spatial data effectively using R and QGIS. You'll learn to use different statistical analyses with spatial data and automate spatial tasks. You'll also learn to classify remote sensing data and use a machine learning approach to map landslide susceptibility.

Nov 2018 11h 48m

QGIS 3.4 is a user-friendly open source geographic information system (GIS) that runs on Linux, Unix, Mac OS X, and Windows. The book will take you on a journey from firing up QGIS for the first time to developing your own processing pathway. We'll look at the fundamentals of GIS: data creation, data display, creating maps and spatial analysis.

Learning Geospatial Analysis with Python

Learning Geospatial Analysis with Python

Geospatial Analysis is used in almost every field you can think of from medicine to defense, to farming. Learning Geospatial Analysis with Python, Third Edition would be a helpful guide to Geographic Information Systems and Remote Sensing Analysis using Python 3.7 without overwhelming the reader.

Sep 2019 15h 12m

The most commonly used GIS tools automate tasks that were historically done manually—compiling new maps by overlaying one on top of the other or physically cutting maps into pieces representing specific study areas, changing their projection, and getting meaningful results from the various layers by applying mathematical functions and operations. This book is an easy-to-follow guide to use the most matured open source GIS tools for these tasks.

Jun 2017 14h 16m

Expert Geoserver

Expert Geoserver

In this book, you'll learn how to publish geospatial processing algorithms through WPS, and put your GeoServer-based web application into fast, user-friendly, and secure production. By the end of this book, you will be able to deploy a professional-quality secure, and user-specific GeoServer-backed web mapping and processing application through a modern, cloud-hosting infrastructure.

Jul 2018 4h 28m

QGIS Python Programming Cookbook

QGIS Python Programming Cookbook

QGIS is a desktop geographic information system that facilitates data viewing, editing, and analysis. Based on version QGIS 2.18, this book will teach you how to write Python code that works with spatial data to automate geoprocessing tasks in QGIS.

Mar 2017 15h 28m

Mastering Geospatial Development with QGIS 3.x

Mastering Geospatial Development with QGIS 3.x

This book is a guide for professionals looking to master the open source QGIS software. This book will take you all the way through to learning advanced techniques like illuminated contours and dynamic masking. You will learn about the advanced topics like the creation of GeoPackages, the Processing Toolbox, and the creation of plugins using PyQGIS.

Mar 2019 15h 32m

Personalised recommendations for you

Based on your interests and search pattern

LLVM Code Generation

LLVM Code Generation

LLVM is a key technology for building modern compilers. You'll learn how to use its infrastructure to create and extend backends (X86 and AArch64), and contribute to the LLVM open-source project, equipping you with key skills in compiler design.

May 2025 20h 40m

Domain-Driven Refactoring

Domain-Driven Refactoring

This book is your exhaustive guide to applying DDD practices for building robust applications. You'll learn key patterns, refine business logic, and solve real-world problems with DDD principles, refactoring, and event-driven architectures.

May 2025 10h 48m

The Power Platform Playbook for Digital Transformation

The Power Platform Playbook for Digital Transformation

Transform your business with Power Apps, Power Automate, Power BI, and Copilot Studio. This guide covers automation, AI insights, governance, and security, helping leaders, IT pros, and analysts build scalable, low-code enterprise solutions.

Apr 2025 11h 52m

Microservices with Go

Microservices with Go

The book covers Go microservice development, covering the basics for beginners and best practices for structuring Go apps. Novice as well seasoned developers will gain insights into managing and scaling microservices.

Jun 2025 14h 16m