-
Book Overview & Buying
-
Table Of Contents
Geospatial Analysis with SQL
By :
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_2020Income_per_Capita per census tractAs 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...