Summary
In this chapter, you learned how to write a few spatial topographic queries and add multiple layers of data to your SQL queries. You were introduced to an important resource for understanding demographic and economic data attributes associated with geographical locations – the 2020 US Census. You successfully ran queries on data and generated your own maps for exploration.
In Chapter 5, Using SQL Functions – Spatial and Non-Spatial, you will continue to be introduced to SQL spatial queries and begin to work with more advanced concepts, such as measuring distance and evaluating buffers, in addition to building a simple prediction model.