Converting a String Field to a Numerical Field in QGIS

Numerical data saved as a string in a PostGIS table column needs to be converted to a numerical data type to be properly analyzed. Below is a process by which to convert string data to real numbers in QGIS. Open the layer with the improper string column in QGIS, and toggle editing mode by selecting […]

Translating Vector Geometries

Translating geometries involves displacing vector data using a pre-defined offset distance from the current position of the data. In this case, we will be using this data to alter UAV flight paths (vector line data). This will involve shifting the paths to the East, West, North, or South, depending on the orientation of the flight […]

Adding Mapbox Tiles to QGIS 3.4

Mapbox has an excellent tiling service that has both a ton of basemaps and an easy-to-use mapping system for web applications. It is possible to use their tiles in QGIS as a basemap. The steps are relatively simple and will be covered below. Create a Mapbox account by going to www.mapbox.com. Login in and create […]

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 […]

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 […]

Logging in to PostgreSQL database on Linux terminal

This section assumes command line access to the PostgreSQL server from a terminal window. The server used in this section is running Ubuntu Linux 18.10. To Log into your user account in the database: psql -U <postgre username> -d <dbname> Logging in to root PostgreSQL user account If you are the database administrator and need […]

Changing user access permissions on PostgreSQL schemas

This section assumes command line access to the PostgreSQL server from a terminal window. The server used in this section is running Ubuntu Linux 18.10. Once logged into the terminal either locally or over SSH, log in as the root database user “postgres” by typing: sudo -i -u postgres Or if you don’t have access […]

Importing Common Static Data to QGIS

Importing Static Data to QGIS This section will focus on basic importing of static geospatial data to QGIS project files for use. This will not cover the use of PostGIS or PostgreSQL for data management. Common standard files types will be included. Adding Favorite Directories QGIS allows the user to add ‘favorite’ directories to the […]

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 […]

Getting Started with QGIS – Windows and Linux Installation

This post will focus on the basic installation and implementation of QGIS Desktop software on both Windows and Linux based systems. Installing QGIS: Windows Follow the steps below to install QGIS on Windows systems. This includes Windows 7, 8, 8.1, and 10. Navigate to https://qgis.org/en/site/forusers/download.html in your browser to find the downloads page for various […]