This question comes up more frequently than I would expect. I've been writing here since 2006 and this blog is a good map of my professional journey over that time. Most often, when people ask me the titular question, they are wondering how I can keep this up for so long. Less frequently, the question … Continue reading How Do I Write?
Tag: GIS
Window Functions and PostGIS
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
Initial Thoughts on FOSS4G North America
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
Data Over Software
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
Changes In Latitudes…
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…
Balancing Organizational Controls and Technical Controls in Data
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
TUgis Wrap-Up
Earlier this month, I attended TUgis, Maryland’s annual GIS conference. It was my first time attending since I gave the keynote address in 2017. That was due primarily to the conference being moved to early August - a reasonable adjustment due to the fact that the venue is always Towson University and the new timeframe … Continue reading TUgis Wrap-Up
A Few Updates to pg_webhooks
At the time of my last post, there were a few outstanding issues that I wanted to address in the code of pg_webhooks. I've addressed three of them this week. There wasn't actually a route to unsubscribe from a channel, so I added that shortly after the initial release. Another key shortcoming was that the … Continue reading A Few Updates to pg_webhooks
A Simple Webhook Interface for PostgreSQL NOTIFY
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
New Directions
Since the first of the year, I've been on my own. After considering a number of really compelling job offers, I decided to start my own company and take a contract position with company doing work that's meaningful to me (more on that in the future). I'm also picking back up with some GIS work … Continue reading New Directions