Book Image

PostGIS Cookbook - Second Edition

By : Pedro Wightman, Bborie Park, Stephen Vincent Mather, Thomas Kraft, Mayra Zurbarán
Book Image

PostGIS Cookbook - Second Edition

By: Pedro Wightman, Bborie Park, Stephen Vincent Mather, Thomas Kraft, Mayra Zurbarán

Overview of this book

PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the PostgreSQL object-relational database and is currently the most popular open source spatial databases. If you want to explore the complete range of PostGIS techniques and expose related extensions, then this book is for you. This book is a comprehensive guide to PostGIS tools and concepts which are required to manage, manipulate, and analyze spatial data in PostGIS. It covers key spatial data manipulation tasks, explaining not only how each task is performed, but also why. It provides practical guidance allowing you to safely take advantage of the advanced technology in PostGIS in order to simplify your spatial database administration tasks. Furthermore, you will learn to take advantage of basic and advanced vector, raster, and routing approaches along with the concepts of data maintenance, optimization, and performance, and will help you to integrate these into a large ecosystem of desktop and web tools. By the end, you will be armed with all the tools and instructions you need to both manage the spatial database system and make better decisions as your project's requirements evolve.

Related Content you might be interested in

Current Title:

Small book image
PostGIS Cookbook - Second Edition
Pedro Wightman | Bborie Park | Stephen Vincent Mather | Thomas Kraft | Mayra Zurbarán
Mar, 2018 | 584 pages
Small book image
Mastering PostGIS
Tomasz Nycz | Michal Mackiewicz | Dominik Mikiewicz
May, 2017 | 328 pages
Small book image
GeoServer Beginner's Guide
Stefano Iacovella
Oct, 2017 | 384 pages
Small book image
Mastering Geospatial Analysis with Python
Paul Crickard | Silas Toms | Eric van Rees
Apr, 2018 | 440 pages
Table of Contents (18 chapters)
Title Page
Title Page
Packt Upsell
Packt Upsell
Contributors
Contributors
Preface
Preface
Free Chapter
1
Moving Data In and Out of PostGIS
Moving Data In and Out of PostGIS
Introduction
Importing nonspatial tabular data (CSV) using PostGIS functions
Importing nonspatial tabular data (CSV) using GDAL
Importing shapefiles with shp2pgsql
Importing and exporting data with the ogr2ogr GDAL command
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
2
Structures That Work
Structures That Work
Introduction
Using geospatial views
Using triggers to populate the geometry column
Structuring spatial data with table inheritance
Extending inheritance – table partitioning
Normalizing imports
Normalizing internal overlays
Using polygon overlays for proportional census estimates
3
Working with Vector Data – The Basics
Working with Vector Data – The Basics
Introduction
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
4
Working with Vector Data – Advanced Recipes
Working with Vector Data – Advanced Recipes
Introduction
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
Calculating Voronoi diagrams
5
Working with Raster Data
Working with Raster Data
Introduction
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
6
Working with pgRouting
Working with pgRouting
Introduction
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
7
Into the Nth Dimension
Into the Nth Dimension
Introduction
Importing LiDAR data
Performing 3D queries on a LiDAR point cloud
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
UAV photogrammetry in PostGIS – point cloud
UAV photogrammetry in PostGIS – DSM creation
8
PostGIS Programming
PostGIS Programming
Introduction
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
9
PostGIS and the Web
PostGIS and the Web
Introduction
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
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
10
Maintenance, Optimization, and Performance Tuning
Maintenance, Optimization, and Performance Tuning
Introduction
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
11
Using Desktop Clients
Using Desktop Clients
Introduction
Adding PostGIS layers – QGIS
Using the Database Manager plugin – QGIS
Adding PostGIS layers – OpenJUMP GIS
Running database queries – OpenJUMP GIS
Adding PostGIS layers – gvSIG
Adding PostGIS layers – uDig
12
Introduction to Location Privacy Protection Mechanisms
Introduction to Location Privacy Protection Mechanisms
Introduction
Adding noise to protect location data
Creating redundancy in geographical query results
References
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think
Index
Index

Packt Upsell

mapt.io

Mapt is an online digital library that gives you full access to over 5,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit our website.

Why subscribe?

  • Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals

  • Improve your learning with Skill Plans built especially for you

  • Get a free eBook or video every month

  • Mapt is fully searchable

  • Copy and paste, print, and bookmark content

PacktPub.com

Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at [email protected] for more details.

At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.

Previous Section
Next Chapter