GEO informational SQL database of countries of port cities

Complete geo-informational database in EXCEL, which is easy to export to SQL, CSV, ACCESS, DB, XML, etc.
All records support official identifier codes in accordance with existing ISO, GeoNames, IATA, FIPS, OKATO, UNLOCODE standards, which allows this database to be connected to existing Internet services. The data in the database are taken from official open sources and have been repeatedly filtered and contacted with each other, and at any time it is possible to update any record from any open database.

================ Database structure
== continents (7 entries)
iso_cont ISO continent code
name The name of the continent in English.
name_ru The name of the continent in Russian
sortid id for sorting
geoname_id id of the object by geoname

== countries (247 records)
iso code iso alpha2
iso3 code iso alpha3
iso_num code iso numeric
fips code according to FIPS (Federal Information Processing Standards), developed by the US government, used by all civil government agencies and counterparties in the US. Many of the FIPS standards are modified versions of other widely used standards, including ISO
name geographic name eng
name_ru geographic name rus
capital_geonamesid Capital, object id by geoname, if not Int, then its name in English.
area_km2 Area in sq. km.
population Population
continent iso continent code
languages ​​iso codes of languages ​​with adverbs (separated by commas) in ISO 639-1 #
currency country currency #
geonameId object id by geoname
tld end of country domain zone
phone country phone code
postal_code_format postal code format
postal_code_regex regular expression for postal code
neighbors iso-code of bordering countries, separated by commas

== Currency (174 records)
iso_alpha ISO 4217 currency letter code #
iso_num numeric currency code ISO 4217 #
currency Currency name, eng
сurrency_ru Monetary unit name, rus

== Languages ​​(over 7 entries)
iso3 ISO 639-3,
iso2 ISO 639-2
iso1 ISO 639-1
language name, eng
language_ru name, rus

== Cities (over 20 cities = all cities in the world with a population of over 000)
geonameid id of the object by geoname
name geographic name (utf8), eng
asciiname geographical name in plain ascii encoding, eng
name_ru geographic name, rus
latitude coordinates, dogota
longitude coordinates, latitude
country ISO-3166 two-letter country code
cc2 alternate country code, comma separated, ISO-3166 2-letter country code, 60 characters
admin1 2nd level of administrative division - fips-code
admin2 2nd level of administrative division, state for the USA
admin3 3rd level of administrative division
admin4 4rd level of administrative division
population population
elevation is the maximum point of elevation above sea level, the field is almost empty
gtopo30 Altitude above Sea Level
timezone timezone
modification date of last modification of the entry

== World airports (air, sea, railway, bus, etc.)
iata_code IATA code
icao_code ICAO code
name_rus Name, rus
name_eng Name, eng
city_rus closest city, rus
city_eng closest city, eng.
IATAcitycode IATA city code
UNLOCODE code UNLOCODE
gmt_offset GMT time
country_rus name of the country, rus
country_eng country name, eng
country_iso_code country ISO code
latitude longitude
longitude latitude
runway_length runway length
runway_elevation altitude
phone phone
fax fax
email email
website website

+ Detailed description of the most popular countries, resorts, tourist regions
+ Flags of all countries