Posts

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.

https://mosaico.io/


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
4.psql -h localhost -U USER_NAME_HERE DATABASE_NAME_HERE

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

DATABASE_NAME_HERE=>

To exit type:-

\q

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 po…

OpenDroneMap Revisited - and the Results are Impressive

Image

Using GDAL Tools to Convert Drone Imagery and Orthomosaics to Google Map...

Image

Fairphone 2 - Hands On Review

Image

How to easily install Ubuntu on your Fairphone 2

Image

Important GIS Application Areas

Looking for a GIS application area to work in? I stumbled across this page today. Now let your ideas flow!.

http://grindgis.com/blog/gis-applications-uses