Uncategorized

Why the open source vs. traditional GIS debate needs to stop

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 […]

Uncategorized

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 […]

Uncategorized

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 […]

Uncategorized

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 […]

Learn Spatial SQL
Uncategorized

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 […]