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 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