A geospatial career journey
Yesterday evening, I had the pleasure of participating in a panel discussion on Clubhouse, hosted by Todd Barr and Jordan Cullen, and including Will Cadell of SparkGeo. Clubhouse seems to be a really convenient venue for setting up such a forum with low barriers to entry, so that was enjoyable. The topic of the discussion … Continue reading Return on Non-Investment
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
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
These are some of the things I've been up to lately, while the blog has been quiet: At work, I've continued delving into BigQuery. Our FME jobs are running like clockwork and I've been spending a lot of time writing queries and doing analysis for various stakeholders across the company. The next phase of the … Continue reading Lately…
More often that not in my current role, opportunities to get my hands dirty come from the data side of our operation rather than the engineering side. These days, the data side involves corporate data rather than a lot of geospatial data. If I were to be guided by my own personal inertia, I'd drift … Continue reading FME, Salesforce, and BigQuery
All hail the mighty water cooler - the oft-praised bastion of corporate culture, where the strategies of organizations great and small are made or destroyed in the hushed tones of whispered conversations among those who gather for daily hydration. By now, everyone who can has been working remotely for several weeks. Companies are starting to … Continue reading Your Culture Will Adjust