Technical requirements
The data for the exercises in this chapter can be found on GitHub at https://github.com/PacktPublishing/Geospatial-Analysis-with-SQL
The following datasets will be used in this chapter:
Airport_Influence_areaCensus_Designated_places_2020
Income_per_Capitaper census tract- American Community Survey (ACS) – 1 year data
As we learned about geometric and geographic spatial queries in defining coordinates and locations, we investigated points, lines, and areas of polygons. When referring to a topological query, we are mainly interested in where objects are located and where they might intersect, in addition to specific attributes.
Topological SQL queries investigate spatial relations between tables or entities within a database. Topological criteria focus on the arrangement of entities in space. These arrangements are preserved regardless of projection. We have already explored spatial relationships such as distance...
