Alex Urquhart
Geomatics Professional

What I'm Thinking

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

Deploying My Site With Gogs

Published on: 31 May 2016
As I’ve written about before my current blog is a static site generated with Hugo. Being a static site, with no dependencies it is incredibly easy to set up a method to deploy your site using git push. An in-depth article on this workflow was published by DigitalOcean and is what my method has evolved from over the past few months. I recently installed Gogs, or “Go Git Service”, which is a lightweight, self hosted GitHub clone that I will be using to host my personal projects that I don’t want to share with you fine people. ... Read More