Wednesday, 18 October 2017

The Grass GIS Story - 1987 Video

I've attached the improved quality video master recovered recently. Also... somewhere i can get hold of it to remind me how GIS looked back in '87'.

The older version is still on YouTube:-

The original archived version here:-

Jeff McKennas' FOSS4G 2014 Presentation here:- 

Download Large Video (179.1mb)
Download Small Video (92 mb)

Friday, 22 September 2017

FOSS4GUK 2018 Announcement

Just been announced. Missed the last two UK events...wont be missing 2018 if i can help it!

"The FOSS4G UK will be taking place on the 8th and 9th of March at the 
Geovation Hub, London! The event will be similar to FOSS4G 2016 which 
happened in Southampton, probably with some changes allowing for the 
difference in venues and room sizes. I will be chairing the 
committee along with Tom Chadwin as co-chair".

Thursday, 17 August 2017

IoT and the Move to Open Source GIS

I wanted to make reference to this very thoughtful 'Directions Magazine' article penned by Andy Dearing of Boundless Spatial Inc. Please follow link below.

Tuesday, 20 June 2017

Open Source Email Template Builders

Not strictly a GI post but i think 'Mosaico' is worth a mention if you are creating and sending email templates regularly reporting on the projects your working on or any other marketing material and you need to be sure they scale on all devices. Unlike 'MailChimp' or 'BeeFree' it's open source. Have a look.

Wednesday, 31 May 2017

How to install Postgresql-9.6 and PostGIS-2.3 on Ubuntu 17.04 (Zesty Zapus) in six easy steps (updated 31-05-2017).

Install Ubuntu 17.04 (Zesty Zapus)

1. check your Ubuntu version:-

lsb_release -a

Install Postgresql

2. On the server or your PC (Terminal):-

sudo apt-get update
sudo apt-get install -y postgresql postgresql-contrib

Create a database and a user for access

Replace DATABASE_NAME_HERE and USER_NAME_HERE with the values you want to use.
# this will prompt you for a database password...also note the capital letter 'O' not number '0' (zero) below:-

3. sudo -u postgres createuser -P USER_NAME_HERE
sudo -u postgres createdb -O USER_NAME_HERE DATABASE_NAME_HERE

Test Connection to Postgresql


Postgresql will ask you for your password. Then you should see the following:


To exit type:-


To add PostGIS-2.3 support to the database

5. sudo apt-get install -y postgis postgresql-9.6-postgis-2.3
# typing 'postgresql-9.5' instead of postgresql-9.6 above will fail.

sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;" DATABASE_NAME_HERE

6. Finally... install PgAdmin3 and set your 'service' connections

 sudo apt-get install pgadmin3

My thanks to Jon Saints for his original post dated from 13th August 2014 (for Ubuntu 14.04)

Featured post

Qgis-server...Installing the QGIS Lizmap Plugin & Lizmap Web Client

This post follows on from my previous three (most recent first in list) linked below. There is no doubt that in just a short time from no...