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
Tapping into the power of spatial SQL aggregations
Use aggregations in SQL to group your data and perform large scale spatial joins Picking up where we left off from our last tutorial, we will jump right into the next set of topics: Using the WHERE clause to do more advanced filtering of your data Aggregations by grouping your data, filtering aggregated data using … Continue reading Tapping into the power of spatial SQL aggregations
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