A geospatial career journey
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
Following up on my previous post, I decided to attempt the same analysis in PostgreSQL. The analysis doesn't make use of any spatial logic itself (yet), but I consider this a PostGIS post because it is using PostGIS geometries. In the past, I have noticed that BigQuery SQL is very reminiscent of that of PostgreSQL, … Continue reading Analyzing Location Change Over Time in PostGIS
I've recently spent a lot of time doing various forms of business analytics in BigQuery. As discussed in a previous post, I've been using BigQuery as the data integration environment for several business systems. I've found integration at the data level via an ETL/ELT/IPaaS pipeline to be a lot more stable than system-level integrations that … Continue reading Analyzing Location Change Over Time in BigQuery
I've been paying more attention to my morning and evening routines the past few months. This started as a outgrowth of my focus on fitness, but has since expanded. Originally, I set out to block out time during my day to ensure that I had time for fitness activities. This usually shows up as an … Continue reading Mornings and Evenings
I'm not normally one to do an end-of-year retrospective, but this has been a fairly unusual year, to put it mildly. This one is a little rambly and touches on a number of topics. The war on cubicle body I ended up doing a lot more running than I had planned. Gyms were closed much … Continue reading Looking Back, Looking Ahead