geoname: geoname

Description Usage Format Details Source

Description

This is a data frame consisting of a subset of the GeoNames Gazetteer all country data.

Feature class:

Usage

1

Format

A data frame with 445818 rows and 12 columns

geonameid

integer id of record in geonames database

name

name of geographical point (utf8) varchar(200)

asciiname

name of geographical point in plain ascii characters, varchar(200)

latitude

latitude in decimal degrees (wgs84)

longitude

longitude in decimal degrees (wgs84)

feature_code

see http://www.geonames.org/export/codes.html, varchar(10)

country_code

ISO-3166 2-letter country code, 2 characters

admin1_code

fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)

admin2_code

code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)

admin3_code

code for third level administrative division, varchar(20)

admin4_code

code for fourth level administrative division, varchar(20)

modification_date

date of last modification in yyyy-MM-dd format

Details

feature_class definition
A country, state, region, ...
P city, village, ...

Feature code:

feature_class feature_code definition note
A ADM1 first-order administrative division a primary administrative division of a country, such as a state in the United States
A ADM1H historical first-order administrative division a former first-order administrative division
A ADM2 second-order administrative division a subdivision of a first-order administrative division
A ADM2H historical second-order administrative division a former second-order administrative division
A ADM3 third-order administrative division a subdivision of a second-order administrative division
A ADM3H historical third-order administrative division a former third-order administrative division
A ADM4 fourth-order administrative division a subdivision of a third-order administrative division
A ADM4H historical fourth-order administrative division a former fourth-order administrative division
A PCL political entity
A PCLD dependent political entity
A PCLF freely associated state
A PCLH historical political entity a former political entity
A PCLI independent political entity
A PCLS semi-independent political entity
A TERR territory
P PPLA seat of a first-order administrative division seat of a first-order administrative division (PPLC takes precedence over PPLA)
P PPLA2 seat of a second-order administrative division
P PPLA3 seat of a third-order administrative division
P PPLA4 seat of a fourth-order administrative division
P PPLC capital of a political entity

Source

http://download.geonames.org/export/dump/allCountries.zip


dnanto/neogeonames documentation built on Sept. 21, 2020, 7:42 p.m.