Indonesia cities list with latitude and longitude in CSV format

Indonesia
CSV, SQL, XML, JSON
Last update : 11 December 2023.
This is the best list of 243039 cities in the Indonesia 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 Indonesia file that you are going to retrieve. The data is displayed here in the form of a table:
Geoname_ID | City | Alternate_Name | Country_Code | Region | Sub_region | Latitude | Longitude | Elevation | Population | Timezone | Fcode_Name |
---|---|---|---|---|---|---|---|---|---|---|---|
7410405 | Presak Bat | Presak Bat | ID | West Nusa Tenggara | Kabupaten Lombok Timur | -8.7312 | 116.4731 | 0 | Asia/Makassar | populated place | |
7473177 | Masuka | Masuka | ID | South Sulawesi | Kabupaten Luwu | -3.2785 | 120.2349 | 0 | Asia/Makassar | populated place | |
6260900 | Sembungan | ID | Central Java | Kabupaten Magelang | -7.59722 | 110.18278 | 0 | Asia/Jakarta | populated place | ||
7792518 | Citiis | Citiis | ID | Banten | Kabupaten Serang | -6.2111 | 105.9639 | 0 | Asia/Jakarta | populated place | |
6256772 | Karangwuni | ID | Central Java | Kabupaten Magelang | -7.37694 | 110.31639 | 0 | Asia/Jakarta | populated place | ||
1965613 | Ngowok | Gowok,Ngowok | ID | East Java | Kabupaten Malang | -8.1206 | 112.5511 | 0 | Asia/Jakarta | populated place | |
7545492 | Bentaur | Bentaur | ID | West Nusa Tenggara | Kabupaten Lombok Barat | -8.5227 | 116.1178 | 0 | Asia/Makassar | populated place | |
6563734 | Ngabuh | Ngabuh | ID | Central Java | Kabupaten Temanggung | -7.19028 | 110.20556 | 0 | Asia/Jakarta | populated place | |
6770082 | Tambakringin | Tambakringin | ID | Central Java | Kabupaten Pemalang | -6.8924 | 109.3646 | 0 | Asia/Jakarta | populated place | |
1638704 | Lako | Lako,Lako 2 | ID | 1.11667 | 127.41667 | 0 | Asia/Jayapura | populated place | |||
8390309 | Mumubolan | Mumubolan | ID | East Nusa Tenggara | Kabupaten Kupang | -10.1412 | 123.3954 | 0 | Asia/Makassar | populated place | |
6387621 | Kalimenyawak | Kalimenyawak | ID | Central Java | Kabupaten Banyumas | -7.43028 | 108.99556 | 0 | Asia/Jakarta | populated place | |
8067429 | Cihieum | Cihieum | ID | West Java | Kabupaten Kuningan | -7.0087 | 108.5699 | 0 | Asia/Jakarta | populated place | |
2010292 | Sorogaten | ID | Yogyakarta | Kabupaten Kulon Progo | -7.94722 | 110.19444 | 0 | Asia/Jakarta | populated place | ||
1949452 | Sadamaya | Sadamaya | ID | West Java | Kabupaten Cianjur | -6.70472 | 107.12583 | 0 | Asia/Jakarta | populated place | |
6915641 | Pangipangi | Pangipangi | ID | Southeast Sulawesi | Kabupaten Kolaka Timur | -4.2016 | 121.913 | 0 | Asia/Makassar | populated place | |
8520108 | Komar | Komar,Komor | ID | South Papua | Kabupaten Asmat | -5.27109 | 138.2801 | 0 | Asia/Jayapura | populated place | |
6261630 | Tegalsari | ID | Central Java | Kabupaten Purworejo | -7.70194 | 110.01444 | 0 | Asia/Jakarta | populated place | ||
7888153 | Sawahnangka | Sawahnangka | ID | West Java | Kabupaten Cianjur | -7.1807 | 107.1137 | 0 | Asia/Jakarta | populated place | |
1986211 | Katulampa | ID | West Java | Kabupaten Bandung | -7.09972 | 107.73778 | 0 | Asia/Jakarta | populated place | ||
2006522 | Punden | ID | Central Java | Kabupaten Klaten | -7.66417 | 110.61528 | 0 | Asia/Jakarta | populated place | ||
1906374 | Pengampon | Pengampon | ID | East Java | Gresik Regency | -7.2976 | 112.6135 | 0 | Asia/Jakarta | populated place | |
6923636 | Lawang | Lawang | ID | North Sulawesi | Kabupaten Kepulauan Sangihe | 3.40703 | 125.56917 | 0 | Asia/Makassar | populated place | |
8744996 | Transmigrasi Sugihan Kiri | Transmigrasi Sugihan Kiri | ID | South Sumatra | Kabupaten Banyu Asin | -2.55125 | 105.16305 | 0 | Asia/Jakarta | populated place | |
1935878 | Tegalsari | ID | Central Java | Kabupaten Sukoharjo | -7.6575 | 110.87694 | 0 | Asia/Jakarta | populated place | ||
6721071 | Sinta Damai | Sinta Damai | ID | North Sumatra | Kabupaten Deli Serdang | 3.62979 | 98.9134 | 0 | Asia/Jakarta | populated place | |
7845346 | Sengkol Dua | Sengkol Dua | ID | West Java | Kabupaten Sukabumi | -7.3184 | 106.5743 | 0 | Asia/Jakarta | populated place | |
7415296 | Lembahbahagia | Lembahbahagia | ID | South Sulawesi | Kabupaten Luwu Timur | -2.5538 | 120.7841 | 0 | Asia/Makassar | populated place | |
8017983 | Sukarasa | Soekakarsa,Sukarasa | ID | West Java | Kabupaten Tasikmalaya | -7.3722 | 108.0821 | 0 | Asia/Jakarta | populated place | |
8362101 | Umbulan Kayubangar | Umbulan Kayubangar,Umbulankayubangar | ID | Lampung | Kabupaten Lampung Utara | -4.72593 | 104.74218 | 0 | Asia/Jakarta | populated place | |
8637293 | Situmtuman Satu | Situmtuman 1,Situmtuman Satu | ID | North Sumatra | Kabupaten Humbang Hasundutan | 2.3066 | 98.9516 | 0 | Asia/Jakarta | populated place | |
6703600 | Pondok Karang Rejo | Pondok Karang Rejo | ID | North Sumatra | Kabupaten Asahan | 3.0111 | 99.6433 | 0 | Asia/Jakarta | populated place | |
12178258 | Beyan Lor | ID | East Java | Kabupaten Jombang | -7.56662 | 112.21559 | 0 | Asia/Jakarta | populated place | ||
1640852 | Kayi | Kaji,Kayi | ID | Southwest Papua | Kabupaten Tambrauw | -0.93333 | 132.63333 | 0 | Asia/Jayapura | populated place | |
2006696 | Tegalmulyo | ID | Central Java | Kabupaten Klaten | -7.68333 | 110.6075 | 0 | Asia/Jakarta | populated place | ||
6255579 | Nayu | ID | Central Java | Kabupaten Wonogiri | -7.94111 | 110.94556 | 0 | Asia/Jakarta | populated place | ||
6601248 | Paris | Paris | ID | West Java | Kabupaten Sukabumi | -6.87583 | 106.77 | 0 | Asia/Jakarta | populated place | |
7061155 | Kaerenge | Kaerenge | ID | South Sulawesi | Kabupaten Barru | -4.4326 | 119.7115 | 0 | Asia/Makassar | populated place | |
6714486 | Perlak | Perlak | ID | Aceh | Kabupaten Gayo Lues | 4.1584 | 96.9769 | 0 | Asia/Jakarta | populated place | |
7780959 | Patenggeng | Patenggeng | ID | Banten | Kabupaten Pandeglang | -6.3605 | 105.9032 | 0 | Asia/Jakarta | populated place | |
7743070 | Lumban Dolok | Lumban Dolok | ID | North Sumatra | Kabupaten Samosir | 2.7404 | 98.7728 | 0 | Asia/Jakarta | populated place | |
8420669 | Lawangtabak | Lawangtabak | ID | East Nusa Tenggara | Kabupaten Alor | -8.1842 | 124.7563 | 0 | Asia/Makassar | populated place | |
6831003 | Ngemplak | Ngemplak | ID | East Java | Kabupaten Kediri | -7.6599 | 112.2024 | 0 | Asia/Jakarta | populated place | |
6703098 | Salangdagu | Salangdagu | ID | North Sumatra | Kabupaten Langkat | 3.6102 | 98.0899 | 0 | Asia/Jakarta | populated place | |
1635883 | Mataram | Mataram | ID | West Java | Kabupaten Sukabumi | -7.1684 | 106.6665 | 0 | Asia/Jakarta | populated place | |
6378248 | Karanganyar | Karanganyar | ID | Central Java | Kabupaten Wonosobo | -7.5675 | 109.81111 | 0 | Asia/Jakarta | populated place | |
6724576 | Duit Dua | Duit 2,Duit Dua | ID | Riau | Kabupaten Kampar | 0.3533 | 101.2325 | 0 | Asia/Jakarta | populated place | |
2005233 | Gonjeu | ID | Yogyakarta | Kabupaten Bantul | -7.82694 | 110.335 | 0 | Asia/Jakarta | populated place | ||
6842133 | Bulu Satu | Bulu Satu | ID | East Java | Kabupaten Madiun | -7.4847 | 111.6774 | 0 | Asia/Jakarta | populated place | |
6408039 | Jandang | Jandang | ID | Central Java | Kabupaten Wonogiri | -7.75139 | 111.26889 | 0 | Asia/Jakarta | populated place | |
7743777 | Ambarisan | Ambarisan | ID | North Sumatra | Kabupaten Simalungun | 2.8758 | 98.9033 | 0 | Asia/Jakarta | populated place | |
2000093 | Kuncen | ID | Yogyakarta | Kabupaten Sleman | -7.81556 | 110.44972 | 0 | Asia/Jakarta | populated place | ||
6579268 | Warujajar | Warujajar | ID | West Java | Kabupaten Cianjur | -6.81917 | 107.14556 | 0 | Asia/Jakarta | populated place | |
6260529 | Gebang | ID | Central Java | Kabupaten Purworejo | -7.57417 | 110.03278 | 0 | Asia/Jakarta | populated place | ||
6597260 | Nanggeleng | Nanggeleng | ID | West Java | Kabupaten Bogor | -6.73222 | 106.86028 | 0 | Asia/Jakarta | populated place | |
6821926 | Bupong Lao | Bupong Lao | ID | East Java | Kabupaten Situbondo | -7.764 | 113.738 | 0 | Asia/Jakarta | populated place | |
6588384 | Ciraden | Ciraden | ID | West Java | Kabupaten Sukabumi | -6.98889 | 107.01278 | 0 | Asia/Jakarta | populated place | |
1962480 | Ceuri | Ceuri,Tjeuri | ID | West Java | Kabupaten Bandung | -7.00722 | 107.54528 | 0 | Asia/Jakarta | populated place | |
8058382 | Jelak | Jelak | ID | Central Java | Kabupaten Pati | -6.7188 | 111.0462 | 0 | Asia/Jakarta | populated place | |
8314824 | Kenteng | Kenteng | ID | East Java | Kabupaten Trenggalek | -8.148 | 111.5494 | 0 | Asia/Jakarta | populated place | |
7569372 | Fatima | Fatima | ID | East Nusa Tenggara | Kabupaten Ngada | -8.8056 | 120.9707 | 0 | Asia/Makassar | populated place | |
7781556 | Combong | Combong | ID | Banten | Kabupaten Serang | -6.2153 | 106.1218 | 0 | Asia/Jakarta | populated place | |
8078019 | Kuta | Kuta | ID | Central Java | Kabupaten Brebes | -7.0639 | 108.8652 | 0 | Asia/Jakarta | populated place | |
6597901 | Gang Sukarna | Gang Sukarna | ID | West Java | Kota Bogor | -6.58917 | 106.78917 | 0 | Asia/Jakarta | populated place | |
7377570 | Binakarya | Binakarya | ID | West Nusa Tenggara | Kabupaten Sumbawa | -8.6018 | 117.4531 | 0 | Asia/Makassar | populated place | |
8410058 | Noefefan | Noefefan | ID | East Nusa Tenggara | Kabupaten Timor Tengah Selatan | -10.1134 | 124.4823 | 0 | Asia/Makassar | populated place | |
7380140 | Wolowuja | Wolowuja | ID | East Nusa Tenggara | Kabupaten Ende | -8.7901 | 121.8876 | 0 | Asia/Makassar | populated place | |
8185392 | Kebon | Kebon | ID | East Java | Kabupaten Jember | -8.2914 | 113.5117 | 0 | Asia/Jakarta | populated place | |
6758947 | Ciloa | Ciloa | ID | Banten | Kabupaten Serang | -6.0831 | 106.0544 | 0 | Asia/Jakarta | populated place | |
6593087 | Dusun Empat | Dusun Empat | ID | West Java | Kabupaten Purwakarta | -6.61389 | 107.48361 | 0 | Asia/Jakarta | populated place | |
6718504 | Meunasah Aluemudim | Meunasah Aluemudim | ID | Aceh | Kabupaten Aceh Utara | 5.0699 | 97.3012 | 0 | Asia/Jakarta | populated place | |
1629356 | Sabandar | Sabandar | ID | West Java | Kabupaten Majalengka | -6.64833 | 108.05694 | 0 | Asia/Jakarta | populated place | |
1965977 | Waregu | ID | West Java | Kabupaten Bandung | -7.06528 | 107.61833 | 0 | Asia/Jakarta | populated place | ||
8527172 | Talang Tanjungtaring | Talang Tanjungtaring | ID | South Sumatra | Kota Pagar Alam | -4.12039 | 103.20138 | 0 | Asia/Jakarta | populated place | |
8418329 | Oepuah | Oepuah | ID | East Nusa Tenggara | Kabupaten Timor Tengah Selatan | -9.7881 | 124.6894 | 0 | Asia/Makassar | populated place | |
6830048 | Gemantar | Gemantar | ID | East Java | Kabupaten Magetan | -7.5806 | 111.4548 | 0 | Asia/Jakarta | populated place | |
6378283 | Pandagan | Pandagan | ID | Central Java | Kabupaten Wonosobo | -7.56222 | 109.77139 | 0 | Asia/Jakarta | populated place | |
6588882 | Cikaret | Cikaret | ID | West Java | Kabupaten Bandung Barat | -6.97722 | 107.21583 | 0 | Asia/Jakarta | populated place | |
1639271 | Kuangsan | Koeangsan,Koengsan,Kuangsan | ID | Central Java | Kabupaten Sukoharjo | -7.68333 | 110.95 | 0 | Asia/Jakarta | populated place | |
7558821 | Longgato | Longgato | ID | Gorontalo | Kabupaten Gorontalo | 0.6061 | 123.0359 | 0 | Asia/Makassar | populated place | |
7057565 | Balibunga | Balibunga | ID | West Nusa Tenggara | Kabupaten Dompu | -8.5404 | 118.4354 | 0 | Asia/Makassar | populated place | |
6763246 | Blambangan | Blambangan | ID | Central Java | Kota Pekalongan | -6.92499 | 109.6789 | 0 | Asia/Jakarta | populated place | |
8579275 | Tabuan | Tabuan | ID | Riau | Kabupaten Indragiri Hilir | 0.01425 | 103.48406 | 0 | Asia/Jakarta | populated place | |
2002661 | Dagaran | ID | Yogyakarta | Kabupaten Bantul | -7.91111 | 110.31556 | 0 | Asia/Jakarta | populated place | ||
6407117 | Talang | Talang | ID | Central Java | Kabupaten Wonogiri | -7.80611 | 111.23 | 0 | Asia/Jakarta | populated place | |
6779047 | Lonangka | Lonangka | ID | East Java | Kabupaten Sampang | -7.0556 | 113.2256 | 0 | Asia/Jakarta | populated place | |
7083499 | Sumberjeding | Sumberjeding | ID | East Java | Kabupaten Jember | -8.2035 | 113.7979 | 0 | Asia/Jakarta | populated place | |
6739475 | Legokkole | Legokkole | ID | West Java | Kabupaten Bandung | -7.0604 | 107.4388 | 0 | Asia/Jakarta | populated place | |
7666474 | Tempelsari | Tempelsari | ID | Lampung | Kabupaten Pesawaran | -5.46357 | 105.02121 | 0 | Asia/Jakarta | populated place | |
6386041 | Gunungtumpeng | Gunungtumpeng | ID | Central Java | Kabupaten Kebumen | -7.62528 | 109.61278 | 0 | Asia/Jakarta | populated place | |
6828817 | Buaran | Buaran | ID | East Java | Kabupaten Pasuruan | -7.6759 | 112.9187 | 0 | Asia/Jakarta | populated place | |
7567654 | Mera | Mera | ID | East Nusa Tenggara | Kabupaten Manggarai Timur | -8.7489 | 120.6856 | 0 | Asia/Makassar | populated place | |
1974465 | Polang | Polang | ID | South Sulawesi | Kabupaten Barru | -4.4674 | 119.6263 | 0 | Asia/Makassar | populated place | |
7571845 | Congahing | Congahing | ID | South Sulawesi | Kabupaten Bone | -4.9969 | 120.0944 | 0 | Asia/Makassar | populated place | |
1621791 | Batumea | Batoemea,Batumea,Watoemea,Watoenea,Watunea | ID | Southeast Sulawesi | Kabupaten Konawe Kepulauan | -4.0759 | 122.9429 | 0 | Asia/Makassar | populated place | |
1638886 | Labuandiri | Laboeandere,Laboeandiri,Labuandiri | ID | Southeast Sulawesi | Kabupaten Buton | -5.37118 | 123.13721 | 0 | Asia/Makassar | populated place | |
12197546 | Gondang | ID | Central Java | Kabupaten Pemalang | -6.88651 | 109.41962 | 0 | Asia/Jakarta | populated place | ||
6579489 | Pasirwaru | Pasirwaru | ID | West Java | Kabupaten Cianjur | -6.84639 | 107.14472 | 0 | Asia/Jakarta | populated place | |
8057396 | Karangsari | Karangsari | ID | West Java | Kabupaten Ciamis | -7.4932 | 108.5872 | 0 | Asia/Jakarta | populated place | |
6590931 | Warungnangka | Warungnangka | ID | West Java | Kabupaten Bandung Barat | -6.74306 | 107.34278 | 0 | Asia/Jakarta | populated place |
FaQ about Indonesia
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