Bill Dollins

@geobabbler.bsky.social

Runner. Coder. Database hacker. Accidental geographer. Perpetual novice. Chaotic neutral.

We saw Young Washington a couple of weeks ago. My wife is a US history teacher so it was a must-see for us. A couple of notes: 1) it generally got the history right. Washington was a bit of a mess then and they didn’t polish it. 2) King George County, VA does not look like that at all.

50 years ago this weekend, I was at the Bicentennial Air Show at Andrews AFB. My dad pulled some strings and we were let past the rope so I could sit in an SR-71. I was too young to understand but it was cool. I wish 250 had been more, but I’m looking forward to Election Day.

Turns out the best way to do research is to do research. Taking page from my grad school experience during the pandemic, I have forced myself into the habit of writing term papers when learning new concepts. blog.geomusings.com/2026/06/05/o...

On Essays

A few weeks ago, I was on a catch-up Zoom call with a friend I hadn’t chatted with in a while. He made mention of the recent uptick in my blogging activity and then, very good-naturedly, took…

blog.geomusings.com

In part three of my anniversary series, I look at the constant iteration of the geospatial stack over 20 years, the opportunity costs of that iteration, and the responsibility conferred by the technical capability achieved over that time. blog.geomusings.com/2026/05/28/t...

Twenty Years, Part Three

I recently finished implementing a network analysis through PostGIS and pgRouting, exposed through an MCP interface so it can be called by AI. I have done versions of this as a Lambda and as a Goog…

blog.geomusings.com

Open data was built to be used, but AI-scale consumption is changing the equation. Using OSM as a thought experiment, I explore what AI-optimized infrastructure that preserves openness, attribution, community values, and operational sustainability may look like. blog.geomusings.com/2026/05/14/o...

Open Data and AI

Open data projects are seeing a new kind of consumer in the form of automated systems that can consume public data continuously, at scale, and through access patterns that were not designed with th…

blog.geomusings.com

I had a dream last night that I was stopped at a traffic light when a car pulled up next to me. Its windows were down and it was blasting “Lifestyles of the Rich and Famous” by Good Charlotte. This is not a big song for me but it’s now stuck in heavy rotation in my head. Damn subconscious.

The phrase "generate a CSV formatted for easy import into Postgres" is magic with Claude. Even if you don't plan to use Postgres, it gives you a nicely cleaned up CSV. I usually also ask it to make a metadata markdown file to preserve richness it may need to strip out.

originalprocessedmetadata

Spatial finance can see assets, hazards, emissions, and exposure with increasing precision. But places are also shaped by institutions, memory, liability, politics, and trust. This post looks at what spatial finance cannot yet see from orbit. blog.geomusings.com/2026/04/28/w...

What Spatial Finance Cannot See From Orbit

For eighteen years, I drove past the Morgantown Generating Station on my way to work. Its stacks were part of the background geography of my daily life, sitting along the Potomac River in Newburg, …

blog.geomusings.com