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

China
China
CSV, SQL, XML, JSON

Last update : 10 December 2024.

Country
China
Capitale
Beijing
Number of cities
792318
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
12468320XingdecunXingdecun,xing de cun,兴德村CNJilin42.64609126.064370Asia/Shanghaipopulated place
10132586ShangshagouShangshagou,shang sha gou,上沙沟CNHebeiZhangjiakou Shi40.31038114.736330Asia/Shanghaipopulated place
6972701JiangjunyanJiangjunyan,jiang jun yan,将军岩CNZhejiangHangzhou Shi29.37632119.521180Asia/Shanghaipopulated place
9290992DafanzhuangDafanzhuang,da fan zhuang,大范庄CNHebeiHengshui Shi37.93178116.386280Asia/Shanghaipopulated place
7657871ShangxiangShangxiang,shang xiang,上巷CNJiangxiJi’an Shi27.143114.984880Asia/Shanghaipopulated place
12347491QinjiacunQinjiacun,qin jia cun,秦家村CNShandong37.50451118.420540Asia/Shanghaipopulated place
6924967YouhuajingYouhuajing,you hua jing,油花井CNSichuanYibin Shi28.74194104.314430Asia/Shanghaipopulated place
7907933HuangtianHuangtian,huang tian,黄田CNGuangdongQingyuan Shi23.86583112.910830Asia/Shanghaipopulated place
9129236LuzhuangLuzhuang,lu zhuang,路庄CNShandongDezhou Shi36.6725116.660Asia/Shanghaipopulated place
10680667MankangchaMankangcha,man kang cha,墁炕岔CNGansuLanzhou Shi36.3048104.0850Asia/Shanghaipopulated place
7628548LiniutunLiniutun,li niu tun,李牛屯CNHeilongjiangHarbin Shi45.89556127.014670Asia/Shanghaipopulated place
10196713Wan’anWan’an,Wan’an,wan an,万安CNSichuanAba Zangzu Qiangzu Zizhizhou31.7625104.0460Asia/Shanghaipopulated place
11462735XiayuXiayu,xia yu,下峪CNShanxiLinfen Shi36.19779111.851210Asia/Shanghaipopulated place
12070768BaizhangBaizhang,bai zhang,百丈CNFujianNanping Shi28.0122118.421420Asia/Shanghaipopulated place
10864339FenglicunFenglicun,feng li cun,风里村CNGuangdongChaozhou Shi23.57908116.539380Asia/Shanghaipopulated place
10143520KongshandongKongshandong,kong shan dong,空山洞CNYunnanQujing Shi25.9778104.1130Asia/Shanghaipopulated place
10011968TaipingzhaiTaipingzhai,tai ping zhai,太平寨CNYunnanWenshan Zhuangzu Miaozu Zizhizhou24.0488105.0450Asia/Shanghaipopulated place
9998915DagonggouDagonggou,da gong gou,大弓沟CNHebeiZhangjiakou Shi41.59923114.532830Asia/Shanghaipopulated place
1984021YuntoucunYuntou,Yuntoucun,yun tou,yun tou cun,云头,云头村CNFujianNanping Shi27.17948118.665920Asia/Shanghaipopulated place
9897487TanliangcunTanliang,Tanliangcun,tan liang,tan liang cun,坛良,坛良村CNGuangxiNanning Shi22.65138108.428790Asia/Shanghaipopulated place
10202496YesituoYesituo,ye si tuo,耶斯托CNSichuanAba Zangzu Qiangzu Zizhizhou31.9215102.2420Asia/Shanghaipopulated place
10369325GupochongGupochong,gu po chong,古坡冲CNHunanHuaihua Prefecture27.28276109.645110Asia/Shanghaipopulated place
7678502ShishanShishan,shi shan,石山CNZhejiangHuzhou Shi30.73369119.998770Asia/Shanghaipopulated place
7756549XiantangXiantang,xian tang,仙塘CNJiangxiYichun Shi28.31204115.330520Asia/Shanghaipopulated place
9998732ShuixiangShuixiang,shui xiang,水乡CNHebeiZhangjiakou Shi41.67285114.331930Asia/Shanghaipopulated place
8134588YanwuchangYanwuchang,yan wu chang,岩屋场CNHunanChangde Shi28.9318111.978850Asia/Shanghaipopulated place
10156196DazhuyuanDazhuyuan,da zhu yuan,大竹园CNYunnanQujing Shi24.971103.8440Asia/Shanghaipopulated place
7738278LiantangLiantang,lian tang,莲塘CNJiangxiFuzhou Shi27.71188116.660Asia/Shanghaipopulated place
7661561NanliujiataiNanliujiatai,nan liu jia tai,南刘家台CNHubeiJingzhou Shi30.05665112.613840Asia/Shanghaipopulated place
1557291HouwangzhuangCNAnhuiHuainan Shi32.84167116.7250Asia/Shanghaipopulated place
10024738HuangnitianHuangnitian,huang ni tian,黄泥田CNGuizhouGuiyang Shi26.6526106.2950Asia/Shanghaipopulated place
11093864XiaochenXiaochen,xiao chen,肖陈CNJiangsuSuqian Shi33.7983118.2920Asia/Shanghaipopulated place
11513381WeizigouWeizigou,wei zi gou,苇子沟CNLiaoningTieling Shi42.2512124.0970Asia/Shanghaipopulated place
12198086BaitasicunBaitasicun,bai ta si cun,白塔寺村CNShandongTai’an Shi35.85492116.74670Asia/Shanghaipopulated place
2033305YongsijiangYongsijiang,yong si jiang,永四疆CNHeilongjiangJiamusi Shi47.71667132.983330Asia/Shanghaipopulated place
6823931LiguanyingLiguanying,li guan ying,李官营CNYunnanKunming Shi24.6052102.6840Asia/Shanghaipopulated place
10039382DazheheiDazhehei,da zhe hei,大者黑CNYunnanHonghe Hanizu Yizu Zizhizhou23.9503103.3550Asia/Shanghaipopulated place
6959613LeigongpingLeigongping,lei gong ping,雷公坪CNSichuanLeshan Shi28.68186103.46380Asia/Shanghaipopulated place
2037406FengkuCNJilinSongyuan Shi44.28333123.250Asia/Shanghaipopulated place
11589935HepingcunHepingcun,he ping cun,和平村CNHeilongjiangMudanjiang Shi44.23459129.31530Asia/Shanghaipopulated place
10355658XiaotangpuXiaotangpu,xiao tang pu,晓塘铺CNHunanYongzhou25.90036111.931790Asia/Shanghaipopulated place
7072175ChenjiaChenjia,chen jia,陈家CNZhejiangNingbo Shi29.90299121.375610Asia/Shanghaipopulated place
1551793LiziCNGuizhouZunyi Shi27.98528106.645280Asia/Shanghaipopulated place
10634039HouwangzhuangHouwangzhuang,hou wang zhuang,后王庄CNHenanZhoukou Shi33.87978114.783750Asia/Shanghaipopulated place
1982776XinluheCNHunanHuaihua Prefecture27.48110.273060Asia/Shanghaipopulated place
12116757LiutianzhuangcunLiutianzhuangcun,liu tian zhuang cun,刘田庄村CNShandongLinyi Shi35.0261118.504670Asia/Shanghaipopulated place
10003656GuimoGuimo,gui mo,规模CNGuizhouQianxinan Buyei and Miao Autonomous Prefecture25.9192105.2680Asia/Shanghaipopulated place
12450152HongweicunHongweicun,hong wei cun,红卫村CNHeilongjiang51.69964126.631760Asia/Shanghaipopulated place
10429528CaojiazhuangCaojiazhuang,cao jia zhuang,曹家庄CNGansuTianshui Shi34.3624106.1990Asia/Shanghaipopulated place
10140999ShuyecunShuyecun,shu ye cun,树叶村CNYunnanZhaotong Shi27.3651103.0650Asia/Shanghaipopulated place
11799726BeitingBeiting,bei ting,碑亭CNZhejiangShaoxing Shi29.68929120.248370Asia/Shanghaipopulated place
10361929DaliwangDaliwang,da li wang,大里王CNHenanLuoyang Shi34.72725112.540480Asia/Shanghaipopulated place
12142123ChenzhongcunChenzhongcun,chen zhong cun,陈中村CNShandongDongying Shi37.6855118.4670Asia/Shanghaipopulated place
10207746EbaEba,e ba,俄巴CNSichuanGarzê Zangzu Zizhizhou29.7733100.9840Asia/Shanghaipopulated place
10647873Leijia HoutaiLeijia Houtai,lei jia hou tai,雷家后台CNGansuWuwei Shi37.5097103.0530Asia/Shanghaipopulated place
7461503LongbeiLongbei,long bei,龙陂CNJiangxiGanzhou Shi26.06774116.265280Asia/Shanghaipopulated place
12370456WangmozhuangcunWangmozhuangcun,wang mo zhuang cun,王莫庄村CNShandong35.95404117.538940Asia/Shanghaipopulated place
6981350HeyuanHeyuan,he yuan,和源CNSichuanYa’an Shi30.02545102.803260Asia/Shanghaipopulated place
10024089LingjiangLingjiang,ling jiang,陵江CNGuizhouBijie Diqu26.9409105.6950Asia/Shanghaipopulated place
8275542ZhuyuanzhuangZhuyuanzhuang,zhu yuan zhuang,竹园庄CNAnhuiChuzhou Shi32.71806118.72890Asia/Shanghaipopulated place
12082305GouqujiacunGouqujiacun,gou qu jia cun,沟曲家村CNShandongWeihai Shi37.20033122.252580Asia/Shanghaipopulated place
11586639QianjincunQianjincun,qian jin cun,前进村CNHeilongjiangHarbin Shi46.10204127.390280Asia/Shanghaipopulated place
8574739QiaoguangcunQiaoguang,Qiaoguangcun,qiao guang,qiao guang cun,桥光,桥光村CNFujianPutian Shi25.6525118.789160Asia/Shanghaipopulated place
8597843LingjiaocunLingjiao,Lingjiaocun,ling jiao,ling jiao cun,岭脚,岭脚村CNFujianZhangzhou Shi24.16604117.795130Asia/Shanghaipopulated place
11527809MeijiacunMeijia Wobu,Meijiacun,Meijiawobao,mei jia cun,mei jia wo bao,梅家村,梅家窝堡CNLiaoningAnshan Shi41.4134122.428660Asia/Shanghaipopulated place
11714213WanlicunWanlicun,wan li cun,湾里村CNZhejiangJiaxing Shi30.51849120.503720Asia/Shanghaipopulated place
7516105HezhuangHezhuang,he zhuang,何庄CNNingxia Hui Autonomous RegionGuyuan Shi36.55265106.047930Asia/Shanghaipopulated place
9900067ChangtiancunChangtian,Changtiancun,zhang tian,zhang tian cun,长田,长田村CNGuangxiYulin Shi22.19366109.559640Asia/Shanghaipopulated place
7919509DongdalingDongdaling,dong da ling,东大岭CNLiaoningAnshan Shi40.69047123.092220Asia/Shanghaipopulated place
8561627ChencunChencun,chen cun,陈村CNHebeiShijiazhuang Shi38.08145114.868110Asia/Shanghaipopulated place
7509373XimazhuangXimazhuang,xi ma zhuang,西马庄CNShanxiShuozhou Shi39.71055112.817050Asia/Shanghaipopulated place
9939507LanbazhaiLanbazhai,lan ba zhai,烂坝寨CNYunnanLincang Shi24.663799.7780Asia/Shanghaipopulated place
10198494WujiapingWujiaping,wu jia ping,五家坪CNSichuanYa’an Shi29.279102.7460Asia/Shanghaipopulated place
6818677WangjiagouWangjiagou,wang jia gou,王家沟CNSichuanGuangyuan Shi31.62361105.405780Asia/Shanghaipopulated place
7006750ChahugouChahugou,cha hu gou,茶壶沟CNHunanXiangxi Tujiazu Miaozu Zizhizhou29.15226109.732820Asia/Shanghaipopulated place
11246666WawucunWawucun,wa wu cun,瓦屋村CNShandongQingdao Shi35.83276119.980960Asia/Shanghaipopulated place
7734039HuanxiHuanxi,huan xi,环溪CNZhejiangHangzhou Shi30.22079120.304970Asia/Shanghaipopulated place
11714655ChanglecunChanglecun,chang le cun,常乐村CNZhejiangHuzhou Shi30.91632120.307680Asia/Shanghaipopulated place
12342127Bailong ShequBailong Shequ,bai long she qu,白龙社区CNGuangxi24.50429108.661180Asia/Shanghaipopulated place
10158801LiujiacunLiujiacun,liu jia cun,六家村CNYunnanKunming Shi26.0212103.2570Asia/Shanghaipopulated place
10140667XiarelongXiarelong,xia re long,下热陇CNSichuanAba Zangzu Qiangzu Zizhizhou34.1654102.8840Asia/Shanghaipopulated place
10198119ZhengcaoZhengcao,zheng cao,整槽CNSichuanLeshan Shi29.3483103.2790Asia/Shanghaipopulated place
7446041YinmusicunYinmusicun,yin mu si cun,银母寺村CNShaanxiBaoji Shi33.88867106.946670Asia/Shanghaipopulated place
8404395NanshuNanshu,nan shu,楠树CNChongqingChongqing30.93601108.462590Asia/Shanghaipopulated place
11560285SangzhuangcunSangzhuangcun,sang zhuang cun,桑庄村CNJiangsuLianyungang Shi34.39148118.907470Asia/Shanghaipopulated place
11722949HenglingcunHenglingcun,heng ling cun,横岭村CNZhejiangHuzhou Shi30.68162119.844820Asia/Shanghaipopulated place
8365367JiangcunJiangcun,jiang cun,江村CNJiangsuTaizhou Shi32.4447120.116520Asia/Shanghaipopulated place
9874193ChangquwanChangquwan,zhang qu wan,长曲湾CNJiangxiPingxiang Shi27.1538113.8860Asia/Shanghaipopulated place
11892225AnjianmailisiAnjianmailisi,an jian mai li si,安间买力斯CNXinjiangKaxgar Diqu39.3129276.267940Asia/Urumqipopulated place
10651046ZhengwancunZhengwancun,zheng wan cun,郑湾村CNAnhuiHefei Shi31.0599117.21390Asia/Shanghaipopulated place
1916770DasuyangCNZhejiangQuzhou Shi29.31028118.362780Asia/Shanghaipopulated place
7331916ZhouzhuangZhouzhuang,zhou zhuang,周庄CNJiangsuSuzhou Shi31.35824120.391450Asia/Shanghaipopulated place
11451970ShiyaoShiyao,shi yao,石窑CNShanxiJincheng Shi35.35111112.317970Asia/Shanghaipopulated place
7528062ShuangfengcheShuangfengche,shuang feng che,双风车CNJiangsuYancheng Shi32.64643120.111570Asia/Shanghaipopulated place
7072418ShizhuShizhu,shi zhu,石竹CNZhejiangShaoxing Shi29.4012120.931960Asia/Shanghaipopulated place
7513980XiaodanglouXiaodanglou,xiao dang lou,小党楼CNHenanZhumadian Shi33.02078113.945720Asia/Shanghaipopulated place
9934107MuliMuli,mu li,木梨CNGuangxiLaibin Shi23.8361109.440Asia/Shanghaipopulated place
10025641XinzhaiXinzhai,xin zhai,新寨CNGuizhouQiannan Bouyeizu Miaozu Zizhizhou25.9893106.6830Asia/Shanghaipopulated place
10031550MajiabaMajiaba,ma jia ba,麻家坝CNGuizhouZunyi Shi27.8927107.290Asia/Shanghaipopulated place
10429193LizigouLizigou,li zi gou,李子沟CNGansuTianshui Shi34.546105.0810Asia/Shanghaipopulated place

China: A Geographical Powerhouse at the Heart of Asia

China, the world’s most populous country and second-largest by land area, offers one of the most diverse and expansive geographical landscapes found anywhere on Earth. Spanning deserts, mountains, rivers, plateaus, and fertile plains, China’s geography plays a significant role in shaping its history, culture, and development. From the towering peaks of the Himalayas to the dense forests of the southeast, China is a land of extreme contrasts, making it a rich field of study for geographers and researchers alike. Access to detailed data on China’s cities, regions, and departments—including precise latitude and longitude information—can provide deeper insights into the geographical diversity and urban dynamics of this vast nation.

A Land of Contrasts: China’s Diverse Landscapes

China’s geography is as varied as it is vast, with a range of climates and landscapes that differ dramatically from region to region. In the west, China is home to the **Tibetan Plateau**, also known as the "Roof of the World." This region is dominated by high-altitude mountains, glaciers, and vast grasslands. The plateau forms the heart of the country's cultural and spiritual heritage, as it is home to several Tibetan Buddhist monasteries and the unique culture of the Tibetan people.

To the east, China’s geography shifts dramatically. The **North China Plain** is an extensive area of fertile land, nourished by the mighty **Yellow River** (Huang He). This region is the heart of China’s agricultural production and has historically been the foundation of Chinese civilization. The **Yangtze River** (Chang Jiang) flows through the south, creating another vast agricultural region in the **Yangtze River Delta** that is crucial for the economy of modern China, particularly for industrial and commercial activities.

In the south, China’s geography becomes even more diverse, transitioning into subtropical and tropical regions. The **Sichuan Basin**, surrounded by mountains, is a fertile region known for its rice cultivation, while the **South China Sea** coast includes bustling cities like **Guangzhou** and **Shenzhen**, and the stunning karst landscape of **Guilin**.

China is also home to some of the most well-known deserts in the world, such as the **Gobi Desert** and the **Taklamakan Desert**, which form part of the arid northern and western regions. These desert areas, with their harsh climate and unique ecosystems, contrast sharply with the more temperate zones in the east and south.

Urbanization and Economic Hubs: The Cities of China

China’s cities are diverse and dynamic, each with its own unique geographical, cultural, and economic identity. **Beijing**, the capital, is located in the northern part of the country, near the border of the vast steppes. It is a city of monumental historical significance, home to imperial palaces and ancient temples, and serves as the political heart of the nation.

To the southeast, **Shanghai**, located on the coast of the East China Sea, has become a global financial hub. Known for its modern skyline, historical districts, and strategic port, Shanghai is one of China’s largest cities and a key player in the world’s economy. The city’s proximity to the Yangtze River Delta has facilitated rapid urban growth and industrialization, contributing to its position as one of the world’s most important trade and commerce centers.

In the south, **Hong Kong** stands as a special administrative region, a global financial center known for its free-market economy and cosmopolitan atmosphere. While officially part of China, it maintains a separate political and economic system, which contributes to its distinct international identity.

Chengdu**, located in the interior of Sichuan province, is another key city in China’s urban landscape. Surrounded by mountains and rich farmland, Chengdu is a hub for technology, research, and cultural heritage, particularly famous for its cuisine and as the home of the **giant panda**. It is an example of how China’s interior regions have also experienced rapid growth and development in recent years.

The Regional Structure: Understanding China’s Administrative Divisions

China’s vast landmass is divided into **34 provincial-level divisions**, which include **23 provinces**, **5 autonomous regions**, **4 direct-controlled municipalities**, and **2 Special Administrative Regions (SARs)**. Each of these divisions reflects the unique geographical, cultural, and economic characteristics of the regions they represent.

Some of the key administrative regions in China include:

- **Beijing** and **Shanghai**: These municipalities are directly governed by the central government and serve as the country’s political, cultural, and economic epicenters.

- **Guangdong**: This coastal province, home to cities like **Guangzhou** and **Shenzhen**, has been the engine of China’s economic reforms and industrialization since the 1980s.

- **Xinjiang**: Located in China’s far west, this autonomous region is the country’s largest and is known for its deserts, mountains, and the diverse culture of the **Uighur** people.

- **Tibet**: The **Tibet Autonomous Region** (TAR), located in the southwest, is largely defined by its rugged terrain, and is home to the Tibetan Plateau and its unique cultural identity.

- **Inner Mongolia**: Located in the northern part of China, this autonomous region is a vast steppe, characterized by its pastoral economy and the presence of Mongol culture.

These regions are not only crucial for governance but also for economic planning and development. Each region has unique challenges and opportunities based on its geography, natural resources, and cultural heritage. Understanding the geographical and administrative divisions of China is essential for anyone looking to gain deeper insights into the country’s spatial organization and development trends.

Accessing Geographic Data on China’s Cities and Regions

For geographers, researchers, and anyone interested in understanding China’s cities and regions in greater depth, access to detailed geographic data is key. Our comprehensive database provides exact **latitude and longitude** coordinates for each of China’s cities, regions, and departments. By obtaining this data, you can conduct precise spatial analysis, create detailed maps, and gain a deeper understanding of China’s complex geography.

This data is invaluable for a wide range of applications, including urban planning, environmental management, infrastructure development, and tourism. Whether you are interested in the rapid urbanization of **Shanghai**, the agricultural potential of **Sichuan**, or the unique geographical challenges of **Xinjiang**, the database provides the essential tools to explore China’s cities and regions with accuracy and depth.

Conclusion: Unlocking the Geographic Richness of China

China is a country of extraordinary geographical diversity, where landscapes and cities are as varied as its cultural and economic traditions. From the high mountains of the west to the coastal plains of the east, China offers an unparalleled diversity of environments that shape the lives of its people. Access to detailed data on the cities, regions, and departments of China—including their precise latitude and longitude coordinates—opens up new possibilities for understanding the country’s geography in all its complexity. Whether for academic research, urban development, or policy-making, this geographic data provides the insights needed to explore and understand one of the world’s most dynamic and rapidly changing nations.

FaQ about China

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.