PostGIS is a spatial database that integrates 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 the related extensions, this book is a must-have.

This book is a deep-dive into the full range of PostGIS topics, with practical applications of the concepts and code. It is a comprehensive guide on PostGIS tools and concepts which are required to manage, manipulate, and analyse spatial data in PostGIS. This book is packed with systematic instructions of hands-on examples and in-depth explanations. Even for experienced users, this book will serve as a great source of reference by providing new ways of working with PostGIS through the book's easy-to-follow approach.

This hands-on guide looks at 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.

This practical book will help you take advantage of basic and advanced vector, raster, and routing approaches. You will learn to use the concepts of data maintenance, optimization, and performance, which will help you to integrate these into a large ecosystem of desktop and web tools.

With this comprehensive guide, 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.

Approach

An easy-to-use guide, full of hands-on recipes for manipulating spatial data in a PostGIS database. Each topic is explained and placed in context, and for the more inquisitive, there are more details of the concepts used.

Who this book is for

If you are a web developer or a software architect, especially in location-based companies, and want to expand the range of techniques you are using with PostGIS, then this book is for you. You should have some prior experience with PostgreSQL database and spatial concepts.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.

At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.

Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.

We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.

Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.

Yes, you can access PostGIS Cookbook by Paolo Corti, Thomas J. Kraft, Stephen Vincent Mather, Bborie Park in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Modelling & Design. We have over one million books available in our catalogue for you to explore.

Information

Publisher

Packt Publishing

Year

2014

ISBN

9781849518666

Edition

Topic

Computer Science

Subtopic

Data Modelling & Design

Index

Computer Science

PostGIS Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

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

Getting ready

How to do it...

How it works...

Importing shapefiles with shp2pgsql

How to do it...

How it works...

There's more...

Importing and exporting data with the ogr2ogr GDAL command

How to do it...

How it works...

See also

Handling batch importing and exporting of datasets

Getting ready

How to do it...

How it works...

Exporting data to the shapefile with the pgsql2shp PostGIS command

How to do it...

How it works...

Importing OpenStreetMap data with the osm2pgsql command

Getting ready

How to do it...

How it works...

Importing raster data with the raster2pgsql PostGIS command

Getting ready

How to do it...

How it works...

Importing multiple rasters at a time

Getting ready

How to do it...

How it works...

Exporting rasters with the gdal_translate and gdalwarp GDAL commands

Getting ready

How to do it...

How it works...

See also

2. Structures that Work

Introduction

Using geospatial views

Getting ready

How to do it...

How it works...

There's more...

See also

Using triggers to populate a geometry column

Getting ready

How to do it...

There's more...

Extending further...

See also

Structuring spatial data with table inheritance

Getting ready

How to do it...

How it works...

See also

Extending inheritance – table partitioning

Getting ready

How to do it...

How it works...

See also

Normalizing imports

Getting ready

How to do it...

How it works...

There's more...

Normalizing internal overlays

Getting ready

How to do it...

Converting polygons to linestrings

Converting linestrings back to polygons

Finding center points of resultant polygons

Using resultant points to query tabular relationships

How it works...

There's more...

Using polygon overlays for proportional census estimates

Getting ready

How to do it...

How it works...

3. Working with Vector Data – The Basics

Introduction

Working with GPS data

Getting ready

How to do it...

How it works...

Fixing invalid geometries

Getting ready

How to do it...

How it works...

GIS analysis with spatial joins

Getting ready

How to do it...

How it works...

Simplifying geometries

How to do it...

How it works...

Measuring distances

Getting ready

How to do it...

How it works...

Merging polygons using a common attribute

Getting ready

How to do it...

How it works...

Computing intersections

Getting ready

How to do it...

How it works...

Clipping geometries to deploy data

Getting ready

How to do it...

How it works...

Simplifying geometries with PostGIS topology

Getting ready

How to do it...

How it works...

4. Working with Vector Data – Advanced Recipes

Introduction

Improving proximity filtering with KNN

Getting ready

How to do it...

How it works...

See also

Improving proximity filtering with KNN – advanced

Getting ready

How to do it...

How it works...

See also

Rotating geometries

Getting ready

How to do it...

How it works...

See also

Improving ST_Polygonize

Getting ready

How to do it...

See also

Translating, scaling, and rotating geometries – advanced

Getting ready

How to do it...

How it works...

See also

Generating detailed building footprints from LiDAR

Getting ready

How to do it...

How it works...

Using external scripts to embed new functionality in order to calculate a Voronoi diagram

Getting ready

How to do it...

See also

Using external scripts to embed other libraries in order to calculate a Voronoi diagram – advanced

Getting ready

How to do it...

There's more...

Step zero – preparing the test table

Step one – preparing the input text

Step two – returning results

Step three – bundling as a function

Step four – translating into geometry

5. Working with Raster Data

Introduction

Getting and loading rasters

Getting ready

How to do it...

How it works...

Working with basic raster information and analysis

Getting ready

How to do it...

How it works...

Performing simple map-algebra operations

Getting ready

How to do it...

How it works...

Combining geometries with rasters for analysis

Getting ready

How to do it...

How it works...

Converting between rasters and geometries

Getting ready

How to do it...

How it works...

Processing and loading rasters with GDAL VRT

Getting ready

How to do it...

How it works...

Warping and resampling rasters

Getting ready

How to do it...

How it works...

Performing advanced map-algebra operations

Getting ready

How to do it...

How it works...

Executing DEM operations

Getting ready

How to do it...

How it works...

Sharing and visualizing rasters through SQL

Getting ready

How to do it...

How it works...

6. Working with pgRouting

Introduction

Startup – Dijkstra rout...

PostGIS Cookbook

About This Book

In Detail

Approach

Who this book is for

Frequently asked questions

Information

PostGIS Cookbook

Table of Contents

Table of contents