PostGIS in Action

Chapter 3. Organizing spatial data

 

This chapter covers

• Options for structuring spatial vector data
• Modeling a real city
• Rules and triggers

 

In the last chapter we did a walkthrough of all the possible geometry types PostGIS offers and how you would create and store them. 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 rules and triggers to manage inserts and updates in our tables and views.

3.1. Spatial storage approaches

You should now have a good understanding of all the spatial vector types available in PostGIS. We’ll move on to ...