A geospatial career journey
I've been integrating pg_webhooks into some project work lately. Conversely, I have not been using n8n much, but a vendor rep used it in a demo of some workflow automation capabilities for a platform one of my customers is using. I had dabbled with it about two years ago but haven't done much with it … Continue reading Using pg_webhooks with n8n – A Simple Example
FOSS4G North America was an opportunity for me to reconnect with both community and technology. I enjoyed being able to both learn new things and refresh my skills with technologies such as PostGIS. I was reflecting on how, a couple weeks prior to the conference, I introduced the concept of PostgreSQL window functions to a … Continue reading Window Functions and PostGIS
FOSS4G North America (FOSS4GNA) wrapped up yesterday, closing out with another thought-provoking keynote by Paul Ramsey. Paul’s talks on the “economics of open source” have evolved over the years and, while this talk certainly discussed such economics, it was so much more. Paul is one of the best speakers you will see and his talks … Continue reading Initial Thoughts on FOSS4G North America
One of the first tasks I ever had in my then-new GIS career was doing AML development in ARC/INFO 6.x for a data production project. My code parsed DXF exported from AutoCAD R11 for DOS and then assigned attributes based on things like layer, color, line weight, feature type, and others. It also georeferenced the … Continue reading Data Over Software
Last week was a good week. Given that I was on vacation with my family in Florida, that statement is pretty much a given, but it was still of note. This vacation was our annual week in South Florida at a timeshare we've had for years. I have often worked some portion of the week … Continue reading Changes In Latitudes…
Technical Controls - The security controls (i.e., safeguards or countermeasures) for an information system that are primarily implemented and executed by the information system through mechanisms contained in the hardware, software, or firmware components of the system. Organizational Controls - The security controls (i.e., safeguards or countermeasures) for an information system that primarily are implemented … Continue reading Balancing Organizational Controls and Technical Controls in Data
PostgreSQL's NOTIFY/LISTEN method for subscribing to events from a database is a subject I return to periodically. I've touched on it in one form or another over several years. My latest run at it involves building a Node Express application that will allow external systems to subscribe to webhooks that are fired by NOTIFY statements … Continue reading A Simple Webhook Interface for PostgreSQL NOTIFY
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
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
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