BigQuery and Koop

As I continued my experimentation with BigQuery, I found myself wanting to more easily use it with my regular GIS tool set. BigQuery has a lot of powerful analytic capability, but the SQL console is intimidating for the casual user and the GeoViewer tool is fairly limited. As I began digging deeper in my previous … Continue reading BigQuery and Koop

Routing with BigQuery and ArcGIS Platform APIs

This post is a continuation of last month's post about analyzing location change with BigQuery. At the end of that post, I was already thinking of ways to extend the analysis and visualization. I decided to take the opportunity to explore Esri's recently-announced ArcGIS Platform APIs. These APIs are the same that have been available … Continue reading Routing with BigQuery and ArcGIS Platform APIs

Watching COVID-19 Data for Your County with PostgreSQL and Node

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