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

Madagascar
Madagascar
CSV, SQL, XML, JSON

Last update : 15 January 2025.

Country
Madagascar
Capitale
Antananarivo
Number of cities
24091
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
1084267AmbalamanakanaMGAmoron’i ManiaAmbositra District-20.7333347.183330Indian/Antananarivopopulated place
1078054AmpasimpotsyMGAlaotra MangoroMoramanga District-18.6833348.016670Indian/Antananarivopopulated place
1081919AmboaimitrohakyMGAndroyBeloha District-24.7666745.050Indian/Antananarivopopulated place
1063796IvoryMGUpper MatsiatraVohibato-21.5666746.916670Indian/Antananarivopopulated place
1060268MarobantyMGBoenyMahajanga II-15.8166746.90Indian/Antananarivopopulated place
1059187MenakanitsyMGIhorombeIvohibe-22.8666746.933330Indian/Antananarivopopulated place
1076481AndampyMGSofiaPort-Berge (Boriziny-Vaovao)-15.5333347.70Indian/Antananarivopopulated place
1059218MazavalanitraMGAtsinananaMarolambo-20.3333347.833330Indian/Antananarivopopulated place
1054586TsinjoarivoMGBongolavaTsiroanomandidy-19.0166745.650Indian/Antananarivopopulated place
1060023MarokoroMGAlaotra MangoroAndilamena District-16.5833348.216670Indian/Antananarivopopulated place
1073959AngodonaMGSofiaPort-Berge (Boriziny-Vaovao)-15.4666747.750Indian/Antananarivopopulated place
1083603AmbararataMGAnosyBetroka District-23.645.750Indian/Antananarivopopulated place
1075835AndondaheMGAtsinananaToamasina II-17.7549.366670Indian/Antananarivopopulated place
1070517AntanimenaMGAnosyAmboasary District-24.746.250Indian/Antananarivopopulated place
1061200ManavonyMGMelakyAntsalova-19.1666744.733330Indian/Antananarivopopulated place
1080144AmbohimenaAmbatomena,AmbohimenaMGBongolavaFenoarivobe-17.9666745.983330Indian/Antananarivopopulated place
1076533AndambarioMGIhorombeIhosy-22.6166746.516670Indian/Antananarivopopulated place
1076954AnalasatranaAnalasatrana,AntsatranaMGDianaAmbilobe-13.0666748.883330Indian/Antananarivopopulated place
1059308MatsaborimangaMGDianaAmbilobe-12.8666749.050Indian/Antananarivopopulated place
1071497AnosibeMGMelakyMaintirano-18.2833344.266670Indian/Antananarivopopulated place
1072057AnkilyMGAndroyTsihombe-25.3666745.533330Indian/Antananarivopopulated place
1060194MarofivikyMGAnosyAmboasary District-24.1833346.450Indian/Antananarivopopulated place
1070746Antanetibe AvaratraAntanetibe Avaratra,Antanetibe NordMGBongolavaTsiroanomandidy-19.0166746.466670Indian/Antananarivopopulated place
1081713AmbodialamponaMGAtsinananaBrickaville-18.548.70Indian/Antananarivopopulated place
1076660AndafiaMGMenabeBelo Sur Tsiribihina-19.3544.80Indian/Antananarivopopulated place
1078168AmpasimarinyAmpasimarina,AmpasimarinyMGBoenyMahajanga II-15.5166746.50Indian/Antananarivopopulated place
1064768FolahantezaMGAnalanjirofoMananara Nord District-16.0166749.533330Indian/Antananarivopopulated place
1077897AmpefyMGSavaVohemar-13.7549.833330Indian/Antananarivopopulated place
1073788AnjahandoakaMGAtsimo-AndrefanaSakaraha District-22.944.550Indian/Antananarivopopulated place
1062882MadiromirafyMGBoenyAmbato Boeni-16.3321246.85240Indian/Antananarivopopulated place
1084472AmbalabeMGMenabeManja District-21.5544.266670Indian/Antananarivopopulated place
1080850AmbodivoahangyMGAtsinananaBrickaville-18.7333348.583330Indian/Antananarivopopulated place
1083515AmbaratraMGVakinankaratraMandoto-19.5666746.466670Indian/Antananarivopopulated place
1077110AnalamavoMGMelakyBesalampy-16.6666744.716670Indian/Antananarivopopulated place
1067470BemambaMGMelakyAntsalova-19.2166744.783330Indian/Antananarivopopulated place
1084557AmbakiranoMGSavaVohemar-13.3666749.783330Indian/Antananarivopopulated place
1062238MahatsinjoMGAtsimo-AtsinananaMidongy-Atsimo-23.0666746.916670Indian/Antananarivopopulated place
1070828AntanantsaraMGAnalamangaAmbohidratrimo District-18.6333347.533330Indian/Antananarivopopulated place
1075931AndohatanyMGVakinankaratraFaratsiho-19.2547.050Indian/Antananarivopopulated place
1084362AmbalahosyMGVatovavy RegionMananjary-21.3833347.933330Indian/Antananarivopopulated place
1059993MaroleoMahaleo,MaroleoMGBoenySoalala-16.1545.233330Indian/Antananarivopopulated place
1077293AnalabeMGFitovinany RegionManakara-21.7833347.833330Indian/Antananarivopopulated place
1073741AnjanaboronaMGBoenyMahajanga II-15.6833346.516670Indian/Antananarivopopulated place
1083036AmbatolahyMGAnosyBetroka District-23.7546.150Indian/Antananarivopopulated place
1056029TaiembetsyMGAndroyTsihombe-25.445.450Indian/Antananarivopopulated place
1063828IvohimalazaIvohimalaza,Vahimalaza,Vohimalaxa,VohimalazaMGIhorombeIhosy-22.1166745.683330Indian/Antananarivopopulated place
1054022VohibolaMGAndroyBeloha District-24.745.10Indian/Antananarivopopulated place
1058424MorarfenaMGBongolavaFenoarivobe-18.4166746.683330Indian/Antananarivopopulated place
1078459AmpapamenabeMGDianaAmbilobe-13.3548.850Indian/Antananarivopopulated place
1082010AmbindaMGAnosyBetroka District-2345.833330Indian/Antananarivopopulated place
1056579SiasiaMGAnosyTaolagnaro-24.7666747.016670Indian/Antananarivopopulated place
1077785AmpiolahanaMGItasySoavinandriana-19.1546.450Indian/Antananarivopopulated place
1083225AmbatofolakaMGAnalanjirofoFenerive Est-17.2549.350Indian/Antananarivopopulated place
1062158MahaveloMGAtsimo-AtsinananaFarafangana District-22.747.70Indian/Antananarivopopulated place
1075419Andranoboaka AndremafanaAndranoboaka Andremafana,AndranomiboakaMGIhorombeIhosy-21.946.016670Indian/Antananarivopopulated place
1068886AntsotahaAntsotaha,AntsotsahaMGSavaVohemar-13.5549.833330Indian/Antananarivopopulated place
1082682AmbatomitsanganaMGAnalamangaAnkazobe District-18.2833347.133330Indian/Antananarivopopulated place
1059073MiakotsoMGBongolavaFenoarivobe-18.646.950Indian/Antananarivopopulated place
1060583Manompy AvaratraMGAlaotra MangoroAndilamena District-16.4166748.116670Indian/Antananarivopopulated place
1057450SahandratyMGVatovavy RegionNosy-Varika-20.5666747.933330Indian/Antananarivopopulated place
1059593MarovatoMGAtsinananaBrickaville-18.6833348.60Indian/Antananarivopopulated place
1073674AnjebaAnjeba,AnjebatobyMGAndroyAmbovombe District-24.9666745.566670Indian/Antananarivopopulated place
1075185AndranomaitsoMGVatovavy RegionIfanadiana-20.8333347.70Indian/Antananarivopopulated place
1062110MahazendaMGFitovinany RegionIkongo-21.8666747.450Indian/Antananarivopopulated place
1076380AndasimbaryMGAtsimo-AndrefanaBetioky District-23.9333344.950Indian/Antananarivopopulated place
1056503SoaindranaMGUpper MatsiatraVohibato-21.5166747.033330Indian/Antananarivopopulated place
1057467SahanantoMGAtsinananaBrickaville-18.5166748.966670Indian/Antananarivopopulated place
1076429AndaparatyMGAnalanjirofoMaroantsetra District-15.249.60Indian/Antananarivopopulated place
1067313BemavoMGAtsimo-AndrefanaBeroroha District-21.6166745.383330Indian/Antananarivopopulated place
1075349AndranofotsyMGAndroyBeloha District-24.9545.083330Indian/Antananarivopopulated place
1075581AndrambonivoryMGAmoron’i ManiaAmbatofinandrahana District-20.6833346.716670Indian/Antananarivopopulated place
1067998BekijanaMGItasySoavinandriana-19.2166746.666670Indian/Antananarivopopulated place
1061962MahitsitadyMGVakinankaratraBetafo District-19.746.833330Indian/Antananarivopopulated place
1066128BetsipangaMGAtsimo-AtsinananaBefotaka-23.946.966670Indian/Antananarivopopulated place
1083747AmbanimangyMGSavaAntalaha-15.2550.433330Indian/Antananarivopopulated place
1081177AmbodimanryMGBetsibokaMaevatanana-16.9666746.80Indian/Antananarivopopulated place
1062601MahamavoMGBetsibokaMaevatanana-16.947.20Indian/Antananarivopopulated place
1076262Andemaky AndrefanaAndemaky Andrefana,Andemaky Ouest,AndemokaMGAnosyBetroka District-23.0545.716670Indian/Antananarivopopulated place
1072236AnkilimaryMGAnosyAmboasary District-23.9833346.333330Indian/Antananarivopopulated place
1075264AndranolavaMGIhorombeIvohibe-22.4547.133330Indian/Antananarivopopulated place
1076543AndalonaMGVakinankaratraBetafo District-19.7166746.516670Indian/Antananarivopopulated place
1074511AndrazatoMGAnosyTaolagnaro-24.647.183330Indian/Antananarivopopulated place
1062611MahamaninaMGSavaVohemar-13.2333349.916670Indian/Antananarivopopulated place
1059653MarotsirakaMarotsifaka,MarotsirakaMGAtsimo-AndrefanaSakaraha District-22.8166744.30Indian/Antananarivopopulated place
1073563AnjilajilaMGVatovavy RegionMananjary-21.2166748.216670Indian/Antananarivopopulated place
1060465MareranoMarerano,MoraranoMGAtsimo-AndrefanaBeroroha District-21.3666744.866670Indian/Antananarivopopulated place
1069224AntsingiloMGMenabeMiandrivazo District-19.2833345.416670Indian/Antananarivopopulated place
1067194BemorampaBemoramba,BemorampaMGMelakyMaintirano-17.1666744.50Indian/Antananarivopopulated place
1083128AmbatoharananaMGAnalamangaAndramasina District-19.2833347.80Indian/Antananarivopopulated place
1084502AmbalabaoMGBetsibokaMaevatanana-17.4333347.183330Indian/Antananarivopopulated place
1060243MarodimakaMGDianaAmbilobe-13.5548.816670Indian/Antananarivopopulated place
1057550SahamamyAntsahamamy,SahamamyMGAlaotra MangoroAmparafaravola District-17.5166748.30Indian/Antananarivopopulated place
1077391AnadabomaroMGAndroyBekily District-24.1833345.750Indian/Antananarivopopulated place
1084391AmbalahambanaMGUpper MatsiatraVohibato-21.6833346.933330Indian/Antananarivopopulated place
1060548ManorokaMGAtsimo-AndrefanaToliara II District-23.5166743.833330Indian/Antananarivopopulated place
1062220MahatsinjokelyMGBoenyAmbato Boeni-16.9166745.966670Indian/Antananarivopopulated place
1061671ManakambahinyMGAtsinananaToamasina II-17.6333349.483330Indian/Antananarivopopulated place
1054049VohibazahaMGAtsinananaBrickaville-18.848.550Indian/Antananarivopopulated place
1070964AntananaboMGAtsimo-AtsinananaFarafangana District-22.8547.80Indian/Antananarivopopulated place
1075811AndongozahelyMGSofiaBefandriana Nord-15.149.250Indian/Antananarivopopulated place

Exploring Madagascar: A Geographical Treasure Trove

The Island of Diversity

Madagascar, the world’s fourth-largest island, is a geographical marvel that sits off the southeastern coast of Africa. It stands as a vibrant hub of biodiversity and ecological importance, with ecosystems that range from lush rainforests to arid deserts. With its rich cultural history and distinctive flora and fauna, Madagascar offers more than just scenic beauty; it’s an island of discovery for geographers, ecologists, and travelers alike.

This island nation’s geographical diversity isn’t limited to its natural landscapes. The urban sprawl, historical sites, and rural territories form a complex web of human habitation, which is further defined by the administrative divisions of its cities, regions, and departments. To truly understand Madagascar's spatial intricacies, one must delve deeper into its geographic data. This includes obtaining critical information about the locations of its cities, regions, and departments, as well as the exact latitude and longitude of these locations.

Urban and Regional Layout: Understanding Madagascar’s Cities

Madagascar’s cities are a mix of bustling urban centers and quieter towns, each contributing to the country’s cultural and economic landscape. The capital city, Antananarivo, stands as the focal point of Madagascar’s urban life, sprawling over the central highlands. However, other cities such as Toamasina, Mahajanga, and Fianarantsoa also play significant roles in the economic and cultural development of the island.

Understanding the layout of these cities within their respective regions and departments offers valuable insights into the regional distribution of Madagascar’s resources, infrastructure, and population. The country is divided into several regions, each with its own set of cities, towns, and administrative divisions that together form a complex but structured territorial framework.

Obtaining detailed geographical data that includes the names of Madagascar's cities, along with their respective regions and departments, is crucial for those studying the island’s development. This data allows geographers to identify patterns in population density, resource allocation, and urban growth. Such detailed knowledge is key to understanding how different regions interact and how each city plays a role in the broader geographic and administrative system of the island.

The Role of Geographic Coordinates

Geographic coordinates — specifically latitude and longitude — provide a precise method for locating any point on Madagascar’s vast expanse. These coordinates allow geographers to map out every city and urban center with accuracy, ensuring that studies of the island’s topography, climate, and infrastructure are grounded in verifiable data.

For instance, mapping the cities of Madagascar with their exact latitude and longitude allows for better understanding of their spatial relationships, from the way transportation networks interconnect to the impact of geographic location on economic activities. Furthermore, knowing the exact geographic coordinates of cities can help in the study of environmental factors, such as the influence of altitude on weather patterns or the distribution of plant and animal species.

Accessing accurate and up-to-date geographic coordinates for every major city on Madagascar provides crucial data for scientists, policymakers, and anyone interested in the island's physical geography. This information is especially important for planning purposes, such as the development of infrastructure, environmental conservation efforts, and disaster management strategies.

Mapping Madagascar: From the Highlands to the Coastlines

Madagascar’s unique topography plays a major role in shaping the lives of its inhabitants. The island is characterized by a central highland region surrounded by coastal plains, which significantly affect the distribution of cities and human settlements. The combination of rugged mountains, fertile valleys, and extensive coastline creates a dynamic geographical environment that requires in-depth analysis to understand how the human population has adapted to and interacted with these features.

For those looking to study Madagascar in a more structured way, access to comprehensive geographical data—detailing cities, regions, and departments—is indispensable. This kind of data not only enhances understanding of urban planning and development but also aids in the study of environmental conservation. For example, knowing the precise location of a city in relation to surrounding ecosystems can inform efforts to preserve Madagascar's biodiversity while balancing the need for economic development.

By having access to the latitude and longitude of each city, one can map the geographical features of Madagascar with greater precision, enhancing studies in various fields such as transportation, ecology, and climatology.

Unlocking the Full Potential of Madagascar’s Geography

For anyone eager to explore the full geographical landscape of Madagascar, obtaining detailed city, region, and department data is essential. With this information, one can uncover insights into the spatial organization of the island, assess the environmental impacts of urbanization, and understand the complex relationships between human settlements and natural resources.

A comprehensive database that includes geographical coordinates and city information offers unparalleled access to Madagascar’s geography. Whether for academic research, urban development projects, or environmental conservation efforts, this data empowers individuals to study the island from a multidimensional perspective, revealing the intricate and unique geographical features that define Madagascar.

FaQ about Madagascar

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.