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

Exporting vector data using ogr2ogr

We have already seen a little preview of ogr2ogr exporting the data when we made sure that our KML import had actually brought in the proper data. This time we'll expand on the subject a bit and also export a few more formats, to give you an idea of how sound a tool ogr2ogr is.

In order to get some information on the tool, simply type the following in the console:

ogr2ogr

Alternatively, if you would like to get some more descriptive info, visit http://www.gdal.org/ogr2ogr.html.

You could also type the following:

ogr2ogr -long-usage

The nice thing about ogr2ogr is that the tool is very flexible and offers some options that allow us to export exactly what we are after. You can specify what data you would like to select by specifying the columns in a -select parameter. -where parameter lets you specify the filtering for your dataset in case you want to output only a subset...