Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Mastering PostGIS

You're reading from Mastering PostGIS Modern ways to create, analyze, and implement spatial data

Product type Paperback

Published in May 2017

Publisher Packt

ISBN-13 9781784391645

Length 328 pages

Edition 1st Edition

Languages

SQL

Tools

PostGIS

Concepts

Geospatial Analysis

Authors (4):

George Silva

Mikiewicz

Michal Mackiewicz

Nycz

View More author details

Table of Contents (9) Chapters

1. Importing Spatial Data FREE CHAPTER

2. Spatial Data Analysis

3. Data Processing - Vector Ops

4. Data Processing - Raster Ops

5. Exporting Spatial Data

6. ETL Using Node.js

7. PostGIS – Creating Simple WebGIS Applications

8. PostGIS Topology

9. pgRouting

The conceptual model

Before we start working with topology, we need to discuss the key concepts behind the PostGIS topological data model. PostGIS topology implementation is based on ISO standard 13249 - Information technology - Database languages - SQL multimedia and application packages - Part 3: Spatial. The standard name is often abbreviated as ISO SQL/MM. This standard defines two data models for topology: TopoGeometry and TopoNetwork; PostGIS implements only the former.

In this model, there are three kinds of elements/primitives used to compose geospatial features: nodes, edges, and faces.

Nodes are point features. They can exist on their own (isolated nodes) or serve as connection points for linear features (the edges). For example, this is a Czech-Polish-Slovak tripoint near Jaworzynka village, which contains a node and three edges:

An example of topological data: a node and three edges

In topology, only one node can appear for a specified coordinate pair - if there are more nodes in...

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 $15.99/month. Cancel anytime

Authors (4)

George Silva

George Silva

See other products by George Silva

Mikiewicz

Mikiewicz

Dominik Mikiewicz is a senior GIS consultant and the owner of one-person software shop Cartomatic. When not coding, he spends time with wife and kids, trying to make the little ones enjoy mountain trekking. He is also a long-distance cycling and running enthusiast.

See other products by Mikiewicz

Michal Mackiewicz

Michal Mackiewicz

Michal Mackiewicz has been working as a software engineer at GIS Support for five years. His main job is to orchestrate various open source geospatial components and creating application-specific GIS systems. PostgreSQL and PostGIS are among his favorite tools, and are used in almost every project. Apart from developing, he also runs PostGIS training courses. When not at work, he volunteers for OpenStreetMap and a local railway preservation society.

See other products by Michal Mackiewicz

Nycz

Nycz

Tomasz Nycz is a geographer and cartographer. He initiated the implementation of GIS in the State Fire Service units in Poland. He works with recognized GIS companies in the emergency management industry. In practice, he uses QGIS and PostGIS. He has been an OpenStreetMap contributor for years. He also develops his scientific interests in the use of new technologies in geomorphology and remote sensing. He is also an avid drone pilot and mountain explorer.

See other products by Nycz

Other recommended products

Related to this chapter

PostGIS Cookbook

PostGIS Cookbook

PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. If you want to explore the complete range of PostGIS techniques and expose the related extensions, then this book is for you.

Mar 2018 19h 28m

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

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

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

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

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

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

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

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 44m

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