Cloud, Ready

As a consultant, I have always placed a premium on the maturity of the technologies I recommend and deploy for my customers. While staying current with innovations, especially in the geospatial space, is a critical part of my work, I believe in letting new technologies develop and stabilize before introducing them into customer workflows. This … Continue reading Cloud, Ready

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)