Producing geolocation database from Norwegian datasets: Difference between revisions

From Maria GDK Wiki
Jump to navigation Jump to search
(Created page with "This guide demonstrates how to create placename databases from the Norwegian datasets '''SSR''' (Placenames) and '''Matrikkelen''' (Street addresses). The workspaces used in t...")
 
Line 13: Line 13:
== Steps ==
== Steps ==
* Run the workspaces with the corresponding datasets. The output will be un-optimized sqlite files with placename data.
* 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) <source lang="powershell">TPG.GeoFramework.LocationServiceSqliteLoader.exe matrikkelen_fme_output.sqlite geoloc matrikkelen_fme_output.location.sqlite</source>
* With the supplied .exe tool, run (for both datasets) <source lang="bash">TPG.GeoFramework.LocationServiceSqliteLoader.exe matrikkelen_fme_output.sqlite geoloc matrikkelen_fme_output.location.sqlite</source>




[[Category:Preparing data]]
[[Category:Preparing data]]

Revision as of 14:19, 26 May 2021

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