PostGIS in Action (3rd)
Where the adventure begins

PostGIS in Action: (ed. #3) Chapter 14 - Organizing spatial data

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

In this chapter we continue our study by demonstrating the different table layouts you can design to store spatial data. Next, we apply our various design approaches to a real-world example. We finish the chapter with a discussion and examples of using triggers to manage inserts and updates in our tables and views.

  • Options for structuring spatial data
  • Modeling a real city
  • Using table partitioning to partition a big table into sub-tables
  • Triggers on views
Save 50% off on Third Edition of PostGIS In Action enter mlobe3 in the Promotional Code box when you check out. Offer ends November 25th, 2021

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