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.
Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out in hard-copy 4th quarter 2017. Content is now feature complete and can purchase e-Book draft and get final when goes to print.
© Leo Hsu and Regina Obe 2014