Working with GPKG data

Note - These instructions are based on ArcGIS Pro version 2.3.3. More recent releases should perform in a similar manner.

1. Create a new blank map project in ArcGIS Pro and select an appropriate map backdrop to use as context against which to display the data. Ensure that the coordinate reference system is set to British National Grid

2. Open the Catalog panel on the right-hand side of the main window.

3. Right-click on Folders and select Add a new folder connection.

4. Browse to the location of the GKPG file for the AddressBase Core product and select that folder.

Note - Allow it a little time to make the connection as the ArcGIS Indexing server works in the background on the GPKG file before it is displayed. The national AddressBase Core GeoPackage file is over 13GB in size, so this will take a few minutes. When the process is complete, the AddressBase Core GPKG should appear as a database in the Catalog panel.

Note - The coordinate reference system of the basemap should be set to British National Grid before loading the main.abcore_address element into the map backdrop.

1. In the selected folder, click the arrow to the left of the GPKG file to expose the component element. This is the file which contains the data.

2. Right-click on the abcore element – in this example, main.abcore_address – and then select Add to Current Map.
3. It will now appear in the Contents panel on the left-hand side of the main map window. Give the application a few minutes to load the data, especially if loading a national set. The screenshot below shows a smaller GPKG covering part of Hampshire which has been loaded into ArcGIS Pro using the method described above.

Note - These instructions are based on ArcMap version 10.5.1. More recent releases should perform in a similar manner.

1. In Arc Catalog, connect to the folder that contains the AB_Core GeoPackage data. You will need to create a new folder connection if one doesn't exist. In the example below, the connection in Arc Catalog has been made and the GPKG has been expanded to show the main.abcore_address element containing the AB_Core data within the GKPG. This data which will be added to the backdrop mapping in ArcMap.
2. In ArcMap, click Add Data.

3. In the Add Data dialog:

   • Navigate to the folder which contains the GPKG.

   • Click on the main AB_Core element within the GPKG to select it.

   • Click Add.

     The data from the GPKG loads into ArcMap.

     Note - Unlike in the CSV option, there is no need to specify a coordinate reference system for the AB_Core data because that information already exists in the GKPG.

     However, you will have to change the coordinate reference system set for the backdrop map to use to British National Grid beforehand to get the data to display in its correct position in relation to the backdrop map.

Note - These instructions are based on QGIS version 3.10.5. More recent releases should perform in a similar manner.

1. Launch QGIS and select a suitable mapping backdrop to provide geographical context. The example below uses the open dataset, OS Zoomstack, to provide a mapping context.

2. When loading CSV data, ensure that the map window coordinate reference system is set to EPSG 27700 (British National Grid).
3. Click the Add Vector Layer icon in the in the Manage Layers toolbar on the left. To activate this toolbar, go to View > Toolbars > Manage Layers toolbar and make sure that Manage Layers Toolbar option is selected.
4. In Data Source Manager | Vector, click the ... (three dots) to the right of the Vector Dataset(s) field.
5. In Open OGR Supported Vector Dataset(s), browse to the location of the folder in which the GPKG file is located, select the file to be loaded, and click OK.

   Note - You can filter other files in the folder which are not GKPGs by setting the files of type box (in the bottom right-hand corner of the window) to GeoPackage (*.gkpg *.GKPG)

6. In Data Source Manager | Vector, click Add. The GPKG data will now load into QGIS.
7. Click Close. The GKPG data is loaded into the map area. You can now interrogate and style the data with the tools available within QGIS.

   Note - The GKPG data does not need a spatial index to be created as that indexing is normally held within the GeoPackage itself.

Note - These instructions are based on MapInfo Professional version 16.0.4. More recent releases should perform in a similar manner.

Note - Versions of MapInfo Professional before the 16.0.0 release do not support the GPKG format. Versions from 16.0.0 onwards fully support the format.

1. Launch MapInfo Professional.

2. Load a suitable backdrop map to provide context for the AB_Core data. This can be map data held locally or from a wide variety of online sources, some of which are free to use. This example uses the OS Maps API light backdrop map, with the coordinate reference system set to EPSG 27700 (British National Grid).
3. Select Table in the top menu and then select Open > Table. You can also do this using a quick launch button if it has been set up in MapInfo Professional.

4. In the Open dialog:

   • Navigate to the AB_Core GPKG folder location.

   • Files of type: Select GeoPackage (*.gpkg).

   • Preferred View: Select Current Mapper. This ensures that the data will display against the selected backdrop contextual mapping.

   • Select the file to be loaded.

   • Click Open.
5. In the Select One or More Tables to Open dialog: In this dialog you can change the style of the loaded data one of several different available styles.

6. Select a style and click OK.

7. Click OK. You can also specify the location of the newly created .TAB folder which will source the GKPG.
8. The GeoPackage data now loads into the map area. You can interrogate that data using any of the available tools.
9. You can easily browse the data by right-clicking on the new GKPG layer in the content panel and selecting Browse.
10. A new browser tab will appear alongside the map tab in the main display area.
11. Save the workspace in MapInfo Professional for future use.

Note - These instructions are based on CadCorp Map Modeller version 9.

1. Launch CadCorp Map Modeller.

2. Add a suitable backdrop map for use as a contextual backdrop:

   • Open a blank map and ensure that the default coordinate reference system is set to British National Grid.

   • Select Add Overlay.
   • In Overlay Types, select Web > Tile Dataset, and then select Next.
   • In Tile Dataset, expand Ordnance Survey (GB) > OS Open Zoomstack, select one of the available styles and then click Finish.

     The backdrop map will load. Our example uses the 'Road' style version of the OS Open Zoomstack data as a backdrop. For this option, an internet connection is required. You could use a locally held overlay of data as an alternative option.

3. To add the GPKG data:

   • Click Add Overlay in the top menu.
   • In Overlay Types, select Files > File and then click Next.
4. In File Browser, locate the folder in which the AB_Core data is stored, select the GKPG file, and then click Finish. Set the file type box (bottom right-hand field) to All known formats.

   The GPKG data will now load into CadCorp Map Modeller. The AB_Core entry will display in the list of Maps in the left panel and the GPKG data should display against the backdrop map in the map area.

Displaying the address location

You may need to change the styling to make the AB_Core data visible:

1. Right-click the AB_Core GPKG entry and select Properties.

2. In Overlays > Styles experiment with the symbol and point size options and click OK when satisfied.

   This example uses a circle (Symbol field) and a point size of -0.05 (Point field) to make the data stand out against the backdrop mapping.