代码拉取完成,页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50150
Source Host : localhost:3306
Source Database : btdb
Target Server Type : MYSQL
Target Server Version : 50150
File Encoding : 65001
Date: 2013-05-14 21:29:14
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `bt_area`
-- ----------------------------
DROP TABLE IF EXISTS `bt_area`;
CREATE TABLE `bt_area` (
`areaid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '地址ID',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '地区名字',
`parentid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '上级路径ID',
`vieworder` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '顺序',
PRIMARY KEY (`areaid`),
KEY `idx_name` (`name`),
KEY `idx_parentid_vieworder` (`parentid`,`vieworder`)
) ENGINE=MyISAM AUTO_INCREMENT=820792 DEFAULT CHARSET=gbk COMMENT='统一地区库';
-- ----------------------------
-- Records of bt_area
-- ----------------------------
INSERT INTO `bt_area` VALUES ('11', '北京', '0', '1');
INSERT INTO `bt_area` VALUES ('31', '上海', '0', '2');
INSERT INTO `bt_area` VALUES ('44', '广东', '0', '3');
INSERT INTO `bt_area` VALUES ('34', '安徽', '0', '4');
INSERT INTO `bt_area` VALUES ('50', '重庆', '0', '5');
INSERT INTO `bt_area` VALUES ('35', '福建', '0', '6');
INSERT INTO `bt_area` VALUES ('46', '海南', '0', '7');
INSERT INTO `bt_area` VALUES ('13', '河北', '0', '8');
INSERT INTO `bt_area` VALUES ('41', '河南', '0', '9');
INSERT INTO `bt_area` VALUES ('23', '黑龙江', '0', '10');
INSERT INTO `bt_area` VALUES ('42', '湖北', '0', '11');
INSERT INTO `bt_area` VALUES ('43', '湖南', '0', '12');
INSERT INTO `bt_area` VALUES ('62', '甘肃', '0', '13');
INSERT INTO `bt_area` VALUES ('45', '广西', '0', '14');
INSERT INTO `bt_area` VALUES ('52', '贵州', '0', '15');
INSERT INTO `bt_area` VALUES ('22', '吉林', '0', '16');
INSERT INTO `bt_area` VALUES ('36', '江西', '0', '17');
INSERT INTO `bt_area` VALUES ('32', '江苏', '0', '18');
INSERT INTO `bt_area` VALUES ('21', '辽宁', '0', '19');
INSERT INTO `bt_area` VALUES ('15', '内蒙古', '0', '20');
INSERT INTO `bt_area` VALUES ('64', '宁夏', '0', '21');
INSERT INTO `bt_area` VALUES ('63', '青海', '0', '22');
INSERT INTO `bt_area` VALUES ('37', '山东', '0', '23');
INSERT INTO `bt_area` VALUES ('14', '山西', '0', '24');
INSERT INTO `bt_area` VALUES ('61', '陕西', '0', '25');
INSERT INTO `bt_area` VALUES ('51', '四川', '0', '26');
INSERT INTO `bt_area` VALUES ('12', '天津', '0', '27');
INSERT INTO `bt_area` VALUES ('54', '西藏', '0', '28');
INSERT INTO `bt_area` VALUES ('65', '新疆', '0', '29');
INSERT INTO `bt_area` VALUES ('53', '云南', '0', '30');
INSERT INTO `bt_area` VALUES ('33', '浙江', '0', '31');
INSERT INTO `bt_area` VALUES ('71', '台湾', '0', '32');
INSERT INTO `bt_area` VALUES ('81', '香港', '0', '33');
INSERT INTO `bt_area` VALUES ('82', '澳门', '0', '34');
INSERT INTO `bt_area` VALUES ('1129', '延庆', '11', '18');
INSERT INTO `bt_area` VALUES ('1128', '密云', '11', '17');
INSERT INTO `bt_area` VALUES ('1127', '怀柔', '11', '16');
INSERT INTO `bt_area` VALUES ('1126', '平谷', '11', '15');
INSERT INTO `bt_area` VALUES ('1124', '大兴', '11', '14');
INSERT INTO `bt_area` VALUES ('1121', '昌平', '11', '13');
INSERT INTO `bt_area` VALUES ('1113', '顺义', '11', '12');
INSERT INTO `bt_area` VALUES ('1112', '通州', '11', '11');
INSERT INTO `bt_area` VALUES ('1111', '房山', '11', '10');
INSERT INTO `bt_area` VALUES ('1109', '门头沟', '11', '9');
INSERT INTO `bt_area` VALUES ('1108', '海淀', '11', '8');
INSERT INTO `bt_area` VALUES ('1107', '石景山', '11', '7');
INSERT INTO `bt_area` VALUES ('1106', '丰台', '11', '6');
INSERT INTO `bt_area` VALUES ('1105', '朝阳', '11', '5');
INSERT INTO `bt_area` VALUES ('1104', '宣武', '11', '4');
INSERT INTO `bt_area` VALUES ('1103', '崇文', '11', '3');
INSERT INTO `bt_area` VALUES ('1102', '西城', '11', '2');
INSERT INTO `bt_area` VALUES ('1101', '东城', '11', '1');
INSERT INTO `bt_area` VALUES ('1201', '和平', '12', '1');
INSERT INTO `bt_area` VALUES ('1202', '河东', '12', '2');
INSERT INTO `bt_area` VALUES ('1203', '河西', '12', '3');
INSERT INTO `bt_area` VALUES ('1204', '南开', '12', '4');
INSERT INTO `bt_area` VALUES ('1205', '河北', '12', '5');
INSERT INTO `bt_area` VALUES ('1206', '红桥', '12', '6');
INSERT INTO `bt_area` VALUES ('1207', '滨海新区', '12', '7');
INSERT INTO `bt_area` VALUES ('1210', '东丽', '12', '8');
INSERT INTO `bt_area` VALUES ('1211', '西青', '12', '9');
INSERT INTO `bt_area` VALUES ('1212', '津南', '12', '10');
INSERT INTO `bt_area` VALUES ('1213', '北辰', '12', '11');
INSERT INTO `bt_area` VALUES ('1221', '宁河', '12', '12');
INSERT INTO `bt_area` VALUES ('1222', '武清', '12', '13');
INSERT INTO `bt_area` VALUES ('1223', '静海', '12', '14');
INSERT INTO `bt_area` VALUES ('1224', '宝坻', '12', '15');
INSERT INTO `bt_area` VALUES ('1225', '蓟县', '12', '16');
INSERT INTO `bt_area` VALUES ('1301', '石家庄', '13', '1');
INSERT INTO `bt_area` VALUES ('1302', '唐山', '13', '2');
INSERT INTO `bt_area` VALUES ('1303', '秦皇岛', '13', '3');
INSERT INTO `bt_area` VALUES ('1304', '邯郸', '13', '4');
INSERT INTO `bt_area` VALUES ('1305', '邢台', '13', '5');
INSERT INTO `bt_area` VALUES ('1306', '保定', '13', '6');
INSERT INTO `bt_area` VALUES ('1307', '张家口', '13', '7');
INSERT INTO `bt_area` VALUES ('1308', '承德', '13', '8');
INSERT INTO `bt_area` VALUES ('1309', '沧州', '13', '9');
INSERT INTO `bt_area` VALUES ('1310', '廊坊', '13', '10');
INSERT INTO `bt_area` VALUES ('1311', '衡水', '13', '11');
INSERT INTO `bt_area` VALUES ('1401', '太原', '14', '1');
INSERT INTO `bt_area` VALUES ('1402', '大同', '14', '2');
INSERT INTO `bt_area` VALUES ('1403', '阳泉', '14', '3');
INSERT INTO `bt_area` VALUES ('1404', '长治', '14', '4');
INSERT INTO `bt_area` VALUES ('1405', '晋城', '14', '5');
INSERT INTO `bt_area` VALUES ('1406', '朔州', '14', '6');
INSERT INTO `bt_area` VALUES ('1407', '晋中', '14', '7');
INSERT INTO `bt_area` VALUES ('1408', '运城', '14', '8');
INSERT INTO `bt_area` VALUES ('1409', '忻州', '14', '9');
INSERT INTO `bt_area` VALUES ('1410', '临汾', '14', '10');
INSERT INTO `bt_area` VALUES ('1411', '吕梁', '14', '11');
INSERT INTO `bt_area` VALUES ('1501', '呼和浩特', '15', '1');
INSERT INTO `bt_area` VALUES ('1502', '包头', '15', '2');
INSERT INTO `bt_area` VALUES ('1503', '乌海', '15', '3');
INSERT INTO `bt_area` VALUES ('1504', '赤峰', '15', '4');
INSERT INTO `bt_area` VALUES ('1505', '通辽', '15', '5');
INSERT INTO `bt_area` VALUES ('1506', '鄂尔多斯', '15', '6');
INSERT INTO `bt_area` VALUES ('1507', '呼伦贝尔', '15', '7');
INSERT INTO `bt_area` VALUES ('1508', '巴彦淖尔', '15', '8');
INSERT INTO `bt_area` VALUES ('1509', '乌兰察布', '15', '9');
INSERT INTO `bt_area` VALUES ('1522', '兴安', '15', '10');
INSERT INTO `bt_area` VALUES ('1525', '锡林郭勒', '15', '11');
INSERT INTO `bt_area` VALUES ('1529', '阿拉善', '15', '12');
INSERT INTO `bt_area` VALUES ('2101', '沈阳', '21', '1');
INSERT INTO `bt_area` VALUES ('2102', '大连', '21', '2');
INSERT INTO `bt_area` VALUES ('2103', '鞍山', '21', '3');
INSERT INTO `bt_area` VALUES ('2104', '抚顺', '21', '4');
INSERT INTO `bt_area` VALUES ('2105', '本溪', '21', '5');
INSERT INTO `bt_area` VALUES ('2106', '丹东', '21', '6');
INSERT INTO `bt_area` VALUES ('2107', '锦州', '21', '7');
INSERT INTO `bt_area` VALUES ('2108', '营口', '21', '8');
INSERT INTO `bt_area` VALUES ('2109', '阜新', '21', '9');
INSERT INTO `bt_area` VALUES ('2110', '辽阳', '21', '10');
INSERT INTO `bt_area` VALUES ('2111', '盘锦', '21', '11');
INSERT INTO `bt_area` VALUES ('2112', '铁岭', '21', '12');
INSERT INTO `bt_area` VALUES ('2113', '朝阳', '21', '13');
INSERT INTO `bt_area` VALUES ('2114', '葫芦岛', '21', '14');
INSERT INTO `bt_area` VALUES ('2201', '长春', '22', '1');
INSERT INTO `bt_area` VALUES ('2202', '吉林', '22', '2');
INSERT INTO `bt_area` VALUES ('2203', '四平', '22', '3');
INSERT INTO `bt_area` VALUES ('2204', '辽源', '22', '4');
INSERT INTO `bt_area` VALUES ('2205', '通化', '22', '5');
INSERT INTO `bt_area` VALUES ('2206', '白山', '22', '6');
INSERT INTO `bt_area` VALUES ('2207', '松原', '22', '7');
INSERT INTO `bt_area` VALUES ('2208', '白城', '22', '8');
INSERT INTO `bt_area` VALUES ('2224', '延边', '22', '9');
INSERT INTO `bt_area` VALUES ('2301', '哈尔滨', '23', '1');
INSERT INTO `bt_area` VALUES ('2302', '齐齐哈尔', '23', '2');
INSERT INTO `bt_area` VALUES ('2303', '鸡西', '23', '3');
INSERT INTO `bt_area` VALUES ('2304', '鹤岗', '23', '4');
INSERT INTO `bt_area` VALUES ('2305', '双鸭山', '23', '5');
INSERT INTO `bt_area` VALUES ('2306', '大庆', '23', '6');
INSERT INTO `bt_area` VALUES ('2307', '伊春', '23', '7');
INSERT INTO `bt_area` VALUES ('2308', '佳木斯', '23', '8');
INSERT INTO `bt_area` VALUES ('2309', '七台河', '23', '9');
INSERT INTO `bt_area` VALUES ('2310', '牡丹江', '23', '10');
INSERT INTO `bt_area` VALUES ('2311', '黑河', '23', '11');
INSERT INTO `bt_area` VALUES ('2312', '绥化', '23', '12');
INSERT INTO `bt_area` VALUES ('2327', '大兴安岭', '23', '13');
INSERT INTO `bt_area` VALUES ('3101', '黄浦', '31', '1');
INSERT INTO `bt_area` VALUES ('3103', '卢湾', '31', '2');
INSERT INTO `bt_area` VALUES ('3104', '徐汇', '31', '3');
INSERT INTO `bt_area` VALUES ('3105', '长宁', '31', '4');
INSERT INTO `bt_area` VALUES ('3106', '静安', '31', '5');
INSERT INTO `bt_area` VALUES ('3107', '普陀', '31', '6');
INSERT INTO `bt_area` VALUES ('3108', '闸北', '31', '7');
INSERT INTO `bt_area` VALUES ('3109', '虹口', '31', '8');
INSERT INTO `bt_area` VALUES ('3110', '杨浦', '31', '9');
INSERT INTO `bt_area` VALUES ('3112', '闵行', '31', '10');
INSERT INTO `bt_area` VALUES ('3113', '宝山', '31', '11');
INSERT INTO `bt_area` VALUES ('3114', '嘉定', '31', '12');
INSERT INTO `bt_area` VALUES ('3115', '浦东新区', '31', '13');
INSERT INTO `bt_area` VALUES ('3116', '金山', '31', '14');
INSERT INTO `bt_area` VALUES ('3117', '松江', '31', '15');
INSERT INTO `bt_area` VALUES ('3126', '奉贤', '31', '16');
INSERT INTO `bt_area` VALUES ('3129', '青浦', '31', '17');
INSERT INTO `bt_area` VALUES ('3130', '崇明', '31', '18');
INSERT INTO `bt_area` VALUES ('3201', '南京', '32', '1');
INSERT INTO `bt_area` VALUES ('3202', '无锡', '32', '2');
INSERT INTO `bt_area` VALUES ('3203', '徐州', '32', '3');
INSERT INTO `bt_area` VALUES ('3204', '常州', '32', '4');
INSERT INTO `bt_area` VALUES ('3205', '苏州', '32', '5');
INSERT INTO `bt_area` VALUES ('3206', '南通', '32', '6');
INSERT INTO `bt_area` VALUES ('3207', '连云港', '32', '7');
INSERT INTO `bt_area` VALUES ('3208', '淮安', '32', '8');
INSERT INTO `bt_area` VALUES ('3209', '盐城', '32', '9');
INSERT INTO `bt_area` VALUES ('3210', '扬州', '32', '10');
INSERT INTO `bt_area` VALUES ('3211', '镇江', '32', '11');
INSERT INTO `bt_area` VALUES ('3212', '泰州', '32', '12');
INSERT INTO `bt_area` VALUES ('3213', '宿迁', '32', '13');
INSERT INTO `bt_area` VALUES ('3301', '杭州', '33', '1');
INSERT INTO `bt_area` VALUES ('3302', '宁波', '33', '2');
INSERT INTO `bt_area` VALUES ('3303', '温州', '33', '3');
INSERT INTO `bt_area` VALUES ('3304', '嘉兴', '33', '4');
INSERT INTO `bt_area` VALUES ('3305', '湖州', '33', '5');
INSERT INTO `bt_area` VALUES ('3306', '绍兴', '33', '6');
INSERT INTO `bt_area` VALUES ('3307', '金华', '33', '7');
INSERT INTO `bt_area` VALUES ('3308', '衢州', '33', '8');
INSERT INTO `bt_area` VALUES ('3309', '舟山', '33', '9');
INSERT INTO `bt_area` VALUES ('3310', '台州', '33', '10');
INSERT INTO `bt_area` VALUES ('3311', '丽水', '33', '11');
INSERT INTO `bt_area` VALUES ('3401', '合肥', '34', '1');
INSERT INTO `bt_area` VALUES ('3402', '芜湖', '34', '2');
INSERT INTO `bt_area` VALUES ('3403', '蚌埠', '34', '3');
INSERT INTO `bt_area` VALUES ('3404', '淮南', '34', '4');
INSERT INTO `bt_area` VALUES ('3405', '马鞍山', '34', '5');
INSERT INTO `bt_area` VALUES ('3406', '淮北', '34', '6');
INSERT INTO `bt_area` VALUES ('3407', '铜陵', '34', '7');
INSERT INTO `bt_area` VALUES ('3408', '安庆', '34', '8');
INSERT INTO `bt_area` VALUES ('3410', '黄山', '34', '9');
INSERT INTO `bt_area` VALUES ('3411', '滁州', '34', '10');
INSERT INTO `bt_area` VALUES ('3412', '阜阳', '34', '11');
INSERT INTO `bt_area` VALUES ('3413', '宿州', '34', '12');
INSERT INTO `bt_area` VALUES ('3414', '巢湖', '34', '13');
INSERT INTO `bt_area` VALUES ('3415', '六安', '34', '14');
INSERT INTO `bt_area` VALUES ('3416', '亳州', '34', '15');
INSERT INTO `bt_area` VALUES ('3417', '池州', '34', '16');
INSERT INTO `bt_area` VALUES ('3418', '宣城', '34', '17');
INSERT INTO `bt_area` VALUES ('3501', '福州', '35', '1');
INSERT INTO `bt_area` VALUES ('3502', '厦门', '35', '2');
INSERT INTO `bt_area` VALUES ('3503', '莆田', '35', '3');
INSERT INTO `bt_area` VALUES ('3504', '三明', '35', '4');
INSERT INTO `bt_area` VALUES ('3505', '泉州', '35', '5');
INSERT INTO `bt_area` VALUES ('3506', '漳州', '35', '6');
INSERT INTO `bt_area` VALUES ('3507', '南平', '35', '7');
INSERT INTO `bt_area` VALUES ('3508', '龙岩', '35', '8');
INSERT INTO `bt_area` VALUES ('3509', '宁德', '35', '9');
INSERT INTO `bt_area` VALUES ('3601', '南昌', '36', '1');
INSERT INTO `bt_area` VALUES ('3602', '景德镇', '36', '2');
INSERT INTO `bt_area` VALUES ('3603', '萍乡', '36', '3');
INSERT INTO `bt_area` VALUES ('3604', '九江', '36', '4');
INSERT INTO `bt_area` VALUES ('3605', '新余', '36', '5');
INSERT INTO `bt_area` VALUES ('3606', '鹰潭', '36', '6');
INSERT INTO `bt_area` VALUES ('3607', '赣州', '36', '7');
INSERT INTO `bt_area` VALUES ('3608', '吉安', '36', '8');
INSERT INTO `bt_area` VALUES ('3609', '宜春', '36', '9');
INSERT INTO `bt_area` VALUES ('3610', '抚州', '36', '10');
INSERT INTO `bt_area` VALUES ('3611', '上饶', '36', '11');
INSERT INTO `bt_area` VALUES ('3701', '济南', '37', '1');
INSERT INTO `bt_area` VALUES ('3702', '青岛', '37', '2');
INSERT INTO `bt_area` VALUES ('3703', '淄博', '37', '3');
INSERT INTO `bt_area` VALUES ('3704', '枣庄', '37', '4');
INSERT INTO `bt_area` VALUES ('3705', '东营', '37', '5');
INSERT INTO `bt_area` VALUES ('3706', '烟台', '37', '6');
INSERT INTO `bt_area` VALUES ('3707', '潍坊', '37', '7');
INSERT INTO `bt_area` VALUES ('3708', '济宁', '37', '8');
INSERT INTO `bt_area` VALUES ('3709', '泰安', '37', '9');
INSERT INTO `bt_area` VALUES ('3710', '威海', '37', '10');
INSERT INTO `bt_area` VALUES ('3711', '日照', '37', '11');
INSERT INTO `bt_area` VALUES ('3712', '莱芜', '37', '12');
INSERT INTO `bt_area` VALUES ('3713', '临沂', '37', '13');
INSERT INTO `bt_area` VALUES ('3714', '德州', '37', '14');
INSERT INTO `bt_area` VALUES ('3715', '聊城', '37', '15');
INSERT INTO `bt_area` VALUES ('3716', '滨州', '37', '16');
INSERT INTO `bt_area` VALUES ('3717', '菏泽', '37', '17');
INSERT INTO `bt_area` VALUES ('4101', '郑州', '41', '1');
INSERT INTO `bt_area` VALUES ('4102', '开封', '41', '2');
INSERT INTO `bt_area` VALUES ('4103', '洛阳', '41', '3');
INSERT INTO `bt_area` VALUES ('4104', '平顶山', '41', '4');
INSERT INTO `bt_area` VALUES ('4105', '安阳', '41', '5');
INSERT INTO `bt_area` VALUES ('4106', '鹤壁', '41', '6');
INSERT INTO `bt_area` VALUES ('4107', '新乡', '41', '7');
INSERT INTO `bt_area` VALUES ('4108', '焦作', '41', '8');
INSERT INTO `bt_area` VALUES ('4109', '濮阳', '41', '9');
INSERT INTO `bt_area` VALUES ('4110', '许昌', '41', '10');
INSERT INTO `bt_area` VALUES ('4111', '漯河', '41', '11');
INSERT INTO `bt_area` VALUES ('4112', '三门峡', '41', '12');
INSERT INTO `bt_area` VALUES ('4113', '南阳', '41', '13');
INSERT INTO `bt_area` VALUES ('4114', '商丘', '41', '14');
INSERT INTO `bt_area` VALUES ('4115', '信阳', '41', '15');
INSERT INTO `bt_area` VALUES ('4116', '周口', '41', '16');
INSERT INTO `bt_area` VALUES ('4117', '驻马店', '41', '17');
INSERT INTO `bt_area` VALUES ('4118', '济源', '41', '18');
INSERT INTO `bt_area` VALUES ('4201', '武汉', '42', '1');
INSERT INTO `bt_area` VALUES ('4202', '黄石', '42', '2');
INSERT INTO `bt_area` VALUES ('4203', '十堰', '42', '3');
INSERT INTO `bt_area` VALUES ('4205', '宜昌', '42', '4');
INSERT INTO `bt_area` VALUES ('4206', '襄樊', '42', '5');
INSERT INTO `bt_area` VALUES ('4207', '鄂州', '42', '6');
INSERT INTO `bt_area` VALUES ('4208', '荆门', '42', '7');
INSERT INTO `bt_area` VALUES ('4209', '孝感', '42', '8');
INSERT INTO `bt_area` VALUES ('4210', '荆州', '42', '9');
INSERT INTO `bt_area` VALUES ('4211', '黄冈', '42', '10');
INSERT INTO `bt_area` VALUES ('4212', '咸宁', '42', '11');
INSERT INTO `bt_area` VALUES ('4213', '随州', '42', '12');
INSERT INTO `bt_area` VALUES ('4228', '恩施', '42', '13');
INSERT INTO `bt_area` VALUES ('4229', '仙桃', '42', '14');
INSERT INTO `bt_area` VALUES ('4230', '潜江', '42', '15');
INSERT INTO `bt_area` VALUES ('4231', '天门', '42', '16');
INSERT INTO `bt_area` VALUES ('4232', '神农架', '42', '17');
INSERT INTO `bt_area` VALUES ('4301', '长沙', '43', '1');
INSERT INTO `bt_area` VALUES ('4302', '株洲', '43', '2');
INSERT INTO `bt_area` VALUES ('4303', '湘潭', '43', '3');
INSERT INTO `bt_area` VALUES ('4304', '衡阳', '43', '4');
INSERT INTO `bt_area` VALUES ('4305', '邵阳', '43', '5');
INSERT INTO `bt_area` VALUES ('4306', '岳阳', '43', '6');
INSERT INTO `bt_area` VALUES ('4307', '常德', '43', '7');
INSERT INTO `bt_area` VALUES ('4308', '张家界', '43', '8');
INSERT INTO `bt_area` VALUES ('4309', '益阳', '43', '9');
INSERT INTO `bt_area` VALUES ('4310', '郴州', '43', '10');
INSERT INTO `bt_area` VALUES ('4311', '永州', '43', '11');
INSERT INTO `bt_area` VALUES ('4312', '怀化', '43', '12');
INSERT INTO `bt_area` VALUES ('4313', '娄底', '43', '13');
INSERT INTO `bt_area` VALUES ('4331', '湘西', '43', '14');
INSERT INTO `bt_area` VALUES ('4401', '广州', '44', '1');
INSERT INTO `bt_area` VALUES ('4402', '韶关', '44', '2');
INSERT INTO `bt_area` VALUES ('4403', '深圳', '44', '3');
INSERT INTO `bt_area` VALUES ('4404', '珠海', '44', '4');
INSERT INTO `bt_area` VALUES ('4405', '汕头', '44', '5');
INSERT INTO `bt_area` VALUES ('4406', '佛山', '44', '6');
INSERT INTO `bt_area` VALUES ('4407', '江门', '44', '7');
INSERT INTO `bt_area` VALUES ('4408', '湛江', '44', '8');
INSERT INTO `bt_area` VALUES ('4409', '茂名', '44', '9');
INSERT INTO `bt_area` VALUES ('4412', '肇庆', '44', '10');
INSERT INTO `bt_area` VALUES ('4413', '惠州', '44', '11');
INSERT INTO `bt_area` VALUES ('4414', '梅州', '44', '12');
INSERT INTO `bt_area` VALUES ('4415', '汕尾', '44', '13');
INSERT INTO `bt_area` VALUES ('4416', '河源', '44', '14');
INSERT INTO `bt_area` VALUES ('4417', '阳江', '44', '15');
INSERT INTO `bt_area` VALUES ('4418', '清远', '44', '16');
INSERT INTO `bt_area` VALUES ('4419', '东莞', '44', '17');
INSERT INTO `bt_area` VALUES ('4420', '中山', '44', '18');
INSERT INTO `bt_area` VALUES ('4451', '潮州', '44', '19');
INSERT INTO `bt_area` VALUES ('4452', '揭阳', '44', '20');
INSERT INTO `bt_area` VALUES ('4453', '云浮', '44', '21');
INSERT INTO `bt_area` VALUES ('4501', '南宁', '45', '1');
INSERT INTO `bt_area` VALUES ('4502', '柳州', '45', '2');
INSERT INTO `bt_area` VALUES ('4503', '桂林', '45', '3');
INSERT INTO `bt_area` VALUES ('4504', '梧州', '45', '4');
INSERT INTO `bt_area` VALUES ('4505', '北海', '45', '5');
INSERT INTO `bt_area` VALUES ('4506', '防城港', '45', '6');
INSERT INTO `bt_area` VALUES ('4507', '钦州', '45', '7');
INSERT INTO `bt_area` VALUES ('4508', '贵港', '45', '8');
INSERT INTO `bt_area` VALUES ('4509', '玉林', '45', '9');
INSERT INTO `bt_area` VALUES ('4510', '百色', '45', '10');
INSERT INTO `bt_area` VALUES ('4511', '贺州', '45', '11');
INSERT INTO `bt_area` VALUES ('4512', '河池', '45', '12');
INSERT INTO `bt_area` VALUES ('4513', '来宾', '45', '13');
INSERT INTO `bt_area` VALUES ('4514', '崇左', '45', '14');
INSERT INTO `bt_area` VALUES ('4601', '海口', '46', '1');
INSERT INTO `bt_area` VALUES ('4602', '三亚', '46', '2');
INSERT INTO `bt_area` VALUES ('4603', '五指山', '46', '3');
INSERT INTO `bt_area` VALUES ('4604', '琼海', '46', '4');
INSERT INTO `bt_area` VALUES ('4605', '儋州', '46', '5');
INSERT INTO `bt_area` VALUES ('4606', '文昌', '46', '6');
INSERT INTO `bt_area` VALUES ('4607', '万宁', '46', '7');
INSERT INTO `bt_area` VALUES ('4608', '东方', '46', '8');
INSERT INTO `bt_area` VALUES ('5001', '万州', '50', '1');
INSERT INTO `bt_area` VALUES ('5002', '涪陵', '50', '2');
INSERT INTO `bt_area` VALUES ('5003', '渝中', '50', '3');
INSERT INTO `bt_area` VALUES ('5004', '大渡口', '50', '4');
INSERT INTO `bt_area` VALUES ('5005', '江北', '50', '5');
INSERT INTO `bt_area` VALUES ('5006', '沙坪坝', '50', '6');
INSERT INTO `bt_area` VALUES ('5007', '九龙坡', '50', '7');
INSERT INTO `bt_area` VALUES ('5008', '南岸', '50', '8');
INSERT INTO `bt_area` VALUES ('5009', '北碚', '50', '9');
INSERT INTO `bt_area` VALUES ('5010', '万盛', '50', '10');
INSERT INTO `bt_area` VALUES ('5011', '双桥', '50', '11');
INSERT INTO `bt_area` VALUES ('5012', '渝北', '50', '12');
INSERT INTO `bt_area` VALUES ('5013', '巴南', '50', '13');
INSERT INTO `bt_area` VALUES ('5021', '长寿', '50', '14');
INSERT INTO `bt_area` VALUES ('5022', '綦江', '50', '15');
INSERT INTO `bt_area` VALUES ('5023', '潼南', '50', '16');
INSERT INTO `bt_area` VALUES ('5024', '铜梁', '50', '17');
INSERT INTO `bt_area` VALUES ('5025', '大足', '50', '18');
INSERT INTO `bt_area` VALUES ('5026', '荣昌', '50', '19');
INSERT INTO `bt_area` VALUES ('5027', '璧山', '50', '20');
INSERT INTO `bt_area` VALUES ('5028', '梁平', '50', '21');
INSERT INTO `bt_area` VALUES ('5029', '城口', '50', '22');
INSERT INTO `bt_area` VALUES ('5030', '丰都', '50', '23');
INSERT INTO `bt_area` VALUES ('5031', '垫江', '50', '24');
INSERT INTO `bt_area` VALUES ('5032', '武隆', '50', '25');
INSERT INTO `bt_area` VALUES ('5033', '忠县', '50', '26');
INSERT INTO `bt_area` VALUES ('5034', '开县', '50', '27');
INSERT INTO `bt_area` VALUES ('5035', '云阳', '50', '28');
INSERT INTO `bt_area` VALUES ('5036', '奉节', '50', '29');
INSERT INTO `bt_area` VALUES ('5037', '巫山', '50', '30');
INSERT INTO `bt_area` VALUES ('5038', '巫溪', '50', '31');
INSERT INTO `bt_area` VALUES ('5039', '黔江', '50', '32');
INSERT INTO `bt_area` VALUES ('5040', '石柱', '50', '33');
INSERT INTO `bt_area` VALUES ('5041', '秀山', '50', '34');
INSERT INTO `bt_area` VALUES ('5042', '酉阳', '50', '35');
INSERT INTO `bt_area` VALUES ('5043', '彭水', '50', '36');
INSERT INTO `bt_area` VALUES ('5081', '江津', '50', '37');
INSERT INTO `bt_area` VALUES ('5082', '合川', '50', '38');
INSERT INTO `bt_area` VALUES ('5083', '永川', '50', '39');
INSERT INTO `bt_area` VALUES ('5084', '南川', '50', '40');
INSERT INTO `bt_area` VALUES ('5101', '成都', '51', '1');
INSERT INTO `bt_area` VALUES ('5103', '自贡', '51', '2');
INSERT INTO `bt_area` VALUES ('5104', '攀枝花', '51', '3');
INSERT INTO `bt_area` VALUES ('5105', '泸州', '51', '4');
INSERT INTO `bt_area` VALUES ('5106', '德阳', '51', '5');
INSERT INTO `bt_area` VALUES ('5107', '绵阳', '51', '6');
INSERT INTO `bt_area` VALUES ('5108', '广元', '51', '7');
INSERT INTO `bt_area` VALUES ('5109', '遂宁', '51', '8');
INSERT INTO `bt_area` VALUES ('5110', '内江', '51', '9');
INSERT INTO `bt_area` VALUES ('5111', '乐山', '51', '10');
INSERT INTO `bt_area` VALUES ('5113', '南充', '51', '11');
INSERT INTO `bt_area` VALUES ('5114', '眉山', '51', '12');
INSERT INTO `bt_area` VALUES ('5115', '宜宾', '51', '13');
INSERT INTO `bt_area` VALUES ('5116', '广安', '51', '14');
INSERT INTO `bt_area` VALUES ('5117', '达州', '51', '15');
INSERT INTO `bt_area` VALUES ('5118', '雅安', '51', '16');
INSERT INTO `bt_area` VALUES ('5119', '巴中', '51', '17');
INSERT INTO `bt_area` VALUES ('5120', '资阳', '51', '18');
INSERT INTO `bt_area` VALUES ('5132', '阿坝', '51', '19');
INSERT INTO `bt_area` VALUES ('5133', '甘孜', '51', '20');
INSERT INTO `bt_area` VALUES ('5134', '凉山', '51', '21');
INSERT INTO `bt_area` VALUES ('5201', '贵阳', '52', '1');
INSERT INTO `bt_area` VALUES ('5202', '六盘水', '52', '2');
INSERT INTO `bt_area` VALUES ('5203', '遵义', '52', '3');
INSERT INTO `bt_area` VALUES ('5204', '安顺', '52', '4');
INSERT INTO `bt_area` VALUES ('5222', '铜仁', '52', '5');
INSERT INTO `bt_area` VALUES ('5223', '黔西南', '52', '6');
INSERT INTO `bt_area` VALUES ('5224', '毕节', '52', '7');
INSERT INTO `bt_area` VALUES ('5226', '黔东南', '52', '8');
INSERT INTO `bt_area` VALUES ('5227', '黔南', '52', '9');
INSERT INTO `bt_area` VALUES ('5301', '昆明', '53', '1');
INSERT INTO `bt_area` VALUES ('5303', '曲靖', '53', '2');
INSERT INTO `bt_area` VALUES ('5304', '玉溪', '53', '3');
INSERT INTO `bt_area` VALUES ('5305', '保山', '53', '4');
INSERT INTO `bt_area` VALUES ('5306', '昭通', '53', '5');
INSERT INTO `bt_area` VALUES ('5307', '丽江', '53', '6');
INSERT INTO `bt_area` VALUES ('5308', '普洱', '53', '7');
INSERT INTO `bt_area` VALUES ('5309', '临沧', '53', '8');
INSERT INTO `bt_area` VALUES ('5323', '楚雄', '53', '9');
INSERT INTO `bt_area` VALUES ('5325', '红河', '53', '10');
INSERT INTO `bt_area` VALUES ('5326', '文山', '53', '11');
INSERT INTO `bt_area` VALUES ('5328', '西双版纳', '53', '12');
INSERT INTO `bt_area` VALUES ('5329', '大理', '53', '13');
INSERT INTO `bt_area` VALUES ('5331', '德宏', '53', '14');
INSERT INTO `bt_area` VALUES ('5333', '怒江傈', '53', '15');
INSERT INTO `bt_area` VALUES ('5334', '迪庆', '53', '16');
INSERT INTO `bt_area` VALUES ('5401', '拉萨', '54', '1');
INSERT INTO `bt_area` VALUES ('5421', '昌都', '54', '2');
INSERT INTO `bt_area` VALUES ('5422', '山南', '54', '3');
INSERT INTO `bt_area` VALUES ('5423', '日喀则', '54', '4');
INSERT INTO `bt_area` VALUES ('5424', '那曲', '54', '5');
INSERT INTO `bt_area` VALUES ('5425', '阿里', '54', '6');
INSERT INTO `bt_area` VALUES ('5426', '林芝', '54', '7');
INSERT INTO `bt_area` VALUES ('6101', '西安', '61', '1');
INSERT INTO `bt_area` VALUES ('6102', '铜川', '61', '2');
INSERT INTO `bt_area` VALUES ('6103', '宝鸡', '61', '3');
INSERT INTO `bt_area` VALUES ('6104', '咸阳', '61', '4');
INSERT INTO `bt_area` VALUES ('6105', '渭南', '61', '5');
INSERT INTO `bt_area` VALUES ('6106', '延安', '61', '6');
INSERT INTO `bt_area` VALUES ('6107', '汉中', '61', '7');
INSERT INTO `bt_area` VALUES ('6108', '榆林', '61', '8');
INSERT INTO `bt_area` VALUES ('6109', '安康', '61', '9');
INSERT INTO `bt_area` VALUES ('6110', '商洛', '61', '10');
INSERT INTO `bt_area` VALUES ('6201', '兰州', '62', '1');
INSERT INTO `bt_area` VALUES ('6202', '嘉峪关', '62', '2');
INSERT INTO `bt_area` VALUES ('6203', '金昌', '62', '3');
INSERT INTO `bt_area` VALUES ('6204', '白银', '62', '4');
INSERT INTO `bt_area` VALUES ('6205', '天水', '62', '5');
INSERT INTO `bt_area` VALUES ('6206', '武威', '62', '6');
INSERT INTO `bt_area` VALUES ('6207', '张掖', '62', '7');
INSERT INTO `bt_area` VALUES ('6208', '平凉', '62', '8');
INSERT INTO `bt_area` VALUES ('6209', '酒泉', '62', '9');
INSERT INTO `bt_area` VALUES ('6210', '庆阳', '62', '10');
INSERT INTO `bt_area` VALUES ('6211', '定西', '62', '11');
INSERT INTO `bt_area` VALUES ('6212', '陇南', '62', '12');
INSERT INTO `bt_area` VALUES ('6229', '临夏', '62', '13');
INSERT INTO `bt_area` VALUES ('6230', '甘南', '62', '14');
INSERT INTO `bt_area` VALUES ('6301', '西宁', '63', '1');
INSERT INTO `bt_area` VALUES ('6321', '海东', '63', '2');
INSERT INTO `bt_area` VALUES ('6322', '海北', '63', '3');
INSERT INTO `bt_area` VALUES ('6323', '黄南', '63', '4');
INSERT INTO `bt_area` VALUES ('6325', '海南', '63', '5');
INSERT INTO `bt_area` VALUES ('6326', '果洛', '63', '6');
INSERT INTO `bt_area` VALUES ('6327', '玉树', '63', '7');
INSERT INTO `bt_area` VALUES ('6328', '海西', '63', '8');
INSERT INTO `bt_area` VALUES ('6401', '银川', '64', '1');
INSERT INTO `bt_area` VALUES ('6402', '石嘴山', '64', '2');
INSERT INTO `bt_area` VALUES ('6403', '吴忠', '64', '3');
INSERT INTO `bt_area` VALUES ('6404', '固原', '64', '4');
INSERT INTO `bt_area` VALUES ('6405', '中卫', '64', '5');
INSERT INTO `bt_area` VALUES ('6501', '乌鲁木齐', '65', '1');
INSERT INTO `bt_area` VALUES ('6502', '克拉玛依', '65', '2');
INSERT INTO `bt_area` VALUES ('6521', '吐鲁番', '65', '3');
INSERT INTO `bt_area` VALUES ('6522', '哈密', '65', '4');
INSERT INTO `bt_area` VALUES ('6523', '昌吉', '65', '5');
INSERT INTO `bt_area` VALUES ('6527', '博尔塔拉', '65', '6');
INSERT INTO `bt_area` VALUES ('6528', '巴音郭楞', '65', '7');
INSERT INTO `bt_area` VALUES ('6529', '阿克苏', '65', '8');
INSERT INTO `bt_area` VALUES ('6530', '克孜勒苏', '65', '9');
INSERT INTO `bt_area` VALUES ('6531', '喀什', '65', '10');
INSERT INTO `bt_area` VALUES ('6532', '和田', '65', '11');
INSERT INTO `bt_area` VALUES ('6540', '伊犁', '65', '12');
INSERT INTO `bt_area` VALUES ('6542', '塔城', '65', '13');
INSERT INTO `bt_area` VALUES ('6543', '阿勒泰', '65', '14');
INSERT INTO `bt_area` VALUES ('6544', '石河子', '65', '15');
INSERT INTO `bt_area` VALUES ('6545', '阿拉尔', '65', '16');
INSERT INTO `bt_area` VALUES ('6546', '图木舒克', '65', '17');
INSERT INTO `bt_area` VALUES ('6547', '五家渠', '65', '18');
INSERT INTO `bt_area` VALUES ('7101', '台北市', '71', '1');
INSERT INTO `bt_area` VALUES ('7102', '高雄市', '71', '2');
INSERT INTO `bt_area` VALUES ('7103', '基隆市', '71', '3');
INSERT INTO `bt_area` VALUES ('7104', '台中市', '71', '4');
INSERT INTO `bt_area` VALUES ('7105', '台南市', '71', '5');
INSERT INTO `bt_area` VALUES ('7106', '新竹市', '71', '6');
INSERT INTO `bt_area` VALUES ('7107', '嘉义市', '71', '7');
INSERT INTO `bt_area` VALUES ('7108', '台北县', '71', '8');
INSERT INTO `bt_area` VALUES ('7109', '宜兰县', '71', '9');
INSERT INTO `bt_area` VALUES ('7110', '新竹县', '71', '10');
INSERT INTO `bt_area` VALUES ('7111', '桃园县', '71', '11');
INSERT INTO `bt_area` VALUES ('7112', '苗栗县', '71', '12');
INSERT INTO `bt_area` VALUES ('7113', '台中县', '71', '13');
INSERT INTO `bt_area` VALUES ('7114', '彰化县', '71', '14');
INSERT INTO `bt_area` VALUES ('7115', '南投县', '71', '15');
INSERT INTO `bt_area` VALUES ('7116', '嘉义县', '71', '16');
INSERT INTO `bt_area` VALUES ('7117', '云林县', '71', '17');
INSERT INTO `bt_area` VALUES ('7118', '台南县', '71', '18');
INSERT INTO `bt_area` VALUES ('7119', '高雄县', '71', '19');
INSERT INTO `bt_area` VALUES ('7120', '屏东县', '71', '20');
INSERT INTO `bt_area` VALUES ('7121', '台东县', '71', '21');
INSERT INTO `bt_area` VALUES ('7122', '花莲县', '71', '22');
INSERT INTO `bt_area` VALUES ('7123', '澎湖县', '71', '23');
INSERT INTO `bt_area` VALUES ('8101', '中西区', '81', '1');
INSERT INTO `bt_area` VALUES ('8102', '东区', '81', '2');
INSERT INTO `bt_area` VALUES ('8103', '九龙城区', '81', '3');
INSERT INTO `bt_area` VALUES ('8104', '观塘区', '81', '4');
INSERT INTO `bt_area` VALUES ('8105', '南区', '81', '5');
INSERT INTO `bt_area` VALUES ('8106', '深水区', '81', '6');
INSERT INTO `bt_area` VALUES ('8107', '湾仔区', '81', '7');
INSERT INTO `bt_area` VALUES ('8108', '黄大仙区', '81', '8');
INSERT INTO `bt_area` VALUES ('8109', '油尖旺区', '81', '9');
INSERT INTO `bt_area` VALUES ('8110', '离岛区', '81', '10');
INSERT INTO `bt_area` VALUES ('8111', '葵青区', '81', '11');
INSERT INTO `bt_area` VALUES ('8112', '北区', '81', '12');
INSERT INTO `bt_area` VALUES ('8113', '西贡区', '81', '13');
INSERT INTO `bt_area` VALUES ('8114', '沙田区', '81', '14');
INSERT INTO `bt_area` VALUES ('8115', '屯门区', '81', '15');
INSERT INTO `bt_area` VALUES ('8116', '大埔区', '81', '16');
INSERT INTO `bt_area` VALUES ('8117', '荃湾区', '81', '17');
INSERT INTO `bt_area` VALUES ('8118', '元朗区', '81', '18');
INSERT INTO `bt_area` VALUES ('8201', '花地玛堂区', '82', '1');
INSERT INTO `bt_area` VALUES ('8202', '圣安多尼堂区', '82', '2');
INSERT INTO `bt_area` VALUES ('8203', '大堂区', '82', '3');
INSERT INTO `bt_area` VALUES ('8204', '望德堂区', '82', '4');
INSERT INTO `bt_area` VALUES ('8205', '风顺堂区', '82', '5');
INSERT INTO `bt_area` VALUES ('8206', '嘉模堂区', '82', '6');
INSERT INTO `bt_area` VALUES ('8207', '圣方济各堂区', '82', '7');
INSERT INTO `bt_area` VALUES ('610424', '乾县', '6104', '6');
INSERT INTO `bt_area` VALUES ('610423', '泾阳县', '6104', '5');
INSERT INTO `bt_area` VALUES ('610422', '三原县', '6104', '4');
INSERT INTO `bt_area` VALUES ('610404', '渭城区', '6104', '3');
INSERT INTO `bt_area` VALUES ('610403', '杨凌区', '6104', '2');
INSERT INTO `bt_area` VALUES ('610402', '秦都区', '6104', '1');
INSERT INTO `bt_area` VALUES ('610331', '太白县', '6103', '12');
INSERT INTO `bt_area` VALUES ('610330', '凤县', '6103', '11');
INSERT INTO `bt_area` VALUES ('610329', '麟游县', '6103', '10');
INSERT INTO `bt_area` VALUES ('610328', '千阳县', '6103', '9');
INSERT INTO `bt_area` VALUES ('610327', '陇县', '6103', '8');
INSERT INTO `bt_area` VALUES ('610326', '眉县', '6103', '7');
INSERT INTO `bt_area` VALUES ('610324', '扶风县', '6103', '6');
INSERT INTO `bt_area` VALUES ('610323', '岐山县', '6103', '5');
INSERT INTO `bt_area` VALUES ('610322', '凤翔县', '6103', '4');
INSERT INTO `bt_area` VALUES ('610304', '陈仓区', '6103', '3');
INSERT INTO `bt_area` VALUES ('610303', '金台区', '6103', '2');
INSERT INTO `bt_area` VALUES ('610302', '渭滨区', '6103', '1');
INSERT INTO `bt_area` VALUES ('610222', '宜君县', '6102', '4');
INSERT INTO `bt_area` VALUES ('610204', '耀州区', '6102', '3');
INSERT INTO `bt_area` VALUES ('610203', '印台区', '6102', '2');
INSERT INTO `bt_area` VALUES ('610202', '王益区', '6102', '1');
INSERT INTO `bt_area` VALUES ('610126', '高陵县', '6101', '13');
INSERT INTO `bt_area` VALUES ('610125', '户县', '6101', '12');
INSERT INTO `bt_area` VALUES ('610124', '周至县', '6101', '11');
INSERT INTO `bt_area` VALUES ('610122', '蓝田县', '6101', '10');
INSERT INTO `bt_area` VALUES ('610116', '长安区', '6101', '9');
INSERT INTO `bt_area` VALUES ('610115', '临潼区', '6101', '8');
INSERT INTO `bt_area` VALUES ('610114', '阎良区', '6101', '7');
INSERT INTO `bt_area` VALUES ('610113', '雁塔区', '6101', '6');
INSERT INTO `bt_area` VALUES ('610112', '未央区', '6101', '5');
INSERT INTO `bt_area` VALUES ('610111', '灞桥区', '6101', '4');
INSERT INTO `bt_area` VALUES ('610104', '莲湖区', '6101', '3');
INSERT INTO `bt_area` VALUES ('610103', '碑林区', '6101', '2');
INSERT INTO `bt_area` VALUES ('610102', '新城区', '6101', '1');
INSERT INTO `bt_area` VALUES ('542627', '朗县', '5426', '7');
INSERT INTO `bt_area` VALUES ('542626', '察隅县', '5426', '6');
INSERT INTO `bt_area` VALUES ('542625', '波密县', '5426', '5');
INSERT INTO `bt_area` VALUES ('542624', '墨脱县', '5426', '4');
INSERT INTO `bt_area` VALUES ('542623', '米林县', '5426', '3');
INSERT INTO `bt_area` VALUES ('542622', '工布江达县', '5426', '2');
INSERT INTO `bt_area` VALUES ('542621', '林芝县', '5426', '1');
INSERT INTO `bt_area` VALUES ('542527', '措勤县', '5425', '7');
INSERT INTO `bt_area` VALUES ('542526', '改则县', '5425', '6');
INSERT INTO `bt_area` VALUES ('542525', '革吉县', '5425', '5');
INSERT INTO `bt_area` VALUES ('542524', '日土县', '5425', '4');
INSERT INTO `bt_area` VALUES ('542523', '噶尔县', '5425', '3');
INSERT INTO `bt_area` VALUES ('542522', '札达县', '5425', '2');
INSERT INTO `bt_area` VALUES ('542521', '普兰县', '5425', '1');
INSERT INTO `bt_area` VALUES ('542430', '尼玛县', '5424', '10');
INSERT INTO `bt_area` VALUES ('542429', '巴青县', '5424', '9');
INSERT INTO `bt_area` VALUES ('542428', '班戈县', '5424', '8');
INSERT INTO `bt_area` VALUES ('542427', '索县', '5424', '7');
INSERT INTO `bt_area` VALUES ('542426', '申扎县', '5424', '6');
INSERT INTO `bt_area` VALUES ('542425', '安多县', '5424', '5');
INSERT INTO `bt_area` VALUES ('542424', '聂荣县', '5424', '4');
INSERT INTO `bt_area` VALUES ('542423', '比如县', '5424', '3');
INSERT INTO `bt_area` VALUES ('542422', '嘉黎县', '5424', '2');
INSERT INTO `bt_area` VALUES ('542421', '那曲县', '5424', '1');
INSERT INTO `bt_area` VALUES ('542338', '岗巴县', '5423', '18');
INSERT INTO `bt_area` VALUES ('542337', '萨嘎县', '5423', '17');
INSERT INTO `bt_area` VALUES ('542336', '聂拉木县', '5423', '16');
INSERT INTO `bt_area` VALUES ('542335', '吉隆县', '5423', '15');
INSERT INTO `bt_area` VALUES ('542334', '亚东县', '5423', '14');
INSERT INTO `bt_area` VALUES ('542333', '仲巴县', '5423', '13');
INSERT INTO `bt_area` VALUES ('542332', '定结县', '5423', '12');
INSERT INTO `bt_area` VALUES ('542331', '康马县', '5423', '11');
INSERT INTO `bt_area` VALUES ('542330', '仁布县', '5423', '10');
INSERT INTO `bt_area` VALUES ('542329', '白朗县', '5423', '9');
INSERT INTO `bt_area` VALUES ('542328', '谢通门县', '5423', '8');
INSERT INTO `bt_area` VALUES ('542327', '昂仁县', '5423', '7');
INSERT INTO `bt_area` VALUES ('542326', '拉孜县', '5423', '6');
INSERT INTO `bt_area` VALUES ('542325', '萨迦县', '5423', '5');
INSERT INTO `bt_area` VALUES ('542324', '定日县', '5423', '4');
INSERT INTO `bt_area` VALUES ('542323', '江孜县', '5423', '3');
INSERT INTO `bt_area` VALUES ('542322', '南木林县', '5423', '2');
INSERT INTO `bt_area` VALUES ('542301', '日喀则市', '5423', '1');
INSERT INTO `bt_area` VALUES ('542233', '浪卡子县', '5422', '12');
INSERT INTO `bt_area` VALUES ('542232', '错那县', '5422', '11');
INSERT INTO `bt_area` VALUES ('542231', '隆子县', '5422', '10');
INSERT INTO `bt_area` VALUES ('542229', '加查县', '5422', '9');
INSERT INTO `bt_area` VALUES ('542228', '洛扎县', '5422', '8');
INSERT INTO `bt_area` VALUES ('542227', '措美县', '5422', '7');
INSERT INTO `bt_area` VALUES ('542226', '曲松县', '5422', '6');
INSERT INTO `bt_area` VALUES ('542225', '琼结县', '5422', '5');
INSERT INTO `bt_area` VALUES ('542224', '桑日县', '5422', '4');
INSERT INTO `bt_area` VALUES ('542223', '贡嘎县', '5422', '3');
INSERT INTO `bt_area` VALUES ('542222', '扎囊县', '5422', '2');
INSERT INTO `bt_area` VALUES ('542221', '乃东县', '5422', '1');
INSERT INTO `bt_area` VALUES ('542133', '边坝县', '5421', '11');
INSERT INTO `bt_area` VALUES ('542132', '洛隆县', '5421', '10');
INSERT INTO `bt_area` VALUES ('542129', '芒康县', '5421', '9');
INSERT INTO `bt_area` VALUES ('542128', '左贡县', '5421', '8');
INSERT INTO `bt_area` VALUES ('542127', '八宿县', '5421', '7');
INSERT INTO `bt_area` VALUES ('542126', '察雅县', '5421', '6');
INSERT INTO `bt_area` VALUES ('542125', '丁青县', '5421', '5');
INSERT INTO `bt_area` VALUES ('542124', '类乌齐县', '5421', '4');
INSERT INTO `bt_area` VALUES ('542123', '贡觉县', '5421', '3');
INSERT INTO `bt_area` VALUES ('542122', '江达县', '5421', '2');
INSERT INTO `bt_area` VALUES ('542121', '昌都县', '5421', '1');
INSERT INTO `bt_area` VALUES ('540127', '墨竹工卡县', '5401', '8');
INSERT INTO `bt_area` VALUES ('540126', '达孜县', '5401', '7');
INSERT INTO `bt_area` VALUES ('540125', '堆龙德庆县', '5401', '6');
INSERT INTO `bt_area` VALUES ('540124', '曲水县', '5401', '5');
INSERT INTO `bt_area` VALUES ('540123', '尼木县', '5401', '4');
INSERT INTO `bt_area` VALUES ('540122', '当雄县', '5401', '3');
INSERT INTO `bt_area` VALUES ('540121', '林周县', '5401', '2');
INSERT INTO `bt_area` VALUES ('540102', '城关区', '5401', '1');
INSERT INTO `bt_area` VALUES ('533423', '维西傈僳族自治县', '5334', '3');
INSERT INTO `bt_area` VALUES ('533422', '德钦县', '5334', '2');
INSERT INTO `bt_area` VALUES ('533421', '香格里拉县', '5334', '1');
INSERT INTO `bt_area` VALUES ('533325', '兰坪白族普米族自治县', '5333', '4');
INSERT INTO `bt_area` VALUES ('533324', '贡山独龙族怒族自治县', '5333', '3');
INSERT INTO `bt_area` VALUES ('533323', '福贡县', '5333', '2');
INSERT INTO `bt_area` VALUES ('533321', '泸水县', '5333', '1');
INSERT INTO `bt_area` VALUES ('533124', '陇川县', '5331', '5');
INSERT INTO `bt_area` VALUES ('533123', '盈江县', '5331', '4');
INSERT INTO `bt_area` VALUES ('533122', '梁河县', '5331', '3');
INSERT INTO `bt_area` VALUES ('533103', '潞西市', '5331', '2');
INSERT INTO `bt_area` VALUES ('533102', '瑞丽市', '5331', '1');
INSERT INTO `bt_area` VALUES ('532932', '鹤庆县', '5329', '12');
INSERT INTO `bt_area` VALUES ('532931', '剑川县', '5329', '11');
INSERT INTO `bt_area` VALUES ('532930', '洱源县', '5329', '10');
INSERT INTO `bt_area` VALUES ('532929', '云龙县', '5329', '9');
INSERT INTO `bt_area` VALUES ('532928', '永平县', '5329', '8');
INSERT INTO `bt_area` VALUES ('532927', '巍山彝族回族自治县', '5329', '7');
INSERT INTO `bt_area` VALUES ('532926', '南涧彝族自治县', '5329', '6');
INSERT INTO `bt_area` VALUES ('532925', '弥渡县', '5329', '5');
INSERT INTO `bt_area` VALUES ('532924', '宾川县', '5329', '4');
INSERT INTO `bt_area` VALUES ('532923', '祥云县', '5329', '3');
INSERT INTO `bt_area` VALUES ('532922', '漾濞彝族自治县', '5329', '2');
INSERT INTO `bt_area` VALUES ('532901', '大理市', '5329', '1');
INSERT INTO `bt_area` VALUES ('532823', '勐腊县', '5328', '3');
INSERT INTO `bt_area` VALUES ('532822', '勐海县', '5328', '2');
INSERT INTO `bt_area` VALUES ('532801', '景洪市', '5328', '1');
INSERT INTO `bt_area` VALUES ('532628', '富宁县', '5326', '8');
INSERT INTO `bt_area` VALUES ('532627', '广南县', '5326', '7');
INSERT INTO `bt_area` VALUES ('532626', '丘北县', '5326', '6');
INSERT INTO `bt_area` VALUES ('532625', '马关县', '5326', '5');
INSERT INTO `bt_area` VALUES ('532624', '麻栗坡县', '5326', '4');
INSERT INTO `bt_area` VALUES ('532623', '西畴县', '5326', '3');
INSERT INTO `bt_area` VALUES ('532622', '砚山县', '5326', '2');
INSERT INTO `bt_area` VALUES ('532621', '文山县', '5326', '1');
INSERT INTO `bt_area` VALUES ('532532', '河口瑶族自治县', '5325', '13');
INSERT INTO `bt_area` VALUES ('532531', '绿春县', '5325', '12');
INSERT INTO `bt_area` VALUES ('532530', '金平苗族瑶族傣族自治县', '5325', '11');
INSERT INTO `bt_area` VALUES ('532529', '红河县', '5325', '10');
INSERT INTO `bt_area` VALUES ('532528', '元阳县', '5325', '9');
INSERT INTO `bt_area` VALUES ('532527', '泸西县', '5325', '8');
INSERT INTO `bt_area` VALUES ('532526', '弥勒县', '5325', '7');
INSERT INTO `bt_area` VALUES ('532525', '石屏县', '5325', '6');
INSERT INTO `bt_area` VALUES ('532524', '建水县', '5325', '5');
INSERT INTO `bt_area` VALUES ('532523', '屏边苗族自治县', '5325', '4');
INSERT INTO `bt_area` VALUES ('532522', '蒙自县', '5325', '3');
INSERT INTO `bt_area` VALUES ('532502', '开远市', '5325', '2');
INSERT INTO `bt_area` VALUES ('532501', '个旧市', '5325', '1');
INSERT INTO `bt_area` VALUES ('532331', '禄丰县', '5323', '10');
INSERT INTO `bt_area` VALUES ('532329', '武定县', '5323', '9');
INSERT INTO `bt_area` VALUES ('532328', '元谋县', '5323', '8');
INSERT INTO `bt_area` VALUES ('532327', '永仁县', '5323', '7');
INSERT INTO `bt_area` VALUES ('532326', '大姚县', '5323', '6');
INSERT INTO `bt_area` VALUES ('532325', '姚安县', '5323', '5');
INSERT INTO `bt_area` VALUES ('532324', '南华县', '5323', '4');
INSERT INTO `bt_area` VALUES ('532323', '牟定县', '5323', '3');
INSERT INTO `bt_area` VALUES ('532322', '双柏县', '5323', '2');
INSERT INTO `bt_area` VALUES ('532301', '楚雄市', '5323', '1');
INSERT INTO `bt_area` VALUES ('530927', '沧源佤族自治县', '5309', '8');
INSERT INTO `bt_area` VALUES ('530926', '耿马傣族佤族自治县', '5309', '7');
INSERT INTO `bt_area` VALUES ('530925', '双江拉祜族佤族布朗族傣族自治县', '5309', '6');
INSERT INTO `bt_area` VALUES ('530924', '镇康县', '5309', '5');
INSERT INTO `bt_area` VALUES ('530923', '永德县', '5309', '4');
INSERT INTO `bt_area` VALUES ('530922', '云县', '5309', '3');
INSERT INTO `bt_area` VALUES ('530921', '凤庆县', '5309', '2');
INSERT INTO `bt_area` VALUES ('530902', '临翔区', '5309', '1');
INSERT INTO `bt_area` VALUES ('530829', '西盟佤族自治县', '5308', '10');
INSERT INTO `bt_area` VALUES ('530828', '澜沧拉祜族自治县', '5308', '9');
INSERT INTO `bt_area` VALUES ('530827', '孟连傣族拉祜族佤族自治县', '5308', '8');
INSERT INTO `bt_area` VALUES ('530826', '江城哈尼族彝族自治县', '5308', '7');
INSERT INTO `bt_area` VALUES ('530825', '镇沅彝族哈尼族拉祜族自治县', '5308', '6');
INSERT INTO `bt_area` VALUES ('530824', '景谷傣族彝族自治县', '5308', '5');
INSERT INTO `bt_area` VALUES ('530823', '景东彝族自治县', '5308', '4');
INSERT INTO `bt_area` VALUES ('530822', '墨江哈尼族自治县', '5308', '3');
INSERT INTO `bt_area` VALUES ('530821', '宁洱镇', '5308', '2');
INSERT INTO `bt_area` VALUES ('530802', '思茅区', '5308', '1');
INSERT INTO `bt_area` VALUES ('530724', '宁蒗彝族自治县', '5307', '5');
INSERT INTO `bt_area` VALUES ('530723', '华坪县', '5307', '4');
INSERT INTO `bt_area` VALUES ('530722', '永胜县', '5307', '3');
INSERT INTO `bt_area` VALUES ('530721', '玉龙纳西族自治县', '5307', '2');
INSERT INTO `bt_area` VALUES ('530702', '古城区', '5307', '1');
INSERT INTO `bt_area` VALUES ('530630', '水富县', '5306', '11');
INSERT INTO `bt_area` VALUES ('530629', '威信县', '5306', '10');
INSERT INTO `bt_area` VALUES ('530628', '彝良县', '5306', '9');
INSERT INTO `bt_area` VALUES ('530627', '镇雄县', '5306', '8');
INSERT INTO `bt_area` VALUES ('530626', '绥江县', '5306', '7');
INSERT INTO `bt_area` VALUES ('530625', '永善县', '5306', '6');
INSERT INTO `bt_area` VALUES ('530624', '大关县', '5306', '5');
INSERT INTO `bt_area` VALUES ('530623', '盐津县', '5306', '4');
INSERT INTO `bt_area` VALUES ('530622', '巧家县', '5306', '3');
INSERT INTO `bt_area` VALUES ('530621', '鲁甸县', '5306', '2');
INSERT INTO `bt_area` VALUES ('530602', '昭阳区', '5306', '1');
INSERT INTO `bt_area` VALUES ('530524', '昌宁县', '5305', '5');
INSERT INTO `bt_area` VALUES ('530523', '龙陵县', '5305', '4');
INSERT INTO `bt_area` VALUES ('530522', '腾冲县', '5305', '3');
INSERT INTO `bt_area` VALUES ('530521', '施甸县', '5305', '2');
INSERT INTO `bt_area` VALUES ('530502', '隆阳区', '5305', '1');
INSERT INTO `bt_area` VALUES ('530428', '元江哈尼族彝族傣族自治县', '5304', '9');
INSERT INTO `bt_area` VALUES ('530427', '新平彝族傣族自治县', '5304', '8');
INSERT INTO `bt_area` VALUES ('530426', '峨山彝族自治县', '5304', '7');
INSERT INTO `bt_area` VALUES ('530425', '易门县', '5304', '6');
INSERT INTO `bt_area` VALUES ('530424', '华宁县', '5304', '5');
INSERT INTO `bt_area` VALUES ('530423', '通海县', '5304', '4');
INSERT INTO `bt_area` VALUES ('530422', '澄江县', '5304', '3');
INSERT INTO `bt_area` VALUES ('530421', '江川县', '5304', '2');
INSERT INTO `bt_area` VALUES ('530402', '红塔区', '5304', '1');
INSERT INTO `bt_area` VALUES ('530381', '宣威市', '5303', '9');
INSERT INTO `bt_area` VALUES ('530328', '沾益县', '5303', '8');
INSERT INTO `bt_area` VALUES ('530326', '会泽县', '5303', '7');
INSERT INTO `bt_area` VALUES ('530325', '富源县', '5303', '6');
INSERT INTO `bt_area` VALUES ('530324', '罗平县', '5303', '5');
INSERT INTO `bt_area` VALUES ('530323', '师宗县', '5303', '4');
INSERT INTO `bt_area` VALUES ('530322', '陆良县', '5303', '3');
INSERT INTO `bt_area` VALUES ('530321', '马龙县', '5303', '2');
INSERT INTO `bt_area` VALUES ('530302', '麒麟区', '5303', '1');
INSERT INTO `bt_area` VALUES ('530181', '安宁市', '5301', '14');
INSERT INTO `bt_area` VALUES ('530129', '寻甸回族彝族自治县', '5301', '13');
INSERT INTO `bt_area` VALUES ('530128', '禄劝彝族苗族自治县', '5301', '12');
INSERT INTO `bt_area` VALUES ('530127', '嵩明县', '5301', '11');
INSERT INTO `bt_area` VALUES ('530126', '石林彝族自治县', '5301', '10');
INSERT INTO `bt_area` VALUES ('530125', '宜良县', '5301', '9');
INSERT INTO `bt_area` VALUES ('530124', '富民县', '5301', '8');
INSERT INTO `bt_area` VALUES ('530122', '晋宁县', '5301', '7');
INSERT INTO `bt_area` VALUES ('530121', '呈贡县', '5301', '6');
INSERT INTO `bt_area` VALUES ('530113', '东川区', '5301', '5');
INSERT INTO `bt_area` VALUES ('530112', '西山区', '5301', '4');
INSERT INTO `bt_area` VALUES ('530111', '官渡区', '5301', '3');
INSERT INTO `bt_area` VALUES ('530103', '盘龙区', '5301', '2');
INSERT INTO `bt_area` VALUES ('530102', '五华区', '5301', '1');
INSERT INTO `bt_area` VALUES ('522732', '三都水族自治县', '5227', '12');
INSERT INTO `bt_area` VALUES ('522731', '惠水县', '5227', '11');
INSERT INTO `bt_area` VALUES ('522730', '龙里县', '5227', '10');
INSERT INTO `bt_area` VALUES ('522729', '长顺县', '5227', '9');
INSERT INTO `bt_area` VALUES ('522728', '罗甸县', '5227', '8');
INSERT INTO `bt_area` VALUES ('522727', '平塘县', '5227', '7');
INSERT INTO `bt_area` VALUES ('522726', '独山县', '5227', '6');
INSERT INTO `bt_area` VALUES ('522725', '瓮安县', '5227', '5');
INSERT INTO `bt_area` VALUES ('522723', '贵定县', '5227', '4');
INSERT INTO `bt_area` VALUES ('522722', '荔波县', '5227', '3');
INSERT INTO `bt_area` VALUES ('522702', '福泉市', '5227', '2');
INSERT INTO `bt_area` VALUES ('522701', '都匀市', '5227', '1');
INSERT INTO `bt_area` VALUES ('522636', '丹寨县', '5226', '16');
INSERT INTO `bt_area` VALUES ('522635', '麻江县', '5226', '15');
INSERT INTO `bt_area` VALUES ('522634', '雷山县', '5226', '14');
INSERT INTO `bt_area` VALUES ('522633', '从江县', '5226', '13');
INSERT INTO `bt_area` VALUES ('522632', '榕江县', '5226', '12');
INSERT INTO `bt_area` VALUES ('522631', '黎平县', '5226', '11');
INSERT INTO `bt_area` VALUES ('522630', '台江县', '5226', '10');
INSERT INTO `bt_area` VALUES ('522629', '剑河县', '5226', '9');
INSERT INTO `bt_area` VALUES ('522628', '锦屏县', '5226', '8');
INSERT INTO `bt_area` VALUES ('522627', '天柱县', '5226', '7');
INSERT INTO `bt_area` VALUES ('522626', '岑巩县', '5226', '6');
INSERT INTO `bt_area` VALUES ('522625', '镇远县', '5226', '5');
INSERT INTO `bt_area` VALUES ('522624', '三穗县', '5226', '4');
INSERT INTO `bt_area` VALUES ('522623', '施秉县', '5226', '3');
INSERT INTO `bt_area` VALUES ('522622', '黄平县', '5226', '2');
INSERT INTO `bt_area` VALUES ('522601', '凯里市', '5226', '1');
INSERT INTO `bt_area` VALUES ('522428', '赫章县', '5224', '8');
INSERT INTO `bt_area` VALUES ('522427', '威宁彝族回族苗族自治县', '5224', '7');
INSERT INTO `bt_area` VALUES ('522426', '纳雍县', '5224', '6');
INSERT INTO `bt_area` VALUES ('522425', '织金县', '5224', '5');
INSERT INTO `bt_area` VALUES ('522424', '金沙县', '5224', '4');
INSERT INTO `bt_area` VALUES ('522423', '黔西县', '5224', '3');
INSERT INTO `bt_area` VALUES ('522422', '大方县', '5224', '2');
INSERT INTO `bt_area` VALUES ('522401', '毕节市', '5224', '1');
INSERT INTO `bt_area` VALUES ('522328', '安龙县', '5223', '8');
INSERT INTO `bt_area` VALUES ('522327', '册亨县', '5223', '7');
INSERT INTO `bt_area` VALUES ('522326', '望谟县', '5223', '6');
INSERT INTO `bt_area` VALUES ('522325', '贞丰县', '5223', '5');
INSERT INTO `bt_area` VALUES ('522324', '晴隆县', '5223', '4');
INSERT INTO `bt_area` VALUES ('522323', '普安县', '5223', '3');
INSERT INTO `bt_area` VALUES ('522322', '兴仁县', '5223', '2');
INSERT INTO `bt_area` VALUES ('522301', '兴义市', '5223', '1');
INSERT INTO `bt_area` VALUES ('522230', '万山特区', '5222', '10');
INSERT INTO `bt_area` VALUES ('522229', '松桃苗族自治县', '5222', '9');
INSERT INTO `bt_area` VALUES ('522228', '沿河土家族自治县', '5222', '8');
INSERT INTO `bt_area` VALUES ('522227', '德江县', '5222', '7');
INSERT INTO `bt_area` VALUES ('522226', '印江土家族苗族自治县', '5222', '6');
INSERT INTO `bt_area` VALUES ('522225', '思南县', '5222', '5');
INSERT INTO `bt_area` VALUES ('522224', '石阡县', '5222', '4');
INSERT INTO `bt_area` VALUES ('522223', '玉屏侗族自治县', '5222', '3');
INSERT INTO `bt_area` VALUES ('522222', '江口县', '5222', '2');
INSERT INTO `bt_area` VALUES ('522201', '铜仁市', '5222', '1');
INSERT INTO `bt_area` VALUES ('520425', '紫云苗族布依族自治县', '5204', '6');
INSERT INTO `bt_area` VALUES ('520424', '关岭布依族苗族自治县', '5204', '5');
INSERT INTO `bt_area` VALUES ('520423', '镇宁布依族苗族自治县', '5204', '4');
INSERT INTO `bt_area` VALUES ('520422', '普定县', '5204', '3');
INSERT INTO `bt_area` VALUES ('520421', '平坝县', '5204', '2');
INSERT INTO `bt_area` VALUES ('520402', '西秀区', '5204', '1');
INSERT INTO `bt_area` VALUES ('520382', '仁怀市', '5203', '14');
INSERT INTO `bt_area` VALUES ('520381', '赤水市', '5203', '13');
INSERT INTO `bt_area` VALUES ('520330', '习水县', '5203', '12');
INSERT INTO `bt_area` VALUES ('520329', '余庆县', '5203', '11');
INSERT INTO `bt_area` VALUES ('520328', '湄潭县', '5203', '10');
INSERT INTO `bt_area` VALUES ('520327', '凤冈县', '5203', '9');
INSERT INTO `bt_area` VALUES ('520326', '务川仡佬族苗族自治县', '5203', '8');
INSERT INTO `bt_area` VALUES ('520325', '道真仡佬族苗族自治县', '5203', '7');
INSERT INTO `bt_area` VALUES ('520324', '正安县', '5203', '6');
INSERT INTO `bt_area` VALUES ('520323', '绥阳县', '5203', '5');
INSERT INTO `bt_area` VALUES ('520322', '桐梓县', '5203', '4');
INSERT INTO `bt_area` VALUES ('520321', '遵义县', '5203', '3');
INSERT INTO `bt_area` VALUES ('520303', '汇川区', '5203', '2');
INSERT INTO `bt_area` VALUES ('520302', '红花岗区', '5203', '1');
INSERT INTO `bt_area` VALUES ('520222', '盘县', '5202', '4');
INSERT INTO `bt_area` VALUES ('520221', '水城县', '5202', '3');
INSERT INTO `bt_area` VALUES ('520203', '六枝特区', '5202', '2');
INSERT INTO `bt_area` VALUES ('520201', '钟山区', '5202', '1');
INSERT INTO `bt_area` VALUES ('520181', '清镇市', '5201', '10');
INSERT INTO `bt_area` VALUES ('520123', '修文县', '5201', '9');
INSERT INTO `bt_area` VALUES ('520122', '息烽县', '5201', '8');
INSERT INTO `bt_area` VALUES ('520121', '开阳县', '5201', '7');
INSERT INTO `bt_area` VALUES ('520114', '小河区', '5201', '6');
INSERT INTO `bt_area` VALUES ('520113', '白云区', '5201', '5');
INSERT INTO `bt_area` VALUES ('520112', '乌当区', '5201', '4');
INSERT INTO `bt_area` VALUES ('520111', '花溪区', '5201', '3');
INSERT INTO `bt_area` VALUES ('520103', '云岩区', '5201', '2');
INSERT INTO `bt_area` VALUES ('520102', '南明区', '5201', '1');
INSERT INTO `bt_area` VALUES ('513437', '雷波县', '5134', '17');
INSERT INTO `bt_area` VALUES ('513436', '美姑县', '5134', '16');
INSERT INTO `bt_area` VALUES ('513435', '甘洛县', '5134', '15');
INSERT INTO `bt_area` VALUES ('513434', '越西县', '5134', '14');
INSERT INTO `bt_area` VALUES ('513433', '冕宁县', '5134', '13');
INSERT INTO `bt_area` VALUES ('513432', '喜德县', '5134', '12');
INSERT INTO `bt_area` VALUES ('513431', '昭觉县', '5134', '11');
INSERT INTO `bt_area` VALUES ('513430', '金阳县', '5134', '10');
INSERT INTO `bt_area` VALUES ('513429', '布拖县', '5134', '9');
INSERT INTO `bt_area` VALUES ('513428', '普格县', '5134', '8');
INSERT INTO `bt_area` VALUES ('513427', '宁南县', '5134', '7');
INSERT INTO `bt_area` VALUES ('513426', '会东县', '5134', '6');
INSERT INTO `bt_area` VALUES ('513425', '会理县', '5134', '5');
INSERT INTO `bt_area` VALUES ('513424', '德昌县', '5134', '4');
INSERT INTO `bt_area` VALUES ('513423', '盐源县', '5134', '3');
INSERT INTO `bt_area` VALUES ('513422', '木里藏族自治县', '5134', '2');
INSERT INTO `bt_area` VALUES ('513401', '西昌市', '5134', '1');
INSERT INTO `bt_area` VALUES ('513338', '得荣县', '5133', '18');
INSERT INTO `bt_area` VALUES ('513337', '稻城县', '5133', '17');
INSERT INTO `bt_area` VALUES ('513336', '乡城县', '5133', '16');
INSERT INTO `bt_area` VALUES ('513335', '巴塘县', '5133', '15');
INSERT INTO `bt_area` VALUES ('513334', '理塘县', '5133', '14');
INSERT INTO `bt_area` VALUES ('513333', '色达县', '5133', '13');
INSERT INTO `bt_area` VALUES ('513332', '石渠县', '5133', '12');
INSERT INTO `bt_area` VALUES ('513331', '白玉县', '5133', '11');
INSERT INTO `bt_area` VALUES ('513330', '德格县', '5133', '10');
INSERT INTO `bt_area` VALUES ('513329', '新龙县', '5133', '9');
INSERT INTO `bt_area` VALUES ('513328', '甘孜县', '5133', '8');
INSERT INTO `bt_area` VALUES ('513327', '炉霍县', '5133', '7');
INSERT INTO `bt_area` VALUES ('513326', '道孚县', '5133', '6');
INSERT INTO `bt_area` VALUES ('513325', '雅江县', '5133', '5');
INSERT INTO `bt_area` VALUES ('513324', '九龙县', '5133', '4');
INSERT INTO `bt_area` VALUES ('513323', '丹巴县', '5133', '3');
INSERT INTO `bt_area` VALUES ('513322', '泸定县', '5133', '2');
INSERT INTO `bt_area` VALUES ('513321', '康定县', '5133', '1');
INSERT INTO `bt_area` VALUES ('513233', '红原县', '5132', '13');
INSERT INTO `bt_area` VALUES ('513232', '若尔盖县', '5132', '12');
INSERT INTO `bt_area` VALUES ('513231', '阿坝县', '5132', '11');
INSERT INTO `bt_area` VALUES ('513230', '壤塘县', '5132', '10');
INSERT INTO `bt_area` VALUES ('513229', '马尔康县', '5132', '9');
INSERT INTO `bt_area` VALUES ('513228', '黑水县', '5132', '8');
INSERT INTO `bt_area` VALUES ('513227', '小金县', '5132', '7');
INSERT INTO `bt_area` VALUES ('513226', '金川县', '5132', '6');
INSERT INTO `bt_area` VALUES ('513225', '九寨沟县', '5132', '5');
INSERT INTO `bt_area` VALUES ('513224', '松潘县', '5132', '4');
INSERT INTO `bt_area` VALUES ('513223', '茂县', '5132', '3');
INSERT INTO `bt_area` VALUES ('513222', '理县', '5132', '2');
INSERT INTO `bt_area` VALUES ('513221', '汶川县', '5132', '1');
INSERT INTO `bt_area` VALUES ('512081', '简阳市', '5120', '4');
INSERT INTO `bt_area` VALUES ('512022', '乐至县', '5120', '3');
INSERT INTO `bt_area` VALUES ('512021', '安岳县', '5120', '2');
INSERT INTO `bt_area` VALUES ('512002', '雁江区', '5120', '1');
INSERT INTO `bt_area` VALUES ('511923', '平昌县', '5119', '4');
INSERT INTO `bt_area` VALUES ('511922', '南江县', '5119', '3');
INSERT INTO `bt_area` VALUES ('511921', '通江县', '5119', '2');
INSERT INTO `bt_area` VALUES ('511902', '巴州区', '5119', '1');
INSERT INTO `bt_area` VALUES ('511827', '宝兴县', '5118', '8');
INSERT INTO `bt_area` VALUES ('511826', '芦山县', '5118', '7');
INSERT INTO `bt_area` VALUES ('511825', '天全县', '5118', '6');
INSERT INTO `bt_area` VALUES ('511824', '石棉县', '5118', '5');
INSERT INTO `bt_area` VALUES ('511823', '汉源县', '5118', '4');
INSERT INTO `bt_area` VALUES ('511822', '荥经县', '5118', '3');
INSERT INTO `bt_area` VALUES ('511821', '名山县', '5118', '2');
INSERT INTO `bt_area` VALUES ('511802', '雨城区', '5118', '1');
INSERT INTO `bt_area` VALUES ('511781', '万源市', '5117', '7');
INSERT INTO `bt_area` VALUES ('511725', '渠县', '5117', '6');
INSERT INTO `bt_area` VALUES ('511724', '大竹县', '5117', '5');
INSERT INTO `bt_area` VALUES ('511723', '开江县', '5117', '4');
INSERT INTO `bt_area` VALUES ('511722', '宣汉县', '5117', '3');
INSERT INTO `bt_area` VALUES ('511721', '达县', '5117', '2');
INSERT INTO `bt_area` VALUES ('511702', '通川区', '5117', '1');
INSERT INTO `bt_area` VALUES ('511681', '华蓥市', '5116', '5');
INSERT INTO `bt_area` VALUES ('511623', '邻水县', '5116', '4');
INSERT INTO `bt_area` VALUES ('511622', '武胜县', '5116', '3');
INSERT INTO `bt_area` VALUES ('511621', '岳池县', '5116', '2');
INSERT INTO `bt_area` VALUES ('511602', '广安区', '5116', '1');
INSERT INTO `bt_area` VALUES ('511529', '屏山县', '5115', '10');
INSERT INTO `bt_area` VALUES ('511528', '兴文县', '5115', '9');
INSERT INTO `bt_area` VALUES ('511527', '筠连县', '5115', '8');
INSERT INTO `bt_area` VALUES ('511526', '珙县', '5115', '7');
INSERT INTO `bt_area` VALUES ('511525', '高县', '5115', '6');
INSERT INTO `bt_area` VALUES ('511524', '长宁县', '5115', '5');
INSERT INTO `bt_area` VALUES ('511523', '江安县', '5115', '4');
INSERT INTO `bt_area` VALUES ('511522', '南溪县', '5115', '3');
INSERT INTO `bt_area` VALUES ('511521', '宜宾县', '5115', '2');
INSERT INTO `bt_area` VALUES ('511502', '翠屏区', '5115', '1');
INSERT INTO `bt_area` VALUES ('511425', '青神县', '5114', '6');
INSERT INTO `bt_area` VALUES ('511424', '丹棱县', '5114', '5');
INSERT INTO `bt_area` VALUES ('511423', '洪雅县', '5114', '4');
INSERT INTO `bt_area` VALUES ('511422', '彭山县', '5114', '3');
INSERT INTO `bt_area` VALUES ('511421', '仁寿县', '5114', '2');
INSERT INTO `bt_area` VALUES ('511402', '东坡区', '5114', '1');
INSERT INTO `bt_area` VALUES ('511381', '阆中市', '5113', '9');
INSERT INTO `bt_area` VALUES ('511325', '西充县', '5113', '8');
INSERT INTO `bt_area` VALUES ('511324', '仪陇县', '5113', '7');
INSERT INTO `bt_area` VALUES ('511323', '蓬安县', '5113', '6');
INSERT INTO `bt_area` VALUES ('511322', '营山县', '5113', '5');
INSERT INTO `bt_area` VALUES ('511321', '南部县', '5113', '4');
INSERT INTO `bt_area` VALUES ('511304', '嘉陵区', '5113', '3');
INSERT INTO `bt_area` VALUES ('511303', '高坪区', '5113', '2');
INSERT INTO `bt_area` VALUES ('511302', '顺庆区', '5113', '1');
INSERT INTO `bt_area` VALUES ('511181', '峨眉山市', '5111', '11');
INSERT INTO `bt_area` VALUES ('511133', '马边彝族自治县', '5111', '10');
INSERT INTO `bt_area` VALUES ('511132', '峨边彝族自治县', '5111', '9');
INSERT INTO `bt_area` VALUES ('511129', '沐川县', '5111', '8');
INSERT INTO `bt_area` VALUES ('511126', '夹江县', '5111', '7');
INSERT INTO `bt_area` VALUES ('511124', '井研县', '5111', '6');
INSERT INTO `bt_area` VALUES ('511123', '犍为县', '5111', '5');
INSERT INTO `bt_area` VALUES ('511113', '金口河区', '5111', '4');
INSERT INTO `bt_area` VALUES ('511112', '五通桥区', '5111', '3');
INSERT INTO `bt_area` VALUES ('511111', '沙湾区', '5111', '2');
INSERT INTO `bt_area` VALUES ('511102', '市中区', '5111', '1');
INSERT INTO `bt_area` VALUES ('511028', '隆昌县', '5110', '5');
INSERT INTO `bt_area` VALUES ('511025', '资中县', '5110', '4');
INSERT INTO `bt_area` VALUES ('511024', '威远县', '5110', '3');
INSERT INTO `bt_area` VALUES ('511011', '东兴区', '5110', '2');
INSERT INTO `bt_area` VALUES ('511002', '市中区', '5110', '1');
INSERT INTO `bt_area` VALUES ('510923', '大英县', '5109', '5');
INSERT INTO `bt_area` VALUES ('510922', '射洪县', '5109', '4');
INSERT INTO `bt_area` VALUES ('510921', '蓬溪县', '5109', '3');
INSERT INTO `bt_area` VALUES ('510904', '安居区', '5109', '2');
INSERT INTO `bt_area` VALUES ('510903', '船山区', '5109', '1');
INSERT INTO `bt_area` VALUES ('510824', '苍溪县', '5108', '7');
INSERT INTO `bt_area` VALUES ('510823', '剑阁县', '5108', '6');
INSERT INTO `bt_area` VALUES ('510822', '青川县', '5108', '5');
INSERT INTO `bt_area` VALUES ('510821', '旺苍县', '5108', '4');
INSERT INTO `bt_area` VALUES ('510812', '朝天区', '5108', '3');
INSERT INTO `bt_area` VALUES ('510811', '元坝区', '5108', '2');
INSERT INTO `bt_area` VALUES ('510802', '利州区', '5108', '1');
INSERT INTO `bt_area` VALUES ('510781', '江油市', '5107', '9');
INSERT INTO `bt_area` VALUES ('510727', '平武县', '5107', '8');
INSERT INTO `bt_area` VALUES ('510726', '北川羌族自治县', '5107', '7');
INSERT INTO `bt_area` VALUES ('510725', '梓潼县', '5107', '6');
INSERT INTO `bt_area` VALUES ('510724', '安县', '5107', '5');
INSERT INTO `bt_area` VALUES ('510723', '盐亭县', '5107', '4');
INSERT INTO `bt_area` VALUES ('510722', '三台县', '5107', '3');
INSERT INTO `bt_area` VALUES ('510704', '游仙区', '5107', '2');
INSERT INTO `bt_area` VALUES ('510703', '涪城区', '5107', '1');
INSERT INTO `bt_area` VALUES ('510683', '绵竹市', '5106', '6');
INSERT INTO `bt_area` VALUES ('510682', '什邡市', '5106', '5');
INSERT INTO `bt_area` VALUES ('510681', '广汉市', '5106', '4');
INSERT INTO `bt_area` VALUES ('510626', '罗江县', '5106', '3');
INSERT INTO `bt_area` VALUES ('510623', '中江县', '5106', '2');
INSERT INTO `bt_area` VALUES ('510603', '旌阳区', '5106', '1');
INSERT INTO `bt_area` VALUES ('510525', '古蔺县', '5105', '7');
INSERT INTO `bt_area` VALUES ('510524', '叙永县', '5105', '6');
INSERT INTO `bt_area` VALUES ('510522', '合江县', '5105', '5');
INSERT INTO `bt_area` VALUES ('510521', '泸县', '5105', '4');
INSERT INTO `bt_area` VALUES ('510504', '龙马潭区', '5105', '3');
INSERT INTO `bt_area` VALUES ('510503', '纳溪区', '5105', '2');
INSERT INTO `bt_area` VALUES ('510502', '江阳区', '5105', '1');
INSERT INTO `bt_area` VALUES ('510422', '盐边县', '5104', '5');
INSERT INTO `bt_area` VALUES ('510421', '米易县', '5104', '4');
INSERT INTO `bt_area` VALUES ('510411', '仁和区', '5104', '3');
INSERT INTO `bt_area` VALUES ('510403', '西区', '5104', '2');
INSERT INTO `bt_area` VALUES ('510402', '东区', '5104', '1');
INSERT INTO `bt_area` VALUES ('510322', '富顺县', '5103', '6');
INSERT INTO `bt_area` VALUES ('510321', '荣县', '5103', '5');
INSERT INTO `bt_area` VALUES ('510311', '沿滩区', '5103', '4');
INSERT INTO `bt_area` VALUES ('510304', '大安区', '5103', '3');
INSERT INTO `bt_area` VALUES ('510303', '贡井区', '5103', '2');
INSERT INTO `bt_area` VALUES ('510302', '自流井区', '5103', '1');
INSERT INTO `bt_area` VALUES ('510184', '崇州市', '5101', '19');
INSERT INTO `bt_area` VALUES ('510183', '邛崃市', '5101', '18');
INSERT INTO `bt_area` VALUES ('510182', '彭州市', '5101', '17');
INSERT INTO `bt_area` VALUES ('510181', '都江堰市', '5101', '16');
INSERT INTO `bt_area` VALUES ('510132', '新津县', '5101', '15');
INSERT INTO `bt_area` VALUES ('510131', '蒲江县', '5101', '14');
INSERT INTO `bt_area` VALUES ('510129', '大邑县', '5101', '13');
INSERT INTO `bt_area` VALUES ('510124', '郫县', '5101', '12');
INSERT INTO `bt_area` VALUES ('510122', '双流县', '5101', '11');
INSERT INTO `bt_area` VALUES ('510121', '金堂县', '5101', '10');
INSERT INTO `bt_area` VALUES ('510115', '温江区', '5101', '9');
INSERT INTO `bt_area` VALUES ('510114', '新都区', '5101', '8');
INSERT INTO `bt_area` VALUES ('510113', '青白江区', '5101', '7');
INSERT INTO `bt_area` VALUES ('510112', '龙泉驿区', '5101', '6');
INSERT INTO `bt_area` VALUES ('510108', '成华区', '5101', '5');
INSERT INTO `bt_area` VALUES ('510107', '武侯区', '5101', '4');
INSERT INTO `bt_area` VALUES ('510106', '金牛区', '5101', '3');
INSERT INTO `bt_area` VALUES ('510105', '青羊区', '5101', '2');
INSERT INTO `bt_area` VALUES ('510104', '锦江区', '5101', '1');
INSERT INTO `bt_area` VALUES ('508419', '南川区', '5084', '1');
INSERT INTO `bt_area` VALUES ('508318', '永川区', '5083', '1');
INSERT INTO `bt_area` VALUES ('508217', '合川区', '5082', '1');
INSERT INTO `bt_area` VALUES ('508116', '江津区', '5081', '1');
INSERT INTO `bt_area` VALUES ('504343', '彭水苗族土家族自治县', '5043', '1');
INSERT INTO `bt_area` VALUES ('504242', '酉阳土家族苗族自治县', '5042', '1');
INSERT INTO `bt_area` VALUES ('504141', '秀山土家族苗族自治县', '5041', '1');
INSERT INTO `bt_area` VALUES ('504040', '石柱土家族自治县', '5040', '1');
INSERT INTO `bt_area` VALUES ('503914', '黔江区', '5039', '1');
INSERT INTO `bt_area` VALUES ('503838', '巫溪县', '5038', '1');
INSERT INTO `bt_area` VALUES ('503737', '巫山县', '5037', '1');
INSERT INTO `bt_area` VALUES ('503636', '奉节县', '5036', '1');
INSERT INTO `bt_area` VALUES ('503535', '云阳县', '5035', '1');
INSERT INTO `bt_area` VALUES ('503434', '开县', '5034', '1');
INSERT INTO `bt_area` VALUES ('503333', '忠县', '5033', '1');
INSERT INTO `bt_area` VALUES ('503232', '武隆县', '5032', '1');
INSERT INTO `bt_area` VALUES ('503131', '垫江县', '5031', '1');
INSERT INTO `bt_area` VALUES ('503030', '丰都县', '5030', '1');
INSERT INTO `bt_area` VALUES ('502929', '城口县', '5029', '1');
INSERT INTO `bt_area` VALUES ('502828', '梁平县', '5028', '1');
INSERT INTO `bt_area` VALUES ('502727', '璧山县', '5027', '1');
INSERT INTO `bt_area` VALUES ('502626', '荣昌县', '5026', '1');
INSERT INTO `bt_area` VALUES ('502525', '大足县', '5025', '1');
INSERT INTO `bt_area` VALUES ('502424', '铜梁县', '5024', '1');
INSERT INTO `bt_area` VALUES ('502323', '潼南县', '5023', '1');
INSERT INTO `bt_area` VALUES ('502222', '綦江县', '5022', '1');
INSERT INTO `bt_area` VALUES ('502115', '长寿区', '5021', '1');
INSERT INTO `bt_area` VALUES ('501313', '巴南区', '5013', '1');
INSERT INTO `bt_area` VALUES ('501212', '渝北区', '5012', '1');
INSERT INTO `bt_area` VALUES ('501111', '双桥区', '5011', '1');
INSERT INTO `bt_area` VALUES ('501010', '万盛区', '5010', '1');
INSERT INTO `bt_area` VALUES ('500909', '北碚区', '5009', '1');
INSERT INTO `bt_area` VALUES ('500808', '南岸区', '5008', '1');
INSERT INTO `bt_area` VALUES ('500707', '九龙坡区', '5007', '1');
INSERT INTO `bt_area` VALUES ('500606', '沙坪坝区', '5006', '1');
INSERT INTO `bt_area` VALUES ('500505', '江北区', '5005', '1');
INSERT INTO `bt_area` VALUES ('500104', '大渡口区', '5004', '1');
INSERT INTO `bt_area` VALUES ('500303', '渝中区', '5003', '1');
INSERT INTO `bt_area` VALUES ('500202', '涪陵区', '5002', '1');
INSERT INTO `bt_area` VALUES ('500101', '万州区', '5001', '1');
INSERT INTO `bt_area` VALUES ('460800', '东方', '4608', '1');
INSERT INTO `bt_area` VALUES ('460700', '万宁', '4607', '1');
INSERT INTO `bt_area` VALUES ('460600', '文昌', '4606', '1');
INSERT INTO `bt_area` VALUES ('460500', '儋州', '4605', '1');
INSERT INTO `bt_area` VALUES ('460400', '琼海', '4604', '1');
INSERT INTO `bt_area` VALUES ('460300', '五指山', '4603', '1');
INSERT INTO `bt_area` VALUES ('460200', '三亚市', '4602', '1');
INSERT INTO `bt_area` VALUES ('460108', '美兰区', '4601', '4');
INSERT INTO `bt_area` VALUES ('460107', '琼山区', '4601', '3');
INSERT INTO `bt_area` VALUES ('460106', '龙华区', '4601', '2');
INSERT INTO `bt_area` VALUES ('460105', '秀英区', '4601', '1');
INSERT INTO `bt_area` VALUES ('451481', '凭祥市', '4514', '7');
INSERT INTO `bt_area` VALUES ('451425', '天等县', '4514', '6');
INSERT INTO `bt_area` VALUES ('451424', '大新县', '4514', '5');
INSERT INTO `bt_area` VALUES ('451423', '龙州县', '4514', '4');
INSERT INTO `bt_area` VALUES ('451422', '宁明县', '4514', '3');
INSERT INTO `bt_area` VALUES ('451421', '扶绥县', '4514', '2');
INSERT INTO `bt_area` VALUES ('451402', '江洲区', '4514', '1');
INSERT INTO `bt_area` VALUES ('451381', '合山市', '4513', '6');
INSERT INTO `bt_area` VALUES ('451324', '金秀瑶族自治县', '4513', '5');
INSERT INTO `bt_area` VALUES ('451323', '武宣县', '4513', '4');
INSERT INTO `bt_area` VALUES ('451322', '象州县', '4513', '3');
INSERT INTO `bt_area` VALUES ('451321', '忻城县', '4513', '2');
INSERT INTO `bt_area` VALUES ('451302', '兴宾区', '4513', '1');
INSERT INTO `bt_area` VALUES ('451281', '宜州市', '4512', '11');
INSERT INTO `bt_area` VALUES ('451229', '大化瑶族自治县', '4512', '10');
INSERT INTO `bt_area` VALUES ('451228', '都安瑶族自治县', '4512', '9');
INSERT INTO `bt_area` VALUES ('451227', '巴马瑶族自治县', '4512', '8');
INSERT INTO `bt_area` VALUES ('451226', '环江毛南族自治县', '4512', '7');
INSERT INTO `bt_area` VALUES ('451225', '罗城仫佬族自治县', '4512', '6');
INSERT INTO `bt_area` VALUES ('451224', '东兰县', '4512', '5');
INSERT INTO `bt_area` VALUES ('451223', '凤山县', '4512', '4');
INSERT INTO `bt_area` VALUES ('451222', '天峨县', '4512', '3');
INSERT INTO `bt_area` VALUES ('451221', '南丹县', '4512', '2');
INSERT INTO `bt_area` VALUES ('451202', '金城江区', '4512', '1');
INSERT INTO `bt_area` VALUES ('451123', '富川瑶族自治县', '4511', '4');
INSERT INTO `bt_area` VALUES ('451122', '钟山县', '4511', '3');
INSERT INTO `bt_area` VALUES ('451121', '昭平县', '4511', '2');
INSERT INTO `bt_area` VALUES ('451102', '八步区', '4511', '1');
INSERT INTO `bt_area` VALUES ('451031', '隆林各族自治县', '4510', '12');
INSERT INTO `bt_area` VALUES ('451030', '西林县', '4510', '11');
INSERT INTO `bt_area` VALUES ('451029', '田林县', '4510', '10');
INSERT INTO `bt_area` VALUES ('451028', '乐业县', '4510', '9');
INSERT INTO `bt_area` VALUES ('451027', '凌云县', '4510', '8');
INSERT INTO `bt_area` VALUES ('451026', '那坡县', '4510', '7');
INSERT INTO `bt_area` VALUES ('451025', '靖西县', '4510', '6');
INSERT INTO `bt_area` VALUES ('451024', '德保县', '4510', '5');
INSERT INTO `bt_area` VALUES ('451023', '平果县', '4510', '4');
INSERT INTO `bt_area` VALUES ('451022', '田东县', '4510', '3');
INSERT INTO `bt_area` VALUES ('451021', '田阳县', '4510', '2');
INSERT INTO `bt_area` VALUES ('451002', '右江区', '4510', '1');
INSERT INTO `bt_area` VALUES ('450981', '北流市', '4509', '6');
INSERT INTO `bt_area` VALUES ('450924', '兴业县', '4509', '5');
INSERT INTO `bt_area` VALUES ('450923', '博白县', '4509', '4');
INSERT INTO `bt_area` VALUES ('450922', '陆川县', '4509', '3');
INSERT INTO `bt_area` VALUES ('450921', '容县', '4509', '2');
INSERT INTO `bt_area` VALUES ('450902', '玉州区', '4509', '1');
INSERT INTO `bt_area` VALUES ('450881', '桂平市', '4508', '5');
INSERT INTO `bt_area` VALUES ('450821', '平南县', '4508', '4');
INSERT INTO `bt_area` VALUES ('450804', '覃塘区', '4508', '3');
INSERT INTO `bt_area` VALUES ('450803', '港南区', '4508', '2');
INSERT INTO `bt_area` VALUES ('450802', '港北区', '4508', '1');
INSERT INTO `bt_area` VALUES ('