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 … Continue reading The Top 11 Open GeoParquet Datasets: Making big geospatial data easy
Join all the things in spatial SQL
In this post, we will take a look at joining data in SQL. We will take a quick look at joining data in SQL generally, and then how to perform spatial joins using spatial relationships. Let’s take a look at the answers to the challenges from the previous post If you are following along, in … Continue reading Join all the things in spatial SQL
Related posts
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 … Continue reading Mastering Spatial SQL: The Ultimate Guide to Tools & Databases in 2024
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 … Continue reading Load geospatial data to Redshift, BigQuery, Snowflake, and PostGIS: The complete guide