Tapping into the power of spatial SQL aggregations

7 min. read Use aggregations in SQL to group your data and perform large scale spatial joins Picking up where we left off from our last tutorial, we will jump right into the next set of topics: Using the WHERE clause to do more advanced filtering of your data Aggregations by grouping your data, filtering aggregated data using HAVING, and using selective aggregations to aggregate only specific sets of data Spatial aggregations — or spatial relationships using intersections, contains, overlaps, and unions But first, a review of our challenge from Part 1 Here is the challenge from the last post: Using the Mapzen Who’s on First … Continue reading Tapping into the power of spatial SQL aggregations