PostGIS Cookbook : store, organize, manipulate, and analyze spatial data / Mayra Zurbaran [and five others].

Format:

Book

Author/Creator:

Vincent Mather, Stephen, Author.

Zurbaran, Mayra, author.

Language:

English

Subjects (All):

Database software.

Physical Description:

1 online resource (584 pages)

Edition:

Second edition.

Place of Publication:

Birmingham ; Mumbai : Packt, 2018.

Summary:

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.

Contents:

Cover

Title Page

Copyright and Credits

Packt Upsell

Contributors

Table of Contents

Preface

Chapter 1: Moving Data In and Out of PostGIS

Introduction

Importing nonspatial tabular data (CSV) using PostGIS functions

Getting ready

How to do it...

How it works...

Importing nonspatial tabular data (CSV) using GDAL

Importing shapefiles with shp2pgsql

There's more...

Importing and exporting data with the ogr2ogr GDAL command

See also

Handling batch importing and exporting of datasets

Exporting data to a shapefile with the pgsql2shp PostGIS command

Importing OpenStreetMap data with the osm2pgsql command

Importing raster data with the raster2pgsql PostGIS command

Importing multiple rasters at a time

Exporting rasters with the gdal_translate and gdalwarp GDAL commands

Chapter 2: Structures That Work

Using geospatial views

Using triggers to populate the geometry column

Extending further...

Structuring spatial data with table inheritance

Extending inheritance - table partitioning

Normalizing imports

Getting ready.

How to do it...

Normalizing internal overlays

Using polygon overlays for proportional census estimates

Chapter 3: Working with Vector Data - The Basics

Working with GPS data

Fixing invalid geometries

GIS analysis with spatial joins

Simplifying geometries

Measuring distances

Merging polygons using a common attribute

Computing intersections

Clipping geometries to deploy data

Simplifying geometries with PostGIS topology

Chapter 4: Working with Vector Data - Advanced Recipes

Improving proximity filtering with KNN

Improving proximity filtering with KNN - advanced

Rotating geometries

Improving ST_Polygonize

Translating, scaling, and rotating geometries - advanced

Detailed building footprints from LiDAR

Creating a fixed number of clusters from a set of points.

Getting ready

Calculating Voronoi diagrams

Chapter 5: Working with Raster Data

Getting and loading rasters

Working with basic raster information and analysis

Performing simple map-algebra operations

Combining geometries with rasters for analysis

Converting between rasters and geometries

Processing and loading rasters with GDAL VRT

Warping and resampling rasters

Performing advanced map-algebra operations

Executing DEM operations

Sharing and visualizing rasters through SQL

Chapter 6: Working with pgRouting

Startup - Dijkstra routing

Loading data from OpenStreetMap and finding the shortest path using A*

Calculating the driving distance/service area

Calculating the driving distance with demographics

Extracting the centerlines of polygons

Chapter 7: Into the Nth Dimension

Importing LiDAR data

Performing 3D queries on a LiDAR point cloud

How to do it.

Constructing and serving buildings 2.5D

Using ST_Extrude to extrude building footprints

Creating arbitrary 3D objects for PostGIS

Exporting models as X3D for the web

Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D

Getting started

UAV photogrammetry in PostGIS - point cloud

UAV photogrammetry in PostGIS - DSM creation

Chapter 8: PostGIS Programming

Writing PostGIS vector data with Psycopg

Writing PostGIS vector data with OGR Python bindings

Writing PostGIS functions with PL/Python

Geocoding and reverse geocoding using the GeoNames datasets

Geocoding using the OSM datasets with trigrams

Geocoding with geopy and PL/Python

Importing NetCDF datasets with Python and GDAL

Chapter 9: PostGIS and the Web

Creating WMS and WFS services with MapServer

Creating WMS and WFS services with GeoServer

Creating a WMS Time service with MapServer

Consuming WMS services with OpenLayers

How it works.

Consuming WMS services with Leaflet

Consuming WFS-T services with OpenLayers

Developing web applications with GeoDjango - part 1

Developing web applications with GeoDjango - part 2

Developing a web GPX viewer with Mapbox

Chapter 10: Maintenance, Optimization, and Performance Tuning

Organizing the database

Setting up the correct data privilege mechanism

Backing up the database

Using indexes

Clustering for efficiency

Optimizing SQL queries

Migrating a PostGIS database to a different server

Replicating a PostGIS database with streaming replication

Geospatial sharding

Paralellizing in PosgtreSQL

Chapter 11: Using Desktop Clients

Adding PostGIS layers - QGIS

Using the Database Manager plugin - QGIS

Adding PostGIS layers - OpenJUMP GIS

Running database queries - OpenJUMP GIS

Adding PostGIS layers - gvSIG.

Notes:

Description based on print version record.

ISBN:

9781788296441

1788296443

OCLC:

1030822104