Book Overview & Buying
Table Of Contents

Mastering PostGIS

By : Dominik Mikiewicz, Michal Mackiewicz , Tomasz Nycz

1 (1)

Buy this Book

Mastering PostGIS

1 (1)

By: Dominik Mikiewicz, Michal Mackiewicz , Tomasz Nycz

Buy this Book

Overview of this book

PostGIS is open source extension onf PostgreSQL object-relational database system that allows GIS objects to be stored and allows querying for information and location services. The aim of this book is to help you master the functionalities offered by PostGIS- from data creation, analysis and output, to ETL and live edits. The book begins with an overview of the key concepts related to spatial database systems and how it applies to Spatial RMDS. You will learn to load different formats into your Postgres instance, investigate the spatial nature of your raster data, and finally export it using built-in functionalities or 3th party tools for backup or representational purposes. Through the course of this book, you will be presented with many examples on how to interact with the database using JavaScript and Node.js. Sample web-based applications interacting with backend PostGIS will also be presented throughout the book, so you can get comfortable with the modern ways of consuming and modifying your spatial data.

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

Importing Spatial Data

Obtaining test data

Importing flat data

Importing shape files using shp2pgsql

Importing vector data using ogr2ogr

Importing data using GIS clients

Importing OpenStreetMap data

Connecting to external data sources with foreign data wrappers

Loading rasters using raster2pgsql

Importing data with pgrestore

Summary

Spatial Data Analysis

Composing and decomposing geometries

Spatial measurement

Geometry bounding boxes

Geometry simplification

Geometry validation

Intersecting geometries

Nearest feature queries

Summary

Data Processing - Vector Ops

Primer - obtaining and importing OpenStreetMap data

Merging geometries

Slicing geometries

Buffering and offsetting geometries

Reprojecting geometries

Spatial relationships

Summary

Data Processing - Raster Ops

Preparing data

Processing and analysis

Analytic and statistical functions

Vector to raster conversion

Raster to vector conversion

Spatial relationship

Metadata

Summary

Exporting Spatial Data

Exporting data using \COPY in psql

Exporting vector data using pgsql2shp

Exporting vector data using ogr2ogr

Exporting data using GIS clients

Outputting rasters using GDAL

Outputting raster using psql

Exporting data using the PostgreSQL backup functionality

Summary

ETL Using Node.js

Setting up Node.js

Handshaking with a database using Node.js PgSQL client

Retrieving and processing JSON data

Geocoding address data

Consuming WFS data

Summary

PostGIS – Creating Simple WebGIS Applications

ExtJS says Hello World

Configuring GeoServer web services

Making use of PgRaster in a simple WMS GetMap handler

Consuming WMS

Enabling CORS in Jetty

Consuming WFS in ol3

Outputting and consuming GeoJSON

Outputting and consuming TopoJSON

Implementing a simple CRUD application that demonstrates vector editing via web interfaces

Summary

PostGIS Topology

The conceptual model

The data

Installation

Creating an empty topology

Importing Simple Feature data into topology

Inspecting and validating a topology

Accessing the topology data

Topology editing

Topology-aware simplification

Topology output

Summary

pgRouting

Installing the pgRouting extension

Importing routing data

pgRouting algorithms

Consuming pgRouting functionality in a web app

Summary

Spatial relationships

In the previous chapter, one spatial relationship function - the ST_Intersects, was introduced. This is only the beginning of the story; there are many more, finer functions available, to explore the relationships between features more precisely. For more details, read on.

Touching

A geometry is defined as touching when at least its vertex or edge lies on the edge of the reference geometry, but no points are inside its interior.

For example, let's find all the tributaries of the Odra river:

SELECT name,waterway FROM lines WHERE waterway in ('river','stream') AND name != 'Odra' AND ST_Touches( 
   wkb_geometry, 
   (SELECT ST_Collect(wkb_geometry) FROM lines WHERE name = 'Odra') 
   );

The ST_Collect...

Tech Concepts

Programming languages

Tech Tools