ArcMap

Geodatabase To GeoNames

Summary

Exports the GeoNames features in a geodatabase to a text file.

This tool can be used after GeoNames data has been loaded into your database and associated with features. You would then edit and update the GeoNames features, as necessary, and export them to a text file. This text file is created in Unicode Transfer Format (UTF) in 8-bit or 16-bit format so you can load the GeoNames data into data in different locales.

At a minimum, the GeoNames feature class must contain the unique feature identifier (UFI) and unique name identifier (UNI) fields. The text file is created for features from the country you choose using the GeoNames feature class and table in your geodatabase.

It is assumed that the name of the feature class and table are Geonames_FeaturesP and Geonames_Table, respectively, but you can also use GeoNames files your organization may have already created.

Usage

  • Due to schema changes in the GeoNames table, you may need to import the new schema into your existing GeoNames table. Fresh copies of the GeoNames feature class and table are located at C:\Program Files (x86)\ArcGIS\EsriDefenseMapping\Desktop10.5\Geonames\Schema\Gdb\Geonames_Template.zip.

  • If your organization already has a GeoNames database, this database may be used as long as it contains the UFI and UNI fields.

Syntax

arcpy.defense.GeodatabaseToGeoNames(in_feature_class, in_table, out_text_file, in_country_code, in_output_format)
ParameterExplanationData Type
in_feature_class

The GeoNames feature class; this feature class should be in the working database.

Feature Class
in_table

The GeoNames table; this table should be in the working database.

Table
out_text_file

The path to the output GeoNames text file.

Text File
in_country_code

Choose the country code that corresponds with the country for which you want to export GeoNames features.

String
in_output_format

The output format of the file. You can use either an 8-bit or 16-bit format.

  • UTF8 —This is the default 8-bit format.
  • UTF16 —This is the 16-bit format.
String

Code sample

GeodatabaseToGeoNames example (stand-alone script)

The following script is an example of calling the GeodatabaseToGeoNames tool in a stand-alone Python script.

# Importing arcpy module
import arcpy

# Checking out Defense extension
arcpy.CheckOutExtension('defense')

# Setting variables for parameters
feature_class = r'C:\Data\MGCP_TRD_4_2.gdb\GeoNames_FeaturesP'
in_table = r'C:\Data\MGCP_TRD_4_2.gdb\GEONAMES_TABLE'
output_file = r'C:\Data\GeoNames_HA.txt'
country_code = 'HA'

# Calling GeoNames to Geodatabase tool
arcpy.defense.GeodatabasetoGeoNames(feature_class, in_table, output_file, country_code, 'UTF8')

# Checking in Defense extension
arcpy.CheckInExtension('defense')

Environments

Licensing information

  • Basic: No
  • Standard: Requires Defense Mapping
  • Advanced: Requires Defense Mapping