Packt+ | Advance your knowledge in tech

0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

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):

Pedro Wightman

Bborie Park

Paolo Corti

Stephen Vincent Mather

Thomas Kraft

Mayra Zurbarán

+2 more

View More author details

Table of Contents (14) Chapters

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

13. Other Books You May Enjoy

Leave a review - let other readers know what you think

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 €18.99/month. Cancel anytime

Authors (6)

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

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

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

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

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

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

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

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

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

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

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

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

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

Personalised recommendations for you

Based on your interests and search pattern

Pragmatic Microservices with C# and Azure

Pragmatic Microservices with C# and Azure

This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.

May 2024 16h 56m

Mastering Python Design Patterns

Mastering Python Design Patterns

Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.

May 2024 9h 52m

System Programming Essentials with Go

System Programming Essentials with Go

From file operations to process management and network programming, this hands-on guide equips software engineers with the skills to build efficient, reliable applications and optimize their performance.

Jun 2024 13h 36m

Modern Python Cookbook

Modern Python Cookbook

The new edition of Modern Python Cookbook provides over 130 recipes for solving real-world problems with Python. Updated for Python 3.12 with new recipes and chapters. This practical guide will enhance your skills and teach you advanced techniques.

Jul 2024 27h 16m

The Ultimate Zoom Cookbook

The Ultimate Zoom Cookbook

This cookbook is an in-depth guide to using Zoom effectively. You'll be able to follow each recipe easily to harness the power of the communication and collaboration tools in Zoom.

May 2024 11h 20m

Enterprise Architecture with .NET

Enterprise Architecture with .NET

This book will help you create applications that integrate correctly into complex and ever-changing information systems. You'll execute this by using industry standards that reduce the app's technical debt and elevate software development practices.

May 2024 25h 44m

Salesforce B2C Solution Architect's Handbook

Salesforce B2C Solution Architect's Handbook

Discover how Salesforce Customer 360 unifies Marketing Cloud, B2C Commerce, Data Cloud, and Service Cloud into one solution, and learn the capabilities, integration options, limitations, and workflows to create value for your organization.

May 2024 15h 28m

Systems Programming with C# and .NET

Systems Programming with C# and .NET

Unlock the full potential of C# and .NET Core in systems programming to secure, deploy, and maintain robust applications. With this book, you'll focus on low-level APIs, memory management, and performance optimization.

Jul 2024 15h 48m

Technical Program Manager's Handbook

Technical Program Manager's Handbook

Unlock the full potential of your career as a TPM with this comprehensive guide, featuring new chapters on AI and more. Learn advanced techniques and gain insights from industry leaders. Elevate your skills and thrive in the Big Five tech companies.

Sep 2024 12h 16m

Microsoft Power Pages in Action

Microsoft Power Pages in Action

Packed with real-world examples, low-code coding techniques, and insights into crafting responsive pages, automating apps, and enhancing virtual agents, Microsoft Power Pages in Action is a valuable resource for building feature-rich web apps.

Jun 2024 11h 40m