An unusual and useful property of PostgreSQL databases is that they allow for object inheritance models as they apply to tables. This means that we can have parent/child relationships between tables and leverage that to structure out data in meaningful ways. In our example, we will apply this to hydrology data. This data can be points, lines, polygons, or more complex structures, but they have one commonality; they are explicitly linked in a physical sense and inherently related and are all about water. Water/hydrology is an excellent natural system to model this way, as our ways of modeling it spatially can be quite mixed depending on scales, details, the data collection process, and a host of other factors.
PostGIS Cookbook
PostGIS Cookbook
Overview of this book
Table of Contents (18 chapters)
PostGIS Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Moving Data In and Out of PostGIS
Structures that Work
Working with Vector Data – The Basics
Working with Vector Data – Advanced Recipes
Working with Raster Data
Working with pgRouting
Into the Nth Dimension
PostGIS Programming
PostGIS and the Web
Maintenance, Optimization, and Performance Tuning
Using Desktop Clients
Index
Customer Reviews