A geospatial career journey
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
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
I have addressed the topic of triggered notifications a couple of times on this blog previously. I've taken the opportunity to apply the technique to a current use case - the ability to get notifications whenever the confirmed count of COVID-19 cases changes in my county or surrounding ones. I am basing this workflow on … Continue reading Watching COVID-19 Data for Your County with PostgreSQL and Node
