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 […]
Yes, (another) file format is the most important new development tool for the modern GIS stack in 2022. There is a ton of hype around tools, processes, and methods for making geospatial analysis faster and at scale, but what if the data (in this case vector data) was better formatted for different query performance both […]
Spatial data science has been one of the fastest-growing career paths in modern GIS in the past few years. The combination of the boom in the data science path, proliferation and popularity of Python, and demand for more flexible/technical roles in data science and analytics have spilled over into modern GIS. Yet spatial data science […]
If you are looking for help loading a variety of geospatial data into PostGIS, then you have landed in the right place. This is a guide for my video below with further tutorials and guides. Special shout out to the team at Crunchy Data for their fantastic post on the topic. The Spatial SQL Book […]
This post serves as the guide for the first video in the Learn Spatial SQL series, focusing on SQL Basics for Spatial SQL, specifically Basic Query Structure: SELECT SELECT provides the basic query structure to return data from a table. This is the most foundational query structure in SQL when returning data from a table. […]
