China cities list with latitude and longitude in CSV format

China
China
CSV, SQL, XML, JSON

Last update : 27 April 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

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.