Producing global placename database: Difference between revisions
No edit summary |
(→) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
== Prerequisites == | == Prerequisites == | ||
=== Tool === | === 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]] | 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]] | ||
=== Data === | === Data === | ||
| Line 12: | Line 12: | ||
== Steps == | == Steps == | ||
# | # | ||
# Run the tool on Countries.txt first: < | # Run the tool on Countries.txt first: <source lang="powershell">TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\Countries.txt" gns "c:\location\20210304_Worldgeonames.location.sqlite"</source> | ||
# Run the tool on NationalFile, with the same output file as in the previous step. This will add the new data to the existing file. < | # Run the tool on NationalFile, with the same output file as in the previous step. This will add the new data to the existing file. <source lang="powershell">TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\NationalFile.txt" gns_us "c:\location\20210304_Worldgeonames.location.sqlite"</source> | ||
The database is now complete, and can be read by the Maria GDK location service to search for place names with complete global coverage. | |||
[[Category:Preparing data]] | |||
Latest revision as of 15:00, 4 March 2021
This guide shows you have to produce a global placename database from two sources: The US agencies NGA and USGS. An alternative source for global placename data is https://www.geonames.org/
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
Data
Download global data from https://geonames.nga.mil/gns/html/namefiles.html (Entire country files dataset).
Download US domestic data from https://www.usgs.gov/core-science-systems/ngp/board-on-geographic-names/download-gnis-data (National file)
Steps
- Run the tool on Countries.txt first:
TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\Countries.txt" gns "c:\location\20210304_Worldgeonames.location.sqlite"
- Run the tool on NationalFile, with the same output file as in the previous step. This will add the new data to the existing file.
TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\NationalFile.txt" gns_us "c:\location\20210304_Worldgeonames.location.sqlite"
The database is now complete, and can be read by the Maria GDK location service to search for place names with complete global coverage.