省市区三级行政区代码（包含港澳台）sql3

一、sql

INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431024', '431000', '0,430000,431000', '嘉禾县', 'jiahexian', '湖南省郴州市嘉禾县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431025', '431000', '0,430000,431000', '临武县', 'linwuxian', '湖南省郴州市临武县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431026', '431000', '0,430000,431000', '汝城县', 'ruchengxian', '湖南省郴州市汝城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431027', '431000', '0,430000,431000', '桂东县', 'guidongxian', '湖南省郴州市桂东县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431028', '431000', '0,430000,431000', '安仁县', 'anrenxian', '湖南省郴州市安仁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431081', '431000', '0,430000,431000', '资兴市', 'zixingshi', '湖南省郴州市资兴市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431100', '430000', '0,430000', '永州市', 'yongzhoushi', '湖南省永州市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431102', '431100', '0,430000,431100', '零陵区', 'linglingqu', '湖南省永州市零陵区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431103', '431100', '0,430000,431100', '冷水滩区', 'lengshuitanqu', '湖南省永州市冷水滩区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431122', '431100', '0,430000,431100', '东安县', 'donganxian', '湖南省永州市东安县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431123', '431100', '0,430000,431100', '双牌县', 'shuangpaixian', '湖南省永州市双牌县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431124', '431100', '0,430000,431100', '道县', 'daoxian', '湖南省永州市道县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431125', '431100', '0,430000,431100', '江永县', 'jiangyongxian', '湖南省永州市江永县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431126', '431100', '0,430000,431100', '宁远县', 'ningyuanxian', '湖南省永州市宁远县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431127', '431100', '0,430000,431100', '蓝山县', 'lanshanxian', '湖南省永州市蓝山县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431128', '431100', '0,430000,431100', '新田县', 'xintianxian', '湖南省永州市新田县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431129', '431100', '0,430000,431100', '江华瑶族自治县', 'jianghuayaozuzizhixian', '湖南省永州市江华瑶族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431171', '431100', '0,430000,431100', '永州经济技术开发区', 'yongzhoujingjijishukaifaqu', '湖南省永州市永州经济技术开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431173', '431100', '0,430000,431100', '永州市回龙圩管理区', 'yongzhoushihuilongweiguanliqu', '湖南省永州市永州市回龙圩管理区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431181', '431100', '0,430000,431100', '祁阳市', 'qiyangshi', '湖南省永州市祁阳市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431200', '430000', '0,430000', '怀化市', 'huaihuashi', '湖南省怀化市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431202', '431200', '0,430000,431200', '鹤城区', 'hechengqu', '湖南省怀化市鹤城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431221', '431200', '0,430000,431200', '中方县', 'zhongfangxian', '湖南省怀化市中方县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431222', '431200', '0,430000,431200', '沅陵县', 'yuanlingxian', '湖南省怀化市沅陵县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431223', '431200', '0,430000,431200', '辰溪县', 'chenxixian', '湖南省怀化市辰溪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431224', '431200', '0,430000,431200', '溆浦县', 'xupuxian', '湖南省怀化市溆浦县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431225', '431200', '0,430000,431200', '会同县', 'huitongxian', '湖南省怀化市会同县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431226', '431200', '0,430000,431200', '麻阳苗族自治县', 'mayangmiaozuzizhixian', '湖南省怀化市麻阳苗族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431227', '431200', '0,430000,431200', '新晃侗族自治县', 'xinhuangdongzuzizhixian', '湖南省怀化市新晃侗族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431228', '431200', '0,430000,431200', '芷江侗族自治县', 'zhijiangdongzuzizhixian', '湖南省怀化市芷江侗族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431229', '431200', '0,430000,431200', '靖州苗族侗族自治县', 'jingzhoumiaozudongzuzizhixian', '湖南省怀化市靖州苗族侗族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431230', '431200', '0,430000,431200', '通道侗族自治县', 'tongdaodongzuzizhixian', '湖南省怀化市通道侗族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431271', '431200', '0,430000,431200', '怀化市洪江管理区', 'huaihuashihongjiangguanliqu', '湖南省怀化市怀化市洪江管理区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431281', '431200', '0,430000,431200', '洪江市', 'hongjiangshi', '湖南省怀化市洪江市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431300', '430000', '0,430000', '娄底市', 'loudishi', '湖南省娄底市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431302', '431300', '0,430000,431300', '娄星区', 'louxingqu', '湖南省娄底市娄星区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431321', '431300', '0,430000,431300', '双峰县', 'shuangfengxian', '湖南省娄底市双峰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431322', '431300', '0,430000,431300', '新化县', 'xinhuaxian', '湖南省娄底市新化县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431381', '431300', '0,430000,431300', '冷水江市', 'lengshuijiangshi', '湖南省娄底市冷水江市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('431382', '431300', '0,430000,431300', '涟源市', 'lianyuanshi', '湖南省娄底市涟源市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433100', '430000', '0,430000', '湘西土家族苗族自治州', 'xiangxitujiazumiaozuzizhizhou', '湖南省湘西土家族苗族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433101', '433100', '0,430000,433100', '吉首市', 'jishoushi', '湖南省湘西土家族苗族自治州吉首市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433122', '433100', '0,430000,433100', '泸溪县', 'luxixian', '湖南省湘西土家族苗族自治州泸溪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433123', '433100', '0,430000,433100', '凤凰县', 'fenghuangxian', '湖南省湘西土家族苗族自治州凤凰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433124', '433100', '0,430000,433100', '花垣县', 'huayuanxian', '湖南省湘西土家族苗族自治州花垣县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433125', '433100', '0,430000,433100', '保靖县', 'baojingxian', '湖南省湘西土家族苗族自治州保靖县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433126', '433100', '0,430000,433100', '古丈县', 'guzhangxian', '湖南省湘西土家族苗族自治州古丈县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433127', '433100', '0,430000,433100', '永顺县', 'yongshunxian', '湖南省湘西土家族苗族自治州永顺县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('433130', '433100', '0,430000,433100', '龙山县', 'longshanxian', '湖南省湘西土家族苗族自治州龙山县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440000', '0', '0', '广东省', 'guangdongsheng', '广东省', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440100', '440000', '0,440000', '广州市', 'guangzhoushi', '广东省广州市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440103', '440100', '0,440000,440100', '荔湾区', 'liwanqu', '广东省广州市荔湾区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440104', '440100', '0,440000,440100', '越秀区', 'yuexiuqu', '广东省广州市越秀区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440105', '440100', '0,440000,440100', '海珠区', 'haizhuqu', '广东省广州市海珠区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440106', '440100', '0,440000,440100', '天河区', 'tianhequ', '广东省广州市天河区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440111', '440100', '0,440000,440100', '白云区', 'baiyunqu', '广东省广州市白云区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440112', '440100', '0,440000,440100', '黄埔区', 'huangpuqu', '广东省广州市黄埔区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440113', '440100', '0,440000,440100', '番禺区', 'fanyuqu', '广东省广州市番禺区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440114', '440100', '0,440000,440100', '花都区', 'huadouqu', '广东省广州市花都区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440115', '440100', '0,440000,440100', '南沙区', 'nanshaqu', '广东省广州市南沙区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440117', '440100', '0,440000,440100', '从化区', 'conghuaqu', '广东省广州市从化区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440118', '440100', '0,440000,440100', '增城区', 'zengchengqu', '广东省广州市增城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440200', '440000', '0,440000', '韶关市', 'shaoguanshi', '广东省韶关市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440203', '440200', '0,440000,440200', '武江区', 'wujiangqu', '广东省韶关市武江区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440204', '440200', '0,440000,440200', '浈江区', 'zhenjiangqu', '广东省韶关市浈江区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440205', '440200', '0,440000,440200', '曲江区', 'qujiangqu', '广东省韶关市曲江区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440222', '440200', '0,440000,440200', '始兴县', 'shixingxian', '广东省韶关市始兴县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440224', '440200', '0,440000,440200', '仁化县', 'renhuaxian', '广东省韶关市仁化县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440229', '440200', '0,440000,440200', '翁源县', 'wengyuanxian', '广东省韶关市翁源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440232', '440200', '0,440000,440200', '乳源瑶族自治县', 'ruyuanyaozuzizhixian', '广东省韶关市乳源瑶族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440233', '440200', '0,440000,440200', '新丰县', 'xinfengxian', '广东省韶关市新丰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440281', '440200', '0,440000,440200', '乐昌市', 'lechangshi', '广东省韶关市乐昌市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440282', '440200', '0,440000,440200', '南雄市', 'nanxiongshi', '广东省韶关市南雄市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440300', '440000', '0,440000', '深圳市', 'shenzhenshi', '广东省深圳市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440303', '440300', '0,440000,440300', '罗湖区', 'luohuqu', '广东省深圳市罗湖区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440304', '440300', '0,440000,440300', '福田区', 'futianqu', '广东省深圳市福田区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440305', '440300', '0,440000,440300', '南山区', 'nanshanqu', '广东省深圳市南山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440306', '440300', '0,440000,440300', '宝安区', 'baoanqu', '广东省深圳市宝安区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440307', '440300', '0,440000,440300', '龙岗区', 'longgangqu', '广东省深圳市龙岗区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440308', '440300', '0,440000,440300', '盐田区', 'yantianqu', '广东省深圳市盐田区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440309', '440300', '0,440000,440300', '龙华区', 'longhuaqu', '广东省深圳市龙华区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440310', '440300', '0,440000,440300', '坪山区', 'pingshanqu', '广东省深圳市坪山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440311', '440300', '0,440000,440300', '光明区', 'guangmingqu', '广东省深圳市光明区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440400', '440000', '0,440000', '珠海市', 'zhuhaishi', '广东省珠海市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440402', '440400', '0,440000,440400', '香洲区', 'xiangzhouqu', '广东省珠海市香洲区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440403', '440400', '0,440000,440400', '斗门区', 'doumenqu', '广东省珠海市斗门区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440404', '440400', '0,440000,440400', '金湾区', 'jinwanqu', '广东省珠海市金湾区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440500', '440000', '0,440000', '汕头市', 'shantoushi', '广东省汕头市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440507', '440500', '0,440000,440500', '龙湖区', 'longhuqu', '广东省汕头市龙湖区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440511', '440500', '0,440000,440500', '金平区', 'jinpingqu', '广东省汕头市金平区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440512', '440500', '0,440000,440500', '濠江区', 'haojiangqu', '广东省汕头市濠江区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440513', '440500', '0,440000,440500', '潮阳区', 'chaoyangqu', '广东省汕头市潮阳区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440514', '440500', '0,440000,440500', '潮南区', 'chaonanqu', '广东省汕头市潮南区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440515', '440500', '0,440000,440500', '澄海区', 'chenghaiqu', '广东省汕头市澄海区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440523', '440500', '0,440000,440500', '南澳县', 'nanaoxian', '广东省汕头市南澳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440600', '440000', '0,440000', '佛山市', 'foshanshi', '广东省佛山市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440604', '440600', '0,440000,440600', '禅城区', 'shanchengqu', '广东省佛山市禅城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440605', '440600', '0,440000,440600', '南海区', 'nanhaiqu', '广东省佛山市南海区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440606', '440600', '0,440000,440600', '顺德区', 'shundequ', '广东省佛山市顺德区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440607', '440600', '0,440000,440600', '三水区', 'sanshuiqu', '广东省佛山市三水区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440608', '440600', '0,440000,440600', '高明区', 'gaomingqu', '广东省佛山市高明区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440700', '440000', '0,440000', '江门市', 'jiangmenshi', '广东省江门市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440703', '440700', '0,440000,440700', '蓬江区', 'pengjiangqu', '广东省江门市蓬江区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440704', '440700', '0,440000,440700', '江海区', 'jianghaiqu', '广东省江门市江海区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440705', '440700', '0,440000,440700', '新会区', 'xinhuiqu', '广东省江门市新会区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440781', '440700', '0,440000,440700', '台山市', 'taishanshi', '广东省江门市台山市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440783', '440700', '0,440000,440700', '开平市', 'kaipingshi', '广东省江门市开平市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440784', '440700', '0,440000,440700', '鹤山市', 'heshanshi', '广东省江门市鹤山市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440785', '440700', '0,440000,440700', '恩平市', 'enpingshi', '广东省江门市恩平市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440800', '440000', '0,440000', '湛江市', 'zhanjiangshi', '广东省湛江市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440802', '440800', '0,440000,440800', '赤坎区', 'chikanqu', '广东省湛江市赤坎区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440803', '440800', '0,440000,440800', '霞山区', 'xiashanqu', '广东省湛江市霞山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440804', '440800', '0,440000,440800', '坡头区', 'potouqu', '广东省湛江市坡头区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440811', '440800', '0,440000,440800', '麻章区', 'mazhangqu', '广东省湛江市麻章区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440823', '440800', '0,440000,440800', '遂溪县', 'suixixian', '广东省湛江市遂溪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440825', '440800', '0,440000,440800', '徐闻县', 'xuwenxian', '广东省湛江市徐闻县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440881', '440800', '0,440000,440800', '廉江市', 'lianjiangshi', '广东省湛江市廉江市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440882', '440800', '0,440000,440800', '雷州市', 'leizhoushi', '广东省湛江市雷州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440883', '440800', '0,440000,440800', '吴川市', 'wuchuanshi', '广东省湛江市吴川市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440900', '440000', '0,440000', '茂名市', 'maomingshi', '广东省茂名市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440902', '440900', '0,440000,440900', '茂南区', 'maonanqu', '广东省茂名市茂南区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440904', '440900', '0,440000,440900', '电白区', 'dianbaiqu', '广东省茂名市电白区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440981', '440900', '0,440000,440900', '高州市', 'gaozhoushi', '广东省茂名市高州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440982', '440900', '0,440000,440900', '化州市', 'huazhoushi', '广东省茂名市化州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('440983', '440900', '0,440000,440900', '信宜市', 'xinyishi', '广东省茂名市信宜市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441200', '440000', '0,440000', '肇庆市', 'zhaoqingshi', '广东省肇庆市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441202', '441200', '0,440000,441200', '端州区', 'duanzhouqu', '广东省肇庆市端州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441203', '441200', '0,440000,441200', '鼎湖区', 'dinghuqu', '广东省肇庆市鼎湖区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441204', '441200', '0,440000,441200', '高要区', 'gaoyaoqu', '广东省肇庆市高要区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441223', '441200', '0,440000,441200', '广宁县', 'guangningxian', '广东省肇庆市广宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441224', '441200', '0,440000,441200', '怀集县', 'huaijixian', '广东省肇庆市怀集县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441225', '441200', '0,440000,441200', '封开县', 'fengkaixian', '广东省肇庆市封开县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441226', '441200', '0,440000,441200', '德庆县', 'deqingxian', '广东省肇庆市德庆县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441284', '441200', '0,440000,441200', '四会市', 'sihuishi', '广东省肇庆市四会市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441300', '440000', '0,440000', '惠州市', 'huizhoushi', '广东省惠州市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441302', '441300', '0,440000,441300', '惠城区', 'huichengqu', '广东省惠州市惠城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441303', '441300', '0,440000,441300', '惠阳区', 'huiyangqu', '广东省惠州市惠阳区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441322', '441300', '0,440000,441300', '博罗县', 'boluoxian', '广东省惠州市博罗县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441323', '441300', '0,440000,441300', '惠东县', 'huidongxian', '广东省惠州市惠东县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441324', '441300', '0,440000,441300', '龙门县', 'longmenxian', '广东省惠州市龙门县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441400', '440000', '0,440000', '梅州市', 'meizhoushi', '广东省梅州市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441402', '441400', '0,440000,441400', '梅江区', 'meijiangqu', '广东省梅州市梅江区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441403', '441400', '0,440000,441400', '梅县区', 'meixianqu', '广东省梅州市梅县区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441422', '441400', '0,440000,441400', '大埔县', 'dapuxian', '广东省梅州市大埔县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441423', '441400', '0,440000,441400', '丰顺县', 'fengshunxian', '广东省梅州市丰顺县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441424', '441400', '0,440000,441400', '五华县', 'wuhuaxian', '广东省梅州市五华县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441426', '441400', '0,440000,441400', '平远县', 'pingyuanxian', '广东省梅州市平远县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441427', '441400', '0,440000,441400', '蕉岭县', 'jiaolingxian', '广东省梅州市蕉岭县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441481', '441400', '0,440000,441400', '兴宁市', 'xingningshi', '广东省梅州市兴宁市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441500', '440000', '0,440000', '汕尾市', 'shanweishi', '广东省汕尾市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441502', '441500', '0,440000,441500', '城区', 'chengqu', '广东省汕尾市城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441521', '441500', '0,440000,441500', '海丰县', 'haifengxian', '广东省汕尾市海丰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441523', '441500', '0,440000,441500', '陆河县', 'luhexian', '广东省汕尾市陆河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441581', '441500', '0,440000,441500', '陆丰市', 'lufengshi', '广东省汕尾市陆丰市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441600', '440000', '0,440000', '河源市', 'heyuanshi', '广东省河源市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441602', '441600', '0,440000,441600', '源城区', 'yuanchengqu', '广东省河源市源城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441621', '441600', '0,440000,441600', '紫金县', 'zijinxian', '广东省河源市紫金县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441622', '441600', '0,440000,441600', '龙川县', 'longchuanxian', '广东省河源市龙川县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441623', '441600', '0,440000,441600', '连平县', 'lianpingxian', '广东省河源市连平县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441624', '441600', '0,440000,441600', '和平县', 'hepingxian', '广东省河源市和平县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441625', '441600', '0,440000,441600', '东源县', 'dongyuanxian', '广东省河源市东源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441700', '440000', '0,440000', '阳江市', 'yangjiangshi', '广东省阳江市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441702', '441700', '0,440000,441700', '江城区', 'jiangchengqu', '广东省阳江市江城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441704', '441700', '0,440000,441700', '阳东区', 'yangdongqu', '广东省阳江市阳东区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441721', '441700', '0,440000,441700', '阳西县', 'yangxixian', '广东省阳江市阳西县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441781', '441700', '0,440000,441700', '阳春市', 'yangchunshi', '广东省阳江市阳春市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441800', '440000', '0,440000', '清远市', 'qingyuanshi', '广东省清远市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441802', '441800', '0,440000,441800', '清城区', 'qingchengqu', '广东省清远市清城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441803', '441800', '0,440000,441800', '清新区', 'qingxinqu', '广东省清远市清新区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441821', '441800', '0,440000,441800', '佛冈县', 'fogangxian', '广东省清远市佛冈县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441823', '441800', '0,440000,441800', '阳山县', 'yangshanxian', '广东省清远市阳山县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441825', '441800', '0,440000,441800', '连山壮族瑶族自治县', 'lianshanzhuangzuyaozuzizhixian', '广东省清远市连山壮族瑶族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441826', '441800', '0,440000,441800', '连南瑶族自治县', 'liannanyaozuzizhixian', '广东省清远市连南瑶族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441881', '441800', '0,440000,441800', '英德市', 'yingdeshi', '广东省清远市英德市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441882', '441800', '0,440000,441800', '连州市', 'lianzhoushi', '广东省清远市连州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('441900', '440000', '0,440000', '东莞市', 'dongguanshi', '广东省东莞市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('442000', '440000', '0,440000', '中山市', 'zhongshanshi', '广东省中山市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445100', '440000', '0,440000', '潮州市', 'chaozhoushi', '广东省潮州市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445102', '445100', '0,440000,445100', '湘桥区', 'xiangqiaoqu', '广东省潮州市湘桥区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445103', '445100', '0,440000,445100', '潮安区', 'chaoanqu', '广东省潮州市潮安区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445122', '445100', '0,440000,445100', '饶平县', 'raopingxian', '广东省潮州市饶平县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445200', '440000', '0,440000', '揭阳市', 'jieyangshi', '广东省揭阳市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445202', '445200', '0,440000,445200', '榕城区', 'rongchengqu', '广东省揭阳市榕城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445203', '445200', '0,440000,445200', '揭东区', 'jiedongqu', '广东省揭阳市揭东区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445222', '445200', '0,440000,445200', '揭西县', 'jiexixian', '广东省揭阳市揭西县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445224', '445200', '0,440000,445200', '惠来县', 'huilaixian', '广东省揭阳市惠来县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445281', '445200', '0,440000,445200', '普宁市', 'puningshi', '广东省揭阳市普宁市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445300', '440000', '0,440000', '云浮市', 'yunfushi', '广东省云浮市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445302', '445300', '0,440000,445300', '云城区', 'yunchengqu', '广东省云浮市云城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445303', '445300', '0,440000,445300', '云安区', 'yunanqu', '广东省云浮市云安区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445321', '445300', '0,440000,445300', '新兴县', 'xinxingxian', '广东省云浮市新兴县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445322', '445300', '0,440000,445300', '郁南县', 'yunanxian', '广东省云浮市郁南县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('445381', '445300', '0,440000,445300', '罗定市', 'luodingshi', '广东省云浮市罗定市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450000', '0', '0', '广西壮族自治区', 'guangxizhuangzuzizhiqu', '广西壮族自治区', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450100', '450000', '0,450000', '南宁市', 'nanningshi', '广西壮族自治区南宁市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450102', '450100', '0,450000,450100', '兴宁区', 'xingningqu', '广西壮族自治区南宁市兴宁区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450103', '450100', '0,450000,450100', '青秀区', 'qingxiuqu', '广西壮族自治区南宁市青秀区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450105', '450100', '0,450000,450100', '江南区', 'jiangnanqu', '广西壮族自治区南宁市江南区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450107', '450100', '0,450000,450100', '西乡塘区', 'xixiangtangqu', '广西壮族自治区南宁市西乡塘区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450108', '450100', '0,450000,450100', '良庆区', 'liangqingqu', '广西壮族自治区南宁市良庆区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('450109', '450100', '0,450000,450100', '邕宁区', 'yongningqu', '广西壮族自治区南宁市邕宁区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`,