Ryan Cooper

We just published a deep dive on spatial joins in DuckDB by @maxxen.bsky.social.

In this blog post, Max explains how spatial joins evolved in DuckDB and how the current operator harnesses R-Trees.

Read the full post at duckdb.org/2025/08/08/s...

08.08.2025 15:24 — 👍 49    🔁 12    💬 0    📌 1

I imagine it will be lower, less diverse turnout, but still reasonably high. Speaking personally, our contingent (US-based, public school district) had to back out due to budgetary uncertainty stemming, in part, from DOGE’s actions.

06.05.2025 16:49 — 👍 1    🔁 0    💬 0    📌 0

GeoFeeds Is Online I've missed Planet Geospatial. I've missed it so much that I messaged James the other day and said we should get it going again. He wholeheartedly agreed and then started going on about perfectly valid stuff like not wanting to wrestle with 15-year-old Python 2.x code and such. So I built something in Node. Blogs (and I'll lump Substack into that category) are where the good stuff happens, but they are so scattered in 2025.

GeoFeeds Is Online

I've missed Planet Geospatial. I've missed it so much that I messaged James the other day and said we should get it going again. He wholeheartedly agreed and then started going on about perfectly valid stuff like not wanting to wrestle with 15-year-old Python 2.x code and such.…

13.02.2025 22:45 — 👍 8    🔁 5    💬 1    📌 0

QGIS Atlas by Field This post explains how to use the Atlas function in QGIS to automate the production of maps from a single layer in order to produce a map o...

This is pretty awesome. From this post about using QGIS' atlas function on attributes rather than a spatial index, I figured out how to apply it to a rule-based visualization. Make your "field" rules, then put the eval statement in the rule-based viz dialog.

www.statsmapsnpix.com/2019/01/qgis...

12.02.2025 00:04 — 👍 14    🔁 1    💬 1    📌 0

We have both. AGOL is for items that need to be shared outside the firewall. Enterprise is deployed internally. We’re mostly adding Enterprise users. Most users need Viewer level access and those are unlimited on Enterprise vs $125 per user on AGOL.

05.02.2025 01:54 — 👍 2    🔁 0    💬 0    📌 0

Koop Koop - an open source geospatial ETL engine

Koop is an option. There are a couple plugins for connecting to Postgres. It basically translates your tables into a FeatureService.

koopjs.github.io

22.01.2025 16:16 — 👍 2    🔁 0    💬 0    📌 0

If you haven’t, I suggest getting in writing your recommendation against giving this person admin rights and having whoever is responsible confirm they are overriding your recommendation.

14.01.2025 20:27 — 👍 2    🔁 0    💬 1    📌 0

From one AGOL admin to another, I just want to reassure you your instincts on this are correct. This is a bad call. Sorry you’re having to deal with this when there are better, safer solutions already baked in to AGOL

14.01.2025 20:10 — 👍 3    🔁 0    💬 1    📌 0

Hello #GISChat. I'm giving a presentation to the Illinois Surveyor community in Feb. My intention is to show how many disciplines that GIS covers outside Parcels & Lot Lines. It would be great if you could take this short questionnaire and pass it along to your own GIS network. arcg.is/1fDb0K

30.12.2024 21:33 — 👍 3    🔁 1    💬 0    📌 0

Good observations! Looking at the executive summary it doesn’t break down the results into much detail. I think breaking it down by career stage would be interesting. Less convinced that title would reveal much since (imo) there isn’t much uniformity in how different employers apply GIS job titles

17.12.2024 22:06 — 👍 1    🔁 0    💬 0    📌 0

Map of cumulative sketches of North Carolina’s border

Totally get the nostalgia here. That era of web mapping was so fun! Seems it kinda died with CARTO and Mapbox getting VC funding. So glad Mapzen’s quirky, innovative work is still around and usable as open source software. I actually used Tangram recently to get blend modes in a Leaflet map.

16.12.2024 02:47 — 👍 2    🔁 0    💬 0    📌 0