Puerto Rico cities list with latitude and longitude in CSV format

Puerto_Rico
Puerto Rico
CSV, SQL, XML, JSON

Last update : 24 April 2024.

Country
Puerto Rico
Capitale
San Juan
Number of cities
2471
Download

This is the best list of 2471 cities in the Puerto Rico 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 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

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 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.