GeoNames

“The GeoNames geographical database covers all countries. It contains over 25 million geographical names and consists of over 11 million unique features whereof 4.8 million populated places and 13 million alternate names. All features are categorized into one out of nine feature classes and further subcategorized into one out of 645 feature codes. GeoNames is integrating geographical data such as names of places in various languages, elevation, population and others from various sources.” - source: GeoNames and data details

Summary

Average runtime

~20 min

Average download size

350 MB

Harvest Type

URL

Harvest Frequency

Weekly

Runs on remote worker

False

Catchup missed runs

False

Table Write Disposition

Truncate

Update Frequency

~Monthly

Credentials Required

No

Uses Telescope Template

Snapshot

Each shard includes all data

Yes

Latest schema

name

type

mode

description

geonameid

INTEGER

NULLABLE

integer id of record in geonames database

name

STRING

NULLABLE

name of geographical point (utf8) varchar(200)

asciiname

STRING

NULLABLE

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

alternatenames

STRING

NULLABLE

alternatenames, comma separated, ascii names automatically transliterated, convenience attribute from alternatename table, varchar(10000)

latitude

FLOAT

NULLABLE

latitude in decimal degrees (wgs84)

longitude

FLOAT

NULLABLE

longitude in decimal degrees (wgs84)

featureclass

STRING

NULLABLE

see http://www.geonames.org/export/codes.html, char(1)

featurecode

STRING

NULLABLE

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

countrycode

STRING

NULLABLE

ISO-3166 2-letter country code, 2 characters

cc2

STRING

NULLABLE

alternate country codes, comma separated, ISO-3166 2-letter country code, 200 characters

admin1code

STRING

NULLABLE

fipscode (subject to change to iso code), see exceptions below, see file admin1Codes.txt at https://download.geonames.org/export/dump/ for display names of this code; varchar(20)

admin2code

STRING

NULLABLE

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

admin3code

STRING

NULLABLE

code for third level administrative division, varchar(20)

admin4code

STRING

NULLABLE

code for fourth level administrative division, varchar(20)

population

INTEGER

NULLABLE

bigint (8 byte int)

elevation

STRING

NULLABLE

in meters, integer

dem

INTEGER

NULLABLE

digital elevation model, srtm3 or gtopo30, average elevation of 3’’x3’’ (ca 90mx90m) or 30’’x30’’ (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.

timezone

STRING

NULLABLE

the iana timezone id (see file timeZone.txt) varchar(40)

modificationdate

DATE

NULLABLE

date of last modification in yyyy-MM-dd format