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 and machine learning, and far more. Because of these reasons I wanted to share a […]
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 First, head over to this site to download and install Postgres.app. This is a complete […]
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 spatial SQL (see my past posts on the topic). It’s speed, scale, and ability to […]
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 the answers to the challenges from the previous post If you are following along, in […]
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 more advanced filtering of your data Aggregations by grouping your data, filtering aggregated data using […]
