Producing geolocation database from Norwegian datasets

This guide demonstrates how to create placename databases from the Norwegian datasets SSR (Placenames) and Matrikkelen (Street addresses). The workspaces used in this guide depend upon the schema of the input datasets not changing. If they change from one version to the next, the workspaces will have to be adapted.

Prerequisites

Tool

The tool which is used to build the database is TPG.GeoFramework.LocationServiceSqliteLoader.exe. Make sure that the support files cc.csv, dsg.csv and gns_adm1.csv are also located in the same folder. For general documentation, see Geolocation

FME workspaces

• gdb2sqlite_matrikkel_2020.fmw
• gml2sqlite3_norge_ssr.fmw

Data

• Matrikkelen (File geodatabase)
• SSR (GML)

Steps

• Run the workspaces with the corresponding datasets. The output will be un-optimized sqlite files with placename data.
• With the supplied .exe tool, run (for both datasets)

  TPG.GeoFramework.LocationServiceSqliteLoader.exe matrikkelen_fme_output.sqlite geoloc matrikkelen_fme_output.location.sqlite