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. […]
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 knowledge, but this guide is meant to be a really simple cookbook to start to […]
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 a flexible workflow and use a wide range of data, delivering easy to use and […]
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 new book on Spatial SQL with 500+ pages to help you go from SQL novice […]
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 […]
