Singapore cities list with latitude and longitude in CSV format
Singapore
CSV, SQL, XML, JSON
Last update : 18 September 2024.
This is the best list of 135 cities in the Singapore 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 Singapore 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
1880575 | Kampong Pasir Merah | SG | 1.42917 | 104.04694 | 0 | Asia/Singapore | populated place | ||||
1882155 | Yishun New Town | Nee Soon,Yishun,Yishun New Town,yi shun,义顺,義順 | SG | 1.43333 | 103.83111 | 0 | Asia/Singapore | populated place | |||
1880242 | Somapah Serangoon | SG | 1.36667 | 103.88333 | 0 | Asia/Singapore | populated place | ||||
1880553 | Kampong Seraya | SG | 1.28333 | 103.73333 | 0 | Asia/Singapore | populated place | ||||
1884737 | Choa Chu Kang New Town | CCK,Cai Cuo Gang,Chhoa Chhu Kang,Chhòa Chhù Káng,Choa Chu Kang,Choa Chu Kang New Town,Chua Chu Kang,Cài Cuò Gǎng,cai cuo gang,cuva cu kan,சுவா சூ காங்,蔡厝港 | SG | 1.3825 | 103.74972 | 0 | Asia/Singapore | populated place | |||
1880437 | Nee Soon Estate | Nee Soon,Nee Soon Estate,Nee Soon Village | SG | 1.40278 | 103.81778 | 0 | Asia/Singapore | populated place | |||
7289760 | Sengkang New Town | Sengkang,Sengkang New Town,Sheng Gang,Shèng Gǎng,cenkan,sheng gang,செங்காங்,盛港 | SG | 1.39167 | 103.89444 | 0 | Asia/Singapore | populated place | |||
1880593 | Kampong Kitin | SG | 1.435 | 103.85917 | 0 | Asia/Singapore | populated place | ||||
1880226 | Sungai Simpang | Sungai Simpang,Sungei Simpang Village,Xinbang,Xīnbāng,xin bang,新邦 | SG | 1.43806 | 103.82667 | 0 | Asia/Singapore | populated place | |||
1880828 | Aik Hong and Aik Chiang Estate | SG | 1.39083 | 103.72861 | 0 | Asia/Singapore | populated place | ||||
1880539 | Kampong Teban | SG | 1.37861 | 103.90778 | 0 | Asia/Singapore | populated place | ||||
1880602 | Kampong Che Jevah | SG | 1.41444 | 103.98972 | 0 | Asia/Singapore | populated place | ||||
1880582 | Kampong Melayu | Kampong Malayu,Kampong Melayu | SG | 1.40861 | 103.97944 | 0 | Asia/Singapore | populated place | |||
1880183 | Thong Hoe Village | Thong Hoe,Thong Hoe Village | SG | 1.41806 | 103.70194 | 0 | Asia/Singapore | populated place | |||
1880577 | Kampong Pahang | SG | 1.40917 | 104.03278 | 0 | Asia/Singapore | populated place | ||||
1880540 | Kampong Tanjong Penjuru | Kampong Tanjong Penjuru,Kampong Tanjong Penuru | SG | 1.3 | 103.75 | 0 | Asia/Singapore | populated place | |||
1880621 | Kampong Ayer Limau | SG | 1.28333 | 103.71667 | 0 | Asia/Singapore | populated place | ||||
1880604 | Kampong Changi | SG | 1.38333 | 104 | 0 | Asia/Singapore | populated place | ||||
1880556 | Kampong Sanyonkong Parit | Kampong Sanyongkong,Kampong Sanyonkong Parit | SG | 1.40611 | 104.06583 | 0 | Asia/Singapore | populated place | |||
1880534 | Kampong Tongkang Pechah | SG | 1.39 | 103.87639 | 0 | Asia/Singapore | populated place | ||||
1880572 | Kampong Pengkalan Pakau | SG | 1.40944 | 104.0725 | 0 | Asia/Singapore | populated place | ||||
1880622 | Kampong Ayer Gemuruh | SG | 1.35 | 103.98333 | 0 | Asia/Singapore | populated place | ||||
1880135 | Yio Chu Kang | Yio Chu Kang,Yio Chu Kang Village | SG | 1.39111 | 103.85139 | 0 | Asia/Singapore | populated place | |||
1880611 | Kampong Beremban | SG | 1.38139 | 103.91583 | 0 | Asia/Singapore | populated place | ||||
1880159 | Ulu Bedok | Ulu Bedok,Ulu Bedok Village | SG | 1.33333 | 103.93333 | 0 | Asia/Singapore | populated place | |||
1880329 | Saga | Saga,Saga Village | SG | 1.26667 | 103.83333 | 0 | Asia/Singapore | populated place | |||
1880554 | Kampong Serangoon Kechil | SG | 1.39 | 103.90722 | 0 | Asia/Singapore | populated place | ||||
1880609 | Kampong Bugis | SG | 1.21667 | 103.76667 | 0 | Asia/Singapore | populated place | ||||
1880348 | Punggol | Bang’e,Bǎng’é,Ponggol,Punggol,Punggol Village,bang e,ponkol,pwngl,پونگل,பொங்கோல்,榜鹅 | SG | 1.41444 | 103.90694 | 0 | Asia/Singapore | populated place | |||
1880614 | Kampong Batu Koyok | SG | 1.39694 | 104.04778 | 0 | Asia/Singapore | populated place | ||||
1880574 | Kampong Pasir Ris | Baisha,Baxili,Báishā,Bāxīlì,Kampong Pasir Ris,Pacir ris,Pasir Ris,Pācir ris,ba xi li,bai sha,pacir ris,பாசிர் ரிஸ்,巴西立,白沙 | SG | 1.37833 | 103.93194 | 0 | Asia/Singapore | populated place | |||
1884365 | Ang Mo Kio New Town | Ang Mo Kio New Town | SG | 1.38028 | 103.83972 | 0 | Asia/Singapore | populated place | |||
1880528 | Kampong Wak Bechik | SG | 1.28333 | 103.71667 | 0 | Asia/Singapore | populated place | ||||
1880581 | Kampong Noordin | SG | 1.41778 | 103.965 | 0 | Asia/Singapore | populated place | ||||
1880525 | Kampong Wak Sekak | SG | 1.26667 | 103.7 | 0 | Asia/Singapore | populated place | ||||
7289766 | HarbourFront | SG | 1.2652 | 103.8201 | 0 | Asia/Singapore | populated place | ||||
1884382 | Bedok New Town | Bedok,Bedok New Town,Bedok Village,Pitok,Piṭōk,pitok,wu luo,பிடோக்,勿洛 | SG | 1.32639 | 103.94167 | 0 | Asia/Singapore | populated place | |||
1880587 | Kampong Lew Lian | SG | 1.35 | 103.86667 | 0 | Asia/Singapore | populated place | ||||
1880144 | West Coast Village | SG | 1.31667 | 103.75 | 0 | Asia/Singapore | populated place | ||||
1880567 | Kampong Pinang | Kampong Pinang,Kampong Sungi Pinang | SG | 1.38111 | 103.89417 | 0 | Asia/Singapore | populated place | |||
6690793 | Blk 822 Jurong West Street 81 | SG | 1.347 | 103.69357 | 0 | Asia/Singapore | populated place | ||||
1882402 | Kangkar | SG | 1.37611 | 103.90167 | 0 | Asia/Singapore | populated place | ||||
1882118 | Tanglin Halt | SG | 1.30139 | 103.7975 | 0 | Asia/Singapore | populated place | ||||
1880592 | Kampong Kopit | SG | 1.26667 | 103.83333 | 0 | Asia/Singapore | populated place | ||||
1880822 | Ama Keng | Ama Keng,Ama Keng Village | SG | 1.40444 | 103.70667 | 0 | Asia/Singapore | populated place | |||
7281987 | Novena | novina,nuo wei na,நொவீணா,诺维娜 | SG | 1.31697 | 103.8438 | 0 | Asia/Singapore | populated place | |||
1880584 | Kampong Mamam | SG | 1.41722 | 103.97611 | 0 | Asia/Singapore | populated place | ||||
1880761 | Boon Lay | Boon Lay,Bun Le,Bûn Lé,pun le,wen li/wen li,பூன் லே,文礼/文禮 | SG | 1.33333 | 103.7 | 0 | Asia/Singapore | populated place | |||
1880568 | Kampong Pesek | SG | 1.28333 | 103.68333 | 0 | Asia/Singapore | populated place | ||||
1882253 | Lim Chu Kang | Lim Chu Kang,Lim-chhu-kang,Lincuogang,Líncuògǎng,Lîm-chhù-káng,lim cu kan,lin cuo gang,லிம் சூ காங்,林厝港 | SG | 1.43667 | 103.70944 | 0 | Asia/Singapore | populated place | |||
1880579 | Kampong Pachitan | SG | 1.31667 | 103.91667 | 0 | Asia/Singapore | populated place | ||||
1880573 | Kampong Pengkalan Kundor | SG | 1.41 | 103.84444 | 0 | Asia/Singapore | populated place | ||||
1880137 | Yew Tee | Yew Tee,Yew Tee Village,Yow Toe | SG | 1.39444 | 103.75389 | 0 | Asia/Singapore | populated place | |||
1880755 | Bright Hill Crescent | SG | 1.35 | 103.83333 | 0 | Asia/Singapore | populated place | ||||
1880541 | Kampong Tanjong Irau | Kampong Tanjong Irau,Kampong Wah Tuang | SG | 1.45667 | 103.84667 | 0 | Asia/Singapore | populated place | |||
1880723 | Changi Village | Changi,Changi Village,Kampung Changi,zhang yi cun,樟宜村 | SG | 1.39037 | 103.98674 | 0 | Asia/Singapore | populated place | |||
7289746 | Newton | SG | 1.30902 | 103.83757 | 0 | Asia/Singapore | populated place | ||||
1884367 | Bukit Panjang New Town | Bt Panjang,Bukit Panjang,Bukit Panjang New Town,Wujibanrang,Wǔjíbānràng,pukkittu pancan,wu ji ban rang,புக்கித்து பஞ்சாங்,武吉班让 | SG | 1.37972 | 103.76472 | 0 | Asia/Singapore | populated place | |||
1880605 | Kampong Chai Chee | SG | 1.33333 | 103.93333 | 0 | Asia/Singapore | populated place | ||||
1880531 | Kampong Ulu Jurong | SG | 1.35 | 103.71667 | 0 | Asia/Singapore | populated place | ||||
1880536 | Tengah | Deng Jia,Dēng Jiā,Kampong Tengah,Teng-ka,Tengah,tenka,தெங்கா | SG | 1.37194 | 103.70389 | 0 | Asia/Singapore | populated place | |||
1880623 | Kampong Ayer Bajau | SG | 1.36667 | 103.65 | 0 | Asia/Singapore | populated place | ||||
1880529 | Kampong Unum | Kampong Unam,Kampong Unum | SG | 1.43139 | 104.05972 | 0 | Asia/Singapore | populated place | |||
1880544 | Kampong Sungai Tengah | SG | 1.38333 | 103.9 | 0 | Asia/Singapore | populated place | ||||
1880351 | Pulau Ubin Village | Kampong Pulau Ubin,Pulau Ubin,Pulau Ubin Village | SG | 1.40333 | 103.97139 | 0 | Asia/Singapore | populated place | |||
1880591 | Kampong Kranji | Kampong Kranji,Kelanzhi,Keranji,Kranji,Kèlánzhī,ke lan zhi,kiranci,கிராஞ்சி,克兰芝 | SG | 1.43333 | 103.75 | 0 | Asia/Singapore | populated place | |||
1880639 | Jalan Kayu | Dixil,Jalan Kayu,jalan kayu,re lan jia you,ஜலன் காயு,惹兰加由 | SG | 1.39722 | 103.87194 | 0 | Asia/Singapore | populated place | |||
1880576 | Kampong Pasir | SG | 1.40833 | 104.08417 | 0 | Asia/Singapore | populated place | ||||
1882107 | Saint Michael’s Estate | SG | 1.32778 | 103.86083 | 0 | Asia/Singapore | populated place | ||||
1880795 | Banta Tengeh | SG | 1.35 | 103.65 | 0 | Asia/Singapore | populated place | ||||
1880619 | Kampong Ayer Samak | SG | 1.42056 | 104.07944 | 0 | Asia/Singapore | populated place | ||||
1880601 | Kampong Cutforth | SG | 1.38194 | 103.73639 | 0 | Asia/Singapore | populated place | ||||
1880586 | Kampong Loyang | Kampong Loya,Kampong Loyang | SG | 1.37778 | 103.95944 | 0 | Asia/Singapore | populated place | |||
1880548 | Kampong Sungai Belang | SG | 1.42333 | 104.06667 | 0 | Asia/Singapore | populated place | ||||
1880428 | Ong Lee | Ong Lee,Ong Lee Village | SG | 1.35 | 103.75 | 0 | Asia/Singapore | populated place | |||
1880606 | Kampong Bukit Panjang | SG | 1.38361 | 103.76 | 0 | Asia/Singapore | populated place | ||||
1880571 | Kampong Pengkalan Petai | SG | 1.40333 | 103.85 | 0 | Asia/Singapore | populated place | ||||
1880616 | Kampong Bahru | Kampong Baharu,Kampong Bahru | SG | 1.41861 | 103.97028 | 0 | Asia/Singapore | populated place | |||
1880557 | Kampong Sanyongkong | SG | 1.39833 | 104.05778 | 0 | Asia/Singapore | populated place | ||||
1880751 | Bukit Mandai Village | Bukit Mandai,Bukit Mandai Village,Mandai,Mandai Road Village,Wanli,Wànlǐ,wan li,万礼 | SG | 1.41222 | 103.75667 | 0 | Asia/Singapore | populated place | |||
1880702 | Chong Pang | Chong Pang,Chong Pang Village | SG | 1.44444 | 103.82389 | 0 | Asia/Singapore | populated place | |||
1880620 | Kampong Ayer Merbau | SG | 1.26667 | 103.71667 | 0 | Asia/Singapore | populated place | ||||
1880131 | Tanjong Pagar | Tancon Pakar,Tanjong Pagar,Tanjung Pagar,Tañcōṅ Pakār,dan rong ba ge,tancon pakar,தஞ்சோங் பகார்,丹戎巴葛 | SG | 1.28333 | 103.83333 | 0 | Asia/Singapore | populated place | |||
1882316 | Woodlands | Woodlands,Woodlands New Town | SG | 1.43801 | 103.78877 | 252530 | Asia/Singapore | populated place | |||
1882778 | Marine Parade | Malin Bailie,Marine Parade,Marine Parade Estate,Mǎlín Bǎiliè,ma lin bai lie,marin paret,மரின் பரேட்,马林百列 | SG | 1.30306 | 103.90778 | 46390 | Asia/Singapore | populated place | |||
1880493 | Lam San Village | Lam San,Lam San Village | SG | 1.37694 | 103.73139 | 0 | Asia/Singapore | populated place | |||
1880560 | Kampong Saigon | SG | 1.21667 | 103.76667 | 0 | Asia/Singapore | populated place | ||||
7289737 | Bugis | Bugis,Bugis Square,Bugis Street,Bugis Village,Kampong Bugis,Wujishi,Wǔjíshì,pukis,wu ji shi,பூகிஸ்,武吉士 | SG | 1.30056 | 103.85493 | 0 | Asia/Singapore | populated place | |||
1880624 | Kampong Amoy Quee | SG | 1.38333 | 103.85 | 0 | Asia/Singapore | populated place | ||||
1880546 | Kampong Sungai Jurong | SG | 1.35167 | 103.73361 | 0 | Asia/Singapore | populated place | ||||
1882788 | Kampong Sakeng | SG | 1.20778 | 103.77778 | 0 | Asia/Singapore | populated place | ||||
1880610 | Kampong Blukang | SG | 1.35 | 103.65 | 0 | Asia/Singapore | populated place | ||||
1880527 | Kampong Wak Dulah | Kampong Dulah,Kampong Wak Dulah | SG | 1.38333 | 103.66667 | 0 | Asia/Singapore | populated place | |||
1882318 | Sungai Mandai Village | Sungai Mandai,Sungai Mandai Village | SG | 1.41056 | 103.77694 | 0 | Asia/Singapore | populated place | |||
1880701 | Chye Kay | SG | 1.42611 | 103.82417 | 0 | Asia/Singapore | populated place | ||||
1880618 | Kampong Ayer Samak Darat | SG | 1.41389 | 104.07222 | 0 | Asia/Singapore | populated place | ||||
1881953 | Jurong Town | Bandar Baharu Jurong,Jurong,Jurong New Town,Jurong Town,Jurong Village,Yulang,Yùláng,juron,yu lang,ஜூரோங்,裕廊 | SG | 1.33417 | 103.72278 | 0 | Asia/Singapore | populated place | |||
1880537 | Kampong Telok | SG | 1.38333 | 103.65 | 0 | Asia/Singapore | populated place | ||||
1880563 | Kampong Punggol | SG | 1.4125 | 103.91028 | 0 | Asia/Singapore | populated place | ||||
6942030 | Night Safari | SG | 1.40226 | 103.78789 | 0 | Asia/Singapore | populated place |
FaQ about Singapore
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