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 |