Philippines cities list with latitude and longitude in CSV format

Philippines
Philippines
CSV, SQL, XML, JSON

Last update : 11 December 2023.

Country
Philippines
Capitale
Manila
Number of cities
41852
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
1726506BasagBasagPHBicolProvince of Albay13.2678123.59610Asia/Manilapopulated place
1724244Bulo IlayaBolo Ilaya,Bulo Ilaya,Ilayang BoloPHCalabarzonProvince of Quezon13.8755121.956280Asia/Manilapopulated place
1721112CagangCagangPHCentral VisayasProvince of Negros Oriental9.9716123.18210Asia/Manilapopulated place
1685163SuyoSuyoPHIlocosProvince of La Union16.6120.466670Asia/Manilapopulated place
1707953LaketLaketPHSoccsksargenProvince of South Cotabato6.24856124.851440Asia/Manilapopulated place
1732146AgbalangaAgbalangaPHCentral VisayasProvince of Cebu9.92381123.462860Asia/Manilapopulated place
1690823SalogonSalogon,SalongonPHBicolProvince of Camarines Sur13.6586123.52252239Asia/Manilapopulated place
1687220SapismalSapismalPHDavaoDavao Occidental5.45556125.491390Asia/Manilapopulated place
7428484Hacienda San BaldomeroHacienda San BaldomeroPHWestern VisayasProvince of Negros Occidental10.59556123.05930Asia/Manilapopulated place
7090977Pasong Putik ProperPHMetro ManilaEastern Manila District14.738121.06910Asia/Manilapopulated place
7418630CapenayCapenayPHWestern VisayasProvince of Iloilo11.255122.91140Asia/Manilapopulated place
1721107CagaraCagaraPHBicolProvince of Masbate12.4598123.4830Asia/Manilapopulated place
1700194MatutumMatutumPHSoccsksargenProvince of South Cotabato6.2975125.127780Asia/Manilapopulated place
1696930OwacanOwacanPHCentral VisayasProvince of Negros Oriental10.0274123.15460Asia/Manilapopulated place
1690732SalvacionSalvacionPHMimaropaProvince of Palawan10.2103119.22970Asia/Manilapopulated place
1704525MaboloMaboloPHCentral VisayasBohol9.66667124.20Asia/Manilapopulated place
1710634InudalInudalPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.03333124.483330Asia/Manilapopulated place
1709122KatambuanKatambuanPHEastern VisayasProvince of Leyte10.9891124.45590Asia/Manilapopulated place
1706583LibtongLibtongPHBicolProvince of Sorsogon12.95123.90Asia/Manilapopulated place
1685205SorocSoroc,SurocPHEastern VisayasProvince of Eastern Samar10.98795125.796360Asia/Manilapopulated place
7091181PoblacionPHMetro ManilaEastern Manila District14.5832121.02860Asia/Manilapopulated place
1697105OngcaOngcaPHCentral VisayasProvince of Cebu10.0624123.55620Asia/Manilapopulated place
1696941OtonOtonPHMimaropaProvince of Palawan11.1214119.50160Asia/Manilapopulated place
1713960Ebcor TownEbcor Town,Edcor,Gallego EdcorPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.44056124.397222483Asia/Manilapopulated place
1721575CabirianCabirianPHMimaropaOccidental Mindoro12.42794121.108210Asia/Manilapopulated place
1725265BilicBilic,BillicPHCentral LuzonProvince of Nueva Ecija15.56917121.153610Asia/Manilapopulated place
1698295NangalisanNangalisanPHCagayan ValleyProvince of Nueva Vizcaya16.62708121.209040Asia/Manilapopulated place
1728378BalaticBalatic,BataticPHCentral VisayasProvince of Cebu9.8129123.54070Asia/Manilapopulated place
1687495SantuyoSantoyo,Santuy,SantuyoPHCentral LuzonProvince of Nueva Ecija15.38333121.083330Asia/Manilapopulated place
1679462YopuanYopuanPHCagayan ValleyProvince of Nueva Vizcaya16.46667120.933330Asia/Manilapopulated place
1690102San EugenioSan EugenioPHBicolProvince of Sorsogon12.6743124.12650Asia/Manilapopulated place
1688045Santa MariaSanta MariaPHCalabarzonProvince of Laguna14.0262121.31180Asia/Manilapopulated place
1958168LangusLangusPHAutonomous Region in Muslim MindanaoProvince of Sulu6.2875120.57520Asia/Manilapopulated place
1724175BonbonBonbom,BonbonPHCalabarzonProvince of Quezon15.04233121.918760Asia/Manilapopulated place
1698129NaraNaraPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.15124.216670Asia/Manilapopulated place
7567549Balong-AnitoBalong-AnitoPHCentral LuzonProvince of Bataan14.4424120.4760Asia/Manilapopulated place
1693976PiasPiasPHIlocosProvince of La Union16.63333120.350Asia/Manilapopulated place
1683195TangcarangCancaron,TangcarangPHCentral LuzonProvince of Tarlac15.54749120.378360Asia/Manilapopulated place
1701137MaraguitMaraguitPHWestern VisayasProvince of Iloilo10.8451122.44860Asia/Manilapopulated place
1701476MantalonanMantalonanPHMimaropaProvince of Romblon12.34444122.020280Asia/Manilapopulated place
8373788Bunsuran TerceroBunsuran,Bunsuran III,Bunsuran Tercero,Bunsuran TresPHCentral LuzonProvince of Bulacan14.861120.928560Asia/Manilapopulated place
1694978PantalPHIlocosProvince of Pangasinan16.05120.333330Asia/Manilapopulated place
1705129LumutanLumotan,LumutanPHCalabarzonProvince of Quezon13.9798121.97650Asia/Manilapopulated place
1699725MilavigaMilabiga,MilavigaPHBicolProvince of Catanduanes13.8719124.13650Asia/Manilapopulated place
1703496MainpisMainpisPHIlocosProvince of Pangasinan16.3428119.89220Asia/Manilapopulated place
1698366NamolinasNamolinasPHCordilleraProvince of Abra17.43333120.833330Asia/Manilapopulated place
1705396LubongPHCordilleraProvince of Abra17.58333120.650Asia/Manilapopulated place
1700008MaygnawayMaygnauay,MaygnawayPHBicolProvince of Catanduanes13.6864124.06580Asia/Manilapopulated place
7625812BalimbingBalimbingPHCalabarzonProvince of Rizal14.5237121.33840Asia/Manilapopulated place
1721807CabaritanCabaritan,CaratanPHCagayan ValleyProvince of Cagayan18.23333121.583330Asia/Manilapopulated place
1732472Abar 2Abar 2,Abar SegundoPHCentral LuzonProvince of Nueva Ecija15.7796120.96630Asia/Manilapopulated place
1681727TipoloTipoloPHWestern VisayasProvince of Iloilo10.95122.633330Asia/Manilapopulated place
8301358CanibunganCanibunganPHWestern VisayasProvince of Negros Occidental10.9457123.24780Asia/Manilapopulated place
1695022PanoypoyPanoypoyPHCentral VisayasProvince of Cebu10.41314123.929390Asia/Manilapopulated place
1716303DadataganDadataganPHCordilleraProvince of Abra17.2120.750Asia/Manilapopulated place
1703051MalapatanBayan ng Malapatan,Lungsod sa Malapatan,MalapatanPHSoccsksargenProvince of Sarangani5.96917125.2894419439Asia/Manilapopulated place
1704133MadrilenoMadrelino,MadrilenoPHCaragaProvince of Surigao del Sur9.30444126.181390Asia/Manilapopulated place
1706111LinomotLinomot,LinumutPHCagayan ValleyProvince of Isabela16.54424121.80560Asia/Manilapopulated place
8549645MalintaPHCagayan ValleyProvince of Cagayan18.09065121.617410Asia/Manilapopulated place
1730236ArarampangAr-Arumpang,ArarampangPHIlocosProvince of La Union16.7775120.41840Asia/Manilapopulated place
1731708AlakayganAlacaygan,AlakayganPHWestern VisayasProvince of Iloilo11122.80Asia/Manilapopulated place
1715415DatagDatagPHCentral VisayasProvince of Siquijor9.255123.59750Asia/Manilapopulated place
1687577Santo RosarioSanto RosarioPHCentral LuzonProvince of Pampanga15.06819120.733350Asia/Manilapopulated place
1707538LangobLangobPHCentral VisayasProvince of Cebu9.6881123.3430Asia/Manilapopulated place
7418782GimelonGimelonPHWestern VisayasProvince of Iloilo11.0972122.63660Asia/Manilapopulated place
1720308CalimbahanCalimbahan,CalimbajanPHWestern VisayasProvince of Aklan11.7378122.26260Asia/Manilapopulated place
1702970MalauliMalauliPHCentral LuzonProvince of Pampanga14.82965120.667840Asia/Manilapopulated place
1722509BurabodBurabod,BurabudPHEastern VisayasBiliran11.4782124.4540Asia/Manilapopulated place
1700111MauoMaua,Mauo,MawoPHEastern VisayasProvince of Northern Samar12.4451124.31360Asia/Manilapopulated place
1683447TamontakaTamontacaPHSoccsksargenCotabato City7.18056124.225565166Asia/Manilapopulated place
1699639MinangaMinangaPHCagayan ValleyProvince of Cagayan17.69501121.898150Asia/Manilapopulated place
1690076San FelipeSan FelipePHCagayan ValleyProvince of Isabela17.12384121.888740Asia/Manilapopulated place
1710006CabadianganCabadiangan,KabadianganPHEastern VisayasProvince of Southern Leyte9.9506125.28610Asia/Manilapopulated place
7411899CabatbuganCabatbuganPHWestern VisayasProvince of Iloilo10.6584122.29340Asia/Manilapopulated place
1724100Bonga BongaBonga BongaPHEastern VisayasProvince of Leyte11.11667124.883330Asia/Manilapopulated place
1697180OloOloPHCentral VisayasProvince of Siquijor9.21667123.516670Asia/Manilapopulated place
1702341MambaliliPHCaragaProvince of Agusan del Sur8.19556125.970Asia/Manilapopulated place
1697493Nouvilas OrientalInabilas,Nauvitas Oriental,Nouvilas Oriental,Nouviles Oriental,Nouvillas OrientalPHEastern VisayasProvince of Samar11.2775125.146670Asia/Manilapopulated place
1729078Bago-IngedBago-IngedPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.06667124.650Asia/Manilapopulated place
7428762SingalatSingalatPHCentral LuzonProvince of Nueva Ecija15.59033121.085820Asia/Manilapopulated place
1723137Bujong SanglayPHBicolProvince of Masbate12.36667123.80Asia/Manilapopulated place
1682979TapaconTapaconPHWestern VisayasProvince of Iloilo11.13333122.616670Asia/Manilapopulated place
1727196BaniBaniPHCentral LuzonProvince of Zambales15.5823119.93353066Asia/Manilapopulated place
7618862TucodTucodPHCagayan ValleyProvince of Quirino16.4041121.47290Asia/Manilapopulated place
1705625Looc LabuanLooc,Looc LabuanPHZamboanga PeninsulaProvince of Zamboanga Sibugay7.56058122.471290Asia/Manilapopulated place
1721014CagdaraoCagdaraoPHBicolProvince of Catanduanes13.9073124.35440Asia/Manilapopulated place
8656550Mataas Na LupaCheckpoint,Mataas Na LupaPHCalabarzonProvince of Cavite14.2273120.883110Asia/Manilapopulated place
8313844SinturisanPHCalabarzonProvince of Quezon13.89007121.311590Asia/Manilapopulated place
1723115BukalBukalPHCentral LuzonProvince of Bataan14.8120.516670Asia/Manilapopulated place
7415721MabunoMabunoPHCagayan ValleyProvince of Cagayan18.0517121.84550Asia/Manilapopulated place
1729435Bad-angBad-angPHCaragaProvince of Surigao del Norte9.63528125.919720Asia/Manilapopulated place
1691350SabangPHCalabarzonProvince of Batangas14.06333120.711112563Asia/Manilapopulated place
1720627CalangCalangPHWestern VisayasProvince of Iloilo11.0531122.60080Asia/Manilapopulated place
6569704BagangonBagangonPHNorthern MindanaoProvince of Misamis Oriental8.47139124.329720Asia/Manilapopulated place
1966760NabalasanNabalasanPHBicolProvince of Masbate12.1379123.59490Asia/Manilapopulated place
1707597LangasianLangasiaan,LangasianPHCaragaProvince of Agusan del Sur8.24806125.714720Asia/Manilapopulated place
1706626LiboLiboPHCentral VisayasProvince of Siquijor9.2544123.65210Asia/Manilapopulated place
1720210Cal-litangCal-litangPHIlocosProvince of Pangasinan15.94141120.653740Asia/Manilapopulated place
1709101KatibungKatibung,LuukPHAutonomous Region in Muslim MindanaoProvince of Sulu6.3422120.54820Asia/Manilapopulated place
1719701CamiaCamiaPHWestern VisayasProvince of Iloilo10.58333122.150Asia/Manilapopulated place

FaQ about Philippines

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.