A geospatial career journey
One of the advantages of writing a blog for nearly twenty years is that you can go back and see how some of the things you wrote about have held up over time. Suffice it to say there are a number of posts that tempt me to hit the delete key. There were times when … Continue reading “Post GIS” Revisited
I've been doing more (a lot more) with Claude Code lately. With its subagents and skills features, it's become more customizable and powerful. I can really dial it into doing things the way I want them done, which accelerates my development and quickly gets me to where I am focused on important behaviors, rather than … Continue reading Spatial Analysis with Claude Code
For the past two years, have been working with a fiber-to-the-home (FTTH) provider supporting various data architecture and geospatial activities. This is a classic infrastructure business that cycles through phases of design, construction, and maintenance as the built environment changes. This leads to a lot classic GIS editing over time - which can mean the … Continue reading GeoParquet Backup and Restore
I flew home from St. Louis yesterday, returning from the FOSS4G North America conference. I took a different approach to the conference this year than I did in 2023. Rather than moderate sessions and participate in a lot of on-site logistics, I sat in on more sessions so I got to see a lot more … Continue reading A FOSS4GNA Savasana
A couple of weeks ago, I had a need to return GeoJSON from PostGIS. This is something I've done many times, but I usually do the final formatting in the application/API layer with Javascript or Python. Basically, my workflow has been to SELECT, using the built-in ST_AsGeoJSON function to convert the geometry to GeoJSON. I … Continue reading Producing GeoJSON with SQL