Posts

About a year and a half ago I wrote a post on “wrangling” and joining 130 million points using various open source tools. Shortly thereafter I joined Wherobots where I get to spend most of my time building SedonaDB, a tool purpose-built to make exactly that sort of wranging and joining effortless.

With apologies for skipping the last 18 days…it’s day 24 of the 30 day map challenege and I’m back! In my first post about SedonaDB I did a brief investigation into the least creatively named waterbodies in Nova Scotia based on the water segments data in Nova Scotia.

Day 6 of the 30 day map challenege is Dimensions, and when I read the prompt I immediately thought: I have to do something with M values. M values, you say?

It’s day 5…earth! I was particular excited about this day in the 30 day map challenege because earth is my thing…I did a M.Sc. in Geology and taught Geomorphology at Acadia University for several years.

Day two of the 30 day map challenege is lines! A few weeks ago I wrote a post about stream traversal with SedonaDB. For day two I’ll do this with the river system for Gaspereau Lake (starting at the mouth of the beautiful Gaspereau River!

Day one of the 30 day map challenege is points! One of the datasets I use all the time in testing is named ns-water_point from GeoArrow Data. When I made this test data I didn’t think very hard about it…the Nova Scotia Geospatial Data Directory has a hydrological section and I spent the better part of a decade there working on lakes…it seemed like fun!

I’m an obvious fan of GeoParquet and SedonaDB and it should be no surprise that I worked (still working!) pretty hard making sure SedonaDB could take advantage of all GeoParquet had to offer.

Last week I had the pleasure of being a guest on a Cloud Native Geospatial webinar with my colleagues Jia Yu and Matt Forrest where we talked SedonaDB. In the webinar Matt demoed a fantastic blog post comparing a real-world workflow on SedonaDB, DuckDB, and PostGIS.

Last Wednesday the Apache Sedona project announced SedonaDB. There’s also a great post on the Whereobots blog that has a bit more context, or if you’re like me and you just want to see the code you can do that too.

One of the most fun parts of being involved in GeoParquet is that I get to hear about all the amazing tools that people are writing to scale geospatial analysis above and beyond what the stack I’m familiar with can handle.