Chapter 14. Organizing spatial data
This chapter covers:
Options for structuring spatial data
Modeling a real city
Data abstraction with views
Triggers on tables and views
In chapter 2 we walked through all the possible geometry, geography, and raster types PostGIS offers, and how you can create and store them. In this chapter, we’ll continue our study by demonstrating the different table layouts you can design to store spatial data. Then we’ll apply these various design approaches to a real-world example (Paris, France). We’ll finish the chapter with a discussion and examples of using views for database abstraction and using triggers to manage inserts and updates in tables and views. Our main focus will be the geometry type, which is still the ...
Get PostGIS in Action, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
