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
Tag: GIS
Attribute Transfer in PostGIS Using Spatial SQL
Data conflation is a meat-and-potatoes task in most GIS workflows. There are numerous reasons one might need to get data from one data set into another. Perhaps you want to attach a new geometry type to existing attributes or a table. Or maybe you need to pull attributes from one or more data sets into … Continue reading Attribute Transfer in PostGIS Using Spatial SQL
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
Fulcrum Query API and Koop
I don't write code as much as I used to, but I have to return to it every so often to keep my sanity. With the current world situation, there are a lot of dashboards going up, many of which are based on the Esri Operations Dashboard or ArcGIS Hub. I got thinking about a … Continue reading Fulcrum Query API and Koop
Milestones, Goals, and the Power of No
It’s been a few weeks since I hit my latest milestone, but life was fairly full in the immediate aftermath. On the plus side, the extra time was good for reflection. The milestone to which I am referring is that, on October 27, 2019, I ran the Marine Corps Marathon in Washington, DC. The race … Continue reading Milestones, Goals, and the Power of No
Ron Lake – The Man In the Arena
It is not the critic who counts; not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood; who strives valiantly; who … Continue reading Ron Lake – The Man In the Arena
Hello, Discipline, My Old Friend
It wasn't that long ago that I was "always on" in terms of work. There is a certain ethos in the DC area that rewards that outlook and I was fairly good at it. This was compounded by the fact that I was a partner in my company and the buck always stops with the … Continue reading Hello, Discipline, My Old Friend
Evolution and Leadership
Catching Up with Microsoft
The One About PostGIS