Check all this out and more in the release post! sedona.apache.org/latest/blog/...
11.03.2026 02:31
👍 0
🔁 0
💬 0
📌 0
Check all this out and more in the release post! sedona.apache.org/latest/blog/...
Finally, we added the beginnings of an #rstats DataFrame API that can be used to implement a #dplyr backend. This is my favourite feature of SedonaDB 0.3.0 because I love R, dplyr, and because I never properly learned SQL 😬
#rstats users will be pleased to know that you can now read anything sf can piped directly into SedonaDB via GDAL's @arrow.apache.org integration. This makes the SedonaDB R package considerably more useful!
We also added a lot of functions (with full 4D and geometry type support with PostGIS integration tests, as usual!)
We've always had a great Parquet writer; however, Parquet is new on the block and sometimes you just need a Shapefile (or GeoPackage, or FlatGeoBuf). This was always possible with SedonaDB and pyogrio's Arrow integration but in 0.3.0 we gave it some nice defaults and made it easy to do.
Ever since reading @opencholmes.bsky.social's fantastic GeoParquet best practices guide, I've wanted to make that trivial to do with SedonaDB's Parquet writer. After this release...it is! Sort, compress, and reduce your row group size based on the results of any query all in one go!
One of the most commonly requested features by those of us who wrote SedonaDB code frequently was parameterized SQL queries! Now you can add a placeholder and bind just about any spatial object you can think of (CRS included!). Let us know if we missed your favourite one!
SedonaDB can now represent geometries with a separate CRS per row (like @postgis.bsky.social/EWKB), including transforming to and from with CRSes derived from a column. If you've ever been sent a spreadsheet with UTM coordinates with a "zone" column, this feature is for you!
The new spatial join gives more flexibility for running SedonaDB in memory constrained environments and increases the size of the data you can swing around on your laptop. It's currently opt-in (requires setting a memory limit)...give it a go and let us know how it goes!
We're chuffed to announce Apache SedonaDB 0.3.0! This release features a rewritten join that supports larger-than-memory spatial/KNN joins courtesy of Kristin Cowalcijk, new functions, parameterized SQL queries, GDAL/pyogrio reads, GDAL/sf based reads in R, and the beginnings of an R DataFrame API!
Does SedonaDB's KNN join help at all? I haven't wired up nice dplyrish syntax for everything yet but the SQL isn't too bad.
📖 Apache Parquet recently added native support for Geospatial. This post explains what that means and why it is important: parquet.apache.org/blog/2026/02...
Great inaugural post about the geospatial types on the Parquet blog.
Thank you Jia Yu, Dewey Dunnington , Kristin Cowalcijk, Feng Zhang.
More posts coming !
parquet.apache.org/blog/2026/02...
Released this week: Version 22 of the ADBC libraries and drivers.
This release includes updates to the ADBC libraries for 8 languages, and improvements to the 4 ADBC drivers that are maintained in the apache/arrow-adbc repository. See the blog for more details: arrow.apache.org/blog/2026/01...
Introducing gdalcli by Andrew Brown -- an R frontend to GDAL’s unified CLI (≥3.11) 🌐
Compose and execute GDAL workflows with pipe-friendly functions.
Learn more: github.com/brownag/gdal...
#RStats #GDAL #Geospatial #OpenSource #RSpatial
Apache SedonaDB 0.2.0 is now available. Download here: buff.ly/k9LRlyC
SedonaDB is the first open source, single-node analytical database engine that treats spatial data as a first-class citizen. It is developed as a subproject of Apache Sedona. #opensource
I taught a 70 person section of intro to computer science and the automated checks were a total godsend. (I also ran out of GitHub Actions minutes almost immediately...)
For the full scoop, check out our release post! sedona.apache.org/latest/blog/...
Finally...we're now on crates.io! We're still learning how to support Rust projects that are interested in spatial support...leave a note on our repo if you're interested!
We were fortunate to have over 40 functions contributed since our last release, but if we didn't get to your favourite you can now patch it in via pyarrow and/or shapely!
On the write side, SedonaDB can now write GeoParquet 1.1 files with spatial sorting and limited row group size to optimize partial reads when hosting or viewing large files.
Just like our GeoParquet suport, if your query contains one or more WHERE ST_Intersects() (or similar), this is automatically pushed into the data source to read as little as possible!
We're proud to officially be GDAL in a trenchcoat! You can now query GeoPackage, FlatGeoBuf, Shapefile, or anything else supported by GDAL/OGR, including URLs, zipped files, directories, and globs.
Excited to announce SedonaDB 0.2.0! Highlights include reading spatial file formats via GDAL/OGR, improved GeoParquet IO, Python @arrow.apache.org UDFs, and 40+ additional functions.
Here are the slides and recordings from our Boston DataFusion Meetup in September:
Youtube: youtu.be/wCAud478Dg8
Slides (pdf): drive.google.com/file/d/18KGH...
At FOSS4G Auckland 2025, we, MIERUNE Inc., had four talks about various topics from GTFS to GeoArrow. This is a quick summary of the presentation titles and the links to the slides🔗
dev.to/mierune/foss...
Wohoo, QGIS Arrow support has been merged: https://github.com/qgis/QGIS/pull/63749
Thanks @paleolimbot & @nyalld et al.
Looking forward to testing it out soon 🤩
#QGIS #Arrow #GISChat
Starring in a few minutes: It’s QGIS Open Day today! 🎉 Don’t miss our two awesome talks. Grab all links and info on the wiki: https://github.com/qgis/QGIS/wiki/QOD-November-2025
#QGIS #GISChat
