国省州市县四级关联表

来源：互联网发布：手机淘宝怎么定时上架编辑：程序博客网时间：2024/05/17 07:26

把国家省市县再补充一下澳门和台湾的行政划分。

现成表：Area_SQL.sql

update Area setArea_ID=100820100,Title='澳门',PID=100820000,Sort=1,Content='澳门澳门'where Area_ID=100820001;

delete from Area whereArea_ID=100820002;

insert into Areavalues(100820200,'离岛',100820000,2,'澳门离岛',NULL);

insert into Areavalues(100820201,'氹仔',100820200,1,'澳门离岛氹仔',NULL);

insert into Areavalues(100820202,'路环',100820200,2,'澳门离岛路环',NULL);

insert into Areavalues(100820203,'路氹',100820200,3,'澳门离岛路氹',NULL);

insert into Areavalues(100820101,'花地玛堂区',100820100,1,'澳门澳门花地玛堂区',NULL);

insert into Areavalues(100820102,'圣安多尼堂区',100820100,2,'澳门澳门圣安多尼堂区',NULL);

insert into Areavalues(100820103,'大堂区',100820100,3,'澳门澳门大堂区',NULL);

insert into Areavalues(100820104,'望德堂区',100820100,4,'澳门澳门望德堂区',NULL);

insert into Areavalues(100820105,'风顺堂区',100820100,5,'澳门澳门风顺堂区',NULL);

update Area setArea_ID=100710100,Title='台北市',PID=100710000,Sort=1,Content='台湾省台北市' where Area_ID=100710001;

update Area setArea_ID=100710200,Title='高雄市',PID=100710000,Sort=2,Content='台湾省高雄市' where Area_ID=100710002;

update Area setArea_ID=100710300,Title='基隆市',PID=100710000,Sort=3,Content='台湾省基隆市' where Area_ID=100710003;

update Area setArea_ID=100710400,Title='台中市',PID=100710000,Sort=4,Content='台湾省台中市' where Area_ID=100710004;

insert into Areavalues(100710500,'台南市',100710000,5,'台湾省台南市',NULL);

insert into Areavalues(100710600,'新竹市',100710000,6,'台湾省新竹市',NULL);

insert into Areavalues(100710700,'嘉义市',100710000,7,'台湾省嘉义市',NULL);

insert into Areavalues(100710800,'台北县',100710000,8,'台湾省台北县',NULL);

insert into Areavalues(100710900,'宜兰县',100710000,9,'台湾省宜兰县',NULL);

insert into Areavalues(100711000,'新竹县',100710000,10,'台湾省新竹县',NULL);

insert into Areavalues(100711100,'桃园县',100710000,11,'台湾省桃园县',NULL);

insert into Areavalues(100711200,'苗栗县',100710000,12,'湾省苗栗县',NULL);

insert into Areavalues(100711300,'台中县',100710000,13,'湾省台中县',NULL);

insert into Areavalues(100711400,'彰化县',100710000,14,'台湾省彰化县',NULL);

insert into Areavalues(100711500,'南投县',100710000,15,'台湾省南投县',NULL);

insert into Areavalues(100711600,'嘉义县',100710000,16,'台湾省嘉义县',NULL);

insert into Areavalues(100711700,'云林县',100710000,17,'台湾省云林县',NULL);

insert into Areavalues(100711800,'台南县',100710000,18,'台湾省台南县',NULL);

insert into Areavalues(100711900,'高雄县',100710000,19,'台湾省高雄县',NULL);

insert into Areavalues(100712000,'屏东县',100710000,20,'台湾省屏东县',NULL);

insert into Areavalues(100712100,'台东县',100710000,21,'台湾省台东县',NULL);

insert into Areavalues(100712200,'花莲县',100710000,22,'台湾省花莲县',NULL);

insert into Areavalues(100712300,'澎湖县',100710000,23,'台湾省澎湖县',NULL);

参考网址：台湾省行政区划，澳门特别行政区

完了之后，老板说这样是不行的，台湾怎么这么简单？

于是，照着《台湾省行政区划分》弄吧，我的天，要命，这是一个省- -

不过程序员就是简化工作流程的，写代码吧。。。如下：

#!-*- coding:utf8 -*-

#获取台湾省市县的行政划分

#补充台中市区行政划分

taizhong_q = """

insert into Area values(100710401,'中区',100710400,'台湾省台中市中区',1,NULL);

insert into Area values(100710402,'东区',100710400,'台湾省台中市中区',2,NULL);

insert into Area values(100710403,'西区',100710400,'台湾省台中市中区',3,NULL);

insert into Area values(100710404,'南区',100710400,'台湾省台中市中区',4,NULL);

insert into Area values(100710405,'北区',100710400,'台湾省台中市中区',5,NULL);

insert into Area values(100710406,'西屯区',100710400,'台湾省台中市中区',6,NULL);

insert into Area values(100710407,'南屯区',100710400,'台湾省台中市中区',7,NULL);

insert into Area values(100710408,'北屯区',100710400,'台湾省台中市中区',8,NULL);

"""

import urllib2

import re

s = """

100710100 台北市

100710200 高雄市

100710300 基隆市

100710400 台中市

100710500 台南市

100710600 新竹市

100710700 嘉义市

100710800 台北县

100710900 宜兰县

100711000 新竹县

100711100 桃园县

100711200 苗栗县

100711300 台中县

100711400 彰化县

100711500 南投县

100711600 嘉义县

100711700 云林县

100711800 台南县

100711900 高雄县

100712000 屏东县

100712100 台东县

100712200 花莲县

100712300 澎湖县"""

l = s.splitlines()

for i in l:

lr = i.split('')

n_1 = lr[2]

i_1 =int(lr[0])

url ='http://www.baike.com/wiki/' +n_1.decode('raw_unicode_escape').encode('unicode_escape').replace('\\','%').replace('x','').upper()

#print url

u =urllib2.urlopen(url)

r =u.read()

withfile('result.html','w')as f:

f.write(r)

rl =re.findall(r'strong>下辖.+?span(.+?)span',r,re.S)

ifrl:rl=rl[0]

else:continue

rls =re.findall(r'href="(.+?)".+?>(.+?)',rl,re.S)

i_2 = 0

for i inrls:

i_2 += 1

#url ='http://www.baike.com/wiki/'+rls[0][1].decode('raw_unicode_escape').encode('unicode_escape').replace('\\','%').replace('x','').upper()

#url = i[0]

name = i[1]

i_1 += 1

#insert into Areavalues(100710800,'台北县',100710000,8,'台湾省台北县',NULL);

print "insert into Areavalues(%s,'%s',%s,'%s',%s,NULL);" % (i_1,name,lr[0],'台湾省 %s%s'%(n_1,name),i_2)

print taizhong_q

结果：

insert into Areavalues(100710101,'中正区',100710100,'台湾省台北市中正区',1,NULL);

insert into Areavalues(100710102,'万华区',100710100,'台湾省台北市万华区',2,NULL);

insert into Areavalues(100710103,'大同区',100710100,'台湾省台北市大同区',3,NULL);

insert into Areavalues(100710104,'中山区',100710100,'台湾省台北市中山区',4,NULL);

insert into Areavalues(100710105,'松山区',100710100,'台湾省台北市松山区',5,NULL);

insert into Areavalues(100710106,'大安区',100710100,'台湾省台北市大安区',6,NULL);

insert into Areavalues(100710107,'信义区',100710100,'台湾省台北市信义区',7,NULL);

insert into Areavalues(100710108,'内湖区',100710100,'台湾省台北市内湖区',8,NULL);

insert into Areavalues(100710109,'南港区',100710100,'台湾省台北市南港区',9,NULL);

insert into Areavalues(100710110,'士林区',100710100,'台湾省台北市士林区',10,NULL);

insert into Areavalues(100710111,'北投区',100710100,'台湾省台北市北投区',11,NULL);

insert into Areavalues(100710112,'文山区',100710100,'台湾省台北市文山区',12,NULL);

insert into Areavalues(100710201,'盐埕区',100710200,'台湾省高雄市盐埕区',1,NULL);

insert into Areavalues(100710202,'鼓山区',100710200,'台湾省高雄市鼓山区',2,NULL);

insert into Areavalues(100710203,'左营区',100710200,'台湾省高雄市左营区',3,NULL);

insert into Areavalues(100710204,'楠梓区',100710200,'台湾省高雄市楠梓区',4,NULL);

insert into Areavalues(100710205,'三民区',100710200,'台湾省高雄市三民区',5,NULL);

insert into Areavalues(100710206,'新兴区',100710200,'台湾省高雄市新兴区',6,NULL);

insert into Areavalues(100710207,'前金区',100710200,'台湾省高雄市前金区',7,NULL);

insert into Areavalues(100710208,'连雅区',100710200,'台湾省高雄市连雅区',8,NULL);

insert into Areavalues(100710209,'前镇区',100710200,'台湾省高雄市前镇区',9,NULL);

insert into Areavalues(100710210,'旗津区',100710200,'台湾省高雄市旗津区',10,NULL);

insert into Areavalues(100710301,'中正区',100710300,'台湾省基隆市中正区',1,NULL);

insert into Areavalues(100710302,'信义区',100710300,'台湾省基隆市信义区',2,NULL);

insert into Areavalues(100710303,'仁爱区',100710300,'台湾省基隆市仁爱区',3,NULL);

insert into Areavalues(100710304,'中山区',100710300,'台湾省基隆市中山区',4,NULL);

insert into Areavalues(100710305,'安乐区',100710300,'台湾省基隆市安乐区',5,NULL);

insert into Areavalues(100710306,'暖暖区',100710300,'台湾省基隆市暖暖区',6,NULL);

insert into Areavalues(100710307,'七堵区',100710300,'台湾省基隆市七堵区',7,NULL);

insert into Areavalues(100710501,'中西区',100710500,'台湾省台南市中西区',1,NULL);

insert into Areavalues(100710502,'东区',100710500,'台湾省台南市东区',2,NULL);

insert into Areavalues(100710503,'南区',100710500,'台湾省台南市南区',3,NULL);

insert into Areavalues(100710504,'北区',100710500,'台湾省台南市北区',4,NULL);

insert into Areavalues(100710505,'安平区',100710500,'台湾省台南市安平区',5,NULL);

insert into Areavalues(100710506,'安南区',100710500,'台湾省台南市安南区',6,NULL);

insert into Areavalues(100710601,'东区',100710600,'台湾省新竹市东区',1,NULL);

insert into Areavalues(100710602,'北区',100710600,'台湾省新竹市北区',2,NULL);

insert into Areavalues(100710603,'香山区',100710600,'台湾省新竹市香山区',3,NULL);

insert into Areavalues(100710701,'东区',100710700,'台湾省嘉义市东区',1,NULL);

insert into Areavalues(100710702,'西区',100710700,'台湾省嘉义市西区',2,NULL);

insert into Areavalues(100710801,'板桥市',100710800,'台湾省台北县板桥市',1,NULL);

insert into Areavalues(100710802,'汐止市',100710800,'台湾省台北县汐止市',2,NULL);

insert into Areavalues(100710803,'新店市',100710800,'台湾省台北县新店市',3,NULL);

insert into Areavalues(100710804,'永和市',100710800,'台湾省台北县永和市',4,NULL);

insert into Areavalues(100710805,'中和市',100710800,'台湾省台北县中和市',5,NULL);

insert into Areavalues(100710806,'土城市',100710800,'台湾省台北县土城市',6,NULL);

insert into Areavalues(100710807,'树林市',100710800,'台湾省台北县树林市',7,NULL);

insert into Areavalues(100710808,'三重市',100710800,'台湾省台北县三重市',8,NULL);

insert into Areavalues(100710809,'新庄市',100710800,'台湾省台北县新庄市',9,NULL);

insert into Areavalues(100710810,'芦洲市',100710800,'台湾省台北县芦洲市',10,NULL);

insert into Areavalues(100710811,'瑞芳镇',100710800,'台湾省台北县瑞芳镇',11,NULL);

insert into Areavalues(100710812,'三峡镇',100710800,'台湾省台北县三峡镇',12,NULL);

insert into Areavalues(100710813,'莺歌镇',100710800,'台湾省台北县莺歌镇',13,NULL);

insert into Areavalues(100710814,'淡水镇',100710800,'台湾省台北县淡水镇',14,NULL);

insert into Areavalues(100710815,'万里乡',100710800,'台湾省台北县万里乡',15,NULL);

insert into Areavalues(100710816,'金山乡',100710800,'台湾省台北县金山乡',16,NULL);

insert into Areavalues(100710817,'深坑乡',100710800,'台湾省台北县深坑乡',17,NULL);

insert into Areavalues(100710818,'石碇乡',100710800,'台湾省台北县石碇乡',18,NULL);

insert into Areavalues(100710819,'平溪乡',100710800,'台湾省台北县平溪乡',19,NULL);

insert into Areavalues(100710820,'双溪乡',100710800,'台湾省台北县双溪乡',20,NULL);

insert into Areavalues(100710821,'贡寮乡',100710800,'台湾省台北县贡寮乡',21,NULL);

insert into Areavalues(100710822,'坪林乡',100710800,'台湾省台北县坪林乡',22,NULL);

insert into Areavalues(100710823,'乌来乡',100710800,'台湾省台北县乌来乡',23,NULL);

insert into Areavalues(100710824,'泰山乡',100710800,'台湾省台北县泰山乡',24,NULL);

insert into Areavalues(100710825,'林口乡',100710800,'台湾省台北县林口乡',25,NULL);

insert into Areavalues(100710826,'五股乡',100710800,'台湾省台北县五股乡',26,NULL);

insert into Areavalues(100710827,'八里乡',100710800,'台湾省台北县八里乡',27,NULL);

insert into Areavalues(100710828,'三芝乡',100710800,'台湾省台北县三芝乡',28,NULL);

insert into Areavalues(100710829,'石门乡',100710800,'台湾省台北县石门乡',29,NULL);

insert into Areavalues(100710901,'宜兰市',100710900,'台湾省宜兰县宜兰市',1,NULL);

insert into Areavalues(100710902,'头城镇',100710900,'台湾省宜兰县头城镇',2,NULL);

insert into Areavalues(100710903,'罗东镇',100710900,'台湾省宜兰县罗东镇',3,NULL);

insert into Areavalues(100710904,'苏澳镇',100710900,'台湾省宜兰县苏澳镇',4,NULL);

insert into Areavalues(100710905,'礁溪乡',100710900,'台湾省宜兰县礁溪乡',5,NULL);

insert into Areavalues(100710906,'壮围乡',100710900,'台湾省宜兰县壮围乡',6,NULL);

insert into Areavalues(100710907,'员山乡',100710900,'台湾省宜兰县员山乡',7,NULL);

insert into Areavalues(100710908,'三星乡',100710900,'台湾省宜兰县三星乡',8,NULL);

insert into Areavalues(100710909,'大同乡',100710900,'台湾省宜兰县大同乡',9,NULL);

insert into Areavalues(100710910,'五结乡',100710900,'台湾省宜兰县五结乡',10,NULL);

insert into Areavalues(100710911,'冬山乡',100710900,'台湾省宜兰县冬山乡',11,NULL);

insert into Areavalues(100710912,'南澳乡',100710900,'台湾省宜兰县南澳乡',12,NULL);

insert into Areavalues(100711001,'竹北市',100711000,'台湾省新竹县竹北市',1,NULL);

insert into Areavalues(100711002,'新埔镇',100711000,'台湾省新竹县新埔镇',2,NULL);

insert into Areavalues(100711003,'关西镇',100711000,'台湾省新竹县关西镇',3,NULL);

insert into Areavalues(100711004,'竹东镇',100711000,'台湾省新竹县竹东镇',4,NULL);

insert into Areavalues(100711005,'湖口乡',100711000,'台湾省新竹县湖口乡',5,NULL);

insert into Areavalues(100711006,'新丰乡',100711000,'台湾省新竹县新丰乡',6,NULL);

insert into Areavalues(100711007,'芎林乡',100711000,'台湾省新竹县芎林乡',7,NULL);

insert into Areavalues(100711008,'宝山乡',100711000,'台湾省新竹县宝山乡',8,NULL);

insert into Areavalues(100711009,'五峰乡',100711000,'台湾省新竹县五峰乡',9,NULL);

insert into Areavalues(100711010,'横山乡',100711000,'台湾省新竹县横山乡',10,NULL);

insert into Areavalues(100711011,'尖石乡',100711000,'台湾省新竹县尖石乡',11,NULL);

insert into Areavalues(100711012,'北埔乡',100711000,'台湾省新竹县北埔乡',12,NULL);

insert into Areavalues(100711013,'峨眉乡',100711000,'台湾省新竹县峨眉乡',13,NULL);

insert into Areavalues(100711101,'桃园市',100711100,'台湾省桃园县桃园市',1,NULL);

insert into Areavalues(100711102,'中坜市',100711100,'台湾省桃园县中坜市',2,NULL);

insert into Areavalues(100711103,'平镇市',100711100,'台湾省桃园县平镇市',3,NULL);

insert into Areavalues(100711104,'八德市',100711100,'台湾省桃园县八德市',4,NULL);

insert into Areavalues(100711105,'杨梅镇',100711100,'台湾省桃园县杨梅镇',5,NULL);

insert into Areavalues(100711106,'大溪镇',100711100,'台湾省桃园县大溪镇',6,NULL);

insert into Areavalues(100711107,'龙潭乡',100711100,'台湾省桃园县龙潭乡',7,NULL);

insert into Areavalues(100711108,'新屋乡',100711100,'台湾省桃园县新屋乡',8,NULL);

insert into Areavalues(100711109,'观音乡',100711100,'台湾省桃园县观音乡',9,NULL);

insert into Areavalues(100711110,'龟山乡',100711100,'台湾省桃园县龟山乡',10,NULL);

insert into Areavalues(100711111,'复兴乡',100711100,'台湾省桃园县复兴乡',11,NULL);

insert into Areavalues(100711112,'大园乡',100711100,'台湾省桃园县大园乡',12,NULL);

insert into Areavalues(100711113,'芦竹乡',100711100,'台湾省桃园县芦竹乡',13,NULL);

insert into Areavalues(100711201,'苗栗市',100711200,'台湾省苗栗县苗栗市',1,NULL);

insert into Areavalues(100711202,'竹南镇',100711200,'台湾省苗栗县竹南镇',2,NULL);

insert into Areavalues(100711203,'头份镇',100711200,'台湾省苗栗县头份镇',3,NULL);

insert into Areavalues(100711204,'后龙镇',100711200,'台湾省苗栗县后龙镇',4,NULL);

insert into Areavalues(100711205,'通霄镇',100711200,'台湾省苗栗县通霄镇',5,NULL);

insert into Areavalues(100711206,'苑裡镇',100711200,'台湾省苗栗县苑裡镇',6,NULL);

insert into Areavalues(100711207,'卓兰镇',100711200,'台湾省苗栗县卓兰镇',7,NULL);

insert into Areavalues(100711208,'三湾乡',100711200,'台湾省苗栗县三湾乡',8,NULL);

insert into Areavalues(100711209,'南庄乡',100711200,'台湾省苗栗县南庄乡',9,NULL);

insert into Areavalues(100711210,'狮潭乡',100711200,'台湾省苗栗县狮潭乡',10,NULL);

insert into Areavalues(100711211,'造桥乡',100711200,'台湾省苗栗县造桥乡',11,NULL);

insert into Areavalues(100711212,'头屋乡',100711200,'台湾省苗栗县头屋乡',12,NULL);

insert into Areavalues(100711213,'公馆乡',100711200,'台湾省苗栗县公馆乡',13,NULL);

insert into Areavalues(100711214,'大湖乡',100711200,'台湾省苗栗县大湖乡',14,NULL);

insert into Areavalues(100711215,'泰安乡',100711200,'台湾省苗栗县泰安乡',15,NULL);

insert into Areavalues(100711216,'铜锣乡',100711200,'台湾省苗栗县铜锣乡',16,NULL);

insert into Areavalues(100711217,'三义乡',100711200,'台湾省苗栗县三义乡',17,NULL);

insert into Areavalues(100711218,'西湖乡',100711200,'台湾省苗栗县西湖乡',18,NULL);

insert into Areavalues(100711301,'丰原市',100711300,'台湾省台中县丰原市',1,NULL);

insert into Areavalues(100711302,'太平市',100711300,'台湾省台中县太平市',2,NULL);

insert into Areavalues(100711303,'大里市',100711300,'台湾省台中县大里市',3,NULL);

insert into Areavalues(100711304,'东势镇',100711300,'台湾省台中县东势镇',4,NULL);

insert into Areavalues(100711305,'沙鹿镇',100711300,'台湾省台中县沙鹿镇',5,NULL);

insert into Areavalues(100711306,'梧栖镇',100711300,'台湾省台中县梧栖镇',6,NULL);

insert into Areavalues(100711307,'清水镇',100711300,'台湾省台中县清水镇',7,NULL);

insert into Areavalues(100711308,'大甲镇',100711300,'台湾省台中县大甲镇',8,NULL);

insert into Areavalues(100711309,'雾峰乡',100711300,'台湾省台中县雾峰乡',9,NULL);

insert into Areavalues(100711310,'乌日乡',100711300,'台湾省台中县乌日乡',10,NULL);

insert into Areavalues(100711311,'后里乡',100711300,'台湾省台中县后里乡',11,NULL);

insert into Areavalues(100711312,'石冈乡',100711300,'台湾省台中县石冈乡',12,NULL);

insert into Areavalues(100711313,'和平乡',100711300,'台湾省台中县和平乡',13,NULL);

insert into Areavalues(100711314,'新社乡',100711300,'台湾省台中县新社乡',14,NULL);

insert into Areavalues(100711315,'潭子乡',100711300,'台湾省台中县潭子乡',15,NULL);

insert into Areavalues(100711316,'大雅乡',100711300,'台湾省台中县大雅乡',16,NULL);

insert into Areavalues(100711317,'神冈乡',100711300,'台湾省台中县神冈乡',17,NULL);

insert into Areavalues(100711318,'大肚乡',100711300,'台湾省台中县大肚乡',18,NULL);

insert into Areavalues(100711319,'龙井乡',100711300,'台湾省台中县龙井乡',19,NULL);

insert into Areavalues(100711320,'外埔乡',100711300,'台湾省台中县外埔乡',20,NULL);

insert into Areavalues(100711321,'大安乡',100711300,'台湾省台中县大安乡',21,NULL);

insert into Areavalues(100711401,'彰化市',100711400,'台湾省彰化县彰化市',1,NULL);

insert into Areavalues(100711402,'鹿港镇',100711400,'台湾省彰化县鹿港镇',2,NULL);

insert into Areavalues(100711403,'和美镇',100711400,'台湾省彰化县和美镇',3,NULL);

insert into Areavalues(100711404,'员林镇',100711400,'台湾省彰化县员林镇',4,NULL);

insert into Areavalues(100711405,'溪湖镇',100711400,'台湾省彰化县溪湖镇',5,NULL);

insert into Areavalues(100711406,'田中镇',100711400,'台湾省彰化县田中镇',6,NULL);

insert into Areavalues(100711407,'北斗镇',100711400,'台湾省彰化县北斗镇',7,NULL);

insert into Areavalues(100711408,'二林镇',100711400,'台湾省彰化县二林镇',8,NULL);

insert into Areavalues(100711409,'芬园乡',100711400,'台湾省彰化县芬园乡',9,NULL);

insert into Areavalues(100711410,'花坛乡',100711400,'台湾省彰化县花坛乡',10,NULL);

insert into Areavalues(100711411,'秀水乡',100711400,'台湾省彰化县秀水乡',11,NULL);

insert into Areavalues(100711412,'福兴乡',100711400,'台湾省彰化县福兴乡',12,NULL);

insert into Areavalues(100711413,'线西乡',100711400,'台湾省彰化县线西乡',13,NULL);

insert into Areavalues(100711414,'伸港乡',100711400,'台湾省彰化县伸港乡',14,NULL);

insert into Areavalues(100711415,'社头乡',100711400,'台湾省彰化县社头乡',15,NULL);

insert into Areavalues(100711416,'永靖乡',100711400,'台湾省彰化县永靖乡',16,NULL);

insert into Areavalues(100711417,'埔心乡',100711400,'台湾省彰化县埔心乡',17,NULL);

insert into Areavalues(100711418,'大村乡',100711400,'台湾省彰化县大村乡',18,NULL);

insert into Areavalues(100711419,'埔盐乡',100711400,'台湾省彰化县埔盐乡',19,NULL);

insert into Areavalues(100711420,'田尾乡',100711400,'台湾省彰化县田尾乡',20,NULL);

insert into Areavalues(100711421,'埤头乡',100711400,'台湾省彰化县埤头乡',21,NULL);

insert into Areavalues(100711422,'溪州乡',100711400,'台湾省彰化县溪州乡',22,NULL);

insert into Areavalues(100711423,'竹塘乡',100711400,'台湾省彰化县竹塘乡',23,NULL);

insert into Areavalues(100711424,'大城乡',100711400,'台湾省彰化县大城乡',24,NULL);

insert into Areavalues(100711425,'芳苑乡',100711400,'台湾省彰化县芳苑乡',25,NULL);

insert into Areavalues(100711426,'二水乡',100711400,'台湾省彰化县二水乡',26,NULL);

insert into Areavalues(100711501,'南投市',100711500,'台湾省南投县南投市',1,NULL);

insert into Areavalues(100711502,'草屯镇',100711500,'台湾省南投县草屯镇',2,NULL);

insert into Areavalues(100711503,'埔里镇',100711500,'台湾省南投县埔里镇',3,NULL);

insert into Areavalues(100711504,'集集镇',100711500,'台湾省南投县集集镇',4,NULL);

insert into Areavalues(100711505,'竹山镇',100711500,'台湾省南投县竹山镇',5,NULL);

insert into Areavalues(100711506,'中寮乡',100711500,'台湾省南投县中寮乡',6,NULL);

insert into Areavalues(100711507,'国姓乡',100711500,'台湾省南投县国姓乡',7,NULL);

insert into Areavalues(100711508,'仁爱乡',100711500,'台湾省南投县仁爱乡',8,NULL);

insert into Areavalues(100711509,'名间乡',100711500,'台湾省南投县名间乡',9,NULL);

insert into Areavalues(100711510,'水里乡',100711500,'台湾省南投县水里乡',10,NULL);

insert into Areavalues(100711511,'鱼池乡',100711500,'台湾省南投县鱼池乡',11,NULL);

insert into Areavalues(100711512,'信义乡',100711500,'台湾省南投县信义乡',12,NULL);

insert into Areavalues(100711513,'鹿谷乡',100711500,'台湾省南投县鹿谷乡',13,NULL);

insert into Areavalues(100711601,'太保市',100711600,'台湾省嘉义县太保市',1,NULL);

insert into Areavalues(100711602,'朴子市',100711600,'台湾省嘉义县朴子市',2,NULL);

insert into Areavalues(100711603,'大林镇',100711600,'台湾省嘉义县大林镇',3,NULL);

insert into Areavalues(100711604,'布袋镇',100711600,'台湾省嘉义县布袋镇',4,NULL);

insert into Areavalues(100711605,'番路乡',100711600,'台湾省嘉义县番路乡',5,NULL);

insert into Areavalues(100711606,'梅山乡',100711600,'台湾省嘉义县梅山乡',6,NULL);

insert into Areavalues(100711607,'竹崎乡',100711600,'台湾省嘉义县竹崎乡',7,NULL);

insert into Areavalues(100711608,'阿里山乡',100711600,'台湾省嘉义县阿里山乡',8,NULL);

insert into Areavalues(100711609,'中埔乡',100711600,'台湾省嘉义县中埔乡',9,NULL);

insert into Areavalues(100711610,'大埔乡',100711600,'台湾省嘉义县大埔乡',10,NULL);

insert into Areavalues(100711611,'水上乡',100711600,'台湾省嘉义县水上乡',11,NULL);

insert into Areavalues(100711612,'鹿草乡',100711600,'台湾省嘉义县鹿草乡',12,NULL);

insert into Areavalues(100711613,'东石乡',100711600,'台湾省嘉义县东石乡',13,NULL);

insert into Areavalues(100711614,'六脚乡',100711600,'台湾省嘉义县六脚乡',14,NULL);

insert into Areavalues(100711615,'新港乡',100711600,'台湾省嘉义县新港乡',15,NULL);

insert into Areavalues(100711616,'民雄乡',100711600,'台湾省嘉义县民雄乡',16,NULL);

insert into Areavalues(100711617,'溪口乡',100711600,'台湾省嘉义县溪口乡',17,NULL);

insert into Areavalues(100711618,'义竹乡',100711600,'台湾省嘉义县义竹乡',18,NULL);

insert into Areavalues(100711701,'斗六市',100711700,'台湾省云林县斗六市',1,NULL);

insert into Areavalues(100711702,'斗南镇',100711700,'台湾省云林县斗南镇',2,NULL);

insert into Areavalues(100711703,'虎尾镇',100711700,'台湾省云林县虎尾镇',3,NULL);

insert into Areavalues(100711704,'土库镇',100711700,'台湾省云林县土库镇',4,NULL);

insert into Areavalues(100711705,'西螺镇',100711700,'台湾省云林县西螺镇',5,NULL);

insert into Areavalues(100711706,'北港镇',100711700,'台湾省云林县北港镇',6,NULL);

insert into Areavalues(100711707,'大埤乡',100711700,'台湾省云林县大埤乡',7,NULL);

insert into Areavalues(100711708,'褒忠乡',100711700,'台湾省云林县褒忠乡',8,NULL);

insert into Areavalues(100711709,'东势乡',100711700,'台湾省云林县东势乡',9,NULL);

insert into Areavalues(100711710,'台西乡',100711700,'台湾省云林县台西乡',10,NULL);

insert into Areavalues(100711711,'崙背乡',100711700,'台湾省云林县崙背乡',11,NULL);

insert into Areavalues(100711712,'麦寮乡',100711700,'台湾省云林县麦寮乡',12,NULL);

insert into Areavalues(100711713,'林内乡',100711700,'台湾省云林县林内乡',13,NULL);

insert into Areavalues(100711714,'古坑乡',100711700,'台湾省云林县古坑乡',14,NULL);

insert into Areavalues(100711715,'莿桐乡',100711700,'台湾省云林县莿桐乡',15,NULL);

insert into Areavalues(100711716,'二崙乡',100711700,'台湾省云林县二崙乡',16,NULL);

insert into Areavalues(100711717,'水林乡',100711700,'台湾省云林县水林乡',17,NULL);

insert into Areavalues(100711718,'口湖乡',100711700,'台湾省云林县口湖乡',18,NULL);

insert into Areavalues(100711719,'四湖乡',100711700,'台湾省云林县四湖乡',19,NULL);

insert into Areavalues(100711720,'元长乡',100711700,'台湾省云林县元长乡',20,NULL);

insert into Areavalues(100711801,'新营市',100711800,'台湾省台南县新营市',1,NULL);

insert into Areavalues(100711802,'永康市',100711800,'台湾省台南县永康市',2,NULL);

insert into Areavalues(100711803,'新化镇',100711800,'台湾省台南县新化镇',3,NULL);

insert into Areavalues(100711804,'麻豆镇',100711800,'台湾省台南县麻豆镇',4,NULL);

insert into Areavalues(100711805,'佳里镇',100711800,'台湾省台南县佳里镇',5,NULL);

insert into Areavalues(100711806,'学甲镇',100711800,'台湾省台南县学甲镇',6,NULL);

insert into Areavalues(100711807,'白河镇',100711800,'台湾省台南县白河镇',7,NULL);

insert into Areavalues(100711808,'盐水镇',100711800,'台湾省台南县盐水镇',8,NULL);

insert into Areavalues(100711809,'善化镇',100711800,'台湾省台南县善化镇',9,NULL);

insert into Areavalues(100711810,'归仁乡',100711800,'台湾省台南县归仁乡',10,NULL);

insert into Areavalues(100711811,'左镇乡',100711800,'台湾省台南县左镇乡',11,NULL);

insert into Areavalues(100711812,'玉井乡',100711800,'台湾省台南县玉井乡',12,NULL);

insert into Areavalues(100711813,'楠西乡',100711800,'台湾省台南县楠西乡',13,NULL);

insert into Areavalues(100711814,'南化乡',100711800,'台湾省台南县南化乡',14,NULL);

insert into Areavalues(100711815,'仁德乡',100711800,'台湾省台南县仁德乡',15,NULL);

insert into Areavalues(100711816,'关庙乡',100711800,'台湾省台南县关庙乡',16,NULL);

insert into Areavalues(100711817,'龙崎乡',100711800,'台湾省台南县龙崎乡',17,NULL);

insert into Areavalues(100711818,'官田乡',100711800,'台湾省台南县官田乡',18,NULL);

insert into Areavalues(100711819,'西港乡',100711800,'台湾省台南县西港乡',19,NULL);

insert into Areavalues(100711820,'七股乡',100711800,'台湾省台南县七股乡',20,NULL);

insert into Areavalues(100711821,'将军乡',100711800,'台湾省台南县将军乡',21,NULL);

insert into Areavalues(100711822,'北门乡',100711800,'台湾省台南县北门乡',22,NULL);

insert into Areavalues(100711823,'後壁乡',100711800,'台湾省台南县後壁乡',23,NULL);

insert into Areavalues(100711824,'东山乡',100711800,'台湾省台南县东山乡',24,NULL);

insert into Areavalues(100711825,'六甲乡',100711800,'台湾省台南县六甲乡',25,NULL);

insert into Areavalues(100711826,'下营乡',100711800,'台湾省台南县下营乡',26,NULL);

insert into Areavalues(100711827,'柳营乡',100711800,'台湾省台南县柳营乡',27,NULL);

insert into Areavalues(100711828,'大内乡',100711800,'台湾省台南县大内乡',28,NULL);

insert into Areavalues(100711829,'山上乡',100711800,'台湾省台南县山上乡',29,NULL);

insert into Areavalues(100711830,'新市乡',100711800,'台湾省台南县新市乡',30,NULL);

insert into Areavalues(100711831,'安定乡',100711800,'台湾省台南县安定乡',31,NULL);

insert into Areavalues(100711901,'凤山市',100711900,'台湾省高雄县凤山市',1,NULL);

insert into Areavalues(100711902,'冈山镇',100711900,'台湾省高雄县冈山镇',2,NULL);

insert into Areavalues(100711903,'旗山镇',100711900,'台湾省高雄县旗山镇',3,NULL);

insert into Areavalues(100711904,'美浓镇',100711900,'台湾省高雄县美浓镇',4,NULL);

insert into Areavalues(100711905,'仁武乡',100711900,'台湾省高雄县仁武乡',5,NULL);

insert into Areavalues(100711906,'大社乡',100711900,'台湾省高雄县大社乡',6,NULL);

insert into Areavalues(100711907,'路竹乡',100711900,'台湾省高雄县路竹乡',7,NULL);

insert into Areavalues(100711908,'阿莲乡',100711900,'台湾省高雄县阿莲乡',8,NULL);

insert into Areavalues(100711909,'田寮乡',100711900,'台湾省高雄县田寮乡',9,NULL);

insert into Areavalues(100711910,'燕巢乡',100711900,'台湾省高雄县燕巢乡',10,NULL);

insert into Areavalues(100711911,'桥头乡',100711900,'台湾省高雄县桥头乡',11,NULL);

insert into Areavalues(100711912,'梓官乡',100711900,'台湾省高雄县梓官乡',12,NULL);

insert into Areavalues(100711913,'弥陀乡',100711900,'台湾省高雄县弥陀乡',13,NULL);

insert into Areavalues(100711914,'永安乡',100711900,'台湾省高雄县永安乡',14,NULL);

insert into Areavalues(100711915,'湖内乡',100711900,'台湾省高雄县湖内乡',15,NULL);

insert into Areavalues(100711916,'大寮乡',100711900,'台湾省高雄县大寮乡',16,NULL);

insert into Areavalues(100711917,'林园乡',100711900,'台湾省高雄县林园乡',17,NULL);

insert into Areavalues(100711918,'鸟松乡',100711900,'台湾省高雄县鸟松乡',18,NULL);

insert into Areavalues(100711919,'大树乡',100711900,'台湾省高雄县大树乡',19,NULL);

insert into Areavalues(100711920,'六龟乡',100711900,'台湾省高雄县六龟乡',20,NULL);

insert into Areavalues(100711921,'内门乡',100711900,'台湾省高雄县内门乡',21,NULL);

insert into Areavalues(100711922,'杉林乡',100711900,'台湾省高雄县杉林乡',22,NULL);

insert into Areavalues(100711923,'甲仙乡',100711900,'台湾省高雄县甲仙乡',23,NULL);

insert into Areavalues(100711924,'桃源乡',100711900,'台湾省高雄县桃源乡',24,NULL);

insert into Areavalues(100711925,'三民乡',100711900,'台湾省高雄县三民乡',25,NULL);

insert into Areavalues(100711926,'茂林乡',100711900,'台湾省高雄县茂林乡',26,NULL);

insert into Areavalues(100711927,'茄萣乡',100711900,'台湾省高雄县茄萣乡',27,NULL);

insert into Areavalues(100712001,'屏东市',100712000,'台湾省屏东县屏东市',1,NULL);

insert into Areavalues(100712002,'潮州镇',100712000,'台湾省屏东县潮州镇',2,NULL);

insert into Areavalues(100712003,'东港镇',100712000,'台湾省屏东县东港镇',3,NULL);

insert into Areavalues(100712004,'恒春镇',100712000,'台湾省屏东县恒春镇',4,NULL);

insert into Areavalues(100712005,'三地门乡',100712000,'台湾省屏东县三地门乡',5,NULL);

insert into Areavalues(100712006,'雾台乡',100712000,'台湾省屏东县雾台乡',6,NULL);

insert into Areavalues(100712007,'玛家乡',100712000,'台湾省屏东县玛家乡',7,NULL);

insert into Areavalues(100712008,'九如乡',100712000,'台湾省屏东县九如乡',8,NULL);

insert into Areavalues(100712009,'里港乡',100712000,'台湾省屏东县里港乡',9,NULL);

insert into Areavalues(100712010,'高树乡',100712000,'台湾省屏东县高树乡',10,NULL);

insert into Areavalues(100712011,'盐埔乡',100712000,'台湾省屏东县盐埔乡',11,NULL);

insert into Areavalues(100712012,'长治乡',100712000,'台湾省屏东县长治乡',12,NULL);

insert into Areavalues(100712013,'麟洛乡',100712000,'台湾省屏东县麟洛乡',13,NULL);

insert into Areavalues(100712014,'竹田乡',100712000,'台湾省屏东县竹田乡',14,NULL);

insert into Areavalues(100712015,'内埔乡',100712000,'台湾省屏东县内埔乡',15,NULL);

insert into Areavalues(100712016,'万丹乡',100712000,'台湾省屏东县万丹乡',16,NULL);

insert into Areavalues(100712017,'泰武乡',100712000,'台湾省屏东县泰武乡',17,NULL);

insert into Areavalues(100712018,'来义乡',100712000,'台湾省屏东县来义乡',18,NULL);

insert into Areavalues(100712019,'万峦乡',100712000,'台湾省屏东县万峦乡',19,NULL);

insert into Areavalues(100712020,'嵌顶乡',100712000,'台湾省屏东县嵌顶乡',20,NULL);

insert into Areavalues(100712021,'新埤乡',100712000,'台湾省屏东县新埤乡',21,NULL);

insert into Areavalues(100712022,'南州乡',100712000,'台湾省屏东县南州乡',22,NULL);

insert into Areavalues(100712023,'林边乡',100712000,'台湾省屏东县林边乡',23,NULL);

insert into Areavalues(100712024,'琉球乡',100712000,'台湾省屏东县琉球乡',24,NULL);

insert into Areavalues(100712025,'佳冬乡',100712000,'台湾省屏东县佳冬乡',25,NULL);

insert into Areavalues(100712026,'新园乡',100712000,'台湾省屏东县新园乡',26,NULL);

insert into Areavalues(100712027,'枋寮乡',100712000,'台湾省屏东县枋寮乡',27,NULL);

insert into Areavalues(100712028,'枋山乡',100712000,'台湾省屏东县枋山乡',28,NULL);

insert into Areavalues(100712029,'春日乡',100712000,'台湾省屏东县春日乡',29,NULL);

insert into Areavalues(100712030,'狮子乡',100712000,'台湾省屏东县狮子乡',30,NULL);

insert into Areavalues(100712031,'车城乡',100712000,'台湾省屏东县车城乡',31,NULL);

insert into Areavalues(100712032,'牡丹乡',100712000,'台湾省屏东县牡丹乡',32,NULL);

insert into Areavalues(100712033,'满州乡',100712000,'台湾省屏东县满州乡',33,NULL);

insert into Areavalues(100712101,'台东市',100712100,'台湾省台东县台东市',1,NULL);

insert into Areavalues(100712102,'关山镇',100712100,'台湾省台东县关山镇',2,NULL);

insert into Areavalues(100712103,'成功镇',100712100,'台湾省台东县成功镇',3,NULL);

insert into Areavalues(100712104,'绿岛乡',100712100,'台湾省台东县绿岛乡',4,NULL);

insert into Areavalues(100712105,'兰屿乡',100712100,'台湾省台东县兰屿乡',5,NULL);

insert into Areavalues(100712106,'延平乡',100712100,'台湾省台东县延平乡',6,NULL);

insert into Areavalues(100712107,'卑南乡',100712100,'台湾省台东县卑南乡',7,NULL);

insert into Areavalues(100712108,'鹿野乡',100712100,'台湾省台东县鹿野乡',8,NULL);

insert into Areavalues(100712109,'海端乡',100712100,'台湾省台东县海端乡',9,NULL);

insert into Areavalues(100712110,'池上乡',100712100,'台湾省台东县池上乡',10,NULL);

insert into Areavalues(100712111,'东河乡',100712100,'台湾省台东县东河乡',11,NULL);

insert into Areavalues(100712112,'长滨乡',100712100,'台湾省台东县长滨乡',12,NULL);

insert into Areavalues(100712113,'太麻里乡',100712100,'台湾省台东县太麻里乡',13,NULL);

insert into Areavalues(100712114,'金峰乡',100712100,'台湾省台东县金峰乡',14,NULL);

insert into Areavalues(100712115,'大武乡',100712100,'台湾省台东县大武乡',15,NULL);

insert into Areavalues(100712116,'达仁乡',100712100,'台湾省台东县达仁乡',16,NULL);

insert into Areavalues(100712201,'花莲市',100712200,'台湾省花莲县花莲市',1,NULL);

insert into Areavalues(100712202,'凤林镇',100712200,'台湾省花莲县凤林镇',2,NULL);

insert into Areavalues(100712203,'玉里镇',100712200,'台湾省花莲县玉里镇',3,NULL);

insert into Areavalues(100712204,'新城乡',100712200,'台湾省花莲县新城乡',4,NULL);

insert into Areavalues(100712205,'秀林乡',100712200,'台湾省花莲县秀林乡',5,NULL);

insert into Areavalues(100712206,'吉安乡',100712200,'台湾省花莲县吉安乡',6,NULL);

insert into Areavalues(100712207,'寿丰乡',100712200,'台湾省花莲县寿丰乡',7,NULL);

insert into Areavalues(100712208,'光复乡',100712200,'台湾省花莲县光复乡',8,NULL);

insert into Areavalues(100712209,'丰滨乡',100712200,'台湾省花莲县丰滨乡',9,NULL);

insert into Areavalues(100712210,'瑞穗乡',100712200,'台湾省花莲县瑞穗乡',10,NULL);

insert into Areavalues(100712211,'万荣乡',100712200,'台湾省花莲县万荣乡',11,NULL);

insert into Areavalues(100712212,'卓溪乡',100712200,'台湾省花莲县卓溪乡',12,NULL);

insert into Areavalues(100712213,'富里乡',100712200,'台湾省花莲县富里乡',13,NULL);

insert into Areavalues(100712301,'马公市',100712300,'台湾省澎湖县马公市',1,NULL);

insert into Areavalues(100712302,'西屿乡',100712300,'台湾省澎湖县西屿乡',2,NULL);

insert into Areavalues(100712303,'望安乡',100712300,'台湾省澎湖县望安乡',3,NULL);

insert into Areavalues(100712304,'七美乡',100712300,'台湾省澎湖县七美乡',4,NULL);

insert into Areavalues(100712305,'白沙乡',100712300,'台湾省澎湖县白沙乡',5,NULL);

insert into Areavalues(100712306,'湖西乡',100712300,'台湾省澎湖县湖西乡',6,NULL);

insert into Areavalues(100710401,'中区',100710400,'台湾省台中市中区',1,NULL);

insert into Areavalues(100710402,'东区',100710400,'台湾省台中市中区',2,NULL);

insert into Areavalues(100710403,'西区',100710400,'台湾省台中市中区',3,NULL);

insert into Areavalues(100710404,'南区',100710400,'台湾省台中市中区',4,NULL);

insert into Areavalues(100710405,'北区',100710400,'台湾省台中市中区',5,NULL);

insert into Areavalues(100710406,'西屯区',100710400,'台湾省台中市中区',6,NULL);

insert into Areavalues(100710407,'南屯区',100710400,'台湾省台中市中区',7,NULL);

insert into Areavalues(100710408,'北屯区',100710400,'台湾省台中市中区',8,NULL);

这样就算基本完善了，发一个最终版本sql脚本。《area_inter_result.sql》

参考资料：台中市行政区划互动百科

0 0