PostGIS in Action (3rd)
Where the adventure begins

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

PostGIS In Action 3rd Edition Chapters    PostGIS In Action 2nd Edition Chapters    1st 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)

pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.

PostGIS in Action,3rd edition MEAP    PostgreSQL: Up and Running       D3.js in Action 2nd Edition   PostGIS Cookbook 2nd edition