I few weeks ago, I described an integration I built to pull data from the Stripe via its API and load it into BigQuery. There were two main problems with this approach: First, it was incredibly hacky - a Wile E. Coyote approach to the problem involving cron jobs and EC2 instances and GCS uploads … Continue reading Stripe API Pagination in FME
Tag: GIS
Organizational Muscle Memory
I've had plenty of opportunity to tell my "story" lately. After my initial post that my current position is ending, there has been a pleasantly surprising amount of interest and activity. Others have told me that I shouldn't be surprised, but I feel like I've been fairly heads-down the past six years so it was … Continue reading Organizational Muscle Memory
Turning the Page
It is rare that I use my blog to explicitly blow my own horn. I prefer to write about technology, leadership, and the good works of others, but I find myself in different circumstances now. I learned this week that my current position will be eliminated as of 31 December, 2022. After that, I will … Continue reading Turning the Page
Lessons from Maps and Old Code
Taking over someone else's code is hard. There is probably no better look at how a person thinks than looking at their code. It can be tempting to trash their code and start from scratch. This temptation often runs into conflict with a sunk-cost fallacy that says "The previous person spent so much time on … Continue reading Lessons from Maps and Old Code
Services, Solutions, and Products
Prior to my current role, I spent 25 years working in the federal contracting space. Almost all technology built in that world is one-off and designed for the specific needs of a customer. Often, those needs are complex and meeting them involves creating new technology. "Productizing" a solution is common trope around the Beltway among … Continue reading Services, Solutions, and Products
Give Me a Standard, Any Standard
I've spent the last year or so doing very little with geospatial technology, but I find myself missing it tremendously. Of course "in my blood" and "how I'm wired" and similar aphorisms apply to how I'm feeling, but that's not what really has me missing geospatial. In a shocking (for me) turn of events, I … Continue reading Give Me a Standard, Any Standard
Simple Isochrone Analysis in QGIS
With my MBA program behind me, one of my goals has been to shake the rust off my coding and GIS skills. For this post, I thought I would start simply, just to make sure I remembered how to find my way around QGIS. We recently purchased a plug-in hybrid. It has a 17-mile range … Continue reading Simple Isochrone Analysis in QGIS
SaaS, IPaaS, and Interoperability
I started this blog back in 2006 during a time when I wasn't doing much geospatial work at all. I was working on building a human resources system for a federal government customer who was falling under the then-new and now-defunct National Security Personnel System. Because it was new and sufficiently different from the GS … Continue reading SaaS, IPaaS, and Interoperability
Geography, Geospatial, and GIS
I was participating in a Clubhouse discussion today when someone asked the about the distinction between GIS and geospatial. Since Clubhouse is audio-only, I am paraphrasing by contribution to that particular discussion here. I think the boundaries and definitions of these concepts are pretty blurry and I am reticent to create hard distinctions between them. … Continue reading Geography, Geospatial, and GIS
Reconsidering the Spreadsheet
I'm a CIO. That means a typical day can involve a range of activities: responding to data calls for security audits, reviewing SOC2 reports of prospective platform vendors, managing subscriptions of existing vendors, handling GDPR requests, ensuring data from corporate systems is meaningful and relevant for our internal stakeholders, attending meetings of various sorts. Somewhere … Continue reading Reconsidering the Spreadsheet