Somalia cities list with latitude and longitude in CSV,SQL,XML,JSON formats

Somalia
Somalia
CSV, SQL, XML, JSON

Last update : 10 December 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

Somalia: A Geographical Overview of the Horn of Africa

Somalia, located on the Horn of Africa, is a country that boasts one of the longest coastlines in Africa, stretching along the Indian Ocean and the Gulf of Aden. With a history that spans thousands of years, Somalia’s geography is deeply intertwined with its culture, economy, and the natural world. The country’s strategic location has made it a crossroads for various civilizations, trade routes, and cultures. For geographers, Somalia presents a fascinating case study in human-environment interactions, regional disparities, and the challenges posed by its diverse landscapes.

Diverse Landscapes and Ecosystems

Somalia’s geography is as varied as it is vast. The country stretches from the humid and fertile coastal regions to the arid, semi-desert interior. The landscape is primarily composed of plateaus, mountain ranges, and vast plains, making it a striking mixture of coastal and inland environments. To the north, the country is bordered by the Gulf of Aden, while to the east lies the Indian Ocean, both offering abundant marine resources and providing important trade routes for the region.

The country’s highest point, Mount Shimbiris, located in the northern Sanaag region, reaches 2,416 meters above sea level. Somalia also features the Jubba and Shabelle rivers, which provide vital water resources to the predominantly dry landscape. These rivers, along with the occasional seasonal rains, are critical for agriculture, especially in the southern and central regions of the country.

In addition to the arid conditions in much of the interior, Somalia’s coastal areas are characterized by rich marine biodiversity, coral reefs, and abundant fish stocks. The combination of these ecological features has made Somalia both a land of contrasts and a site of strategic importance throughout history.

The Administrative Structure: Regions and Cities

Somalia is divided into 18 administrative regions, each with distinct cultural, geographical, and economic characteristics. The regions serve as the key administrative units, and the country’s governance structure is based on these divisions. The capital city, Mogadishu, located on the Indian Ocean coastline, serves as the political, economic, and cultural center of the country. It is also the most populous city in Somalia, playing a key role in trade, governance, and international relations.

Other notable cities include Hargeisa, the capital of Somaliland, which is located in the northern part of the country. This city, while politically distinct due to Somaliland’s push for independence, serves as a critical economic and cultural hub. Kismayo, located in the southern region of Lower Juba, is another important city, known for its port and strategic position along the coast.

Each region in Somalia plays a unique role in the country’s socio-economic fabric. The northern regions, such as Puntland and Somaliland, are characterized by a more stable governance structure, which contrasts with the challenges faced by southern and central Somalia, where conflicts and governance issues persist.

The Importance of Geographic Data for Somalia

Understanding Somalia’s diverse geography requires detailed and accurate geographic data. Access to information about the cities, regions, and their respective coordinates—such as latitude and longitude—helps create a clearer picture of the country’s spatial dynamics. For example, knowing the exact geographic coordinates of key cities like Mogadishu, Hargeisa, or Kismayo enables researchers to analyze patterns in urbanization, population distribution, and resource management.

Geographical data is also essential for understanding the effects of climate change, desertification, and shifting rainfall patterns. Somalia’s primarily arid and semi-arid climate makes it particularly vulnerable to the impacts of climate change, and accurate geographic information helps predict and mitigate potential disasters such as droughts and flooding.

In addition, data on the location of important agricultural zones, water resources, and transportation networks is critical for both regional development and disaster relief efforts. By having access to such data, policymakers can make informed decisions on infrastructure development, resource allocation, and sustainability projects.

Using Geographic Data for Sustainable Development

The ability to obtain comprehensive geographic data on Somalia’s cities and regions opens up many opportunities for sustainable development, particularly in resource management, urban planning, and environmental protection. Somalia’s agricultural economy depends heavily on access to reliable water sources, making it important to map areas with potential for irrigation and agricultural expansion. Regions such as the Shabelle and Jubba river basins are crucial to the country’s agricultural production, and understanding their geographical characteristics helps in developing sustainable farming practices.

Urbanization is also a major issue in Somalia, particularly in cities like Mogadishu, where population growth is rapid. Detailed geographical data enables better planning for urban infrastructure, housing, transportation systems, and the provision of essential services. Understanding the growth patterns and spatial distribution of urban areas allows for more efficient allocation of resources and helps reduce the strain on existing infrastructure.

Furthermore, Somalia’s natural resources, including livestock, fisheries, and minerals, require careful management. Geographical data plays an important role in identifying regions rich in these resources, allowing for the development of policies that promote sustainable use and equitable distribution.

Disaster Preparedness and Geographic Data

Somalia is prone to a variety of natural disasters, including droughts, floods, and cyclones. Having access to precise geographical data allows the government and international organizations to better plan for these events. For example, knowing the exact locations of communities in high-risk areas helps prioritize evacuation routes, disaster response strategies, and relief efforts.

Additionally, geographic data is essential for managing the effects of desertification, which has been a growing concern in many parts of the country. Mapping areas that are particularly vulnerable to land degradation allows for the implementation of reforestation and soil conservation programs, helping to mitigate the long-term impacts of climate change.

Promoting Access to Geographic Data for Somalia

Access to detailed and up-to-date geographic data is vital for effective decision-making and development in Somalia. With the right data, researchers, urban planners, and government agencies can address the country’s most pressing challenges, from resource management to urban growth and environmental sustainability.

By promoting access to geographic data on the cities, regions, and natural features of Somalia, a more informed approach can be taken to tackling issues such as poverty, food security, and infrastructure development. This data also supports international cooperation and assistance efforts, as global organizations work alongside Somalia to achieve sustainable development goals and improve the livelihoods of its citizens.

Conclusion: Harnessing Geographic Data for a Better Future

In conclusion, Somalia’s diverse geography presents both opportunities and challenges for its development. The country’s complex landscape, combined with its unique cultural and political divisions, requires careful planning and management. Access to geographic data—especially the precise location of cities, regions, and resources—is essential for making informed decisions that can drive sustainable development, improve governance, and protect the environment.

For those looking to understand Somalia in greater depth, geographic data offers a powerful tool for exploration and analysis. By gaining access to comprehensive data, Somalia can better address its challenges, harness its resources, and build a more resilient future for its people.

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.