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


Comments

Post a Comment

Popular posts from this blog

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

-
Image
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 now we will probably see a 'one-click' installer to by-pass the next steps but a least this method allows you to change 'in/out' the individual libraries if there is are updates using the usual ' sudo apt update && sudo apt upgrade '. http://www.paulshapley.com/2016/08/qgis-server-bringing-map-into-browser.html http://www.paulshapley.com/2016/07/how-to-install-qgis-server-on-ubuntu.html http://www.paulshapley.com/2016/04/how-to-install-postgresql-95-and.html 1.  Firstly...Create a new QGIS project, add your layers from PostGIS, Shapefiles or raster (geotiff), style and symbolise those layers, set the projection and ensure you've set up your 'OWS Server' in 'Project Properties'. 2.  Let's install the 'Lizmap' Plugin first by going into the 'Plugins' menu then 'Manage
Read more

Install QGIS 3.22 LTS with QGIS-SERVER-3.22 and Apache2 on Ubuntu 22.04 LTS

-
Image
Install QGIS-SERVER-3.22   (assuming 'qgis' and 'qgis-plugin-grass' already on Ubuntu 22.04 LTS) (if not) :~$ sudo apt install qgis qgis-plugin-grass (then) :~$ sudo apt install qgis-server [sudo] password for paul: Reading package lists... Done Building dependency tree... Done Reading state information... Done qgis-server is already the newest version (3.22.16+dfsg-1~jammy3). 0 to upgrade, 0 to newly install, 0 to remove and 19 not to upgrade. Check the version installed: :~$ /usr/lib/cgi-bin/qgis_mapserv.fcgi --version QGIS 3.22.16-Białowieża 'Białowieża' (exported) QGIS code branchRelease 3.22 Qt version 5.15.3 Python version 3.10.6 GDAL/OGR version 3.6.2 PROJ version 9.1.1 EPSG Registry database version v10.076 (2022-08-31) GEOS version 3.11.1-CAPI-1.17.1 SQLite version 3.37.2 OS Ubuntu 22.04.2 LTS Now Install Apache2 :~$ sudo apt install apache2 [sudo] password for paul:  Reading package lists... Done Building dependency tree... Done Reading state informati
Read more

Qgis-server...Installation on Ubuntu 16.04 LTS

-
Image
Before we start it is always a good idea to remove and re-install apache2 web server so that we start from the same set up:- To remove Apache2:- $ sudo apt --purge remove apache2 $ sudo apt autoremove To re-install Apache2:- $ sudo apt install apache2 $ sudo /etc/init.d/apache2 restart # or $ sudo service apache2 restart 1. $ sudo apt install apache2 (if not installed already done so as above) 2. $ sudo apt install qgis-server libapache2-mod-fcgid 3. $ sudo a2enmod fcgid 4. $ sudo a2enconf serve-cgi-bin 5. $ sudo service apache2 restart 6. add the following code and don't forget to save the changes:- ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/ <Directory "/usr/lib/cgi-bin/"> Options ExecCGI FollowSymLinks Require all granted AddHandler fcgid-script .fcgi </Directory> into /etc/apache2/sites-available/ 000-default.conf $ sudo gedit /etc/apache2/sites-available/000-default.conf # so that it looks like this:- <VirtualHost *:80>   
Read more