PostGIS in Action (2nd)
Where the adventure begins

PostGIS in Action: (ed. #2) Chapter 2 - Spatial Types

1st Edition Chapters    PostGIS In Action 2nd Edition Chapters
Download chapter code and data

  • raster, geometry, geography, topology spatial types and subclassifications
  • geometry and geography type modifiers
  • Spatial catalog tables
  • How to create spatial columns and populate

In the first chapter, we gave you a brief taste of what PostGIS is and what are the basic spatial types it supports. In this chapter we'll demonstrate how to create these spatial types and how to create spatial database columns. We'll introduce the concept of typmod that allows constraining geometry and geography types based on declarative column type definition such as geom geometry(LineString,4326)

Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out 1st or 2nd quarter 2017. Preview drafts available. Content is now feature complete.

PostGIS in Action,2nd edition MEAP      PostGIS Cookbook    PostgreSQL: Up and Running,2nd Edition    PostGIS 2 Análisis Espacial Avanzado (Spanish Edition)   
Node JS In Action, 2nd Edition    D3.js in Action