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 … Read more

Open – Beyond Technology

I am currently reading the book “Fierce Conversations” by Susan Scott. I am on hiatus from teaching my leadership course this year, so I am taking the opportunity to refresh my content and my perspectives. The basis of the book is fairly simple:

Our work, our relationships, and our lives succeed or fail one conversation at a time. While no single conversation is guaranteed to transform a company, a relationship, or a life, any single conversation can.

Susan Scott, Fierce Conversations: Achieving Success at Work and in Life One Conversation at a Time

This has gotten me thinking in general about conversations that have impacted me throughout my career, whether with colleagues, direct reports, supervisors, customers, or mentors.

Recently, I had an interaction on Twitter that got me thinking about a long-ago conversation in a different context that, although I had never thought much about it, had an effect on how I view the role of technology in solving problems. That Twitter interaction is here:

Read more

SpatiaLite for Android Available

On what seems to be turning into SpatiaLite Monday, Sandro Furieri also announced on the SpatiaLite Google Group the availability of a stable version of SpatiaLite for Android. I am happy to see that this version was developed and contributed back by the US Army Geospatial Center. The fact that they contributed back to the … Read more

Personal Geospatial Workflows

I’ve had a couple of people ask me recently about the geospatial tools I use. Year-over-year, that answer changes but here’s how I answer that right now:

As a Federal contractor, I spend a lot of time working with the Esri stack during my work day. A few years ago, I added a few open-source geospatial tools into my tool set and, since then, have also done a respectable amount to consulting work them as well. The balance between the two varies over time, depending on the requirements of individual customers and projects. Lately, commercial customers have seemed much more interested in open-source tools while my government customers are sticking with Esri. Since those observations are based on the the extremely heavy filter of my own recent experience, I’d be hesitant to draw any larger conclusions from them.

I’ve always believed that proficiency with a wide range of tools makes me a better consultant and integrator, so I am always exploring and trying new things. With those commercial customers, and in my own personal side projects, my recent workflows have gelled around a core set of tools, both commercial and open-source:

Read more

Wilson Center to Discuss FCC National Broadband Map

One of the most compelling recent success stories for open-source geospatial tools in the Federal Government has been the Federal Communications Commission (FCC) National Broadband Map initiative. It has been a very visible example of the stability, scalability, flexibility, and power of open-source geospatial tools. The Woodrow Wilson Center will be hosting a case study … Read more

ToGeoJson and ToWKT for the Esri FGDB API

In support of some of our ongoing PIM work, we’ve been integrating the Esri File Geodatabase (FGDB) API into some tools. Without going into a level of detail that would hijack this post, one of the many functions performed by some of the tools is to validate physical spatial databases against established data models to analyze compliance and identify differences. These databases may be in Esri or non-Esri formats and we have traditionally handled Esri geodatabases through ArcObjects since it provides a relatively uniform interface across the various flavors of geodatabase.

Of course, ArcObjects requires an ArcGIS license of some sort and we are finding out that this is not always available to users in the field under many situations so the FGDB API gets past that for file geodatabases, at least.

Read more

Favorite QGIS Resources of the Moment

I’ve been dabbling more with Quantum GIS (QGIS) lately. I’m not doing anything particularly sophisticated but it’s a great viewer for some data types (SpatiaLite, GeoJSON) that aren’t supported by my commercial desktop GIS so it’s helping me validate outputs of some applications I’m writing.

While I’ll never be a real cartographer, I am interested in doing a little more. Here are the resources that have been helping me the most lately…

Read more

CartoDB/Leaflet Sample Update

A while back, I posted about some experimentation I did with Leaflet and CartoDB in the wake of FOSS4G in Denver. I recently had the chance to go back and update that sample with some spatial queries. At the time of the original post, CartoDB was still in beta and spatial queries didn’t seem to work, despite the fact that the back-end was driven by PostGIS.

Read more

Planet PostGIS Online

Planet PostGIS, an aggregation of PostGIS-related blog content is now online. As the name suggests, it is built using the same technology as James Fee’s Planet Geospatial but is focused on content related to PostGIS.

If you are working with PostGIS, whether as part of an open-source stack or in conjunction with proprietary tools such as ArcGIS, you may want to check out Planet PostGIS.

Thanks to Regina Obe and everyone involved in setting this up.