This is a video that I have been thinking about making for some time and the topic itself is one that has resonated with me for years. I sort of steered away from it since the topic itself can be a bit contentious, for both the open-source and traditional GIS community. But it is the […]
80% of all data is spatial? (is this really true)
By the numbers 80% of all data has a spatial component (I am sure you have heard it) 78% of articles have a georeferenced component (“How much information is geospatially referenced? Networks and cognition.” 2012) Modern GIS with Matt Forrest is a reader-supported publication. To receive new posts and support my work, consider becoming a […]
Load geospatial data to Redshift, BigQuery, Snowflake, and PostGIS: The complete guide
Getting started with spatial SQL will always require one key step where many hit a roadblock – importing data into your spatial database. In a traditional GIS setting, this is as simple as dragging or dropping a file or simply clicking to load it. For databases and data warehouses, this requires a few more steps […]
Building your spatial SQL toolkit
There are a ton of different ways to work with spatial SQL, but there are three different elements of every spatial SQL setup: The Spatial SQL Book – Available now! Check out my new book on Spatial SQL with 500+ pages to help you go from SQL novice to spatial SQL pro. This video will […]
Spatial SQL for GIS and Geospatial: Basic SQL
Welcome to the first in a series of videos and posts on learning spatial SQL. This will focus on learning the core elements of SQL, and in the name of not reinventing the wheel, there are already such great resources to learn SQL. The Spatial SQL Book – Available now! Check out my new book […]





