Alex Urquhart
Geomatics Professional

What I'm Thinking

SSH Port Forwarding Made Easy

Published on: 13 February 2018
Have you ever wanted to access a resource on a remote server from your home computer? The standard ssh utility includes a feature called tunneling, or ssh port forwarding that can help you accomplish this. It’s a useful tool if you want to connect to a remote e-mail server, database, or application server. Personally, whenever I’ve wanted to do this I always end up googling the flags and parameters I need to use. ... Read More

Set Up a PostGIS Database With Docker

Published on: 29 October 2017
For GIS users who haven’t heard of PostGIS: PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. In this tutorial post we’ll cover how to install and run a PostGIS database on Windows using Docker, a popular containerization platform. We’ll then connect to the database and use it in both QGIS and ArcGIS Pro. ... Read More
Web AppBuilder for ArcGIS is a browser-based tool that enables end-users to create interactive mapping applications using their own data. The Developer Edition of Web AppBuilder provides a framework for developers to create custom themes and widgets for Web AppBuilder using the Dojo Toolkit and the ArcGIS API for JavaScript. Anybody who has worked with the Dojo toolkit for any length of time knows that creating custom Dojo widgets is a less than pleasant experience. ... Read More

Backing Up and Transferring Your Reddit Account

Published on: 29 January 2017
I started doing a basic experiment with the Reddit API in May 2016. I was initially interested in working with web-based OAuth2 authentication, which I hadn’t done before, so I started hacking away using Flask, PRAW, and SQLAlchemy. There was really no set goal, I just wanted to experiment with extracting data from my account and displaying it on a webpage. It later dawned on me that if you have had a Reddit account for awhile and have saved a few hundred different items, that there is no readily available tool to extract that and back it up somewhere. ... Read More
Over the winter my girlfriend and I got a place together, and I wanted to create a nice map to put up on our wall. I decided to make a project out of it. Since I started learning about GIS in 2011 I had only read the odd news article or experimented once or twice with QGIS, a free and open source GIS suite. For school and work I had exclusively used ArcMap, so trying out and getting used to the many differences in QGIS was a lot of fun. ... Read More