One of the biggest challenges, at least for me, when getting started with spatial SQL is having a quick and easy reference to transfer your current GIS workflows into SQL. There are many amazing resources out there to expand this…
GIS Analysts serve the incredibly important purpose of providing detailed analysis and flexible results working with a wide range of data and tools. Not only do GIS Analysts work with many different stakeholder groups, but they also have to maintain…
Take advantage of the speed of PostGIS along with the flexibility of Geopandas and Python in 4 minutes! Take a look at the video and follow along with these steps! The Spatial SQL Book – Available now! Check out my…
Spatial SQL is not just a query language. It is becoming far more than that and its uses are expanding beyond just a database for spatial data. It allows for faster spatial analysis, supports spatial applications, enables spatial data science…
QGIS provides an excellent interface to get started with PostGIS, and (if you are a Mac user) you can start with PostGIS using Postgres.app very fast! Check out the video and follow along using this guide. Download and install Postgres.app…
One of the top questions I get asked is what my favorite resources are for learning any given topic, and spatial SQL is always near the top of that list It’s no secret that I am a big fan of…
In this post, we will take a look at joining data in SQL. We will take a quick look at joining data in SQL generally, and then how to perform spatial joins using spatial relationships. Let’s take a look at…
Use aggregations in SQL to group your data and perform large scale spatial joins Picking up where we left off from our last tutorial, we will jump right into the next set of topics: Using the WHERE clause to do…
Mastering SQL fundamentals to get started with spatial SQL So you are interested in getting started with spatial SQL — that’s great! Getting started can seem overwhelming but in this post and others, I hope to take you through the different use cases…