A geospatial career journey
This week, I had the opportunity to attend OGC@30, the celebration of the 30th anniversary of the founding of the Open Geospatial Consortium (OGC). The early 1990s were the very beginning of my professional career and they were also a time of geospatial innovation. Many of the pioneers from that time, including OGC founder David … Continue reading Thirty Years of OGC
I recently had the opportunity to help organize last week’s inaugural DMV GIS Day, a virtual event hosted by New Light Technologies (NLT) that brought together geospatial professionals and enthusiasts from across the D.C., Maryland, and Virginia region. It was an inspiring reminder of the innovation and collaboration that define our field and our region. … Continue reading Reflections on DMV GIS Day 2024
A few months ago, I wrote a post about how to generate GeoJSON feature collections using pure SQL in PostGIS. After attending FOSS4GNA and learning more about GeoParquet and DuckDB, I wanted to modify the approach to use those tools. What is DuckDB? It is an in-process SQL database management system designed for fast analytical … Continue reading Producing GeoJSON from SQL, Part 2 (DuckDB/Geoparquet Edition)
My last post offered a bit of a survey course on my experience at FOSS4GNA in St. Louis. I have a few aspects of the conference I want to unpack and it may take another post or two to accomplish that. For me, personally, the experience of helping to organize FOSS4GNA, then attending and reconnecting … Continue reading Reflecting on My FOSS4GNA
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
In the 18+ months since I stepped back into the world of geospatial consulting and services, one of the most striking things I have noticed is the seemingly increased tribalism in the geospatial space. Maybe I shouldn’t be surprised, given the increased tribalism of society in general, but that’s a different post that won’t get … Continue reading Walls and Bridges
I had a project over the summer that required me to do a deep dive into various concepts around AI. Approximately 200 academic papers later, I came away with a laundry list of things I wanted to try. I am primarily interested in the capabilities of LLMs, but I am not particularly interested in the … Continue reading Experimenting with RAG Using ChatGPT and DuckDuckGo
At FedGeoDay in April, I attended a workshop conducted by my friend Steve Pousty on the use of vector databases. Steve is a great teacher and I learned a lot that day. I’ve been on a bit of a journey since. I’ve gotten some project work with AI and I find vector databases to be … Continue reading Image Similarity with PgVector
As I mentioned earlier this year, I spend a lot of time working in Python these days. More and more, my work seems to be about performing geospatial tasks with the minimal amount of geospatial dependencies possible. My most recent work has been generating contours from a set of sampled elevation points. I’ve done this … Continue reading Just Enough Geospatial
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