Producing global placename database: Difference between revisions
No edit summary |
(→) |
||
| Line 14: | Line 14: | ||
# Run the tool on Countries.txt first: <code>TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\Countries.txt" gns "c:\location\20210304_Worldgeonames.location.sqlite"</code> | # Run the tool on Countries.txt first: <code>TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\Countries.txt" gns "c:\location\20210304_Worldgeonames.location.sqlite"</code> | ||
# 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. <code>TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\NationalFile.txt" gns_us "c:\location\20210304_Worldgeonames.location.sqlite"</code> | # 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. <code>TPG.GeoFramework.LocationServiceSqliteLoader.exe "c:\location\NationalFile.txt" gns_us "c:\location\20210304_Worldgeonames.location.sqlite"</code> | ||
The database is now complete, and can be read by the Maria GDK location service to look up place names with complete global coverage. | |||
Revision as of 13:04, 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 look up place names with complete global coverage.