Adding basemaps to QGIS project

Web based basemaps can provide an excellent context for a mapping project. Map services such as OpenStreetMap and Bing provide tile services that can be used to fill in details such as topography, road networks, hydrography and satellite imagery for a map without having to provide your own set of base features. Quick note on… Read more »

Creating user groups in PostgreSQL

In larger work environments it becomes essential to be able to assign similar permissions to groups of people for the database environment. PostgreSQL has a built in authentication system that easily allows for this. As with the rest of this documentation, this section assumes a PostgreSQL installation on a Debian based Linux distribution. We use… Read more »

Running a remote PostGIS database (Linux)

This document uses Ubuntu 18.10 in conjunction with PostgreSQL 10 with PostGIS. Similar concepts should apply to other installations. It assumes PostgreSQL has been installed with the PostGIS extensions already. Initializing the database to run on server startup Either open the terminal in your Linux server or open an SSH session to your server and… Read more »

Creating PostgreSQL Database for QGIS

QGIS has native support for geospatial databases using PostgreSQL as a back end. PostgreSQL can be fully geospatially enabled using the PostGIS extensions to allow for direct geospatial manipulation within the database itself. Installing PostgreSQL (Windows) As of this writing, the latest supported version of PostgreSQL for QGIS 3.4 is PostgreSQL 10.x. An interactive installer… Read more »

Testing DJI 2.4GHz datalink

Part of my current project involves using a multirotor UAV with a methane detection system to monitor for pipeline leaks in small high pressure distribution lines. I first started getting involved with UAV systems back in 2014 when DJI wasn’t nearly the household name it is now. The Phantom 3 had just come out and… Read more »

Elementary wasn’t so great after all

Well, I know I just posted up a bunch of information on how to set up QGIS 3 and PostgreSQL/PostGIS on Elementary OS Juno, but alas, that’s over. Elementary OS is by far the best looking Linux Distribution (Distro) that I’ve yet used, and I assumed that since it was basically a re-skinned Ubuntu 18.04… Read more »