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

Spain
Spain
CSV, SQL, XML, JSON

Last update : 10 December 2024.

Country
Spain
Capitale
Madrid
Number of cities
22946
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
3105043Villar de los PisonesVillar de los PisonesESCastille and LeónProvincia de Zamora42.0725-6.511240Europe/Madridpopulated place
3118915LasiesoESAragonProvincia de Huesca42.42314-0.437480Europe/Madridpopulated place
3119041Las AlboredasLas Albaredas,Las AlboredasESValenciaProvíncia de Castelló40.533-0.295750Europe/Madridpopulated place
3128175BermelloESGaliciaProvincia da Coruña43.1401-8.928380Europe/Madridpopulated place
3114974OreitiaOreitiaESBasque CountryAraba / Álava42.85666-2.559040Europe/Madridpopulated place
3118371LineresESAsturiasProvince of Asturias43.43159-5.872470Europe/Madridpopulated place
8504772MadariaESBasque CountryAraba / Álava43.0448-3.082560Europe/Madridpopulated place
2515340Las LagunetasESCanary IslandsProvincia de Santa Cruz de Tenerife28.31667-16.783330Atlantic/Canarypopulated place
3118462LiberLiber,San RemigioESGaliciaProvincia de Lugo42.86443-7.093530Europe/Madridpopulated place
3125278CésarCesar,César,Santa Maria,Santa MaríaESGaliciaProvincia da Coruña42.96667-8.416670Europe/Madridpopulated place
3126907CamasobresCamasobresESCastille and LeónProvincia de Palencia43.01541-4.488220Europe/Madridpopulated place
3117244Masía de VisenMas de Visen,Masia de Visen,Masía de VisenESValenciaProvíncia de Castelló40.25-0.233330Europe/Madridpopulated place
3107624TrabazosESGaliciaProvincia de Ourense42.28195-7.186620Europe/Madridpopulated place
2515865La IglesiaCortijada La Iglesia,La IglesiaESAndalusiaProvincia de Jaén37.82497-3.890830Europe/Madridpopulated place
2515895La HerreraLa HerreraESAndalusiaProvincia de Jaén38.2-2.916670Europe/Madridpopulated place
2521066BenimametBenimametESValenciaProvíncia de València39.5-0.416670Europe/Madridpopulated place
3116467MoñíoESAsturiasProvince of Asturias43.38927-5.313610Europe/Madridpopulated place
3128278BenesoESGaliciaProvincia da Coruña42.75-8.95112Europe/Madridpopulated place
2513863Mina San MiguelESAndalusiaProvincia de Sevilla37.88333-60Europe/Madridpopulated place
3124347CousoCouzoESGaliciaProvincia da Coruña42.51975-9.037280Europe/Madridpopulated place
3126743Camporredondo de AlbaCamporredonde,Camporredondo,Camporredondo de AlbaESCastille and LeónProvincia de Palencia42.89572-4.74630Europe/Madridpopulated place
12156674San Miguel de BarcalaESGaliciaProvincia de Pontevedra42.73416-8.597580Europe/Madridpopulated place
3118931Las FraguasLas FraguasESCastille and LeónProvincia de Soria41.69491-2.717740Europe/Madridpopulated place
3110824San BlasBarrio de San Blas,San BlasESAragonProvincia de Teruel40.36016-1.178680Europe/Madridpopulated place
3109253SegovielaSegovielaESCastille and LeónProvincia de Soria41.92444-2.416660Europe/Madridpopulated place
2520009Casa de MeginaCasa de Megina,Casa de MejinaESAndalusiaProvincia de Sevilla37.38333-6.10Europe/Madridpopulated place
11280835Barrio Los MenoresESCanary IslandsProvincia de Santa Cruz de Tenerife28.14103-16.755740Atlantic/Canarypopulated place
2565081La MedianaESAndalusiaProvincia de Huelva37.13673-6.616370Europe/Madridpopulated place
2511633SabioteSabioteESAndalusiaProvincia de Jaén38.06916-3.314483958Europe/Madridpopulated place
3128681BarjaESGaliciaProvincia de Lugo42.48333-7.233330Europe/Madridpopulated place
3105787VilelaSanta Maria,Santa María,VilelaESGaliciaProvincia de Ourense42.38333-8.016670Europe/Madridpopulated place
3123029EscaleraEscaleraESCastille-La ManchaProvincia de Guadalajara40.77041-2.026950Europe/Madridpopulated place
3113411PiñuelPinuel,PiñuelESCastille and LeónProvincia de Zamora41.34923-6.018070Europe/Madridpopulated place
3106287Vega de RiacosVega de RiacosESCastille and LeónProvincia de Palencia42.75464-4.675394Europe/Madridpopulated place
2516815Hambre VivaCasas Hambre Gorda,Caserio Hambre Viva,Caserío Hambre Viva,Hambre VivaESMurciaMurcia37.96094-0.971750Europe/Madridpopulated place
3129908AraduengaESCastille and LeónProvincia de Burgos43.09647-3.171620Europe/Madridpopulated place
3115831MuroMuro,San JuanESGaliciaProvincia de Lugo42.85-7.40Europe/Madridpopulated place
6461763Vinya GranVinya GranESCataloniaProvíncia de Girona42.296942.950790Europe/Madridpopulated place
3118844Las SalinasCaserio de las Salinas,Caserío de las Salinas,Las SalinasESCastille and LeónProvincia de Valladolid41.26873-4.931790Europe/Madridpopulated place
3105934ViladamatViladamatESCataloniaProvíncia de Girona42.132993.075550Europe/Madridpopulated place
3117141MatienaMatiana,MatienaESBasque CountryBizkaia43.16667-2.60Europe/Madridpopulated place
3119655La GranadaLa GranadaESCataloniaProvíncia de Barcelona41.378161.719021566Europe/Madridpopulated place
3111921RevillaESCantabriaProvincia de Cantabria43.40642-3.866160Europe/Madridpopulated place
3128120BerrocalilloBerrocalillo,Caserio Berrocalillo,Caserío BerrocalilloESExtremaduraProvincia de Cáceres40.03532-6.113320Europe/Madridpopulated place
3122906EspasaESAsturiasProvince of Asturias43.57567-5.763620Europe/Madridpopulated place
2521387BaldazosBaldazos,Caserio Baldazos,Caserío BaldazosESMurciaMurcia37.69171-1.621310Europe/Madridpopulated place
3112066RejaESGaliciaProvincia de Lugo43.51667-7.266670Europe/Madridpopulated place
3119974LabarcesLabarcesESCantabriaProvincia de Cantabria43.32531-4.393040Europe/Madridpopulated place
3122270FontenlaFontenla,San MamedESGaliciaProvincia de Pontevedra42.16667-8.483330Europe/Madridpopulated place
3104802VillasoplizESCastille and LeónProvincia de Burgos42.92425-3.696560Europe/Madridpopulated place
3112191ErrekaldeErrekalde,RecaldeESBasque CountryBizkaia43.2-3.083330Europe/Madridpopulated place
3113132Portela de PortomouriscoESGaliciaProvincia de Lugo42.34537-7.133570Europe/Madridpopulated place
3119079LarráinzarESNavarreProvincia de Navarra42.97826-1.696260Europe/Madridpopulated place
3119197A PoblaESGaliciaProvincia de Ourense42.41667-7.016670Europe/Madridpopulated place
3129995AnlloAnlloESGaliciaProvincia de Ourense42.38875-8.090440Europe/Madridpopulated place
3108841SobredaESGaliciaProvincia de Lugo42.67007-7.595760Europe/Madridpopulated place
2511069Santiago de MoraSantiago de Mora,Santiago de MoroESCastille-La ManchaProvincia de Albacete38.57093-1.599730Europe/Madridpopulated place
3130015AnguixESCastille-La ManchaProvincia de Cuenca40.43269-2.806530Europe/Madridpopulated place
3124481CortegadaESGaliciaProvincia de Ourense42.11725-7.645290Europe/Madridpopulated place
3114049PedruelESAragonProvincia de Huesca42.26193-0.087230Europe/Madridpopulated place
12495708NázaraESGaliciaProvincia de Ourense42.33723-8.097750Europe/Madridpopulated place
9036842CabopinoESAndalusiaProvincia de Málaga36.49042-4.742830Europe/Madridpopulated place
3113164PorqueroPorquero,PorquerosESCastille and LeónProvincia de León42.59953-6.10770Europe/Madridpopulated place
2521347Baños de ZújarESAndalusiaProvincia de Granada37.59746-2.81510Europe/Madridpopulated place
3118757LauríaESAsturiasProvince of Asturias43.43333-5.516670Europe/Madridpopulated place
3111174SabugueiraSabugueira,San PelayoESGaliciaProvincia da Coruña42.9-8.416670Europe/Madridpopulated place
3128103BeruntzaESBasque CountryGipuzkoa42.97977-2.292250Europe/Madridpopulated place
3118554LeioaLeioa,Lejoa,Lejona,Lekhona,lai ao a,layaywa,reioa,Лейоа,Лехона,لايايوا,レイオア,莱奥阿ESBasque CountryBizkaia43.32686-2.9888431197Europe/Madridpopulated place
2518563El CharcoEl CharcoESCanary IslandsProvincia de Santa Cruz de Tenerife28.51667-17.850Atlantic/Canarypopulated place
3121692Gallinero de ArcallanaGallinero,Gallinero de ArcallanaESAsturiasProvince of Asturias43.54025-6.341350Europe/Madridpopulated place
3122513Ferreiros de BalboaESGaliciaProvincia de Lugo42.80994-7.176210Europe/Madridpopulated place
3104242Barrio ZuaztoiESNavarreProvincia de Navarra43.18333-1.50Europe/Madridpopulated place
3113281PoboledaPoboledaESCataloniaProvíncia de Tarragona41.234830.84534339Europe/Madridpopulated place
3125553CebránsCebrans,CebránsESGaliciaProvincia da Coruña43.07728-9.165290Europe/Madridpopulated place
3125966CastañeraESAsturiasProvince of Asturias43.23692-6.248890Europe/Madridpopulated place
3114363ParadapiñolParadapinol,Paradapiñol,Paradepinol,ParadepiñolESGaliciaProvincia de Lugo42.48148-7.167470Europe/Madridpopulated place
2511306Sanlúcar de BarramedaSan Lucar de Barrameda,Sanlucar,Sanlucar de Barrameda,Sanlukar de Barameda,Sanlukar-de-Barrameda,Sanlúcar,Sanlúcar de Barrameda,Sunlucar de Barrameda,san luk arde bar ra me da,sang lu ka er de wa la mei da,sanlukaleudebalameda,shlwqt,Санлукар де Барамеда,Санлукар-де-Баррамеда,شلوقة,ซานลูการ์เดบาร์ราเมดา,სანლუკარ-დე-ბარამედა,サンルーカル・デ・バラメーダ,桑卢卡尔德瓦拉梅达,산루카르데바라메다ESAndalusiaProvincia de Cádiz36.77808-6.351568037Europe/Madridpopulated place
2518649El CampilloCaserio El Campillo,Caserío El Campillo,El CampilloESAndalusiaProvincia de Cádiz36.65-6.316670Europe/Madridpopulated place
3123829DonsiónDonsion,Donsión,Santa EulaliaESGaliciaProvincia de Pontevedra42.66033-8.153290Europe/Madridpopulated place
3121327GomeciegoGomeciegoESCastille and LeónProvincia de Salamanca41.02607-6.312910Europe/Madridpopulated place
3116881Mequinensa / MequinenzaMequinensa,Mequinensa / Maquinenza,MequinenzaESAragonProvincia de Zaragoza41.372110.301692479Europe/Madridpopulated place
2517064GrañenaCortijada Granena,Cortijada Grañena,Granena,GrañenaESAndalusiaProvincia de Jaén37.84994-3.761220Europe/Madridpopulated place
3106972Valdecolmenas de ArribaESCastille-La ManchaProvincia de Cuenca40.09775-2.441530Europe/Madridpopulated place
3119582LaiñoLaino,Laiño,San JuanESGaliciaProvincia de Pontevedra42.71667-8.716670Europe/Madridpopulated place
3120362InsúaSalvador,San SalvadorESGaliciaProvincia de Lugo42.71379-7.714290Europe/Madridpopulated place
7115328Saliente BajoESAndalusiaAlmería37.46384-2.150290Europe/Madridpopulated place
3128216BercimuelleBercimuelle,Caserio Bercimuelle,Caserío BercimuelleESCastille and LeónProvincia de Ávila40.84584-5.152520Europe/Madridpopulated place
3124043CulebrosCulebrosESCastille and LeónProvincia de León42.6417-6.103770Europe/Madridpopulated place
3120444IgenaIgenaESAsturiasProvince of Asturias43.39455-5.018670Europe/Madridpopulated place
6325356AzpilgoetaAzpilgoetaESBasque CountryGipuzkoa43.25422-2.388420Europe/Madridpopulated place
3114714OvellarizaOvellarizaESAsturiasProvince of Asturias43.31015-6.980450Europe/Madridpopulated place
3124901Cobos Junto a la MolinaESCastille and LeónProvincia de Burgos42.53398-3.60970Europe/Madridpopulated place
3125745Castrillo de HayaESCantabriaProvincia de Cantabria42.91216-4.174620Europe/Madridpopulated place
3110852Sant Antoni de VilamajorSan Antonio de Vilamajor,Sant Antoni de VilamajorESCataloniaProvíncia de Barcelona41.666672.40Europe/Madridpopulated place
3129346ArtaArtaESBasque CountryBizkaia43.24342-2.536280Europe/Madridpopulated place
3125626Castroserna de ArribaCastroserna de ArribaESCastille and LeónProvincia de Segovia41.19029-3.716030Europe/Madridpopulated place
3104879VilarrasoESGaliciaProvincia da Coruña43.18333-8.033330Europe/Madridpopulated place
3107034ValdazoValdazoESCastille and LeónProvincia de Burgos42.52464-3.362450Europe/Madridpopulated place
6459074el Morassacel MorassacESCataloniaProvíncia de Girona42.33392.997250Europe/Madridpopulated place
3122200Fornelos de CovaFornelos de CovaESGaliciaProvincia de Ourense42.2073-7.10820Europe/Madridpopulated place

Spain: A Geographical Portrait of Diversity and Heritage

Spain, located in the southwestern corner of Europe, is a country of contrasts. From its lush, green landscapes in the north to the sun-soaked beaches of the Mediterranean in the south, Spain’s geographical diversity is matched only by its rich cultural heritage. As a geographer, one finds in Spain a fascinating study of how diverse landscapes, climates, and regional identities shape both the environment and society. Understanding Spain’s spatial structure requires detailed geographic data, including information on its cities, regions, and departments. This data is crucial for comprehending the intricacies of urban development, population distribution, and regional cooperation across this complex country.

A Country of Contrasting Landscapes

Spain’s varied topography is one of its defining features. The country is dominated by a vast central plateau, known as the Meseta, which is encircled by mountain ranges such as the Pyrenees in the north and the Sierra Nevada in the south. The central plateau is flanked by the fertile valleys of the Ebro, Guadalquivir, and Tagus rivers, which are vital for Spain’s agriculture and water resources. These rivers provide much-needed irrigation for the country’s most productive farming regions.

The northern regions, including Galicia and Asturias, are characterized by a temperate maritime climate, which results in lush forests, rolling hills, and a coastline dotted with estuaries and cliffs. In contrast, the southern part of Spain, particularly in regions like Andalusia, is known for its arid landscapes, dotted with olive groves and deserts that transition into Mediterranean-style coastal areas. The Canary Islands, located off the northwest coast of Africa, and the Balearic Islands in the Mediterranean, add even more diversity to Spain’s physical geography.

This geographical variety significantly influences the cultural and economic landscapes across Spain. From agriculture to tourism, each region’s physical environment provides a backdrop for local economies and ways of life, underscoring the importance of geographic data for understanding Spain’s development.

The Administrative Divisions: Regions, Provinces, and Cities

Spain is divided into 17 autonomous communities, each with its own distinct geographical, cultural, and political identity. These communities are further divided into provinces, which serve as administrative units. These regions and provinces play a critical role in Spain’s political landscape, with some, like Catalonia and the Basque Country, having significant political autonomy due to their distinct linguistic and cultural histories.

The capital of Spain, Madrid, is located in the heart of the country, and serves as both the political and economic center. Madrid is not only the largest city in Spain but also one of the most significant urban hubs in Europe. The city’s central location on the Iberian Peninsula has historically made it a nexus for trade, culture, and government.

Other major cities in Spain, such as Barcelona, Valencia, and Seville, contribute to the country’s vibrant cultural fabric. Barcelona, located in Catalonia, is known for its modernist architecture and Mediterranean charm. Seville, in Andalusia, showcases Spain’s rich Moorish heritage and cultural traditions. Valencia, with its blend of historic and contemporary architecture, underscores Spain’s role as a crossroads of European and global influences.

Each of Spain’s regions has its own geographical and cultural characteristics, influenced by the country’s diverse topography and climate. For instance, the Mediterranean coast is home to cities like Valencia and Alicante, which have developed around their seaside locations, while the northern provinces like Galicia and the Basque Country are more heavily forested and have a wetter climate that has shaped local agriculture and industries.

Geographic Data: Unlocking Insights into Spain’s Regional Dynamics

Geographic data plays a crucial role in understanding the spatial organization of Spain. Information about the latitude and longitude of Spain’s cities, along with their corresponding regions and provinces, provides valuable insights into patterns of settlement, economic activity, and infrastructure development. Having access to this geographic data allows for more effective planning and resource management, particularly in urban centers and areas with significant economic activity.

For example, knowing the exact coordinates of cities like Madrid, Barcelona, or Seville helps geographers and planners assess factors such as population density, traffic flow, and accessibility to key services. Geographic data is also essential for understanding the distribution of natural resources, including water availability and agricultural land, which are critical for managing Spain’s diverse landscapes.

Furthermore, data on Spain’s regions and provinces helps to identify disparities in development and the allocation of resources. For instance, while Catalonia and the Basque Country are among the most economically advanced regions of Spain, other areas, such as Extremadura and parts of Andalusia, face challenges related to underdevelopment and rural depopulation. Detailed geographic data allows for a more nuanced understanding of these regional differences and can guide policies aimed at improving regional equity and economic opportunity.

Regional Development and Urbanization in Spain

Spain’s rapid urbanization over the past century has been a key factor in the country’s economic transformation. With a highly concentrated urban population, Spain has developed a network of large cities and metropolitan areas, with Madrid and Barcelona leading the way. These cities have become international centers for culture, commerce, and tourism, driving Spain’s growth in the global economy.

However, urbanization has also brought challenges, including congestion, pollution, and regional inequality. Many of Spain’s smaller cities and rural areas have struggled to keep pace with the economic development seen in urban centers. This has led to a trend of rural-to-urban migration, with young people and families seeking better job opportunities and living conditions in Spain’s major cities. Geographic data on migration patterns, housing trends, and economic activity can help to better understand these dynamics and inform policies aimed at reducing regional disparities.

At the same time, Spain’s regional governments play an essential role in addressing local issues and promoting sustainable development. The autonomous communities have the authority to implement regional development plans, focusing on areas such as education, healthcare, infrastructure, and environmental conservation. Geographic data on regional resources, population distribution, and environmental conditions is crucial for these efforts.

Spain’s Environmental Management and Sustainability

Spain’s diverse geography presents both opportunities and challenges when it comes to environmental management. The country is home to a variety of ecosystems, ranging from the semi-arid landscapes of the south to the temperate forests of the north. Spain also has a rich natural heritage, including national parks, wildlife reserves, and coastal areas that attract both residents and tourists alike.

The country’s environment, however, faces significant threats, including desertification, deforestation, and climate change. Spain has been experiencing more frequent droughts, especially in its southeastern regions, and its coastal areas are vulnerable to rising sea levels. Geographic data plays a vital role in understanding these challenges, as it helps to monitor environmental changes, track the movement of endangered species, and identify regions most at risk from climate impacts.

For example, the use of geographic information systems (GIS) can help track land-use changes, monitor deforestation in protected areas, and assess the effectiveness of water conservation efforts. Data on the geographic location of natural resources, such as rivers and forests, is essential for managing Spain’s environment in a way that balances development with ecological preservation.

Conclusion: The Power of Geographic Data for Spain’s Future

In conclusion, Spain’s diverse geography is a fundamental aspect of its identity and development. From its mountain ranges and rivers to its vibrant cities and rural landscapes, the country’s physical environment shapes its economy, culture, and regional dynamics. Geographic data, particularly the latitude and longitude of its cities and regions, is essential for understanding Spain’s spatial organization and the distribution of resources.

With accurate geographic data, Spain can continue to promote balanced regional development, manage its natural resources effectively, and address environmental challenges. Whether for urban planning, sustainability efforts, or economic growth, geographic data is key to Spain’s future success. Accessing and utilizing such data ensures that policies and strategies are informed by a clear understanding of the country’s complex geographical landscape.

FaQ about Spain

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.