I took a real Shapefile with almost 1.1 million polygons and converted it to GeoParquet three different ways. The file went from over 1.4 GB of source data down to 246 MB, opened cleanly in QGIS, and ran spatial queries in seconds instead of minutes. The dataset was the New York City building footprints. Every […]
Last week the team from Apache Sedona released SedonaDB, a new tool that makes spatial processing fast and also treats spatial data like a first class citizen. Or read a different way it is really fast for doing spatial analytics. It uses Python and SQL to analyze data and can also output data in GeoParquet […]
If you are looking for help loading a variety of geospatial data into PostGIS, then you have landed in the right place. This is a guide for my video below with further tutorials and guides. Special shout out to the team at Crunchy Data for their fantastic post on the topic. The Spatial SQL Book […]
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 […]
