A geospatial career journey
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)
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
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
As I was building a Python notebook in Databricks, I started thinking about how much Python work I’ve been doing since I went out on my own. That got me thinking about all of the SQL I had been doing the last couple of years at my previous role, then the Javascript before that and … Continue reading Rings In a Tree
I spent the past couple of days at the Esri Federal GIS Conference, still referred to by many as the “FedUC,” in Washington, DC. The primary reason I went was to attend some customer meetings. The FedUC draws many people (6,000 in this year’s case) from around the country and it’s a convenient place to … Continue reading In HIFLD, a Lesson
On March 1, 2024, ArcMap will transition into “mature support.” This means it will stop getting patches and updates. While ArcMap is not scheduled to be retired until 2026, the lack of patches and updates is the death knell for any modern software. At a minimum, many IT shops will begin to uninstall it simply … Continue reading Pour One Out for ArcMap
William Dollins bill@dollins.nethttps://www.linkedin.com/in/billdollins/ Executive SummaryMr. Dollins an accomplished technology executive with over two decades of leadership experience in geospatial information systems (GIS). He has a proven track record of building and leading high-performing cross-functional teams, managing spatial data infrastructure, and developing strategic GIS initiatives that align with organizational goals. His expertise extends to GIS databases, software, … Continue reading My Resume
One of the first tasks I ever had in my then-new GIS career was doing AML development in ARC/INFO 6.x for a data production project. My code parsed DXF exported from AutoCAD R11 for DOS and then assigned attributes based on things like layer, color, line weight, feature type, and others. It also georeferenced the … Continue reading Data Over Software
Earlier this month, I attended TUgis, Maryland’s annual GIS conference. It was my first time attending since I gave the keynote address in 2017. That was due primarily to the conference being moved to early August – a reasonable adjustment due to the fact that the venue is always Towson University and the new timeframe … Continue reading TUgis Wrap-Up