Colombia cities list with latitude and longitude in CSV format

Colombia
Colombia
CSV, SQL, XML, JSON

Last update : 11 December 2023.

Country
Colombia
Capitale
Bogotá
Number of cities
30947
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
3771370La CabañaCOCaucaEl Tambo2.50879-76.866660America/Bogotapopulated place
3770883Santa RosaCOCaucaPopayán2.5173-76.656580America/Bogotapopulated place
3683573El ParaísoEl Paraiso,El Paraíso,ParaisoCOCórdobaTierralta8.01176-76.178670America/Bogotapopulated place
8572805El ParqueEl ParqueCOCundinamarcaApulo4.47268-74.523890America/Bogotapopulated place
3830782Villa CruzCOBolívarArjona10.10625-75.361360America/Bogotapopulated place
3680780La HorquetaHorqueta,La HorquetaCOLa Guajira DepartmentAlbania11.1645-72.523540America/Bogotapopulated place
3733343Los CarruselesCOCesarChimichagua9.29472-73.791940America/Bogotapopulated place
3669000San RoqueCOAtlánticoBarranquilla10.95-74.833330America/Bogotapopulated place
3671546Puerto BarrigónBarrigon,Barrigón,Puerto Barrigan,Puerto Barrigon,Puerto Barrigán,Puerto BarrigónCOMetaCabuyaro4.16667-73.016670America/Bogotapopulated place
3689888AndreaAndrea,Hacienda AndreaCOAtlánticoPolonuevo10.76667-74.833330America/Bogotapopulated place
3738371MaracaiboCONorte de Santander DepartmentHacarí8.38646-73.133030America/Bogotapopulated place
3678770La HondaCOCasanare DepartmentYopal5.48699-72.395410America/Bogotapopulated place
3737201AltamiraCOTolimaPlanadas3.25583-75.616390America/Bogotapopulated place
3783461El RecreoCOCórdobaMontería8.77393-75.86560America/Bogotapopulated place
3669920San FelipeHato San Felipe,San FelipeCOCasanare DepartmentOrocué5.11667-71.916670America/Bogotapopulated place
3736241AmborcoCOHuilaPalermo3.02194-75.364440America/Bogotapopulated place
3734051El DoradoEl DoradoCOCaquetáAlbania1.17236-75.886270America/Bogotapopulated place
3678905La GloriaGloria,Hacienda Gloria,La GloriaCOMagdalenaSan Zenón9.3492-74.309770America/Bogotapopulated place
3687242CartagenaCOAmazonasEl Encanto-2.44494-72.28970America/Bogotapopulated place
3684645El CedroCaserio de El Cedro,Caserío de El Cedro,El CedroCOCundinamarcaNariño4.4251-74.792340America/Bogotapopulated place
10354548El UvalEl UvalCOHuilaBaraya3.12206-74.967990America/Bogotapopulated place
3774669El BálsamoCOBoyacáPuerto Boyacá5.81167-74.360280America/Bogotapopulated place
3670960RastrojosCOTolimaAmbalema4.88333-74.80America/Bogotapopulated place
3667349TausavitaCOCundinamarcaSutatausa5.26667-73.816670America/Bogotapopulated place
3690360Aguas ClarasCOSantanderSabana de Torres7.26583-73.561110America/Bogotapopulated place
3678736La HorquetaLa HorquetaCOCundinamarcaTocaima4.4491-74.588230America/Bogotapopulated place
3680996Hato el TotumoCOCasanare DepartmentTrinidad5.47593-71.603360America/Bogotapopulated place
3770373El DelirioCOAntioquiaPuerto Nare6.08528-74.736390America/Bogotapopulated place
3677364Las MaríasCOAntioquiaCaucasia7.98059-74.979970America/Bogotapopulated place
12421613MatacacaoMatacacaoCONorte de Santander Department8.75577-72.959010America/Bogotapopulated place
12385723La TrinidadLa TrinidadCONorte de Santander Department8.46663-73.248080America/Bogotapopulated place
3777276Tierra CastrosCOBoyacáMoniquirá5.89667-73.548060America/Bogotapopulated place
7544521Vereda San Luis de ChontayacoVda. San Luis de ChontayacoCOPutumayoMocoa1.14246-76.699890America/Bogotapopulated place
3780444La ToldaCOAntioquiaJericó5.74197-75.823670America/Bogotapopulated place
3674450MonteríaHacienda Monteria,Hacienda Montería,Monteria,MonteríaCOMagdalenaEl Piñon10.25662-74.637870America/Bogotapopulated place
8183351El VerdeEl VerdeCOSantanderFloridablanca7.05624-73.116730America/Bogotapopulated place
3670732Río NegroRio Negro,Río NegroCOTolimaDolores3.64361-74.809160America/Bogotapopulated place
3735664CasatejaCOCaucaPatía1.94393-77.178340America/Bogotapopulated place
3677066Las VacasCOSucre9.65386-75.095570America/Bogotapopulated place
3680027KashichomCOLa Guajira DepartmentUribia11.83783-72.166160America/Bogotapopulated place
8640391BellavístaCONariñoMagüi1.83273-78.185480America/Bogotapopulated place
3674008NatividadCOMagdalenaGuamal9.36504-74.08670America/Bogotapopulated place
3675309MarengoCOSantanderSan Vicente de Chucurí6.9-73.60America/Bogotapopulated place
3672473PericoCOCundinamarcaGuaduas5.35-74.70America/Bogotapopulated place
3683375El PorvenirEl Porvenir,Hacienda El PorvenirCOCesarLa Paz10.36667-73.216670America/Bogotapopulated place
3676495Llano GrandeCOBoyacáNuevo Colón5.36667-73.43710America/Bogotapopulated place
3668432Santa TeresaCONariñoArboleda1.47127-77.132620America/Bogotapopulated place
3683215RetiroCaserio Retiro,Caserío Retiro,RetiroCOBolívarMagangué9.16972-74.734630America/Bogotapopulated place
3666886ToribioHacienda La Pola,Hacienda Toribio,ToribioCOMagdalenaChibolo10.06667-74.466670America/Bogotapopulated place
8182161CarretonalCarretonalCOBogota D.C.4.65698-74.188730America/Bogotapopulated place
3782443San JorgeCOTolimaSan Antonio3.96306-75.471670America/Bogotapopulated place
3758116El Carmen de FonsecaCOLa Guajira DepartmentFonseca10.85595-72.83190America/Bogotapopulated place
3666536TuyaganoCOAntioquiaSabanalarga6.9-75.80America/Bogotapopulated place
3781087Las JuntasCOHuilaMunicipio de Íquira2.70592-75.62210America/Bogotapopulated place
3683703El OjitoCOSucreColoso9.49242-75.333880America/Bogotapopulated place
3778606Cueva AdentroCOValle del CaucaEl Cerrito3.65806-76.144440America/Bogotapopulated place
3669263San MiguelCOAntioquiaGiraldo6.65-75.883330America/Bogotapopulated place
3828558Los CedrosCONariñoGualmatán0.94855-77.584190America/Bogotapopulated place
3829415Buena VistaCOVichadaCumaribo4.26028-70.544170America/Bogotapopulated place
3686924Cerco de PiedraCOTolimaIbagué4.455-75.047220America/Bogotapopulated place
3769588BramadoraCOCasanare DepartmentManí4.60194-72.006940America/Bogotapopulated place
3782972La MariaCOValle del CaucaZarzal4.35167-76.13750America/Bogotapopulated place
3673527OroriaCOBolívarSimití8.11667-73.916670America/Bogotapopulated place
3675450ManicaCOSucreSincelejo9.39179-75.477050America/Bogotapopulated place
3774854Kilómetro CatorceCOBoyacáPuerto Boyacá5.878-74.44030America/Bogotapopulated place
3688966BellavistaCONariñoSan Andres de Tumaco1.66667-78.583330America/Bogotapopulated place
3782572La VictoriaCOTolimaChaparral3.71278-75.328060America/Bogotapopulated place
7522990CasablancaCasablancaCOAntioquiaNecoclí8.37276-76.755050America/Bogotapopulated place
8337209El JordánEl Jordan,El JordánCOAntioquiaEnvigado6.10181-75.569850America/Bogotapopulated place
3738331El CajónCONorte de Santander DepartmentEl Carmen8.62472-73.481390America/Bogotapopulated place
8581125San AntonioSan AntonioCOTolimaMelgar4.17088-74.597320America/Bogotapopulated place
3677975La ProvidenciaCOCesarAstrea9.55-73.916670America/Bogotapopulated place
3732089La EsperanzaCOSantanderSabana de Torres7.32278-73.414170America/Bogotapopulated place
3684323El DiamanteCOTolimaFlandes4.237-74.89280America/Bogotapopulated place
3735410El CerroEl CerroCOCaucaBolívar1.77027-77.016860America/Bogotapopulated place
3731757AltamirCOAntioquiaYarumal7.02111-75.59250America/Bogotapopulated place
12421378Santa HelenaSanta HelenaCONorte de Santander Department8.51497-72.923690America/Bogotapopulated place
7539578La CumbreLa CumbreCOCaquetáAlbania1.3021-75.953080America/Bogotapopulated place
3666544TutkaCOLa Guajira DepartmentUribia12.06667-71.883330America/Bogotapopulated place
3687747Campo LindoCampo LindoCODepartamento de AraucaArauca6.62092-70.496510America/Bogotapopulated place
3677566Las DeliciasFundo Las Delicias,Las DeliciasCODepartamento de AraucaPuerto Rondón6.45011-71.068630America/Bogotapopulated place
8626668Santa RitaCONariñoTúquerres1.05224-77.651540America/Bogotapopulated place
7523690El Otono LithiaEl Otono LithiaCOCundinamarcaGuaduas5.08839-74.584560America/Bogotapopulated place
3684863El BoralCOCasanare DepartmentTrinidad5.39208-70.702620America/Bogotapopulated place
3668574Santander de la CruzCOCórdobaMoñitos9.18925-76.174450America/Bogotapopulated place
3689799ApartaderosApartadero,ApartaderosCONorte de Santander DepartmentOcaña8.21667-73.333330America/Bogotapopulated place
3830727La RabiosaCOBolívarSan Juan Nepomuceno10.0565-75.116470America/Bogotapopulated place
3668736Santa InésCODepartamento de AraucaArauca6.95099-70.858510America/Bogotapopulated place
3671863PorvenirCOCaquetá1.31667-73.30America/Bogotapopulated place
3685921CorazónCOTolimaIbagué4.3-75.466670America/Bogotapopulated place
8559480Las Brisas MarinasCOCesarValledupar10.218-73.464160America/Bogotapopulated place
3775069Lama RedondaCOBoyacáOtanche5.79083-74.173330America/Bogotapopulated place
3679673La CajaCOMagdalenaFundación10.48333-73.650America/Bogotapopulated place
3774915La EsperanzaCOCundinamarcaYacopí5.74549-74.301860America/Bogotapopulated place
3673094PalominoOutaij-glicka,PalominoCOMagdalenaSanta Marta11.03567-73.64690America/Bogotapopulated place
3782890Capilla del SocorroCOValle del CaucaAndalucía4.18222-76.210America/Bogotapopulated place
3682139GardeniaGardenia,Hacienda GardeniaCOMagdalenaNueva Granada9.81253-74.429890America/Bogotapopulated place
3782644ChipalaCOTolimaOrtega3.82778-75.306940America/Bogotapopulated place
3828727San FranciscoCONariñoCumbal0.83234-77.840470America/Bogotapopulated place
3734734La PalomaCOTolimaRovira4.24139-75.369440America/Bogotapopulated place

FaQ about Colombia

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.