Working with GML data

GML data can be viewed and loaded into Safe FME. When AddressBase Premium is read into FME, the non-spatial tables within the product are automatically related to the spatial tables.

Note: The following instructions use FME version 2020.0, but should work in most versions.

1. Open FME Workbench.

2. Click the Reader button in the ribbon.
3. An Add Reader dialog box will appear.
4. Select GML (Geography Markup Language) as the Format.

5. Select a coordinate reference system from the Coord. System dropdown list. It’s recommended that British National Grid (EPSG:27700) is selected as the coordinate reference system; however, you can select a different coordinate reference system if required.

6. Click the three dots button next to the Dataset box. This will bring up another dialog box where you can select the GML dataset to read into FME.

7. Click OK and OK again.

8. A Select Feature Types dialog box will appear in which you can select what feature types should be read into FME. The BasicLandPropertyUnit and Street feature types also include the non-spatial table information, such as LPI and organisation.

9. Click OK.

10. The three feature types should appear as readers.

More information on GML readers in FME is available on the Safe Software website.

Note - The following instructions are based on PostgreSQL version 12.3 and assume that you have set-up your database with the PostGIS spatial extension in a Windows environment.

Requirements:

• A development platform for PostgreSQL (for example, pgAdmin or dBeaver)

• A PostgreSQL database

• PostGIS extension

• GDAL extension

• Access to a Command Prompt or similar

• A basic understanding of database terminology

Instructions

Note - Before you start, make sure the AddressBase Premium GML is stored in a suitable location and the file is unzipped.

1. Open the Command Prompt by clicking the Windows Start button in the bottom left-hand side of the screen and typing cmd into the search bar.
2. The Command Prompt will appear.

3. Change the directory of the Command Prompt App if necessary. The directory needs to point to the folder where the GML is stored. For this example, the GML to be loaded into PostgreSQL is stored in a C:\Temp folder.

4. In the Command Prompt, type cd followed by the directory of the location of the GML. Press Enter on the keyboard. This will change the directory.
5. Enter the following command:

   Copy

   ogr2ogr -f "PostgreSQL" PG:"host=<host> port=<port> dbname=<database> user=<username> password=<password>" <data_name.gml> -overwrite -progress -t_srs EPSG:<CRS>

   Where: <host>, <port>, <database>, <username> and <password> can be found within the subsequent database. <data_name.gml> is the AddressBase Premium GML file, for example, AddressBasePremium_AOI_2021-04- 12_001_gml.gml. <CRS> is the coordinate reference system. British National Grid (27700) is recommended but you can use alternative coordinate reference systems if required. Example:

   Copy

   ogr2ogr -f "PostgreSQL" PG:"host=localhost port=5432 dbname=osdata user=postgres password=pgdata1234" AddressBasePremium_AOI_2021-04-12_001_gml.gml -overwrite - progress -t_srs EPSG:27700

6. Open your chosen development platform by going to the Windows Start button and selecting your chosen software.

7. In your Database Navigator, move to the database you loaded data into and expand the schema.

8. From using the code above, the GML files should be in your default schema (shown in bold). The data should load into two tables: basiclandpropertyunit and street. Data in non-spatial tables will automatically be matched to the spatial tables based on a unique identifier.

9. Once loaded, you may want to add Primary and Foreign Keys to the data. These can only be added on columns where the data values are unique. Where there are no unique data values, an index may be added which will aid searching. For the BLPU table, the UPRN provides a unique value.

Note - You can also manage your database using the PostGRES SQL Command Prompt.