Puerto Rico cities list with latitude and longitude in Excel, CSV, SQL, XML, JSON formats

Puerto_Rico
Puerto Rico
Excel, CSV, SQL, XML, JSON

Last update : 16 December 2025.

Country
Puerto Rico
Capital
San Juan
Number of cities
2471
Download
Click here

This is the best list of 2471 cities in the Puerto Rico available in 5 formats ( Excel, CSV, JSON, SQL, XML ). You will find only data associated with the cities of a country (capital, towns and villages). There is no information concerning the environment, such as the location of a river or a mountain, for example. All cities are 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 Puerto Rico file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
4562709BajaderoPRAreciboDomingo Ruíz Barrio18.42661-66.68323253877America/Puerto_Ricopopulated place
4564922Extension Jardines de Santa IsabelPRSanta IsabelSanta Isabel Barrio-Pueblo17.97052-66.406100America/Puerto_Ricopopulated place
4565967Las MercedesPRLoízaCanóvanas Barrio18.42022-65.8915530America/Puerto_Ricopopulated place
4565197Hacienda EugeniaPRAñascoHatillo Barrio18.29773-67.1876850America/Puerto_Ricopopulated place
4565521Iglesia Virgen de la ProvidenciaPRComeríoCedrito Barrio18.24829-66.194064160America/Puerto_Ricopopulated place
7275044Ceiba ComunidadPRVega AltaSabana Barrio18.44336-66.34682210America/Puerto_Ricopopulated place
4566427Oasis GardensPRGuaynabo18.378-66.09544590America/Puerto_Ricopopulated place
4567669Residencial Jardines de CidraPRCidraSud Barrio18.17329-66.165174290America/Puerto_Ricopopulated place
4565964Las MercedesPRAreciboTanamá Barrio18.45606-66.7204530America/Puerto_Ricopopulated place
4562832BayamonPRCidraBayamón Barrio18.17774-66.113224341699America/Puerto_Ricopopulated place
4565922Las CántarasLas CantarasPRAreciboArrozal Barrio18.37523-66.671292430America/Puerto_Ricopopulated place
4565195Hacienda EsperanzaPRPeñuelasRucio Barrio18.11135-66.716846120America/Puerto_Ricopopulated place
4565722KennedyPRPeñuelasCoto Barrio18.06552-66.7274790America/Puerto_Ricopopulated place
4566909ProvidenciaPRPatillasPollos Barrio17.98747-66.003570America/Puerto_Ricopopulated place
7276376Orocovis Zona UrbanaPROrocovisOrocovis Barrio-Pueblo18.2257-66.391625050America/Puerto_Ricopopulated place
7276404Aibonito Zona UrbanaPRAibonitoAibonito Barrio-Pueblo18.13983-66.265826030America/Puerto_Ricopopulated place
4565279Hacienda PietriPRAdjuntasGuilarte Barrio18.17218-66.771295940America/Puerto_Ricopopulated place
4565266Hacienda MogotePRYauco18.11274-66.80997710America/Puerto_Ricopopulated place
4562570Alturas de BoriquenPRAguas Buenas18.35689-66.0685600America/Puerto_Ricopopulated place
4564197El FrutalPRBayamónHato Tejas Barrio18.39662-66.19294610America/Puerto_Ricopopulated place
7274982Pueblito Del Río ComunidadPueblito Del Rio Comunidad,Pueblito Del Río ComunidadPRLas PiedrasEl Río Barrio18.22802-65.86157830America/Puerto_Ricopopulated place
4562944Boulevardo Buenos AiresPRAreciboArecibo Barrio-Pueblo18.4705-66.7185110America/Puerto_Ricopopulated place
4568671Villa del AlarPRSan JuanMonacillo Urbano Barrio18.36634-66.0735690America/Puerto_Ricopopulated place
4566512Parcelas NuevasPRCidraRincón Barrio18.14024-66.172394331628America/Puerto_Ricopopulated place
4562784Barriada ClanPRHatilloHatillo Barrio-Pueblo18.48411-66.82268130America/Puerto_Ricopopulated place
4565305Hacienda San IsidoroColonia San IsidoroPRPatillasJacaboa Barrio17.97774-65.9723980America/Puerto_Ricopopulated place
4568073San AntonioPRCaguasCaguas Barrio-Pueblo18.24357-66.03017540America/Puerto_Ricopopulated place
4565953Las LomasPRSan JuanGobernador Piñero Barrio18.39162-66.09517300America/Puerto_Ricopopulated place
4565268Hacienda MonserratePRLaresRío Prieto Barrio18.19051-66.880453750America/Puerto_Ricopopulated place
4568013Sabana GardensPRCarolinaSabana Abajo Barrio18.41439-65.9723930America/Puerto_Ricopopulated place
4568733VolcanPRToa Baja18.42078-66.186230America/Puerto_Ricopopulated place
4567688Residencial Los NaranjalesPRCarolinaBuena Vista Barrio (Inactive)18.3905-65.9546170America/Puerto_Ricopopulated place
4562921BorrásBorrasPRLuquilloJuan Martín Barrio18.3544-65.69238280America/Puerto_Ricopopulated place
4566517Park GardensPRSan JuanSabana Llana Sur Barrio18.38884-66.03211520America/Puerto_Ricopopulated place
4563382CeladaPRGuraboCelada Barrio18.27162-65.966794435America/Puerto_Ricopopulated place
4566257Minima San AntonioPRDoradoHiguillar Barrio18.45939-66.2668380America/Puerto_Ricopopulated place
4565276Hacienda ParaísoHacienda ParaisoPRPonceReal Barrio18.10163-66.572392110America/Puerto_Ricopopulated place
7274978Playita ComunidadPRYabucoaCalabazas Barrio18.04048-65.90711890America/Puerto_Ricopopulated place
4565203Hacienda FigueroaPROrocovisAla de la Piedra Barrio18.19024-66.512675670America/Puerto_Ricopopulated place
4568652Villa RetiroPRSanta IsabelSanta Isabel Barrio-Pueblo17.96969-66.41239100America/Puerto_Ricopopulated place
4565758La EstancitaPRUtuadoRoncador Barrio18.25162-66.762125600America/Puerto_Ricopopulated place
7276407Arroyo Zona UrbanaPRArroyoArroyo Barrio-Pueblo17.96885-66.06134100America/Puerto_Ricopopulated place
7275042Carrizales ComunidadPRHatilloCarrizales Barrio18.48107-66.78788330America/Puerto_Ricopopulated place
4564932Extension San JosePRCialesJaguas Barrio18.33328-66.47239800America/Puerto_Ricopopulated place
4568543Venus GardensPRSan JuanSabana Llana Sur Barrio18.37523-66.03794440America/Puerto_Ricopopulated place
4565655Jardines de LaresPRLaresLares Barrio-Pueblo18.29079-66.886013650America/Puerto_Ricopopulated place
4565636Jardines de AnascoPRAñascoDagüey Barrio18.28884-67.13685110America/Puerto_Ricopopulated place
4565653Jardines de LafayettePRArroyoGuásimas Barrio17.97052-66.06516100America/Puerto_Ricopopulated place
8335064MerceditaPRPonceVayas Barrio18.01098-66.563160America/Puerto_Ricopopulated place
4564220El ParadisoPRSan JuanCupey Barrio18.38023-66.05822200America/Puerto_Ricopopulated place
4563866Colinas de Fair ViewPRTrujillo AltoCarraízo Barrio18.35745-66.03183670America/Puerto_Ricopopulated place
4565117GuaydíaGuaydiaPRGuayanillaGuayanilla Barrio-Pueblo18.02385-66.78906200America/Puerto_Ricopopulated place
4566505Parada de Señal IrizarryParada de Senal IrizarryPRLajasSabana Yeguas Barrio18.03163-67.0249160America/Puerto_Ricopopulated place
7275016Aceitunas ComunidadPRMocaAceitunas Barrio18.44555-67.066931710America/Puerto_Ricopopulated place
4565717JuncalPRSan SebastiánJuncal Barrio18.31384-66.919073531155America/Puerto_Ricopopulated place
4565258Hacienda MarquésHacienda MarquesPRUtuadoMameyes Abajo Barrio18.28829-66.575175230America/Puerto_Ricopopulated place
4568247SantanaPRAreciboSantana Barrio18.44633-66.67017100America/Puerto_Ricopopulated place
4565170Hacienda Cintrona PrimeraPRJuana DíazCintrona Barrio18.0158-66.51906160America/Puerto_Ricopopulated place
4565331Hacienda Tres HermanasPRUtuadoGuaonico Barrio18.23246-66.737674410America/Puerto_Ricopopulated place
4563062Campo VerdePRBayamónHato Tejas Barrio18.40939-66.15767280America/Puerto_Ricopopulated place
4565227Hacienda La EsperanzaPRUtuadoConsejo Barrio18.19079-66.679065170America/Puerto_Ricopopulated place
4567745Río BlancoRio BlancoPRNaguaboRío Blanco Barrio18.21829-65.7885181406America/Puerto_Ricopopulated place
4565133Hacienda AlomarPRSanta IsabelFelicia 1 Barrio17.95802-66.3921170America/Puerto_Ricopopulated place
4565043Garcia PoncePRFajardoFajardo Barrio-Pueblo18.33551-65.65544180America/Puerto_Ricopopulated place
4565204Hacienda Flor de AlbaPRCialesCialitos Barrio18.28495-66.514892700America/Puerto_Ricopopulated place
4568156San LuisColonia San LuisPRNaguaboHúcares Barrio18.20218-65.71127200America/Puerto_Ricopopulated place
4566014Liro Del SurPRPoncePlaya Barrio17.98858-66.6346230America/Puerto_Ricopopulated place
7274995Sabana ComunidadPRVega BajaCeiba Barrio18.46431-66.3516730America/Puerto_Ricopopulated place
4562858BeltránBeltranPRFajardoSardinera Barrio18.34079-65.6332280America/Puerto_Ricopopulated place
4567596RecioPRPatillasGuardarraya Barrio17.97163-65.9582230America/Puerto_Ricopopulated place
4567662Residencial Francisco SeinPRLaresLares Barrio-Pueblo18.29856-66.877952950America/Puerto_Ricopopulated place
4564908EstansiaPRBayamónHato Tejas Barrio18.41161-66.1590670America/Puerto_Ricopopulated place
4565020FreirePRCidraCeiba Barrio18.18079-66.164064170America/Puerto_Ricopopulated place
4562789Barriada MarinPRGuayamaGuayama Barrio-Pueblo17.9733-66.10683430America/Puerto_Ricopopulated place
4565300Hacienda SaloméHacienda SalomePRMayagüezLeguísamo Barrio18.24273-67.083232310America/Puerto_Ricopopulated place
4567678Residencial La CeibaPRCeibaCeiba Barrio-Pueblo18.2669-65.64599170America/Puerto_Ricopopulated place
4565221Hacienda JuliaPRHormiguerosBenavente Barrio18.1219-67.0924260America/Puerto_Ricopopulated place
4565800La PicaPRSabana GrandeMachuchal Barrio18.06246-66.954621090America/Puerto_Ricopopulated place
4566097Luis Llorens TorresPRSan JuanSanturce Barrio18.448-66.0415520America/Puerto_Ricopopulated place
4568683VillalbaPRVillalbaVillalba Barrio-Pueblo18.12718-66.492121514555America/Puerto_Ricoseat of a first-order administrative division
4568594Villa CalizPRCaguasCañaboncito Barrio18.2219-66.06294930America/Puerto_Ricopopulated place
4563870Colinas de Villa RosaPRSabana GrandeSantana Barrio18.08774-66.967961370America/Puerto_Ricopopulated place
4568696Villas de SabanaPRToa BajaSabana Seca Barrio18.43717-66.1893330America/Puerto_Ricopopulated place
4562867Beverly HillsPRGuaynaboRío Barrio18.33301-66.095171130America/Puerto_Ricopopulated place
4565699Jose P H HernandezPRRío GrandeJiménez Barrio18.38523-65.8201640America/Puerto_Ricopopulated place
4562513Aguas BuenasPRAguas BuenasAguas Buenas Barrio-Pueblo18.2569-66.102942584576America/Puerto_Ricoseat of a first-order administrative division
4566978Puerts de TierraPRSan JuanSan Juan Antiguo Barrio18.46439-66.1026730America/Puerto_Ricopopulated place
4566493Palo SecoPRToa BajaPalo Seco Barrio18.46106-66.1446110America/Puerto_Ricopopulated place
4564017Costa AzulPRGuayamaGuayama Barrio-Pueblo17.97608-66.101320America/Puerto_Ricopopulated place
4566300Monte BrisasPRFajardoQuebrada Fajardo Barrio18.34634-65.65572180America/Puerto_Ricopopulated place
4565190Hacienda EsperanzaPRAdjuntasLimaní Barrio18.1744-66.79745560America/Puerto_Ricopopulated place
4565155Hacienda Buena VistaPRLas MaríasBuena Vista Barrio18.24968-66.953234190America/Puerto_Ricopopulated place
7274986Rafael Capó ComunidadRafael Capo ComunidadPRHatilloCampo Alegre Barrio18.39978-66.79081820America/Puerto_Ricopopulated place
4565272Hacienda NoezPRAdjuntasGuilarte Barrio18.15413-66.765177390America/Puerto_Ricopopulated place
4568127San JuanCaparra,Ciudad de Puerto Rico,Portorico,Prico,Puerto Rico,SJU,Saint Iuan,Saint John de Porto Rico,Sainte Jean de Porto-rico,San Chouan,San Chuanas,San Huan,San Ian de Porto Rico,San Ioanni,San Jean de Portorico,San Juan,San Juan Batista de Puerto Rico,San Juan Bautistade de Puerto Rico,San Juan de Puerto Rico,San Khuan,San Xoan,San Xoán,San Xuan,San-Juano,San-Khuan,Sanhuana,The City of Saint John,Ville de Porto-Rico,Ville de Sainte Jean de Porto Rico,can van,saenhwan,san hwn,san khwan,san-khuani,sana hu’ana,sana huraana,sanfuan,sanhuan,sheng hu an,Σαν Χουάν,Сан Хуан,Сан-Хуан,Սան Խուան,סן חואן,سان خوآن,سان خوان,सान हुआन,সান হুৱান,ਸਾਨ ਹੁਆਨ,சான் வான்,ซานฮวน,სან-ხუანი,サンフアン,圣胡安,산후안,샌환PRSan JuanSan Juan Antiguo Barrio18.46633-66.105727418140America/Puerto_Ricocapital of a political entity
4562986BuyonesPRPonceCapitanejo Barrio17.99163-66.5507330America/Puerto_Ricopopulated place
4566190MarquezPRAreciboArecibo Barrio-Pueblo18.46995-66.72768130America/Puerto_Ricopopulated place
4567566Quintas de San FranciscoPRMayagüezMayagüez Barrio-Pueblo18.19496-67.13185810America/Puerto_Ricopopulated place
4567959Rivera DonatoPRHumacaoMabú Barrio18.15524-65.83572280America/Puerto_Ricopopulated place
4568000Royal TownPRBayamónCerro Gordo Barrio18.36578-66.17183400America/Puerto_Ricopopulated place

Discovering Puerto Rico: A Geographical Overview

Puerto Rico, a Caribbean island territory of the United States, is a place where geography and culture converge in fascinating ways. Situated in the northeastern Caribbean Sea, Puerto Rico’s location has made it a significant crossroad in the Americas, influencing its natural landscapes and the development of its cities. With its mountains, coastal plains, and tropical climate, Puerto Rico offers a unique opportunity for geographic study. To truly understand the spatial dynamics of the island, it's essential to explore its cities, regions, and precise geographical coordinates. Having access to detailed data on these elements enhances our understanding of how geography shapes the lives of the people who call Puerto Rico home.

The Geography of Puerto Rico: A Diverse Landscape

Puerto Rico’s geography is defined by its variety of natural features. The island is characterized by rugged mountains, fertile valleys, and an extensive coastline. The central mountain range, the Cordillera Central, runs across Puerto Rico from west to east, creating dramatic landscapes and dividing the island into distinct regions. This mountain range includes the highest point on the island, Cerro de Punta, which reaches an elevation of 1,338 meters (4,390 feet).

To the north, Puerto Rico’s coastline is marked by beautiful beaches and cliffs, while the southern coast is lined with flatter plains and lagoons. The island’s tropical climate, with its year-round warmth and high humidity, has contributed to its rich biodiversity, from lush rainforests like El Yunque National Forest to dry forests in the island’s southwestern regions. The climate and terrain also influence settlement patterns and agriculture, with coastal areas traditionally serving as hubs for urban development, while the mountains have been home to agricultural communities.

Puerto Rico’s location within the Caribbean archipelago also makes it vulnerable to natural events such as hurricanes and earthquakes. These geographical features have had a significant impact on the island's urban planning and infrastructure.

Regions and Cities of Puerto Rico

Puerto Rico is divided into 78 municipalities, each serving as an administrative unit with its own local government. These municipalities reflect the island’s historical and cultural diversity, with each city having its own unique identity shaped by geography, history, and local traditions.

San Juan, the capital and largest city, is located on the northern coast and is the cultural, economic, and political heart of Puerto Rico. As the primary port city, San Juan has historically served as a major gateway for trade and commerce. The city’s colonial architecture, including the famous El Morro fortress, is a testament to its strategic importance in the Caribbean during the Spanish colonial period.

Other significant cities in Puerto Rico include Ponce, located on the southern coast, which serves as the island’s center for arts and culture; Bayamón, a major urban center near San Juan; and Mayagüez, which plays a central role in the island’s agricultural economy. These cities, along with smaller towns and rural communities, offer a comprehensive view of how geography shapes urbanization and cultural development in Puerto Rico.

Each municipality is situated in relation to Puerto Rico’s diverse landscape, with many cities located along the coast, while others are nestled in the fertile valleys or nestled within the mountains. Understanding the geographical relationships between these cities and their surrounding regions helps to shed light on the development patterns of Puerto Rico and the forces that have influenced the distribution of its population.

Latitude and Longitude: Mapping Puerto Rico’s Cities

Precise geographical data, such as the latitude and longitude of Puerto Rico’s cities, plays an essential role in understanding how urban areas are positioned in relation to key natural features. By obtaining this data, geographers can analyze the spatial relationships between cities and their environments, as well as how these cities have evolved over time.

For instance, San Juan’s geographic position along the northern coast and its proximity to the Caribbean Sea have made it an essential hub for maritime trade and tourism. Similarly, the positioning of Ponce on the southern coast has shaped its historical significance in terms of agriculture, commerce, and transportation.

Latitude and longitude data for cities like Mayagüez, Arecibo, and Fajardo provides valuable insights into the country’s urban layout. Such data can also help inform decision-making for sustainable urban planning, infrastructure development, and environmental management, as it gives us a clearer picture of how cities interact with the surrounding landscapes and resources.

Unlocking the Potential of Geospatial Data for Puerto Rico

Accessing accurate and comprehensive geographical data on Puerto Rico’s cities, regions, and their respective coordinates is essential for understanding the island’s geographical complexities. A detailed database containing this information provides researchers, urban planners, and policymakers with the tools they need to assess urban growth, resource distribution, and infrastructure needs across Puerto Rico.

For instance, by obtaining the precise coordinates of San Juan, Ponce, and other cities, experts can better analyze how geographical factors—such as proximity to the coast, rivers, and mountains—affect the economy, culture, and urban development of Puerto Rico. This data also enables the study of how geographic factors influence the movement of people, goods, and services across the island.

Geospatial data is also invaluable for understanding Puerto Rico’s vulnerability to natural disasters, such as hurricanes and flooding. Knowing the exact location of cities allows for more targeted disaster preparedness plans, ensuring that resources and infrastructure are properly allocated to areas that are most at risk. Additionally, it can help identify regions that require environmental conservation efforts or improved infrastructure to enhance resilience against climate change.

Conclusion

Puerto Rico’s diverse geography, from its mountainous interiors to its coastal plains, plays a central role in shaping the lives of its residents and the island’s cultural and economic development. The relationship between geography and urbanization is evident in the distribution of cities across the island, with their proximity to key natural features influencing their growth and significance. Accessing detailed geospatial data, including the latitude and longitude of Puerto Rico’s cities, is essential for understanding the complex interplay between urban areas, natural resources, and environmental challenges. With this information, Puerto Rico can continue to make informed decisions for sustainable growth, infrastructure development, and environmental protection in the years to come.

FaQ about Puerto Rico

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 5 Excel, 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 .zip archive containing the country files in Excel, 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.
Yes! We have recently updated our data packs and included the Excel (.xlsx) format, the latest Excel format. Take advantage now of 5 formats instead of 4 at no extra cost!

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname (used under CC BY 4.0), we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.