This chapter is available as a free download. Free chapter
This chapter covers the fundamentals of spatial databases and what you can do with a spatially enabled database that you can't do with a standard relational database. It concludes with a fast-paced example of loading fast food restaurant longitude latitude data and converting them to geometric points, loading roads data from ESRI shapefiles and doing spatial summaries by joining these two sets of data.
Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out 1st or 2nd quarter 2017. Preview drafts available. Content is now feature complete.
© Leo Hsu and Regina Obe 2014