国省州市县四级关联表

最新推荐文章于 2021-07-22 11:16:15 发布

zhipeng-python

最新推荐文章于 2021-07-22 11:16:15 发布

阅读量553

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/u012731379/article/details/64125556

版权

SQL 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

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

现成表： Area_SQL.sql

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

delete from Area where Area_ID=100820002;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

insert into Area values(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()

with file('result.html','w')as f:

f.write(r)

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

if rl:rl=rl[0]

else:continue

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

i_2 = 0

for i in rls:

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 Area values(100710800,'台北县',100710000,8,'台湾省台北县',NULL);

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

print taizhong_q

结果：

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);

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

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

zhipeng-python

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
3
评论
国省州市县四级关联表

把国家省市县再补充一下澳门和台湾的行政划分。现成表：Area_SQL.sqlupdate Area setArea_ID=100820100,Title='澳门',PID=100820000,Sort=1,Content='澳门澳门'where Area_ID=100820001;delete from Area whereArea_ID=100820002;insert int
复制链接

扫一扫