SQL is a fundamental tool in GIS for managing and analyzing spatial data efficiently. In this section, I’ve included SQL code samples that demonstrate how I’ve used it to query, filter, and manipulate geographic datasets. These examples highlight tasks such as selecting features based on attributes, performing spatial joins, and optimizing data workflows. While much of my GIS work focuses on cartography, integrating SQL allows for more advanced data analysis and streamlining processes within spatial databases.

I’ve also included a ERD for the database I set up using SQL - click on the image to see a larger version of the ERD.