Colombia cities list with latitude and longitude in CSV, XML, SQL, JSON format

Colombia
Colombia
CSV, SQL, XML, JSON

Last update : 13 December 2024.

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

Below is a list of 100 prominent cities in Colombia. Each row includes a city's latitude, longitude, region and other variables of interest. This is a subset of all 30947 places in Colombia that you'll find in our World Cities Database. You're free to use the data below for personal or commercial applications. The data below can be downloaded in .csv, .json, .xml and .sql formats. Notable Cities: The capital of Colombia is Bogotá.


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
3756995La CañaguataLa Canaguata,La CañaguataCOBoyacáCubará7.03203-72.063490America/Bogotapopulated place
3689861AngosturasCOValle del CaucaSan Pedro3.9754-76.180920America/Bogotapopulated place
3672107PitayóPitayo,PitayóCOCaucaSilvia2.70945-76.329310America/Bogotapopulated place
3677511Las FloresCOCesarValledupar10.75945-73.347370America/Bogotapopulated place
7546107Puerto MirandaCOCaquetá1.01268-76.209070America/Bogotapopulated place
8192481La PiñuelaLa Pinuela,La PiñuelaCOCaquetáFlorencia1.62395-75.66920America/Bogotapopulated place
3685973ContaderoCOBolívarSan Fernando9.07441-74.30060America/Bogotapopulated place
3732335San JoséCOSantanderOcamonte6.35041-73.145970America/Bogotapopulated place
3775597Las FloresCOMagdalenaGuamal9.36642-74.068810America/Bogotapopulated place
3770685MechengueCOCaucaEl Tambo2.57583-76.913890America/Bogotapopulated place
3775379VeraniaCOBoyacáSan Pablo de Borbur5.65417-74.095280America/Bogotapopulated place
3737679El HaticoCONorte de Santander DepartmentAbrego8.11722-73.152780America/Bogotapopulated place
3735629CañaveralCOCaucaMercaderes1.71141-77.18320America/Bogotapopulated place
3769616CataluñaCOCundinamarcaUbalá4.72018-73.297110America/Bogotapopulated place
3793410CascajalCOAntioquiaFrontino6.705-76.111110America/Bogotapopulated place
3731517PedragosaCOAntioquiaItuango7.25639-75.856670America/Bogotapopulated place
3778630El BrillanteCOValle del CaucaEl Cerrito3.67861-76.105280America/Bogotapopulated place
3672241PilcuánCONariñoBarbacoas1.4-78.083330America/Bogotapopulated place
8634987La AguadaCOCaucaSilvia2.65352-76.484640America/Bogotapopulated place
3685561CucharalCOBolívarPinillos8.98333-74.450America/Bogotapopulated place
3671607PuembíCONariñoBarbacoas1.65-78.10America/Bogotapopulated place
7539582La ReservaLa ReservaCOCaquetáAlbania1.33274-75.928930America/Bogotapopulated place
3736031San PabloCONariñoPolicarpa1.71083-77.451110America/Bogotapopulated place
3791447La MarielaCOTolimaRioblanco3.59889-75.828330America/Bogotapopulated place
8181995BuenavistaBuenavistaCOBogota D.C.Bogotá D.C.4.541-74.055060America/Bogotapopulated place
3678369La MonedaCOValle del CaucaSevilla4.2628-75.952750America/Bogotapopulated place
3736028La SierraCONariñoEl Rosario1.76395-77.379560America/Bogotapopulated place
8015990Las DeliciasCOBolívarMorales8.38766-73.780630America/Bogotapopulated place
3782443San JorgeCOTolimaSan Antonio3.96306-75.471670America/Bogotapopulated place
7524477CampoamorCampoamorCOSantanderLebríja7.38583-73.36440America/Bogotapopulated place
3676564LimoncitoCOCundinamarcaGuayabetal4.26667-73.833330America/Bogotapopulated place
3770593La VioletaCOCaucaPopayán2.54219-76.596890America/Bogotapopulated place
3782082Los AguadosCOCundinamarcaChoachí4.58696-73.918040America/Bogotapopulated place
3671358Puerto RangelCOMagdalenaGuamal9.19092-74.287270America/Bogotapopulated place
3673163PalmiraCOBoyacáPaya5.60015-72.339770America/Bogotapopulated place
3738277El AmparoCONorte de Santander DepartmentTibú8.78194-72.760280America/Bogotapopulated place
8638503La BrasiliaCOCesarValledupar9.9865-73.624490America/Bogotapopulated place
3734294La CabañaCOCaquetáAlbania1.14745-75.838880America/Bogotapopulated place
3667299TenerifeCOCórdobaMontería8.66694-76.109170America/Bogotapopulated place
3670040San BenitoCOAtlánticoUsiacurí10.7-74.950America/Bogotapopulated place
3777081PortachueloCOSantanderVélez5.95462-73.667340America/Bogotapopulated place
8016107El ParaísoEl Paraiso,El ParaísoCOCesarAguachica8.18218-73.673320America/Bogotapopulated place
3683073El SantuarioCOBoyacáSiachoque5.5-73.266670America/Bogotapopulated place
3676454Loma Simón BolívarCaserio Loma de Simon Bolivar,Loma Simon Bolivar,Loma Simón Bolívar,Loma de Simon,Loma de Simon Bolivar,Loma de Simón,Loma de Simón BolivarCOBolívarMompós9.22653-74.463610America/Bogotapopulated place
3775487YacopiCOBoyacáMuzo5.54806-74.0950America/Bogotapopulated place
3781361La MaríaCORisaraldaBelén de Umbría5.13928-75.872140America/Bogotapopulated place
8559505El ArcaCOCesarValledupar10.09002-73.449960America/Bogotapopulated place
3782085Los AndesCOCundinamarcaGuasca4.78718-73.760440America/Bogotapopulated place
3686995CebaderoCONariñoAlbán1.46667-77.083330America/Bogotapopulated place
3740661La MotilonaLa MotilonaCONorte de Santander DepartmentTibú9.0024-72.898360America/Bogotapopulated place
8261719El HoyoEl HoyoCOAntioquiaMedellín6.25468-75.701210America/Bogotapopulated place
3672807PasirroCOLa Guajira DepartmentUribia12.3-71.550America/Bogotapopulated place
8305977La AgustinaCOCaucaSantander de Quilichao2.89112-76.530710America/Bogotapopulated place
3734530El RecreoCOTolimaOrtega4.05222-75.30750America/Bogotapopulated place
3763559El SantuarioCOMetaMesetas3.42942-74.042240America/Bogotapopulated place
3779076NápolesCOValle del CaucaPalmira3.67028-76.033890America/Bogotapopulated place
3688014CajapíCONariñoSan Andres de Tumaco1.51056-78.679440America/Bogotapopulated place
10323386La ArgentinaLa ArgentinaCOMetaSan Martín3.54746-73.58060America/Bogotapopulated place
3757411La AlianzaCONorte de Santander DepartmentCúcuta8.22861-72.457220America/Bogotapopulated place
8310013PablónPablon,PablónCOSantanderBucaramanga7.17917-73.132210America/Bogotapopulated place
3675106MataperrosHacienda Mataperros,MataperrosCOBolívarEl Guamo10.03333-74.883330America/Bogotapopulated place
3830606NapolesCOBolívarTurbaco10.33446-75.352210America/Bogotapopulated place
3784913La MesetaCOAntioquiaAndes5.58208-75.880270America/Bogotapopulated place
3687067CatalanesCOBolívarSan Jacinto9.7905-75.043380America/Bogotapopulated place
8622805Crucero del CualíCrucero del Cuali,Crucero del CualíCOCaucaCaloto3.08035-76.41710America/Bogotapopulated place
3669851San FranciscoCONorte de Santander DepartmentSan Calixto8.45-73.116670America/Bogotapopulated place
3666010Villa ClaraCOCórdobaPueblo Nuevo8.53441-75.412040America/Bogotapopulated place
3779531La MacocaCOCórdobaCanalete8.76611-76.132780America/Bogotapopulated place
3680090JuradóJUO,Jurado,JuradóCOChocóJuradó7.10421-77.7622351America/Bogotapopulated place
3776714La LlanadaCOSantanderPuente Nacional5.741-73.654970America/Bogotapopulated place
3665685YopitoCODepartamento de AraucaTame6.46667-71.666670America/Bogotapopulated place
3689077Batallón CartagenaBatallon Cartagena,Batallón Cartagena,Cuarteles del Batallon Cartagena,Cuarteles del Batallón CartagenaCOCórdobaMontería8.73333-75.916670America/Bogotapopulated place
3674201Mundo NuevoCOSucreSantiago de Tolú9.61667-75.50America/Bogotapopulated place
3828192El CarmenEl CarmenCOTolimaAlpujarra3.47787-74.85550America/Bogotapopulated place
3769954PalmiraCOMetaVillavicencio4.02322-73.34220America/Bogotapopulated place
3763810BerraquiaCOGuainía DepartmentPuerto Colombia2.62973-67.475410America/Bogotapopulated place
3780504Alto San RafaelCOAntioquiaJardín5.55841-75.78250America/Bogotapopulated place
3680750HuainaCOLa Guajira DepartmentUribia12-71.30America/Bogotapopulated place
7523290Villa MartinVilla MartinCOTolimaMunicipio de San Sebastián de Mariquita5.21747-74.930670America/Bogotapopulated place
3779063MiravallesCOValle del CaucaVijes3.69725-76.468650America/Bogotapopulated place
3783600Las LaurasCOCórdobaSan Pelayo8.98731-75.761140America/Bogotapopulated place
7539778La FloridaLa FloridaCOCaquetáMorelia1.2616-75.597940America/Bogotapopulated place
3666097VersallesCOAntioquiaSanta Bárbara5.93333-75.566670America/Bogotapopulated place
3669598San JoséHacienda San Jose,Hacienda San José,San Jose,San JoséCOMagdalenaAlgarrobo10.06215-74.081670America/Bogotapopulated place
8139672El ArrieralEl ArrieralCOValle del CaucaBuenaventura3.89643-77.094630America/Bogotapopulated place
3669808San GilSan Chilis,San Gil,san khyl,san-khili,sheng xi er,سان خیل,სან-ხილი,聖希爾COSantanderSan Gil6.55952-73.1363746152America/Bogotapopulated place
3782482El RobleCOTolimaChaparral3.75778-75.49250America/Bogotapopulated place
3830860QuilembeCOBolívarArjona10.24613-75.361260America/Bogotapopulated place
10354680ManzanaresManzanaresCOHuilaNeiva2.92028-75.021890America/Bogotapopulated place
3675281MarianelaCOCasanare DepartmentManí4.56376-72.056040America/Bogotapopulated place
3739507San MarcosSan MarcosCOHuilaColombia3.529-74.716840America/Bogotapopulated place
10323544Los SaucesLos SaucesCOMetaEl Castillo3.58507-73.771320America/Bogotapopulated place
8622378MendiolaMendiolaCOCaucaCorinto3.18432-76.300820America/Bogotapopulated place
3829032Boca de ChapetónBoca Chapeton,Boca Chapetón,Boca de Chapeton,Boca de ChapetónCOCaucaGuapi2.51387-77.880420America/Bogotapopulated place
3674540MonserrateCOSucreSincelejo9.36667-75.433330America/Bogotapopulated place
3771013BuenavistaBuenavistaCOCaucaTotoró2.58391-76.53070America/Bogotapopulated place
3776684La GaviotaCOSantanderSucre5.89484-73.834010America/Bogotapopulated place
3778846La EsperanzaCOValle del CaucaGuadalajara de Buga3.81444-76.348330America/Bogotapopulated place
3776913Los SantrillosCOBoyacáSanta Sofía5.73972-73.586390America/Bogotapopulated place
3677739Las BalsasLa Balsa,Las BalsasCOCórdobaCiénaga de Oro8.91306-75.667780America/Bogotapopulated place

**Exploring Colombia: A Geographer's Perspective**

Nestled in the northwestern corner of South America, Colombia is a land of staggering geographical diversity, from its lush rainforests and rugged Andean peaks to its Caribbean coastlines and Amazonian basin. For a geographer, delving into the data of Colombia's cities, regions, and geographical coordinates offers a fascinating journey through the country's physical, cultural, and environmental landscapes. Let us embark on this exploration to uncover the geographical intricacies of Colombia.

Unveiling Urban Centers**

Colombia's urban centers are vibrant hubs of culture, commerce, and population diversity. From the bustling metropolis of Bogotá to the historic port city of Cartagena, each urban center reflects the country's rich tapestry of history and urbanization. For a geographer, obtaining data on Colombia's cities involves analyzing population demographics, urban sprawl patterns, and economic activities within the context of each region's geographical setting.

Mapping Regional Diversity**

Beyond its urban centers, Colombia boasts a mosaic of geographical regions, each with its own distinct landscapes and ecological features. From the snow-capped peaks of the Andes to the biodiverse Amazon rainforest, the country's geographical diversity is unparalleled. Colombia is divided into departments and regions, each characterized by unique topography, climate variations, and natural resources. The quest for data extends beyond numerical coordinates, encompassing the study of regional development, resource management, and environmental conservation efforts across Colombia's diverse landscape.

Navigating Latitude and Longitude**

In the pursuit of geographical understanding, latitude and longitude serve as essential navigational tools for mapping Colombia's vast terrain. From the northernmost city of Riohacha to the southern reaches of Leticia, each geographical coordinate offers insights into Colombia's spatial distribution, climate zones, and land use patterns. For a geographer, acquiring accurate latitude and longitude data is crucial for understanding spatial relationships, environmental gradients, and human-environment interactions across Colombia's diverse geography.

Exploring Human-Environment Interactions**

Colombia's geography is deeply intertwined with human activities and environmental dynamics. From the challenges of deforestation in the Amazon to the impacts of urbanization on fragile ecosystems, Colombia's geographical landscape reflects a complex interplay between human societies and the natural environment. As a geographer, the quest for data extends beyond physical geography, encompassing the study of land tenure systems, agricultural practices, and biodiversity conservation efforts in Colombia's dynamic landscape.

Conclusion: Embracing Colombia's Geography**

In the tapestry of Colombia's geography, the quest for data serves as a gateway to understanding the country's rich cultural heritage, environmental diversity, and socio-economic complexities. As we unravel the geographical nuances of this diverse nation, let us not only seek coordinates on a map but also embrace the spirit of exploration, discovery, and appreciation for Colombia's geography, which lies at the crossroads of South America's past and future.

download world databases cities Colombia

Download data files for Colombia's cities in CSV, SQL, XML and JSON formats

Geographical Insights into Colombia: Unlocking the Power of Geographic Data for Development

Colombia, located at the crossroads of South America, is a country rich in natural resources, diverse landscapes, and cultural heritage. From its lush Amazonian rainforests to the towering peaks of the Andes and the beautiful Caribbean coastline, Colombia’s geography is as varied as its population. Understanding the spatial dynamics of this diverse country is crucial for fostering sustainable development, managing natural resources, and addressing urbanization challenges. By obtaining detailed geographic data on Colombia’s cities, regions, and departments—including precise latitude and longitude coordinates—planners, geographers, and policymakers can make informed decisions about the country’s future.

Access to geographic data in formats such as CSV, SQL, JSON, and XML opens up a wide range of opportunities for spatial analysis, infrastructure development, and environmental management. This article explores the importance of geographic data for Colombia’s future and how it can be used to guide the country toward balanced growth and sustainable resource management.

Colombia’s Geography: A Diverse and Complex Landscape

Colombia’s geography is defined by its diverse landscapes, which include the Andes mountain range, tropical rainforests, vast plains, and coastlines along both the Caribbean Sea and the Pacific Ocean. The Andes runs through the country from south to north, dividing Colombia into three distinct mountain ranges. Between these mountains lies the fertile Andean highland region, which is home to the majority of Colombia’s population and economic activity.

To the east, Colombia is bordered by the vast Amazon Basin, while the plains of the Llanos stretch across the country’s eastern lowlands. The Pacific coast, in contrast, is characterized by tropical rainforests and important biodiversity, while the Caribbean coast is known for its beautiful beaches and vibrant tourism industry. These varied geographic zones impact the distribution of Colombia’s population, infrastructure, and economic resources.

Understanding how the country’s cities, regions, and departments are distributed across this diverse geography is crucial for addressing regional inequalities and fostering sustainable development. Geographic data helps planners assess how different areas of the country can best utilize their natural resources while preserving environmental integrity.

Mapping Colombia’s Cities and Regions

Colombia is divided into 33 departments, each with its own administrative divisions and cultural characteristics. These departments are further subdivided into municipalities, with each municipality containing multiple cities and towns. The capital, Bogotá, located in the Andean region, is Colombia’s largest city and serves as the economic, political, and cultural hub of the country. Other major cities include Medellín, Cali, and Barranquilla, each of which serves as a regional center for trade, industry, and services.

Bogotá, for example, has seen rapid urbanization and is facing challenges related to infrastructure, housing, and transportation. Medellín, historically an industrial city, has evolved into a center for innovation and technology. Cali, known for its role in Colombia’s sugar industry, is an important economic and cultural center in the southwestern region. Barranquilla, on the Caribbean coast, serves as a major port city and an entry point for international trade.

Beyond these urban centers, many smaller cities and rural towns spread throughout Colombia’s departments face challenges such as limited access to services, underdeveloped infrastructure, and vulnerability to environmental factors such as flooding or drought. Geographic data, including information on the population, infrastructure, and geographic location of cities, is essential for addressing these disparities and ensuring that development is distributed evenly across the country.

Latitude and Longitude: Pinpointing Locations for Better Planning

Latitude and longitude data is essential for accurate mapping and geographic analysis. By obtaining precise coordinates for cities like Bogotá, Medellín, and Cali, urban planners and geographers can gain valuable insights into the country’s infrastructure needs, resource distribution, and economic activities.

For instance, knowing the exact latitude and longitude of Bogotá allows planners to evaluate its proximity to key transportation routes, industrial zones, and natural resources. This information can help in optimizing urban growth strategies and ensuring that the city’s infrastructure meets the demands of its growing population.

Similarly, understanding the geographic coordinates of cities in Colombia’s rural regions—such as Popayán, Pasto, or Leticia—can help policymakers identify areas that are underserved by infrastructure and focus development efforts in these regions. Latitude and longitude data also supports environmental monitoring, as it can be used to track land use, deforestation, and climate-related changes in the country’s diverse ecosystems.

Flexible Data Formats: CSV, SQL, JSON, and XML for Efficient Analysis

For geographic data to be useful and accessible to a wide range of users, it must be available in flexible formats such as CSV, SQL, JSON, and XML. These formats allow stakeholders to efficiently analyze, integrate, and visualize the data across various platforms and applications.

CSV and SQL formats are particularly valuable for urban planners, government agencies, and researchers working with large datasets. These formats allow users to filter, sort, and query data based on multiple criteria, such as population density, infrastructure availability, and economic activity. By using these formats, planners can easily assess trends in regional development, resource allocation, and urbanization.

JSON and XML formats are more suitable for developers working with dynamic systems or GIS tools. These formats support real-time updates, interactive mapping, and the integration of live data into decision-making platforms. With these formats, developers can create interactive maps, data visualization tools, and real-time tracking systems that can aid in urban planning, disaster management, and environmental monitoring.

By offering Colombia’s geographic data in these formats, the country ensures that its geographic information can be utilized by a wide range of stakeholders, from local governments to international development agencies and environmental organizations.

Conclusion: Unlocking Colombia’s Geographic Data for a Sustainable Future

Colombia’s diverse geography—spanning from its Andean mountains to its tropical rainforests and coastal plains—presents both challenges and opportunities for the country’s growth and development. By obtaining detailed geographic data on Colombia’s cities, regions, and departments—including precise latitude and longitude coordinates—geographers, urban planners, and policymakers can gain deeper insights into the country’s spatial dynamics.

Latitude and longitude data, combined with flexible formats like CSV, SQL, JSON, and XML, provides the foundation for informed decision-making and effective resource management. This data is crucial for promoting balanced regional development, optimizing infrastructure, and ensuring the sustainable use of Colombia’s natural resources.

Unlocking the full potential of geographic data will enable Colombia to address its development challenges, enhance economic opportunities, and protect its unique ecosystems for future generations. By leveraging this data, Colombia can continue to progress toward a prosperous and sustainable future.

List of countries :

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