Summary
In this chapter, we were introduced to additional spatial considerations and how to differentiate between a Cartesian coordinate system and a spatial coordinate system. Creating and exploring databases is fundamental to building SQL skills, and both were introduced as foundational to working with datasets in the chapters that follow. We learned how to import data into QGIS that synchronizes with the database(s) we created in pgAdmin. And with this, the application of SQL fundamentals to query datasets will prepare us for problem-solving in the next chapter, using geometric data and integrating GIS functions into a modern SQL environment.
