Somalia cities list with latitude and longitude in CSV format

Somalia
Somalia
CSV, SQL, XML, JSON

Last update : 26 May 2024.

Country
Somalia
Capitale
Mogadishu
Number of cities
4288
Download

This is the best list of 4288 cities in the Somalia 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 Somalia file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
62824Ceel BuhCeel BuhSOBari9.089849.58720Africa/Mogadishupopulated place
57873GugumaaleGugumaaleSOBay2.8352544.274250Africa/Mogadishupopulated place
52757Qurac JafleQurac JafleSOHiiraan3.3111945.539540Africa/Mogadishupopulated place
63947Bu BuuleBu Buule,BunleSOMiddle Juba1.1580642.556690Africa/Mogadishupopulated place
51923ShalleedayShalleedaySOLower Shabeelle1.850344.66470Africa/Mogadishupopulated place
62503Cugni FaraSOBay2.5833344.133330Africa/Mogadishupopulated place
57457HaluodSOBari11.7666750.566670Africa/Mogadishupopulated place
8044676IslaawIslaawSOLower Shabeelle1.75744.61680Africa/Mogadishupopulated place
55414KurmanKurmanSOBay2.480442.86980Africa/Mogadishupopulated place
61993DalooldhoDalooldho,DalordoSOWoqooyi Galbeed9.5927144.062290Africa/Mogadishupopulated place
54626Mada UarsisaMada Uarsisa,MatauarsisaSOLower Juba0.8166741.40Africa/Mogadishupopulated place
63857Bulo TumasSOBay3.1833343.616670Africa/Mogadishupopulated place
56379Jameeco AamineyJameeco AamineySOBay2.867244.09630Africa/Mogadishupopulated place
50441WeedhirrWeedhirrSOBay3.2613443.406130Africa/Mogadishupopulated place
54449MajabtoMajabtoSOLower Shabeelle1.7728344.628550Africa/Mogadishupopulated place
58100GorouSOBay2.2027842.685360Africa/Mogadishupopulated place
8537695ShagowShagowSOBay3.095743.59280Africa/Mogadishupopulated place
60397DumodlehDumodle,DumodlehSOSool9.4166747.10Africa/Mogadishupopulated place
53821MoloolowSOMiddle Juba0.8892142.591980Africa/Mogadishupopulated place
65713AgarboaleSOBari10.4833350.816670Africa/Mogadishupopulated place
50578WareegsimoUeregsamo,Ueregsàmo,WareegsimoSOBari11.919450.97150Africa/Mogadishupopulated place
56472Jaag UraJaag UraSOBay2.1420143.569750Africa/Mogadishupopulated place
59114GarasSOLower Juba-0.0256342.540290Africa/Mogadishupopulated place
55033LaloftoLafaftu,Lalaftu,LaloftoSOLower Juba-1.141.266670Africa/Mogadishupopulated place
60087El LeheleiSOHiiraan4.4666745.433330Africa/Mogadishupopulated place
54403MalayleeyMalalaile,MalayleeySOLower Shabeelle1.163143.96820Africa/Mogadishupopulated place
65773AfjiinowAfjiinowSOBay2.9405843.631980Africa/Mogadishupopulated place
51492SudhSud,SudhSOBari8.6666750.366670Africa/Mogadishupopulated place
63145CalidheerCalidheerSOMiddle Shabele2.910345.447460Africa/Mogadishupopulated place
53937MijacaseeyeManja Ase,MijacaseeyeSOTogdheer10.1371745.111080Africa/Mogadishupopulated place
55598KoofireyKoofireySOLower Shabeelle2.6603645.0210Africa/Mogadishupopulated place
60603Doon SoomaaliDoon SoomaaliSOMiddle Shabele3.135645.6560Africa/Mogadishupopulated place
59667FiirfiirisaFiirfiirisa,Fur FursaSOLower Juba0.6613941.910280Africa/Mogadishupopulated place
60166El CalidatSOGedo3.4542.083330Africa/Mogadishupopulated place
52073Scec AvicherScec Avicher,Scek AvicherSOMiddle Shabele3.1333345.833330Africa/Mogadishupopulated place
63928BukhBokh,Bou,Bouk,Bugh,Buka,BukhSOAwdal10.4543.066670Africa/Mogadishupopulated place
56324JedaJedaSOMiddle Shabele2.5728945.349760Africa/Mogadishupopulated place
63228Cadow JuraraCadow Jurara,Godi AroriSOTogdheer9.2692145.420460Africa/Mogadishupopulated place
61314DharaboDharaboSOLower Shabeelle2.344844.80880Africa/Mogadishupopulated place
61400DhajalokhDhajalokhSOLower Shabeelle2.179445.15330Africa/Mogadishupopulated place
58320GolGolSOBay2.9858543.80590Africa/Mogadishupopulated place
60063El UaroEl Uara,El UaroSOGedo3.5666741.650Africa/Mogadishupopulated place
6263954DaraweyneSOWoqooyi Galbeed9.7361144.238610Africa/Mogadishupopulated place
60124El GavoiadSOBari10.3333350.566670Africa/Mogadishupopulated place
65948AboreyAboreySOHiiraan4.0103545.681260Africa/Mogadishupopulated place
64654BariiraBariira,Bariire,Barire,Bulo Erillo,Bùlo ErilloSOMiddle Juba0.5637542.693940Africa/Mogadishupopulated place
49534ZecoSOMudug5.447.516670Africa/Mogadishupopulated place
62857Ceeg BilcilleCeeg Bilcille,El Bilile,`Eik Bil`ileh,‘Eik Bil‘ilehSOTogdheer9.3834745.24540Africa/Mogadishupopulated place
64497Beerta BisikriniBeerta BisikriniSOLower Shabeelle2.128945.0720Africa/Mogadishupopulated place
51732ShimbiraaleShimbiraaleSOWoqooyi Galbeed10.130645.02220Africa/Mogadishupopulated place
63527BuuryaqabBuuryaqabSOMudug7.3458347.618060Africa/Mogadishupopulated place
61380DhallaamocuneDhallaamocune,Musa GhudeirSOTogdheer8.3743746.621990Africa/Mogadishupopulated place
64055BoodaBooda,Bulo BodaSOLower Juba-0.1129342.669890Africa/Mogadishupopulated place
61404DhaharDhaharSOSanaag9.7491748.821940Africa/Mogadishupopulated place
50232XafataSOBay2.4118342.708240Africa/Mogadishupopulated place
55621KombareereKombareereSOLower Shabeelle2.014744.88840Africa/Mogadishupopulated place
52112SarmanSaraman,SarmanSOBakool3.955144.00350Africa/Mogadishupopulated place
57228Hawa OonlowAvai Onole,Hawa OonlowSOMiddle Juba0.9285543.29290Africa/Mogadishupopulated place
59134GarahuleGarahale,GarahuleSOBari10.5666750.633330Africa/Mogadishupopulated place
52671RaaxooleRaaxooleSOLower Shabeelle1.689144.56930Africa/Mogadishupopulated place
62639Cigalle HooleyCigalle HooleySOBay2.7220544.476160Africa/Mogadishupopulated place
50893UrungoUrungoSOLower Juba0.087441.53590Africa/Mogadishupopulated place
60119El GheldaEl Gelda,El GheldaSOGedo4.1333342.750Africa/Mogadishupopulated place
55671KismayoChisimaio,Chisimayu,KMU,Kisimayo,Kisimayu,Kismaanyo,Kismaayo,Kismanyo,Kismayo,Kismayu,Kismānyó,kisumayo,キスマヨSOLower Juba-0.3581742.54536234852Africa/Mogadishuseat of a first-order administrative division
55764KarreCarre,Carrè,KarreSOBay3.2666744.366670Africa/Mogadishupopulated place
50940UnramadeUnramadeSOBakool3.9113943.983970Africa/Mogadishupopulated place
56541IsgaadIsgaadSOLower Shabeelle2.6376145.294310Africa/Mogadishupopulated place
63773BurgaanSOLower Juba0.2534942.833930Africa/Mogadishupopulated place
50099XanlaayXanlaaySOLower Shabeelle1.891344.81750Africa/Mogadishupopulated place
64288BiloiSOBakool4.344.50Africa/Mogadishupopulated place
53419OfidowOfidowSOBakool4.029343.85790Africa/Mogadishupopulated place
61600Deg GonayDeg GonaySOBay3.032243.55460Africa/Mogadishupopulated place
60137Xin DhanaaneEl Endanane,Xin DhanaaneSOGalguduud4.7568246.74880Africa/Mogadishupopulated place
58994GarbahaarreyGBM,Garba Harey,Garba Harre,GarbahaarreySOGedo3.3289242.2209112652Africa/Mogadishuseat of a first-order administrative division
52901QorowleQorowleSOLower Shabeelle1.5134244.129960Africa/Mogadishupopulated place
58270GoloonleGoloonleSOBay2.814243.88770Africa/Mogadishupopulated place
63841BuqBokh,Bugh,Bukh,BuqSOSanaag10.6227547.177990Africa/Mogadishupopulated place
53867MisraSOMiddle Juba0.5020842.758830Africa/Mogadishupopulated place
53831Mola BoraleSOMiddle Shabele3.2166745.766670Africa/Mogadishupopulated place
65741Af UenSOHiiraan3.3036845.138790Africa/Mogadishupopulated place
52064Sciam CuSOLower Juba-1.3670441.730680Africa/Mogadishupopulated place
51243TirroonTirroonSOBay3.078343.46310Africa/Mogadishupopulated place
53196QalaqolQalaqolSOBay2.8366143.951680Africa/Mogadishupopulated place
52388SaabidSaabid,ZabitSOLower Shabeelle2.131145.03770Africa/Mogadishupopulated place
65187Baanyale MubaarakBaanyale MubaarakSOBay2.9969643.773110Africa/Mogadishupopulated place
61644DeebleyDeebleySOMiddle Shabele2.395945.95570Africa/Mogadishupopulated place
57537HafSOLower Juba-0.0542.666670Africa/Mogadishupopulated place
49662YaaqleSOMiddle Juba0.5638142.719430Africa/Mogadishupopulated place
51324TarbaSOMiddle Juba0.8114342.657670Africa/Mogadishupopulated place
65352Audelle IerAudelle Ier,Audelle YerSOBari10.6549.016670Africa/Mogadishupopulated place
52042ScimaSOBay2.9833344.050Africa/Mogadishupopulated place
55011LanbulleSOGedo4.142.183330Africa/Mogadishupopulated place
52574Ras CaddeyRas CaddeySOBay2.55642.86570Africa/Mogadishupopulated place
62757Ceel GuduudCeel Guduud,El Ghebut,El Godut,`El Gudud,‘Ēl GudūdSOGedo3.0833342.60Africa/Mogadishupopulated place
63745BusaarBu Sar,BusaarSOGedo2.6777741.325350Africa/Mogadishupopulated place
54802Lo’anebaLo’aneba,Lo’anebaSOSanaag10.800947.12730Africa/Mogadishupopulated place
61855DaradawanleSOWoqooyi Galbeed9.9971744.19320Africa/Mogadishupopulated place
60842DighelliSONugaal7.8333349.483330Africa/Mogadishupopulated place
51601SindassiSOLower Shabeelle1.3544.283330Africa/Mogadishupopulated place
62844CeelayCeelaySOBari9.7936149.159440Africa/Mogadishupopulated place

FaQ about Somalia


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.