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

GeoPackage Ordnance Survey Data for QGIS 3

GeoPackage with Rasters

Passenger Drone - Initial Trials of the Ehang 184 AAV

https://youtu.be/Mr1V-r2YxME

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)

FOSS4GUK 2018 Announcement

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

http://uk.osgeo.org/foss4guk2018/

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

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.

https://www.directionsmag.com/article/1080