Viewing the data in QGIS

In QGIS, click on the ‘open PostGIS layer’ button on the left hand side of the window.

open PostGIS layer’ button

Add PostGIS Table window

In the next window, a new connection will have to be set up to the newly created database containing the OS OpenMap-Local data. Click on ‘new’. Another window called ‘create PostGIS connection’ will appear. Information will be required to be entered into this window to set up the new connection.

Create a new PostGIS connection window

In this example, the name ‘osopenmap’ for the connection has been provided along with the name of the database which holds the data. Click on the ‘Test Connect’ button to ensure that the correct connection is made. Once successful, click ‘OK’. If the save username and save password boxes have been clicked, click ‘OK’ in the subsequent message box.

A new connection will now be available in the list of PostGIS database connections. Ensuring that the correct one is listed, click on ‘connect’. The schema containing the OS OpenMap-Local data can be seen.

Add PostGIS Tables window

Click on the + sign next to the schema to expand the list of tables. Select all of the tables within OS OpenMap-Local that are required to be loaded to QGIS. Once all have been selected, click ‘Add’.

Add PostGIS Table(s) window

The OS OpenMap-Local data will load into QGIS. The data will need to be re-ordered and then styled appropriately using personalised style files or the style files available from GitHub published by Ordnance Survey. If using these published files, please consult the accompanying ‘Quick Start Guide’ as to their use. It should be noted that there is no requirement to add a spatial index to the data from PostGIS as those indexes were added automatically during the loading of the data into PostgreSQL.

OS OpenMap Local data loaded into QGIS

If using the published style files, the output should appear as shown above.