Sao Tome and Principe cities list with latitude and longitude in CSV format

Sao_Tome_and_Principe
Sao Tome and Principe
CSV, SQL, XML, JSON

Last update : 24 April 2024.

Country
Sao Tome and Principe
Capitale
São Tomé
Number of cities
232
Download

This is the best list of 232 cities in the Sao Tome and Principe available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the Sao Tome and Principe file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
2410854Rio AveSTSão Tomé IslandLemba District0.266676.50Africa/Sao_Tomepopulated place
2410724Vila RosaSTPríncipe1.674627.421820Africa/Sao_Tomepopulated place
2410907Planca SegundaSTSão Tomé Island0.46.616670Africa/Sao_Tomepopulated place
2410967Nova MocaNova Moca,Nova MokaSTSão Tomé Island0.283336.633330Africa/Sao_Tomepopulated place
2410868QuinasSTSão Tomé Island0.266676.60Africa/Sao_Tomepopulated place
2410914PiedadeSTPríncipe1.634857.437360Africa/Sao_Tomepopulated place
2410969Nova CubaSTPríncipe1.639047.408130Africa/Sao_Tomepopulated place
2411261BelmonteSTSão Tomé Island0.333336.650Africa/Sao_Tomepopulated place
11239070Porto RealSTPríncipe1.624737.401460Africa/Sao_Tomepopulated place
2411093HenriqueHenriqueSTSão Tomé Island0.056.550Africa/Sao_Tomepopulated place
2411285Anselmo de AndradeAnselmo de Andrade,LapaSTPríncipe1.604327.365790Africa/Sao_Tomepopulated place
2411148EsprainhaSTSão Tomé IslandLemba District0.333336.516670Africa/Sao_Tomepopulated place
2410964Novo BrasilNovo Brasil,Novo BrazilSTSão Tomé Island0.083336.566670Africa/Sao_Tomepopulated place
2410853Rio do OuroSTSão Tomé Island0.366676.650Africa/Sao_Tomepopulated place
2410900Ponta FigoPonta FigoSTSão Tomé IslandLemba District0.356.550Africa/Sao_Tomepopulated place
2410813Santa RitaSTPríncipe1.673577.41120Africa/Sao_Tomepopulated place
11203976CruzeiroSTSão Tomé Island0.290356.67810Africa/Sao_Tomepopulated place
2411101GuardaSTSão Tomé Island0.356.60Africa/Sao_Tomepopulated place
2411153EnjaleEnjaleSTSão Tomé Island0.033336.516670Africa/Sao_Tomepopulated place
2411244BombomBombomSTPríncipe0.310756.728160Africa/Sao_Tomepopulated place
2410723Vila SaraSTSão Tomé IslandLemba District0.333336.583330Africa/Sao_Tomepopulated place
2410960N’zumbiN’zumbi,N’zumbiSTSão Tomé Island0.066676.550Africa/Sao_Tomepopulated place
2410845SalomãoSTPríncipe1.639967.388430Africa/Sao_Tomepopulated place
2411081Ió GrandeSTSão Tomé Island0.216676.616670Africa/Sao_Tomepopulated place
2411008MiranteSTSão Tomé IslandLemba District0.256.516670Africa/Sao_Tomepopulated place
11204205Boa MorteSTSão Tomé Island0.339916.71990Africa/Sao_Tomepopulated place
2410821SantanaSant’Ana,Santana,Sant’AnaSTSão Tomé Island0.254236.74140Africa/Sao_Tomepopulated place
2410811Santa TrindadePico,Santa TrindadeSTPríncipe1.619657.391290Africa/Sao_Tomepopulated place
2410820SantanaSTPríncipe1.664287.43710Africa/Sao_Tomepopulated place
2410906Platô CaféSTSão Tomé Island0.266676.666670Africa/Sao_Tomepopulated place
2411142Fernão DiasSTSão Tomé Island0.416676.683330Africa/Sao_Tomepopulated place
2410998Monte CaféSTSão Tomé Island0.36.650Africa/Sao_Tomepopulated place
2411041MadalenaMadalena,MagdalenaSTSão Tomé Island0.333336.666670Africa/Sao_Tomepopulated place
2410909Planca PrimeiraSTSão Tomé Island0.46.60Africa/Sao_Tomepopulated place
2410744Terra FirmeSTPríncipe1.677627.460360Africa/Sao_Tomepopulated place
2411257B. FaroSTSão Tomé Island0.233336.666670Africa/Sao_Tomepopulated place
2410898Ponta FuradaPonta Furada,Roca Furada,Roça FuradaSTSão Tomé IslandLemba District0.233336.483330Africa/Sao_Tomepopulated place
2410952Oquê GasparSTPríncipe1.646917.412470Africa/Sao_Tomepopulated place
11204403GenerosaSTSão Tomé IslandLemba District0.347376.548160Africa/Sao_Tomepopulated place
2410841Santa AdelaideSTSão Tomé Island0.266676.650Africa/Sao_Tomepopulated place
2411306Água-CôcoAgua-Coco,Água-CôcoSTSão Tomé Island0.056.533330Africa/Sao_Tomepopulated place
2411104GratidãoSTSão Tomé Island0.333336.683330Africa/Sao_Tomepopulated place
2410936ParisSTSão Tomé Island0.333336.683330Africa/Sao_Tomepopulated place
2411166DianaSTSão Tomé Island0.333336.683330Africa/Sao_Tomepopulated place
2410968Nova EstrelaSTPríncipe1.618647.431440Africa/Sao_Tomepopulated place
2410822Santa MariaSTSão Tomé Island0.356.60Africa/Sao_Tomepopulated place
2411011MilagrosaSTSão Tomé IslandMé-Zóchi District0.279596.660290Africa/Sao_Tomepopulated place
2411237Buenos AiresBuenos Aires,Buenos AyresSTSão Tomé Island0.266676.716670Africa/Sao_Tomepopulated place
2410775São ManuelSao Manoel,Sao Manuel,São Manoel,São ManuelSTSão Tomé IslandLemba District0.266676.483330Africa/Sao_Tomepopulated place
2410808Santo AndréSTSão Tomé Island0.333336.70Africa/Sao_Tomepopulated place
2410905Poiso AltoSTSão Tomé Island0.333336.616670Africa/Sao_Tomepopulated place
2411190CatumbelaSTSão Tomé Island0.256.666670Africa/Sao_Tomepopulated place
2410754SequeiraSTPríncipe1.637777.38010Africa/Sao_Tomepopulated place
2410837Santa ClaraSTSão Tomé Island0.356.616670Africa/Sao_Tomepopulated place
2411090Infante Dom HenriqueSTPríncipe1.56757.412190Africa/Sao_Tomepopulated place
2410983M. PeixeSTSão Tomé Island0.46.650Africa/Sao_Tomepopulated place
2410789São JoãoSTSão Tomé IslandCaué District0.083336.550Africa/Sao_Tomepopulated place
2411260Belo MonteSTPríncipe1.679097.441330Africa/Sao_Tomepopulated place
2410840Santa CatarinaSanta Catanna,Santa CatarinaSTSão Tomé IslandLemba District0.271576.472410Africa/Sao_Tomepopulated place
2410836Santa ClotildeSTSão Tomé IslandCaué District0.116676.60Africa/Sao_Tomepopulated place
2411073JavaJavaSTSão Tomé Island0.266676.650Africa/Sao_Tomepopulated place
11203985Vila MariaSTSão Tomé Island0.331116.738860Africa/Sao_Tomepopulated place
11204006Folha FedeSTSão Tomé Island0.2846.6840Africa/Sao_Tomepopulated place
2410798São FranciscoSTSão Tomé IslandCantagalo District0.26.650Africa/Sao_Tomepopulated place
2410763São ToméSalazar,San Tomas,San Tome,San Tomé,San Tomė,San-Tameh,San-Tome,Santo Tome,Santo Tomé,Santome,Sao Thome,Sao Tome,Sao Tomee,Sao Tomé,Sao-Tomeo,Soeo Tome,Svaety Tomas,Svätý Tomáš,Sào Thomé,São Tomé,Söo Tomé,TMS,Urbs Sancti Thomae,cavo tome,sa’o tome,sangtume,santome,savea team,saw twmy,saywtwmh,sea tu me,sheng duo mei,Σάο Τομέ,Сан-Тамэ,Сан-Томе,Сао Томе,Սան Տոմե,סאו טומה,ساؤ ٹومے,سائوتومه,ساو تومي,ساو تۆمێ,ساو ٹومے,साओ टोमे,সাও টোমে,ਸਾਓ ਤੋਮੇ,சாவோ தொமே,സാവോ ടോം,เซาตูเม,སའོ་ཊོ་མེ།,სან-ტომე,ሳን ቶሜ,サントメ,圣多美,聖多美,상투메STSão Tomé IslandÁgua Grande District0.336546.7273253300Africa/Sao_Tomecapital of a political entity
2410982MulondoSTSão Tomé IslandLemba District0.36.516670Africa/Sao_Tomepopulated place
2410778São José PicatéPincate,Pincaté,Sao Jose,Sao Jose Picate,São José,São José PicatéSTPríncipe1.63497.398050Africa/Sao_Tomepopulated place
2410805Santo AntónioCidade de Santo Antonio,Cidade de Santo António,San Antonio,Santo Antonijus,Santo Antonio,Santo António,Santu-Anton’ju,Sao Antonio,São Antõnio,sang tu xang tx ni xu,santuantoniu,santw antwnyw,sheng an dong ni ao,Санто Антонио,Санту-Антонью,سانتو آنتونیو,سانتو انتونیو,ซังตูอังตอนีอู,サント・アントニオ,聖安東尼奧,산투안토니우STPríncipe1.639437.419511156Africa/Sao_Tomeseat of a first-order administrative division
2411245BombaimBombaimSTSão Tomé Island0.256.633330Africa/Sao_Tomepopulated place
2411249Boa EsperançaSTSão Tomé Island0.333336.633330Africa/Sao_Tomepopulated place
2410972NevesNevesSTSão Tomé IslandLemba District0.356716.548970Africa/Sao_Tomepopulated place
2411251BlubluBlubluSTSão Tomé Island0.316676.716670Africa/Sao_Tomepopulated place
2410779São JoséSTSão Tomé IslandLemba District0.216676.50Africa/Sao_Tomepopulated place
2410826Santa JoaquinaSTPríncipe1.611227.403880Africa/Sao_Tomepopulated place
2410802Santo CristoSTPríncipe1.624937.431710Africa/Sao_Tomepopulated place
2411262Bela VistaSTPríncipe1.617797.41350Africa/Sao_Tomepopulated place
2410833Santa CruzSTSão Tomé IslandCaué District0.133336.650Africa/Sao_Tomepopulated place
2411155Dona EugéniaDona Eugenia,Dona EugéniaSTSão Tomé Island0.133336.616670Africa/Sao_Tomepopulated place
2410797São FranciscoSTSão Tomé IslandMé-Zóchi District0.316676.650Africa/Sao_Tomepopulated place
2411056LauraSTSão Tomé Island0.283336.70Africa/Sao_Tomepopulated place
2411241BombonSTSão Tomé Island0.316676.733330Africa/Sao_Tomepopulated place
2410738Trás os MontesTras os Montes,Traz os Montes,Trás os MontesSTSão Tomé Island0.266676.616670Africa/Sao_Tomepopulated place
2411297Alto DouroSTSão Tomé IslandCantagalo District0.26.716670Africa/Sao_Tomepopulated place
2411049LemosLemosSTSão Tomé Island0.36.70Africa/Sao_Tomepopulated place
2410971Neves FerreiraNeves FerreiraSTPríncipe1.549447.397190Africa/Sao_Tomepopulated place
2410990Montes HermíniosSTSão Tomé Island0.256.70Africa/Sao_Tomepopulated place
2411100GuayaquilSTSão Tomé Island0.26.616670Africa/Sao_Tomepopulated place
2410892Porto AlegrePGP,Porto AlegreSTSão Tomé Island0.033336.533330Africa/Sao_Tomepopulated place
2410783São JoaquimSTPríncipe1.620597.377040Africa/Sao_Tomepopulated place
2411115Germinia AntóniaSTPríncipe1.636617.377950Africa/Sao_Tomepopulated place
2410835Santa ClotildeSanta ClotildeSTSão Tomé IslandCantagalo District0.256.70Africa/Sao_Tomepopulated place
2411079IolaSTPríncipe1.640947.373030Africa/Sao_Tomepopulated place
2410997Monte CarmoSTSão Tomé IslandCaué District0.156.583330Africa/Sao_Tomepopulated place
2410994MonteforteSTSão Tomé IslandLemba District0.333336.533330Africa/Sao_Tomepopulated place
2410777São LuísSao Luis,Sao Luiz,São Luiz,São LuísSTSão Tomé Island0.36.616670Africa/Sao_Tomepopulated place
2411036ManteroCorreio,ManteroSTPríncipe1.598817.35320Africa/Sao_Tomepopulated place
2410852Rio LeçaSTSão Tomé IslandLemba District0.356.550Africa/Sao_Tomepopulated place
2410992Monte RaulSTSão Tomé Island0.216676.683330Africa/Sao_Tomepopulated place
2410769São NicolauSTSão Tomé Island0.283336.633330Africa/Sao_Tomepopulated place
11238807Fundação PopularSTSão Tomé Island0.33156.71970Africa/Sao_Tomepopulated place

FaQ about Sao Tome and Principe


Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.