最新-中国城市编码sql版下篇

最新推荐文章于 2021-12-01 11:30:53 发布
派森先生
最新推荐文章于 2021-12-01 11:30:53 发布
阅读量1.2k
点赞数 1
分类专栏： Mysql数据库
本文链接：https://blog.csdn.net/qq_44846224/article/details/112382093
版权
Mysql数据库专栏收录该内容
6 篇文章 0 订阅
订阅专栏
将以下内容与上篇拼接即为完整版

INSERT INTO `dict_area` VALUES (410481, '舞钢市', 410400);
INSERT INTO `dict_area` VALUES (410482, '汝州市', 410400);
INSERT INTO `dict_area` VALUES (410500, '安阳市', 410000);
INSERT INTO `dict_area` VALUES (410502, '文峰区', 410500);
INSERT INTO `dict_area` VALUES (410503, '北关区', 410500);
INSERT INTO `dict_area` VALUES (410505, '殷都区', 410500);
INSERT INTO `dict_area` VALUES (410506, '龙安区', 410500);
INSERT INTO `dict_area` VALUES (410522, '安阳县', 410500);
INSERT INTO `dict_area` VALUES (410523, '汤阴县', 410500);
INSERT INTO `dict_area` VALUES (410526, '滑县', 410500);
INSERT INTO `dict_area` VALUES (410527, '内黄县', 410500);
INSERT INTO `dict_area` VALUES (410581, '林州市', 410500);
INSERT INTO `dict_area` VALUES (410600, '鹤壁市', 410000);
INSERT INTO `dict_area` VALUES (410602, '鹤山区', 410600);
INSERT INTO `dict_area` VALUES (410603, '山城区', 410600);
INSERT INTO `dict_area` VALUES (410611, '淇滨区', 410600);
INSERT INTO `dict_area` VALUES (410621, '浚县', 410600);
INSERT INTO `dict_area` VALUES (410622, '淇县', 410600);
INSERT INTO `dict_area` VALUES (410700, '新乡市', 410000);
INSERT INTO `dict_area` VALUES (410702, '红旗区', 410700);
INSERT INTO `dict_area` VALUES (410703, '卫滨区', 410700);
INSERT INTO `dict_area` VALUES (410704, '凤泉区', 410700);
INSERT INTO `dict_area` VALUES (410711, '牧野区', 410700);
INSERT INTO `dict_area` VALUES (410721, '新乡县', 410700);
INSERT INTO `dict_area` VALUES (410724, '获嘉县', 410700);
INSERT INTO `dict_area` VALUES (410725, '原阳县', 410700);
INSERT INTO `dict_area` VALUES (410726, '延津县', 410700);
INSERT INTO `dict_area` VALUES (410727, '封丘县', 410700);
INSERT INTO `dict_area` VALUES (410728, '长垣县', 410700);
INSERT INTO `dict_area` VALUES (410781, '卫辉市', 410700);
INSERT INTO `dict_area` VALUES (410782, '辉县市', 410700);
INSERT INTO `dict_area` VALUES (410800, '焦作市', 410000);
INSERT INTO `dict_area` VALUES (410802, '解放区', 410800);
INSERT INTO `dict_area` VALUES (410803, '中站区', 410800);
INSERT INTO `dict_area` VALUES (410804, '马村区', 410800);
INSERT INTO `dict_area` VALUES (410811, '山阳区', 410800);
INSERT INTO `dict_area` VALUES (410821, '修武县', 410800);
INSERT INTO `dict_area` VALUES (410822, '博爱县', 410800);
INSERT INTO `dict_area` VALUES (410823, '武陟县', 410800);
INSERT INTO `dict_area` VALUES (410825, '温县', 410800);
INSERT INTO `dict_area` VALUES (410882, '沁阳市', 410800);
INSERT INTO `dict_area` VALUES (410883, '孟州市', 410800);
INSERT INTO `dict_area` VALUES (410900, '濮阳市', 410000);
INSERT INTO `dict_area` VALUES (410902, '华龙区', 410900);
INSERT INTO `dict_area` VALUES (410922, '清丰县', 410900);
INSERT INTO `dict_area` VALUES (410923, '南乐县', 410900);
INSERT INTO `dict_area` VALUES (410926, '范县', 410900);
INSERT INTO `dict_area` VALUES (410927, '台前县', 410900);
INSERT INTO `dict_area` VALUES (410928, '濮阳县', 410900);
INSERT INTO `dict_area` VALUES (411000, '许昌市', 410000);
INSERT INTO `dict_area` VALUES (411002, '魏都区', 411000);
INSERT INTO `dict_area` VALUES (411003, '建安区', 411000);
INSERT INTO `dict_area` VALUES (411024, '鄢陵县', 411000);
INSERT INTO `dict_area` VALUES (411025, '襄城县', 411000);
INSERT INTO `dict_area` VALUES (411081, '禹州市', 411000);
INSERT INTO `dict_area` VALUES (411082, '长葛市', 411000);
INSERT INTO `dict_area` VALUES (411100, '漯河市', 410000);
INSERT INTO `dict_area` VALUES (411102, '源汇区', 411100);
INSERT INTO `dict_area` VALUES (411103, '郾城区', 411100);
INSERT INTO `dict_area` VALUES (411104, '召陵区', 411100);
INSERT INTO `dict_area` VALUES (411121, '舞阳县', 411100);
INSERT INTO `dict_area` VALUES (411122, '临颍县', 411100);
INSERT INTO `dict_area` VALUES (411200, '三门峡市', 410000);
INSERT INTO `dict_area` VALUES (411202, '湖滨区', 411200);
INSERT INTO `dict_area` VALUES (411203, '陕州区', 411200);
INSERT INTO `dict_area` VALUES (411221, '渑池县', 411200);
INSERT INTO `dict_area` VALUES (411224, '卢氏县', 411200);
INSERT INTO `dict_area` VALUES (411281, '义马市', 411200);
INSERT INTO `dict_area` VALUES (411282, '灵宝市', 411200);
INSERT INTO `dict_area` VALUES (411300, '南阳市', 410000);
INSERT INTO `dict_area` VALUES (411302, '宛城区', 411300);
INSERT INTO `dict_area` VALUES (411303, '卧龙区', 411300);
INSERT INTO `dict_area` VALUES (411321, '南召县', 411300);
INSERT INTO `dict_area` VALUES (411322, '方城县', 411300);
INSERT INTO `dict_area` VALUES (411323, '西峡县', 411300);
INSERT INTO `dict_area` VALUES (411324, '镇平县', 411300);
INSERT INTO `dict_area` VALUES (411325, '内乡县', 411300);
INSERT INTO `dict_area` VALUES (411326, '淅川县', 411300);
INSERT INTO `dict_area` VALUES (411327, '社旗县', 411300);
INSERT INTO `dict_area` VALUES (411328, '唐河县', 411300);
INSERT INTO `dict_area` VALUES (411329, '新野县', 411300);
INSERT INTO `dict_area` VALUES (411330, '桐柏县', 411300);
INSERT INTO `dict_area` VALUES (411381, '邓州市', 411300);
INSERT INTO `dict_area` VALUES (411400, '商丘市', 410000);
INSERT INTO `dict_area` VALUES (411402, '梁园区', 411400);
INSERT INTO `dict_area` VALUES (411403, '睢阳区', 411400);
INSERT INTO `dict_area` VALUES (411421, '民权县', 411400);
INSERT INTO `dict_area` VALUES (411422, '睢县', 411400);
INSERT INTO `dict_area` VALUES (411423, '宁陵县', 411400);
INSERT INTO `dict_area` VALUES (411424, '柘城县', 411400);
INSERT INTO `dict_area` VALUES (411425, '虞城县', 411400);
INSERT INTO `dict_area` VALUES (411426, '夏邑县', 411400);
INSERT INTO `dict_area` VALUES (411481, '永城市', 411400);
INSERT INTO `dict_area` VALUES (411500, '信阳市', 410000);
INSERT INTO `dict_area` VALUES (411502, '浉河区', 411500);
INSERT INTO `dict_area` VALUES (411503, '平桥区', 411500);
INSERT INTO `dict_area` VALUES (411521, '罗山县', 411500);
INSERT INTO `dict_area` VALUES (411522, '光山县', 411500);
INSERT INTO `dict_area` VALUES (411523, '新县', 411500);
INSERT INTO `dict_area` VALUES (411524, '商城县', 411500);
INSERT INTO `dict_area` VALUES (411525, '固始县', 411500);
INSERT INTO `dict_area` VALUES (411526, '潢川县', 411500);
INSERT INTO `dict_area` VALUES (411527, '淮滨县', 411500);
INSERT INTO `dict_area` VALUES (411528, '息县', 411500);
INSERT INTO `dict_area` VALUES (411600, '周口市', 410000);
INSERT INTO `dict_area` VALUES (411602, '川汇区', 411600);
INSERT INTO `dict_area` VALUES (411621, '扶沟县', 411600);
INSERT INTO `dict_area` VALUES (411622, '西华县', 411600);
INSERT INTO `dict_area` VALUES (411623, '商水县', 411600);
INSERT INTO `dict_area` VALUES (411624, '沈丘县', 411600);
INSERT INTO `dict_area` VALUES (411625, '郸城县', 411600);
INSERT INTO `dict_area` VALUES (411626, '淮阳县', 411600);
INSERT INTO `dict_area` VALUES (411627, '太康县', 411600);
INSERT INTO `dict_area` VALUES (411628, '鹿邑县', 411600);
INSERT INTO `dict_area` VALUES (411681, '项城市', 411600);
INSERT INTO `dict_area` VALUES (411700, '驻马店市', 410000);
INSERT INTO `dict_area` VALUES (411702, '驿城区', 411700);
INSERT INTO `dict_area` VALUES (411721, '西平县', 411700);
INSERT INTO `dict_area` VALUES (411722, '上蔡县', 411700);
INSERT INTO `dict_area` VALUES (411723, '平舆县', 411700);
INSERT INTO `dict_area` VALUES (411724, '正阳县', 411700);
INSERT INTO `dict_area` VALUES (411725, '确山县', 411700);
INSERT INTO `dict_area` VALUES (411726, '泌阳县', 411700);
INSERT INTO `dict_area` VALUES (411727, '汝南县', 411700);
INSERT INTO `dict_area` VALUES (411728, '遂平县', 411700);
INSERT INTO `dict_area` VALUES (411729, '新蔡县', 411700);
INSERT INTO `dict_area` VALUES (411800, '济源市', 410000);
INSERT INTO `dict_area` VALUES (420000, '湖北省', NULL);
INSERT INTO `dict_area` VALUES (420100, '武汉市', 420000);
INSERT INTO `dict_area` VALUES (420102, '江岸区', 420100);
INSERT INTO `dict_area` VALUES (420103, '江汉区', 420100);
INSERT INTO `dict_area` VALUES (420104, '硚口区', 420100);
INSERT INTO `dict_area` VALUES (420105, '汉阳区', 420100);
INSERT INTO `dict_area` VALUES (420106, '武昌区', 420100);
INSERT INTO `dict_area` VALUES (420107, '青山区', 420100);
INSERT INTO `dict_area` VALUES (420111, '洪山区', 420100);
INSERT INTO `dict_area` VALUES (420112, '东西湖区', 420100);
INSERT INTO `dict_area` VALUES (420113, '汉南区', 420100);
INSERT INTO `dict_area` VALUES (420114, '蔡甸区', 420100);
INSERT INTO `dict_area` VALUES (420115, '江夏区', 420100);
INSERT INTO `dict_area` VALUES (420116, '黄陂区', 420100);
INSERT INTO `dict_area` VALUES (420117, '新洲区', 420100);
INSERT INTO `dict_area` VALUES (420200, '黄石市', 420000);
INSERT INTO `dict_area` VALUES (420202, '黄石港区', 420200);
INSERT INTO `dict_area` VALUES (420203, '西塞山区', 420200);
INSERT INTO `dict_area` VALUES (420204, '下陆区', 420200);
INSERT INTO `dict_area` VALUES (420205, '铁山区', 420200);
INSERT INTO `dict_area` VALUES (420222, '阳新县', 420200);
INSERT INTO `dict_area` VALUES (420281, '大冶市', 420200);
INSERT INTO `dict_area` VALUES (420300, '十堰市', 420000);
INSERT INTO `dict_area` VALUES (420302, '茅箭区', 420300);
INSERT INTO `dict_area` VALUES (420303, '张湾区', 420300);
INSERT INTO `dict_area` VALUES (420304, '郧阳区', 420300);
INSERT INTO `dict_area` VALUES (420322, '郧西县', 420300);
INSERT INTO `dict_area` VALUES (420323, '竹山县', 420300);
INSERT INTO `dict_area` VALUES (420324, '竹溪县', 420300);
INSERT INTO `dict_area` VALUES (420325, '房县', 420300);
INSERT INTO `dict_area` VALUES (420381, '丹江口市', 420300);
INSERT INTO `dict_area` VALUES (420500, '宜昌市', 420000);
INSERT INTO `dict_area` VALUES (420502, '西陵区', 420500);
INSERT INTO `dict_area` VALUES (420503, '伍家岗区', 420500);
INSERT INTO `dict_area` VALUES (420504, '点军区', 420500);
INSERT INTO `dict_area` VALUES (420505, '猇亭区', 420500);
INSERT INTO `dict_area` VALUES (420506, '夷陵区', 420500);
INSERT INTO `dict_area` VALUES (420525, '远安县', 420500);
INSERT INTO `dict_area` VALUES (420526, '兴山县', 420500);
INSERT INTO `dict_area` VALUES (420527, '秭归县', 420500);
INSERT INTO `dict_area` VALUES (420528, '长阳土家族自治县', 420500);
INSERT INTO `dict_area` VALUES (420529, '五峰土家族自治县', 420500);
INSERT INTO `dict_area` VALUES (420581, '宜都市', 420500);
INSERT INTO `dict_area` VALUES (420582, '当阳市', 420500);
INSERT INTO `dict_area` VALUES (420583, '枝江市', 420500);
INSERT INTO `dict_area` VALUES (420600, '襄阳市', 420000);
INSERT INTO `dict_area` VALUES (420602, '襄城区', 420600);
INSERT INTO `dict_area` VALUES (420606, '樊城区', 420600);
INSERT INTO `dict_area` VALUES (420607, '襄州区', 420600);
INSERT INTO `dict_area` VALUES (420624, '南漳县', 420600);
INSERT INTO `dict_area` VALUES (420625, '谷城县', 420600);
INSERT INTO `dict_area` VALUES (420626, '保康县', 420600);
INSERT INTO `dict_area` VALUES (420682, '老河口市', 420600);
INSERT INTO `dict_area` VALUES (420683, '枣阳市', 420600);
INSERT INTO `dict_area` VALUES (420684, '宜城市', 420600);
INSERT INTO `dict_area` VALUES (420700, '鄂州市', 420000);
INSERT INTO `dict_area` VALUES (420702, '梁子湖区', 420700);
INSERT INTO `dict_area` VALUES (420703, '华容区', 420700);
INSERT INTO `dict_area` VALUES (420704, '鄂城区', 420700);
INSERT INTO `dict_area` VALUES (420800, '荆门市', 420000);
INSERT INTO `dict_area` VALUES (420802, '东宝区', 420800);
INSERT INTO `dict_area` VALUES (420804, '掇刀区', 420800);
INSERT INTO `dict_area` VALUES (420821, '京山县', 420800);
INSERT INTO `dict_area` VALUES (420822, '沙洋县', 420800);
INSERT INTO `dict_area` VALUES (420881, '钟祥市', 420800);
INSERT INTO `dict_area` VALUES (420900, '孝感市', 420000);
INSERT INTO `dict_area` VALUES (420902, '孝南区', 420900);
INSERT INTO `dict_area` VALUES (420921, '孝昌县', 420900);
INSERT INTO `dict_area` VALUES (420922, '大悟县', 420900);
INSERT INTO `dict_area` VALUES (420923, '云梦县', 420900);
INSERT INTO `dict_area` VALUES (420981, '应城市', 420900);
INSERT INTO `dict_area` VALUES (420982, '安陆市', 420900);
INSERT INTO `dict_area` VALUES (420984, '汉川市', 420900);
INSERT INTO `dict_area` VALUES (421000, '荆州市', 420000);
INSERT INTO `dict_area` VALUES (421002, '沙市区', 421000);
INSERT INTO `dict_area` VALUES (421003, '荆州区', 421000);
INSERT INTO `dict_area` VALUES (421022, '公安县', 421000);
INSERT INTO `dict_area` VALUES (421023, '监利县', 421000);
INSERT INTO `dict_area` VALUES (421024, '江陵县', 421000);
INSERT INTO `dict_area` VALUES (421081, '石首市', 421000);
INSERT INTO `dict_area` VALUES (421083, '洪湖市', 421000);
INSERT INTO `dict_area` VALUES (421087, '松滋市', 421000);
INSERT INTO `dict_area` VALUES (421100, '黄冈市', 420000);
INSERT INTO `dict_area` VALUES (421102, '黄州区', 421100);
INSERT INTO `dict_area` VALUES (421121, '团风县', 421100);
INSERT INTO `dict_area` VALUES (421122, '红安县', 421100);
INSERT INTO `dict_area` VALUES (421123, '罗田县', 421100);
INSERT INTO `dict_area` VALUES (421124, '英山县', 421100);
INSERT INTO `dict_area` VALUES (421125, '浠水县', 421100);
INSERT INTO `dict_area` VALUES (421126, '蕲春县', 421100);
INSERT INTO `dict_area` VALUES (421127, '黄梅县', 421100);
INSERT INTO `dict_area` VALUES (421181, '麻城市', 421100);
INSERT INTO `dict_area` VALUES (421182, '武穴市', 421100);
INSERT INTO `dict_area` VALUES (421200, '咸宁市', 420000);
INSERT INTO `dict_area` VALUES (421202, '咸安区', 421200);
INSERT INTO `dict_area` VALUES (421221, '嘉鱼县', 421200);
INSERT INTO `dict_area` VALUES (421222, '通城县', 421200);
INSERT INTO `dict_area` VALUES (421223, '崇阳县', 421200);
INSERT INTO `dict_area` VALUES (421224, '通山县', 421200);
INSERT INTO `dict_area` VALUES (421281, '赤壁市', 421200);
INSERT INTO `dict_area` VALUES (421300, '随州市', 420000);
INSERT INTO `dict_area` VALUES (421303, '曾都区', 421300);
INSERT INTO `dict_area` VALUES (421321, '随县', 421300);
INSERT INTO `dict_area` VALUES (421381, '广水市', 421300);
INSERT INTO `dict_area` VALUES (421400, '仙桃市', 420000);
INSERT INTO `dict_area` VALUES (421500, '潜江市', 420000);
INSERT INTO `dict_area` VALUES (421600, '天门市', 420000);
INSERT INTO `dict_area` VALUES (421700, '神农架林区', 420000);
INSERT INTO `dict_area` VALUES (422800, '恩施土家族苗族自治州', 420000);
INSERT INTO `dict_area` VALUES (422801, '恩施市', 422800);
INSERT INTO `dict_area` VALUES (422802, '利川市', 422800);
INSERT INTO `dict_area` VALUES (422822, '建始县', 422800);
INSERT INTO `dict_area` VALUES (422823, '巴东县', 422800);
INSERT INTO `dict_area` VALUES (422825, '宣恩县', 422800);
INSERT INTO `dict_area` VALUES (422826, '咸丰县', 422800);
INSERT INTO `dict_area` VALUES (422827, '来凤县', 422800);
INSERT INTO `dict_area` VALUES (422828, '鹤峰县', 422800);
INSERT INTO `dict_area` VALUES (430000, '湖南省', NULL);
INSERT INTO `dict_area` VALUES (430100, '长沙市', 430000);
INSERT INTO `dict_area` VALUES (430102, '芙蓉区', 430100);
INSERT INTO `dict_area` VALUES (430103, '天心区', 430100);
INSERT INTO `dict_area` VALUES (430104, '岳麓区', 430100);
INSERT INTO `dict_area` VALUES (430105, '开福区', 430100);
INSERT INTO `dict_area` VALUES (430111, '雨花区', 430100);
INSERT INTO `dict_area` VALUES (430112, '望城区', 430100);
INSERT INTO `dict_area` VALUES (430121, '长沙县', 430100);
INSERT INTO `dict_area` VALUES (430181, '浏阳市', 430100);
INSERT INTO `dict_area` VALUES (430182, '宁乡市', 430100);
INSERT INTO `dict_area` VALUES (430200, '株洲市', 430000);
INSERT INTO `dict_area` VALUES (430202, '荷塘区', 430200);
INSERT INTO `dict_area` VALUES (430203, '芦淞区', 430200);
INSERT INTO `dict_area` VALUES (430204, '石峰区', 430200);
INSERT INTO `dict_area` VALUES (430211, '天元区', 430200);
INSERT INTO `dict_area` VALUES (430221, '株洲县', 430200);
INSERT INTO `dict_area` VALUES (430223, '攸县', 430200);
INSERT INTO `dict_area` VALUES (430224, '茶陵县', 430200);
INSERT INTO `dict_area` VALUES (430225, '炎陵县', 430200);
INSERT INTO `dict_area` VALUES (430281, '醴陵市', 430200);
INSERT INTO `dict_area` VALUES (430300, '湘潭市', 430000);
INSERT INTO `dict_area` VALUES (430302, '雨湖区', 430300);
INSERT INTO `dict_area` VALUES (430304, '岳塘区', 430300);
INSERT INTO `dict_area` VALUES (430321, '湘潭县', 430300);
INSERT INTO `dict_area` VALUES (430381, '湘乡市', 430300);
INSERT INTO `dict_area` VALUES (430382, '韶山市', 430300);
INSERT INTO `dict_area` VALUES (430400, '衡阳市', 430000);
INSERT INTO `dict_area` VALUES (430405, '珠晖区', 430400);
INSERT INTO `dict_area` VALUES (430406, '雁峰区', 430400);
INSERT INTO `dict_area` VALUES (430407, '石鼓区', 430400);
INSERT INTO `dict_area` VALUES (430408, '蒸湘区', 430400);
INSERT INTO `dict_area` VALUES (430412, '南岳区', 430400);
INSERT INTO `dict_area` VALUES (430421, '衡阳县', 430400);
INSERT INTO `dict_area` VALUES (430422, '衡南县', 430400);
INSERT INTO `dict_area` VALUES (430423, '衡山县', 430400);
INSERT INTO `dict_area` VALUES (430424, '衡东县', 430400);
INSERT INTO `dict_area` VALUES (430426, '祁东县', 430400);
INSERT INTO `dict_area` VALUES (430481, '耒阳市', 430400);
INSERT INTO `dict_area` VALUES (430482, '常宁市', 430400);
INSERT INTO `dict_area` VALUES (430500, '邵阳市', 430000);
INSERT INTO `dict_area` VALUES (430502, '双清区', 430500);
INSERT INTO `dict_area` VALUES (430503, '大祥区', 430500);
INSERT INTO `dict_area` VALUES (430511, '北塔区', 430500);
INSERT INTO `dict_area` VALUES (430521, '邵东县', 430500);
INSERT INTO `dict_area` VALUES (430522, '新邵县', 430500);
INSERT INTO `dict_area` VALUES (430523, '邵阳县', 430500);
INSERT INTO `dict_area` VALUES (430524, '隆回县', 430500);
INSERT INTO `dict_area` VALUES (430525, '洞口县', 430500);
INSERT INTO `dict_area` VALUES (430527, '绥宁县', 430500);
INSERT INTO `dict_area` VALUES (430528, '新宁县', 430500);
INSERT INTO `dict_area` VALUES (430529, '城步苗族自治县', 430500);
INSERT INTO `dict_area` VALUES (430581, '武冈市', 430500);
INSERT INTO `dict_area` VALUES (430600, '岳阳市', 430000);
INSERT INTO `dict_area` VALUES (430602, '岳阳楼区', 430600);
INSERT INTO `dict_area` VALUES (430603, '云溪区', 430600);
INSERT INTO `dict_area` VALUES (430611, '君山区', 430600);
INSERT INTO `dict_area` VALUES (430621, '岳阳县', 430600);
INSERT INTO `dict_area` VALUES (430623, '华容县', 430600);
INSERT INTO `dict_area` VALUES (430624, '湘阴县', 430600);
INSERT INTO `dict_area` VALUES (430626, '平江县', 430600);
INSERT INTO `dict_area` VALUES (430681, '汨罗市', 430600);
INSERT INTO `dict_area` VALUES (430682, '临湘市', 430600);
INSERT INTO `dict_area` VALUES (430700, '常德市', 430000);
INSERT INTO `dict_area` VALUES (430702, '武陵区', 430700);
INSERT INTO `dict_area` VALUES (430703, '鼎城区', 430700);
INSERT INTO `dict_area` VALUES (430721, '安乡县', 430700);
INSERT INTO `dict_area` VALUES (430722, '汉寿县', 430700);
INSERT INTO `dict_area` VALUES (430723, '澧县', 430700);
INSERT INTO `dict_area` VALUES (430724, '临澧县', 430700);
INSERT INTO `dict_area` VALUES (430725, '桃源县', 430700);
INSERT INTO `dict_area` VALUES (430726, '石门县', 430700);
INSERT INTO `dict_area` VALUES (430781, '津市市', 430700);
INSERT INTO `dict_area` VALUES (430800, '张家界市', 430000);
INSERT INTO `dict_area` VALUES (430802, '永定区', 430800);
INSERT INTO `dict_area` VALUES (430811, '武陵源区', 430800);
INSERT INTO `dict_area` VALUES (430821, '慈利县', 430800);
INSERT INTO `dict_area` VALUES (430822, '桑植县', 430800);
INSERT INTO `dict_area` VALUES (430900, '益阳市', 430000);
INSERT INTO `dict_area` VALUES (430902, '资阳区', 430900);
INSERT INTO `dict_area` VALUES (430903, '赫山区', 430900);
INSERT INTO `dict_area` VALUES (430921, '南县', 430900);
INSERT INTO `dict_area` VALUES (430922, '桃江县', 430900);
INSERT INTO `dict_area` VALUES (430923, '安化县', 430900);
INSERT INTO `dict_area` VALUES (430981, '沅江市', 430900);
INSERT INTO `dict_area` VALUES (431000, '郴州市', 430000);
INSERT INTO `dict_area` VALUES (431002, '北湖区', 431000);
INSERT INTO `dict_area` VALUES (431003, '苏仙区', 431000);
INSERT INTO `dict_area` VALUES (431021, '桂阳县', 431000);
INSERT INTO `dict_area` VALUES (431022, '宜章县', 431000);
INSERT INTO `dict_area` VALUES (431023, '永兴县', 431000);
INSERT INTO `dict_area` VALUES (431024, '嘉禾县', 431000);
INSERT INTO `dict_area` VALUES (431025, '临武县', 431000);
INSERT INTO `dict_area` VALUES (431026, '汝城县', 431000);
INSERT INTO `dict_area` VALUES (431027, '桂东县', 431000);
INSERT INTO `dict_area` VALUES (431028, '安仁县', 431000);
INSERT INTO `dict_area` VALUES (431081, '资兴市', 431000);
INSERT INTO `dict_area` VALUES (431100, '永州市', 430000);
INSERT INTO `dict_area` VALUES (431102, '零陵区', 431100);
INSERT INTO `dict_area` VALUES (431103, '冷水滩区', 431100);
INSERT INTO `dict_area` VALUES (431121, '祁阳县', 431100);
INSERT INTO `dict_area` VALUES (431122, '东安县', 431100);
INSERT INTO `dict_area` VALUES (431123, '双牌县', 431100);
INSERT INTO `dict_area` VALUES (431124, '道县', 431100);
INSERT INTO `dict_area` VALUES (431125, '江永县', 431100);
INSERT INTO `dict_area` VALUES (431126, '宁远县', 431100);
INSERT INTO `dict_area` VALUES (431127, '蓝山县', 431100);
INSERT INTO `dict_area` VALUES (431128, '新田县', 431100);
INSERT INTO `dict_area` VALUES (431129, '江华瑶族自治县', 431100);
INSERT INTO `dict_area` VALUES (431200, '怀化市', 430000);
INSERT INTO `dict_area` VALUES (431202, '鹤城区', 431200);
INSERT INTO `dict_area` VALUES (431221, '中方县', 431200);
INSERT INTO `dict_area` VALUES (431222, '沅陵县', 431200);
INSERT INTO `dict_area` VALUES (431223, '辰溪县', 431200);
INSERT INTO `dict_area` VALUES (431224, '溆浦县', 431200);
INSERT INTO `dict_area` VALUES (431225, '会同县', 431200);
INSERT INTO `dict_area` VALUES (431226, '麻阳苗族自治县', 431200);
INSERT INTO `dict_area` VALUES (431227, '新晃侗族自治县', 431200);
INSERT INTO `dict_area` VALUES (431228, '芷江侗族自治县', 431200);
INSERT INTO `dict_area` VALUES (431229, '靖州苗族侗族自治县', 431200);
INSERT INTO `dict_area` VALUES (431230, '通道侗族自治县', 431200);
INSERT INTO `dict_area` VALUES (431281, '洪江市', 431200);
INSERT INTO `dict_area` VALUES (431300, '娄底市', 430000);
INSERT INTO `dict_area` VALUES (431302, '娄星区', 431300);
INSERT INTO `dict_area` VALUES (431321, '双峰县', 431300);
INSERT INTO `dict_area` VALUES (431322, '新化县', 431300);
INSERT INTO `dict_area` VALUES (431381, '冷水江市', 431300);
INSERT INTO `dict_area` VALUES (431382, '涟源市', 431300);
INSERT INTO `dict_area` VALUES (433100, '湘西土家族苗族自治州', 430000);
INSERT INTO `dict_area` VALUES (433101, '吉首市', 433100);
INSERT INTO `dict_area` VALUES (433122, '泸溪县', 433100);
INSERT INTO `dict_area` VALUES (433123, '凤凰县', 433100);
INSERT INTO `dict_area` VALUES (433124, '花垣县', 433100);
INSERT INTO `dict_area` VALUES (433125, '保靖县', 433100);
INSERT INTO `dict_area` VALUES (433126, '古丈县', 433100);
INSERT INTO `dict_area` VALUES (433127, '永顺县', 433100);
INSERT INTO `dict_area` VALUES (433130, '龙山县', 433100);
INSERT INTO `dict_area` VALUES (440000, '广东省', NULL);
INSERT INTO `dict_area` VALUES (440100, '广州市', 440000);
INSERT INTO `dict_area` VALUES (440103, '荔湾区', 440100);
INSERT INTO `dict_area` VALUES (440104, '越秀区', 440100);
INSERT INTO `dict_area` VALUES (440105, '海珠区', 440100);
INSERT INTO `dict_area` VALUES (440106, '天河区', 440100);
INSERT INTO `dict_area` VALUES (440111, '白云区', 440100);
INSERT INTO `dict_area` VALUES (440112, '黄埔区', 440100);
INSERT INTO `dict_area` VALUES (440113, '番禺区', 440100);
INSERT INTO `dict_area` VALUES (440114, '花都区', 440100);
INSERT INTO `dict_area` VALUES (440115, '南沙区', 440100);
INSERT INTO `dict_area` VALUES (440117, '从化区', 440100);
INSERT INTO `dict_area` VALUES (440118, '增城区', 440100);
INSERT INTO `dict_area` VALUES (440200, '韶关市', 440000);
INSERT INTO `dict_area` VALUES (440203, '武江区', 440200);
INSERT INTO `dict_area` VALUES (440204, '浈江区', 440200);
INSERT INTO `dict_area` VALUES (440205, '曲江区', 440200);
INSERT INTO `dict_area` VALUES (440222, '始兴县', 440200);
INSERT INTO `dict_area` VALUES (440224, '仁化县', 440200);
INSERT INTO `dict_area` VALUES (440229, '翁源县', 440200);
INSERT INTO `dict_area` VALUES (440232, '乳源瑶族自治县', 440200);
INSERT INTO `dict_area` VALUES (440233, '新丰县', 440200);
INSERT INTO `dict_area` VALUES (440281, '乐昌市', 440200);
INSERT INTO `dict_area` VALUES (440282, '南雄市', 440200);
INSERT INTO `dict_area` VALUES (440300, '深圳市', 440000);
INSERT INTO `dict_area` VALUES (440303, '罗湖区', 440300);
INSERT INTO `dict_area` VALUES (440304, '福田区', 440300);
INSERT INTO `dict_area` VALUES (440305, '南山区', 440300);
INSERT INTO `dict_area` VALUES (440306, '宝安区', 440300);
INSERT INTO `dict_area` VALUES (440307, '龙岗区', 440300);
INSERT INTO `dict_area` VALUES (440308, '盐田区', 440300);
INSERT INTO `dict_area` VALUES (440309, '龙华区', 440300);
INSERT INTO `dict_area` VALUES (440310, '坪山区', 440300);
INSERT INTO `dict_area` VALUES (440400, '珠海市', 440000);
INSERT INTO `dict_area` VALUES (440402, '香洲区', 440400);
INSERT INTO `dict_area` VALUES (440403, '斗门区', 440400);
INSERT INTO `dict_area` VALUES (440404, '金湾区', 440400);
INSERT INTO `dict_area` VALUES (440499, '香洲区(由澳门特别行政区实施管辖)', 440400);
INSERT INTO `dict_area` VALUES (440500, '汕头市', 440000);
INSERT INTO `dict_area` VALUES (440507, '龙湖区', 440500);
INSERT INTO `dict_area` VALUES (440511, '金平区', 440500);
INSERT INTO `dict_area` VALUES (440512, '濠江区', 440500);
INSERT INTO `dict_area` VALUES (440513, '潮阳区', 440500);
INSERT INTO `dict_area` VALUES (440514, '潮南区', 440500);
INSERT INTO `dict_area` VALUES (440515, '澄海区', 440500);
INSERT INTO `dict_area` VALUES (440523, '南澳县', 440500);
INSERT INTO `dict_area` VALUES (440600, '佛山市', 440000);
INSERT INTO `dict_area` VALUES (440604, '禅城区', 440600);
INSERT INTO `dict_area` VALUES (440605, '南海区', 440600);
INSERT INTO `dict_area` VALUES (440606, '顺德区', 440600);
INSERT INTO `dict_area` VALUES (440607, '三水区', 440600);
INSERT INTO `dict_area` VALUES (440608, '高明区', 440600);
INSERT INTO `dict_area` VALUES (440700, '江门市', 440000);
INSERT INTO `dict_area` VALUES (440703, '蓬江区', 440700);
INSERT INTO `dict_area` VALUES (440704, '江海区', 440700);
INSERT INTO `dict_area` VALUES (440705, '新会区', 440700);
INSERT INTO `dict_area` VALUES (440781, '台山市', 440700);
INSERT INTO `dict_area` VALUES (440783, '开平市', 440700);
INSERT INTO `dict_area` VALUES (440784, '鹤山市', 440700);
INSERT INTO `dict_area` VALUES (440785, '恩平市', 440700);
INSERT INTO `dict_area` VALUES (440800, '湛江市', 440000);
INSERT INTO `dict_area` VALUES (440802, '赤坎区', 440800);
INSERT INTO `dict_area` VALUES (440803, '霞山区', 440800);
INSERT INTO `dict_area` VALUES (440804, '坡头区', 440800);
INSERT INTO `dict_area` VALUES (440811, '麻章区', 440800);
INSERT INTO `dict_area` VALUES (440823, '遂溪县', 440800);
INSERT INTO `dict_area` VALUES (440825, '徐闻县', 440800);
INSERT INTO `dict_area` VALUES (440881, '廉江市', 440800);
INSERT INTO `dict_area` VALUES (440882, '雷州市', 440800);
INSERT INTO `dict_area` VALUES (440883, '吴川市', 440800);
INSERT INTO `dict_area` VALUES (440900, '茂名市', 440000);
INSERT INTO `dict_area` VALUES (440902, '茂南区', 440900);
INSERT INTO `dict_area` VALUES (440904, '电白区', 440900);
INSERT INTO `dict_area` VALUES (440981, '高州市', 440900);
INSERT INTO `dict_area` VALUES (440982, '化州市', 440900);
INSERT INTO `dict_area` VALUES (440983, '信宜市', 440900);
INSERT INTO `dict_area` VALUES (441200, '肇庆市', 440000);
INSERT INTO `dict_area` VALUES (441202, '端州区', 441200);
INSERT INTO `dict_area` VALUES (441203, '鼎湖区', 441200);
INSERT INTO `dict_area` VALUES (441204, '高要区', 441200);
INSERT INTO `dict_area` VALUES (441223, '广宁县', 441200);
INSERT INTO `dict_area` VALUES (441224, '怀集县', 441200);
INSERT INTO `dict_area` VALUES (441225, '封开县', 441200);
INSERT INTO `dict_area` VALUES (441226, '德庆县', 441200);
INSERT INTO `dict_area` VALUES (441284, '四会市', 441200);
INSERT INTO `dict_area` VALUES (441300, '惠州市', 440000);
INSERT INTO `dict_area` VALUES (441302, '惠城区', 441300);
INSERT INTO `dict_area` VALUES (441303, '惠阳区', 441300);
INSERT INTO `dict_area` VALUES (441322, '博罗县', 441300);
INSERT INTO `dict_area` VALUES (441323, '惠东县', 441300);
INSERT INTO `dict_area` VALUES (441324, '龙门县', 441300);
INSERT INTO `dict_area` VALUES (441400, '梅州市', 440000);
INSERT INTO `dict_area` VALUES (441402, '梅江区', 441400);
INSERT INTO `dict_area` VALUES (441403, '梅县区', 441400);
INSERT INTO `dict_area` VALUES (441422, '大埔县', 441400);
INSERT INTO `dict_area` VALUES (441423, '丰顺县', 441400);
INSERT INTO `dict_area` VALUES (441424, '五华县', 441400);
INSERT INTO `dict_area` VALUES (441426, '平远县', 441400);
INSERT INTO `dict_area` VALUES (441427, '蕉岭县', 441400);
INSERT INTO `dict_area` VALUES (441481, '兴宁市', 441400);
INSERT INTO `dict_area` VALUES (441500, '汕尾市', 440000);
INSERT INTO `dict_area` VALUES (441502, '城区', 441500);
INSERT INTO `dict_area` VALUES (441521, '海丰县', 441500);
INSERT INTO `dict_area` VALUES (441523, '陆河县', 441500);
INSERT INTO `dict_area` VALUES (441581, '陆丰市', 441500);
INSERT INTO `dict_area` VALUES (441600, '河源市', 440000);
INSERT INTO `dict_area` VALUES (441602, '源城区', 441600);
INSERT INTO `dict_area` VALUES (441621, '紫金县', 441600);
INSERT INTO `dict_area` VALUES (441622, '龙川县', 441600);
INSERT INTO `dict_area` VALUES (441623, '连平县', 441600);
INSERT INTO `dict_area` VALUES (441624, '和平县', 441600);
INSERT INTO `dict_area` VALUES (441625, '东源县', 441600);
INSERT INTO `dict_area` VALUES (441700, '阳江市', 440000);
INSERT INTO `dict_area` VALUES (441702, '江城区', 441700);
INSERT INTO `dict_area` VALUES (441704, '阳东区', 441700);
INSERT INTO `dict_area` VALUES (441721, '阳西县', 441700);
INSERT INTO `dict_area` VALUES (441781, '阳春市', 441700);
INSERT INTO `dict_area` VALUES (441800, '清远市', 440000);
INSERT INTO `dict_area` VALUES (441802, '清城区', 441800);
INSERT INTO `dict_area` VALUES (441803, '清新区', 441800);
INSERT INTO `dict_area` VALUES (441821, '佛冈县', 441800);
INSERT INTO `dict_area` VALUES (441823, '阳山县', 441800);
INSERT INTO `dict_area` VALUES (441825, '连山壮族瑶族自治县', 441800);
INSERT INTO `dict_area` VALUES (441826, '连南瑶族自治县', 441800);
INSERT INTO `dict_area` VALUES (441881, '英德市', 441800);
INSERT INTO `dict_area` VALUES (441882, '连州市', 441800);
INSERT INTO `dict_area` VALUES (441900, '东莞市', 440000);
INSERT INTO `dict_area` VALUES (442000, '中山市', 440000);
INSERT INTO `dict_area` VALUES (445100, '潮州市', 440000);
INSERT INTO `dict_area` VALUES (445102, '湘桥区', 445100);
INSERT INTO `dict_area` VALUES (445103, '潮安区', 445100);
INSERT INTO `dict_area` VALUES (445122, '饶平县', 445100);
INSERT INTO `dict_area` VALUES (445200, '揭阳市', 440000);
INSERT INTO `dict_area` VALUES (445202, '榕城区', 445200);
INSERT INTO `dict_area` VALUES (445203, '揭东区', 445200);
INSERT INTO `dict_area` VALUES (445222, '揭西县', 445200);
INSERT INTO `dict_area` VALUES (445224, '惠来县', 445200);
INSERT INTO `dict_area` VALUES (445281, '普宁市', 445200);
INSERT INTO `dict_area` VALUES (445300, '云浮市', 440000);
INSERT INTO `dict_area` VALUES (445302, '云城区', 445300);
INSERT INTO `dict_area` VALUES (445303, '云安区', 445300);
INSERT INTO `dict_area` VALUES (445321, '新兴县', 445300);
INSERT INTO `dict_area` VALUES (445322, '郁南县', 445300);
INSERT INTO `dict_area` VALUES (445381, '罗定市', 445300);
INSERT INTO `dict_area` VALUES (450000, '广西壮族自治区', NULL);
INSERT INTO `dict_area` VALUES (450100, '南宁市', 450000);
INSERT INTO `dict_area` VALUES (450102, '兴宁区', 450100);
INSERT INTO `dict_area` VALUES (450103, '青秀区', 450100);
INSERT INTO `dict_area` VALUES (450105, '江南区', 450100);
INSERT INTO `dict_area` VALUES (450107, '西乡塘区', 450100);
INSERT INTO `dict_area` VALUES (450108, '良庆区', 450100);
INSERT INTO `dict_area` VALUES (450109, '邕宁区', 450100);
INSERT INTO `dict_area` VALUES (450110, '武鸣区', 450100);
INSERT INTO `dict_area` VALUES (450123, '隆安县', 450100);
INSERT INTO `dict_area` VALUES (450124, '马山县', 450100);
INSERT INTO `dict_area` VALUES (450125, '上林县', 450100);
INSERT INTO `dict_area` VALUES (450126, '宾阳县', 450100);
INSERT INTO `dict_area` VALUES (450127, '横县', 450100);
INSERT INTO `dict_area` VALUES (450200, '柳州市', 450000);
INSERT INTO `dict_area` VALUES (450202, '城中区', 450200);
INSERT INTO `dict_area` VALUES (450203, '鱼峰区', 450200);
INSERT INTO `dict_area` VALUES (450204, '柳南区', 450200);
INSERT INTO `dict_area` VALUES (450205, '柳北区', 450200);
INSERT INTO `dict_area` VALUES (450206, '柳江区', 450200);
INSERT INTO `dict_area` VALUES (450222, '柳城县', 450200);
INSERT INTO `dict_area` VALUES (450223, '鹿寨县', 450200);
INSERT INTO `dict_area` VALUES (450224, '融安县', 450200);
INSERT INTO `dict_area` VALUES (450225, '融水苗族自治县', 450200);
INSERT INTO `dict_area` VALUES (450226, '三江侗族自治县', 450200);
INSERT INTO `dict_area` VALUES (450300, '桂林市', 450000);
INSERT INTO `dict_area` VALUES (450302, '秀峰区', 450300);
INSERT INTO `dict_area` VALUES (450303, '叠彩区', 450300);
INSERT INTO `dict_area` VALUES (450304, '象山区', 450300);
INSERT INTO `dict_area` VALUES (450305, '七星区', 450300);
INSERT INTO `dict_area` VALUES (450311, '雁山区', 450300);
INSERT INTO `dict_area` VALUES (450312, '临桂区', 450300);
INSERT INTO `dict_area` VALUES (450321, '阳朔县', 450300);
INSERT INTO `dict_area` VALUES (450323, '灵川县', 450300);
INSERT INTO `dict_area` VALUES (450324, '全州县', 450300);
INSERT INTO `dict_area` VALUES (450325, '兴安县', 450300);
INSERT INTO `dict_area` VALUES (450326, '永福县', 450300);
INSERT INTO `dict_area` VALUES (450327, '灌阳县', 450300);
INSERT INTO `dict_area` VALUES (450328, '龙胜各族自治县', 450300);
INSERT INTO `dict_area` VALUES (450329, '资源县', 450300);
INSERT INTO `dict_area` VALUES (450330, '平乐县', 450300);
INSERT INTO `dict_area` VALUES (450331, '荔浦县', 450300);
INSERT INTO `dict_area` VALUES (450332, '恭城瑶族自治县', 450300);
INSERT INTO `dict_area` VALUES (450400, '梧州市', 450000);
INSERT INTO `dict_area` VALUES (450403, '万秀区', 450400);
INSERT INTO `dict_area` VALUES (450405, '长洲区', 450400);
INSERT INTO `dict_area` VALUES (450406, '龙圩区', 450400);
INSERT INTO `dict_area` VALUES (450421, '苍梧县', 450400);
INSERT INTO `dict_area` VALUES (450422, '藤县', 450400);
INSERT INTO `dict_area` VALUES (450423, '蒙山县', 450400);
INSERT INTO `dict_area` VALUES (450481, '岑溪市', 450400);
INSERT INTO `dict_area` VALUES (450500, '北海市', 450000);
INSERT INTO `dict_area` VALUES (450502, '海城区', 450500);
INSERT INTO `dict_area` VALUES (450503, '银海区', 450500);
INSERT INTO `dict_area` VALUES (450512, '铁山港区', 450500);
INSERT INTO `dict_area` VALUES (450521, '合浦县', 450500);
INSERT INTO `dict_area` VALUES (450600, '防城港市', 450000);
INSERT INTO `dict_area` VALUES (450602, '港口区', 450600);
INSERT INTO `dict_area` VALUES (450603, '防城区', 450600);
INSERT INTO `dict_area` VALUES (450621, '上思县', 450600);
INSERT INTO `dict_area` VALUES (450681, '东兴市', 450600);
INSERT INTO `dict_area` VALUES (450700, '钦州市', 450000);
INSERT INTO `dict_area` VALUES (450702, '钦南区', 450700);
INSERT INTO `dict_area` VALUES (450703, '钦北区', 450700);
INSERT INTO `dict_area` VALUES (450721, '灵山县', 450700);
INSERT INTO `dict_area` VALUES (450722, '浦北县', 450700);
INSERT INTO `dict_area` VALUES (450800, '贵港市', 450000);
INSERT INTO `dict_area` VALUES (450802, '港北区', 450800);
INSERT INTO `dict_area` VALUES (450803, '港南区', 450800);
INSERT INTO `dict_area` VALUES (450804, '覃塘区', 450800);
INSERT INTO `dict_area` VALUES (450821, '平南县', 450800);
INSERT INTO `dict_area` VALUES (450881, '桂平市', 450800);
INSERT INTO `dict_area` VALUES (450900, '玉林市', 450000);
INSERT INTO `dict_area` VALUES (450902, '玉州区', 450900);
INSERT INTO `dict_area` VALUES (450903, '福绵区', 450900);
INSERT INTO `dict_area` VALUES (450921, '容县', 450900);
INSERT INTO `dict_area` VALUES (450922, '陆川县', 450900);
INSERT INTO `dict_area` VALUES (450923, '博白县', 450900);
INSERT INTO `dict_area` VALUES (450924, '兴业县', 450900);
INSERT INTO `dict_area` VALUES (450981, '北流市', 450900);
INSERT INTO `dict_area` VALUES (451000, '百色市', 450000);
INSERT INTO `dict_area` VALUES (451002, '右江区', 451000);
INSERT INTO `dict_area` VALUES (451021, '田阳县', 451000);
INSERT INTO `dict_area` VALUES (451022, '田东县', 451000);
INSERT INTO `dict_area` VALUES (451023, '平果县', 451000);
INSERT INTO `dict_area` VALUES (451024, '德保县', 451000);
INSERT INTO `dict_area` VALUES (451026, '那坡县', 451000);
INSERT INTO `dict_area` VALUES (451027, '凌云县', 451000);
INSERT INTO `dict_area` VALUES (451028, '乐业县', 451000);
INSERT INTO `dict_area` VALUES (451029, '田林县', 451000);
INSERT INTO `dict_area` VALUES (451030, '西林县', 451000);
INSERT INTO `dict_area` VALUES (451031, '隆林各族自治县', 451000);
INSERT INTO `dict_area` VALUES (451081, '靖西市', 451000);
INSERT INTO `dict_area` VALUES (451100, '贺州市', 450000);
INSERT INTO `dict_area` VALUES (451102, '八步区', 451100);
INSERT INTO `dict_area` VALUES (451103, '平桂区', 451100);
INSERT INTO `dict_area` VALUES (451121, '昭平县', 451100);
INSERT INTO `dict_area` VALUES (451122, '钟山县', 451100);
INSERT INTO `dict_area` VALUES (451123, '富川瑶族自治县', 451100);
INSERT INTO `dict_area` VALUES (451200, '河池市', 450000);
INSERT INTO `dict_area` VALUES (451202, '金城江区', 451200);
INSERT INTO `dict_area` VALUES (451203, '宜州区', 451200);
INSERT INTO `dict_area` VALUES (451221, '南丹县', 451200);
INSERT INTO `dict_area` VALUES (451222, '天峨县', 451200);
INSERT INTO `dict_area` VALUES (451223, '凤山县', 451200);
INSERT INTO `dict_area` VALUES (451224, '东兰县', 451200);
INSERT INTO `dict_area` VALUES (451225, '罗城仫佬族自治县', 451200);
INSERT INTO `dict_area` VALUES (451226, '环江毛南族自治县', 451200);
INSERT INTO `dict_area` VALUES (451227, '巴马瑶族自治县', 451200);
INSERT INTO `dict_area` VALUES (451228, '都安瑶族自治县', 451200);
INSERT INTO `dict_area` VALUES (451229, '大化瑶族自治县', 451200);
INSERT INTO `dict_area` VALUES (451300, '来宾市', 450000);
INSERT INTO `dict_area` VALUES (451302, '兴宾区', 451300);
INSERT INTO `dict_area` VALUES (451321, '忻城县', 451300);
INSERT INTO `dict_area` VALUES (451322, '象州县', 451300);
INSERT INTO `dict_area` VALUES (451323, '武宣县', 451300);
INSERT INTO `dict_area` VALUES (451324, '金秀瑶族自治县', 451300);
INSERT INTO `dict_area` VALUES (451381, '合山市', 451300);
INSERT INTO `dict_area` VALUES (451400, '崇左市', 450000);
INSERT INTO `dict_area` VALUES (451402, '江州区', 451400);
INSERT INTO `dict_area` VALUES (451421, '扶绥县', 451400);
INSERT INTO `dict_area` VALUES (451422, '宁明县', 451400);
INSERT INTO `dict_area` VALUES (451423, '龙州县', 451400);
INSERT INTO `dict_area` VALUES (451424, '大新县', 451400);
INSERT INTO `dict_area` VALUES (451425, '天等县', 451400);
INSERT INTO `dict_area` VALUES (451481, '凭祥市', 451400);
INSERT INTO `dict_area` VALUES (460000, '海南省', NULL);
INSERT INTO `dict_area` VALUES (460100, '海口市', 460000);
INSERT INTO `dict_area` VALUES (460105, '秀英区', 460100);
INSERT INTO `dict_area` VALUES (460106, '龙华区', 460100);
INSERT INTO `dict_area` VALUES (460107, '琼山区', 460100);
INSERT INTO `dict_area` VALUES (460108, '美兰区', 460100);
INSERT INTO `dict_area` VALUES (460200, '三亚市', 460000);
INSERT INTO `dict_area` VALUES (460202, '海棠区', 460200);
INSERT INTO `dict_area` VALUES (460203, '吉阳区', 460200);
INSERT INTO `dict_area` VALUES (460204, '天涯区', 460200);
INSERT INTO `dict_area` VALUES (460205, '崖州区', 460200);
INSERT INTO `dict_area` VALUES (460300, '三沙市', 460000);
INSERT INTO `dict_area` VALUES (460321, '西沙群岛', 460300);
INSERT INTO `dict_area` VALUES (460322, '南沙群岛', 460300);
INSERT INTO `dict_area` VALUES (460323, '中沙群岛的岛礁及其海域', 460300);
INSERT INTO `dict_area` VALUES (460400, '儋州市', 460000);
INSERT INTO `dict_area` VALUES (460500, '五指山市', 460000);
INSERT INTO `dict_area` VALUES (460600, '琼海市', 460000);
INSERT INTO `dict_area` VALUES (460700, '文昌市', 460000);
INSERT INTO `dict_area` VALUES (460800, '万宁市', 460000);
INSERT INTO `dict_area` VALUES (460900, '东方市', 460000);
INSERT INTO `dict_area` VALUES (461000, '定安县', 460000);
INSERT INTO `dict_area` VALUES (461100, '屯昌县', 460000);
INSERT INTO `dict_area` VALUES (461200, '澄迈县', 460000);
INSERT INTO `dict_area` VALUES (461300, '临高县', 460000);
INSERT INTO `dict_area` VALUES (461400, '白沙黎族自治县', 460000);
INSERT INTO `dict_area` VALUES (461500, '昌江黎族自治县', 460000);
INSERT INTO `dict_area` VALUES (461600, '乐东黎族自治县', 460000);
INSERT INTO `dict_area` VALUES (461700, '陵水黎族自治县', 460000);
INSERT INTO `dict_area` VALUES (461800, '保亭黎族苗族自治县', 460000);
INSERT INTO `dict_area` VALUES (461900, '琼中黎族苗族自治县', 460000);
INSERT INTO `dict_area` VALUES (500000, '重庆市', NULL);
INSERT INTO `dict_area` VALUES (500101, '万州区', 500000);
INSERT INTO `dict_area` VALUES (500102, '涪陵区', 500000);
INSERT INTO `dict_area` VALUES (500103, '渝中区', 500000);
INSERT INTO `dict_area` VALUES (500104, '大渡口区', 500000);
INSERT INTO `dict_area` VALUES (500105, '江北区', 500000);
INSERT INTO `dict_area` VALUES (500106, '沙坪坝区', 500000);
INSERT INTO `dict_area` VALUES (500107, '九龙坡区', 500000);
INSERT INTO `dict_area` VALUES (500108, '南岸区', 500000);
INSERT INTO `dict_area` VALUES (500109, '北碚区', 500000);
INSERT INTO `dict_area` VALUES (500110, '綦江区', 500000);
INSERT INTO `dict_area` VALUES (500111, '大足区', 500000);
INSERT INTO `dict_area` VALUES (500112, '渝北区', 500000);
INSERT INTO `dict_area` VALUES (500113, '巴南区', 500000);
INSERT INTO `dict_area` VALUES (500114, '黔江区', 500000);
INSERT INTO `dict_area` VALUES (500115, '长寿区', 500000);
INSERT INTO `dict_area` VALUES (500116, '江津区', 500000);
INSERT INTO `dict_area` VALUES (500117, '合川区', 500000);
INSERT INTO `dict_area` VALUES (500118, '永川区', 500000);
INSERT INTO `dict_area` VALUES (500119, '南川区', 500000);
INSERT INTO `dict_area` VALUES (500120, '璧山区', 500000);
INSERT INTO `dict_area` VALUES (500151, '铜梁区', 500000);
INSERT INTO `dict_area` VALUES (500152, '潼南区', 500000);
INSERT INTO `dict_area` VALUES (500153, '荣昌区', 500000);
INSERT INTO `dict_area` VALUES (500154, '开州区', 500000);
INSERT INTO `dict_area` VALUES (500155, '梁平区', 500000);
INSERT INTO `dict_area` VALUES (500156, '武隆区', 500000);
INSERT INTO `dict_area` VALUES (500229, '城口县', 500000);
INSERT INTO `dict_area` VALUES (500230, '丰都县', 500000);
INSERT INTO `dict_area` VALUES (500231, '垫江县', 500000);
INSERT INTO `dict_area` VALUES (500233, '忠县', 500000);
INSERT INTO `dict_area` VALUES (500235, '云阳县', 500000);
INSERT INTO `dict_area` VALUES (500236, '奉节县', 500000);
INSERT INTO `dict_area` VALUES (500237, '巫山县', 500000);
INSERT INTO `dict_area` VALUES (500238, '巫溪县', 500000);
INSERT INTO `dict_area` VALUES (500240, '石柱土家族自治县', 500000);
INSERT INTO `dict_area` VALUES (500241, '秀山土家族苗族自治县', 500000);
INSERT INTO `dict_area` VALUES (500242, '酉阳土家族苗族自治县', 500000);
INSERT INTO `dict_area` VALUES (500243, '彭水苗族土家族自治县', 500000);
INSERT INTO `dict_area` VALUES (510000, '四川省', NULL);
INSERT INTO `dict_area` VALUES (510100, '成都市', 510000);
INSERT INTO `dict_area` VALUES (510104, '锦江区', 510100);
INSERT INTO `dict_area` VALUES (510105, '青羊区', 510100);
INSERT INTO `dict_area` VALUES (510106, '金牛区', 510100);
INSERT INTO `dict_area` VALUES (510107, '武侯区', 510100);
INSERT INTO `dict_area` VALUES (510108, '成华区', 510100);
INSERT INTO `dict_area` VALUES (510112, '龙泉驿区', 510100);
INSERT INTO `dict_area` VALUES (510113, '青白江区', 510100);
INSERT INTO `dict_area` VALUES (510114, '新都区', 510100);
INSERT INTO `dict_area` VALUES (510115, '温江区', 510100);
INSERT INTO `dict_area` VALUES (510116, '双流区', 510100);
INSERT INTO `dict_area` VALUES (510117, '郫都区', 510100);
INSERT INTO `dict_area` VALUES (510121, '金堂县', 510100);
INSERT INTO `dict_area` VALUES (510129, '大邑县', 510100);
INSERT INTO `dict_area` VALUES (510131, '蒲江县', 510100);
INSERT INTO `dict_area` VALUES (510132, '新津县', 510100);
INSERT INTO `dict_area` VALUES (510181, '都江堰市', 510100);
INSERT INTO `dict_area` VALUES (510182, '彭州市', 510100);
INSERT INTO `dict_area` VALUES (510183, '邛崃市', 510100);
INSERT INTO `dict_area` VALUES (510184, '崇州市', 510100);
INSERT INTO `dict_area` VALUES (510185, '简阳市', 510100);
INSERT INTO `dict_area` VALUES (510300, '自贡市', 510000);
INSERT INTO `dict_area` VALUES (510302, '自流井区', 510300);
INSERT INTO `dict_area` VALUES (510303, '贡井区', 510300);
INSERT INTO `dict_area` VALUES (510304, '大安区', 510300);
INSERT INTO `dict_area` VALUES (510311, '沿滩区', 510300);
INSERT INTO `dict_area` VALUES (510321, '荣县', 510300);
INSERT INTO `dict_area` VALUES (510322, '富顺县', 510300);
INSERT INTO `dict_area` VALUES (510400, '攀枝花市', 510000);
INSERT INTO `dict_area` VALUES (510402, '东区', 510400);
INSERT INTO `dict_area` VALUES (510403, '西区', 510400);
INSERT INTO `dict_area` VALUES (510411, '仁和区', 510400);
INSERT INTO `dict_area` VALUES (510421, '米易县', 510400);
INSERT INTO `dict_area` VALUES (510422, '盐边县', 510400);
INSERT INTO `dict_area` VALUES (510500, '泸州市', 510000);
INSERT INTO `dict_area` VALUES (510502, '江阳区', 510500);
INSERT INTO `dict_area` VALUES (510503, '纳溪区', 510500);
INSERT INTO `dict_area` VALUES (510504, '龙马潭区', 510500);
INSERT INTO `dict_area` VALUES (510521, '泸县', 510500);
INSERT INTO `dict_area` VALUES (510522, '合江县', 510500);
INSERT INTO `dict_area` VALUES (510524, '叙永县', 510500);
INSERT INTO `dict_area` VALUES (510525, '古蔺县', 510500);
INSERT INTO `dict_area` VALUES (510600, '德阳市', 510000);
INSERT INTO `dict_area` VALUES (510603, '旌阳区', 510600);
INSERT INTO `dict_area` VALUES (510623, '中江县', 510600);
INSERT INTO `dict_area` VALUES (510626, '罗江县', 510600);
INSERT INTO `dict_area` VALUES (510681, '广汉市', 510600);
INSERT INTO `dict_area` VALUES (510682, '什邡市', 510600);
INSERT INTO `dict_area` VALUES (510683, '绵竹市', 510600);
INSERT INTO `dict_area` VALUES (510700, '绵阳市', 510000);
INSERT INTO `dict_area` VALUES (510703, '涪城区', 510700);
INSERT INTO `dict_area` VALUES (510704, '游仙区', 510700);
INSERT INTO `dict_area` VALUES (510705, '安州区', 510700);
INSERT INTO `dict_area` VALUES (510722, '三台县', 510700);
INSERT INTO `dict_area` VALUES (510723, '盐亭县', 510700);
INSERT INTO `dict_area` VALUES (510725, '梓潼县', 510700);
INSERT INTO `dict_area` VALUES (510726, '北川羌族自治县', 510700);
INSERT INTO `dict_area` VALUES (510727, '平武县', 510700);
INSERT INTO `dict_area` VALUES (510781, '江油市', 510700);
INSERT INTO `dict_area` VALUES (510800, '广元市', 510000);
INSERT INTO `dict_area` VALUES (510802, '利州区', 510800);
INSERT INTO `dict_area` VALUES (510811, '昭化区', 510800);
INSERT INTO `dict_area` VALUES (510812, '朝天区', 510800);
INSERT INTO `dict_area` VALUES (510821, '旺苍县', 510800);
INSERT INTO `dict_area` VALUES (510822, '青川县', 510800);
INSERT INTO `dict_area` VALUES (510823, '剑阁县', 510800);
INSERT INTO `dict_area` VALUES (510824, '苍溪县', 510800);
INSERT INTO `dict_area` VALUES (510900, '遂宁市', 510000);
INSERT INTO `dict_area` VALUES (510903, '船山区', 510900);
INSERT INTO `dict_area` VALUES (510904, '安居区', 510900);
INSERT INTO `dict_area` VALUES (510921, '蓬溪县', 510900);
INSERT INTO `dict_area` VALUES (510922, '射洪县', 510900);
INSERT INTO `dict_area` VALUES (510923, '大英县', 510900);
INSERT INTO `dict_area` VALUES (511000, '内江市', 510000);
INSERT INTO `dict_area` VALUES (511002, '市中区', 511000);
INSERT INTO `dict_area` VALUES (511011, '东兴区', 511000);
INSERT INTO `dict_area` VALUES (511024, '威远县', 511000);
INSERT INTO `dict_area` VALUES (511025, '资中县', 511000);
INSERT INTO `dict_area` VALUES (511083, '隆昌市', 511000);
INSERT INTO `dict_area` VALUES (511100, '乐山市', 510000);
INSERT INTO `dict_area` VALUES (511102, '市中区', 511100);
INSERT INTO `dict_area` VALUES (511111, '沙湾区', 511100);
INSERT INTO `dict_area` VALUES (511112, '五通桥区', 511100);
INSERT INTO `dict_area` VALUES (511113, '金口河区', 511100);
INSERT INTO `dict_area` VALUES (511123, '犍为县', 511100);
INSERT INTO `dict_area` VALUES (511124, '井研县', 511100);
INSERT INTO `dict_area` VALUES (511126, '夹江县', 511100);
INSERT INTO `dict_area` VALUES (511129, '沐川县', 511100);
INSERT INTO `dict_area` VALUES (511132, '峨边彝族自治县', 511100);
INSERT INTO `dict_area` VALUES (511133, '马边彝族自治县', 511100);
INSERT INTO `dict_area` VALUES (511181, '峨眉山市', 511100);
INSERT INTO `dict_area` VALUES (511300, '南充市', 510000);
INSERT INTO `dict_area` VALUES (511302, '顺庆区', 511300);
INSERT INTO `dict_area` VALUES (511303, '高坪区', 511300);
INSERT INTO `dict_area` VALUES (511304, '嘉陵区', 511300);
INSERT INTO `dict_area` VALUES (511321, '南部县', 511300);
INSERT INTO `dict_area` VALUES (511322, '营山县', 511300);
INSERT INTO `dict_area` VALUES (511323, '蓬安县', 511300);
INSERT INTO `dict_area` VALUES (511324, '仪陇县', 511300);
INSERT INTO `dict_area` VALUES (511325, '西充县', 511300);
INSERT INTO `dict_area` VALUES (511381, '阆中市', 511300);
INSERT INTO `dict_area` VALUES (511400, '眉山市', 510000);
INSERT INTO `dict_area` VALUES (511402, '东坡区', 511400);
INSERT INTO `dict_area` VALUES (511403, '彭山区', 511400);
INSERT INTO `dict_area` VALUES (511421, '仁寿县', 511400);
INSERT INTO `dict_area` VALUES (511423, '洪雅县', 511400);
INSERT INTO `dict_area` VALUES (511424, '丹棱县', 511400);
INSERT INTO `dict_area` VALUES (511425, '青神县', 511400);
INSERT INTO `dict_area` VALUES (511500, '宜宾市', 510000);
INSERT INTO `dict_area` VALUES (511502, '翠屏区', 511500);
INSERT INTO `dict_area` VALUES (511503, '南溪区', 511500);
INSERT INTO `dict_area` VALUES (511521, '宜宾县', 511500);
INSERT INTO `dict_area` VALUES (511523, '江安县', 511500);
INSERT INTO `dict_area` VALUES (511524, '长宁县', 511500);
INSERT INTO `dict_area` VALUES (511525, '高县', 511500);
INSERT INTO `dict_area` VALUES (511526, '珙县', 511500);
INSERT INTO `dict_area` VALUES (511527, '筠连县', 511500);
INSERT INTO `dict_area` VALUES (511528, '兴文县', 511500);
INSERT INTO `dict_area` VALUES (511529, '屏山县', 511500);
INSERT INTO `dict_area` VALUES (511600, '广安市', 510000);
INSERT INTO `dict_area` VALUES (511602, '广安区', 511600);
INSERT INTO `dict_area` VALUES (511603, '前锋区', 511600);
INSERT INTO `dict_area` VALUES (511621, '岳池县', 511600);
INSERT INTO `dict_area` VALUES (511622, '武胜县', 511600);
INSERT INTO `dict_area` VALUES (511623, '邻水县', 511600);
INSERT INTO `dict_area` VALUES (511681, '华蓥市', 511600);
INSERT INTO `dict_area` VALUES (511700, '达州市', 510000);
INSERT INTO `dict_area` VALUES (511702, '通川区', 511700);
INSERT INTO `dict_area` VALUES (511703, '达川区', 511700);
INSERT INTO `dict_area` VALUES (511722, '宣汉县', 511700);
INSERT INTO `dict_area` VALUES (511723, '开江县', 511700);
INSERT INTO `dict_area` VALUES (511724, '大竹县', 511700);
INSERT INTO `dict_area` VALUES (511725, '渠县', 511700);
INSERT INTO `dict_area` VALUES (511781, '万源市', 511700);
INSERT INTO `dict_area` VALUES (511800, '雅安市', 510000);
INSERT INTO `dict_area` VALUES (511802, '雨城区', 511800);
INSERT INTO `dict_area` VALUES (511803, '名山区', 511800);
INSERT INTO `dict_area` VALUES (511822, '荥经县', 511800);
INSERT INTO `dict_area` VALUES (511823, '汉源县', 511800);
INSERT INTO `dict_area` VALUES (511824, '石棉县', 511800);
INSERT INTO `dict_area` VALUES (511825, '天全县', 511800);
INSERT INTO `dict_area` VALUES (511826, '芦山县', 511800);
INSERT INTO `dict_area` VALUES (511827, '宝兴县', 511800);
INSERT INTO `dict_area` VALUES (511900, '巴中市', 510000);
INSERT INTO `dict_area` VALUES (511902, '巴州区', 511900);
INSERT INTO `dict_area` VALUES (511903, '恩阳区', 511900);
INSERT INTO `dict_area` VALUES (511921, '通江县', 511900);
INSERT INTO `dict_area` VALUES (511922, '南江县', 511900);
INSERT INTO `dict_area` VALUES (511923, '平昌县', 511900);
INSERT INTO `dict_area` VALUES (512000, '资阳市', 510000);
INSERT INTO `dict_area` VALUES (512002, '雁江区', 512000);
INSERT INTO `dict_area` VALUES (512021, '安岳县', 512000);
INSERT INTO `dict_area` VALUES (512022, '乐至县', 512000);
INSERT INTO `dict_area` VALUES (513200, '阿坝藏族羌族自治州', 510000);
INSERT INTO `dict_area` VALUES (513201, '马尔康市', 513200);
INSERT INTO `dict_area` VALUES (513221, '汶川县', 513200);
INSERT INTO `dict_area` VALUES (513222, '理县', 513200);
INSERT INTO `dict_area` VALUES (513223, '茂县', 513200);
INSERT INTO `dict_area` VALUES (513224, '松潘县', 513200);
INSERT INTO `dict_area` VALUES (513225, '九寨沟县', 513200);
INSERT INTO `dict_area` VALUES (513226, '金川县', 513200);
INSERT INTO `dict_area` VALUES (513227, '小金县', 513200);
INSERT INTO `dict_area` VALUES (513228, '黑水县', 513200);
INSERT INTO `dict_area` VALUES (513230, '壤塘县', 513200);
INSERT INTO `dict_area` VALUES (513231, '阿坝县', 513200);
INSERT INTO `dict_area` VALUES (513232, '若尔盖县', 513200);
INSERT INTO `dict_area` VALUES (513233, '红原县', 513200);
INSERT INTO `dict_area` VALUES (513300, '甘孜藏族自治州', 510000);
INSERT INTO `dict_area` VALUES (513301, '康定市', 513300);
INSERT INTO `dict_area` VALUES (513322, '泸定县', 513300);
INSERT INTO `dict_area` VALUES (513323, '丹巴县', 513300);
INSERT INTO `dict_area` VALUES (513324, '九龙县', 513300);
INSERT INTO `dict_area` VALUES (513325, '雅江县', 513300);
INSERT INTO `dict_area` VALUES (513326, '道孚县', 513300);
INSERT INTO `dict_area` VALUES (513327, '炉霍县', 513300);
INSERT INTO `dict_area` VALUES (513328, '甘孜县', 513300);
INSERT INTO `dict_area` VALUES (513329, '新龙县', 513300);
INSERT INTO `dict_area` VALUES (513330, '德格县', 513300);
INSERT INTO `dict_area` VALUES (513331, '白玉县', 513300);
INSERT INTO `dict_area` VALUES (513332, '石渠县', 513300);
INSERT INTO `dict_area` VALUES (513333, '色达县', 513300);
INSERT INTO `dict_area` VALUES (513334, '理塘县', 513300);
INSERT INTO `dict_area` VALUES (513335, '巴塘县', 513300);
INSERT INTO `dict_area` VALUES (513336, '乡城县', 513300);
INSERT INTO `dict_area` VALUES (513337, '稻城县', 513300);
INSERT INTO `dict_area` VALUES (513338, '得荣县', 513300);
INSERT INTO `dict_area` VALUES (513400, '凉山彝族自治州', 510000);
INSERT INTO `dict_area` VALUES (513401, '西昌市', 513400);
INSERT INTO `dict_area` VALUES (513422, '木里藏族自治县', 513400);
INSERT INTO `dict_area` VALUES (513423, '盐源县', 513400);
INSERT INTO `dict_area` VALUES (513424, '德昌县', 513400);
INSERT INTO `dict_area` VALUES (513425, '会理县', 513400);
INSERT INTO `dict_area` VALUES (513426, '会东县', 513400);
INSERT INTO `dict_area` VALUES (513427, '宁南县', 513400);
INSERT INTO `dict_area` VALUES (513428, '普格县', 513400);
INSERT INTO `dict_area` VALUES (513429, '布拖县', 513400);
INSERT INTO `dict_area` VALUES (513430, '金阳县', 513400);
INSERT INTO `dict_area` VALUES (513431, '昭觉县', 513400);
INSERT INTO `dict_area` VALUES (513432, '喜德县', 513400);
INSERT INTO `dict_area` VALUES (513433, '冕宁县', 513400);
INSERT INTO `dict_area` VALUES (513434, '越西县', 513400);
INSERT INTO `dict_area` VALUES (513435, '甘洛县', 513400);
INSERT INTO `dict_area` VALUES (513436, '美姑县', 513400);
INSERT INTO `dict_area` VALUES (513437, '雷波县', 513400);
INSERT INTO `dict_area` VALUES (520000, '贵州省', NULL);
INSERT INTO `dict_area` VALUES (520100, '贵阳市', 520000);
INSERT INTO `dict_area` VALUES (520102, '南明区', 520100);
INSERT INTO `dict_area` VALUES (520103, '云岩区', 520100);
INSERT INTO `dict_area` VALUES (520111, '花溪区', 520100);
INSERT INTO `dict_area` VALUES (520112, '乌当区', 520100);
INSERT INTO `dict_area` VALUES (520113, '白云区', 520100);
INSERT INTO `dict_area` VALUES (520115, '观山湖区', 520100);
INSERT INTO `dict_area` VALUES (520121, '开阳县', 520100);
INSERT INTO `dict_area` VALUES (520122, '息烽县', 520100);
INSERT INTO `dict_area` VALUES (520123, '修文县', 520100);
INSERT INTO `dict_area` VALUES (520181, '清镇市', 520100);
INSERT INTO `dict_area` VALUES (520200, '六盘水市', 520000);
INSERT INTO `dict_area` VALUES (520201, '钟山区', 520200);
INSERT INTO `dict_area` VALUES (520203, '六枝特区', 520200);
INSERT INTO `dict_area` VALUES (520221, '水城县', 520200);
INSERT INTO `dict_area` VALUES (520281, '盘州市', 520200);
INSERT INTO `dict_area` VALUES (520300, '遵义市', 520000);
INSERT INTO `dict_area` VALUES (520302, '红花岗区', 520300);
INSERT INTO `dict_area` VALUES (520303, '汇川区', 520300);
INSERT INTO `dict_area` VALUES (520304, '播州区', 520300);
INSERT INTO `dict_area` VALUES (520322, '桐梓县', 520300);
INSERT INTO `dict_area` VALUES (520323, '绥阳县', 520300);
INSERT INTO `dict_area` VALUES (520324, '正安县', 520300);
INSERT INTO `dict_area` VALUES (520325, '道真仡佬族苗族自治县', 520300);
INSERT INTO `dict_area` VALUES (520326, '务川仡佬族苗族自治县', 520300);
INSERT INTO `dict_area` VALUES (520327, '凤冈县', 520300);
INSERT INTO `dict_area` VALUES (520328, '湄潭县', 520300);
INSERT INTO `dict_area` VALUES (520329, '余庆县', 520300);
INSERT INTO `dict_area` VALUES (520330, '习水县', 520300);
INSERT INTO `dict_area` VALUES (520381, '赤水市', 520300);
INSERT INTO `dict_area` VALUES (520382, '仁怀市', 520300);
INSERT INTO `dict_area` VALUES (520400, '安顺市', 520000);
INSERT INTO `dict_area` VALUES (520402, '西秀区', 520400);
INSERT INTO `dict_area` VALUES (520403, '平坝区', 520400);
INSERT INTO `dict_area` VALUES (520422, '普定县', 520400);
INSERT INTO `dict_area` VALUES (520423, '镇宁布依族苗族自治县', 520400);
INSERT INTO `dict_area` VALUES (520424, '关岭布依族苗族自治县', 520400);
INSERT INTO `dict_area` VALUES (520425, '紫云苗族布依族自治县', 520400);
INSERT INTO `dict_area` VALUES (520500, '毕节市', 520000);
INSERT INTO `dict_area` VALUES (520502, '七星关区', 520500);
INSERT INTO `dict_area` VALUES (520521, '大方县', 520500);
INSERT INTO `dict_area` VALUES (520522, '黔西县', 520500);
INSERT INTO `dict_area` VALUES (520523, '金沙县', 520500);
INSERT INTO `dict_area` VALUES (520524, '织金县', 520500);
INSERT INTO `dict_area` VALUES (520525, '纳雍县', 520500);
INSERT INTO `dict_area` VALUES (520526, '威宁彝族回族苗族自治县', 520500);
INSERT INTO `dict_area` VALUES (520527, '赫章县', 520500);
INSERT INTO `dict_area` VALUES (520600, '铜仁市', 520000);
INSERT INTO `dict_area` VALUES (520602, '碧江区', 520600);
INSERT INTO `dict_area` VALUES (520603, '万山区', 520600);
INSERT INTO `dict_area` VALUES (520621, '江口县', 520600);
INSERT INTO `dict_area` VALUES (520622, '玉屏侗族自治县', 520600);
INSERT INTO `dict_area` VALUES (520623, '石阡县', 520600);
INSERT INTO `dict_area` VALUES (520624, '思南县', 520600);
INSERT INTO `dict_area` VALUES (520625, '印江土家族苗族自治县', 520600);
INSERT INTO `dict_area` VALUES (520626, '德江县', 520600);
INSERT INTO `dict_area` VALUES (520627, '沿河土家族自治县', 520600);
INSERT INTO `dict_area` VALUES (520628, '松桃苗族自治县', 520600);
INSERT INTO `dict_area` VALUES (522300, '黔西南布依族苗族自治州', 520000);
INSERT INTO `dict_area` VALUES (522301, '兴义市', 522300);
INSERT INTO `dict_area` VALUES (522322, '兴仁县', 522300);
INSERT INTO `dict_area` VALUES (522323, '普安县', 522300);
INSERT INTO `dict_area` VALUES (522324, '晴隆县', 522300);
INSERT INTO `dict_area` VALUES (522325, '贞丰县', 522300);
INSERT INTO `dict_area` VALUES (522326, '望谟县', 522300);
INSERT INTO `dict_area` VALUES (522327, '册亨县', 522300);
INSERT INTO `dict_area` VALUES (522328, '安龙县', 522300);
INSERT INTO `dict_area` VALUES (522600, '黔东南苗族侗族自治州', 520000);
INSERT INTO `dict_area` VALUES (522601, '凯里市', 522600);
INSERT INTO `dict_area` VALUES (522622, '黄平县', 522600);
INSERT INTO `dict_area` VALUES (522623, '施秉县', 522600);
INSERT INTO `dict_area` VALUES (522624, '三穗县', 522600);
INSERT INTO `dict_area` VALUES (522625, '镇远县', 522600);
INSERT INTO `dict_area` VALUES (522626, '岑巩县', 522600);
INSERT INTO `dict_area` VALUES (522627, '天柱县', 522600);
INSERT INTO `dict_area` VALUES (522628, '锦屏县', 522600);
INSERT INTO `dict_area` VALUES (522629, '剑河县', 522600);
INSERT INTO `dict_area` VALUES (522630, '台江县', 522600);
INSERT INTO `dict_area` VALUES (522631, '黎平县', 522600);
INSERT INTO `dict_area` VALUES (522632, '榕江县', 522600);
INSERT INTO `dict_area` VALUES (522633, '从江县', 522600);
INSERT INTO `dict_area` VALUES (522634, '雷山县', 522600);
INSERT INTO `dict_area` VALUES (522635, '麻江县', 522600);
INSERT INTO `dict_area` VALUES (522636, '丹寨县', 522600);
INSERT INTO `dict_area` VALUES (522700, '黔南布依族苗族自治州', 520000);
INSERT INTO `dict_area` VALUES (522701, '都匀市', 522700);
INSERT INTO `dict_area` VALUES (522702, '福泉市', 522700);
INSERT INTO `dict_area` VALUES (522722, '荔波县', 522700);
INSERT INTO `dict_area` VALUES (522723, '贵定县', 522700);
INSERT INTO `dict_area` VALUES (522725, '瓮安县', 522700);
INSERT INTO `dict_area` VALUES (522726, '独山县', 522700);
INSERT INTO `dict_area` VALUES (522727, '平塘县', 522700);
INSERT INTO `dict_area` VALUES (522728, '罗甸县', 522700);
INSERT INTO `dict_area` VALUES (522729, '长顺县', 522700);
INSERT INTO `dict_area` VALUES (522730, '龙里县', 522700);
INSERT INTO `dict_area` VALUES (522731, '惠水县', 522700);
INSERT INTO `dict_area` VALUES (522732, '三都水族自治县', 522700);
INSERT INTO `dict_area` VALUES (530000, '云南省', NULL);
INSERT INTO `dict_area` VALUES (530100, '昆明市', 530000);
INSERT INTO `dict_area` VALUES (530102, '五华区', 530100);
INSERT INTO `dict_area` VALUES (530103, '盘龙区', 530100);
INSERT INTO `dict_area` VALUES (530111, '官渡区', 530100);
INSERT INTO `dict_area` VALUES (530112, '西山区', 530100);
INSERT INTO `dict_area` VALUES (530113, '东川区', 530100);
INSERT INTO `dict_area` VALUES (530114, '呈贡区', 530100);
INSERT INTO `dict_area` VALUES (530115, '晋宁区', 530100);
INSERT INTO `dict_area` VALUES (530124, '富民县', 530100);
INSERT INTO `dict_area` VALUES (530125, '宜良县', 530100);
INSERT INTO `dict_area` VALUES (530126, '石林彝族自治县', 530100);
INSERT INTO `dict_area` VALUES (530127, '嵩明县', 530100);
INSERT INTO `dict_area` VALUES (530128, '禄劝彝族苗族自治县', 530100);
INSERT INTO `dict_area` VALUES (530129, '寻甸回族彝族自治县', 530100);
INSERT INTO `dict_area` VALUES (530181, '安宁市', 530100);
INSERT INTO `dict_area` VALUES (530300, '曲靖市', 530000);
INSERT INTO `dict_area` VALUES (530302, '麒麟区', 530300);
INSERT INTO `dict_area` VALUES (530303, '沾益区', 530300);
INSERT INTO `dict_area` VALUES (530321, '马龙县', 530300);
INSERT INTO `dict_area` VALUES (530322, '陆良县', 530300);
INSERT INTO `dict_area` VALUES (530323, '师宗县', 530300);
INSERT INTO `dict_area` VALUES (530324, '罗平县', 530300);
INSERT INTO `dict_area` VALUES (530325, '富源县', 530300);
INSERT INTO `dict_area` VALUES (530326, '会泽县', 530300);
INSERT INTO `dict_area` VALUES (530381, '宣威市', 530300);
INSERT INTO `dict_area` VALUES (530400, '玉溪市', 530000);
INSERT INTO `dict_area` VALUES (530402, '红塔区', 530400);
INSERT INTO `dict_area` VALUES (530403, '江川区', 530400);
INSERT INTO `dict_area` VALUES (530422, '澄江县', 530400);
INSERT INTO `dict_area` VALUES (530423, '通海县', 530400);
INSERT INTO `dict_area` VALUES (530424, '华宁县', 530400);
INSERT INTO `dict_area` VALUES (530425, '易门县', 530400);
INSERT INTO `dict_area` VALUES (530426, '峨山彝族自治县', 530400);
INSERT INTO `dict_area` VALUES (530427, '新平彝族傣族自治县', 530400);
INSERT INTO `dict_area` VALUES (530428, '元江哈尼族彝族傣族自治县', 530400);
INSERT INTO `dict_area` VALUES (530500, '保山市', 530000);
INSERT INTO `dict_area` VALUES (530502, '隆阳区', 530500);
INSERT INTO `dict_area` VALUES (530521, '施甸县', 530500);
INSERT INTO `dict_area` VALUES (530523, '龙陵县', 530500);
INSERT INTO `dict_area` VALUES (530524, '昌宁县', 530500);
INSERT INTO `dict_area` VALUES (530581, '腾冲市', 530500);
INSERT INTO `dict_area` VALUES (530600, '昭通市', 530000);
INSERT INTO `dict_area` VALUES (530602, '昭阳区', 530600);
INSERT INTO `dict_area` VALUES (530621, '鲁甸县', 530600);
INSERT INTO `dict_area` VALUES (530622, '巧家县', 530600);
INSERT INTO `dict_area` VALUES (530623, '盐津县', 530600);
INSERT INTO `dict_area` VALUES (530624, '大关县', 530600);
INSERT INTO `dict_area` VALUES (530625, '永善县', 530600);
INSERT INTO `dict_area` VALUES (530626, '绥江县', 530600);
INSERT INTO `dict_area` VALUES (530627, '镇雄县', 530600);
INSERT INTO `dict_area` VALUES (530628, '彝良县', 530600);
INSERT INTO `dict_area` VALUES (530629, '威信县', 530600);
INSERT INTO `dict_area` VALUES (530630, '水富县', 530600);
INSERT INTO `dict_area` VALUES (530700, '丽江市', 530000);
INSERT INTO `dict_area` VALUES (530702, '古城区', 530700);
INSERT INTO `dict_area` VALUES (530721, '玉龙纳西族自治县', 530700);
INSERT INTO `dict_area` VALUES (530722, '永胜县', 530700);
INSERT INTO `dict_area` VALUES (530723, '华坪县', 530700);
INSERT INTO `dict_area` VALUES (530724, '宁蒗彝族自治县', 530700);
INSERT INTO `dict_area` VALUES (530800, '普洱市', 530000);
INSERT INTO `dict_area` VALUES (530802, '思茅区', 530800);
INSERT INTO `dict_area` VALUES (530821, '宁洱哈尼族彝族自治县', 530800);
INSERT INTO `dict_area` VALUES (530822, '墨江哈尼族自治县', 530800);
INSERT INTO `dict_area` VALUES (530823, '景东彝族自治县', 530800);
INSERT INTO `dict_area` VALUES (530824, '景谷傣族彝族自治县', 530800);
INSERT INTO `dict_area` VALUES (530825, '镇沅彝族哈尼族拉祜族自治县', 530800);
INSERT INTO `dict_area` VALUES (530826, '江城哈尼族彝族自治县', 530800);
INSERT INTO `dict_area` VALUES (530827, '孟连傣族拉祜族佤族自治县', 530800);
INSERT INTO `dict_area` VALUES (530828, '澜沧拉祜族自治县', 530800);
INSERT INTO `dict_area` VALUES (530829, '西盟佤族自治县', 530800);
INSERT INTO `dict_area` VALUES (530900, '临沧市', 530000);
INSERT INTO `dict_area` VALUES (530902, '临翔区', 530900);
INSERT INTO `dict_area` VALUES (530921, '凤庆县', 530900);
INSERT INTO `dict_area` VALUES (530922, '云县', 530900);
INSERT INTO `dict_area` VALUES (530923, '永德县', 530900);
INSERT INTO `dict_area` VALUES (530924, '镇康县', 530900);
INSERT INTO `dict_area` VALUES (530925, '双江拉祜族佤族布朗族傣族自治县', 530900);
INSERT INTO `dict_area` VALUES (530926, '耿马傣族佤族自治县', 530900);
INSERT INTO `dict_area` VALUES (530927, '沧源佤族自治县', 530900);
INSERT INTO `dict_area` VALUES (532300, '楚雄彝族自治州', 530000);
INSERT INTO `dict_area` VALUES (532301, '楚雄市', 532300);
INSERT INTO `dict_area` VALUES (532322, '双柏县', 532300);
INSERT INTO `dict_area` VALUES (532323, '牟定县', 532300);
INSERT INTO `dict_area` VALUES (532324, '南华县', 532300);
INSERT INTO `dict_area` VALUES (532325, '姚安县', 532300);
INSERT INTO `dict_area` VALUES (532326, '大姚县', 532300);
INSERT INTO `dict_area` VALUES (532327, '永仁县', 532300);
INSERT INTO `dict_area` VALUES (532328, '元谋县', 532300);
INSERT INTO `dict_area` VALUES (532329, '武定县', 532300);
INSERT INTO `dict_area` VALUES (532331, '禄丰县', 532300);
INSERT INTO `dict_area` VALUES (532500, '红河哈尼族彝族自治州', 530000);
INSERT INTO `dict_area` VALUES (532501, '个旧市', 532500);
INSERT INTO `dict_area` VALUES (532502, '开远市', 532500);
INSERT INTO `dict_area` VALUES (532503, '蒙自市', 532500);
INSERT INTO `dict_area` VALUES (532504, '弥勒市', 532500);
INSERT INTO `dict_area` VALUES (532523, '屏边苗族自治县', 532500);
INSERT INTO `dict_area` VALUES (532524, '建水县', 532500);
INSERT INTO `dict_area` VALUES (532525, '石屏县', 532500);
INSERT INTO `dict_area` VALUES (532527, '泸西县', 532500);
INSERT INTO `dict_area` VALUES (532528, '元阳县', 532500);
INSERT INTO `dict_area` VALUES (532529, '红河县', 532500);
INSERT INTO `dict_area` VALUES (532530, '金平苗族瑶族傣族自治县', 532500);
INSERT INTO `dict_area` VALUES (532531, '绿春县', 532500);
INSERT INTO `dict_area` VALUES (532532, '河口瑶族自治县', 532500);
INSERT INTO `dict_area` VALUES (532600, '文山壮族苗族自治州', 530000);
INSERT INTO `dict_area` VALUES (532601, '文山市', 532600);
INSERT INTO `dict_area` VALUES (532622, '砚山县', 532600);
INSERT INTO `dict_area` VALUES (532623, '西畴县', 532600);
INSERT INTO `dict_area` VALUES (532624, '麻栗坡县', 532600);
INSERT INTO `dict_area` VALUES (532625, '马关县', 532600);
INSERT INTO `dict_area` VALUES (532626, '丘北县', 532600);
INSERT INTO `dict_area` VALUES (532627, '广南县', 532600);
INSERT INTO `dict_area` VALUES (532628, '富宁县', 532600);
INSERT INTO `dict_area` VALUES (532800, '西双版纳傣族自治州', 530000);
INSERT INTO `dict_area` VALUES (532801, '景洪市', 532800);
INSERT INTO `dict_area` VALUES (532822, '勐海县', 532800);
INSERT INTO `dict_area` VALUES (532823, '勐腊县', 532800);
INSERT INTO `dict_area` VALUES (532900, '大理白族自治州', 530000);
INSERT INTO `dict_area` VALUES (532901, '大理市', 532900);
INSERT INTO `dict_area` VALUES (532922, '漾濞彝族自治县', 532900);
INSERT INTO `dict_area` VALUES (532923, '祥云县', 532900);
INSERT INTO `dict_area` VALUES (532924, '宾川县', 532900);
INSERT INTO `dict_area` VALUES (532925, '弥渡县', 532900);
INSERT INTO `dict_area` VALUES (532926, '南涧彝族自治县', 532900);
INSERT INTO `dict_area` VALUES (532927, '巍山彝族回族自治县', 532900);
INSERT INTO `dict_area` VALUES (532928, '永平县', 532900);
INSERT INTO `dict_area` VALUES (532929, '云龙县', 532900);
INSERT INTO `dict_area` VALUES (532930, '洱源县', 532900);
INSERT INTO `dict_area` VALUES (532931, '剑川县', 532900);
INSERT INTO `dict_area` VALUES (532932, '鹤庆县', 532900);
INSERT INTO `dict_area` VALUES (533100, '德宏傣族景颇族自治州', 530000);
INSERT INTO `dict_area` VALUES (533102, '瑞丽市', 533100);
INSERT INTO `dict_area` VALUES (533103, '芒市', 533100);
INSERT INTO `dict_area` VALUES (533122, '梁河县', 533100);
INSERT INTO `dict_area` VALUES (533123, '盈江县', 533100);
INSERT INTO `dict_area` VALUES (533124, '陇川县', 533100);
INSERT INTO `dict_area` VALUES (533300, '怒江傈僳族自治州', 530000);
INSERT INTO `dict_area` VALUES (533301, '泸水市', 533300);
INSERT INTO `dict_area` VALUES (533323, '福贡县', 533300);
INSERT INTO `dict_area` VALUES (533324, '贡山独龙族怒族自治县', 533300);
INSERT INTO `dict_area` VALUES (533325, '兰坪白族普米族自治县', 533300);
INSERT INTO `dict_area` VALUES (533400, '迪庆藏族自治州', 530000);
INSERT INTO `dict_area` VALUES (533401, '香格里拉市', 533400);
INSERT INTO `dict_area` VALUES (533422, '德钦县', 533400);
INSERT INTO `dict_area` VALUES (533423, '维西傈僳族自治县', 533400);
INSERT INTO `dict_area` VALUES (540000, '西藏自治区', NULL);
INSERT INTO `dict_area` VALUES (540100, '拉萨市', 540000);
INSERT INTO `dict_area` VALUES (540102, '城关区', 540100);
INSERT INTO `dict_area` VALUES (540103, '堆龙德庆区', 540100);
INSERT INTO `dict_area` VALUES (540121, '林周县', 540100);
INSERT INTO `dict_area` VALUES (540122, '当雄县', 540100);
INSERT INTO `dict_area` VALUES (540123, '尼木县', 540100);
INSERT INTO `dict_area` VALUES (540124, '曲水县', 540100);
INSERT INTO `dict_area` VALUES (540126, '达孜县', 540100);
INSERT INTO `dict_area` VALUES (540127, '墨竹工卡县', 540100);
INSERT INTO `dict_area` VALUES (540200, '日喀则市', 540000);
INSERT INTO `dict_area` VALUES (540202, '桑珠孜区', 540200);
INSERT INTO `dict_area` VALUES (540221, '南木林县', 540200);
INSERT INTO `dict_area` VALUES (540222, '江孜县', 540200);
INSERT INTO `dict_area` VALUES (540223, '定日县', 540200);
INSERT INTO `dict_area` VALUES (540224, '萨迦县', 540200);
INSERT INTO `dict_area` VALUES (540225, '拉孜县', 540200);
INSERT INTO `dict_area` VALUES (540226, '昂仁县', 540200);
INSERT INTO `dict_area` VALUES (540227, '谢通门县', 540200);
INSERT INTO `dict_area` VALUES (540228, '白朗县', 540200);
INSERT INTO `dict_area` VALUES (540229, '仁布县', 540200);
INSERT INTO `dict_area` VALUES (540230, '康马县', 540200);
INSERT INTO `dict_area` VALUES (540231, '定结县', 540200);
INSERT INTO `dict_area` VALUES (540232, '仲巴县', 540200);
INSERT INTO `dict_area` VALUES (540233, '亚东县', 540200);
INSERT INTO `dict_area` VALUES (540234, '吉隆县', 540200);
INSERT INTO `dict_area` VALUES (540235, '聂拉木县', 540200);
INSERT INTO `dict_area` VALUES (540236, '萨嘎县', 540200);
INSERT INTO `dict_area` VALUES (540237, '岗巴县', 540200);
INSERT INTO `dict_area` VALUES (540300, '昌都市', 540000);
INSERT INTO `dict_area` VALUES (540302, '卡若区', 540300);
INSERT INTO `dict_area` VALUES (540321, '江达县', 540300);
INSERT INTO `dict_area` VALUES (540322, '贡觉县', 540300);
INSERT INTO `dict_area` VALUES (540323, '类乌齐县', 540300);
INSERT INTO `dict_area` VALUES (540324, '丁青县', 540300);
INSERT INTO `dict_area` VALUES (540325, '察雅县', 540300);
INSERT INTO `dict_area` VALUES (540326, '八宿县', 540300);
INSERT INTO `dict_area` VALUES (540327, '左贡县', 540300);
INSERT INTO `dict_area` VALUES (540328, '芒康县', 540300);
INSERT INTO `dict_area` VALUES (540329, '洛隆县', 540300);
INSERT INTO `dict_area` VALUES (540330, '边坝县', 540300);
INSERT INTO `dict_area` VALUES (540400, '林芝市', 540000);
INSERT INTO `dict_area` VALUES (540402, '巴宜区', 540400);
INSERT INTO `dict_area` VALUES (540421, '工布江达县', 540400);
INSERT INTO `dict_area` VALUES (540422, '米林县', 540400);
INSERT INTO `dict_area` VALUES (540423, '墨脱县', 540400);
INSERT INTO `dict_area` VALUES (540424, '波密县', 540400);
INSERT INTO `dict_area` VALUES (540425, '察隅县', 540400);
INSERT INTO `dict_area` VALUES (540426, '朗县', 540400);
INSERT INTO `dict_area` VALUES (540500, '山南市', 540000);
INSERT INTO `dict_area` VALUES (540502, '乃东区', 540500);
INSERT INTO `dict_area` VALUES (540521, '扎囊县', 540500);
INSERT INTO `dict_area` VALUES (540522, '贡嘎县', 540500);
INSERT INTO `dict_area` VALUES (540523, '桑日县', 540500);
INSERT INTO `dict_area` VALUES (540524, '琼结县', 540500);
INSERT INTO `dict_area` VALUES (540525, '曲松县', 540500);
INSERT INTO `dict_area` VALUES (540526, '措美县', 540500);
INSERT INTO `dict_area` VALUES (540527, '洛扎县', 540500);
INSERT INTO `dict_area` VALUES (540528, '加查县', 540500);
INSERT INTO `dict_area` VALUES (540529, '隆子县', 540500);
INSERT INTO `dict_area` VALUES (540530, '错那县', 540500);
INSERT INTO `dict_area` VALUES (540531, '浪卡子县', 540500);
INSERT INTO `dict_area` VALUES (542400, '那曲地区', 540000);
INSERT INTO `dict_area` VALUES (542421, '那曲县', 542400);
INSERT INTO `dict_area` VALUES (542422, '嘉黎县', 542400);
INSERT INTO `dict_area` VALUES (542423, '比如县', 542400);
INSERT INTO `dict_area` VALUES (542424, '聂荣县', 542400);
INSERT INTO `dict_area` VALUES (542425, '安多县', 542400);
INSERT INTO `dict_area` VALUES (542426, '申扎县', 542400);
INSERT INTO `dict_area` VALUES (542427, '索县', 542400);
INSERT INTO `dict_area` VALUES (542428, '班戈县', 542400);
INSERT INTO `dict_area` VALUES (542429, '巴青县', 542400);
INSERT INTO `dict_area` VALUES (542430, '尼玛县', 542400);
INSERT INTO `dict_area` VALUES (542431, '双湖县', 542400);
INSERT INTO `dict_area` VALUES (542500, '阿里地区', 540000);
INSERT INTO `dict_area` VALUES (542521, '普兰县', 542500);
INSERT INTO `dict_area` VALUES (542522, '札达县', 542500);
INSERT INTO `dict_area` VALUES (542523, '噶尔县', 542500);
INSERT INTO `dict_area` VALUES (542524, '日土县', 542500);
INSERT INTO `dict_area` VALUES (542525, '革吉县', 542500);
INSERT INTO `dict_area` VALUES (542526, '改则县', 542500);
INSERT INTO `dict_area` VALUES (542527, '措勤县', 542500);
INSERT INTO `dict_area` VALUES (610000, '陕西省', NULL);
INSERT INTO `dict_area` VALUES (610100, '西安市', 610000);
INSERT INTO `dict_area` VALUES (610102, '新城区', 610100);
INSERT INTO `dict_area` VALUES (610103, '碑林区', 610100);
INSERT INTO `dict_area` VALUES (610104, '莲湖区', 610100);
INSERT INTO `dict_area` VALUES (610111, '灞桥区', 610100);
INSERT INTO `dict_area` VALUES (610112, '未央区', 610100);
INSERT INTO `dict_area` VALUES (610113, '雁塔区', 610100);
INSERT INTO `dict_area` VALUES (610114, '阎良区', 610100);
INSERT INTO `dict_area` VALUES (610115, '临潼区', 610100);
INSERT INTO `dict_area` VALUES (610116, '长安区', 610100);
INSERT INTO `dict_area` VALUES (610117, '高陵区', 610100);
INSERT INTO `dict_area` VALUES (610118, '鄠邑区', 610100);
INSERT INTO `dict_area` VALUES (610122, '蓝田县', 610100);
INSERT INTO `dict_area` VALUES (610124, '周至县', 610100);
INSERT INTO `dict_area` VALUES (610200, '铜川市', 610000);
INSERT INTO `dict_area` VALUES (610202, '王益区', 610200);
INSERT INTO `dict_area` VALUES (610203, '印台区', 610200);
INSERT INTO `dict_area` VALUES (610204, '耀州区', 610200);
INSERT INTO `dict_area` VALUES (610222, '宜君县', 610200);
INSERT INTO `dict_area` VALUES (610300, '宝鸡市', 610000);
INSERT INTO `dict_area` VALUES (610302, '渭滨区', 610300);
INSERT INTO `dict_area` VALUES (610303, '金台区', 610300);
INSERT INTO `dict_area` VALUES (610304, '陈仓区', 610300);
INSERT INTO `dict_area` VALUES (610322, '凤翔县', 610300);
INSERT INTO `dict_area` VALUES (610323, '岐山县', 610300);
INSERT INTO `dict_area` VALUES (610324, '扶风县', 610300);
INSERT INTO `dict_area` VALUES (610326, '眉县', 610300);
INSERT INTO `dict_area` VALUES (610327, '陇县', 610300);
INSERT INTO `dict_area` VALUES (610328, '千阳县', 610300);
INSERT INTO `dict_area` VALUES (610329, '麟游县', 610300);
INSERT INTO `dict_area` VALUES (610330, '凤县', 610300);
INSERT INTO `dict_area` VALUES (610331, '太白县', 610300);
INSERT INTO `dict_area` VALUES (610400, '咸阳市', 610000);
INSERT INTO `dict_area` VALUES (610402, '秦都区', 610400);
INSERT INTO `dict_area` VALUES (610403, '杨陵区', 610400);
INSERT INTO `dict_area` VALUES (610404, '渭城区', 610400);
INSERT INTO `dict_area` VALUES (610422, '三原县', 610400);
INSERT INTO `dict_area` VALUES (610423, '泾阳县', 610400);
INSERT INTO `dict_area` VALUES (610424, '乾县', 610400);
INSERT INTO `dict_area` VALUES (610425, '礼泉县', 610400);
INSERT INTO `dict_area` VALUES (610426, '永寿县', 610400);
INSERT INTO `dict_area` VALUES (610427, '彬县', 610400);
INSERT INTO `dict_area` VALUES (610428, '长武县', 610400);
INSERT INTO `dict_area` VALUES (610429, '旬邑县', 610400);
INSERT INTO `dict_area` VALUES (610430, '淳化县', 610400);
INSERT INTO `dict_area` VALUES (610431, '武功县', 610400);
INSERT INTO `dict_area` VALUES (610481, '兴平市', 610400);
INSERT INTO `dict_area` VALUES (610500, '渭南市', 610000);
INSERT INTO `dict_area` VALUES (610502, '临渭区', 610500);
INSERT INTO `dict_area` VALUES (610503, '华州区', 610500);
INSERT INTO `dict_area` VALUES (610522, '潼关县', 610500);
INSERT INTO `dict_area` VALUES (610523, '大荔县', 610500);
INSERT INTO `dict_area` VALUES (610524, '合阳县', 610500);
INSERT INTO `dict_area` VALUES (610525, '澄城县', 610500);
INSERT INTO `dict_area` VALUES (610526, '蒲城县', 610500);
INSERT INTO `dict_area` VALUES (610527, '白水县', 610500);
INSERT INTO `dict_area` VALUES (610528, '富平县', 610500);
INSERT INTO `dict_area` VALUES (610581, '韩城市', 610500);
INSERT INTO `dict_area` VALUES (610582, '华阴市', 610500);
INSERT INTO `dict_area` VALUES (610600, '延安市', 610000);
INSERT INTO `dict_area` VALUES (610602, '宝塔区', 610600);
INSERT INTO `dict_area` VALUES (610603, '安塞区', 610600);
INSERT INTO `dict_area` VALUES (610621, '延长县', 610600);
INSERT INTO `dict_area` VALUES (610622, '延川县', 610600);
INSERT INTO `dict_area` VALUES (610623, '子长县', 610600);
INSERT INTO `dict_area` VALUES (610625, '志丹县', 610600);
INSERT INTO `dict_area` VALUES (610626, '吴起县', 610600);
INSERT INTO `dict_area` VALUES (610627, '甘泉县', 610600);
INSERT INTO `dict_area` VALUES (610628, '富县', 610600);
INSERT INTO `dict_area` VALUES (610629, '洛川县', 610600);
INSERT INTO `dict_area` VALUES (610630, '宜川县', 610600);
INSERT INTO `dict_area` VALUES (610631, '黄龙县', 610600);
INSERT INTO `dict_area` VALUES (610632, '黄陵县', 610600);
INSERT INTO `dict_area` VALUES (610700, '汉中市', 610000);
INSERT INTO `dict_area` VALUES (610702, '汉台区', 610700);
INSERT INTO `dict_area` VALUES (610721, '南郑县', 610700);
INSERT INTO `dict_area` VALUES (610722, '城固县', 610700);
INSERT INTO `dict_area` VALUES (610723, '洋县', 610700);
INSERT INTO `dict_area` VALUES (610724, '西乡县', 610700);
INSERT INTO `dict_area` VALUES (610725, '勉县', 610700);
INSERT INTO `dict_area` VALUES (610726, '宁强县', 610700);
INSERT INTO `dict_area` VALUES (610727, '略阳县', 610700);
INSERT INTO `dict_area` VALUES (610728, '镇巴县', 610700);
INSERT INTO `dict_area` VALUES (610729, '留坝县', 610700);
INSERT INTO `dict_area` VALUES (610730, '佛坪县', 610700);
INSERT INTO `dict_area` VALUES (610800, '榆林市', 610000);
INSERT INTO `dict_area` VALUES (610802, '榆阳区', 610800);
INSERT INTO `dict_area` VALUES (610803, '横山区', 610800);
INSERT INTO `dict_area` VALUES (610822, '府谷县', 610800);
INSERT INTO `dict_area` VALUES (610824, '靖边县', 610800);
INSERT INTO `dict_area` VALUES (610825, '定边县', 610800);
INSERT INTO `dict_area` VALUES (610826, '绥德县', 610800);
INSERT INTO `dict_area` VALUES (610827, '米脂县', 610800);
INSERT INTO `dict_area` VALUES (610828, '佳县', 610800);
INSERT INTO `dict_area` VALUES (610829, '吴堡县', 610800);
INSERT INTO `dict_area` VALUES (610830, '清涧县', 610800);
INSERT INTO `dict_area` VALUES (610831, '子洲县', 610800);
INSERT INTO `dict_area` VALUES (610881, '神木市', 610800);
INSERT INTO `dict_area` VALUES (610900, '安康市', 610000);
INSERT INTO `dict_area` VALUES (610902, '汉滨区', 610900);
INSERT INTO `dict_area` VALUES (610921, '汉阴县', 610900);
INSERT INTO `dict_area` VALUES (610922, '石泉县', 610900);
INSERT INTO `dict_area` VALUES (610923, '宁陕县', 610900);
INSERT INTO `dict_area` VALUES (610924, '紫阳县', 610900);
INSERT INTO `dict_area` VALUES (610925, '岚皋县', 610900);
INSERT INTO `dict_area` VALUES (610926, '平利县', 610900);
INSERT INTO `dict_area` VALUES (610927, '镇坪县', 610900);
INSERT INTO `dict_area` VALUES (610928, '旬阳县', 610900);
INSERT INTO `dict_area` VALUES (610929, '白河县', 610900);
INSERT INTO `dict_area` VALUES (611000, '商洛市', 610000);
INSERT INTO `dict_area` VALUES (611002, '商州区', 611000);
INSERT INTO `dict_area` VALUES (611021, '洛南县', 611000);
INSERT INTO `dict_area` VALUES (611022, '丹凤县', 611000);
INSERT INTO `dict_area` VALUES (611023, '商南县', 611000);
INSERT INTO `dict_area` VALUES (611024, '山阳县', 611000);
INSERT INTO `dict_area` VALUES (611025, '镇安县', 611000);
INSERT INTO `dict_area` VALUES (611026, '柞水县', 611000);
INSERT INTO `dict_area` VALUES (620000, '甘肃省', NULL);
INSERT INTO `dict_area` VALUES (620100, '兰州市', 620000);
INSERT INTO `dict_area` VALUES (620102, '城关区', 620100);
INSERT INTO `dict_area` VALUES (620103, '七里河区', 620100);
INSERT INTO `dict_area` VALUES (620104, '西固区', 620100);
INSERT INTO `dict_area` VALUES (620105, '安宁区', 620100);
INSERT INTO `dict_area` VALUES (620111, '红古区', 620100);
INSERT INTO `dict_area` VALUES (620121, '永登县', 620100);
INSERT INTO `dict_area` VALUES (620122, '皋兰县', 620100);
INSERT INTO `dict_area` VALUES (620123, '榆中县', 620100);
INSERT INTO `dict_area` VALUES (620200, '嘉峪关市', 620000);
INSERT INTO `dict_area` VALUES (620201, '嘉峪关市', 620200);
INSERT INTO `dict_area` VALUES (620300, '金昌市', 620000);
INSERT INTO `dict_area` VALUES (620302, '金川区', 620300);
INSERT INTO `dict_area` VALUES (620321, '永昌县', 620300);
INSERT INTO `dict_area` VALUES (620400, '白银市', 620000);
INSERT INTO `dict_area` VALUES (620402, '白银区', 620400);
INSERT INTO `dict_area` VALUES (620403, '平川区', 620400);
INSERT INTO `dict_area` VALUES (620421, '靖远县', 620400);
INSERT INTO `dict_area` VALUES (620422, '会宁县', 620400);
INSERT INTO `dict_area` VALUES (620423, '景泰县', 620400);
INSERT INTO `dict_area` VALUES (620500, '天水市', 620000);
INSERT INTO `dict_area` VALUES (620502, '秦州区', 620500);
INSERT INTO `dict_area` VALUES (620503, '麦积区', 620500);
INSERT INTO `dict_area` VALUES (620521, '清水县', 620500);
INSERT INTO `dict_area` VALUES (620522, '秦安县', 620500);
INSERT INTO `dict_area` VALUES (620523, '甘谷县', 620500);
INSERT INTO `dict_area` VALUES (620524, '武山县', 620500);
INSERT INTO `dict_area` VALUES (620525, '张家川回族自治县', 620500);
INSERT INTO `dict_area` VALUES (620600, '武威市', 620000);
INSERT INTO `dict_area` VALUES (620602, '凉州区', 620600);
INSERT INTO `dict_area` VALUES (620621, '民勤县', 620600);
INSERT INTO `dict_area` VALUES (620622, '古浪县', 620600);
INSERT INTO `dict_area` VALUES (620623, '天祝藏族自治县', 620600);
INSERT INTO `dict_area` VALUES (620700, '张掖市', 620000);
INSERT INTO `dict_area` VALUES (620702, '甘州区', 620700);
INSERT INTO `dict_area` VALUES (620721, '肃南裕固族自治县', 620700);
INSERT INTO `dict_area` VALUES (620722, '民乐县', 620700);
INSERT INTO `dict_area` VALUES (620723, '临泽县', 620700);
INSERT INTO `dict_area` VALUES (620724, '高台县', 620700);
INSERT INTO `dict_area` VALUES (620725, '山丹县', 620700);
INSERT INTO `dict_area` VALUES (620800, '平凉市', 620000);
INSERT INTO `dict_area` VALUES (620802, '崆峒区', 620800);
INSERT INTO `dict_area` VALUES (620821, '泾川县', 620800);
INSERT INTO `dict_area` VALUES (620822, '灵台县', 620800);
INSERT INTO `dict_area` VALUES (620823, '崇信县', 620800);
INSERT INTO `dict_area` VALUES (620824, '华亭县', 620800);
INSERT INTO `dict_area` VALUES (620825, '庄浪县', 620800);
INSERT INTO `dict_area` VALUES (620826, '静宁县', 620800);
INSERT INTO `dict_area` VALUES (620900, '酒泉市', 620000);
INSERT INTO `dict_area` VALUES (620902, '肃州区', 620900);
INSERT INTO `dict_area` VALUES (620921, '金塔县', 620900);
INSERT INTO `dict_area` VALUES (620922, '瓜州县', 620900);
INSERT INTO `dict_area` VALUES (620923, '肃北蒙古族自治县', 620900);
INSERT INTO `dict_area` VALUES (620924, '阿克塞哈萨克族自治县', 620900);
INSERT INTO `dict_area` VALUES (620981, '玉门市', 620900);
INSERT INTO `dict_area` VALUES (620982, '敦煌市', 620900);
INSERT INTO `dict_area` VALUES (621000, '庆阳市', 620000);
INSERT INTO `dict_area` VALUES (621002, '西峰区', 621000);
INSERT INTO `dict_area` VALUES (621021, '庆城县', 621000);
INSERT INTO `dict_area` VALUES (621022, '环县', 621000);
INSERT INTO `dict_area` VALUES (621023, '华池县', 621000);
INSERT INTO `dict_area` VALUES (621024, '合水县', 621000);
INSERT INTO `dict_area` VALUES (621025, '正宁县', 621000);
INSERT INTO `dict_area` VALUES (621026, '宁县', 621000);
INSERT INTO `dict_area` VALUES (621027, '镇原县', 621000);
INSERT INTO `dict_area` VALUES (621100, '定西市', 620000);
INSERT INTO `dict_area` VALUES (621102, '安定区', 621100);
INSERT INTO `dict_area` VALUES (621121, '通渭县', 621100);
INSERT INTO `dict_area` VALUES (621122, '陇西县', 621100);
INSERT INTO `dict_area` VALUES (621123, '渭源县', 621100);
INSERT INTO `dict_area` VALUES (621124, '临洮县', 621100);
INSERT INTO `dict_area` VALUES (621125, '漳县', 621100);
INSERT INTO `dict_area` VALUES (621126, '岷县', 621100);
INSERT INTO `dict_area` VALUES (621200, '陇南市', 620000);
INSERT INTO `dict_area` VALUES (621202, '武都区', 621200);
INSERT INTO `dict_area` VALUES (621221, '成县', 621200);
INSERT INTO `dict_area` VALUES (621222, '文县', 621200);
INSERT INTO `dict_area` VALUES (621223, '宕昌县', 621200);
INSERT INTO `dict_area` VALUES (621224, '康县', 621200);
INSERT INTO `dict_area` VALUES (621225, '西和县', 621200);
INSERT INTO `dict_area` VALUES (621226, '礼县', 621200);
INSERT INTO `dict_area` VALUES (621227, '徽县', 621200);
INSERT INTO `dict_area` VALUES (621228, '两当县', 621200);
INSERT INTO `dict_area` VALUES (622900, '临夏回族自治州', 620000);
INSERT INTO `dict_area` VALUES (622901, '临夏市', 622900);
INSERT INTO `dict_area` VALUES (622921, '临夏县', 622900);
INSERT INTO `dict_area` VALUES (622922, '康乐县', 622900);
INSERT INTO `dict_area` VALUES (622923, '永靖县', 622900);
INSERT INTO `dict_area` VALUES (622924, '广河县', 622900);
INSERT INTO `dict_area` VALUES (622925, '和政县', 622900);
INSERT INTO `dict_area` VALUES (622926, '东乡族自治县', 622900);
INSERT INTO `dict_area` VALUES (622927, '积石山保安族东乡族撒拉族自治县', 622900);
INSERT INTO `dict_area` VALUES (623000, '甘南藏族自治州', 620000);
INSERT INTO `dict_area` VALUES (623001, '合作市', 623000);
INSERT INTO `dict_area` VALUES (623021, '临潭县', 623000);
INSERT INTO `dict_area` VALUES (623022, '卓尼县', 623000);
INSERT INTO `dict_area` VALUES (623023, '舟曲县', 623000);
INSERT INTO `dict_area` VALUES (623024, '迭部县', 623000);
INSERT INTO `dict_area` VALUES (623025, '玛曲县', 623000);
INSERT INTO `dict_area` VALUES (623026, '碌曲县', 623000);
INSERT INTO `dict_area` VALUES (623027, '夏河县', 623000);
INSERT INTO `dict_area` VALUES (630000, '青海省', NULL);
INSERT INTO `dict_area` VALUES (630100, '西宁市', 630000);
INSERT INTO `dict_area` VALUES (630102, '城东区', 630100);
INSERT INTO `dict_area` VALUES (630103, '城中区', 630100);
INSERT INTO `dict_area` VALUES (630104, '城西区', 630100);
INSERT INTO `dict_area` VALUES (630105, '城北区', 630100);
INSERT INTO `dict_area` VALUES (630121, '大通回族土族自治县', 630100);
INSERT INTO `dict_area` VALUES (630122, '湟中县', 630100);
INSERT INTO `dict_area` VALUES (630123, '湟源县', 630100);
INSERT INTO `dict_area` VALUES (630200, '海东市', 630000);
INSERT INTO `dict_area` VALUES (630202, '乐都区', 630200);
INSERT INTO `dict_area` VALUES (630203, '平安区', 630200);
INSERT INTO `dict_area` VALUES (630222, '民和回族土族自治县', 630200);
INSERT INTO `dict_area` VALUES (630223, '互助土族自治县', 630200);
INSERT INTO `dict_area` VALUES (630224, '化隆回族自治县', 630200);
INSERT INTO `dict_area` VALUES (630225, '循化撒拉族自治县', 630200);
INSERT INTO `dict_area` VALUES (632200, '海北藏族自治州', 630000);
INSERT INTO `dict_area` VALUES (632221, '门源回族自治县', 632200);
INSERT INTO `dict_area` VALUES (632222, '祁连县', 632200);
INSERT INTO `dict_area` VALUES (632223, '海晏县', 632200);
INSERT INTO `dict_area` VALUES (632224, '刚察县', 632200);
INSERT INTO `dict_area` VALUES (632300, '黄南藏族自治州', 630000);
INSERT INTO `dict_area` VALUES (632321, '同仁县', 632300);
INSERT INTO `dict_area` VALUES (632322, '尖扎县', 632300);
INSERT INTO `dict_area` VALUES (632323, '泽库县', 632300);
INSERT INTO `dict_area` VALUES (632324, '河南蒙古族自治县', 632300);
INSERT INTO `dict_area` VALUES (632500, '海南藏族自治州', 630000);
INSERT INTO `dict_area` VALUES (632521, '共和县', 632500);
INSERT INTO `dict_area` VALUES (632522, '同德县', 632500);
INSERT INTO `dict_area` VALUES (632523, '贵德县', 632500);
INSERT INTO `dict_area` VALUES (632524, '兴海县', 632500);
INSERT INTO `dict_area` VALUES (632525, '贵南县', 632500);
INSERT INTO `dict_area` VALUES (632600, '果洛藏族自治州', 630000);
INSERT INTO `dict_area` VALUES (632621, '玛沁县', 632600);
INSERT INTO `dict_area` VALUES (632622, '班玛县', 632600);
INSERT INTO `dict_area` VALUES (632623, '甘德县', 632600);
INSERT INTO `dict_area` VALUES (632624, '达日县', 632600);
INSERT INTO `dict_area` VALUES (632625, '久治县', 632600);
INSERT INTO `dict_area` VALUES (632626, '玛多县', 632600);
INSERT INTO `dict_area` VALUES (632700, '玉树藏族自治州', 630000);
INSERT INTO `dict_area` VALUES (632701, '玉树市', 632700);
INSERT INTO `dict_area` VALUES (632722, '杂多县', 632700);
INSERT INTO `dict_area` VALUES (632723, '称多县', 632700);
INSERT INTO `dict_area` VALUES (632724, '治多县', 632700);
INSERT INTO `dict_area` VALUES (632725, '囊谦县', 632700);
INSERT INTO `dict_area` VALUES (632726, '曲麻莱县', 632700);
INSERT INTO `dict_area` VALUES (632800, '海西蒙古族藏族自治州', 630000);
INSERT INTO `dict_area` VALUES (632801, '格尔木市', 632800);
INSERT INTO `dict_area` VALUES (632802, '德令哈市', 632800);
INSERT INTO `dict_area` VALUES (632821, '乌兰县', 632800);
INSERT INTO `dict_area` VALUES (632822, '都兰县', 632800);
INSERT INTO `dict_area` VALUES (632823, '天峻县', 632800);
INSERT INTO `dict_area` VALUES (632824, '冷湖行政区', 632800);
INSERT INTO `dict_area` VALUES (632825, '大柴旦行政区', 632800);
INSERT INTO `dict_area` VALUES (632826, '茫崖行政区', 632800);
INSERT INTO `dict_area` VALUES (640000, '宁夏回族自治区', NULL);
INSERT INTO `dict_area` VALUES (640100, '银川市', 640000);
INSERT INTO `dict_area` VALUES (640104, '兴庆区', 640100);
INSERT INTO `dict_area` VALUES (640105, '西夏区', 640100);
INSERT INTO `dict_area` VALUES (640106, '金凤区', 640100);
INSERT INTO `dict_area` VALUES (640121, '永宁县', 640100);
INSERT INTO `dict_area` VALUES (640122, '贺兰县', 640100);
INSERT INTO `dict_area` VALUES (640181, '灵武市', 640100);
INSERT INTO `dict_area` VALUES (640200, '石嘴山市', 640000);
INSERT INTO `dict_area` VALUES (640202, '大武口区', 640200);
INSERT INTO `dict_area` VALUES (640205, '惠农区', 640200);
INSERT INTO `dict_area` VALUES (640221, '平罗县', 640200);
INSERT INTO `dict_area` VALUES (640300, '吴忠市', 640000);
INSERT INTO `dict_area` VALUES (640302, '利通区', 640300);
INSERT INTO `dict_area` VALUES (640303, '红寺堡区', 640300);
INSERT INTO `dict_area` VALUES (640323, '盐池县', 640300);
INSERT INTO `dict_area` VALUES (640324, '同心县', 640300);
INSERT INTO `dict_area` VALUES (640381, '青铜峡市', 640300);
INSERT INTO `dict_area` VALUES (640400, '固原市', 640000);
INSERT INTO `dict_area` VALUES (640402, '原州区', 640400);
INSERT INTO `dict_area` VALUES (640422, '西吉县', 640400);
INSERT INTO `dict_area` VALUES (640423, '隆德县', 640400);
INSERT INTO `dict_area` VALUES (640424, '泾源县', 640400);
INSERT INTO `dict_area` VALUES (640425, '彭阳县', 640400);
INSERT INTO `dict_area` VALUES (640500, '中卫市', 640000);
INSERT INTO `dict_area` VALUES (640502, '沙坡头区', 640500);
INSERT INTO `dict_area` VALUES (640521, '中宁县', 640500);
INSERT INTO `dict_area` VALUES (640522, '海原县', 640500);
INSERT INTO `dict_area` VALUES (650000, '新疆维吾尔自治区', NULL);
INSERT INTO `dict_area` VALUES (650100, '乌鲁木齐市', 650000);
INSERT INTO `dict_area` VALUES (650102, '天山区', 650100);
INSERT INTO `dict_area` VALUES (650103, '沙依巴克区', 650100);
INSERT INTO `dict_area` VALUES (650104, '新市区', 650100);
INSERT INTO `dict_area` VALUES (650105, '水磨沟区', 650100);
INSERT INTO `dict_area` VALUES (650106, '头屯河区', 650100);
INSERT INTO `dict_area` VALUES (650107, '达坂城区', 650100);
INSERT INTO `dict_area` VALUES (650109, '米东区', 650100);
INSERT INTO `dict_area` VALUES (650121, '乌鲁木齐县', 650100);
INSERT INTO `dict_area` VALUES (650200, '克拉玛依市', 650000);
INSERT INTO `dict_area` VALUES (650202, '独山子区', 650200);
INSERT INTO `dict_area` VALUES (650203, '克拉玛依区', 650200);
INSERT INTO `dict_area` VALUES (650204, '白碱滩区', 650200);
INSERT INTO `dict_area` VALUES (650205, '乌尔禾区', 650200);
INSERT INTO `dict_area` VALUES (650400, '吐鲁番市', 650000);
INSERT INTO `dict_area` VALUES (650402, '高昌区', 650400);
INSERT INTO `dict_area` VALUES (650421, '鄯善县', 650400);
INSERT INTO `dict_area` VALUES (650422, '托克逊县', 650400);
INSERT INTO `dict_area` VALUES (650500, '哈密市', 650000);
INSERT INTO `dict_area` VALUES (650502, '伊州区', 650500);
INSERT INTO `dict_area` VALUES (650521, '巴里坤哈萨克自治县', 650500);
INSERT INTO `dict_area` VALUES (650522, '伊吾县', 650500);
INSERT INTO `dict_area` VALUES (652300, '昌吉回族自治州', 650000);
INSERT INTO `dict_area` VALUES (652301, '昌吉市', 652300);
INSERT INTO `dict_area` VALUES (652302, '阜康市', 652300);
INSERT INTO `dict_area` VALUES (652323, '呼图壁县', 652300);
INSERT INTO `dict_area` VALUES (652324, '玛纳斯县', 652300);
INSERT INTO `dict_area` VALUES (652325, '奇台县', 652300);
INSERT INTO `dict_area` VALUES (652327, '吉木萨尔县', 652300);
INSERT INTO `dict_area` VALUES (652328, '木垒哈萨克自治县', 652300);
INSERT INTO `dict_area` VALUES (652700, '博尔塔拉蒙古自治州', 650000);
INSERT INTO `dict_area` VALUES (652701, '博乐市', 652700);
INSERT INTO `dict_area` VALUES (652702, '阿拉山口市', 652700);
INSERT INTO `dict_area` VALUES (652722, '精河县', 652700);
INSERT INTO `dict_area` VALUES (652723, '温泉县', 652700);
INSERT INTO `dict_area` VALUES (652800, '巴音郭楞蒙古自治州', 650000);
INSERT INTO `dict_area` VALUES (652801, '库尔勒市', 652800);
INSERT INTO `dict_area` VALUES (652822, '轮台县', 652800);
INSERT INTO `dict_area` VALUES (652823, '尉犁县', 652800);
INSERT INTO `dict_area` VALUES (652824, '若羌县', 652800);
INSERT INTO `dict_area` VALUES (652825, '且末县', 652800);
INSERT INTO `dict_area` VALUES (652826, '焉耆回族自治县', 652800);
INSERT INTO `dict_area` VALUES (652827, '和静县', 652800);
INSERT INTO `dict_area` VALUES (652828, '和硕县', 652800);
INSERT INTO `dict_area` VALUES (652829, '博湖县', 652800);
INSERT INTO `dict_area` VALUES (652900, '阿克苏地区', 650000);
INSERT INTO `dict_area` VALUES (652901, '阿克苏市', 652900);
INSERT INTO `dict_area` VALUES (652922, '温宿县', 652900);
INSERT INTO `dict_area` VALUES (652923, '库车县', 652900);
INSERT INTO `dict_area` VALUES (652924, '沙雅县', 652900);
INSERT INTO `dict_area` VALUES (652925, '新和县', 652900);
INSERT INTO `dict_area` VALUES (652926, '拜城县', 652900);
INSERT INTO `dict_area` VALUES (652927, '乌什县', 652900);
INSERT INTO `dict_area` VALUES (652928, '阿瓦提县', 652900);
INSERT INTO `dict_area` VALUES (652929, '柯坪县', 652900);
INSERT INTO `dict_area` VALUES (653000, '克孜勒苏柯尔克孜自治州', 650000);
INSERT INTO `dict_area` VALUES (653001, '阿图什市', 653000);
INSERT INTO `dict_area` VALUES (653022, '阿克陶县', 653000);
INSERT INTO `dict_area` VALUES (653023, '阿合奇县', 653000);
INSERT INTO `dict_area` VALUES (653024, '乌恰县', 653000);
INSERT INTO `dict_area` VALUES (653100, '喀什地区', 650000);
INSERT INTO `dict_area` VALUES (653101, '喀什市', 653100);
INSERT INTO `dict_area` VALUES (653121, '疏附县', 653100);
INSERT INTO `dict_area` VALUES (653122, '疏勒县', 653100);
INSERT INTO `dict_area` VALUES (653123, '英吉沙县', 653100);
INSERT INTO `dict_area` VALUES (653124, '泽普县', 653100);
INSERT INTO `dict_area` VALUES (653125, '莎车县', 653100);
INSERT INTO `dict_area` VALUES (653126, '叶城县', 653100);
INSERT INTO `dict_area` VALUES (653127, '麦盖提县', 653100);
INSERT INTO `dict_area` VALUES (653128, '岳普湖县', 653100);
INSERT INTO `dict_area` VALUES (653129, '伽师县', 653100);
INSERT INTO `dict_area` VALUES (653130, '巴楚县', 653100);
INSERT INTO `dict_area` VALUES (653131, '塔什库尔干塔吉克自治县', 653100);
INSERT INTO `dict_area` VALUES (653200, '和田地区', 650000);
INSERT INTO `dict_area` VALUES (653201, '和田市', 653200);
INSERT INTO `dict_area` VALUES (653221, '和田县', 653200);
INSERT INTO `dict_area` VALUES (653222, '墨玉县', 653200);
INSERT INTO `dict_area` VALUES (653223, '皮山县', 653200);
INSERT INTO `dict_area` VALUES (653224, '洛浦县', 653200);
INSERT INTO `dict_area` VALUES (653225, '策勒县', 653200);
INSERT INTO `dict_area` VALUES (653226, '于田县', 653200);
INSERT INTO `dict_area` VALUES (653227, '民丰县', 653200);
INSERT INTO `dict_area` VALUES (654000, '伊犁哈萨克自治州', 650000);
INSERT INTO `dict_area` VALUES (654002, '伊宁市', 654000);
INSERT INTO `dict_area` VALUES (654003, '奎屯市', 654000);
INSERT INTO `dict_area` VALUES (654004, '霍尔果斯市', 654000);
INSERT INTO `dict_area` VALUES (654021, '伊宁县', 654000);
INSERT INTO `dict_area` VALUES (654022, '察布查尔锡伯自治县', 654000);
INSERT INTO `dict_area` VALUES (654023, '霍城县', 654000);
INSERT INTO `dict_area` VALUES (654024, '巩留县', 654000);
INSERT INTO `dict_area` VALUES (654025, '新源县', 654000);
INSERT INTO `dict_area` VALUES (654026, '昭苏县', 654000);
INSERT INTO `dict_area` VALUES (654027, '特克斯县', 654000);
INSERT INTO `dict_area` VALUES (654028, '尼勒克县', 654000);
INSERT INTO `dict_area` VALUES (654200, '塔城地区', 650000);
INSERT INTO `dict_area` VALUES (654201, '塔城市', 654200);
INSERT INTO `dict_area` VALUES (654202, '乌苏市', 654200);
INSERT INTO `dict_area` VALUES (654221, '额敏县', 654200);
INSERT INTO `dict_area` VALUES (654223, '沙湾县', 654200);
INSERT INTO `dict_area` VALUES (654224, '托里县', 654200);
INSERT INTO `dict_area` VALUES (654225, '裕民县', 654200);
INSERT INTO `dict_area` VALUES (654226, '和布克赛尔蒙古自治县', 654200);
INSERT INTO `dict_area` VALUES (654300, '阿勒泰地区', 650000);
INSERT INTO `dict_area` VALUES (654301, '阿勒泰市', 654300);
INSERT INTO `dict_area` VALUES (654321, '布尔津县', 654300);
INSERT INTO `dict_area` VALUES (654322, '富蕴县', 654300);
INSERT INTO `dict_area` VALUES (654323, '福海县', 654300);
INSERT INTO `dict_area` VALUES (654324, '哈巴河县', 654300);
INSERT INTO `dict_area` VALUES (654325, '青河县', 654300);
INSERT INTO `dict_area` VALUES (654326, '吉木乃县', 654300);
INSERT INTO `dict_area` VALUES (659100, '石河子市', 650000);
INSERT INTO `dict_area` VALUES (659200, '阿拉尔市', 650000);
INSERT INTO `dict_area` VALUES (659300, '图木舒克市', 650000);
INSERT INTO `dict_area` VALUES (659400, '五家渠市', 650000);
INSERT INTO `dict_area` VALUES (659500, '北屯市', 650000);
INSERT INTO `dict_area` VALUES (659600, '铁门关市', 650000);
INSERT INTO `dict_area` VALUES (659700, '双河市', 650000);
INSERT INTO `dict_area` VALUES (659800, '可克达拉市', 650000);
INSERT INTO `dict_area` VALUES (659900, '昆玉市', 650000);
INSERT INTO `dict_area` VALUES (710000, '台湾省', NULL);
INSERT INTO `dict_area` VALUES (710100, '台北市', 710000);
INSERT INTO `dict_area` VALUES (710101, '中正区', 710100);
INSERT INTO `dict_area` VALUES (710102, '大同区', 710100);
INSERT INTO `dict_area` VALUES (710103, '中山区', 710100);
INSERT INTO `dict_area` VALUES (710104, '松山区', 710100);
INSERT INTO `dict_area` VALUES (710105, '大安区', 710100);
INSERT INTO `dict_area` VALUES (710106, '万华区', 710100);
INSERT INTO `dict_area` VALUES (710107, '信义区', 710100);
INSERT INTO `dict_area` VALUES (710108, '士林区', 710100);
INSERT INTO `dict_area` VALUES (710109, '北投区', 710100);
INSERT INTO `dict_area` VALUES (710110, '内湖区', 710100);
INSERT INTO `dict_area` VALUES (710111, '南港区', 710100);
INSERT INTO `dict_area` VALUES (710112, '文山区', 710100);
INSERT INTO `dict_area` VALUES (710200, '高雄市', 710000);
INSERT INTO `dict_area` VALUES (710201, '新兴区', 710200);
INSERT INTO `dict_area` VALUES (710202, '前金区', 710200);
INSERT INTO `dict_area` VALUES (710203, '苓雅区', 710200);
INSERT INTO `dict_area` VALUES (710204, '盐埕区', 710200);
INSERT INTO `dict_area` VALUES (710205, '鼓山区', 710200);
INSERT INTO `dict_area` VALUES (710206, '旗津区', 710200);
INSERT INTO `dict_area` VALUES (710207, '前镇区', 710200);
INSERT INTO `dict_area` VALUES (710208, '三民区', 710200);
INSERT INTO `dict_area` VALUES (710209, '左营区', 710200);
INSERT INTO `dict_area` VALUES (710210, '楠梓区', 710200);
INSERT INTO `dict_area` VALUES (710211, '小港区', 710200);
INSERT INTO `dict_area` VALUES (710242, '仁武区', 710200);
INSERT INTO `dict_area` VALUES (710243, '大社区', 710200);
INSERT INTO `dict_area` VALUES (710244, '冈山区', 710200);
INSERT INTO `dict_area` VALUES (710245, '路竹区', 710200);
INSERT INTO `dict_area` VALUES (710246, '阿莲区', 710200);
INSERT INTO `dict_area` VALUES (710247, '田寮区', 710200);
INSERT INTO `dict_area` VALUES (710248, '燕巢区', 710200);
INSERT INTO `dict_area` VALUES (710249, '桥头区', 710200);
INSERT INTO `dict_area` VALUES (710250, '梓官区', 710200);
INSERT INTO `dict_area` VALUES (710251, '弥陀区', 710200);
INSERT INTO `dict_area` VALUES (710252, '永安区', 710200);
INSERT INTO `dict_area` VALUES (710253, '湖内区', 710200);
INSERT INTO `dict_area` VALUES (710254, '凤山区', 710200);
INSERT INTO `dict_area` VALUES (710255, '大寮区', 710200);
INSERT INTO `dict_area` VALUES (710256, '林园区', 710200);
INSERT INTO `dict_area` VALUES (710257, '鸟松区', 710200);
INSERT INTO `dict_area` VALUES (710258, '大树区', 710200);
INSERT INTO `dict_area` VALUES (710259, '旗山区', 710200);
INSERT INTO `dict_area` VALUES (710260, '美浓区', 710200);
INSERT INTO `dict_area` VALUES (710261, '六龟区', 710200);
INSERT INTO `dict_area` VALUES (710262, '内门区', 710200);
INSERT INTO `dict_area` VALUES (710263, '杉林区', 710200);
INSERT INTO `dict_area` VALUES (710264, '甲仙区', 710200);
INSERT INTO `dict_area` VALUES (710265, '桃源区', 710200);
INSERT INTO `dict_area` VALUES (710266, '那玛夏区', 710200);
INSERT INTO `dict_area` VALUES (710267, '茂林区', 710200);
INSERT INTO `dict_area` VALUES (710268, '茄萣区', 710200);
INSERT INTO `dict_area` VALUES (710300, '台南市', 710000);
INSERT INTO `dict_area` VALUES (710301, '中西区', 710300);
INSERT INTO `dict_area` VALUES (710302, '东区', 710300);
INSERT INTO `dict_area` VALUES (710303, '南区', 710300);
INSERT INTO `dict_area` VALUES (710304, '北区', 710300);
INSERT INTO `dict_area` VALUES (710305, '安平区', 710300);
INSERT INTO `dict_area` VALUES (710306, '安南区', 710300);
INSERT INTO `dict_area` VALUES (710339, '永康区', 710300);
INSERT INTO `dict_area` VALUES (710340, '归仁区', 710300);
INSERT INTO `dict_area` VALUES (710341, '新化区', 710300);
INSERT INTO `dict_area` VALUES (710342, '左镇区', 710300);
INSERT INTO `dict_area` VALUES (710343, '玉井区', 710300);
INSERT INTO `dict_area` VALUES (710344, '楠西区', 710300);
INSERT INTO `dict_area` VALUES (710345, '南化区', 710300);
INSERT INTO `dict_area` VALUES (710346, '仁德区', 710300);
INSERT INTO `dict_area` VALUES (710347, '关庙区', 710300);
INSERT INTO `dict_area` VALUES (710348, '龙崎区', 710300);
INSERT INTO `dict_area` VALUES (710349, '官田区', 710300);
INSERT INTO `dict_area` VALUES (710350, '麻豆区', 710300);
INSERT INTO `dict_area` VALUES (710351, '佳里区', 710300);
INSERT INTO `dict_area` VALUES (710352, '西港区', 710300);
INSERT INTO `dict_area` VALUES (710353, '七股区', 710300);
INSERT INTO `dict_area` VALUES (710354, '将军区', 710300);
INSERT INTO `dict_area` VALUES (710355, '学甲区', 710300);
INSERT INTO `dict_area` VALUES (710356, '北门区', 710300);
INSERT INTO `dict_area` VALUES (710357, '新营区', 710300);
INSERT INTO `dict_area` VALUES (710358, '后壁区', 710300);
INSERT INTO `dict_area` VALUES (710359, '白河区', 710300);
INSERT INTO `dict_area` VALUES (710360, '东山区', 710300);
INSERT INTO `dict_area` VALUES (710361, '六甲区', 710300);
INSERT INTO `dict_area` VALUES (710362, '下营区', 710300);
INSERT INTO `dict_area` VALUES (710363, '柳营区', 710300);
INSERT INTO `dict_area` VALUES (710364, '盐水区', 710300);
INSERT INTO `dict_area` VALUES (710365, '善化区', 710300);
INSERT INTO `dict_area` VALUES (710366, '大内区', 710300);
INSERT INTO `dict_area` VALUES (710367, '山上区', 710300);
INSERT INTO `dict_area` VALUES (710368, '新市区', 710300);
INSERT INTO `dict_area` VALUES (710369, '安定区', 710300);
INSERT INTO `dict_area` VALUES (710400, '台中市', 710000);
INSERT INTO `dict_area` VALUES (710401, '中区', 710400);
INSERT INTO `dict_area` VALUES (710402, '东区', 710400);
INSERT INTO `dict_area` VALUES (710403, '南区', 710400);
INSERT INTO `dict_area` VALUES (710404, '西区', 710400);
INSERT INTO `dict_area` VALUES (710405, '北区', 710400);
INSERT INTO `dict_area` VALUES (710406, '北屯区', 710400);
INSERT INTO `dict_area` VALUES (710407, '西屯区', 710400);
INSERT INTO `dict_area` VALUES (710408, '南屯区', 710400);
INSERT INTO `dict_area` VALUES (710431, '太平区', 710400);
INSERT INTO `dict_area` VALUES (710432, '大里区', 710400);
INSERT INTO `dict_area` VALUES (710433, '雾峰区', 710400);
INSERT INTO `dict_area` VALUES (710434, '乌日区', 710400);
INSERT INTO `dict_area` VALUES (710435, '丰原区', 710400);
INSERT INTO `dict_area` VALUES (710436, '后里区', 710400);
INSERT INTO `dict_area` VALUES (710437, '石冈区', 710400);
INSERT INTO `dict_area` VALUES (710438, '东势区', 710400);
INSERT INTO `dict_area` VALUES (710439, '和平区', 710400);
INSERT INTO `dict_area` VALUES (710440, '新社区', 710400);
INSERT INTO `dict_area` VALUES (710441, '潭子区', 710400);
INSERT INTO `dict_area` VALUES (710442, '大雅区', 710400);
INSERT INTO `dict_area` VALUES (710443, '神冈区', 710400);
INSERT INTO `dict_area` VALUES (710444, '大肚区', 710400);
INSERT INTO `dict_area` VALUES (710445, '沙鹿区', 710400);
INSERT INTO `dict_area` VALUES (710446, '龙井区', 710400);
INSERT INTO `dict_area` VALUES (710447, '梧栖区', 710400);
INSERT INTO `dict_area` VALUES (710448, '清水区', 710400);
INSERT INTO `dict_area` VALUES (710449, '大甲区', 710400);
INSERT INTO `dict_area` VALUES (710450, '外埔区', 710400);
INSERT INTO `dict_area` VALUES (710451, '大安区', 710400);
INSERT INTO `dict_area` VALUES (710600, '南投县', 710000);
INSERT INTO `dict_area` VALUES (710614, '南投市', 710600);
INSERT INTO `dict_area` VALUES (710615, '中寮乡', 710600);
INSERT INTO `dict_area` VALUES (710616, '草屯镇', 710600);
INSERT INTO `dict_area` VALUES (710617, '国姓乡', 710600);
INSERT INTO `dict_area` VALUES (710618, '埔里镇', 710600);
INSERT INTO `dict_area` VALUES (710619, '仁爱乡', 710600);
INSERT INTO `dict_area` VALUES (710620, '名间乡', 710600);
INSERT INTO `dict_area` VALUES (710621, '集集镇', 710600);
INSERT INTO `dict_area` VALUES (710622, '水里乡', 710600);
INSERT INTO `dict_area` VALUES (710623, '鱼池乡', 710600);
INSERT INTO `dict_area` VALUES (710624, '信义乡', 710600);
INSERT INTO `dict_area` VALUES (710625, '竹山镇', 710600);
INSERT INTO `dict_area` VALUES (710626, '鹿谷乡', 710600);
INSERT INTO `dict_area` VALUES (710700, '基隆市', 710000);
INSERT INTO `dict_area` VALUES (710701, '仁爱区', 710700);
INSERT INTO `dict_area` VALUES (710702, '信义区', 710700);
INSERT INTO `dict_area` VALUES (710703, '中正区', 710700);
INSERT INTO `dict_area` VALUES (710704, '中山区', 710700);
INSERT INTO `dict_area` VALUES (710705, '安乐区', 710700);
INSERT INTO `dict_area` VALUES (710706, '暖暖区', 710700);
INSERT INTO `dict_area` VALUES (710707, '七堵区', 710700);
INSERT INTO `dict_area` VALUES (710800, '新竹市', 710000);
INSERT INTO `dict_area` VALUES (710801, '东区', 710800);
INSERT INTO `dict_area` VALUES (710802, '北区', 710800);
INSERT INTO `dict_area` VALUES (710803, '香山区', 710800);
INSERT INTO `dict_area` VALUES (710900, '嘉义市', 710000);
INSERT INTO `dict_area` VALUES (710901, '东区', 710900);
INSERT INTO `dict_area` VALUES (710902, '西区', 710900);
INSERT INTO `dict_area` VALUES (711100, '新北市', 710000);
INSERT INTO `dict_area` VALUES (711130, '万里区', 711100);
INSERT INTO `dict_area` VALUES (711131, '金山区', 711100);
INSERT INTO `dict_area` VALUES (711132, '板桥区', 711100);
INSERT INTO `dict_area` VALUES (711133, '汐止区', 711100);
INSERT INTO `dict_area` VALUES (711134, '深坑区', 711100);
INSERT INTO `dict_area` VALUES (711135, '石碇区', 711100);
INSERT INTO `dict_area` VALUES (711136, '瑞芳区', 711100);
INSERT INTO `dict_area` VALUES (711137, '平溪区', 711100);
INSERT INTO `dict_area` VALUES (711138, '双溪区', 711100);
INSERT INTO `dict_area` VALUES (711139, '贡寮区', 711100);
INSERT INTO `dict_area` VALUES (711140, '新店区', 711100);
INSERT INTO `dict_area` VALUES (711141, '坪林区', 711100);
INSERT INTO `dict_area` VALUES (711142, '乌来区', 711100);
INSERT INTO `dict_area` VALUES (711143, '永和区', 711100);
INSERT INTO `dict_area` VALUES (711144, '中和区', 711100);
INSERT INTO `dict_area` VALUES (711145, '土城区', 711100);
INSERT INTO `dict_area` VALUES (711146, '三峡区', 711100);
INSERT INTO `dict_area` VALUES (711147, '树林区', 711100);
INSERT INTO `dict_area` VALUES (711148, '莺歌区', 711100);
INSERT INTO `dict_area` VALUES (711149, '三重区', 711100);
INSERT INTO `dict_area` VALUES (711150, '新庄区', 711100);
INSERT INTO `dict_area` VALUES (711151, '泰山区', 711100);
INSERT INTO `dict_area` VALUES (711152, '林口区', 711100);
INSERT INTO `dict_area` VALUES (711153, '芦洲区', 711100);
INSERT INTO `dict_area` VALUES (711154, '五股区', 711100);
INSERT INTO `dict_area` VALUES (711155, '八里区', 711100);
INSERT INTO `dict_area` VALUES (711156, '淡水区', 711100);
INSERT INTO `dict_area` VALUES (711157, '三芝区', 711100);
INSERT INTO `dict_area` VALUES (711158, '石门区', 711100);
INSERT INTO `dict_area` VALUES (711200, '宜兰县', 710000);
INSERT INTO `dict_area` VALUES (711214, '宜兰市', 711200);
INSERT INTO `dict_area` VALUES (711215, '头城镇', 711200);
INSERT INTO `dict_area` VALUES (711216, '礁溪乡', 711200);
INSERT INTO `dict_area` VALUES (711217, '壮围乡', 711200);
INSERT INTO `dict_area` VALUES (711218, '员山乡', 711200);
INSERT INTO `dict_area` VALUES (711219, '罗东镇', 711200);
INSERT INTO `dict_area` VALUES (711220, '三星乡', 711200);
INSERT INTO `dict_area` VALUES (711221, '大同乡', 711200);
INSERT INTO `dict_area` VALUES (711222, '五结乡', 711200);
INSERT INTO `dict_area` VALUES (711223, '冬山乡', 711200);
INSERT INTO `dict_area` VALUES (711224, '苏澳镇', 711200);
INSERT INTO `dict_area` VALUES (711225, '南澳乡', 711200);
INSERT INTO `dict_area` VALUES (711300, '新竹县', 710000);
INSERT INTO `dict_area` VALUES (711314, '竹北市', 711300);
INSERT INTO `dict_area` VALUES (711315, '湖口乡', 711300);
INSERT INTO `dict_area` VALUES (711316, '新丰乡', 711300);
INSERT INTO `dict_area` VALUES (711317, '新埔镇', 711300);
INSERT INTO `dict_area` VALUES (711318, '关西镇', 711300);
INSERT INTO `dict_area` VALUES (711319, '芎林乡', 711300);
INSERT INTO `dict_area` VALUES (711320, '宝山乡', 711300);
INSERT INTO `dict_area` VALUES (711321, '竹东镇', 711300);
INSERT INTO `dict_area` VALUES (711322, '五峰乡', 711300);
INSERT INTO `dict_area` VALUES (711323, '横山乡', 711300);
INSERT INTO `dict_area` VALUES (711324, '尖石乡', 711300);
INSERT INTO `dict_area` VALUES (711325, '北埔乡', 711300);
INSERT INTO `dict_area` VALUES (711326, '峨眉乡', 711300);
INSERT INTO `dict_area` VALUES (711400, '桃园市', 710000);
INSERT INTO `dict_area` VALUES (711414, '中坜区', 711400);
INSERT INTO `dict_area` VALUES (711415, '平镇区', 711400);
INSERT INTO `dict_area` VALUES (711416, '龙潭区', 711400);
INSERT INTO `dict_area` VALUES (711417, '杨梅区', 711400);
INSERT INTO `dict_area` VALUES (711418, '新屋区', 711400);
INSERT INTO `dict_area` VALUES (711419, '观音区', 711400);
INSERT INTO `dict_area` VALUES (711420, '桃园区', 711400);
INSERT INTO `dict_area` VALUES (711421, '龟山区', 711400);
INSERT INTO `dict_area` VALUES (711422, '八德区', 711400);
INSERT INTO `dict_area` VALUES (711423, '大溪区', 711400);
INSERT INTO `dict_area` VALUES (711424, '复兴区', 711400);
INSERT INTO `dict_area` VALUES (711425, '大园区', 711400);
INSERT INTO `dict_area` VALUES (711426, '芦竹区', 711400);
INSERT INTO `dict_area` VALUES (711500, '苗栗县', 710000);
INSERT INTO `dict_area` VALUES (711519, '竹南镇', 711500);
INSERT INTO `dict_area` VALUES (711520, '头份市', 711500);
INSERT INTO `dict_area` VALUES (711521, '三湾乡', 711500);
INSERT INTO `dict_area` VALUES (711522, '南庄乡', 711500);
INSERT INTO `dict_area` VALUES (711523, '狮潭乡', 711500);
INSERT INTO `dict_area` VALUES (711524, '后龙镇', 711500);
INSERT INTO `dict_area` VALUES (711525, '通霄镇', 711500);
INSERT INTO `dict_area` VALUES (711526, '苑里镇', 711500);
INSERT INTO `dict_area` VALUES (711527, '苗栗市', 711500);
INSERT INTO `dict_area` VALUES (711528, '造桥乡', 711500);
INSERT INTO `dict_area` VALUES (711529, '头屋乡', 711500);
INSERT INTO `dict_area` VALUES (711530, '公馆乡', 711500);
INSERT INTO `dict_area` VALUES (711531, '大湖乡', 711500);
INSERT INTO `dict_area` VALUES (711532, '泰安乡', 711500);
INSERT INTO `dict_area` VALUES (711533, '铜锣乡', 711500);
INSERT INTO `dict_area` VALUES (711534, '三义乡', 711500);
INSERT INTO `dict_area` VALUES (711535, '西湖乡', 711500);
INSERT INTO `dict_area` VALUES (711536, '卓兰镇', 711500);
INSERT INTO `dict_area` VALUES (711700, '彰化县', 710000);
INSERT INTO `dict_area` VALUES (711727, '彰化市', 711700);
INSERT INTO `dict_area` VALUES (711728, '芬园乡', 711700);
INSERT INTO `dict_area` VALUES (711729, '花坛乡', 711700);
INSERT INTO `dict_area` VALUES (711730, '秀水乡', 711700);
INSERT INTO `dict_area` VALUES (711731, '鹿港镇', 711700);
INSERT INTO `dict_area` VALUES (711732, '福兴乡', 711700);
INSERT INTO `dict_area` VALUES (711733, '线西乡', 711700);
INSERT INTO `dict_area` VALUES (711734, '和美镇', 711700);
INSERT INTO `dict_area` VALUES (711735, '伸港乡', 711700);
INSERT INTO `dict_area` VALUES (711736, '员林市', 711700);
INSERT INTO `dict_area` VALUES (711737, '社头乡', 711700);
INSERT INTO `dict_area` VALUES (711738, '永靖乡', 711700);
INSERT INTO `dict_area` VALUES (711739, '埔心乡', 711700);
INSERT INTO `dict_area` VALUES (711740, '溪湖镇', 711700);
INSERT INTO `dict_area` VALUES (711741, '大村乡', 711700);
INSERT INTO `dict_area` VALUES (711742, '埔盐乡', 711700);
INSERT INTO `dict_area` VALUES (711743, '田中镇', 711700);
INSERT INTO `dict_area` VALUES (711744, '北斗镇', 711700);
INSERT INTO `dict_area` VALUES (711745, '田尾乡', 711700);
INSERT INTO `dict_area` VALUES (711746, '埤头乡', 711700);
INSERT INTO `dict_area` VALUES (711747, '溪州乡', 711700);
INSERT INTO `dict_area` VALUES (711748, '竹塘乡', 711700);
INSERT INTO `dict_area` VALUES (711749, '二林镇', 711700);
INSERT INTO `dict_area` VALUES (711750, '大城乡', 711700);
INSERT INTO `dict_area` VALUES (711751, '芳苑乡', 711700);
INSERT INTO `dict_area` VALUES (711752, '二水乡', 711700);
INSERT INTO `dict_area` VALUES (711900, '嘉义县', 710000);
INSERT INTO `dict_area` VALUES (711919, '番路乡', 711900);
INSERT INTO `dict_area` VALUES (711920, '梅山乡', 711900);
INSERT INTO `dict_area` VALUES (711921, '竹崎乡', 711900);
INSERT INTO `dict_area` VALUES (711922, '阿里山乡', 711900);
INSERT INTO `dict_area` VALUES (711923, '中埔乡', 711900);
INSERT INTO `dict_area` VALUES (711924, '大埔乡', 711900);
INSERT INTO `dict_area` VALUES (711925, '水上乡', 711900);
INSERT INTO `dict_area` VALUES (711926, '鹿草乡', 711900);
INSERT INTO `dict_area` VALUES (711927, '太保市', 711900);
INSERT INTO `dict_area` VALUES (711928, '朴子市', 711900);
INSERT INTO `dict_area` VALUES (711929, '东石乡', 711900);
INSERT INTO `dict_area` VALUES (711930, '六脚乡', 711900);
INSERT INTO `dict_area` VALUES (711931, '新港乡', 711900);
INSERT INTO `dict_area` VALUES (711932, '民雄乡', 711900);
INSERT INTO `dict_area` VALUES (711933, '大林镇', 711900);
INSERT INTO `dict_area` VALUES (711934, '溪口乡', 711900);
INSERT INTO `dict_area` VALUES (711935, '义竹乡', 711900);
INSERT INTO `dict_area` VALUES (711936, '布袋镇', 711900);
INSERT INTO `dict_area` VALUES (712100, '云林县', 710000);
INSERT INTO `dict_area` VALUES (712121, '斗南镇', 712100);
INSERT INTO `dict_area` VALUES (712122, '大埤乡', 712100);
INSERT INTO `dict_area` VALUES (712123, '虎尾镇', 712100);
INSERT INTO `dict_area` VALUES (712124, '土库镇', 712100);
INSERT INTO `dict_area` VALUES (712125, '褒忠乡', 712100);
INSERT INTO `dict_area` VALUES (712126, '东势乡', 712100);
INSERT INTO `dict_area` VALUES (712127, '台西乡', 712100);
INSERT INTO `dict_area` VALUES (712128, '仑背乡', 712100);
INSERT INTO `dict_area` VALUES (712129, '麦寮乡', 712100);
INSERT INTO `dict_area` VALUES (712130, '斗六市', 712100);
INSERT INTO `dict_area` VALUES (712131, '林内乡', 712100);
INSERT INTO `dict_area` VALUES (712132, '古坑乡', 712100);
INSERT INTO `dict_area` VALUES (712133, '莿桐乡', 712100);
INSERT INTO `dict_area` VALUES (712134, '西螺镇', 712100);
INSERT INTO `dict_area` VALUES (712135, '二仑乡', 712100);
INSERT INTO `dict_area` VALUES (712136, '北港镇', 712100);
INSERT INTO `dict_area` VALUES (712137, '水林乡', 712100);
INSERT INTO `dict_area` VALUES (712138, '口湖乡', 712100);
INSERT INTO `dict_area` VALUES (712139, '四湖乡', 712100);
INSERT INTO `dict_area` VALUES (712140, '元长乡', 712100);
INSERT INTO `dict_area` VALUES (712400, '屏东县', 710000);
INSERT INTO `dict_area` VALUES (712434, '屏东市', 712400);
INSERT INTO `dict_area` VALUES (712435, '三地门乡', 712400);
INSERT INTO `dict_area` VALUES (712436, '雾台乡', 712400);
INSERT INTO `dict_area` VALUES (712437, '玛家乡', 712400);
INSERT INTO `dict_area` VALUES (712438, '九如乡', 712400);
INSERT INTO `dict_area` VALUES (712439, '里港乡', 712400);
INSERT INTO `dict_area` VALUES (712440, '高树乡', 712400);
INSERT INTO `dict_area` VALUES (712441, '盐埔乡', 712400);
INSERT INTO `dict_area` VALUES (712442, '长治乡', 712400);
INSERT INTO `dict_area` VALUES (712443, '麟洛乡', 712400);
INSERT INTO `dict_area` VALUES (712444, '竹田乡', 712400);
INSERT INTO `dict_area` VALUES (712445, '内埔乡', 712400);
INSERT INTO `dict_area` VALUES (712446, '万丹乡', 712400);
INSERT INTO `dict_area` VALUES (712447, '潮州镇', 712400);
INSERT INTO `dict_area` VALUES (712448, '泰武乡', 712400);
INSERT INTO `dict_area` VALUES (712449, '来义乡', 712400);
INSERT INTO `dict_area` VALUES (712450, '万峦乡', 712400);
INSERT INTO `dict_area` VALUES (712451, '崁顶乡', 712400);
INSERT INTO `dict_area` VALUES (712452, '新埤乡', 712400);
INSERT INTO `dict_area` VALUES (712453, '南州乡', 712400);
INSERT INTO `dict_area` VALUES (712454, '林边乡', 712400);
INSERT INTO `dict_area` VALUES (712455, '东港镇', 712400);
INSERT INTO `dict_area` VALUES (712456, '琉球乡', 712400);
INSERT INTO `dict_area` VALUES (712457, '佳冬乡', 712400);
INSERT INTO `dict_area` VALUES (712458, '新园乡', 712400);
INSERT INTO `dict_area` VALUES (712459, '枋寮乡', 712400);
INSERT INTO `dict_area` VALUES (712460, '枋山乡', 712400);
INSERT INTO `dict_area` VALUES (712461, '春日乡', 712400);
INSERT INTO `dict_area` VALUES (712462, '狮子乡', 712400);
INSERT INTO `dict_area` VALUES (712463, '车城乡', 712400);
INSERT INTO `dict_area` VALUES (712464, '牡丹乡', 712400);
INSERT INTO `dict_area` VALUES (712465, '恒春镇', 712400);
INSERT INTO `dict_area` VALUES (712466, '满州乡', 712400);
INSERT INTO `dict_area` VALUES (712500, '台东县', 710000);
INSERT INTO `dict_area` VALUES (712517, '台东市', 712500);
INSERT INTO `dict_area` VALUES (712518, '绿岛乡', 712500);
INSERT INTO `dict_area` VALUES (712519, '兰屿乡', 712500);
INSERT INTO `dict_area` VALUES (712520, '延平乡', 712500);
INSERT INTO `dict_area` VALUES (712521, '卑南乡', 712500);
INSERT INTO `dict_area` VALUES (712522, '鹿野乡', 712500);
INSERT INTO `dict_area` VALUES (712523, '关山镇', 712500);
INSERT INTO `dict_area` VALUES (712524, '海端乡', 712500);
INSERT INTO `dict_area` VALUES (712525, '池上乡', 712500);
INSERT INTO `dict_area` VALUES (712526, '东河乡', 712500);
INSERT INTO `dict_area` VALUES (712527, '成功镇', 712500);
INSERT INTO `dict_area` VALUES (712528, '长滨乡', 712500);
INSERT INTO `dict_area` VALUES (712529, '金峰乡', 712500);
INSERT INTO `dict_area` VALUES (712530, '大武乡', 712500);
INSERT INTO `dict_area` VALUES (712531, '达仁乡', 712500);
INSERT INTO `dict_area` VALUES (712532, '太麻里乡', 712500);
INSERT INTO `dict_area` VALUES (712600, '花莲县', 710000);
INSERT INTO `dict_area` VALUES (712615, '花莲市', 712600);
INSERT INTO `dict_area` VALUES (712616, '新城乡', 712600);
INSERT INTO `dict_area` VALUES (712618, '秀林乡', 712600);
INSERT INTO `dict_area` VALUES (712619, '吉安乡', 712600);
INSERT INTO `dict_area` VALUES (712620, '寿丰乡', 712600);
INSERT INTO `dict_area` VALUES (712621, '凤林镇', 712600);
INSERT INTO `dict_area` VALUES (712622, '光复乡', 712600);
INSERT INTO `dict_area` VALUES (712623, '丰滨乡', 712600);
INSERT INTO `dict_area` VALUES (712624, '瑞穗乡', 712600);
INSERT INTO `dict_area` VALUES (712625, '万荣乡', 712600);
INSERT INTO `dict_area` VALUES (712626, '玉里镇', 712600);
INSERT INTO `dict_area` VALUES (712627, '卓溪乡', 712600);
INSERT INTO `dict_area` VALUES (712628, '富里乡', 712600);
INSERT INTO `dict_area` VALUES (712700, '澎湖县', 710000);
INSERT INTO `dict_area` VALUES (712707, '马公市', 712700);
INSERT INTO `dict_area` VALUES (712708, '西屿乡', 712700);
INSERT INTO `dict_area` VALUES (712709, '望安乡', 712700);
INSERT INTO `dict_area` VALUES (712710, '七美乡', 712700);
INSERT INTO `dict_area` VALUES (712711, '白沙乡', 712700);
INSERT INTO `dict_area` VALUES (712712, '湖西乡', 712700);
INSERT INTO `dict_area` VALUES (810000, '香港特别行政区', NULL);
INSERT INTO `dict_area` VALUES (810100, '香港特别行政区', 810000);
INSERT INTO `dict_area` VALUES (810101, '中西区', 810100);
INSERT INTO `dict_area` VALUES (810102, '东区', 810100);
INSERT INTO `dict_area` VALUES (810103, '九龙城区', 810100);
INSERT INTO `dict_area` VALUES (810104, '观塘区', 810100);
INSERT INTO `dict_area` VALUES (810105, '南区', 810100);
INSERT INTO `dict_area` VALUES (810106, '深水埗区', 810100);
INSERT INTO `dict_area` VALUES (810107, '湾仔区', 810100);
INSERT INTO `dict_area` VALUES (810108, '黄大仙区', 810100);
INSERT INTO `dict_area` VALUES (810109, '油尖旺区', 810100);
INSERT INTO `dict_area` VALUES (810110, '离岛区', 810100);
INSERT INTO `dict_area` VALUES (810111, '葵青区', 810100);
INSERT INTO `dict_area` VALUES (810112, '北区', 810100);
INSERT INTO `dict_area` VALUES (810113, '西贡区', 810100);
INSERT INTO `dict_area` VALUES (810114, '沙田区', 810100);
INSERT INTO `dict_area` VALUES (810115, '屯门区', 810100);
INSERT INTO `dict_area` VALUES (810116, '大埔区', 810100);
INSERT INTO `dict_area` VALUES (810117, '荃湾区', 810100);
INSERT INTO `dict_area` VALUES (810118, '元朗区', 810100);
INSERT INTO `dict_area` VALUES (820000, '澳门特别行政区', NULL);
INSERT INTO `dict_area` VALUES (820100, '澳门特别行政区', 820000);
INSERT INTO `dict_area` VALUES (820101, '澳门半岛', 820100);
INSERT INTO `dict_area` VALUES (820102, '凼仔', 820100);
INSERT INTO `dict_area` VALUES (820103, '路凼城', 820100);
INSERT INTO `dict_area` VALUES (820104, '路环', 820100);

SET FOREIGN_KEY_CHECKS = 1;
派森先生
关注
1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
最新-中国城市编码sql版下篇

INSERT INTO `dict_area` VALUES (410481, '舞钢市', 410400);INSERT INTO `dict_area` VALUES (410482, '汝州市', 410400);INSERT INTO `dict_area` VALUES (410500, '安阳市', 410000);INSERT INTO `dict_area` VALUES (410502, '文峰区', 410500);INSERT INTO `dict_area` VALUES (
复制链接

扫一扫