# Working with GPKG data {% hint style="info" %} This is not an extensive list of the applications AddressBase Core can be used in; many other GIS software applications and/or databases can be used to load the product. {% endhint %} Ordnance Survey does not recommend specific suppliers or software products, as the most appropriate system will depend on many factors, for example, the amount of data being taken, resources available within the organisation, the existing and planned information technology infrastructure and the applications that AddressBase products can be used for ## Loading data into GIS applications This section provides step-by-step instructions on how to load the GPKG format of AddressBase Core into commonly-used GIS software.

ArcGIS Pro

*Note - These instructions are based on ArcGIS Pro version 2.3.3. More recent releases should perform in a similar manner.*\ \ \&#xNAN;*Note –* Certain versions of ArcPro (for example, version 2.5) require GeoPackages to have a spatial index added before the data can be viewed on the map. This can be done in the Catalog by opening the Feature Class Properties window within the 'Indexes' page.\ \ ![ArcGIS Pro feature class properties window showing the attribute index and spatial index options](https://1897589978-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNpJpLP8RROUaWVQo5ea%2Fuploads%2FdIxyvkdlmq6LoNin2sEB%2FArcGISPropertiesWindow.png?alt=media\&token=daac8942-bf9a-48ee-8e00-7b27ae15ee76) 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 GPKG file for the AddressBase Core product and select that folder. \ \&#xNAN;*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.*\ \ \&#xNAN;*When the process is complete, the AddressBase Core GPKG should appear as a database in the Catalog panel.*\\ ArcGIS Pro UI showing basemap and Catalog panel

\ \&#xNAN;*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.\ \&#xNAN;*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*.\\

ArcGIS Pro Catalog panel showing AddressBase Core GPKG folder

3. It will now appear in the Contents panel on the left-hand side of the main map window.\ \&#xNAN;*Give the application a few minutes to load the data, especially if loading a national set.*\ \ \&#xNAN;*The screenshot below shows a smaller GPKG covering part of Hampshire which has been loaded into ArcGIS Pro using the method described above.*\\

ArcGIS Pro UI showing AddressBase Core data on the basemap

ArcMap

*Note - These instructions are based on* ArcMap *version* 10.5.1. *More recent releases should perform in a similar manner.*\ \ \&#xNAN;*Note –* Certain versions of ArcMap (for example, version 10.8.1) require GeoPackages to have a spatial index added before the data can be viewed on the map. This can be done in the Catalog by opening the Feature Class Properties window within the 'Indexes' page.\ \ ![ArcMap Feature Class Properties window showing Attribute Indexes options and spatial index options](https://1897589978-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FcNpJpLP8RROUaWVQo5ea%2Fuploads%2F2KnTXa6zh6RLnQI2BXaa%2FArcMapPropertiesWindow.png?alt=media\&token=b5a0e23a-19c5-488f-bc80-8973b5b61817) 1. In Arc Catalog, connect to the folder that contains the AB\_Core GeoPackage data.\ \&#xNAN;*You will need to create a new folder connection if one doesn't exist.*\ \ \&#xNAN;*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 GPKG. This data which will be added to the backdrop mapping in ArcMap.*\\

Arc Catalog showing Folder Connections in Catalog Tree

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

\ \&#xNAN;*The data from the GPKG loads into ArcMap.* \\

ArcMap UI showing AddressBase Core data in the Map area

\ \&#xNAN;*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 GPKG.* *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.*

QGIS

*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.\ \&#xNAN;*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.\ \&#xNAN;*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.\\

QGIS Data Source Manager | Vector dialog

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

QGIS Open OGR Supported Vector Dataset(s) dialog

*Note - You can filter other files in the folder which are not GPKGs by setting the files of type box (in the bottom right-hand corner of the window) to GeoPackage (\*.gkpg \*.GPKG)* 6. In Data Source Manager | Vector, click *Add*.\ \&#xNAN;*The GPKG data will now load into QGIS.*\\

7. Click *Close*.\ \ The GPKG data is loaded into the map area.\ \&#xNAN;*You can now interrogate and style the data with the tools available within QGIS.*\\

QGIS UI AddressBase Core data on the backdrop map

\ \&#xNAN;*Note - The GPKG data does not need a spatial index to be created as that indexing is normally held within the GeoPackage itself.*

MapInfo Professional

*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.\ \&#xNAN;*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.*\ \&#xNAN;*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.*\ \&#xNAN;*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:\ \&#xNAN;*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*.\ \&#xNAN;*You can also specify the location of the newly created .TAB folder which will source the GPKG.*\\

MapInfo Professional Select One or More Tables to Open dialog

8. The GeoPackage data now loads into the map area.\ \&#xNAN;*You can interrogate that data using any of the available tools.*\\

MapInfo Professional UI showing AddressBase Core data on the basemap

9. You can easily browse the data by right-clicking on the new GPKG layer in the content panel and selecting *Browse*.\\

MapInfo Professional UI showing AB_Core GPKG in the content panel

10. A new browser tab will appear alongside the map tab in the main display area.\\

MapInfo Professional UI showing GPKG browser tab

11. Save the workspace in MapInfo Professional for future use.

CadCorp Map Modeller

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

CadCorp UI highlighting Add Overlay button

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

CadCorp UI showing backdrop map and highlighting Add Overlay button

* 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 GPKG file, and then click *Finish*.\ \&#xNAN;*Set the file type box (bottom right-hand field) to All known formats.* \\

*The GPKG data will now load into CadCorp Map Modeller.*\ \ \&#xNAN;*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.*\\

CadCorp UI showing AddressBase Core data in the Maps panel and on the background map