Producing geolocation database from Norwegian datasets: Difference between revisions

From Maria GDK Wiki
Jump to navigation Jump to search
(→)
(→)
Line 1: Line 1:
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.
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 ==  
== Prerequisites ==
=== Tool ===
The tool which is used to build the database is <code>TPG.GeoFramework.LocationServiceSqliteLoader.exe</code>. 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 ===
=== FME workspaces ===
* gdb2sqlite_matrikkel_2020.fmw
* gdb2sqlite_matrikkel_2022-08.fmw
* gml2sqlite3_norge_ssr.fmw
* gml2sqlite3_norge_ssr.fmw
=== Maria Map Maker ===
M3 will optimize the databases produced by FME and update the data files in the relevant products


=== Data ===
=== Data ===
* Matrikkelen (File geodatabase)
Both datasets should be structured with the entire country in one dataset. Download the following from geonorge.no:
* SSR (GML)
* Matrikkelen - Adresse (FGDB format)
* Stedsnavn SSR (GML format)
== Steps ==
== 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) <source lang="bash">TPG.GeoFramework.LocationServiceSqliteLoader.exe matrikkelen_fme_output.sqlite geoloc matrikkelen_fme_output.location.sqlite</source>
# Run the workspaces with the corresponding datasets. The output will be un-optimized sqlite files with placename data.
The databases have now been optimized, and can update older data in the products
# Using Maria Map Maker, open the products and update the datasets using the corresponding SQLite file from FME:
* NorwayLocationAddresses
#* NorwayLocationAddresses
* NorwayLocationSSR
#* NorwayLocationSSR


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

Revision as of 22:05, 7 February 2024

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

FME workspaces

  • gdb2sqlite_matrikkel_2022-08.fmw
  • gml2sqlite3_norge_ssr.fmw

Maria Map Maker

M3 will optimize the databases produced by FME and update the data files in the relevant products

Data

Both datasets should be structured with the entire country in one dataset. Download the following from geonorge.no:

  • Matrikkelen - Adresse (FGDB format)
  • Stedsnavn SSR (GML format)

Steps

  1. Run the workspaces with the corresponding datasets. The output will be un-optimized sqlite files with placename data.
  2. Using Maria Map Maker, open the products and update the datasets using the corresponding SQLite file from FME:
    • NorwayLocationAddresses
    • NorwayLocationSSR
Retrieved from "http://docs.maria.teleplanglobe.com/index.php?title=Producing_geolocation_database_from_Norwegian_datasets&oldid=4535"