當前位置:首頁 » 數據倉庫 » 中國全國省市區資料庫
擴展閱讀
webinf下怎麼引入js 2023-08-31 21:54:13
堡壘機怎麼打開web 2023-08-31 21:54:11

中國全國省市區資料庫

發布時間: 2022-08-18 07:17:38

1. 哪位有包括全國省市區縣以及小區的資料庫

估計沒有哪位有,就算有也不可能給你的,這么大的數據估計也就國家才有,還有就是導航公司有大部分

2. 全國資料庫和省內資料庫的區別

一個是一個可以查看全國的,一個可以查看省內的。
資料庫是按照數據結構來組織、存儲和管理數據的倉庫。是一個長期存儲在計算機內的、有組織的、可共享的、統一管理的大量數據的集合。
資料庫是一個實體,它是能夠合理保管數據的倉庫,用戶在該倉庫中存放要管理的事務數據,數據和庫兩個概念結合成為資料庫。

3. 求一個sql或access 的中國省市資料庫

全國省市縣無刷新多級關聯菜單[網頁特效JS代碼]-

2006-3-21 22:56:27

<html>
<head>
<title>省市縣關聯菜單</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
body,select
{
font-size:9pt;
font-family:Verdana;
}
a
{
color:red;
text-decoration:none;
}
a:hover{
text-decoration:underline;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
<!--
function Dsy()
{
this.Items = {};
}
Dsy.prototype.add = function(id,iArray)
{
this.Items[id] = iArray;
}
Dsy.prototype.Exists = function(id)
{
if(typeof(this.Items[id]) == "undefined") return false;
return true;
}

function change(v){
var str="0";
for(i=0;i<v;i++){ str+=("_"+(document.getElementById(s[i]).selectedIndex-1));};
var ss=document.getElementById(s[v]);
with(ss){
length = 0;
options[0]=new Option(opt0[v],opt0[v]);
if(v && document.getElementById(s[v-1]).selectedIndex>0 || !v)
{
if(dsy.Exists(str)){
ar = dsy.Items[str];
for(i=0;i<ar.length;i++)options[length]=new Option(ar[i],ar[i]);
if(v)options[1].selected = true;
}
}
if(++v<s.length){change(v);}
}
}

var dsy = new Dsy();

dsy.add("0",["安徽","北京","福建","甘肅","廣東","廣西","貴州","海南","河北","河南","黑龍江","湖北","湖南","吉林","江蘇","江西","遼寧","內蒙古","寧夏","青海","山東","山西","陝西","上海","四川","天津","西藏","新疆","雲南","浙江","重慶"]);

dsy.add("0_0",["安慶","蚌埠","巢湖","池州","滁州","阜陽","合肥","淮北","淮南","黃山","六安","馬鞍山","宿州","銅陵","蕪湖","宣城","亳州"]);
dsy.add("0_0_0",["安慶市","懷寧縣","潛山縣","宿松縣","太湖縣","桐城市","望江縣","岳西縣","樅陽縣"]);
dsy.add("0_0_1",["蚌埠市","固鎮縣","懷遠縣","五河縣"]);
dsy.add("0_0_2",["巢湖市","含山縣","和縣","廬江縣","無為縣"]);
dsy.add("0_0_3",["池州市","東至縣","青陽縣","石台縣"]);
dsy.add("0_0_4",["滁州市","定遠縣","鳳陽縣","來安縣","明光市","全椒縣","天長市"]);
dsy.add("0_0_5",["阜南縣","阜陽市","界首市","臨泉縣","太和縣","穎上縣"]);
dsy.add("0_0_6",["長豐縣","肥東縣","肥西縣"]);
dsy.add("0_0_7",["淮北市","濉溪縣"]);
dsy.add("0_0_8",["鳳台縣","淮南市"]);
dsy.add("0_0_9",["黃山市","祁門縣","休寧縣","歙縣","黟縣"]);
dsy.add("0_0_10",["霍邱縣","霍山縣","金寨縣","六安市","壽縣","舒城縣"]);
dsy.add("0_0_11",["當塗縣","馬鞍山市"]);
dsy.add("0_0_12",["靈璧縣","宿州市","蕭縣","泗縣","碭山縣"]);
dsy.add("0_0_13",["銅陵市","銅陵縣"]);
dsy.add("0_0_14",["繁昌縣","南陵縣","蕪湖市","蕪湖縣"]);
dsy.add("0_0_15",["廣德縣","績溪縣","郎溪縣","寧國市","宣城市","涇縣","旌德縣"]);
dsy.add("0_0_16",["利辛縣","蒙城縣","渦陽縣","亳州市"]);

dsy.add("0_1",["北京"]);
dsy.add("0_1_0",["北京市","密雲縣","延慶縣"]);

dsy.add("0_2",["福州","龍岩","南平","寧德","莆田","泉州","三明","廈門","漳州"]);
dsy.add("0_2_0",["長樂市","福清市","福州市","連江縣","羅源縣","閩侯縣","閩清縣","平潭縣","永泰縣"]);
dsy.add("0_2_1",["長汀縣","連城縣","龍岩市","上杭縣","武平縣","永定縣","漳平市"]);
dsy.add("0_2_2",["光澤縣","建陽市","建甌市","南平市","浦城縣","邵武市","順昌縣","松溪縣","武夷山市","政和縣"]);
dsy.add("0_2_3",["福安市","福鼎市","古田縣","寧德市","屏南縣","壽寧縣","霞浦縣","周寧縣","柘榮縣"]);
dsy.add("0_2_4",["莆田市","仙游縣"]);
dsy.add("0_2_5",["安溪縣","德化縣","惠安縣","金門縣","晉江市","南安市","泉州市","石獅市","永春縣"]);
dsy.add("0_2_6",["大田縣","建寧縣","將樂縣","明溪縣","寧化縣","清流縣","三明市","沙縣","泰寧縣","永安市","尤溪縣"]);
dsy.add("0_2_7",["廈門市"]);
dsy.add("0_2_8",["長泰縣","東山縣","華安縣","龍海市","南靖縣","平和縣","雲霄縣","漳浦縣","漳州市","詔安縣"]);

dsy.add("0_3",["白銀","定西","甘南藏族自治州","嘉峪關","金昌","酒泉","蘭州","臨夏回族自治州","隴南","平涼","慶陽","天水","武威","張掖"]);
dsy.add("0_3_0",["白銀市","會寧縣","景泰縣","靖遠縣"]);
dsy.add("0_3_1",["定西縣","臨洮縣","隴西縣","通渭縣","渭源縣","漳縣","岷縣"]);
dsy.add("0_3_2",["迭部縣","合作市","臨潭縣","碌曲縣","瑪曲縣","夏河縣","舟曲縣","卓尼縣"]);
dsy.add("0_3_3",["嘉峪關市"]);
dsy.add("0_3_4",["金昌市","永昌縣"]);
dsy.add("0_3_5",["阿克塞哈薩克族自治縣","安西縣","敦煌市","金塔縣","酒泉市","肅北蒙古族自治縣","玉門市"]);
dsy.add("0_3_6",["皋蘭縣","蘭州市","永登縣","榆中縣"]);
dsy.add("0_3_7",["東鄉族自治縣","廣河縣","和政縣","積石山保安族東鄉族撒拉族自治縣","康樂縣","臨夏市","臨夏縣","永靖縣"]);
dsy.add("0_3_8",["成縣","徽縣","康縣","禮縣","兩當縣","文縣","武都縣","西和縣","宕昌縣"]);
dsy.add("0_3_9",["崇信縣","華亭縣","靜寧縣","靈台縣","平涼市","庄浪縣","涇川縣"]);
dsy.add("0_3_10",["合水縣","華池縣","環縣","寧縣","慶城縣","慶陽市","鎮原縣","正寧縣"]);
dsy.add("0_3_11",["甘谷縣","秦安縣","清水縣","天水市","武山縣","張家川回族自治縣"]);
dsy.add("0_3_12",["古浪縣","民勤縣","天祝藏族自治縣","武威市"]);
dsy.add("0_3_13",["高台縣","臨澤縣","民樂縣","山丹縣","肅南裕固族自治縣","張掖市"]);

dsy.add("0_4",["潮州","東莞","佛山","廣州","河源","惠州","江門","揭陽","茂名","梅州","清遠","汕頭","汕尾","韶關","深圳","陽江","雲浮","湛江","肇慶","中山","珠海"]);
dsy.add("0_4_0",["潮安縣","潮州市","饒平縣"]);
dsy.add("0_4_1",["東莞市"]);
dsy.add("0_4_2",["佛山市"]);
dsy.add("0_4_3",["從化市","廣州市","增城市"]);
dsy.add("0_4_4",["東源縣","和平縣","河源市","連平縣","龍川縣","紫金縣"]);
dsy.add("0_4_5",["博羅縣","惠東縣","惠陽市","惠州市","龍門縣"]);
dsy.add("0_4_6",["恩平市","鶴山市","江門市","開平市","台山市"]);
dsy.add("0_4_7",["惠來縣","揭東縣","揭西縣","揭陽市","普寧市"]);
dsy.add("0_4_8",["電白縣","高州市","化州市","茂名市","信宜市"]);
dsy.add("0_4_9",["大埔縣","豐順縣","蕉嶺縣","梅縣","梅州市","平遠縣","五華縣","興寧市"]);
dsy.add("0_4_10",["佛岡縣","連南瑤族自治縣","連山壯族瑤族自治縣","連州市","清新縣","清遠市","陽山縣","英德市"]);
dsy.add("0_4_11",["潮陽市","澄海市","南澳縣","汕頭市"]);
dsy.add("0_4_12",["海豐縣","陸豐市","陸河縣","汕尾市"]);
dsy.add("0_4_13",["樂昌市","南雄市","曲江縣","仁化縣","乳源瑤族自治縣","韶關市","始興縣","翁源縣","新豐縣"]);
dsy.add("0_4_14",["深圳市"]);
dsy.add("0_4_15",["陽春市","陽東縣","陽江市","陽西縣"]);
dsy.add("0_4_16",["羅定市","新興縣","鬱南縣","雲安縣","雲浮市"]);
dsy.add("0_4_17",["雷州市","廉江市","遂溪縣","吳川市","徐聞縣","湛江市"]);
dsy.add("0_4_18",["德慶縣","封開縣","高要市","廣寧縣","懷集縣","四會市","肇慶市"]);
dsy.add("0_4_19",["中山市"]);
dsy.add("0_4_20",["珠海市"]);

dsy.add("0_5",["百色","北海","崇左","防城港","桂林","貴港","河池","賀州","來賓","柳州","南寧","欽州","梧州","玉林"]);
dsy.add("0_5_0",["百色市","德保縣","靖西縣","樂業縣","凌雲縣","隆林各族自治縣","那坡縣","平果縣","田東縣","田林縣","田陽縣","西林縣"]);
dsy.add("0_5_1",["北海市","合浦縣"]);
dsy.add("0_5_2",["崇左市","大新縣","扶綏縣","龍州縣","寧明縣","憑祥市","天等縣"]);
dsy.add("0_5_3",["東興市","防城港市","上思縣"]);
dsy.add("0_5_4",["恭城瑤族自治縣","灌陽縣","桂林市","荔浦縣","臨桂縣","靈川縣","龍勝各族自治縣","平樂縣","全州縣","興安縣","陽朔縣","永福縣","資源縣"]);
dsy.add("0_5_5",["桂平市","貴港市","平南縣"]);
dsy.add("0_5_6",["巴馬瑤族自治縣","大化瑤族自治縣","東蘭縣","都安瑤族自治縣","鳳山縣","河池市","環江毛南族自治縣","羅城仡佬族自治縣","南丹縣","天峨縣","宜州市"]);
dsy.add("0_5_7",["富川瑤族自治縣","賀州市","昭平縣","鍾山縣"]);
dsy.add("0_5_8",["合山市","金秀瑤族自治縣","來賓市","武宣縣","象州縣","忻城縣"]);
dsy.add("0_5_9",["柳城縣","柳江縣","柳州市","鹿寨縣","融安縣","融水苗族自治縣","三江侗族自治縣"]);
dsy.add("0_5_10",["賓陽縣","橫縣","隆安縣","馬山縣","南寧市","上林縣","武鳴縣","邕寧縣"]);
dsy.add("0_5_11",["靈山縣","浦北縣","欽州市"]);
dsy.add("0_5_12",["蒼梧縣","蒙山縣","藤縣","梧州市","岑溪市"]);
dsy.add("0_5_13",["北流市","博白縣","陸川縣","容縣","興業縣","玉林市"]);
dsy.add("0_6",["安順","畢節","貴陽","六盤水","黔東南苗族侗族自治州","黔南布依族苗族自治州","黔西南布依族苗族自治州","銅仁","遵義"]);
dsy.add("0_6_0",["安順市","關嶺布依族苗族自治縣","平壩縣","普定縣","鎮寧布依族苗族自治縣","紫雲苗族布依族自治縣"]);
dsy.add("0_6_1",["畢節市","大方縣","赫章縣","金沙縣","納雍縣","黔西縣","威寧彝族回族苗族自治縣","織金縣"]);
dsy.add("0_6_2",["貴陽市","開陽縣","清鎮市","息烽縣","修文縣"]);
dsy.add("0_6_3",["六盤水市","六枝特區","盤縣","水城縣"]);
dsy.add("0_6_4",["從江縣","丹寨縣","黃平縣","劍河縣","錦屏縣","凱里市","雷山縣","黎平縣","麻江縣","三穗縣","施秉縣","台江縣","天柱縣","鎮遠縣","岑鞏縣","榕江縣"]);
dsy.add("0_6_5",["長順縣","都勻市","獨山縣","福泉市","貴定縣","惠水縣","荔波縣","龍里縣","羅甸縣","平塘縣","三都水族自治縣","甕安縣"]);
dsy.add("0_6_6",["安龍縣","冊亨縣","普安縣","晴隆縣","望謨縣","興仁縣","興義市","貞豐縣"]);
dsy.add("0_6_7",["德江縣","江口縣","石阡縣","思南縣","松桃苗族自治縣","銅仁市","萬山特區","沿河土家族自治縣","印江土家族苗族自治縣","玉屏侗族自治縣"]);
dsy.add("0_6_8",["赤水市","道真仡佬族苗族自治縣","鳳岡縣","仁懷市","綏陽縣","桐梓縣","務川仡佬族苗族自治縣","習水縣","余慶縣","正安縣","遵義市","遵義縣","湄潭縣"]);

dsy.add("0_7",["白沙黎族自治縣","保亭黎族苗族自治縣","昌江黎族自治縣","澄邁縣","定安縣","東方","海口","樂東黎族自治縣","臨高縣","陵水黎族自治縣","瓊海","瓊中黎族苗族自治縣","三亞","屯昌縣","萬寧","文昌","五指山","儋州"]);
dsy.add("0_7_0",["白沙黎族自治縣"]);
dsy.add("0_7_1",["保亭黎族苗族自治縣"]);
dsy.add("0_7_2",["昌江黎族自治縣"]);
dsy.add("0_7_3",["澄邁縣"]);
dsy.add("0_7_4",["定安縣"]);
dsy.add("0_7_5",["東方市"]);
dsy.add("0_7_6",["海口市"]);
dsy.add("0_7_7",["樂東黎族自治縣"]);
dsy.add("0_7_8",["臨高縣"]);
dsy.add("0_7_9",["陵水黎族自治縣"]);
dsy.add("0_7_10",["瓊海市"]);
dsy.add("0_7_11",["瓊中黎族苗族自治縣"]);
dsy.add("0_7_12",["三亞市"]);
dsy.add("0_7_13",["屯昌縣"]);
dsy.add("0_7_14",["萬寧市"]);
dsy.add("0_7_15",["文昌市"]);
dsy.add("0_7_16",["五指山市"]);
dsy.add("0_7_17",["儋州市"]);

dsy.add("0_8",["保定","滄州","承德","邯鄲","衡水","廊坊","秦皇島","石家莊","唐山","邢台","張家口"]);
dsy.add("0_8_0",["安國市","安新縣","保定市","博野縣","定興縣","定州市","阜平縣","高碑店市","高陽縣","滿城縣","清苑縣","曲陽縣","容城縣","順平縣","唐縣","望都縣","雄縣","徐水縣","易縣","淶水縣","淶源縣","涿州市","蠡縣"]);
dsy.add("0_8_1",["泊頭市","滄縣","滄州市","東光縣","海興縣","河間市","黃驊市","孟村回族自治縣","南皮縣","青縣","任丘市","肅寧縣","吳橋縣","獻縣","鹽山縣"]);
dsy.add("0_8_2",["承德市","承德縣","豐寧滿族自治縣","寬城滿族自治縣","隆化縣","灤平縣","平泉縣","圍場滿族蒙古族自治縣","興隆縣"]);
dsy.add("0_8_3",["成安縣","磁縣","大名縣","肥鄉縣","館陶縣","廣平縣","邯鄲市","邯鄲縣","雞澤縣","臨漳縣","邱縣","曲周縣","涉縣","魏縣","武安市","永年縣"]);
dsy.add("0_8_4",["安平縣","阜城縣","故城縣","衡水市","冀州市","景縣","饒陽縣","深州市","武強縣","武邑縣","棗強縣"]);
dsy.add("0_8_5",["霸州市","大廠回族自治縣","大城縣","固安縣","廊坊市","三河市","文安縣","香河縣","永清縣"]);
dsy.add("0_8_6",["昌黎縣","撫寧縣","盧龍縣","秦皇島市","青龍滿族自治縣"]);
dsy.add("0_8_7",["高邑縣","晉州市","井陘縣","靈壽縣","鹿泉市","平山縣","深澤縣","石家莊市","無極縣","辛集市","新樂市","行唐縣","元氏縣","贊皇縣","趙縣","正定縣","藁城市","欒城縣"]);
dsy.add("0_8_8",["樂亭縣","灤南縣","灤縣","遷安市","遷西縣","唐海縣","唐山市","玉田縣","遵化市"]);
dsy.add("0_8_9",["柏鄉縣","廣宗縣","巨鹿縣","臨城縣","臨西縣","隆堯縣","南宮市","南和縣","內丘縣","寧晉縣","平鄉縣","清河縣","任縣","沙河市","威縣","新河縣","邢台市","邢台縣"]);
dsy.add("0_8_10",["赤城縣","崇禮縣","沽源縣","懷安縣","懷來縣","康保縣","尚義縣","萬全縣","蔚縣","宣化縣","陽原縣","張北縣","張家口市","涿鹿縣"]);

dsy.add("0_9",["安陽","鶴壁","濟源","焦作","開封","洛陽","南陽","平頂山","三門峽","商丘","新鄉","信陽","許昌","鄭州","周口","駐馬店","漯河","濮陽"]);
dsy.add("0_9_0",["安陽市","安陽縣","滑縣","林州市","內黃縣","湯陰縣"]);
dsy.add("0_9_1",["","鶴壁市","浚縣","淇縣"]);
dsy.add("0_9_2",["濟源市"]);
dsy.add("0_9_3",["博愛縣","焦作市","孟州市","沁陽市","溫縣","武陟縣","修武縣"]);
dsy.add("0_9_4",["開封市","開封縣","蘭考縣","通許縣","尉氏縣","杞縣"]);
dsy.add("0_9_5",["洛寧縣","洛陽市","孟津縣","汝陽縣","新安縣","伊川縣","宜陽縣","偃師市","嵩縣","欒川縣"]);
dsy.add("0_9_6",["鄧州市","方城縣","南陽市","南召縣","內鄉縣","社旗縣","唐河縣","桐柏縣","西峽縣","新野縣","鎮平縣","淅川縣"]);
dsy.add("0_9_7",["寶豐縣","魯山縣","平頂山市","汝州市","舞鋼市","葉縣","郟縣"]);
dsy.add("0_9_8",["靈寶市","盧氏縣","三門峽市","陝縣","義馬市","澠池縣"]);
dsy.add("0_9_9",["民權縣","寧陵縣","商丘市","夏邑縣","永城市","虞城縣","柘城縣","睢縣"]);
dsy.add("0_9_10",["長垣縣","封丘縣","輝縣市","獲嘉縣","衛輝市","新鄉市","新鄉縣","延津縣","原陽縣"]);
dsy.add("0_9_11",["固始縣","光山縣","淮濱縣","羅山縣","商城縣","息縣","新縣","信陽市","潢川縣"]);
dsy.add("0_9_12",["長葛市","襄城縣","許昌市","許昌縣","禹州市","鄢陵縣"]);
dsy.add("0_9_13",["登封市","鞏義市","新密市","新鄭市","鄭州市","中牟縣","滎陽市"]);
dsy.add("0_9_14",["鄲城縣","扶溝縣","淮陽縣","鹿邑縣","商水縣","沈丘縣","太康縣","西華縣","項城市","周口市"]);
dsy.add("0_9_15",["泌陽縣","平輿縣","確山縣","汝南縣","上蔡縣","遂平縣","西平縣","新蔡縣","正陽縣","駐馬店市"]);
dsy.add("0_9_16",["臨潁縣","舞陽縣","郾城縣","漯河市"]);
dsy.add("0_9_17",["范縣","南樂縣","清豐縣","台前縣","濮陽市","濮陽縣"]);

dsy.add("0_10",["大慶","大興安嶺","哈爾濱","鶴崗","黑河","雞西","佳木斯","牡丹江","七台河","齊齊哈爾","雙鴨山","綏化","伊春"]);
dsy.add("0_10_0",["大慶市","杜爾伯特蒙古族自治縣","林甸縣","肇源縣","肇州縣"]);
dsy.add("0_10_1",["呼瑪縣","漠河縣","塔河縣"]);
dsy.add("0_10_2",["阿城市","巴彥縣","賓縣","方正縣","哈爾濱市","呼蘭縣","木蘭縣","尚志市","雙城市","通河縣","五常市","延壽縣","依蘭縣"]);
dsy.add("0_10_3",["鶴崗市","蘿北縣","綏濱縣"]);
dsy.add("0_10_4",["北安市","黑河市","嫩江縣","孫吳縣","五大連池市","遜克縣"]);
dsy.add("0_10_5",["虎林市","雞東縣","雞西市","密山市"]);
dsy.add("0_10_6",["撫遠縣","富錦市","佳木斯市","湯原縣","同江市","樺川縣","樺南縣"]);
dsy.add("0_10_7",["東寧縣","海林市","林口縣","牡丹江市","穆棱市","寧安市","綏芬河市"]);
dsy.add("0_10_8",["勃利縣","七台河市"]);
dsy.add("0_10_9",["拜泉縣","富裕縣","甘南縣","克東縣","克山縣","龍江縣","齊齊哈爾市","泰來縣","依安縣","訥河市"]);
dsy.add("0_10_10",["寶清縣","集賢縣","饒河縣","雙鴨山市","友誼縣"]);
dsy.add("0_10_11",["安達市","海倫市","蘭西縣","明水縣","青岡縣","慶安縣","綏化市","綏棱縣","望奎縣","肇東市"]);
dsy.add("0_10_12",["嘉蔭縣","鐵力市","伊春市"]);

dsy.add("0_11",["鄂州","恩施土家族苗族自治州","黃岡","黃石","荊門","荊州","潛江","神農架林區","十堰","隨州","天門","武漢","仙桃","咸寧","襄樊","孝感","宜昌"]);
dsy.add("0_11_0",["鄂州市"]);
dsy.add("0_11_1",["巴東縣","恩施市","鶴峰縣","建始縣","來鳳縣","利川市","咸豐縣","宣恩縣"]);
dsy.add("0_11_2",["紅安縣","黃岡市","黃梅縣","羅田縣","麻城市","團風縣","武穴市","英山縣","蘄春縣","浠水縣"]);
dsy.add("0_11_3",["大冶市","黃石市","陽新縣"]);
dsy.add("0_11_4",["荊門市","京山縣","沙洋縣","鍾祥市"]);
dsy.add("0_11_5",["公安縣","洪湖市","監利縣","江陵縣","荊州市","石首市","松滋市"]);
dsy.add("0_11_6",["潛江市"]);
dsy.add("0_11_7",["神農架林區"]);
dsy.add("0_11_8",["丹江口市","房縣","十堰市","鄖西縣","鄖縣","竹山縣","竹溪縣"]);
dsy.add("0_11_9",["廣水市","隨州市"]);
dsy.add("0_11_10",["天門市"]);
dsy.add("0_11_11",["武漢市"]);
dsy.add("0_11_12",["仙桃市"]);
dsy.add("0_11_13",["赤壁市","崇陽縣","嘉魚縣","通城縣","通山縣","咸寧市"]);
dsy.add("0_11_14",["保康縣","谷城縣","老河口市","南漳縣","襄樊市","宜城市","棗陽市"]);
dsy.add("0_11_15",["安陸市","大悟縣","漢川市","孝昌縣","孝感市","應城市","雲夢縣"]);
dsy.add("0_11_16",["長陽土家族自治縣","當陽市","五峰土家族自治縣","興山縣","宜昌市","宜都市","遠安縣","枝江市","秭歸縣"]);

dsy.add("0_12",["常德","長沙","郴州","衡陽","懷化","婁底","邵陽","湘潭","湘西土家族苗族自治州","益陽","永州","岳陽","張家界","株洲"]);
dsy.add("0_12_0",["安鄉縣","常德市","漢壽縣","津市市","臨澧縣","石門縣","桃源縣","澧縣"]);
dsy.add("0_12_1",["長沙市","長沙縣","寧鄉縣","望城縣","瀏陽市"]);
dsy.add("0_12_2",["安仁縣","郴州市","桂東縣","桂陽縣","嘉禾縣","臨武縣","汝城縣","宜章縣","永興縣","資興市"]);
dsy.add("0_12_3",["常寧市","衡東縣","衡南縣","衡山縣","衡陽市","衡陽縣","祁東縣","耒陽市"]);
dsy.add("0_12_4",["辰溪縣","洪江市","懷化市","會同縣","靖州苗族侗族自治縣","麻陽苗族自治縣","通道侗族自治縣","新晃侗族自治縣","中方縣","芷江侗族自治縣","沅陵縣","漵浦縣"]);
dsy.add("0_12_5",["冷水江市","漣源市","婁底市","雙峰縣","新化縣"]);
dsy.add("0_12_6",["城步苗族自治縣","洞口縣","隆回縣","邵東縣","邵陽市","邵陽縣","綏寧縣","武岡市","新寧縣","新邵縣"]);
dsy.add("0_12_7",["韶山市","湘潭市","湘潭縣","湘鄉市"]);
dsy.add("0_12_8",["保靖縣","鳳凰縣","古丈縣","花垣縣","吉首市","龍山縣","永順縣","瀘溪縣"]);
dsy.add("0_12_9",["安化縣","南縣","桃江縣","益陽市","沅江市"]);
dsy.add("0_12_10",["道縣","東安縣","江華瑤族自治縣","江永縣","藍山縣","寧遠縣","祁陽縣","雙牌縣","新田縣","永州市"]);
dsy.add("0_12_11",["華容縣","臨湘市","平江縣","湘陰縣","岳陽市","岳陽縣","汨羅市"]);
dsy.add("0_12_12",["慈利縣","桑植縣","張家界市"]);
dsy.add("0_12_13",["茶陵縣","炎陵縣","株洲市","株洲縣","攸縣","醴陵市"]);

dsy.add("0_13",["白城","白山","長春","吉林","遼源","四平","松原","通化","延邊朝鮮族自治州"]);
dsy.add("0_13_0",["白城市","大安市","通榆縣","鎮賚縣","洮南市"]);
dsy.add("0_13_1",["白山市","長白朝鮮族自治縣","撫松縣","江源縣","靖宇縣","臨江市"]);
dsy.add("0_13_2",["長春市","德惠市","九台市","農安縣","榆樹市"]);
dsy.add("0_13_3",["吉林市","磐石市","舒蘭市","永吉縣","樺甸市","蛟河市"]);
dsy.add("0_13_4",["東豐縣","東遼縣","遼源市"]);
dsy.add("0_13_5",["公主嶺市","梨樹縣","雙遼市","四平市","伊通滿族自治縣"]);
dsy.add("0_13_6",["長嶺縣","扶余縣","乾安縣","前郭爾羅斯蒙古族自治縣","松原市"]);
dsy.add("0_13_7",["輝南縣","集安市","柳河縣","梅河口市","通化市","通化縣"]);
dsy.add("0_13_8",["安圖縣","敦化市","和龍市","龍井市","圖們市","汪清縣","延吉市","琿春市"]);

dsy.add("0_14",["常州","淮安","連雲港","南京","南通","蘇州","宿遷","泰州","無錫","徐州","鹽城","揚州","鎮江"]);
dsy.add("0_14_0",["常州市","金壇市","溧陽市"]);
dsy.add("0_14_1",["洪澤縣","淮安市","金湖縣","漣水縣","盱眙縣"]);
dsy.add("0_14_2",["東海縣","贛榆縣","灌南縣","灌雲縣","連雲港市"]);
dsy.add("0_14_3",["高淳縣","南京市","溧水縣"]);
dsy.add("0_14_4",["海安縣","海門市","南通市","啟東市","如東縣","如皋市","通州市"]);
dsy.add("0_14_5",["常熟市","崑山市","蘇州市","太倉市","吳江市","張家港市"]);
dsy.add("0_14_6",["宿遷市","宿豫縣","沭陽縣","泗洪縣","泗陽縣"]);
dsy.add("0_14_7",["姜堰市","靖江市","泰興市","泰州市","興化市"]);
dsy.add("0_14_8",["江陰市","無錫市","宜興市"]);
dsy.add("0_14_9",["豐縣","沛縣","銅山縣","新沂市","徐州市","邳州市","睢寧縣"]);
dsy.add("0_14_10",["濱海縣","大豐市","東台市","阜寧縣","建湖縣","射陽縣","響水縣","鹽城市","鹽都縣"]);
dsy.add("0_14_11",["寶應縣","高郵市","江都市","揚州市","儀征市"]);
dsy.add("0_14_12",["丹陽市","句容市","揚中市","鎮江市"]);

dsy.add("0_15",["撫州","贛州","吉安","景德鎮","九江","南昌","萍鄉","上饒","新余","宜春","鷹潭"]);
dsy.add("0_15_0",["崇仁縣","東鄉縣","撫州市","廣昌縣","金溪縣","樂安縣","黎川縣","南城縣","南豐縣","宜黃縣","資溪縣"]);
dsy.add("0_15_1",["安遠縣","崇義縣","大余縣","定南縣","贛縣","贛州市","會昌縣","龍南縣","南康市","寧都縣","全南縣","瑞金市","上猶縣","石城縣","信豐縣","興國縣","尋烏縣","於都縣"]);
dsy.add("0_15_2",["安福縣","吉安市","吉安縣","吉水縣","井岡山市","遂川縣","泰和縣","萬安縣","峽江縣","新干縣","永豐縣","永新縣"]);
dsy.add("0_15_3",["浮梁縣","景德鎮市","樂平市"]);
dsy.add("0_15_4",["德安縣","都昌縣","湖口縣","九江市","九江縣","彭澤縣","瑞昌市","武寧縣","星子縣","修水縣","永修縣"]);
dsy.add("0_15_5",["安義縣","進賢縣","南昌市","南昌縣","新建縣"]);
dsy.add("0_15_6",["蓮花縣","蘆溪縣","萍鄉市","上栗縣"]);
dsy.add("0_15_7",["波陽縣","德興市","廣豐縣","橫峰縣","鉛山縣","上饒市","上饒縣","萬年縣","余干縣","玉山縣","弋陽縣","婺源縣"]);
dsy.add("0_15_8",["分宜縣","新余市"]);
dsy.add("0_15_9",["豐城市","奉新縣","高安市","靖安縣","上高縣","銅鼓縣","萬載縣","宜春市","宜豐縣","樟樹市"]);
dsy.add("0_15_10",["貴溪市","鷹潭市","余江縣"]);

dsy.add("0_16",["鞍山","本溪","朝陽","大連","丹東","撫順","阜新","葫蘆島","錦州","遼陽","盤錦","沈陽","鐵嶺","營口"]);
dsy.add("0_16_0",["鞍山市","海城市","台安縣","岫岩滿族自治縣"]);
dsy.add("0_16_1",["本溪滿族自治縣","本溪市","桓仁滿族自治縣"]);
dsy.add("0_

4. 全國31個省市自治區,都是哪裡

全國有23個省,4個直轄市,5個自治區,還有2個特別行政區。他們的名稱及省會名稱如下:

東北:

黑龍江省——哈爾濱、吉林省——長春、遼寧省——沈陽

華東:

上海市、江蘇省——南京、浙江省——杭州、安徽省——合肥、福建省——福州、江西省——南昌、山東省——濟南、台灣省——台北

華北:

北京市、天津市、山西省——太原、河北省——石家莊、內蒙古自治區——呼和浩特

華中:

河南省——鄭州、湖北省——武漢、湖南省——長沙

華南:

廣東省——廣州、廣西壯族自治區——南寧、海南省——海口

西南:

重慶市、四川省——成都、貴州省——貴陽、雲南省——昆明、西藏自治區

西北:

陝西省——西安、甘肅省——蘭州、青海省——西寧、寧夏回族自治區——銀川、新疆維吾爾自治區——烏魯木齊

特別行政區:香港特別行政區、澳門特別行政區


(4)中國全國省市區資料庫擴展閱讀:

我國共有34個省級行政區域,包括23個省,5個自治區,4個直轄市,2個特別行政區。

全國縣級以上行政區劃共有:23個省,5個自治區,4個直轄市,2個特別行政區;51個地區(州、盟),比上年減少了6個;660個市,其中:直轄市4個。地級市285個(包含新設立海南省三沙市),1642個縣(自治縣、旗、自治旗、特區和林區)和845個市轄區。

中華人民共和國行政區劃

截至2018年底,中國全國縣級以上行政區劃共有:23個省,5個自治區,4個直轄市,2個特別行政區;50個地區(州、盟);661個市,其中:直轄市4個;地級市283個;縣級市374個;1636個縣(自治縣、旗、自治旗、特區和林區);852個市轄區。

全國鄉鎮總數37334個,其中:鎮19883個;鄉17451個。全國共有街道辦事處5904個。

全國設有居委會(社區居委會)7.8萬個;居民小組129.6萬個。村委會64.4萬個;村民小組507.9萬個。

5. 怎麼把中國的省市區數據導入sqlserver資料庫

很簡單用數據工具打開表,倒入數據,或者編寫段小程序倒入數據。

6. 中國有多少個省市區,詳細!

截至2019年8月,中國有34個省級行政區,包括23個盛5個自治區、4個直轄市、2個特別行政區。

中國的各個省市自治區及其省會城市如下表:

各省簡稱:

北京(京)、天津(津)、黑龍江(黑)、吉林(吉)、遼寧(遼)、河北(冀)、河南(豫)、

山東(魯)、山西(晉)、陝西(陝)、內蒙古(內蒙古)、寧夏(寧)、甘肅(隴、甘)、

新疆(新)、青海(青)、西藏(藏)、湖北(鄂)、安徽(皖)、江蘇(蘇)、上海(滬)、

浙江(浙)、福建(閔)、湖南(湘)、江西(贛)、四川(川、蜀)、重慶(渝)、

貴州(黔、貴)、雲南(滇、雲)、廣東(粵)、廣西(桂)、海南(瓊)、

香港(港)、澳門(澳)、台灣(台)。

(6)中國全國省市區資料庫擴展閱讀:

全國各省的簡稱順口溜

東三省,黑吉遼;

北、西部,蒙新藏;

西南地區有去貴,華中華南兩湖廣;

東南沿海閩浙蘇,台瓊兩省切莫忘;

華北華東兩河山,皖贛東邊是浙江;

陝甘青川內地廣,寧夏雖小在胸膛;

直轄市,京津滬,山城重慶後補上;

香港澳門兩特區,九七、九九回娘家。

三十四個行政區,牢牢記在心坎上。

中國各省份名字的由來

1、山東——魯

以在太行山之東而得名。唐大部分屬河南道;宋設京東路,後分京東東、西路;金更名山東東、西路,為山東得名的開始;元設山東東西道;明置山東省,後改山東布政使司;清改山東省,省名至今未變。

2、山西——晉

以在太行山之西而行名。唐大部分屬河東道;宋設河東路;金分河東北、南路;元設山西河東道,為山西得名的開始;明置山西省,後改山西布政使司;清改山西省,省名至今未變。

3、河南——豫

以在黃河之南而得名。西漢即有河南郡,為河南得名的開始。唐大部分屬都畿道和河南道;宋設京畿路和京西北路;金改南京路;元設河南江北省和河南江北道;明置河南省,後改河南布政使司;清改河南省,省名至今未變。

4、河北——冀

以在黃河之北而得名。唐大部分屬河北道,為河北得名的開始。宋設河北路,後分河北東、西路;金分河北東路設大名府路;元設燕南趙北道;明設北平省,後廢省,所有府和直隸州直屬中央,稱北直隸;清改直隸省;1929年民國改河北省,省名至今未變。

5、湖南——湘

以在洞庭湖之南而得名。唐屬江南西道和黔中道,後設湖南觀察使,為湖南得名的開始;宋稱湖南路;元設嶺北湖南道;明屬湖廣省,後改省為湖廣布政使司;清分湖廣省置湖南省,省名至今未變。

6、湖北——鄂

以在洞庭湖之北而得名。唐屬江南東道、淮南道和山南東道;宋荊湖北路,簡稱湖北路,為湖北得名的開始;元設江南湖北道;明屬湖廣省,後改為省為湖廣布政使司;清分湖廣省置湖北省,省名至今未變。

7、廣東——粵

以廣南東路簡稱得名。唐屬嶺南道;宋以舊廣州轄地置廣南東路,簡稱廣東路,為廣得名的開始;元設海北廣東道;明置廣東省,後改廣東布政使司;清改廣東省,省名至今未變。

8、黑龍江——黑

以黑龍江而得名。清分吉林將軍置黑龍江將軍,清末改黑龍江省,省名至今未變。

9、遼寧——遼

以遼河流域永久安寧得名。唐屬河北道;遼置東京路;金仍之;元置遼陽行省;明為遼東都司;清設遼東將軍,後改奉天將軍,再改盛京將軍,清末改奉天省;

1929民國改遼寧省,為遼寧得名的開始;偽滿復改奉天省,1945收復後仍改遼寧省;建國初分遼東省和遼西省,後合並恢復遼寧省,省名至今未變。

10、吉林——吉

以吉林烏拉前二字得名,滿語吉林烏拉意為沿江。唐屬東北民族地;遼屬東京路;金屬上京路;元屬遼陽行省;明屬奴兒干都司;清設吉林將軍,清末改吉林省,省名至今未變。

11、安徽——皖

以安慶、徽州各取一字得名。唐大部屬江南西道和淮南道;宋置江南東路和淮南西路;元屬江東建康道和淮西江北道;明境內各府和直隸州直屬中央,稱為直隸,後改南直隸;

清改江南省,後分設安徽省,為安徽得名的開始;民國仍之;建國初分設皖北行署和皖南行署,後合並恢復安徽省,省名至今未變。

12、江蘇——蘇

以江寧、蘇州各取一字得名。唐大部屬江南東道和淮南道;宋置江南東路、兩浙西路和淮南東路;元屬江東建康道、江南浙西道、淮東江北道;

明境內各府和直隸州直屬中央,稱為直隸,後改南直隸;清改江南省,後分設江蘇省,為江蘇得名的開始;民國仍之;建國初分設蘇北行署和蘇南行署,後合並恢復江蘇省,省名至今未變。

13、福建——閩

以福州、建州各取一字得名。唐屬江南東道,後設福建觀察使,為福建得名的開始;宋置福建路;元設福建海右道;明置福建省,後改福建布政使司;清改福建省,省名至今未變。

14、甘肅——甘、隴

以甘州、肅州各取一字得名。唐屬關內道和隴右道;宋時東部屬宋秦鳳路,西部屬西夏;金分秦鳳路為秦鳳、臨洮、慶原三路;元初以甘州置甘肅路(不久即改甘州路),為甘肅得名的開始,後改寧夏行省為甘肅行省;明為陝西行都司;清分陝西省恢復甘肅省,省名至今未變

15、江西——贛

以江南的西部得名。唐屬江南西道,後設江西觀察使,為江西得名的開始;宋置江南西路,簡稱江西路;元設江西行省及江西湖東道;明置江西省,後改江西布政使司;清改江西省,省名至今未變。

16、雲南——滇、雲

以在雲嶺之南得名。漢即設雲南縣,為雲南得名的開始。唐為六詔,後為南詔;宋為大理國;元置雲南行省及雲南諸路道;明置雲南省,後改雲南布政使司;清改雲南省,省名至今未變。

17、貴州——黔、貴

以貴山得名。唐為黔中道;宋屬夔州路;元屬湖廣行省;明置貴州土司,是為貴州得名的開始,後置貴州布政使司;清改貴州省,省名至今未變。

18、四川——川、蜀

以益利梓夔四路得名。唐大部屬劍南道和山南東、山南西道;宋設川峽路(註:非川陝路),後分設西川路和峽西路,再分西川路為益州路和利州路,分峽西路為梓州路和夔州路,合稱四川,其間設四川制置使,為四川得名的開始,後改益州路為成都府路,

改梓州路為潼川府路,分利州路為利州東、西路。元置四川省和四川行省和西蜀四川道;明置四川省,後改四川布政使司;清改四川省;建國初分為川東、川南、川西、川北四行署,後合並恢復四川省,省名至今未變。

19、青海——青

以青海湖得名。唐宋屬吐蕃;元其土地屬宣政院管轄;明屬朵甘都司等;清初為衛藏地,後分設西寧辦事大臣,又稱青海辦事大臣,為青海得名的開始;民國初設青海辦事長官,後屬甘邊寧海鎮守使,之後建青海省,省名至今未變。

20、陝西——陝、秦

以陝原之西得名。唐大部屬京畿道和關內道;宋初設陝西路,為陝西得名的開始,後分設永興軍路,以軍事重鎮延寧、環慶、秦鳳、熙河五路設陝西五路經略使;元設陝西行省和陝西漢中道;明置陝西省,後改陝西布政使司;清改陝西省,省名至今未變。

21、浙江——浙

以浙江(又稱錢塘江)得名。唐屬江南東道,設浙東觀察使和浙西觀察使;宋置兩浙路,南宋又分兩浙東路和兩浙西路,簡稱浙東路和浙西路;元設浙東海右道和江南浙西道;明設浙江省,為浙江得名的開始,後改浙江布政使司;清改浙江省,省名至今未變。

22、海南——瓊

以海南島得名。唐屬嶺南道;宋屬廣南西路;元設海南海北道,是為海南得名的開始;明屬廣東省;清仍之,正式稱瓊崖為海南島;民國仍之,後設海南特別行政區,仍屬省;建國後設海南行政區,仍屬省,1988年為海南省,省名至今未變。

23、北京——京

北京有據可查的第一個名稱為「薊」,是春秋戰國時燕國的都城。遼金是將北京作為陪都,稱為燕京。金滅遼後,遷都於此,稱中都。元代改稱大都。明成祖朱棣從南京遷都於此,改稱北京」。名稱一直沿用至今。1949年設為直轄市。取全稱中的「京」字作為簡稱。

24、天津——津

唐宋以前,天津稱為直沽。金代形成集市稱「直沽寨」。元代設津海鎮,這是天津建城的開始。明永樂2年(1404年)築城設衛,始稱天津衛,取「天子經過的渡口」之意。1949年設為直轄市。取全稱中的「津」字作為簡稱。

25、上海——滬

上海之稱始於宋代,當時上海已成為我國的一個新興貿易港口,那時的上海地區有十八大浦,其中一條叫上海浦,它的西岸設有上海鎮。1292年,上海改鎮為縣。這是上海這一名稱的由來。

1949年,上海設為直轄市。古時,上海地區的漁民發明了一種竹編的捕魚工具扈,當時還沒有上海這一地名,因此,這一帶被稱為「滬瀆」,故上海簡稱滬。春秋戰國時上海是楚春申君黃歇封邑的一部分,故上海別稱申。

26、重慶——渝

重慶古稱巴」。秦時稱江州。隋稱渝州。北宋稱恭州。重慶之名始於1190年,因南宋光宗趙敦先封恭王,後登帝位,遂將恭州升為重慶府,取雙重喜慶」之意。1997年,重慶設為直轄市。隋時,嘉陵江稱渝水,重慶因位於嘉陵江畔而置渝州,故重慶簡稱渝」。

27、廣西壯族自治區

以廣南西路簡稱得名。唐屬嶺南道;宋置廣南西路,簡稱廣西路,為廣西得名的開始;元設廣西兩江道;明置廣西省,後改廣西布政使司;清改廣西省;民國仍之;建國後改廣西壯族自治區,區名至今未變。

28、內蒙古自治區

以漠南蒙古得名。唐為突厥地;宋時出現蒙古部落;後建元朝,其地直屬中書省及嶺北行省;明分達靼韃及瓦剌;清統一蒙古,以漠南蒙古居內地稱內蒙古,漠北蒙古居邊外稱外蒙古,並屬理藩院。

民國初分屬熱河、察哈爾、綏遠等特別區,後均改省;建國前中共以今內蒙古東部設內蒙古自治區,區名至今未變。

29、西藏自治區

以清正式定名得名。唐宋為吐蕃;元屬宣政院;明稱烏思藏,設都司等;清初稱衛藏,衛即前藏,藏即後藏;後正式定名為西藏,為西藏得名的開始;清設西藏辦事大臣;民國初西藏地方;建國後仍之,後改西藏自治區,區名至今未變。

30、寧夏回族自治區

以西夏安寧得名。唐屬關內道;宋時屬西夏;元滅西夏後以舊地設西夏行省,不久改寧夏行省,治所為寧夏路,為寧夏得名的開始,後改行省為甘肅行省,遷甘州路。明屬陝西省,改寧夏路為寧夏衛;清改寧夏府,屬甘肅省,並設寧夏將軍;民國初設甘邊寧夏護軍使。

31、新疆維吾爾

以其為新辟疆土而稱新疆。唐宋為西域;元明為察哈台汗國和窩闊台汗國地;清統一其地,其北部稱回部、南部稱准部,合稱回疆,設伊犁將軍,

又以其為新辟疆土而稱新疆(其時貴州新辟疆土亦稱新疆);清未設新疆省,是為新疆得名的開始;民國仍之;建國後改新疆維吾兒自治區,區名至今未變。

32、香港特別行政區

香港意為出口香料的港口;芳香的海港。香港位於中國東南端,是發展日漸迅速的東亞地區的樞紐,地理條件優越。

香港總面積達 1098平方公里,由香港島、一海之隔的九龍半島和新界(包括235個離島)組成,其中郊區多集中在新界。,「香港」原指石排灣、香港仔一帶,後推而廣之,擴大為香港全島乃至九龍、新界之總稱。

33、澳門特別行政區

據詞典解釋,澳是指海邊彎彎曲曲可以停船的地方。珠江口一帶這類海灣甚多,澳門是眾澳中地理環境比較好的一個澳。澳門之「門」又作何解釋呢?原來澳門南面有四個島,即仔、路環、大橫琴、小橫琴。四島分離對峙,海水縱橫分割而成十字,古人將此水域稱為「十字門」。

於是將「門」與「澳」糅合起來而成「澳門」。另有一種解釋認為,澳門北有蓮峰山,南有媽閣山,兩山對峙如「門」,上下海域為「澳」,合二為一稱「澳門」。

兩種說法都有道理,得到公認。澳門還有一個名字叫「蓮島」。此名既優雅大方,又通俗形象,作為別稱可謂恰到好處。

34、台灣

以台灣府得名。唐宋均為化外地;元在澎湖設巡檢司,兼管台灣漁民;明為荷蘭所佔,明末鄭成功收復,設東寧省及承天府;

清鄭氏,設台灣府及台廈道,是為台灣得名的開始,並正式稱台灣島,後改台廈道為台灣道;清末設台灣省,後為日佔,仍稱台灣;民國收復,恢復台灣省,省名至今未變。台灣是中國領土不可分割的一部分。

省會的變遷原因:

1、因政權的更替而變化,這是造成省會變遷最直接的因素。新政權往往與原政權有著不同發展思維戰略,對原政權的遺留問題往往會進行大刀闊斧的變革,同時受到的阻力較小,因此省會的遷移絕大多數都在政權更替之後的1912年、1950-1954年這樣的年份。

2、安全要求的需要。如廣西因邊防原因在桂林南寧間遷移省會。

3、經濟發展的需要。經濟發展的要求便利的交通和居中的地理位置尤其是位於鐵路交匯點的新興城市如哈爾濱、鄭州等。

4、像南京這樣因首都的得與失的因素而造成的省會的失與得。

7. 中國所有城市的資料庫在哪裡可以找到

在這里看一下,有沒有你需要的。
中國城市資料庫
http://www.cudb.net/
中國城市資料資料庫
Beta

http://www.fayland.org/journal/CityInfo_Beta.html

8. 中國各個省市區版圖面積

面積:

1、新疆維吾爾自治區 面積160萬平方公里

2、西藏自治區 面積120萬平方公里

3、內蒙古自治區面積110萬平方公里

4、青海省面積72萬平方公里

5、四川省面積48萬平方千米

6、黑龍江省面積46萬平方千米

7、甘肅省面積39萬平方千米

8、雲南省面積38萬平方千米

9、廣西壯族自治區面積23萬平方千米

10、湖南省面積21萬平方千米

11、河北省面積19萬平方千米

12、陝西省面積19萬平方千米

13、吉林省面積18萬平方千米

14、湖北省面積18萬平方千米

15、廣東省面積18萬平方千米

16、貴州省面積17萬平方千米

17、江西省面積16萬平方千米

18、河南省面積16萬平方千米

19、山東省面積15萬平方千米

20、山西省面積15萬平方千米

21、遼寧省面積15萬平方千米

22、安徽省面積13萬平方千米

23、福建省面積12萬平方千米

24、江蘇省面積10萬平方千米

25、浙江省面積10萬平方千米

26、重慶市面積8.23萬平方千米

27、寧夏回族自治區面積6.6萬平方千米

28、台灣省面積3.6萬平方千米

29、海南省面答3.4萬平方千米

30、北京市面積1.68萬平方千米

31、天津市 面積1.1萬平方千米

32、上海市 面積0.58萬平方千米

33、香港特別行政區面積1101平方千米

34、澳門特別行政區面積25.8平方千米

(8)中國全國省市區資料庫擴展閱讀

截止2019年01月09日,全國共有(省以下行政區劃單位統計不包括港澳台):

一級行政區(省級行政區):34個(23個省、5個自治區、4個直轄市、2個特別行政區)

二級行政區(地級行政區):333個(293個地級市、7個地區、30個自治州、3個盟)

三級行政區(縣級行政區):2851個(970個市轄區、375個縣級市、1335個縣、117自治縣、49個旗、3個自治旗、1個特區、1個林區)

四級行政區(鄉級行政區):39888個(2個區公所、21116個鎮、9392個鄉、152個蘇木、984個民族鄉、1個民族蘇木、8241個街道)

說明:四級行政區具體數量來源於《中華人民共和國行政區劃簡冊·2018》,一年統計一次,截止2018年1月1日。

按照行政區劃代碼用華北、華東、中南、東北、西南、西北、港澳台表示分布,具體如下 :

華北(北京、天津、河北、山西、內蒙古)

東北(遼寧、吉林、黑龍江)

華東(上海、江蘇、浙江、江西、安徽、福建、山東)

中南(河南、湖北、湖南、廣東、廣西、海南)

西南(重慶、四川、貴州、雲南、西藏)

西北(陝西、甘肅、青海、寧夏、新疆)

港澳台(香港、澳門、台灣)

參考資料來源:網路-中華人民共和國版圖

參考資料來源:網路-中華人民共和國行政區劃

9. 哪裡能找到全國城市列表的資料庫

很多很多,在一般能被點擊選擇城市的網頁里,提取網頁源內容就能獲得很完整的數據。
資料庫的保存方法、及關聯查找方法,建議最好是自己設計。

10. 全國有多少個省市區

4個直轄市 :北京上海天津 重慶
23個省 :黑龍江省(省會哈爾濱)、吉林省(省會長春)、遼寧省(省會沈陽)、江蘇省(省會南京)、山東省(省會濟南)、安徽省(省會合肥)、河北省(省會石家莊)、河南省(省會鄭州)、湖北省(省會武漢)、湖南省(省會長沙)、江西省(省會南昌)、陝西省(省會西安)、山西省(省會太原)、四川省(省會成都)、青海省(省會西寧)、海南省(省會海口)、廣東省(省會廣州)、貴州省(省會貴陽)、浙江省(省會杭州)、福建省(省會福州)、台灣省(省會台北)、甘肅省(省會蘭州)、雲南省(省會昆明)
5個自治區 :內蒙古自治區(首府呼和浩特)、寧夏回族自治區(首府銀川)、新疆維吾爾自治區(首府烏魯木齊)、西藏自治區(首府拉薩)、廣西壯族自治區(首府南寧)
2個特別行政區 :香港特別行政區 澳門特別行政

總的來說是34個