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

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

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

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