Producing GeoJSON from SQL, Part 2 (DuckDB/Geoparquet Edition)

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)

Walls and Bridges

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