Monday, 26 November 2018

How to install Postgresql-10 and PostGIS-2.4 on Ubuntu 18.04 LTS (Bionic Beaver) in six easy steps (updated 26-11-2018).

Install Ubuntu 18.04 LTS (Bionic Beaver)


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.4 support to the database


5. sudo apt-get install -y postgis postgresql-10-postgis-2.4


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)
http://www.saintsjd.com/2014/08/13/howto-install-postgis-on-ubuntu-trusty.html
http://www.github.com/saintsjd
http://facebook.com/saintsjd

Finally...you can check your terminal output with the one below:-

:~$ sudo apt install -y postgresql postgresql-contrib
[sudo] password for xxxx:
Reading package lists... Done
Building dependency tree     
Reading state information... Done
Suggested packages:
  postgresql-doc
The following NEW packages will be installed
  postgresql postgresql-contrib
0 to upgrade, 2 to newly install, 0 to remove and 27 not to upgrade.
Need to get 11.6 kB of archives.
After this operation, 127 kB of additional disk space will be used.
Get:1 http://gb.archive.ubuntu.com/ubuntu bionic/main amd64 postgresql all 10+190 [5,784 B]
Get:2 http://gb.archive.ubuntu.com/ubuntu bionic/main amd64 postgresql-contrib all 10+190 [5,796B]
Fetched 11.6 kB in 0s (101 kB/s)             
Selecting previously unselected package postgresql.
(Reading database ... 399415 files and directories currently installed.)
Preparing to unpack .../postgresql_10+190_all.deb ...
Unpacking postgresql (10+190) ...
Selecting previously unselected package postgresql-contrib.
Preparing to unpack .../postgresql-contrib_10+190_all.deb ...
Unpacking postgresql-contrib (10+190) ...
Setting up postgresql-contrib (10+190) ...
Setting up postgresql (10+190) ...
:~$ sudo -u postgres createuser -P postgis
Enter password for new role: xxxx (your password)
Enter it again: xxxx (your password)
:~$ sudo -u postgres createdb -O postgis webgis
createdb: database creation failed: ERROR:  database "webgis" already exists
:~$ sudo -u postgres createdb -O postgis polybase
:~$ psql -h localhost -U postgis polybase
Password for user postgis:
psql (10.6 (Ubuntu 10.6-0ubuntu0.18.04.1), server 9.6.8)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

polybase=>

\q

:~$ sudo apt install -y postgis postgresql-10-postgis-2.4
Reading package lists... Done
Building dependency tree     
Reading state information... Done
postgis is already the newest version (2.4.3+dfsg-4).
The following NEW packages will be installed
  libprotobuf-c1 postgresql-10-postgis-2.4
0 to upgrade, 2 to newly install, 0 to remove and 27 not to upgrade.
Need to get 578 kB of archives.
After this operation, 1,748 kB of additional disk space will be used.
Get:1 http://gb.archive.ubuntu.com/ubuntu bionic/universe amd64 libprotobuf-c1 amd64 1.2.1-2[19.0 kB]
Get:2 http://gb.archive.ubuntu.com/ubuntu bionic/universe amd64 postgresql-10-postgis-2.4 amd64 2.4.3+dfsg-4 [559 kB]
Fetched 578 kB in 0s (2,861 kB/s)               
Selecting previously unselected package libprotobuf-c1:amd64.
(Reading database ... 399421 files and directories currently installed.)
Preparing to unpack .../libprotobuf-c1_1.2.1-2_amd64.deb ...
Unpacking libprotobuf-c1:amd64 (1.2.1-2) ...
Selecting previously unselected package postgresql-10-postgis-2.4.
Preparing to unpack .../postgresql-10-postgis-2.4_2.4.3+dfsg-4_amd64.deb ...
Unpacking postgresql-10-postgis-2.4 (2.4.3+dfsg-4) ...
Setting up libprotobuf-c1:amd64 (1.2.1-2) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Setting up postgresql-10-postgis-2.4 (2.4.3+dfsg-4) ...
:~$ sudo -u postgres psql -c "CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;"polybase
ERROR:  syntax error at or near "polybase"
LINE 1: ...XTENSION postgis; CREATE EXTENSION postgis_topology;polybase
                                                               ^
:~$ sudo apt install pgadmin4
Reading package lists... Done
Building dependency tree     
Reading state information... Done
Package pgadmin4 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'pgadmin4' has no installation candidate

:~$ sudo apt install pgadmin3
Reading package lists... Done
Building dependency tree     
Reading state information... Done
pgadmin3 is already the newest version (1.22.2-4).
0 to upgrade, 0 to newly install, 0 to remove and 27 not to upgrade.

Tuesday, 20 March 2018

vrt2GeoPackage Rasters

My previous post didn't mention how to setup the Ordnance Survey layers (or any other raster and vector combination) in a single GeoPackage from virtual rasters, so I thought i would elaborate on the 'gdal_translate' part. It's quite easy...you can simply cut and paste this command in Linux or Windows. Remember to substitute with your own paths with your virtual raster layers.

The advantages of the GeoPackage format in QGIS3 are not only speed of map scrolling and zooming but the ability to store (in a database table) your map 'styles' and zoom levels (for vector layers) within when needing to work offline or with Qfield. Also remember that you do not need to include the .vrt extension.

Before you start install and open QGIS 3.0 and then open the 'Browser' and select 'GeoPackage' then right click 'Create database'.



You will then see the panel below. Enter a database name for your new GeoPackage and leave everything else as 'default', then press 'OK'. You should now see a new empty GeoPackage at the location you specified.




Now open the Terminal/Commandline and type the following one layer/block at a time depending on the number of .vrt layers you have.

:~$ gdal_translate /your/path/to/vrtfile/OS_GB_Overview_19-09-17/OS_GB_Overview_19-09-17 /your/path/to/gpkg/psma.gpkg -of GPKG -co APPEND_SUBDATASET=YES -co RASTER_TABLE=OS_GB_Overview_19-09-17 -co ZOOM_LEVEL_STRATEGY=AUTO

:~$ gdal_translate /your/path/to/vrtfile/OS_MiniScale_19-09-17/OS_MiniScale_19-09-17 /your/path/to/gpkg/psma.gpkg -of GPKG -co APPEND_SUBDATASET=YES -co RASTER_TABLE=OS_MiniScale_19-09-17 -co ZOOM_LEVEL_STRATEGY=AUTO

:~$ gdal_translate /your/path/to/vrtfile/250k_19-09-17/250k_19-09-17 /your/path/to/gpkg/psma.gpkg -of GPKG -co APPEND_SUBDATASET=YES -co RASTER_TABLE=250k_19-09-17 -co ZOOM_LEVEL_STRATEGY=AUTO

:~$ gdal_translate /your/path/to/vrtfile/50k_19-09-17/50k_19-09-17 /your/path/to/gpkg/psma.gpkg -of GPKG -co APPEND_SUBDATASET=YES -co RASTER_TABLE=50k_19-09-17 -co ZOOM_LEVEL_STRATEGY=AUTO

:~$ gdal_translate /your/path/to/vrtfile/25k_19-09-17/25k_19-09-17 /your/path/to/gpkg/psma.gpkg -of GPKG -co APPEND_SUBDATASET=YES -co RASTER_TABLE=25k_19-09-17 -co ZOOM_LEVEL_STRATEGY=AUTO

:~$ gdal_translate /your/path/to/vrtfile/VML_19-09-17/VML_19-09-17 /your/path/to/gpkg/psma.gpkg -of GPKG -co APPEND_SUBDATASET=YES -co RASTER_TABLE=VML_19-09-17 -co ZOOM_LEVEL_STRATEGY=AUTO


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:-

https://www.youtube.com/watch?v=U3Hf0qI4JLc&t=357s

The original archived version here:-

https://grass.osgeo.org/grass_movie_CERL_1987/

Jeff McKennas' FOSS4G 2014 Presentation here:-

https://www.slideshare.net/gatewaygeomatics.com/history-of-the-grass-gis-video-from-1987-with-william-shatner 


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

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...