In this chapter we mix spatial functions with SQL with wild abandon. You'll see powerful one-liners to blow your mind. You'll see window function tricks, common table expressions, recursive table expressions
applied to spatial processing. You'll learn how to mold space with SQL to accomplish common world needs that you may have thought were only possible with a desktop GIS tool.
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