Building a Simple Geodata Service With Node, PostGIS, and Amazon RDS


This post describes the construction of a simple, lightweight geospatial data service using Node.JS, PostGIS and Amazon RDS. It is somewhat lengthy and includes a number of code snippets. The post is primarily targeted at users who may be interested in alternative strategies for publishing geospatial data but may not be familiar with the tools discussed here. This effort is ongoing and follow-up posts can be expected.

Continue reading “Building a Simple Geodata Service With Node, PostGIS, and Amazon RDS”

Consider the ‘Alternative’

When I was in college, I had a psychology professor who posited that you could train a cat (a dodgy proposition at best) to take a circuitous route to its food bowl by only rewarding that behavior. He was clearly a behaviorist and was convinced that you could completely condition the instinct to go straight to the food bowl out of the cat. To my knowledge, this professor did not own a cat and never attempted to test his assertion.

I was reminded of this after reading my friend Atanas Entchev’s post in reaction to the PostGISDay hangout panel discussion. In his post, Atanas describes difficulty in convincing customers to consider open-source geospatial tools. These customers and prospects are comfortable with their proprietary tools and associated workflows and are reluctant to consider switching. I have encountered this attitude many times myself so I take no issue with the observation. Barriers to exit are real considerations, regardless of the new technology being considered. Organizations align themselves around their tools to achieve maximum efficiency with them. I discussed these issues at a talk I gave last year to the New Jersey Geospatial Forum about how organizations can extend their existing geospatial technology investments with open-source technologies. These issues are very real for any organization with a mature, extended investment in a particular technology stack.

Continue reading “Consider the ‘Alternative’”

GIS Day After

It’s the morning of November 21st, but not for long. You open one eye. Just one; it’s best not to rush such things. Apparently, you finally came to rest in the ball pit you all made using the squishy globes from myriad conferences past. A cursory scan tells you the GIS lab is trashed. It starts to come back to you: the rousing game of “Pin the Certificate on the Khakis.” Yes, there are your pleated khakis on the wall with everyone’s training and GISP certificates stuck on or around them with pushpins. Someone won in what would have been a most painful way if the khakis had been on your body. The loin cloth fashioned from the old hard-copy topos (which you are still wearing). The fact that you let the intern talk you into finally opening a Twitter account and your glee at discovering you could attach photos to geocoded tweets with your BlackBerry.

Continue reading “GIS Day After”

Desktop Not Dead

In 2011, I gave a talk at the NCGIS conference about the continued dominance of the desktop in the world of GIS. In that talk, my main point was that, regardless of the ultimate destination of GIS data or maps (cloud, server, paper, PDF, etc.), most GIS data passes through a desktop GIS at some point. I don’t have hard data to back up that claim but I think anyone who has worked in the industry for any length of time will agree that it feels right. If we loosely define “desktop GIS” to include not only GUI analytical tools like ArcMap or QGIS, but also command-line tools such as GDAL/OGR and cartographic tools such as TileMill, I think the statement is even more comfortable.

Continue reading “Desktop Not Dead”

WeoGeo: Now With GeoJSON

It’s great news that the government shutdown is finally over. Many of our colleagues across the geospatial industry can now report back to work, ending a another stressful period for them. During the shutdown, many stepped up to try and fill the gap left by shuttered government web sites that would normally distribute geospatial data.

Continue reading “WeoGeo: Now With GeoJSON”

Maryland Department of Planning Bundles Property Data With QGIS

This past week, I got an e-mail from Jim Cannistra, Director of Data Planning Services and the Maryland Department of Planning (MDP), alerting me to a new product available from MDP called FINDER Quantum. This product bundles Maryland property data and related products with QGIS software to provide users with a fully-functional, free-standing system for interacting with the data. It is designed to replace an older, custom software product, capitalizing on an industry-standard open-source system.

From the MDP site, the bundled data includes:

Continue reading “Maryland Department of Planning Bundles Property Data With QGIS”

Come Sling Code With Us

It’s been a pretty good week for us at Zekiah. We announced two new contract wins and I’m pleased to say that we’re not done yet. After final paperwork is done, we should be able to announce a couple more. These are the things that make small-business ownership worthwhile: doing good work, building relationships with our customers and then leveraging our track record to be able to work with new customers. Project execution and business development help us build the foundation necessary to be a good place for our employees to work and we try hard every day to make sure that we are such a place.

Continue reading “Come Sling Code With Us”