Description Usage Format Details Source
This is a data frame consisting of a subset of the GeoNames Gazetteer all country data.
Feature class:
1 |
A data frame with 445818 rows and 12 columns
integer id of record in geonames database
name of geographical point (utf8) varchar(200)
name of geographical point in plain ascii characters, varchar(200)
latitude in decimal degrees (wgs84)
longitude in decimal degrees (wgs84)
see http://www.geonames.org/export/codes.html, varchar(10)
ISO-3166 2-letter country code, 2 characters
fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt for display names of this code; varchar(20)
code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80)
code for third level administrative division, varchar(20)
code for fourth level administrative division, varchar(20)
date of last modification in yyyy-MM-dd format
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 | |
http://download.geonames.org/export/dump/allCountries.zip
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.