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.
pgRouting: A Practical Guide is available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.