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个