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
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 se…
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 true that these don’t come up as often as Z, but many spatial specifications o…
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. While my first thought was mapping be…
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 Direc…
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. This post talks about one of those things: lazy
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 Sedo…
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. I’ve been a sparse blog p…
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. GeoPandas (Python…
There’s a great discussion going on in the GeoParquet repo about how exactly to split up GeoParquet datasets for optimal querying. This post is my adventure giving the partition strategies a shot for practicality. All things are possible wi…
Using an organic carbon removal data set (n = 500), we compared a physically based semiempirical coagulation model (Langmuir sorption-removal) and three ML modeling methods using quantitative (model performance) and qualitative (model inter…