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

Andorra
Andorra
CSV, SQL, XML, JSON

Last update : 15 January 2025.

Country
Andorra
Capitale
Andorra la Vella
Number of cities
59
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
3040132la MassanaLa Macana,La Massana,La Maçana,La-Massana,la Massana,ma sa na,Ла-Массана,ラ・マサナ教区,马萨纳ADLa Massana42.544991.514837211Europe/Andorraseat of a first-order administrative division
3040686EncampEhnkam,Encamp,en kan pu,enkanpu jiao qu,Энкам,エンカンプ教区,恩坎普ADEncamp42.534741.5801411223Europe/Andorraseat of a first-order administrative division
3039320RansolADCanillo42.581371.638120Europe/Andorrapopulated place
3039979LlortsLlors,Llorta,LorsADOrdino42.596251.526580Europe/Andorrapopulated place
7302102La MarginedaMarkhineda,МархинедаADAndorra la Vella42.485991.49024155Europe/Andorrapopulated place
3038999SoldeuADCanillo42.576881.66769602Europe/Andorrapopulated place
3039862MeritxellSanctuaire de Meritxeli,Sanctuaire de Meritxell,Santuari de MeritxellADCanillo42.554031.590870Europe/Andorrapopulated place
8260095Sant Miquel d'EngolastersADEscaldes-Engordany42.511191.559870Europe/Andorrapopulated place
3038832VilaCasas Vila,VilaADEncamp42.531761.566540Europe/Andorrapopulated place
11945497Els VilarsEls VilarsADEscaldes-Engordany42.516361.533560Europe/Andorrapopulated place
3040694El VilarEl VilarADCanillo42.572041.6080Europe/Andorrapopulated place
3039132SegudetSegudetADOrdino42.557131.538080Europe/Andorrapopulated place
3039959LlumeneresLlumeneresADSant Julià de Loria42.472291.511650Europe/Andorrapopulated place
3040141l'AldosaADLa Massana42.543911.52289594Europe/Andorrapopulated place
3039634PalPalADLa Massana42.545921.475240Europe/Andorrapopulated place
3039819MolleresMolleresADCanillo42.550931.589850Europe/Andorrapopulated place
11945537La ComellaLa ComellaADAndorra la Vella42.501171.528790Europe/Andorrapopulated place
3040154La CortinadaLa CortinadaADOrdino42.574231.518450Europe/Andorrapopulated place
3040140l'Aldosa de canilloADCanillo42.578951.62902195Europe/Andorrapopulated place
3040067Les BonsEls BonsADEncamp42.538731.586490Europe/Andorrapopulated place
3039077SisponySisponyADLa Massana42.533681.516130Europe/Andorrapopulated place
3040027Les SalinesADOrdino42.609521.536970Europe/Andorrapopulated place
3039163Sant Julià de LòriaSan Julia,San Julià,Sant Julia de Loria,Sant Julià de Lòria,Sant-Zhulija-de-Lorija,sheng hu li ya-de luo li ya,Сант-Жулия-де-Лория,サン・ジュリア・デ・ロリア教区,圣胡利娅-德洛里亚,圣胡利娅－德洛里亚ADSant Julià de Loria42.463721.491298022Europe/Andorraseat of a first-order administrative division
8260083Bordes d'EnvaliraBordes d'Envalira,Bordes de EnvaliraADCanillo42.559621.685760Europe/Andorrapopulated place
3041098CertersCerters,Certes,Certés,SertesADSant Julià de Loria42.474571.506110Europe/Andorrapopulated place
3039181Santa ColomaSanta ColomaADAndorra la Vella42.494541.498970Europe/Andorrapopulated place
3040051les EscaldesEhskal'des-Ehndzhordani,Escaldes,Escaldes-Engordany,Les Escaldes,esukarudesu=engorudani jiao qu,lai sai si ka er de-en ge er da,Эскальдес-Энджордани,エスカルデス＝エンゴルダニ教区,萊塞斯卡爾德-恩戈爾達,萊塞斯卡爾德－恩戈爾達ADEscaldes-Engordany42.507291.5341415853Europe/Andorraseat of a first-order administrative division
3039604Pas de la CasaPas de la Kasa,Пас де ла КасаADEncamp42.542771.7336120502363Europe/Andorrapopulated place
3040200JuberriJuberri,JuverriADSant Julià de Loria42.441.491940Europe/Andorrapopulated place
10630523Puiol del PiuADLa Massana42.56521.491591660400Europe/Andorrapopulated place
8260082InclesADCanillo42.582851.662670Europe/Andorrapopulated place
3041475AubinyàAubinya,Aubinyà,AuvinyaADSant Julià de Loria42.45311.492470Europe/Andorrapopulated place
3041609AixàsAixas,AixàsADSant Julià de Loria42.486471.468380Europe/Andorrapopulated place
3040437FontanedaFontanedaADSant Julià de Loria42.454051.464710Europe/Andorrapopulated place
3040709Els PlansEls PlansADCanillo42.581431.632730Europe/Andorrapopulated place
3039757NagolNagolADSant Julià de Loria42.471421.502310Europe/Andorrapopulated place
3041543AnyósAnyos,AnyósADLa Massana42.534651.52510Europe/Andorrapopulated place
3040737El SerratLo SerratADOrdino42.61831.539120Europe/Andorrapopulated place
3039678OrdinoOrdino,ao er di nuo,orudino jiao qu,Ордино,オルディノ教区,奥尔迪诺ADOrdino42.556231.533193066Europe/Andorraseat of a first-order administrative division
3039386PratsADCanillo42.560031.593960Europe/Andorrapopulated place
3041519ArinsalArinsal,Arinsal',Arinsalis,arynsal,Аринсал,Аринсаль,آرینسالADLa Massana42.572051.484531419Europe/Andorrapopulated place
3039166Sant Joan de CasellesSan Joan de Casettas,Sant Joan de Casellas,Sant Joan de CasellesADCanillo42.571161.607610Europe/Andorrapopulated place
3040648EngordanyEngordanyADEscaldes-Engordany42.511151.541180Europe/Andorrapopulated place
3038987SornàsSornas,SornàsADOrdino42.564611.527570Europe/Andorrapopulated place
3040025Les SubiranesLes SobiranesADOrdino42.620551.5414716126Europe/Andorrapopulated place
3040601EscàsEscas,EscàsADLa Massana42.546431.508950Europe/Andorrapopulated place
3041541AransAransADOrdino42.582261.518440Europe/Andorrapopulated place
3041598AixovallAixovallADSant Julià de Loria42.47641.488990Europe/Andorrapopulated place
3040609ErtsErcs,Ercz,ErezADLa Massana42.562181.49680Europe/Andorrapopulated place
3041204CanilloCanillo,Kanil'o,ka ni e,kaniryo jiao qu,Канильо,カニーリョ教区,卡尼略ADCanillo42.56761.597563292Europe/Andorraseat of a first-order administrative division
3039896Mas de RibafetaADLa Massana42.569321.488580Europe/Andorrapopulated place
3041563Andorra la VellaALV,Ando-la-Vyey,Andora,Andora la Vela,Andora la Velja,Andora lja Vehl'ja,Andoro Malnova,Andorra,Andorra Tuan,Andorra a Vella,Andorra la Biella,Andorra la Vella,Andorra la Vielha,Andorra-a-Velha,Andorra-la-Vel'ja,Andorra-la-Vielye,Andorre-la-Vieille,Andò-la-Vyèy,Andòrra la Vièlha,an dao er cheng,andolalabeya,andwra la fyla,Ανδόρρα,Андора ла Веля,Андора ла Веља,Андора ля Вэлья,Андорра-ла-Велья,אנדורה לה וולה,أندورا لا فيلا,አንዶራ ላ ቬላ,アンドラ・ラ・ヴェリャ,安道爾城,안도라라베야ADAndorra la Vella42.507791.5210920430Europe/Andorracapital of a political entity
3039901Mas d’AlinsADSant Julià de Loria42.441121.451280Europe/Andorrapopulated place
3038816XixerellaADLa Massana42.553271.487360Europe/Andorrapopulated place
3039154El TarterEhl Tarter,Эл ТартерADCanillo42.579521.653621052Europe/Andorrapopulated place
3039322RàmioADEscaldes-Engordany42.497341.574010Europe/Andorrapopulated place
3041546AnsalongaAnsalongaADOrdino42.568811.521980Europe/Andorrapopulated place
3041604AixirivallAixirivali,Aixirivall,Aixirvall,EixirivallADSant Julià de Loria42.462451.502090Europe/Andorrapopulated place
3041375BixessarriBicisarri,Bixessarri,Bixisarri,Biçisarri,VixesarriADSant Julià de Loria42.481971.460520Europe/Andorrapopulated place

Understanding Andorra: A Geographical Exploration and Data Resource

A Geographical Gem in the Pyrenees

Nestled high in the Pyrenees mountains, between France and Spain, Andorra is a landlocked country that holds a unique position in the heart of Europe. Despite its small size, covering only about 468 square kilometers, Andorra’s geographic diversity and strategic location make it an intriguing subject for geographers. The country is characterized by dramatic mountainous terrain, lush valleys, and a climate that varies significantly between the high-altitude regions and the valleys. The diverse landscape of Andorra not only influences its natural environment but also its cities, settlements, and urban planning, making it an interesting case for study.

Geographically, Andorra is divided into seven parishes, each with its own distinct character and development patterns. The capital, Andorra la Vella, sits at the confluence of the Valira del Norte and Valira del Oriente rivers, surrounded by steep, craggy mountains that give the city both its stunning beauty and its challenges for urban planning. While Andorra’s cities and towns are generally small in size, their placement within the country’s mountainous geography has important implications for infrastructure, tourism, and the way resources are allocated.

For those seeking to study Andorra’s cities, regions, and their spatial relationships, precise data is essential. This is where the comprehensive geographic database I have developed can play a vital role, offering detailed information about the country's cities, including their regions, parishes, and coordinates. By providing this data, I aim to offer geographers, researchers, and urban planners a clearer understanding of Andorra’s geographical structure.

The Parishes and Urban Layout of Andorra

Andorra is divided into seven parishes: Andorra la Vella, Escaldes-Engordany, Encamp, Sant Julià de Lòria, La Massana, Ordino, and Canillo. These parishes are the primary administrative divisions, and each one offers a unique geographical perspective on the country. From the bustling capital of Andorra la Vella to the more tranquil parish of Ordino, the diversity in both the urban and rural landscapes is pronounced.

Andorra la Vella, perched at an altitude of 1,023 meters, is the highest capital city in Europe, providing both an urban setting and spectacular views of the surrounding mountains. It serves as the financial and commercial hub of the country, with a population that swells due to tourism, especially during ski season. In contrast, the parish of Escaldes-Engordany, adjacent to the capital, is known for its thermal springs and tourism-oriented development. The parishes of La Massana and Ordino are more rural, offering a more relaxed atmosphere but also benefiting from proximity to Andorra’s ski resorts.

Each of Andorra’s cities and towns has developed in relation to the geography of its parish. The layout of these cities, nestled between steep mountain slopes or along river valleys, reflects how urbanization has been shaped by the natural terrain. For those seeking to understand the geography of Andorra, it is crucial to look not only at the cities themselves but also at how each one fits within its broader regional context.

The database I’ve developed includes detailed geographic data on each of these parishes, cities, and towns. By providing latitude and longitude coordinates, along with information about their respective regions, the database serves as an invaluable tool for anyone looking to explore Andorra's urban structure in greater detail.

Latitude and Longitude: The Key to Andorra’s Geographic Context

Latitude and longitude coordinates are essential for mapping Andorra’s cities and understanding their geographical relationships. The unique topography of Andorra—characterized by steep slopes, valleys, and ridgelines—means that the cities and towns are often compact but spread out over a relatively small area. Each of the parishes has distinct environmental characteristics that influence the local climate, infrastructure, and human settlement patterns.

The capital, Andorra la Vella, situated at the bottom of a deep valley, experiences a relatively mild climate compared to the higher-altitude areas like Canillo and La Massana. The latitude and longitude of these cities, along with their altitudinal differences, reveal much about their environmental conditions and their suitability for various activities, from agriculture in the valley floors to skiing on the higher peaks.

Through my comprehensive database, users can access accurate latitude and longitude data for each of Andorra’s cities, making it easier to visualize the geographical patterns that shape the country's urbanization and regional development. Whether for academic research, urban planning, or tourism development, understanding the exact coordinates of Andorra’s cities and parishes is crucial for anyone involved in the country’s spatial studies.

Regions and Parishes: Exploring the Administrative Structure

Andorra’s division into seven parishes is not only significant for its administrative functions but also for its geographical diversity. Each parish has distinct characteristics in terms of population density, terrain, and resource availability. For example, Escaldes-Engordany is home to some of the country’s most developed infrastructure, owing to its proximity to Andorra la Vella, while Sant Julià de Lòria, located to the south, has a quieter, more rural character.

The varying geography across Andorra’s parishes also influences land use, from urban centers in the valleys to agriculture and conservation efforts in the highlands. For example, La Massana is known for its ski resorts and agricultural activities in the lower parts of the parish, while the higher altitudes of Canillo are primarily focused on tourism and nature conservation.

Each region and parish of Andorra requires tailored geographic knowledge to understand how the land is used and how development is planned. With this in mind, my geographic database provides detailed information on each parish’s boundaries, its cities, and their respective coordinates. This data is invaluable for understanding how Andorra’s urban and rural areas interact and how the geography of the country shapes its development.

The Importance of Geographic Data for Andorra’s Future

As Andorra continues to develop, understanding its geography becomes increasingly important for sustainable planning, tourism development, and environmental conservation. The country’s unique geographic features, from its mountainous landscapes to its valleys, offer both opportunities and challenges. By providing a comprehensive resource for geographic data, this database helps ensure that decision-making is based on accurate, up-to-date information.

Whether it’s planning for infrastructure, tourism, or environmental protection, understanding the geographic layout of Andorra is essential for future development. By offering detailed latitude and longitude data for each city, region, and parish, the database empowers planners, policymakers, and researchers to make informed decisions that consider the geographical realities of the country.

Conclusion: The Value of Understanding Andorra’s Geography Through Data

Andorra, with its stunning mountain landscapes, vibrant cities, and unique geographical challenges, is a fascinating country to study. Through the comprehensive geographic database I have developed, users can access detailed data on the cities, regions, and parishes of Andorra, including their latitude and longitude coordinates. This resource provides a deeper understanding of the spatial relationships within the country and serves as a critical tool for urban planning, environmental conservation, and tourism development. With accurate geographic data, we can better navigate the opportunities and challenges that lie ahead for Andorra’s future.

FaQ about Andorra

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.