Singapore cities list with latitude and longitude in CSV,SQL,XML,JSON formats

Singapore
Singapore
CSV, SQL, XML, JSON

Last update : 15 January 2025.

Country
Singapore
Capitale
Singapore
Number of cities
135
Download
Click here

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_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
1880575Kampong Pasir MerahSG1.42917104.046940Asia/Singaporepopulated place
1882155Yishun New TownNee Soon,Yishun,Yishun New Town,yi shun,义顺,義順SG1.43333103.831110Asia/Singaporepopulated place
1880242Somapah SerangoonSG1.36667103.883330Asia/Singaporepopulated place
1880553Kampong SerayaSG1.28333103.733330Asia/Singaporepopulated place
1884737Choa Chu Kang New TownCCK,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,சுவா சூ காங்,蔡厝港SG1.3825103.749720Asia/Singaporepopulated place
1880437Nee Soon EstateNee Soon,Nee Soon Estate,Nee Soon VillageSG1.40278103.817780Asia/Singaporepopulated place
7289760Sengkang New TownSengkang,Sengkang New Town,Sheng Gang,Shèng Gǎng,cenkan,sheng gang,செங்காங்,盛港SG1.39167103.894440Asia/Singaporepopulated place
1880593Kampong KitinSG1.435103.859170Asia/Singaporepopulated place
1880226Sungai SimpangSungai Simpang,Sungei Simpang Village,Xinbang,Xīnbāng,xin bang,新邦SG1.43806103.826670Asia/Singaporepopulated place
1880828Aik Hong and Aik Chiang EstateSG1.39083103.728610Asia/Singaporepopulated place
1880539Kampong TebanSG1.37861103.907780Asia/Singaporepopulated place
1880602Kampong Che JevahSG1.41444103.989720Asia/Singaporepopulated place
1880582Kampong MelayuKampong Malayu,Kampong MelayuSG1.40861103.979440Asia/Singaporepopulated place
1880183Thong Hoe VillageThong Hoe,Thong Hoe VillageSG1.41806103.701940Asia/Singaporepopulated place
1880577Kampong PahangSG1.40917104.032780Asia/Singaporepopulated place
1880540Kampong Tanjong PenjuruKampong Tanjong Penjuru,Kampong Tanjong PenuruSG1.3103.750Asia/Singaporepopulated place
1880621Kampong Ayer LimauSG1.28333103.716670Asia/Singaporepopulated place
1880604Kampong ChangiSG1.383331040Asia/Singaporepopulated place
1880556Kampong Sanyonkong ParitKampong Sanyongkong,Kampong Sanyonkong ParitSG1.40611104.065830Asia/Singaporepopulated place
1880534Kampong Tongkang PechahSG1.39103.876390Asia/Singaporepopulated place
1880572Kampong Pengkalan PakauSG1.40944104.07250Asia/Singaporepopulated place
1880622Kampong Ayer GemuruhSG1.35103.983330Asia/Singaporepopulated place
1880135Yio Chu KangYio Chu Kang,Yio Chu Kang VillageSG1.39111103.851390Asia/Singaporepopulated place
1880611Kampong BerembanSG1.38139103.915830Asia/Singaporepopulated place
1880159Ulu BedokUlu Bedok,Ulu Bedok VillageSG1.33333103.933330Asia/Singaporepopulated place
1880329SagaSaga,Saga VillageSG1.26667103.833330Asia/Singaporepopulated place
1880554Kampong Serangoon KechilSG1.39103.907220Asia/Singaporepopulated place
1880609Kampong BugisSG1.21667103.766670Asia/Singaporepopulated place
1880348PunggolBang’e,Bǎng’é,Ponggol,Punggol,Punggol Village,bang e,ponkol,pwngl,پونگل,பொங்கோல்,榜鹅SG1.41444103.906940Asia/Singaporepopulated place
1880614Kampong Batu KoyokSG1.39694104.047780Asia/Singaporepopulated place
1880574Kampong Pasir RisBaisha,Baxili,Báishā,Bāxīlì,Kampong Pasir Ris,Pacir ris,Pasir Ris,Pācir ris,ba xi li,bai sha,pacir ris,பாசிர் ரிஸ்,巴西立,白沙SG1.37833103.931940Asia/Singaporepopulated place
1884365Ang Mo Kio New TownAng Mo Kio New TownSG1.38028103.839720Asia/Singaporepopulated place
1880528Kampong Wak BechikSG1.28333103.716670Asia/Singaporepopulated place
1880581Kampong NoordinSG1.41778103.9650Asia/Singaporepopulated place
1880525Kampong Wak SekakSG1.26667103.70Asia/Singaporepopulated place
7289766HarbourFrontSG1.2652103.82010Asia/Singaporepopulated place
1884382Bedok New TownBedok,Bedok New Town,Bedok Village,Pitok,Piṭōk,pitok,wu luo,பிடோக்,勿洛SG1.32639103.941670Asia/Singaporepopulated place
1880587Kampong Lew LianSG1.35103.866670Asia/Singaporepopulated place
1880144West Coast VillageSG1.31667103.750Asia/Singaporepopulated place
1880567Kampong PinangKampong Pinang,Kampong Sungi PinangSG1.38111103.894170Asia/Singaporepopulated place
6690793Blk 822 Jurong West Street 81SG1.347103.693570Asia/Singaporepopulated place
1882402KangkarSG1.37611103.901670Asia/Singaporepopulated place
1882118Tanglin HaltSG1.30139103.79750Asia/Singaporepopulated place
1880592Kampong KopitSG1.26667103.833330Asia/Singaporepopulated place
1880822Ama KengAma Keng,Ama Keng VillageSG1.40444103.706670Asia/Singaporepopulated place
7281987Novenanovina,nuo wei na,நொவீணா,诺维娜SG1.31697103.84380Asia/Singaporepopulated place
1880584Kampong MamamSG1.41722103.976110Asia/Singaporepopulated place
1880761Boon LayBoon Lay,Bun Le,Bûn Lé,pun le,wen li/wen li,பூன் லே,文礼/文禮SG1.33333103.70Asia/Singaporepopulated place
1880568Kampong PesekSG1.28333103.683330Asia/Singaporepopulated place
1882253Lim Chu KangLim Chu Kang,Lim-chhu-kang,Lincuogang,Líncuògǎng,Lîm-chhù-káng,lim cu kan,lin cuo gang,லிம் சூ காங்,林厝港SG1.43667103.709440Asia/Singaporepopulated place
1880579Kampong PachitanSG1.31667103.916670Asia/Singaporepopulated place
1880573Kampong Pengkalan KundorSG1.41103.844440Asia/Singaporepopulated place
1880137Yew TeeYew Tee,Yew Tee Village,Yow ToeSG1.39444103.753890Asia/Singaporepopulated place
1880755Bright Hill CrescentSG1.35103.833330Asia/Singaporepopulated place
1880541Kampong Tanjong IrauKampong Tanjong Irau,Kampong Wah TuangSG1.45667103.846670Asia/Singaporepopulated place
1880723Changi VillageChangi,Changi Village,Kampung Changi,zhang yi cun,樟宜村SG1.39037103.986740Asia/Singaporepopulated place
7289746NewtonSG1.30902103.837570Asia/Singaporepopulated place
1884367Bukit Panjang New TownBt Panjang,Bukit Panjang,Bukit Panjang New Town,Wujibanrang,Wǔjíbānràng,pukkittu pancan,wu ji ban rang,புக்கித்து பஞ்சாங்,武吉班让SG1.37972103.764720Asia/Singaporepopulated place
1880605Kampong Chai CheeSG1.33333103.933330Asia/Singaporepopulated place
1880531Kampong Ulu JurongSG1.35103.716670Asia/Singaporepopulated place
1880536TengahDeng Jia,Dēng Jiā,Kampong Tengah,Teng-ka,Tengah,tenka,தெங்காSG1.37194103.703890Asia/Singaporepopulated place
1880623Kampong Ayer BajauSG1.36667103.650Asia/Singaporepopulated place
1880529Kampong UnumKampong Unam,Kampong UnumSG1.43139104.059720Asia/Singaporepopulated place
1880544Kampong Sungai TengahSG1.38333103.90Asia/Singaporepopulated place
1880351Pulau Ubin VillageKampong Pulau Ubin,Pulau Ubin,Pulau Ubin VillageSG1.40333103.971390Asia/Singaporepopulated place
1880591Kampong KranjiKampong Kranji,Kelanzhi,Keranji,Kranji,Kèlánzhī,ke lan zhi,kiranci,கிராஞ்சி,克兰芝SG1.43333103.750Asia/Singaporepopulated place
1880639Jalan KayuDixil,Jalan Kayu,jalan kayu,re lan jia you,ஜலன் காயு,惹兰加由SG1.39722103.871940Asia/Singaporepopulated place
1880576Kampong PasirSG1.40833104.084170Asia/Singaporepopulated place
1882107Saint Michael’s EstateSG1.32778103.860830Asia/Singaporepopulated place
1880795Banta TengehSG1.35103.650Asia/Singaporepopulated place
1880619Kampong Ayer SamakSG1.42056104.079440Asia/Singaporepopulated place
1880601Kampong CutforthSG1.38194103.736390Asia/Singaporepopulated place
1880586Kampong LoyangKampong Loya,Kampong LoyangSG1.37778103.959440Asia/Singaporepopulated place
1880548Kampong Sungai BelangSG1.42333104.066670Asia/Singaporepopulated place
1880428Ong LeeOng Lee,Ong Lee VillageSG1.35103.750Asia/Singaporepopulated place
1880606Kampong Bukit PanjangSG1.38361103.760Asia/Singaporepopulated place
1880571Kampong Pengkalan PetaiSG1.40333103.850Asia/Singaporepopulated place
1880616Kampong BahruKampong Baharu,Kampong BahruSG1.41861103.970280Asia/Singaporepopulated place
1880557Kampong SanyongkongSG1.39833104.057780Asia/Singaporepopulated place
1880751Bukit Mandai VillageBukit Mandai,Bukit Mandai Village,Mandai,Mandai Road Village,Wanli,Wànlǐ,wan li,万礼SG1.41222103.756670Asia/Singaporepopulated place
1880702Chong PangChong Pang,Chong Pang VillageSG1.44444103.823890Asia/Singaporepopulated place
1880620Kampong Ayer MerbauSG1.26667103.716670Asia/Singaporepopulated place
1880131Tanjong PagarTancon Pakar,Tanjong Pagar,Tanjung Pagar,Tañcōṅ Pakār,dan rong ba ge,tancon pakar,தஞ்சோங் பகார்,丹戎巴葛SG1.28333103.833330Asia/Singaporepopulated place
1882316WoodlandsWoodlands,Woodlands New TownSG1.43801103.78877252530Asia/Singaporepopulated place
1882778Marine ParadeMalin Bailie,Marine Parade,Marine Parade Estate,Mǎlín Bǎiliè,ma lin bai lie,marin paret,மரின் பரேட்,马林百列SG1.30306103.9077846390Asia/Singaporepopulated place
1880493Lam San VillageLam San,Lam San VillageSG1.37694103.731390Asia/Singaporepopulated place
1880560Kampong SaigonSG1.21667103.766670Asia/Singaporepopulated place
7289737BugisBugis,Bugis Square,Bugis Street,Bugis Village,Kampong Bugis,Wujishi,Wǔjíshì,pukis,wu ji shi,பூகிஸ்,武吉士SG1.30056103.854930Asia/Singaporepopulated place
1880624Kampong Amoy QueeSG1.38333103.850Asia/Singaporepopulated place
1880546Kampong Sungai JurongSG1.35167103.733610Asia/Singaporepopulated place
1882788Kampong SakengSG1.20778103.777780Asia/Singaporepopulated place
1880610Kampong BlukangSG1.35103.650Asia/Singaporepopulated place
1880527Kampong Wak DulahKampong Dulah,Kampong Wak DulahSG1.38333103.666670Asia/Singaporepopulated place
1882318Sungai Mandai VillageSungai Mandai,Sungai Mandai VillageSG1.41056103.776940Asia/Singaporepopulated place
1880701Chye KaySG1.42611103.824170Asia/Singaporepopulated place
1880618Kampong Ayer Samak DaratSG1.41389104.072220Asia/Singaporepopulated place
1881953Jurong TownBandar Baharu Jurong,Jurong,Jurong New Town,Jurong Town,Jurong Village,Yulang,Yùláng,juron,yu lang,ஜூரோங்,裕廊SG1.33417103.722780Asia/Singaporepopulated place
1880537Kampong TelokSG1.38333103.650Asia/Singaporepopulated place
1880563Kampong PunggolSG1.4125103.910280Asia/Singaporepopulated place
6942030Night SafariSG1.40226103.787890Asia/Singaporepopulated place

Singapore: A Geographer’s Guide to a Thriving City-State

Singapore, a gleaming city-state at the southern tip of the Malay Peninsula, stands as a unique example of urban innovation and environmental adaptation. This small island nation, often regarded as a global financial hub, is a fascinating subject for geographers due to its blend of compactness, efficient use of space, and rapid transformation over the last few decades. As one of the world’s most developed countries, Singapore's geographical landscape, administrative structure, and urban planning serve as a model for cities worldwide.

A Compact Yet Complex Geography

Despite its small geographical size, Singapore's strategic location has made it one of the busiest ports in the world and a key player in global trade. The country consists of the main island of Singapore and over 60 smaller islands, many of which are uninhabited or used for specific purposes, such as recreation, nature reserves, or military bases.

Geographically, Singapore is characterized by its low-lying topography, with the highest point being Bukit Timah Hill, which rises just over 160 meters above sea level. The country is surrounded by the Singapore Strait, which serves as a vital shipping lane for global commerce. The nation is also known for its extensive coastline and the man-made reclamation projects that have significantly expanded its land area. These projects are essential to Singapore's urbanization, as the country has been able to extend its territory to accommodate its growing population and increasing demand for infrastructure.

The tropical climate, characterized by year-round heat and humidity, shapes the biodiversity and the way people interact with the environment. From its lush parks and nature reserves to its sprawling urban spaces, Singapore’s geographical features create an intricate balance between nature and development.

Administrative Divisions: Understanding Singapore’s Regional Framework

Singapore, although a city-state, is divided into five distinct planning regions, each with its own unique characteristics and administrative significance. These regions include the Central Region, Eastern Region, Western Region, Northern Region, and the Northeastern Region. Within these regions, the country is further subdivided into districts that reflect both the population distribution and the economic functions of each area.

The Central Region is the heart of Singapore, housing the central business district, major residential areas, and government buildings. It is also home to many cultural landmarks, shopping districts, and iconic structures, such as Marina Bay Sands and Gardens by the Bay. The other regions of Singapore are more diverse, with the Eastern Region featuring Changi Airport and the West being home to industrial hubs and natural reserves like Bukit Timah Nature Reserve. The northern and northeastern regions are more residential, with a focus on community living, greenery, and suburban development.

From a geographical standpoint, understanding the boundaries of these regions, districts, and even smaller neighborhoods is crucial for anyone looking to study urban planning, population growth, and economic development within the country. Each region in Singapore plays a different role, and detailed data on these regions, including their specific cities and localities, is essential for comprehensive analysis.

The Value of Geographical Data for Urban Analysis

To fully appreciate Singapore’s unique urban landscape, one must have access to detailed data on its cities and regions, including geographical coordinates such as latitude and longitude. This data is pivotal in understanding the city-state’s growth patterns, especially in relation to land use, transportation networks, and the evolving relationship between urban and natural spaces.

Precise geographical data allows researchers, city planners, and policy experts to evaluate how each district contributes to the overall success of Singapore. Cities like Orchard, which is a commercial and retail hotspot, or Jurong, known for its industrial developments, require different kinds of infrastructure and investment. Understanding the spatial relationships and positioning of these districts through accurate geographic data supports effective planning and policy decisions.

Moreover, such data is vital for evaluating the environmental aspects of Singapore's urbanization. With limited land available, the country has innovated solutions such as vertical gardens and green buildings to reduce the environmental impact of its dense urban areas. By studying the latitude and longitude of key regions, one can identify the areas most affected by these challenges and target solutions accordingly.

Harnessing the Power of Geographical Information

The ability to obtain detailed geographical data on Singapore’s cities, including their regions and departments, is indispensable for those involved in urban development, policy-making, and environmental conservation. Having access to the precise coordinates of key cities within each region allows geographers to create more accurate models of land use, transportation systems, and social infrastructure.

For example, the data can be used to optimize the movement of people and goods throughout the city, as Singapore’s transportation network is a critical factor in the country’s success. Public transportation systems such as the Mass Rapid Transit (MRT) network, buses, and taxi services must be strategically planned based on geographical information, ensuring efficient movement across both the dense urban core and suburban areas.

Geographical data is also crucial in assessing the effectiveness of Singapore's climate adaptation strategies. The country has made strides in managing rising sea levels, using data to implement flood control measures, coastal protection, and green infrastructure that mitigates environmental risks. Having the right data on the precise locations of these efforts allows for better planning and quicker adaptation to emerging threats.

The Future of Geographic Research in Singapore

Access to comprehensive geographic data about Singapore, including the latitude and longitude of each city and district, is crucial not only for researchers but also for anyone involved in urban development, environmental management, or social planning. As the country continues to grow and evolve, having detailed and accurate geographic data will remain an essential tool for ensuring that development remains sustainable, inclusive, and resilient.

By obtaining and utilizing this data, researchers can explore new avenues for improving urban living, enhancing public services, and managing Singapore’s limited land resources more effectively. Whether it’s optimizing land use for housing, creating green spaces for public enjoyment, or planning for future transportation needs, the power of geographical data cannot be overstated.

Conclusion: A Vision for Data-Driven Urban Planning

In conclusion, Singapore’s success as a thriving city-state is deeply rooted in its geographical innovation, efficient use of space, and meticulous planning. To understand how these achievements have been made, it is essential to access detailed geographical data on the cities, regions, and districts of the country. This data, which includes vital information about the geographical coordinates of each area, provides a foundation for better decision-making and more effective management of resources.

For anyone looking to explore Singapore’s geographical landscape and its future potential, having access to accurate, up-to-date data will open doors to deeper insights, enabling sustainable growth and development for years to come.

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

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.