國家省市區資料庫

Ⅰ 請問用什麼方式可以實現省市級聯的效果呀 省市的數據是從資料庫中查出來的

使用jquery的ajax方式從伺服器載入json數據至客戶端即可以實現省市級聯的效果。
具體如下：
1）、頁面初始化時，首先載入所有的省；
2）、選擇省，ajax傳送編碼至伺服器，伺服器根據選中的省編碼，返回省下所有的市。
這樣就能動態實現了省市級聯的效果了。

Ⅱ 資料庫設計 國家表 國家編號:char(3) 國名：vARCHAR(50) 省市表 省市編號：char(3) 省市名：varchar(50)

(1)要求查找」中國河北省「的所有縣名。該如何查找，寫出sql語句
SELECT
縣郡表.縣郡名
FROM
國家表 JOIN 省市表 ON ( 國家表.國家編號 = 省市表.國家編號 )
JOIN 縣郡表 ON ( 縣郡表.省市編號 = 省市表.省市編號 )
WHERE
國家表.國名 = '中國' AND 省市表.省市名 = '河北'

（2）在功能不變的前提下，將上述三表合並成一個表，該如何設計？在你的設計中，實現上述查找的SQL語句該如何寫

CREATE TABLE 國省縣 (
國名：vARCHAR(50),
省市名：varchar(50),
縣郡名：VarChar(50)
)

SELECT
縣郡名
FROM
國省縣
WHERE
國名 = '中國' AND 省市名 = '河北'

Ⅲ 如何用Access做資料庫錄入全國城市

三張表

表一：省

另外無論怎麼建表，市和省總會重復的，畢竟省市縣是包含關系

Ⅳ 急求一個SQL的省市區資料庫，而且省市區在一張表中，如下圖所示！！！！

創建表的面積
（

NUID整型，

parentId的詮釋，

AREANAME為varchar（20）
）

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

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

Ⅵ 求一完整的全國省市級聯的oracle資料庫建表腳本

--省級 provincial
create table provincial
(
provincialID int,
provincialName varchar(50),
primary key (provincialID)
)engine=INNODB default charset=gbk;

insert into provincial values(1,'北京市');
insert into provincial values(2,'天津市');
insert into provincial values(3,'上海市');
insert into provincial values(4,'重慶市');
insert into provincial values(5,'河北省');
insert into provincial values(6,'山西省');
insert into provincial values(7,'台灣省');
insert into provincial values(8,'遼寧省');
insert into provincial values(9,'吉林省');
insert into provincial values(10,'黑龍江省');
insert into provincial values(11,'江蘇省');
insert into provincial values(12,'浙江省');
insert into provincial values(13,'安徽省');
insert into provincial values(14,'福建省');
insert into provincial values(15,'江西省');
insert into provincial values(16,'山東省');
insert into provincial values(17,'河南省');
insert into provincial values(18,'湖北省');
insert into provincial values(19,'湖南省');
insert into provincial values(20,'廣東省');
insert into provincial values(21,'甘肅省');
insert into provincial values(22,'四川省');
insert into provincial values(23,'貴州省');
insert into provincial values(24,'海南省');
insert into provincial values(25,'雲南省');
insert into provincial values(26,'青海省');
insert into provincial values(27,'陝西省');
insert into provincial values(28,'廣西壯族自治區');
insert into provincial values(29,'西藏自治區');
insert into provincial values(30,'寧夏回族自治區');
insert into provincial values(31,'新疆維吾爾自治區');
insert into provincial values(32,'內蒙古自治區');
insert into provincial values(33,'澳門特別行政區');
insert into provincial values(34,'香港特別行政區');
select provincialID,provincialName from provincial;

--城市 city
create table city
(
cityID int not null,
cityName varchar(50) not null,
provincialID int not null,
primary key (cityID)
)engine=INNODB default charset=gbk; alter table city add constraint FK_pro_city_provincialID foreign key (provincialID)
references provincial (provincialID);

----------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------
--插入各個省的城市數據
--4個直轄市
insert into city values(1,'北京市',1);
insert into city values(2,'天津市',2);
insert into city values(3,'上海市',3);
insert into city values(4,'重慶市',4);
--select * from city where provincialID=4
----------------------------------------------------------------
--5河北省 11個地級市
insert into city values(5,'石家莊市',5);
insert into city values(6,'唐山市',5);
insert into city values(7,'秦皇島市',5);
insert into city values(8,'邯鄲市',5);
insert into city values(9,'邢台市',5);
insert into city values(10,'保定市',5);
insert into city values(11,'張家口市',5);
insert into city values(12,'承德市',5);
insert into city values(13,'滄州市',5);
insert into city values(14,'廊坊市',5);
insert into city values(15,'衡水市',5);
--select * from city where provincialID=5 order by cityID
----------------------------------------------------------------
--6山西省 11個城市
insert into city values(16,'太原市',6);
insert into city values(17,'大同市',6);
insert into city values(18,'陽泉市',6);
insert into city values(19,'長治市',6);
insert into city values(20,'晉城市',6);
insert into city values(21,'朔州市',6);
insert into city values(22,'晉中市',6);
insert into city values(23,'運城市',6);
insert into city values(24,'忻州市',6);
insert into city values(25,'臨汾市',6);
insert into city values(26,'呂梁市',6);
--select * from city where provincialID=6 order by cityID
----------------------------------------------------------------
--7台灣省(台灣本島和澎湖共設7市、16縣，其中台北市和高雄市為「院轄市」，直屬「行政院」，其餘屬台灣省；市下設區，縣下設市（縣轄市）、鎮、鄉，合稱區市鎮鄉。);
insert into city values(27,'台北市',7);
insert into city values(28,'高雄市',7);
insert into city values(29,'基隆市',7);
insert into city values(30,'台中市',7);
insert into city values(31,'台南市',7);
insert into city values(32,'新竹市',7);
insert into city values(33,'嘉義市',7);
insert into city values(34,'台北縣',7);
insert into city values(35,'宜蘭縣',7);
insert into city values(36,'桃園縣',7);
insert into city values(37,'新竹縣',7);
insert into city values(38,'苗栗縣',7);
insert into city values(39,'台中縣',7);
insert into city values(40,'彰化縣',7);
insert into city values(41,'南投縣',7);
insert into city values(42,'雲林縣',7);
insert into city values(43,'嘉義縣',7);
insert into city values(44,'台南縣',7);
insert into city values(45,'高雄縣',7);
insert into city values(46,'屏東縣',7);
insert into city values(47,'澎湖縣',7);
insert into city values(48,'台東縣',7);
insert into city values(49,'花蓮縣',7);
--select * from city where provincialID=7 order by cityID
----------------------------------------------------------------
--8遼寧省 14個地級市
insert into city values(50,'沈陽市',8);
insert into city values(51,'大連市',8);
insert into city values(52,'鞍山市',8);
insert into city values(53,'撫順市',8);
insert into city values(54,'本溪市',8);
insert into city values(55,'丹東市',8);
insert into city values(56,'錦州市',8);
insert into city values(57,'營口市',8);
insert into city values(58,'阜新市',8);
insert into city values(59,'遼陽市',8);
insert into city values(60,'盤錦市',8);
insert into city values(61,'鐵嶺市',8);
insert into city values(62,'朝陽市',8);
insert into city values(63,'葫蘆島市',8);
--select * from city where provincialID=8 order by cityID
----------------------------------------------------------------
--9吉林省(2006年，轄：8個地級市、1個自治州；20個市轄區、20個縣級市、17個縣、3個自治縣。);
insert into city values(64,'長春市',9);
insert into city values(65,'吉林市',9);
insert into city values(66,'四平市',9);
insert into city values(67,'遼源市',9);
insert into city values(68,'通化市',9);
insert into city values(69,'白山市',9);
insert into city values(70,'松原市',9);
insert into city values(71,'白城市',9);
insert into city values(72,'延邊朝鮮族自治州',9);
--select * from city where provincialID=9 order by cityID
----------------------------------------------------------------
--10黑龍江省(2006年，轄：12地級市、1地區；64市轄區、18縣級市、45縣、1自治縣);
insert into city values(73,'哈爾濱市',10);
insert into city values(74,'齊齊哈爾市',10);
insert into city values(75,'鶴 崗 市',10);
insert into city values(76,'雙鴨山市',10);
insert into city values(77,'雞 西 市',10);
insert into city values(78,'大 慶 市',10);
insert into city values(79,'伊 春 市',10);
insert into city values(80,'牡丹江市',10);
insert into city values(81,'佳木斯市',10);
insert into city values(82,'七台河市',10);
insert into city values(83,'黑 河 市',10);
insert into city values(84,'綏 化 市',10);
insert into city values(85,'大興安嶺地區',10);
--select * from city where provincialID=10 order by cityID
----------------------------------------------------------------
--11江蘇省(2005年轄：13個地級市；54個市轄區、27個縣級市、25個縣);
insert into city values(86,'南京市',11);
insert into city values(87,'無錫市',11);
insert into city values(88,'徐州市',11);
insert into city values(89,'常州市',11);
insert into city values(90,'蘇州市',11);
insert into city values(91,'南通市',11);
insert into city values(92,'連雲港市',11);
insert into city values(93,'淮安市',11);
insert into city values(94,'鹽城市',11);
insert into city values(95,'揚州市',11);
insert into city values(96,'鎮江市',11);
insert into city values(97,'泰州市',11);
insert into city values(98,'宿遷市',11);
--select * from city where provincialID=11 order by cityID
----------------------------------------------------------------
--12浙江省(2006年，轄：11個地級市；32個市轄區、22個縣級市、35個縣、1個自治縣。);
insert into city values(99,'杭州市',12);
insert into city values(100,'寧波市',12);
insert into city values(101,'溫州市',12);
insert into city values(102,'嘉興市',12);
insert into city values(103,'湖州市',12);
insert into city values(104,'紹興市',12);
insert into city values(105,'金華市',12);
insert into city values(106,'衢州市',12);
insert into city values(107,'舟山市',12);
insert into city values(108,'台州市',12);
insert into city values(109,'麗水市',12);
--select * from city where provincialID=12 order by cityID
---------------------------------------------------------------- 沒有寫完, 寫不下了,你加我! 775790318

Ⅶ 省市區級聯到後,把省市區添加到資料庫,如何更改資料庫中的省市區 .net

在資料庫表中添加一行ParentId，來區分省和市，比如省的parentId就是0，市的parentId就是相應省的主鍵Id

Ⅷ 求一個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_