11 min. read 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 translate your current workflows into spatial SQL. Other resources A few things to note: I will write SQL code for PostGIS and common data warehouses Not every data warehouse supports projections – for example, BigQuery and Snowflake only support WGS 84 SRID 4326 This guide … Continue reading Spatial SQL Cookbook: Common GIS Analyses in Spatial SQL