In the dynamic field of geospatial technology, the evolution of data formats plays a pivotal role in shaping how we interact with and interpret spatial information. The advent of GeoParquet has marked a significant milestone, offering a more efficient and accessible way to handle large spatial datasets. This blog post delves into a comprehensive exploration […]
Mastering Spatial SQL: The Ultimate Guide to Tools & Databases in 2024
The Evolving Landscape of Spatial SQL In today’s technologically driven world, the use of spatial SQL in databases and data warehouses has become increasingly significant. This growth not only enriches the database management landscape but also simplifies the learning curve for professionals, allowing them to apply their expertise across various tools. This blog post delves […]
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 […]