springboot整合mybatis实现省市区三级查询

springboot 专栏收录该内容
8 篇文章 0 订阅

1.mybaties的xml文件通过mapper.selectParentAddress()查询三级数据

<resultMap id="BaseResultMap" type="***.TAddress">
        <id column="id" jdbcType="INTEGER" property="id"/>
        <result column="name" jdbcType="VARCHAR" property="name"/>
        <result column="parent_id" jdbcType="INTEGER" property="parentId"/>
    </resultMap>
    
    <resultMap id="ParentAddress" type="java.util.Map">
        <id column="id" jdbcType="INTEGER" property="id"/>
        <result column="name" jdbcType="VARCHAR" property="name"/>
        <collection property="children" javaType="java.util.ArrayList" ofType="BaseResultMap"
                                 select="selectNextChildAddress" column="id">
    </collection>
    </resultMap>
    
    <resultMap id="NextChildAddress" type="java.util.Map">
        <id column="id" jdbcType="INTEGER" property="id"/>
        <result column="name" jdbcType="VARCHAR" property="name"/>
        <collection property="children" javaType="java.util.ArrayList" ofType="BaseResultMap"
                    select="selectLastChildAddress" column="id">
        </collection>
    </resultMap>
    
    <sql id="Base_Column_List">
        id, name, parent_id
    </sql>
    
     <select id="selectParentAddress" parameterType="java.lang.Integer" resultMap="ParentAddress">
        select
        <include refid="Base_Column_List"/>
        from t_address
        where parent_id= -1
    </select>
    
    <select id="selectNextChildAddress" parameterType="java.lang.Integer" resultMap="NextChildAddress">
        select
        <include refid="Base_Column_List"/>
        from t_address
        where parent_id = #{id,jdbcType=INTEGER}
    </select>
    
    <select id="selectLastChildAddress" parameterType="java.lang.Integer" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List"/>
        from t_address
        where parent_id = #{id,jdbcType=INTEGER}
    </select>

2.t_address省市区sql数据

/*
Navicat MySQL Data Transfer

Source Server         : guarantee
Source Server Version : 50726
Source Host           : 10.254.0.18:10001
Source Database       : guarantee

Target Server Type    : MYSQL
Target Server Version : 50726
File Encoding         : 65001

Date: 2019-12-02 15:18:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_address
-- ----------------------------
DROP TABLE IF EXISTS `t_address`;
CREATE TABLE `t_address` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
  `parent_id` int(20) NOT NULL DEFAULT '-1' COMMENT '父id,-1表示无父节点',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3526 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_address
-- ----------------------------
INSERT INTO `t_address` VALUES ('5', '北京', '-1');
INSERT INTO `t_address` VALUES ('6', '天津', '-1');
INSERT INTO `t_address` VALUES ('7', '河北', '-1');
INSERT INTO `t_address` VALUES ('8', '山西', '-1');
INSERT INTO `t_address` VALUES ('9', '内蒙古', '-1');
INSERT INTO `t_address` VALUES ('10', '辽宁', '-1');
INSERT INTO `t_address` VALUES ('11', '吉林', '-1');
INSERT INTO `t_address` VALUES ('12', '黑龙江', '-1');
INSERT INTO `t_address` VALUES ('13', '上海', '-1');
INSERT INTO `t_address` VALUES ('14', '江苏', '-1');
INSERT INTO `t_address` VALUES ('15', '浙江', '-1');
INSERT INTO `t_address` VALUES ('16', '安徽', '-1');
INSERT INTO `t_address` VALUES ('17', '福建', '-1');
INSERT INTO `t_address` VALUES ('18', '江西', '-1');
INSERT INTO `t_address` VALUES ('19', '山东', '-1');
INSERT INTO `t_address` VALUES ('20', '河南', '-1');
INSERT INTO `t_address` VALUES ('21', '湖北', '-1');
INSERT INTO `t_address` VALUES ('22', '湖南', '-1');
INSERT INTO `t_address` VALUES ('23', '广东', '-1');
INSERT INTO `t_address` VALUES ('24', '广西', '-1');
INSERT INTO `t_address` VALUES ('25', '海南', '-1');
INSERT INTO `t_address` VALUES ('26', '重庆', '-1');
INSERT INTO `t_address` VALUES ('27', '四川', '-1');
INSERT INTO `t_address` VALUES ('28', '贵州', '-1');
INSERT INTO `t_address` VALUES ('29', '云南', '-1');
INSERT INTO `t_address` VALUES ('30', '西藏', '-1');
INSERT INTO `t_address` VALUES ('31', '陕西', '-1');
INSERT INTO `t_address` VALUES ('32', '甘肃', '-1');
INSERT INTO `t_address` VALUES ('33', '青海', '-1');
INSERT INTO `t_address` VALUES ('34', '宁夏', '-1');
INSERT INTO `t_address` VALUES ('35', '新疆', '-1');
INSERT INTO `t_address` VALUES ('36', '台湾', '-1');
INSERT INTO `t_address` VALUES ('37', '香港', '-1');
INSERT INTO `t_address` VALUES ('38', '澳门', '-1');
INSERT INTO `t_address` VALUES ('39', '北京市', '5');
INSERT INTO `t_address` VALUES ('40', '石家庄市', '7');
INSERT INTO `t_address` VALUES ('41', '唐山市', '7');
INSERT INTO `t_address` VALUES ('42', '秦皇岛市', '7');
INSERT INTO `t_address` VALUES ('43', '邯郸市', '7');
INSERT INTO `t_address` VALUES ('44', '邢台市', '7');
INSERT INTO `t_address` VALUES ('45', '保定市', '7');
INSERT INTO `t_address` VALUES ('46', '张家口市', '7');
INSERT INTO `t_address` VALUES ('47', '承德市', '7');
INSERT INTO `t_address` VALUES ('48', '沧州市', '7');
INSERT INTO `t_address` VALUES ('49', '廊坊市', '7');
INSERT INTO `t_address` VALUES ('50', '衡水市', '7');
INSERT INTO `t_address` VALUES ('51', '太原市', '8');
INSERT INTO `t_address` VALUES ('52', '大同市', '8');
INSERT INTO `t_address` VALUES ('53', '阳泉市', '8');
INSERT INTO `t_address` VALUES ('54', '长治市', '8');
INSERT INTO `t_address` VALUES ('55', '晋城市', '8');
INSERT INTO `t_address` VALUES ('56', '朔州市', '8');
INSERT INTO `t_address` VALUES ('57', '晋中市', '8');
INSERT INTO `t_address` VALUES ('58', '运城市', '8');
INSERT INTO `t_address` VALUES ('59', '忻州市', '8');
INSERT INTO `t_address` VALUES ('60', '临汾市', '8');
INSERT INTO `t_address` VALUES ('61', '吕梁市', '8');
INSERT INTO `t_address` VALUES ('62', '呼和浩特市', '9');
INSERT INTO `t_address` VALUES ('63', '包头市', '9');
INSERT INTO `t_address` VALUES ('64', '乌海市', '9');
INSERT INTO `t_address` VALUES ('65', '赤峰市', '9');
INSERT INTO `t_address` VALUES ('66', '通辽市', '9');
INSERT INTO `t_address` VALUES ('67', '鄂尔多斯市', '9');
INSERT INTO `t_address` VALUES ('68', '呼伦贝尔市', '9');
INSERT INTO `t_address` VALUES ('69', '巴彦淖尔市', '9');
INSERT INTO `t_address` VALUES ('70', '乌兰察布市', '9');
INSERT INTO `t_address` VALUES ('71', '兴安盟', '9');
INSERT INTO `t_address` VALUES ('72', '锡林郭勒盟', '9');
INSERT INTO `t_address` VALUES ('73', '阿拉善盟', '9');
INSERT INTO `t_address` VALUES ('74', '沈阳市', '10');
INSERT INTO `t_address` VALUES ('75', '大连市', '10');
INSERT INTO `t_address` VALUES ('76', '鞍山市', '10');
INSERT INTO `t_address` VALUES ('77', '抚顺市', '10');
INSERT INTO `t_address` VALUES ('78', '本溪市', '10');
INSERT INTO `t_address` VALUES ('79', '丹东市', '10');
INSERT INTO `t_address` VALUES ('80', '锦州市', '10');
INSERT INTO `t_address` VALUES ('81', '营口市', '10');
INSERT INTO `t_address` VALUES ('82', '阜新市', '10');
INSERT INTO `t_address` VALUES ('83', '辽阳市', '10');
INSERT INTO `t_address` VALUES ('84', '盘锦市', '10');
INSERT INTO `t_address` VALUES ('85', '铁岭市', '10');
INSERT INTO `t_address` VALUES ('86', '朝阳市', '10');
INSERT INTO `t_address` VALUES ('87', '葫芦岛市', '10');
INSERT INTO `t_address` VALUES ('88', '长春市', '11');
INSERT INTO `t_address` VALUES ('89', '吉林市', '11');
INSERT INTO `t_address` VALUES ('90', '四平市', '11');
INSERT INTO `t_address` VALUES ('91', '辽源市', '11');
INSERT INTO `t_address` VALUES ('92', '通化市', '11');
INSERT INTO `t_address` VALUES ('93', '白山市', '11');
INSERT INTO `t_address` VALUES ('94', '松原市', '11');
INSERT INTO `t_address` VALUES ('95', '白城市', '11');
INSERT INTO `t_address` VALUES ('96', '延边朝鲜族自治州', '11');
INSERT INTO `t_address` VALUES ('97', '哈尔滨市', '12');
INSERT INTO `t_address` VALUES ('98', '齐齐哈尔市', '12');
INSERT INTO `t_address` VALUES ('99', '鸡西市', '12');
INSERT INTO `t_address` VALUES ('100', '鹤岗市', '12');
INSERT INTO `t_address` VALUES ('101', '双鸭山市', '12');
INSERT INTO `t_address` VALUES ('102', '大庆市', '12');
INSERT INTO `t_address` VALUES ('103', '伊春市', '12');
INSERT INTO `t_address` VALUES ('104', '佳木斯市', '12');
INSERT INTO `t_address` VALUES ('105', '七台河市', '12');
INSERT INTO `t_address` VALUES ('106', '牡丹江市', '12');
INSERT INTO `t_address` VALUES ('107', '黑河市', '12');
INSERT INTO `t_address` VALUES ('108', '绥化市', '12');
INSERT INTO `t_address` VALUES ('109', '大兴安岭地区', '12');
INSERT INTO `t_address` VALUES ('110', '市辖区', '13');
INSERT INTO `t_address` VALUES ('111', '县', '13');
INSERT INTO `t_address` VALUES ('112', '南京市', '14');
INSERT INTO `t_address` VALUES ('113', '无锡市', '14');
INSERT INTO `t_address` VALUES ('114', '徐州市', '14');
INSERT INTO `t_address` VALUES ('115', '常州市', '14');
INSERT INTO `t_address` VALUES ('116', '苏州市', '14');
INSERT INTO `t_address` VALUES ('117', '南通市', '14');
INSERT INTO `t_address` VALUES ('118', '连云港市', '14');
INSERT INTO `t_address` VALUES ('119', '淮安市', '14');
INSERT INTO `t_address` VALUES ('120', '盐城市', '14');
INSERT INTO `t_address` VALUES ('121', '扬州市', '14');
INSERT INTO `t_address` VALUES ('122', '镇江市', '14');
INSERT INTO `t_address` VALUES ('123', '泰州市', '14');
INSERT INTO `t_address` VALUES ('124', '宿迁市', '14');
INSERT INTO `t_address` VALUES ('125', '杭州市', '15');
INSERT INTO `t_address` VALUES ('126', '宁波市', '15');
INSERT INTO `t_address` VALUES ('127', '温州市', '15');
INSERT INTO `t_address` VALUES ('128', '嘉兴市', '15');
INSERT INTO `t_address` VALUES ('129', '湖州市', '15');
INSERT INTO `t_address` VALUES ('130', '绍兴市', '15');
INSERT INTO `t_address` VALUES ('131', '金华市', '15');
INSERT INTO `t_address` VALUES ('132', '衢州市', '15');
INSERT INTO `t_address` VALUES ('133', '舟山市', '15');
INSERT INTO `t_address` VALUES ('134', '台州市', '15');
INSERT INTO `t_address` VALUES ('135', '丽水市', '15');
INSERT INTO `t_address` VALUES ('136', '合肥市', '16');
INSERT INTO `t_address` VALUES ('137', '芜湖市', '16');
INSERT INTO `t_address` VALUES ('138', '蚌埠市', '16');
INSERT INTO `t_address` VALUES ('139', '淮南市', '16');
INSERT INTO `t_address` VALUES ('140', '马鞍山市', '16');
INSERT INTO `t_address` VALUES ('141', '淮北市', '16');
INSERT INTO `t_address` VALUES ('142', '铜陵市', '16');
INSERT INTO `t_address` VALUES ('143', '安庆市', '16');
INSERT INTO `t_address` VALUES ('144', '黄山市', '16');
INSERT INTO `t_address` VALUES ('145', '滁州市', '16');
INSERT INTO `t_address` VALUES ('146', '阜阳市', '16');
INSERT INTO `t_address` VALUES ('147', '宿州市', '16');
INSERT INTO `t_address` VALUES ('148', '巢湖市', '16');
INSERT INTO `t_address` VALUES ('149', '六安市', '16');
INSERT INTO `t_address` VALUES ('150', '亳州市', '16');
INSERT INTO `t_address` VALUES ('151', '池州市', '16');
INSERT INTO `t_address` VALUES ('152', '宣城市', '16');
INSERT INTO `t_address` VALUES ('153', '福州市', '17');
INSERT INTO `t_address` VALUES ('154', '厦门市', '17');
INSERT INTO `t_address` VALUES ('155', '莆田市', '17');
INSERT INTO `t_address` VALUES ('156', '三明市', '17');
INSERT INTO `t_address` VALUES ('157', '泉州市', '17');
INSERT INTO `t_address` VALUES ('158', '漳州市', '17');
INSERT INTO `t_address` VALUES ('159', '南平市', '17');
INSERT INTO `t_address` VALUES ('160', '龙岩市', '17');
INSERT INTO `t_address` VALUES ('161', '宁德市', '17');
INSERT INTO `t_address` VALUES ('162', '南昌市', '18');
INSERT INTO `t_address` VALUES ('163', '景德镇市', '18');
INSERT INTO `t_address` VALUES ('164', '萍乡市', '18');
INSERT INTO `t_address` VALUES ('165', '九江市', '18');
INSERT INTO `t_address` VALUES ('166', '新余市', '18');
INSERT INTO `t_address` VALUES ('167', '鹰潭市', '18');
INSERT INTO `t_address` VALUES ('168', '赣州市', '18');
INSERT INTO `t_address` VALUES ('169', '吉安市', '18');
INSERT INTO `t_address` VALUES ('170', '宜春市', '18');
INSERT INTO `t_address` VALUES ('171', '抚州市', '18');
INSERT INTO `t_address` VALUES ('172', '上饶市', '18');
INSERT INTO `t_address` VALUES ('173', '济南市', '19');
INSERT INTO `t_address` VALUES ('174', '青岛市', '19');
INSERT INTO `t_address` VALUES ('175', '淄博市', '19');
INSERT INTO `t_address` VALUES ('176', '枣庄市', '19');
INSERT INTO `t_address` VALUES ('177', '东营市', '19');
INSERT INTO `t_address` VALUES ('178', '烟台市', '19');
INSERT INTO `t_address` VALUES ('179', '潍坊市', '19');
INSERT INTO `t_address` VALUES ('180', '济宁市', '19');
INSERT INTO `t_address` VALUES ('181', '泰安市', '19');
INSERT INTO `t_address` VALUES ('182', '威海市', '19');
INSERT INTO `t_address` VALUES ('183', '日照市', '19');
INSERT INTO `t_address` VALUES ('184', '莱芜市', '19');
INSERT INTO `t_address` VALUES ('185', '临沂市', '19');
INSERT INTO `t_address` VALUES ('186', '德州市', '19');
INSERT INTO `t_address` VALUES ('187', '聊城市', '19');
INSERT INTO `t_address` VALUES ('188', '滨州市', '19');
INSERT INTO `t_address` VALUES ('189', '荷泽市', '19');
INSERT INTO `t_address` VALUES ('190', '郑州市', '20');
INSERT INTO `t_address` VALUES ('191', '开封市', '20');
INSERT INTO `t_address` VALUES ('192', '洛阳市', '20');
INSERT INTO `t_address` VALUES ('193', '平顶山市', '20');
INSERT INTO `t_address` VALUES ('194', '安阳市', '20');
INSERT INTO `t_address` VALUES ('195', '鹤壁市', '20');
INSERT INTO `t_address` VALUES ('196', '新乡市', '20');
INSERT INTO `t_address` VALUES ('197', '焦作市', '20');
INSERT INTO `t_address` VALUES ('198', '濮阳市', '20');
INSERT INTO `t_address` VALUES ('199', '许昌市', '20');
INSERT INTO `t_address` VALUES ('200', '漯河市', '20');
INSERT INTO `t_address` VALUES ('201', '三门峡市', '20');
INSERT INTO `t_address` VALUES ('202', '南阳市', '20');
INSERT INTO `t_address` VALUES ('203', '商丘市', '20');
INSERT INTO `t_address` VALUES ('204', '信阳市', '20');
INSERT INTO `t_address` VALUES ('205', '周口市', '20');
INSERT INTO `t_address` VALUES ('206', '驻马店市', '20');
INSERT INTO `t_address` VALUES ('207', '武汉市', '21');
INSERT INTO `t_address` VALUES ('208', '黄石市', '21');
INSERT INTO `t_address` VALUES ('209', '十堰市', '21');
INSERT INTO `t_address` VALUES ('210', '宜昌市', '21');
INSERT INTO `t_address` VALUES ('211', '襄樊市', '21');
INSERT INTO `t_address` VALUES ('212', '鄂州市', '21');
INSERT INTO `t_address` VALUES ('213', '荆门市', '21');
INSERT INTO `t_address` VALUES ('214', '孝感市', '21');
INSERT INTO `t_address` VALUES ('215', '荆州市', '21');
INSERT INTO `t_address` VALUES ('216', '黄冈市', '21');
INSERT INTO `t_address` VALUES ('217', '咸宁市', '21');
INSERT INTO `t_address` VALUES ('218', '随州市', '21');
INSERT INTO `t_address` VALUES ('219', '恩施土家族苗族自治州', '21');
INSERT INTO `t_address` VALUES ('220', '省直辖行政单位', '21');
INSERT INTO `t_address` VALUES ('221', '长沙市', '22');
INSERT INTO `t_address` VALUES ('222', '株洲市', '22');
INSERT INTO `t_address` VALUES ('223', '湘潭市', '22');
INSERT INTO `t_address` VALUES ('224', '衡阳市', '22');
INSERT INTO `t_address` VALUES ('225', '邵阳市', '22');
INSERT INTO `t_address` VALUES ('226', '岳阳市', '22');
INSERT INTO `t_address` VALUES ('227', '常德市', '22');
INSERT INTO `t_address` VALUES ('228', '张家界市', '22');
INSERT INTO `t_address` VALUES ('229', '益阳市', '22');
INSERT INTO `t_address` VALUES ('230', '郴州市', '22');
INSERT INTO `t_address` VALUES ('231', '永州市', '22');
INSERT INTO `t_address` VALUES ('232', '怀化市', '22');
INSERT INTO `t_address` VALUES ('233', '娄底市', '22');
INSERT INTO `t_address` VALUES ('234', '湘西土家族苗族自治州', '22');
INSERT INTO `t_address` VALUES ('235', '广州市', '23');
INSERT INTO `t_address` VALUES ('236', '韶关市', '23');
INSERT INTO `t_address` VALUES ('237', '深圳市', '23');
INSERT INTO `t_address` VALUES ('238', '珠海市', '23');
INSERT INTO `t_address` VALUES ('239', '汕头市', '23');
INSERT INTO `t_address` VALUES ('240', '佛山市', '23');
INSERT INTO `t_address` VALUES ('241', '江门市', '23');
INSERT INTO `t_address` VALUES ('242', '湛江市', '23');
INSERT INTO `t_address` VALUES ('243', '茂名市', '23');
INSERT INTO `t_address` VALUES ('244', '肇庆市', '23');
INSERT INTO `t_address` VALUES ('245', '惠州市', '23');
INSERT INTO `t_address` VALUES ('246', '梅州市', '23');
INSERT INTO `t_address` VALUES ('247', '汕尾市', '23');
INSERT INTO `t_address` VALUES ('248', '河源市', '23');
INSERT INTO `t_address` VALUES ('249', '阳江市', '23');
INSERT INTO `t_address` VALUES ('250', '清远市', '23');
INSERT INTO `t_address` VALUES ('251', '东莞市', '23');
INSERT INTO `t_address` VALUES ('252', '中山市', '23');
INSERT INTO `t_address` VALUES ('253', '潮州市', '23');
INSERT INTO `t_address` VALUES ('254', '揭阳市', '23');
INSERT INTO `t_address` VALUES ('255', '云浮市', '23');
INSERT INTO `t_address` VALUES ('256', '南宁市', '24');
INSERT INTO `t_address` VALUES ('257', '柳州市', '24');
INSERT INTO `t_address` VALUES ('258', '桂林市', '24');
INSERT INTO `t_address` VALUES ('259', '梧州市', '24');
INSERT INTO `t_address` VALUES ('260', '北海市', '24');
INSERT INTO `t_address` VALUES ('261', '防城港市', '24');
INSERT INTO `t_address` VALUES ('262', '钦州市', '24');
INSERT INTO `t_address` VALUES ('263', '贵港市', '24');
INSERT INTO `t_address` VALUES ('264', '玉林市', '24');
INSERT INTO `t_address` VALUES ('265', '百色市', '24');
INSERT INTO `t_address` VALUES ('266', '贺州市', '24');
INSERT INTO `t_address` VALUES ('267', '河池市', '24');
INSERT INTO `t_address` VALUES ('268', '来宾市', '24');
INSERT INTO `t_address` VALUES ('269', '崇左市', '24');
INSERT INTO `t_address` VALUES ('270', '海口市', '25');
INSERT INTO `t_address` VALUES ('271', '三亚市', '25');
INSERT INTO `t_address` VALUES ('272', '省直辖县级行政单位', '25');
INSERT INTO `t_address` VALUES ('273', '市辖区', '26');
INSERT INTO `t_address` VALUES ('274', '县', '26');
INSERT INTO `t_address` VALUES ('275', '市', '26');
INSERT INTO `t_address` VALUES ('276', '成都市', '27');
INSERT INTO `t_address` VALUES ('277', '自贡市', '27');
INSERT INTO `t_address` VALUES ('278', '攀枝花市', '27');
INSERT INTO `t_address` VALUES ('279', '泸州市', '27');
INSERT INTO `t_address` VALUES ('280', '德阳市', '27');
INSERT INTO `t_address` VALUES ('281', '绵阳市', '27');
INSERT INTO `t_address` VALUES ('282', '广元市', '27');
INSERT INTO `t_address` VALUES ('283', '遂宁市', '27');
INSERT INTO `t_address` VALUES ('284', '内江市', '27');
INSERT INTO `t_address` VALUES ('285', '乐山市', '27');
INSERT INTO `t_address` VALUES ('286', '南充市', '27');
INSERT INTO `t_address` VALUES ('287', '眉山市', '27');
INSERT INTO `t_address` VALUES ('288', '宜宾市', '27');
INSERT INTO `t_address` VALUES ('289', '广安市', '27');
INSERT INTO `t_address` VALUES ('290', '达州市', '27');
INSERT INTO `t_address` VALUES ('291', '雅安市', '27');
INSERT INTO `t_address` VALUES ('292', '巴中市', '27');
INSERT INTO `t_address` VALUES ('293', '资阳市', '27');
INSERT INTO `t_address` VALUES ('294', '阿坝藏族羌族自治州', '27');
INSERT INTO `t_address` VALUES ('295', '甘孜藏族自治州', '27');
INSERT INTO `t_address` VALUES ('296', '凉山彝族自治州', '27');
INSERT INTO `t_address` VALUES ('297', '贵阳市', '28');
INSERT INTO `t_address` VALUES ('298', '六盘水市', '28');
INSERT INTO `t_address` VALUES ('299', '遵义市', '28');
INSERT INTO `t_address` VALUES ('300', '安顺市', '28');
INSERT INTO `t_address` VALUES ('301', '铜仁地区', '28');
INSERT INTO `t_address` VALUES ('302', '黔西南布依族苗族自治州', '28');
INSERT INTO `t_address` VALUES ('303', '毕节地区', '28');
INSERT INTO `t_address` VALUES ('304', '黔东南苗族侗族自治州', '28');
INSERT INTO `t_address` VALUES ('305', '黔南布依族苗族自治州', '28');
INSERT INTO `t_address` VALUES ('306', '昆明市', '29');
INSERT INTO `t_address` VALUES ('307', '曲靖市', '29');
INSERT INTO `t_address` VALUES ('308', '玉溪市', '29');
INSERT INTO `t_address` VALUES ('309', '保山市', '29');
INSERT INTO `t_address` VALUES ('310', '昭通市', '29');
INSERT INTO `t_address` VALUES ('311', '丽江市', '29');
INSERT INTO `t_address` VALUES ('312', '思茅市', '29');
INSERT INTO `t_address` VALUES ('313', '临沧市', '29');
INSERT INTO `t_address` VALUES ('314', '楚雄彝族自治州', '29');
INSERT INTO `t_address` VALUES ('315', '红河哈尼族彝族自治州', '29');
INSERT INTO `t_address` VALUES ('316', '文山壮族苗族自治州', '29');
INSERT INTO `t_address` VALUES ('317', '西双版纳傣族自治州', '29');
INSERT INTO `t_address` VALUES ('318', '大理白族自治州', '29');
INSERT INTO `t_address` VALUES ('319', '德宏傣族景颇族自治州', '29');
INSERT INTO `t_address` VALUES ('320', '怒江傈僳族自治州', '29');
INSERT INTO `t_address` VALUES ('321', '迪庆藏族自治州', '29');
INSERT INTO `t_address` VALUES ('322', '拉萨市', '30');
INSERT INTO `t_address` VALUES ('323', '昌都地区', '30');
INSERT INTO `t_address` VALUES ('324', '山南地区', '30');
INSERT INTO `t_address` VALUES ('325', '日喀则地区', '30');
INSERT INTO `t_address` VALUES ('326', '那曲地区', '30');
INSERT INTO `t_address` VALUES ('327', '阿里地区', '30');
INSERT INTO `t_address` VALUES ('328', '林芝地区', '30');
INSERT INTO `t_address` VALUES ('329', '西安市', '31');
INSERT INTO `t_address` VALUES ('330', '铜川市', '31');
INSERT INTO `t_address` VALUES ('331', '宝鸡市', '31');
INSERT INTO `t_address` VALUES ('332', '咸阳市', '31');
INSERT INTO `t_address` VALUES ('333', '渭南市', '31');
INSERT INTO `t_address` VALUES ('334', '延安市', '31');
INSERT INTO `t_address` VALUES ('335', '汉中市', '31');
INSERT INTO `t_address` VALUES ('336', '榆林市', '31');
INSERT INTO `t_address` VALUES ('337', '安康市', '31');
INSERT INTO `t_address` VALUES ('338', '商洛市', '31');
INSERT INTO `t_address` VALUES ('339', '兰州市', '32');
INSERT INTO `t_address` VALUES ('340', '嘉峪关市', '32');
INSERT INTO `t_address` VALUES ('341', '金昌市', '32');
INSERT INTO `t_address` VALUES ('342', '白银市', '32');
INSERT INTO `t_address` VALUES ('343', '天水市', '32');
INSERT INTO `t_address` VALUES ('344', '武威市', '32');
INSERT INTO `t_address` VALUES ('345', '张掖市', '32');
INSERT INTO `t_address` VALUES ('346', '平凉市', '32');
INSERT INTO `t_address` VALUES ('347', '酒泉市', '32');
INSERT INTO `t_address` VALUES ('348', '庆阳市', '32');
INSERT INTO `t_address` VALUES ('349', '定西市', '32');
INSERT INTO `t_address` VALUES ('350', '陇南市', '32');
INSERT INTO `t_address` VALUES ('351', '临夏回族自治州', '32');
INSERT INTO `t_address` VALUES ('352', '甘南藏族自治州', '32');
INSERT INTO `t_address` VALUES ('353', '西宁市', '33');
INSERT INTO `t_address` VALUES ('354', '海东地区', '33');
INSERT INTO `t_address` VALUES ('355', '海北藏族自治州', '33');
INSERT INTO `t_address` VALUES ('356', '黄南藏族自治州', '33');
INSERT INTO `t_address` VALUES ('357', '海南藏族自治州', '33');
INSERT INTO `t_address` VALUES ('358', '果洛藏族自治州', '33');
INSERT INTO `t_address` VALUES ('359', '玉树藏族自治州', '33');
INSERT INTO `t_address` VALUES ('360', '海西蒙古族藏族自治州', '33');
INSERT INTO `t_address` VALUES ('361', '银川市', '34');
INSERT INTO `t_address` VALUES ('362', '石嘴山市', '34');
INSERT INTO `t_address` VALUES ('363', '吴忠市', '34');
INSERT INTO `t_address` VALUES ('364', '固原市', '34');
INSERT INTO `t_address` VALUES ('365', '中卫市', '34');
INSERT INTO `t_address` VALUES ('366', '乌鲁木齐市', '35');
INSERT INTO `t_address` VALUES ('367', '克拉玛依市', '35');
INSERT INTO `t_address` VALUES ('368', '吐鲁番地区', '35');
INSERT INTO `t_address` VALUES ('369', '哈密地区', '35');
INSERT INTO `t_address` VALUES ('370', '昌吉回族自治州', '35');
INSERT INTO `t_address` VALUES ('371', '博尔塔拉蒙古自治州', '35');
INSERT INTO `t_address` VALUES ('372', '巴音郭楞蒙古自治州', '35');
INSERT INTO `t_address` VALUES ('373', '阿克苏地区', '35');
INSERT INTO `t_address` VALUES ('374', '克孜勒苏柯尔克孜自治州', '35');
INSERT INTO `t_address` VALUES ('375', '喀什地区', '35');
INSERT INTO `t_address` VALUES ('376', '和田地区', '35');
INSERT INTO `t_address` VALUES ('377', '伊犁哈萨克自治州', '35');
INSERT INTO `t_address` VALUES ('378', '塔城地区', '35');
INSERT INTO `t_address` VALUES ('379', '阿勒泰地区', '35');
INSERT INTO `t_address` VALUES ('380', '省直辖行政单位', '35');
INSERT INTO `t_address` VALUES ('381', '天津市', '6');
INSERT INTO `t_address` VALUES ('382', '东城区', '39');
INSERT INTO `t_address` VALUES ('383', '西城区', '39');
INSERT INTO `t_address` VALUES ('384', '崇文区', '39');
INSERT INTO `t_address` VALUES ('385', '宣武区', '39');
INSERT INTO `t_address` VALUES ('386', '朝阳区', '39');
INSERT INTO `t_address` VALUES ('387', '丰台区', '39');
INSERT INTO `t_address` VALUES ('388', '石景山区', '39');
INSERT INTO `t_address` VALUES ('389', '海淀区', '39');
INSERT INTO `t_address` VALUES ('390', '门头沟区', '39');
INSERT INTO `t_address` VALUES ('391', '房山区', '39');
INSERT INTO `t_address` VALUES ('392', '通州区', '39');
INSERT INTO `t_address` VALUES ('393', '顺义区', '39');
INSERT INTO `t_address` VALUES ('394', '昌平区', '39');
INSERT INTO `t_address` VALUES ('395', '大兴区', '39');
INSERT INTO `t_address` VALUES ('396', '怀柔区', '39');
INSERT INTO `t_address` VALUES ('397', '平谷区', '39');
INSERT INTO `t_address` VALUES ('398', '密云县', '-1');
INSERT INTO `t_address` VALUES ('399', '延庆县', '-1');
INSERT INTO `t_address` VALUES ('400', '和平区', '381');
INSERT INTO `t_address` VALUES ('401', '河东区', '381');
INSERT INTO `t_address` VALUES ('402', '河西区', '381');
INSERT INTO `t_address` VALUES ('403', '南开区', '381');
INSERT INTO `t_address` VALUES ('404', '河北区', '381');
INSERT INTO `t_address` VALUES ('405', '红桥区', '381');
INSERT INTO `t_address` VALUES ('406', '塘沽区', '381');
INSERT INTO `t_address` VALUES ('407', '汉沽区', '381');
INSERT INTO `t_address` VALUES ('408', '大港区', '381');
INSERT INTO `t_address` VALUES ('409', '东丽区', '381');
INSERT INTO `t_address` VALUES ('410', '西青区', '381');
INSERT INTO `t_address` VALUES ('411', '津南区', '381');
INSERT INTO `t_address` VALUES ('412', '北辰区', '381');
INSERT INTO `t_address` VALUES ('413', '武清区', '381');
INSERT INTO `t_address` VALUES ('414', '宝坻区', '381');
INSERT INTO `t_address` VALUES ('415', '宁河县', '-1');
INSERT INTO `t_address` VALUES ('416', '静海县', '-1');
INSERT INTO `t_address` VALUES ('417', '蓟 县', '-1');
INSERT INTO `t_address` VALUES ('418', '市辖区', '40');
INSERT INTO `t_address` VALUES ('419', '长安区', '40');
INSERT INTO `t_address` VALUES ('420', '桥东区', '40');
INSERT INTO `t_address` VALUES ('421', '桥西区', '40');
INSERT INTO `t_address` VALUES ('422', '新华区', '40');
INSERT INTO `t_address` VALUES ('423', '井陉矿区', '40');
INSERT INTO `t_address` VALUES ('424', '裕华区', '40');
INSERT INTO `t_address` VALUES ('425', '井陉县', '40');
INSERT INTO `t_address` VALUES ('426', '正定县', '40');
INSERT INTO `t_address` VALUES ('427', '栾城县', '40');
INSERT INTO `t_address` VALUES ('428', '行唐县', '40');
INSERT INTO `t_address` VALUES ('429', '灵寿县', '40');
INSERT INTO `t_address` VALUES ('430', '高邑县', '40');
INSERT INTO `t_address` VALUES ('431', '深泽县', '40');
INSERT INTO `t_address` VALUES ('432', '赞皇县', '40');
INSERT INTO `t_address` VALUES ('433', '无极县', '40');
INSERT INTO `t_address` VALUES ('434', '平山县', '40');
INSERT INTO `t_address` VALUES ('435', '元氏县', '40');
INSERT INTO `t_address` VALUES ('436', '赵 县', '40');
INSERT INTO `t_address` VALUES ('437', '辛集市', '40');
INSERT INTO `t_address` VALUES ('438', '藁城市', '40');
INSERT INTO `t_address` VALUES ('439', '晋州市', '40');
INSERT INTO `t_address` VALUES ('440', '新乐市', '40');
INSERT INTO `t_address` VALUES ('441', '鹿泉市', '40');
INSERT INTO `t_address` VALUES ('442', '市辖区', '41');
INSERT INTO `t_address` VALUES ('443', '路南区', '41');
INSERT INTO `t_address` VALUES ('444', '路北区', '41');
INSERT INTO `t_address` VALUES ('445', '古冶区', '41');
INSERT INTO `t_address` VALUES ('446', '开平区', '41');
INSERT INTO `t_address` VALUES ('447', '丰南区', '41');
INSERT INTO `t_address` VALUES ('448', '丰润区', '41');
INSERT INTO `t_address` VALUES ('449', '滦 县', '41');
INSERT INTO `t_address` VALUES ('450', '滦南县', '41');
INSERT INTO `t_address` VALUES ('451', '乐亭县', '41');
INSERT INTO `t_address` VALUES ('452', '迁西县', '41');
INSERT INTO `t_address` VALUES ('453', '玉田县', '41');
INSERT INTO `t_address` VALUES ('454', '唐海县', '41');
INSERT INTO `t_address` VALUES ('455', '遵化市', '41');
INSERT INTO `t_address` VALUES ('456', '迁安市', '41');
INSERT INTO `t_address` VALUES ('457', '市辖区', '42');
INSERT INTO `t_address` VALUES ('458', '海港区', '42');
INSERT INTO `t_address` VALUES ('459', '山海关区', '42');
INSERT INTO `t_address` VALUES ('460', '北戴河区', '42');
INSERT INTO `t_address` VALUES ('461', '青龙满族自治县', '42');
INSERT INTO `t_address` VALUES ('462', '昌黎县', '42');
INSERT INTO `t_address` VALUES ('463', '抚宁县', '42');
INSERT INTO `t_address` VALUES ('464', '卢龙县', '42');
INSERT INTO `t_address` VALUES ('465', '市辖区', '43');
INSERT INTO `t_address` VALUES ('466', '邯山区', '43');
INSERT INTO `t_address` VALUES ('467', '丛台区', '43');
INSERT INTO `t_address` VALUES ('468', '复兴区', '43');
INSERT INTO `t_address` VALUES ('469', '峰峰矿区', '43');
INSERT INTO `t_address` VALUES ('470', '邯郸县', '43');
INSERT INTO `t_address` VALUES ('471', '临漳县', '43');
INSERT INTO `t_address` VALUES ('472', '成安县', '43');
INSERT INTO `t_address` VALUES ('473', '大名县', '43');
INSERT INTO `t_address` VALUES ('474', '涉 县', '43');
INSERT INTO `t_address` VALUES ('475', '磁 县', '43');
INSERT INTO `t_address` VALUES ('476', '肥乡县', '43');
INSERT INTO `t_address` VALUES ('477', '永年县', '43');
INSERT INTO `t_address` VALUES ('478', '邱 县', '43');
INSERT INTO `t_address` VALUES ('479', '鸡泽县', '43');
INSERT INTO `t_address` VALUES ('480', '广平县', '43');
INSERT INTO `t_address` VALUES ('481', '馆陶县', '43');
INSERT INTO `t_address` VALUES ('482', '魏 县', '43');
INSERT INTO `t_address` VALUES ('483', '曲周县', '43');
INSERT INTO `t_address` VALUES ('484', '武安市', '43');
INSERT INTO `t_address` VALUES ('485', '市辖区', '44');
INSERT INTO `t_address` VALUES ('486', '桥东区', '44');
INSERT INTO `t_address` VALUES ('487', '桥西区', '44');
INSERT INTO `t_address` VALUES ('488', '邢台县', '44');
INSERT INTO `t_address` VALUES ('489', '临城县', '44');
INSERT INTO `t_address` VALUES ('490', '内丘县', '44');
INSERT INTO `t_address` VALUES ('491', '柏乡县', '44');
INSERT INTO `t_address` VALUES ('492', '隆尧县', '44');
INSERT INTO `t_address` VALUES ('493', '任 县', '44');
INSERT INTO `t_address` VALUES ('494', '南和县', '44');
INSERT INTO `t_address` VALUES ('495', '宁晋县', '44');
INSERT INTO `t_address` VALUES ('496', '巨鹿县', '44');
INSERT INTO `t_address` VALUES ('497', '新河县', '44');
INSERT INTO `t_address` VALUES ('498', '广宗县', '44');
INSERT INTO `t_address` VALUES ('499', '平乡县', '44');
INSERT INTO `t_address` VALUES ('500', '威 县', '44');
INSERT INTO `t_address` VALUES ('501', '清河县', '44');
INSERT INTO `t_address` VALUES ('502', '临西县', '44');
INSERT INTO `t_address` VALUES ('503', '南宫市', '44');
INSERT INTO `t_address` VALUES ('504', '沙河市', '44');
INSERT INTO `t_address` VALUES ('505', '市辖区', '45');
INSERT INTO `t_address` VALUES ('506', '新市区', '45');
INSERT INTO `t_address` VALUES ('507', '北市区', '45');
INSERT INTO `t_address` VALUES ('508', '南市区', '45');
INSERT INTO `t_address` VALUES ('509', '满城县', '45');
INSERT INTO `t_address` VALUES ('510', '清苑县', '45');
INSERT INTO `t_address` VALUES ('511', '涞水县', '45');
INSERT INTO `t_address` VALUES ('512', '阜平县', '45');
INSERT INTO `t_address` VALUES ('513', '徐水县', '45');
INSERT INTO `t_address` VALUES ('514', '定兴县', '45');
INSERT INTO `t_address` VALUES ('515', '唐 县', '45');
INSERT INTO `t_address` VALUES ('516', '高阳县', '45');
INSERT INTO `t_address` VALUES ('517', '容城县', '45');
INSERT INTO `t_address` VALUES ('518', '涞源县', '45');
INSERT INTO `t_address` VALUES ('519', '望都县', '45');
INSERT INTO `t_address` VALUES ('520', '安新县', '45');
INSERT INTO `t_address` VALUES ('521', '易 县', '45');
INSERT INTO `t_address` VALUES ('522', '曲阳县', '45');
INSERT INTO `t_address` VALUES ('523', '蠡 县', '45');
INSERT INTO `t_address` VALUES ('524', '顺平县', '45');
INSERT INTO `t_address` VALUES ('525', '博野县', '45');
INSERT INTO `t_address` VALUES ('526', '雄 县', '45');
INSERT INTO `t_address` VALUES ('527', '涿州市', '45');
INSERT INTO `t_address` VALUES ('528', '定州市', '45');
INSERT INTO `t_address` VALUES ('529', '安国市', '45');
INSERT INTO `t_address` VALUES ('530', '高碑店市', '45');
INSERT INTO `t_address` VALUES ('531', '市辖区', '46');
INSERT INTO `t_address` VALUES ('532', '桥东区', '46');
INSERT INTO `t_address` VALUES ('533', '桥西区', '46');
INSERT INTO `t_address` VALUES ('534', '宣化区', '46');
INSERT INTO `t_address` VALUES ('535', '下花园区', '46');
INSERT INTO `t_address` VALUES ('536', '宣化县', '46');
INSERT INTO `t_address` VALUES ('537', '张北县', '46');
INSERT INTO `t_address` VALUES ('538', '康保县', '46');
INSERT INTO `t_address` VALUES ('539', '沽源县', '46');
INSERT INTO `t_address` VALUES ('540', '尚义县', '46');
INSERT INTO `t_address` VALUES ('541', '蔚 县', '46');
INSERT INTO `t_address` VALUES ('542', '阳原县', '46');
INSERT INTO `t_address` VALUES ('543', '怀安县', '46');
INSERT INTO `t_address` VALUES ('544', '万全县', '46');
INSERT INTO `t_address` VALUES ('545', '怀来县', '46');
INSERT INTO `t_address` VALUES ('546', '涿鹿县', '46');
INSERT INTO `t_address` VALUES ('547', '赤城县', '46');
INSERT INTO `t_address` VALUES ('548', '崇礼县', '46');
INSERT INTO `t_address` VALUES ('549', '市辖区', '47');
INSERT INTO `t_address` VALUES ('550', '双桥区', '47');
INSERT INTO `t_address` VALUES ('551', '双滦区', '47');
INSERT INTO `t_address` VALUES ('552', '鹰手营子矿区', '47');
INSERT INTO `t_address` VALUES ('553', '承德县', '47');
INSERT INTO `t_address` VALUES ('554', '兴隆县', '47');
INSERT INTO `t_address` VALUES ('555', '平泉县', '47');
INSERT INTO `t_address` VALUES ('556', '滦平县', '47');
INSERT INTO `t_address` VALUES ('557', '隆化县', '47');
INSERT INTO `t_address` VALUES ('558', '丰宁满族自治县', '47');
INSERT INTO `t_address` VALUES ('559', '宽城满族自治县', '47');
INSERT INTO `t_address` VALUES ('560', '围场满族蒙古族自治县', '47');
INSERT INTO `t_address` VALUES ('561', '市辖区', '48');
INSERT INTO `t_address` VALUES ('562', '新华区', '48');
INSERT INTO `t_address` VALUES ('563', '运河区', '48');
INSERT INTO `t_address` VALUES ('564', '沧 县', '48');
INSERT INTO `t_address` VALUES ('565', '青 县', '48');
INSERT INTO `t_address` VALUES ('566', '东光县', '48');
INSERT INTO `t_address` VALUES ('567', '海兴县', '48');
INSERT INTO `t_address` VALUES ('568', '盐山县', '48');
INSERT INTO `t_address` VALUES ('569', '肃宁县', '48');
INSERT INTO `t_address` VALUES ('570', '南皮县', '48');
INSERT INTO `t_address` VALUES ('571', '吴桥县', '48');
INSERT INTO `t_address` VALUES ('572', '献 县', '48');
INSERT INTO `t_address` VALUES ('573', '孟村回族自治县', '48');
INSERT INTO `t_address` VALUES ('574', '泊头市', '48');
INSERT INTO `t_address` VALUES ('575', '任丘市', '48');
INSERT INTO `t_address` VALUES ('576', '黄骅市', '48');
INSERT INTO `t_address` VALUES ('577', '河间市', '48');
INSERT INTO `t_address` VALUES ('578', '市辖区', '49');
INSERT INTO `t_address` VALUES ('579', '安次区', '49');
INSERT INTO `t_address` VALUES ('580', '广阳区', '49');
INSERT INTO `t_address` VALUES ('581', '固安县', '49');
INSERT INTO `t_address` VALUES ('582', '永清县', '49');
INSERT INTO `t_address` VALUES ('583', '香河县', '49');
INSERT INTO `t_address` VALUES ('584', '大城县', '49');
INSERT INTO `t_address` VALUES ('585', '文安县', '49');
INSERT INTO `t_address` VALUES ('586', '大厂回族自治县', '49');
INSERT INTO `t_address` VALUES ('587', '霸州市', '49');
INSERT INTO `t_address` VALUES ('588', '三河市', '49');
INSERT INTO `t_address` VALUES ('589', '市辖区', '50');
INSERT INTO `t_address` VALUES ('590', '桃城区', '50');
INSERT INTO `t_address` VALUES ('591', '枣强县', '50');
INSERT INTO `t_address` VALUES ('592', '武邑县', '50');
INSERT INTO `t_address` VALUES ('593', '武强县', '50');
INSERT INTO `t_address` VALUES ('594', '饶阳县', '50');
INSERT INTO `t_address` VALUES ('595', '安平县', '50');
INSERT INTO `t_address` VALUES ('596', '故城县', '50');
INSERT INTO `t_address` VALUES ('597', '景 县', '50');
INSERT INTO `t_address` VALUES ('598', '阜城县', '50');
INSERT INTO `t_address` VALUES ('599', '冀州市', '50');
INSERT INTO `t_address` VALUES ('600', '深州市', '50');
INSERT INTO `t_address` VALUES ('601', '市辖区', '51');
INSERT INTO `t_address` VALUES ('602', '小店区', '51');
INSERT INTO `t_address` VALUES ('603', '迎泽区', '51');
INSERT INTO `t_address` VALUES ('604', '杏花岭区', '51');
INSERT INTO `t_address` VALUES ('605', '尖草坪区', '51');
INSERT INTO `t_address` VALUES ('606', '万柏林区', '51');
INSERT INTO `t_address` VALUES ('607', '晋源区', '51');
INSERT INTO `t_address` VALUES ('608', '清徐县', '51');
INSERT INTO `t_address` VALUES ('609', '阳曲县', '51');
INSERT INTO `t_address` VALUES ('610', '娄烦县', '51');
INSERT INTO `t_address` VALUES ('611', '古交市', '51');
INSERT INTO `t_address` VALUES ('612', '市辖区', '52');
INSERT INTO `t_address` VALUES ('613', '城 区', '52');
INSERT INTO `t_address` VALUES ('614', '矿 区', '52');
INSERT INTO `t_address` VALUES ('615', '南郊区', '52');
INSERT INTO `t_address` VALUES ('616', '新荣区', '52');
INSERT INTO `t_address` VALUES ('617', '阳高县', '52');
INSERT INTO `t_address` VALUES ('618', '天镇县', '52');
INSERT INTO `t_address` VALUES ('619', '广灵县', '52');
INSERT INTO `t_address` VALUES ('620', '灵丘县', '52');
INSERT INTO `t_address` VALUES ('621', '浑源县', '52');
INSERT INTO `t_address` VALUES ('622', '左云县', '52');
INSERT INTO `t_address` VALUES ('623', '大同县', '52');
INSERT INTO `t_address` VALUES ('624', '市辖区', '53');
INSERT INTO `t_address` VALUES ('625', '城 区', '53');
INSERT INTO `t_address` VALUES ('626', '矿 区', '53');
INSERT INTO `t_address` VALUES ('627', '郊 区', '53');
INSERT INTO `t_address` VALUES ('628', '平定县', '53');
INSERT INTO `t_address` VALUES ('629', '盂 县', '53');
INSERT INTO `t_address` VALUES ('630', '市辖区', '54');
INSERT INTO `t_address` VALUES ('631', '城 区', '54');
INSERT INTO `t_address` VALUES ('632', '郊 区', '54');
INSERT INTO `t_address` VALUES ('633', '长治县', '54');
INSERT INTO `t_address` VALUES ('634', '襄垣县', '54');
INSERT INTO `t_address` VALUES ('635', '屯留县', '54');
INSERT INTO `t_address` VALUES ('636', '平顺县', '54');
INSERT INTO `t_address` VALUES ('637', '黎城县', '54');
INSERT INTO `t_address` VALUES ('638', '壶关县', '54');
INSERT INTO `t_address` VALUES ('639', '长子县', '54');
INSERT INTO `t_address` VALUES ('640', '武乡县', '54');
INSERT INTO `t_address` VALUES ('641', '沁 县', '54');
INSERT INTO `t_address` VALUES ('642', '沁源县', '54');
INSERT INTO `t_address` VALUES ('643', '潞城市', '54');
INSERT INTO `t_address` VALUES ('644', '市辖区', '55');
INSERT INTO `t_address` VALUES ('645', '城 区', '55');
INSERT INTO `t_address` VALUES ('646', '沁水县', '55');
INSERT INTO `t_address` VALUES ('647', '阳城县', '55');
INSERT INTO `t_address` VALUES ('648', '陵川县', '55');
INSERT INTO `t_address` VALUES ('649', '泽州县', '55');
INSERT INTO `t_address` VALUES ('650', '高平市', '55');
INSERT INTO `t_address` VALUES ('651', '市辖区', '56');
INSERT INTO `t_address` VALUES ('652', '朔城区', '56');
INSERT INTO `t_address` VALUES ('653', '平鲁区', '56');
INSERT INTO `t_address` VALUES ('654', '山阴县', '56');
INSERT INTO `t_address` VALUES ('655', '应 县', '56');
INSERT INTO `t_address` VALUES ('656', '右玉县', '56');
INSERT INTO `t_address` VALUES ('657', '怀仁县', '56');
INSERT INTO `t_address` VALUES ('658', '市辖区', '57');
INSERT INTO `t_address` VALUES ('659', '榆次区', '57');
INSERT INTO `t_address` VALUES ('660', '榆社县', '57');
INSERT INTO `t_address` VALUES ('661', '左权县', '57');
INSERT INTO `t_address` VALUES ('662', '和顺县', '57');
INSERT INTO `t_address` VALUES ('663', '昔阳县', '57');
INSERT INTO `t_address` VALUES ('664', '寿阳县', '57');
INSERT INTO `t_address` VALUES ('665', '太谷县', '57');
INSERT INTO `t_address` VALUES ('666', '祁 县', '57');
INSERT INTO `t_address` VALUES ('667', '平遥县', '57');
INSERT INTO `t_address` VALUES ('668', '灵石县', '57');
INSERT INTO `t_address` VALUES ('669', '介休市', '57');
INSERT INTO `t_address` VALUES ('670', '市辖区', '58');
INSERT INTO `t_address` VALUES ('671', '盐湖区', '58');
INSERT INTO `t_address` VALUES ('672', '临猗县', '58');
INSERT INTO `t_address` VALUES ('673', '万荣县', '58');
INSERT INTO `t_address` VALUES ('674', '闻喜县', '58');
INSERT INTO `t_address` VALUES ('675', '稷山县', '58');
INSERT INTO `t_address` VALUES ('676', '新绛县', '58');
INSERT INTO `t_address` VALUES ('677', '绛 县', '58');
INSERT INTO `t_address` VALUES ('678', '垣曲县', '58');
INSERT INTO `t_address` VALUES ('679', '夏 县', '58');
INSERT INTO `t_address` VALUES ('680', '平陆县', '58');
INSERT INTO `t_address` VALUES ('681', '芮城县', '58');
INSERT INTO `t_address` VALUES ('682', '永济市', '58');
INSERT INTO `t_address` VALUES ('683', '河津市', '58');
INSERT INTO `t_address` VALUES ('684', '市辖区', '59');
INSERT INTO `t_address` VALUES ('685', '忻府区', '59');
INSERT INTO `t_address` VALUES ('686', '定襄县', '59');
INSERT INTO `t_address` VALUES ('687', '五台县', '59');
INSERT INTO `t_address` VALUES ('688', '代 县', '59');
INSERT INTO `t_address` VALUES ('689', '繁峙县', '59');
INSERT INTO `t_address` VALUES ('690', '宁武县', '59');
INSERT INTO `t_address` VALUES ('691', '静乐县', '59');
INSERT INTO `t_address` VALUES ('692', '神池县', '59');
INSERT INTO `t_address` VALUES ('693', '五寨县', '59');
INSERT INTO `t_address` VALUES ('694', '岢岚县', '59');
INSERT INTO `t_address` VALUES ('695', '河曲县', '59');
INSERT INTO `t_address` VALUES ('696', '保德县', '59');
INSERT INTO `t_address` VALUES ('697', '偏关县', '59');
INSERT INTO `t_address` VALUES ('698', '原平市', '59');
INSERT INTO `t_address` VALUES ('699', '市辖区', '60');
INSERT INTO `t_address` VALUES ('700', '尧都区', '60');
INSERT INTO `t_address` VALUES ('701', '曲沃县', '60');
INSERT INTO `t_address` VALUES ('702', '翼城县', '60');
INSERT INTO `t_address` VALUES ('703', '襄汾县', '60');
INSERT INTO `t_address` VALUES ('704', '洪洞县', '60');
INSERT INTO `t_address` VALUES ('705', '古 县', '60');
INSERT INTO `t_address` VALUES ('706', '安泽县', '60');
INSERT INTO `t_address` VALUES ('707', '浮山县', '60');
INSERT INTO `t_address` VALUES ('708', '吉 县', '60');
INSERT INTO `t_address` VALUES ('709', '乡宁县', '60');
INSERT INTO `t_address` VALUES ('710', '大宁县', '60');
INSERT INTO `t_address` VALUES ('711', '隰 县', '60');
INSERT INTO `t_address` VALUES ('712', '永和县', '60');
INSERT INTO `t_address` VALUES ('713', '蒲 县', '60');
INSERT INTO `t_address` VALUES ('714', '汾西县', '60');
INSERT INTO `t_address` VALUES ('715', '侯马市', '60');
INSERT INTO `t_address` VALUES ('716', '霍州市', '60');
INSERT INTO `t_address` VALUES ('717', '市辖区', '61');
INSERT INTO `t_address` VALUES ('718', '离石区', '61');
INSERT INTO `t_address` VALUES ('719', '文水县', '61');
INSERT INTO `t_address` VALUES ('720', '交城县', '61');
INSERT INTO `t_address` VALUES ('721', '兴 县', '61');
INSERT INTO `t_address` VALUES ('722', '临 县', '61');
INSERT INTO `t_address` VALUES ('723', '柳林县', '61');
INSERT INTO `t_address` VALUES ('724', '石楼县', '61');
INSERT INTO `t_address` VALUES ('725', '岚 县', '61');
INSERT INTO `t_address` VALUES ('726', '方山县', '61');
INSERT INTO `t_address` VALUES ('727', '中阳县', '61');
INSERT INTO `t_address` VALUES ('728', '交口县', '61');
INSERT INTO `t_address` VALUES ('729', '孝义市', '61');
INSERT INTO `t_address` VALUES ('730', '汾阳市', '61');
INSERT INTO `t_address` VALUES ('731', '市辖区', '62');
INSERT INTO `t_address` VALUES ('732', '新城区', '62');
INSERT INTO `t_address` VALUES ('733', '回民区', '62');
INSERT INTO `t_address` VALUES ('734', '玉泉区', '62');
INSERT INTO `t_address` VALUES ('735', '赛罕区', '62');
INSERT INTO `t_address` VALUES ('736', '土默特左旗', '62');
INSERT INTO `t_address` VALUES ('737', '托克托县', '62');
INSERT INTO `t_address` VALUES ('738', '和林格尔县', '62');
INSERT INTO `t_address` VALUES ('739', '清水河县', '62');
INSERT INTO `t_address` VALUES ('740', '武川县', '62');
INSERT INTO `t_address` VALUES ('741', '市辖区', '63');
INSERT INTO `t_address` VALUES ('742', '东河区', '63');
INSERT INTO `t_address` VALUES ('743', '昆都仑区', '63');
INSERT INTO `t_address` VALUES ('744', '青山区', '63');
INSERT INTO `t_address` VALUES ('745', '石拐区', '63');
INSERT INTO `t_address` VALUES ('746', '白云矿区', '63');
INSERT INTO `t_address` VALUES ('747', '九原区', '63');
INSERT INTO `t_address` VALUES ('748', '土默特右旗', '63');
INSERT INTO `t_address` VALUES ('749', '固阳县', '63');
INSERT INTO `t_address` VALUES ('750', '达尔罕茂明安联合旗', '63');
INSERT INTO `t_address` VALUES ('751', '市辖区', '64');
INSERT INTO `t_address` VALUES ('752', '海勃湾区', '64');
INSERT INTO `t_address` VALUES ('753', '海南区', '64');
INSERT INTO `t_address` VALUES ('754', '乌达区', '64');
INSERT INTO `t_address` VALUES ('755', '市辖区', '65');
INSERT INTO `t_address` VALUES ('756', '红山区', '65');
INSERT INTO `t_address` VALUES ('757', '元宝山区', '65');
INSERT INTO `t_address` VALUES ('758', '松山区', '65');
INSERT INTO `t_address` VALUES ('759', '阿鲁科尔沁旗', '65');
INSERT INTO `t_address` VALUES ('760', '巴林左旗', '65');
INSERT INTO `t_address` VALUES ('761', '巴林右旗', '65');
INSERT INTO `t_address` VALUES ('762', '林西县', '65');
INSERT INTO `t_address` VALUES ('763', '克什克腾旗', '65');
INSERT INTO `t_address` VALUES ('764', '翁牛特旗', '65');
INSERT INTO `t_address` VALUES ('765', '喀喇沁旗', '65');
INSERT INTO `t_address` VALUES ('766', '宁城县', '65');
INSERT INTO `t_address` VALUES ('767', '敖汉旗', '65');
INSERT INTO `t_address` VALUES ('768', '市辖区', '66');
INSERT INTO `t_address` VALUES ('769', '科尔沁区', '66');
INSERT INTO `t_address` VALUES ('770', '科尔沁左翼中旗', '66');
INSERT INTO `t_address` VALUES ('771', '科尔沁左翼后旗', '66');
INSERT INTO `t_address` VALUES ('772', '开鲁县', '66');
INSERT INTO `t_address` VALUES ('773', '库伦旗', '66');
INSERT INTO `t_address` VALUES ('774', '奈曼旗', '66');
INSERT INTO `t_address` VALUES ('775', '扎鲁特旗', '66');
INSERT INTO `t_address` VALUES ('776', '霍林郭勒市', '66');
INSERT INTO `t_address` VALUES ('777', '东胜区', '67');
INSERT INTO `t_address` VALUES ('778', '达拉特旗', '67');
INSERT INTO `t_address` VALUES ('779', '准格尔旗', '67');
INSERT INTO `t_address` VALUES ('780', '鄂托克前旗', '67');
INSERT INTO `t_address` VALUES ('781', '鄂托克旗', '67');
INSERT INTO `t_address` VALUES ('782', '杭锦旗', '67');
INSERT INTO `t_address` VALUES ('783', '乌审旗', '67');
INSERT INTO `t_address` VALUES ('784', '伊金霍洛旗', '67');
INSERT INTO `t_address` VALUES ('785', '市辖区', '68');
INSERT INTO `t_address` VALUES ('786', '海拉尔区', '68');
INSERT INTO `t_address` VALUES ('787', '阿荣旗', '68');
INSERT INTO `t_address` VALUES ('788', '莫力达瓦达斡尔族自治旗', '68');
INSERT INTO `t_address` VALUES ('789', '鄂伦春自治旗', '68');
INSERT INTO `t_address` VALUES ('790', '鄂温克族自治旗', '68');
INSERT INTO `t_address` VALUES ('791', '陈巴尔虎旗', '68');
INSERT INTO `t_address` VALUES ('792', '新巴尔虎左旗', '68');
INSERT INTO `t_address` VALUES ('793', '新巴尔虎右旗', '68');
INSERT INTO `t_address` VALUES ('794', '满洲里市', '68');
INSERT INTO `t_address` VALUES ('795', '牙克石市', '68');
INSERT INTO `t_address` VALUES ('796', '扎兰屯市', '68');
INSERT INTO `t_address` VALUES ('797', '额尔古纳市', '68');
INSERT INTO `t_address` VALUES ('798', '根河市', '68');
INSERT INTO `t_address` VALUES ('799', '市辖区', '69');
INSERT INTO `t_address` VALUES ('800', '临河区', '69');
INSERT INTO `t_address` VALUES ('801', '五原县', '69');
INSERT INTO `t_address` VALUES ('802', '磴口县', '69');
INSERT INTO `t_address` VALUES ('803', '乌拉特前旗', '69');
INSERT INTO `t_address` VALUES ('804', '乌拉特中旗', '69');
INSERT INTO `t_address` VALUES ('805', '乌拉特后旗', '69');
INSERT INTO `t_address` VALUES ('806', '杭锦后旗', '69');
INSERT INTO `t_address` VALUES ('807', '市辖区', '70');
INSERT INTO `t_address` VALUES ('808', '集宁区', '70');
INSERT INTO `t_address` VALUES ('809', '卓资县', '70');
INSERT INTO `t_address` VALUES ('810', '化德县', '70');
INSERT INTO `t_address` VALUES ('811', '商都县', '70');
INSERT INTO `t_address` VALUES ('812', '兴和县', '70');
INSERT INTO `t_address` VALUES ('813', '凉城县', '70');
INSERT INTO `t_address` VALUES ('814', '察哈尔右翼前旗', '70');
INSERT INTO `t_address` VALUES ('815', '察哈尔右翼中旗', '70');
INSERT INTO `t_address` VALUES ('816', '察哈尔右翼后旗', '70');
INSERT INTO `t_address` VALUES ('817', '四子王旗', '70');
INSERT INTO `t_address` VALUES ('818', '丰镇市', '70');
INSERT INTO `t_address` VALUES ('819', '乌兰浩特市', '71');
INSERT INTO `t_address` VALUES ('820', '阿尔山市', '71');
INSERT INTO `t_address` VALUES ('821', '科尔沁右翼前旗', '71');
INSERT INTO `t_address` VALUES ('822', '科尔沁右翼中旗', '71');
INSERT INTO `t_address` VALUES ('823', '扎赉特旗', '71');
INSERT INTO `t_address` VALUES ('824', '突泉县', '71');
INSERT INTO `t_address` VALUES ('825', '二连浩特市', '72');
INSERT INTO `t_address` VALUES ('826', '锡林浩特市', '72');
INSERT INTO `t_address` VALUES ('827', '阿巴嘎旗', '72');
INSERT INTO `t_address` VALUES ('828', '苏尼特左旗', '72');
INSERT INTO `t_address` VALUES ('829', '苏尼特右旗', '72');
INSERT INTO `t_address` VALUES ('830', '东乌珠穆沁旗', '72');
INSERT INTO `t_address` VALUES ('831', '西乌珠穆沁旗', '72');
INSERT INTO `t_address` VALUES ('832', '太仆寺旗', '72');
INSERT INTO `t_address` VALUES ('833', '镶黄旗', '72');
INSERT INTO `t_address` VALUES ('834', '正镶白旗', '72');
INSERT INTO `t_address` VALUES ('835', '正蓝旗', '72');
INSERT INTO `t_address` VALUES ('836', '多伦县', '72');
INSERT INTO `t_address` VALUES ('837', '阿拉善左旗', '73');
INSERT INTO `t_address` VALUES ('838', '阿拉善右旗', '73');
INSERT INTO `t_address` VALUES ('839', '额济纳旗', '73');
INSERT INTO `t_address` VALUES ('840', '市辖区', '74');
INSERT INTO `t_address` VALUES ('841', '和平区', '74');
INSERT INTO `t_address` VALUES ('842', '沈河区', '74');
INSERT INTO `t_address` VALUES ('843', '大东区', '74');
INSERT INTO `t_address` VALUES ('844', '皇姑区', '74');
INSERT INTO `t_address` VALUES ('845', '铁西区', '74');
INSERT INTO `t_address` VALUES ('846', '苏家屯区', '74');
INSERT INTO `t_address` VALUES ('847', '东陵区', '74');
INSERT INTO `t_address` VALUES ('848', '新城子区', '74');
INSERT INTO `t_address` VALUES ('849', '于洪区', '74');
INSERT INTO `t_address` VALUES ('850', '辽中县', '74');
INSERT INTO `t_address` VALUES ('851', '康平县', '74');
INSERT INTO `t_address` VALUES ('852', '法库县', '74');
INSERT INTO `t_address` VALUES ('853', '新民市', '74');
INSERT INTO `t_address` VALUES ('854', '市辖区', '75');
INSERT INTO `t_address` VALUES ('855', '中山区', '75');
INSERT INTO `t_address` VALUES ('856', '西岗区', '75');
INSERT INTO `t_address` VALUES ('857', '沙河口区', '75');
INSERT INTO `t_address` VALUES ('858', '甘井子区', '75');
INSERT INTO `t_address` VALUES ('859', '旅顺口区', '75');
INSERT INTO `t_address` VALUES ('860', '金州区', '75');
INSERT INTO `t_address` VALUES ('861', '长海县', '75');
INSERT INTO `t_address` VALUES ('862', '瓦房店市', '75');
INSERT INTO `t_address` VALUES ('863', '普兰店市', '75');
INSERT INTO `t_address` VALUES ('864', '庄河市', '75');
INSERT INTO `t_address` VALUES ('865', '市辖区', '76');
INSERT INTO `t_address` VALUES ('866', '铁东区', '76');
INSERT INTO `t_address` VALUES ('867', '铁西区', '76');
INSERT INTO `t_address` VALUES ('868', '立山区', '76');
INSERT INTO `t_address` VALUES ('869', '千山区', '76');
INSERT INTO `t_address` VALUES ('870', '台安县', '76');
INSERT INTO `t_address` VALUES ('871', '岫岩满族自治县', '76');
INSERT INTO `t_address` VALUES ('872', '海城市', '76');
INSERT INTO `t_address` VALUES ('873', '市辖区', '77');
INSERT INTO `t_address` VALUES ('874', '新抚区', '77');
INSERT INTO `t_address` VALUES ('875', '东洲区', '77');
INSERT INTO `t_address` VALUES ('876', '望花区', '77');
INSERT INTO `t_address` VALUES ('877', '顺城区', '77');
INSERT INTO `t_address` VALUES ('878', '抚顺县', '77');
INSERT INTO `t_address` VALUES ('879', '新宾满族自治县', '77');
INSERT INTO `t_address` VALUES ('880', '清原满族自治县', '77');
INSERT INTO `t_address` VALUES ('881', '市辖区', '78');
INSERT INTO `t_address` VALUES ('882', '平山区', '78');
INSERT INTO `t_address` VALUES ('883', '溪湖区', '78');
INSERT INTO `t_address` VALUES ('884', '明山区', '78');
INSERT INTO `t_address` VALUES ('885', '南芬区', '78');
INSERT INTO `t_address` VALUES ('886', '本溪满族自治县', '78');
INSERT INTO `t_address` VALUES ('887', '桓仁满族自治县', '78');
INSERT INTO `t_address` VALUES ('888', '市辖区', '79');
INSERT INTO `t_address` VALUES ('889', '元宝区', '79');
INSERT INTO `t_address` VALUES ('890', '振兴区', '79');
INSERT INTO `t_address` VALUES ('891', '振安区', '79');
INSERT INTO `t_address` VALUES ('892', '宽甸满族自治县', '79');
INSERT INTO `t_address` VALUES ('893', '东港市', '79');
INSERT INTO `t_address` VALUES ('894', '凤城市', '79');
INSERT INTO `t_address` VALUES ('895', '市辖区', '80');
INSERT INTO `t_address` VALUES ('896', '古塔区', '80');
INSERT INTO `t_address` VALUES ('897', '凌河区', '80');
INSERT INTO `t_address` VALUES ('898', '太和区', '80');
INSERT INTO `t_address` VALUES ('899', '黑山县', '80');
INSERT INTO `t_address` VALUES ('900', '义 县', '80');
INSERT INTO `t_address` VALUES ('901', '凌海市', '80');
INSERT INTO `t_address` VALUES ('902', '北宁市', '80');
INSERT INTO `t_address` VALUES ('903', '市辖区', '81');
INSERT INTO `t_address` VALUES ('904', '站前区', '81');
INSERT INTO `t_address` VALUES ('905', '西市区', '81');
INSERT INTO `t_address` VALUES ('906', '鲅鱼圈区', '81');
INSERT INTO `t_address` VALUES ('907', '老边区', '81');
INSERT INTO `t_address` VALUES ('908', '盖州市', '81');
INSERT INTO `t_address` VALUES ('909', '大石桥市', '81');
INSERT INTO `t_address` VALUES ('910', '市辖区', '82');
INSERT INTO `t_address` VALUES ('911', '海州区', '82');
INSERT INTO `t_address` VALUES ('912', '新邱区', '82');
INSERT INTO `t_address` VALUES ('913', '太平区', '82');
INSERT INTO `t_address` VALUES ('914', '清河门区', '82');
INSERT INTO `t_address` VALUES ('915', '细河区', '82');
INSERT INTO `t_address` VALUES ('916', '阜新蒙古族自治县', '82');
INSERT INTO `t_address` VALUES ('917', '彰武县', '82');
INSERT INTO `t_address` VALUES ('918', '市辖区', '83');
INSERT INTO `t_address` VALUES ('919', '白塔区', '83');
INSERT INTO `t_address` VALUES ('920', '文圣区', '83');
INSERT INTO `t_address` VALUES ('921', '宏伟区', '83');
INSERT INTO `t_address` VALUES ('922', '弓长岭区', '83');
INSERT INTO `t_address` VALUES ('923', '太子河区', '83');
INSERT INTO `t_address` VALUES ('924', '辽阳县', '83');
INSERT INTO `t_address` VALUES ('925', '灯塔市', '83');
INSERT INTO `t_address` VALUES ('926', '市辖区', '84');
INSERT INTO `t_address` VALUES ('927', '双台子区', '84');
INSERT INTO `t_address` VALUES ('928', '兴隆台区', '84');
INSERT INTO `t_address` VALUES ('929', '大洼县', '84');
INSERT INTO `t_address` VALUES ('930', '盘山县', '84');
INSERT INTO `t_address` VALUES ('931', '市辖区', '85');
INSERT INTO `t_address` VALUES ('932', '银州区', '85');
INSERT INTO `t_address` VALUES ('933', '清河区', '85');
INSERT INTO `t_address` VALUES ('934', '铁岭县', '85');
INSERT INTO `t_address` VALUES ('935', '西丰县', '85');
INSERT INTO `t_address` VALUES ('936', '昌图县', '85');
INSERT INTO `t_address` VALUES ('937', '调兵山市', '85');
INSERT INTO `t_address` VALUES ('938', '开原市', '85');
INSERT INTO `t_address` VALUES ('939', '市辖区', '86');
INSERT INTO `t_address` VALUES ('940', '双塔区', '86');
INSERT INTO `t_address` VALUES ('941', '龙城区', '86');
INSERT INTO `t_address` VALUES ('942', '朝阳县', '86');
INSERT INTO `t_address` VALUES ('943', '建平县', '86');
INSERT INTO `t_address` VALUES ('944', '喀喇沁左翼蒙古族自治县', '86');
INSERT INTO `t_address` VALUES ('945', '北票市', '86');
INSERT INTO `t_address` VALUES ('946', '凌源市', '86');
INSERT INTO `t_address` VALUES ('947', '市辖区', '87');
INSERT INTO `t_address` VALUES ('948', '连山区', '87');
INSERT INTO `t_address` VALUES ('949', '龙港区', '87');
INSERT INTO `t_address` VALUES ('950', '南票区', '87');
INSERT INTO `t_address` VALUES ('951', '绥中县', '87');
INSERT INTO `t_address` VALUES ('952', '建昌县', '87');
INSERT INTO `t_address` VALUES ('953', '兴城市', '87');
INSERT INTO `t_address` VALUES ('954', '市辖区', '88');
INSERT INTO `t_address` VALUES ('955', '南关区', '88');
INSERT INTO `t_address` VALUES ('956', '宽城区', '88');
INSERT INTO `t_address` VALUES ('957', '朝阳区', '88');
INSERT INTO `t_address` VALUES ('958', '二道区', '88');
INSERT INTO `t_address` VALUES ('959', '绿园区', '88');
INSERT INTO `t_address` VALUES ('960', '双阳区', '88');
INSERT INTO `t_address` VALUES ('961', '农安县', '88');
INSERT INTO `t_address` VALUES ('962', '九台市', '88');
INSERT INTO `t_address` VALUES ('963', '榆树市', '88');
INSERT INTO `t_address` VALUES ('964', '德惠市', '88');
INSERT INTO `t_address` VALUES ('965', '市辖区', '89');
INSERT INTO `t_address` VALUES ('966', '昌邑区', '89');
INSERT INTO `t_address` VALUES ('967', '龙潭区', '89');
INSERT INTO `t_address` VALUES ('968', '船营区', '89');
INSERT INTO `t_address` VALUES ('969', '丰满区', '89');
INSERT INTO `t_address` VALUES ('970', '永吉县', '89');
INSERT INTO `t_address` VALUES ('971', '蛟河市', '89');
INSERT INTO `t_address` VALUES ('972', '桦甸市', '89');
INSERT INTO `t_address` VALUES ('973', '舒兰市', '89');
INSERT INTO `t_address` VALUES ('974', '磐石市', '89');
INSERT INTO `t_address` VALUES ('975', '市辖区', '90');
INSERT INTO `t_address` VALUES ('976', '铁西区', '90');
INSERT INTO `t_address` VALUES ('977', '铁东区', '90');
INSERT INTO `t_address` VALUES ('978', '梨树县', '90');
INSERT INTO `t_address` VALUES ('979', '伊通满族自治县', '90');
INSERT INTO `t_address` VALUES ('980', '公主岭市', '90');
INSERT INTO `t_address` VALUES ('981', '双辽市', '90');
INSERT INTO `t_address` VALUES ('982', '市辖区', '91');
INSERT INTO `t_address` VALUES ('983', '龙山区', '91');
INSERT INTO `t_address` VALUES ('984', '西安区', '91');
INSERT INTO `t_address` VALUES ('985', '东丰县', '91');
INSERT INTO `t_address` VALUES ('986', '东辽县', '91');
INSERT INTO `t_address` VALUES ('987', '市辖区', '92');
INSERT INTO `t_address` VALUES ('988', '东昌区', '92');
INSERT INTO `t_address` VALUES ('989', '二道江区', '92');
INSERT INTO `t_address` VALUES ('990', '通化县', '92');
INSERT INTO `t_address` VALUES ('991', '辉南县', '92');
INSERT INTO `t_address` VALUES ('992', '柳河县', '92');
INSERT INTO `t_address` VALUES ('993', '梅河口市', '92');
INSERT INTO `t_address` VALUES ('994', '集安市', '92');
INSERT INTO `t_address` VALUES ('995', '市辖区', '93');
INSERT INTO `t_address` VALUES ('996', '八道江区', '93');
INSERT INTO `t_address` VALUES ('997', '抚松县', '93');
INSERT INTO `t_address` VALUES ('998', '靖宇县', '93');
INSERT INTO `t_address` VALUES ('999', '长白朝鲜族自治县', '93');
INSERT INTO `t_address` VALUES ('1000', '江源县', '93');
INSERT INTO `t_address` VALUES ('1001', '临江市', '93');
INSERT INTO `t_address` VALUES ('1002', '市辖区', '94');
INSERT INTO `t_address` VALUES ('1003', '宁江区', '94');
INSERT INTO `t_address` VALUES ('1004', '前郭尔罗斯蒙古族自治县', '94');
INSERT INTO `t_address` VALUES ('1005', '长岭县', '94');
INSERT INTO `t_address` VALUES ('1006', '乾安县', '94');
INSERT INTO `t_address` VALUES ('1007', '扶余县', '94');
INSERT INTO `t_address` VALUES ('1008', '市辖区', '95');
INSERT INTO `t_address` VALUES ('1009', '洮北区', '95');
INSERT INTO `t_address` VALUES ('1010', '镇赉县', '95');
INSERT INTO `t_address` VALUES ('1011', '通榆县', '95');
INSERT INTO `t_address` VALUES ('1012', '洮南市', '95');
INSERT INTO `t_address` VALUES ('1013', '大安市', '95');
INSERT INTO `t_address` VALUES ('1014', '延吉市', '96');
INSERT INTO `t_address` VALUES ('1015', '图们市', '96');
INSERT INTO `t_address` VALUES ('1016', '敦化市', '96');
INSERT INTO `t_address` VALUES ('1017', '珲春市', '96');
INSERT INTO `t_address` VALUES ('1018', '龙井市', '96');
INSERT INTO `t_address` VALUES ('1019', '和龙市', '96');
INSERT INTO `t_address` VALUES ('1020', '汪清县', '96');
INSERT INTO `t_address` VALUES ('1021', '安图县', '96');
INSERT INTO `t_address` VALUES ('1022', '市辖区', '97');
INSERT INTO `t_address` VALUES ('1023', '道里区', '97');
INSERT INTO `t_address` VALUES ('1024', '南岗区', '97');
INSERT INTO `t_address` VALUES ('1025', '道外区', '97');
INSERT INTO `t_address` VALUES ('1026', '香坊区', '97');
INSERT INTO `t_address` VALUES ('1027', '动力区', '97');
INSERT INTO `t_address` VALUES ('1028', '平房区', '97');
INSERT INTO `t_address` VALUES ('1029', '松北区', '97');
INSERT INTO `t_address` VALUES ('1030', '呼兰区', '97');
INSERT INTO `t_address` VALUES ('1031', '依兰县', '97');
INSERT INTO `t_address` VALUES ('1032', '方正县', '97');
INSERT INTO `t_address` VALUES ('1033', '宾 县', '97');
INSERT INTO `t_address` VALUES ('1034', '巴彦县', '97');
INSERT INTO `t_address` VALUES ('1035', '木兰县', '97');
INSERT INTO `t_address` VALUES ('1036', '通河县', '97');
INSERT INTO `t_address` VALUES ('1037', '延寿县', '97');
INSERT INTO `t_address` VALUES ('1038', '阿城市', '97');
INSERT INTO `t_address` VALUES ('1039', '双城市', '97');
INSERT INTO `t_address` VALUES ('1040', '尚志市', '97');
INSERT INTO `t_address` VALUES ('1041', '五常市', '97');
INSERT INTO `t_address` VALUES ('1042', '市辖区', '98');
INSERT INTO `t_address` VALUES ('1043', '龙沙区', '98');
INSERT INTO `t_address` VALUES ('1044', '建华区', '98');
INSERT INTO `t_address` VALUES ('1045', '铁锋区', '98');
INSERT INTO `t_address` VALUES ('1046', '昂昂溪区', '98');
INSERT INTO `t_address` VALUES ('1047', '富拉尔基区', '98');
INSERT INTO `t_address` VALUES ('1048', '碾子山区', '98');
INSERT INTO `t_address` VALUES ('1049', '梅里斯达斡尔族区', '98');
INSERT INTO `t_address` VALUES ('1050', '龙江县', '98');
INSERT INTO `t_address` VALUES ('1051', '依安县', '98');
INSERT INTO `t_address` VALUES ('1052', '泰来县', '98');
INSERT INTO `t_address` VALUES ('1053', '甘南县', '98');
INSERT INTO `t_address` VALUES ('1054', '富裕县', '98');
INSERT INTO `t_address` VALUES ('1055', '克山县', '98');
INSERT INTO `t_address` VALUES ('1056', '克东县', '98');
INSERT INTO `t_address` VALUES ('1057', '拜泉县', '98');
INSERT INTO `t_address` VALUES ('1058', '讷河市', '98');
INSERT INTO `t_address` VALUES ('1059', '市辖区', '99');
INSERT INTO `t_address` VALUES ('1060', '鸡冠区', '99');
INSERT INTO `t_address` VALUES ('1061', '恒山区', '99');
INSERT INTO `t_address` VALUES ('1062', '滴道区', '99');
INSERT INTO `t_address` VALUES ('1063', '梨树区', '99');
INSERT INTO `t_address` VALUES ('1064', '城子河区', '99');
INSERT INTO `t_address` VALUES ('1065', '麻山区', '99');
INSERT INTO `t_address` VALUES ('1066', '鸡东县', '99');
INSERT INTO `t_address` VALUES ('1067', '虎林市', '99');
INSERT INTO `t_address` VALUES ('1068', '密山市', '99');
INSERT INTO `t_address` VALUES ('1069', '市辖区', '100');
INSERT INTO `t_address` VALUES ('1070', '向阳区', '100');
INSERT INTO `t_address` VALUES ('1071', '工农区', '100');
INSERT INTO `t_address` VALUES ('1072', '南山区', '100');
INSERT INTO `t_address` VALUES ('1073', '兴安区', '100');
INSERT INTO `t_address` VALUES ('1074', '东山区', '100');
INSERT INTO `t_address` VALUES ('1075', '兴山区', '100');
INSERT INTO `t_address` VALUES ('1076', '萝北县', '100');
INSERT INTO `t_address` VALUES ('1077', '绥滨县', '100');
INSERT INTO `t_address` VALUES ('1078', '市辖区', '101');
INSERT INTO `t_address` VALUES ('1079', '尖山区', '101');
INSERT INTO `t_address` VALUES ('1080', '岭东区', '101');
INSERT INTO `t_address` VALUES ('1081', '四方台区', '101');
INSERT INTO `t_address` VALUES ('1082', '宝山区', '101');
INSERT INTO `t_address` VALUES ('1083', '集贤县', '101');
INSERT INTO `t_address` VALUES ('1084', '友谊县', '101');
INSERT INTO `t_address` VALUES ('1085', '宝清县', '101');
INSERT INTO `t_address` VALUES ('1086', '饶河县', '101');
INSERT INTO `t_address` VALUES ('1087', '市辖区', '102');
INSERT INTO `t_address` VALUES ('1088', '萨尔图区', '102');
INSERT INTO `t_address` VALUES ('1089', '龙凤区', '102');
INSERT INTO `t_address` VALUES ('1090', '让胡路区', '102');
INSERT INTO `t_address` VALUES ('1091', '红岗区', '102');
INSERT INTO `t_address` VALUES ('1092', '大同区', '102');
INSERT INTO `t_address` VALUES ('1093', '肇州县', '102');
INSERT INTO `t_address` VALUES ('1094', '肇源县', '102');
INSERT INTO `t_address` VALUES ('1095', '林甸县', '102');
INSERT INTO `t_address` VALUES ('1096', '杜尔伯特蒙古族自治县', '102');
INSERT INTO `t_address` VALUES ('1097', '市辖区', '103');
INSERT INTO `t_address` VALUES ('1098', '伊春区', '103');
INSERT INTO `t_address` VALUES ('1099', '南岔区', '103');
INSERT INTO `t_address` VALUES ('1100', '友好区', '103');
INSERT INTO `t_address` VALUES ('1101', '西林区', '103');
INSERT INTO `t_address` VALUES ('1102', '翠峦区', '103');
INSERT INTO `t_address` VALUES ('1103', '新青区', '103');
INSERT INTO `t_address` VALUES ('1104', '美溪区', '103');
INSERT INTO `t_address` VALUES ('1105', '金山屯区', '103');
INSERT INTO `t_address` VALUES ('1106', '五营区', '103');
INSERT INTO `t_address` VALUES ('1107', '乌马河区', '103');
INSERT INTO `t_address` VALUES ('1108', '汤旺河区', '103');
INSERT INTO `t_address` VALUES ('1109', '带岭区', '103');
INSERT INTO `t_address` VALUES ('1110', '乌伊岭区', '103');
INSERT INTO `t_address` VALUES ('1111', '红星区', '103');
INSERT INTO `t_address` VALUES ('1112', '上甘岭区', '103');
INSERT INTO `t_address` VALUES ('1113', '嘉荫县', '103');
INSERT INTO `t_address` VALUES ('1114', '铁力市', '103');
INSERT INTO `t_address` VALUES ('1115', '市辖区', '104');
INSERT INTO `t_address` VALUES ('1116', '永红区', '104');
INSERT INTO `t_address` VALUES ('1117', '向阳区', '104');
INSERT INTO `t_address` VALUES ('1118', '前进区', '104');
INSERT INTO `t_address` VALUES ('1119', '东风区', '104');
INSERT INTO `t_address` VALUES ('1120', '郊 区', '104');
INSERT INTO `t_address` VALUES ('1121', '桦南县', '104');
INSERT INTO `t_address` VALUES ('1122', '桦川县', '104');
INSERT INTO `t_address` VALUES ('1123', '汤原县', '104');
INSERT INTO `t_address` VALUES ('1124', '抚远县', '104');
INSERT INTO `t_address` VALUES ('1125', '同江市', '104');
INSERT INTO `t_address` VALUES ('1126', '富锦市', '104');
INSERT INTO `t_address` VALUES ('1127', '市辖区', '105');
INSERT INTO `t_address` VALUES ('1128', '新兴区', '105');
INSERT INTO `t_address` VALUES ('1129', '桃山区', '105');
INSERT INTO `t_address` VALUES ('1130', '茄子河区', '105');
INSERT INTO `t_address` VALUES ('1131', '勃利县', '105');
INSERT INTO `t_address` VALUES ('1132', '市辖区', '106');
INSERT INTO `t_address` VALUES ('1133', '东安区', '106');
INSERT INTO `t_address` VALUES ('1134', '阳明区', '106');
INSERT INTO `t_address` VALUES ('1135', '爱民区', '106');
INSERT INTO `t_address` VALUES ('1136', '西安区', '106');
INSERT INTO `t_address` VALUES ('1137', '东宁县', '106');
INSERT INTO `t_address` VALUES ('1138', '林口县', '106');
INSERT INTO `t_address` VALUES ('1139', '绥芬河市', '106');
INSERT INTO `t_address` VALUES ('1140', '海林市', '106');
INSERT INTO `t_address` VALUES ('1141', '宁安市', '106');
INSERT INTO `t_address` VALUES ('1142', '穆棱市', '106');
INSERT INTO `t_address` VALUES ('1143', '市辖区', '107');
INSERT INTO `t_address` VALUES ('1144', '爱辉区', '107');
INSERT INTO `t_address` VALUES ('1145', '嫩江县', '107');
INSERT INTO `t_address` VALUES ('1146', '逊克县', '107');
INSERT INTO `t_address` VALUES ('1147', '孙吴县', '107');
INSERT INTO `t_address` VALUES ('1148', '北安市', '107');
INSERT INTO `t_address` VALUES ('1149', '五大连池市', '107');
INSERT INTO `t_address` VALUES ('1150', '市辖区', '108');
INSERT INTO `t_address` VALUES ('1151', '北林区', '108');
INSERT INTO `t_address` VALUES ('1152', '望奎县', '108');
INSERT INTO `t_address` VALUES ('1153', '兰西县', '108');
INSERT INTO `t_address` VALUES ('1154', '青冈县', '108');
INSERT INTO `t_address` VALUES ('1155', '庆安县', '108');
INSERT INTO `t_address` VALUES ('1156', '明水县', '108');
INSERT INTO `t_address` VALUES ('1157', '绥棱县', '108');
INSERT INTO `t_address` VALUES ('1158', '安达市', '108');
INSERT INTO `t_address` VALUES ('1159', '肇东市', '108');
INSERT INTO `t_address` VALUES ('1160', '海伦市', '108');
INSERT INTO `t_address` VALUES ('1161', '呼玛县', '109');
INSERT INTO `t_address` VALUES ('1162', '塔河县', '109');
INSERT INTO `t_address` VALUES ('1163', '漠河县', '109');
INSERT INTO `t_address` VALUES ('1164', '黄浦区', '110');
INSERT INTO `t_address` VALUES ('1165', '卢湾区', '110');
INSERT INTO `t_address` VALUES ('1166', '徐汇区', '110');
INSERT INTO `t_address` VALUES ('1167', '长宁区', '110');
INSERT INTO `t_address` VALUES ('1168', '静安区', '110');
INSERT INTO `t_address` VALUES ('1169', '普陀区', '110');
INSERT INTO `t_address` VALUES ('1170', '闸北区', '110');
INSERT INTO `t_address` VALUES ('1171', '虹口区', '110');
INSERT INTO `t_address` VALUES ('1172', '杨浦区', '110');
INSERT INTO `t_address` VALUES ('1173', '闵行区', '110');
INSERT INTO `t_address` VALUES ('1174', '宝山区', '110');
INSERT INTO `t_address` VALUES ('1175', '嘉定区', '110');
INSERT INTO `t_address` VALUES ('1176', '浦东新区', '110');
INSERT INTO `t_address` VALUES ('1177', '金山区', '110');
INSERT INTO `t_address` VALUES ('1178', '松江区', '110');
INSERT INTO `t_address` VALUES ('1179', '青浦区', '110');
INSERT INTO `t_address` VALUES ('1180', '南汇区', '110');
INSERT INTO `t_address` VALUES ('1181', '奉贤区', '110');
INSERT INTO `t_address` VALUES ('1182', '崇明县', '111');
INSERT INTO `t_address` VALUES ('1183', '市辖区', '112');
INSERT INTO `t_address` VALUES ('1184', '玄武区', '112');
INSERT INTO `t_address` VALUES ('1185', '白下区', '112');
INSERT INTO `t_address` VALUES ('1186', '秦淮区', '112');
INSERT INTO `t_address` VALUES ('1187', '建邺区', '112');
INSERT INTO `t_address` VALUES ('1188', '鼓楼区', '112');
INSERT INTO `t_address` VALUES ('1189', '下关区', '112');
INSERT INTO `t_address` VALUES ('1190', '浦口区', '112');
INSERT INTO `t_address` VALUES ('1191', '栖霞区', '112');
INSERT INTO `t_address` VALUES ('1192', '雨花台区', '112');
INSERT INTO `t_address` VALUES ('1193', '江宁区', '112');
INSERT INTO `t_address` VALUES ('1194', '六合区', '112');
INSERT INTO `t_address` VALUES ('1195', '溧水县', '112');
INSERT INTO `t_address` VALUES ('1196', '高淳县', '112');
INSERT INTO `t_address` VALUES ('1197', '市辖区', '113');
INSERT INTO `t_address` VALUES ('1198', '崇安区', '113');
INSERT INTO `t_address` VALUES ('1199', '南长区', '113');
INSERT INTO `t_address` VALUES ('1200', '北塘区', '113');
INSERT INTO `t_address` VALUES ('1201', '锡山区', '113');
INSERT INTO `t_address` VALUES ('1202', '惠山区', '113');
INSERT INTO `t_address` VALUES ('1203', '滨湖区', '113');
INSERT INTO `t_address` VALUES ('1204', '江阴市', '113');
INSERT INTO `t_address` VALUES ('1205', '宜兴市', '113');
INSERT INTO `t_address` VALUES ('1206', '市辖区', '114');
INSERT INTO `t_address` VALUES ('1207', '鼓楼区', '114');
INSERT INTO `t_address` VALUES ('1208', '云龙区', '114');
INSERT INTO `t_address` VALUES ('1209', '九里区', '114');
INSERT INTO `t_address` VALUES ('1210', '贾汪区', '114');
INSERT INTO `t_address` VALUES ('1211', '泉山区', '114');
INSERT INTO `t_address` VALUES ('1212', '丰 县', '114');
INSERT INTO `t_address` VALUES ('1213', '沛 县', '114');
INSERT INTO `t_address` VALUES ('1214', '铜山县', '114');
INSERT INTO `t_address` VALUES ('1215', '睢宁县', '114');
INSERT INTO `t_address` VALUES ('1216', '新沂市', '114');
INSERT INTO `t_address` VALUES ('1217', '邳州市', '114');
INSERT INTO `t_address` VALUES ('1218', '市辖区', '115');
INSERT INTO `t_address` VALUES ('1219', '天宁区', '115');
INSERT INTO `t_address` VALUES ('1220', '钟楼区', '115');
INSERT INTO `t_address` VALUES ('1221', '戚墅堰区', '115');
INSERT INTO `t_address` VALUES ('1222', '新北区', '115');
INSERT INTO `t_address` VALUES ('1223', '武进区', '115');
INSERT INTO `t_address` VALUES ('1224', '溧阳市', '115');
INSERT INTO `t_address` VALUES ('1225', '金坛市', '115');
INSERT INTO `t_address` VALUES ('1226', '市辖区', '116');
INSERT INTO `t_address` VALUES ('1227', '沧浪区', '116');
INSERT INTO `t_address` VALUES ('1228', '平江区', '116');
INSERT INTO `t_address` VALUES ('1229', '金阊区', '116');
INSERT INTO `t_address` VALUES ('1230', '虎丘区', '116');
INSERT INTO `t_address` VALUES ('1231', '吴中区', '116');
INSERT INTO `t_address` VALUES ('1232', '相城区', '116');
INSERT INTO `t_address` VALUES ('1233', '常熟市', '116');
INSERT INTO `t_address` VALUES ('1234', '张家港市', '116');
INSERT INTO `t_address` VALUES ('1235', '昆山市', '116');
INSERT INTO `t_address` VALUES ('1236', '吴江市', '116');
INSERT INTO `t_address` VALUES ('1237', '太仓市', '116');
INSERT INTO `t_address` VALUES ('1238', '市辖区', '117');
INSERT INTO `t_address` VALUES ('1239', '崇川区', '117');
INSERT INTO `t_address` VALUES ('1240', '港闸区', '117');
INSERT INTO `t_address` VALUES ('1241', '海安县', '117');
INSERT INTO `t_address` VALUES ('1242', '如东县', '117');
INSERT INTO `t_address` VALUES ('1243', '启东市', '117');
INSERT INTO `t_address` VALUES ('1244', '如皋市', '117');
INSERT INTO `t_address` VALUES ('1245', '通州市', '117');
INSERT INTO `t_address` VALUES ('1246', '海门市', '117');
INSERT INTO `t_address` VALUES ('1247', '市辖区', '118');
INSERT INTO `t_address` VALUES ('1248', '连云区', '118');
INSERT INTO `t_address` VALUES ('1249', '新浦区', '118');
INSERT INTO `t_address` VALUES ('1250', '海州区', '118');
INSERT INTO `t_address` VALUES ('1251', '赣榆县', '118');
INSERT INTO `t_address` VALUES ('1252', '东海县', '118');
INSERT INTO `t_address` VALUES ('1253', '灌云县', '118');
INSERT INTO `t_address` VALUES ('1254', '灌南县', '118');
INSERT INTO `t_address` VALUES ('1255', '市辖区', '119');
INSERT INTO `t_address` VALUES ('1256', '清河区', '119');
INSERT INTO `t_address` VALUES ('1257', '楚州区', '119');
INSERT INTO `t_address` VALUES ('1258', '淮阴区', '119');
INSERT INTO `t_address` VALUES ('1259', '清浦区', '119');
INSERT INTO `t_address` VALUES ('1260', '涟水县', '119');
INSERT INTO `t_address` VALUES ('1261', '洪泽县', '119');
INSERT INTO `t_address` VALUES ('1262', '盱眙县', '119');
INSERT INTO `t_address` VALUES ('1263', '金湖县', '119');
INSERT INTO `t_address` VALUES ('1264', '市辖区', '120');
INSERT INTO `t_address` VALUES ('1265', '亭湖区', '120');
INSERT INTO `t_address` VALUES ('1266', '盐都区', '120');
INSERT INTO `t_address` VALUES ('1267', '响水县', '120');
INSERT INTO `t_address` VALUES ('1268', '滨海县', '120');
INSERT INTO `t_address` VALUES ('1269', '阜宁县', '120');
INSERT INTO `t_address` VALUES ('1270', '射阳县', '120');
INSERT INTO `t_address` VALUES ('1271', '建湖县', '120');
INSERT INTO `t_address` VALUES ('1272', '东台市', '120');
INSERT INTO `t_address` VALUES ('1273', '大丰市', '120');
INSERT INTO `t_address` VALUES ('1274', '市辖区', '121');
INSERT INTO `t_address` VALUES ('1275', '广陵区', '121');
INSERT INTO `t_address` VALUES ('1276', '邗江区', '121');
INSERT INTO `t_address` VALUES ('1277', '郊 区', '121');
INSERT INTO `t_address` VALUES ('1278', '宝应县', '121');
INSERT INTO `t_address` VALUES ('1279', '仪征市', '121');
INSERT INTO `t_address` VALUES ('1280', '高邮市', '121');
INSERT INTO `t_address` VALUES ('1281', '江都市', '121');
INSERT INTO `t_address` VALUES ('1282', '市辖区', '122');
INSERT INTO `t_address` VALUES ('1283', '京口区', '122');
INSERT INTO `t_address` VALUES ('1284', '润州区', '122');
INSERT INTO `t_address` VALUES ('1285', '丹徒区', '122');
INSERT INTO `t_address` VALUES ('1286', '丹阳市', '122');
INSERT INTO `t_address` VALUES ('1287', '扬中市', '122');
INSERT INTO `t_address` VALUES ('1288', '句容市', '122');
INSERT INTO `t_address` VALUES ('1289', '市辖区', '123');
INSERT INTO `t_address` VALUES ('1290', '海陵区', '123');
INSERT INTO `t_address` VALUES ('1291', '高港区', '123');
INSERT INTO `t_address` VALUES ('1292', '兴化市', '123');
INSERT INTO `t_address` VALUES ('1293', '靖江市', '123');
INSERT INTO `t_address` VALUES ('1294', '泰兴市', '123');
INSERT INTO `t_address` VALUES ('1295', '姜堰市', '123');
INSERT INTO `t_address` VALUES ('1296', '市辖区', '124');
INSERT INTO `t_address` VALUES ('1297', '宿城区', '124');
INSERT INTO `t_address` VALUES ('1298', '宿豫区', '124');
INSERT INTO `t_address` VALUES ('1299', '沭阳县', '124');
INSERT INTO `t_address` VALUES ('1300', '泗阳县', '124');
INSERT INTO `t_address` VALUES ('1301', '泗洪县', '124');
INSERT INTO `t_address` VALUES ('1302', '市辖区', '125');
INSERT INTO `t_address` VALUES ('1303', '上城区', '125');
INSERT INTO `t_address` VALUES ('1304', '下城区', '125');
INSERT INTO `t_address` VALUES ('1305', '江干区', '125');
INSERT INTO `t_address` VALUES ('1306', '拱墅区', '125');
INSERT INTO `t_address` VALUES ('1307', '西湖区', '125');
INSERT INTO `t_address` VALUES ('1308', '滨江区', '125');
INSERT INTO `t_address` VALUES ('1309', '萧山区', '125');
INSERT INTO `t_address` VALUES ('1310', '余杭区', '125');
INSERT INTO `t_address` VALUES ('1311', '桐庐县', '125');
INSERT INTO `t_address` VALUES ('1312', '淳安县', '125');
INSERT INTO `t_address` VALUES ('1313', '建德市', '125');
INSERT INTO `t_address` VALUES ('1314', '富阳市', '125');
INSERT INTO `t_address` VALUES ('1315', '临安市', '125');
INSERT INTO `t_address` VALUES ('1316', '市辖区', '126');
INSERT INTO `t_address` VALUES ('1317', '海曙区', '126');
INSERT INTO `t_address` VALUES ('1318', '江东区', '126');
INSERT INTO `t_address` VALUES ('1319', '江北区', '126');
INSERT INTO `t_address` VALUES ('1320', '北仑区', '126');
INSERT INTO `t_address` VALUES ('1321', '镇海区', '126');
INSERT INTO `t_address` VALUES ('1322', '鄞州区', '126');
INSERT INTO `t_address` VALUES ('1323', '象山县', '126');
INSERT INTO `t_address` VALUES ('1324', '宁海县', '126');
INSERT INTO `t_address` VALUES ('1325', '余姚市', '126');
INSERT INTO `t_address` VALUES ('1326', '慈溪市', '126');
INSERT INTO `t_address` VALUES ('1327', '奉化市', '126');
INSERT INTO `t_address` VALUES ('1328', '市辖区', '127');
INSERT INTO `t_address` VALUES ('1329', '鹿城区', '127');
INSERT INTO `t_address` VALUES ('1330', '龙湾区', '127');
INSERT INTO `t_address` VALUES ('1331', '瓯海区', '127');
INSERT INTO `t_address` VALUES ('1332', '洞头县', '127');
INSERT INTO `t_address` VALUES ('1333', '永嘉县', '127');
INSERT INTO `t_address` VALUES ('1334', '平阳县', '127');
INSERT INTO `t_address` VALUES ('1335', '苍南县', '127');
INSERT INTO `t_address` VALUES ('1336', '文成县', '127');
INSERT INTO `t_address` VALUES ('1337', '泰顺县', '127');
INSERT INTO `t_address` VALUES ('1338', '瑞安市', '127');
INSERT INTO `t_address` VALUES ('1339', '乐清市', '127');
INSERT INTO `t_address` VALUES ('1340', '市辖区', '128');
INSERT INTO `t_address` VALUES ('1341', '秀城区', '128');
INSERT INTO `t_address` VALUES ('1342', '秀洲区', '128');
INSERT INTO `t_address` VALUES ('1343', '嘉善县', '128');
INSERT INTO `t_address` VALUES ('1344', '海盐县', '128');
INSERT INTO `t_address` VALUES ('1345', '海宁市', '128');
INSERT INTO `t_address` VALUES ('1346', '平湖市', '128');
INSERT INTO `t_address` VALUES ('1347', '桐乡市', '128');
INSERT INTO `t_address` VALUES ('1348', '市辖区', '129');
INSERT INTO `t_address` VALUES ('1349', '吴兴区', '129');
INSERT INTO `t_address` VALUES ('1350', '南浔区', '129');
INSERT INTO `t_address` VALUES ('1351', '德清县', '129');
INSERT INTO `t_address` VALUES ('1352', '长兴县', '129');
INSERT INTO `t_address` VALUES ('1353', '安吉县', '129');
INSERT INTO `t_address` VALUES ('1354', '市辖区', '130');
INSERT INTO `t_address` VALUES ('1355', '越城区', '130');
INSERT INTO `t_address` VALUES ('1356', '绍兴县', '130');
INSERT INTO `t_address` VALUES ('1357', '新昌县', '130');
INSERT INTO `t_address` VALUES ('1358', '诸暨市', '130');
INSERT INTO `t_address` VALUES ('1359', '上虞市', '130');
INSERT INTO `t_address` VALUES ('1360', '嵊州市', '130');
INSERT INTO `t_address` VALUES ('1361', '市辖区', '131');
INSERT INTO `t_address` VALUES ('1362', '婺城区', '131');
INSERT INTO `t_address` VALUES ('1363', '金东区', '131');
INSERT INTO `t_address` VALUES ('1364', '武义县', '131');
INSERT INTO `t_address` VALUES ('1365', '浦江县', '131');
INSERT INTO `t_address` VALUES ('1366', '磐安县', '131');
INSERT INTO `t_address` VALUES ('1367', '兰溪市', '131');
INSERT INTO `t_address` VALUES ('1368', '义乌市', '131');
INSERT INTO `t_address` VALUES ('1369', '东阳市', '131');
INSERT INTO `t_address` VALUES ('1370', '永康市', '131');
INSERT INTO `t_address` VALUES ('1371', '市辖区', '132');
INSERT INTO `t_address` VALUES ('1372', '柯城区', '132');
INSERT INTO `t_address` VALUES ('1373', '衢江区', '132');
INSERT INTO `t_address` VALUES ('1374', '常山县', '132');
INSERT INTO `t_address` VALUES ('1375', '开化县', '132');
INSERT INTO `t_address` VALUES ('1376', '龙游县', '132');
INSERT INTO `t_address` VALUES ('1377', '江山市', '132');
INSERT INTO `t_address` VALUES ('1378', '市辖区', '133');
INSERT INTO `t_address` VALUES ('1379', '定海区', '133');
INSERT INTO `t_address` VALUES ('1380', '普陀区', '133');
INSERT INTO `t_address` VALUES ('1381', '岱山县', '133');
INSERT INTO `t_address` VALUES ('1382', '嵊泗县', '133');
INSERT INTO `t_address` VALUES ('1383', '市辖区', '134');
INSERT INTO `t_address` VALUES ('1384', '椒江区', '134');
INSERT INTO `t_address` VALUES ('1385', '黄岩区', '134');
INSERT INTO `t_address` VALUES ('1386', '路桥区', '134');
INSERT INTO `t_address` VALUES ('1387', '玉环县', '134');
INSERT INTO `t_address` VALUES ('1388', '三门县', '134');
INSERT INTO `t_address` VALUES ('1389', '天台县', '134');
INSERT INTO `t_address` VALUES ('1390', '仙居县', '134');
INSERT INTO `t_address` VALUES ('1391', '温岭市', '134');
INSERT INTO `t_address` VALUES ('1392', '临海市', '134');
INSERT INTO `t_address` VALUES ('1393', '市辖区', '135');
INSERT INTO `t_address` VALUES ('1394', '莲都区', '135');
INSERT INTO `t_address` VALUES ('1395', '青田县', '135');
INSERT INTO `t_address` VALUES ('1396', '缙云县', '135');
INSERT INTO `t_address` VALUES ('1397', '遂昌县', '135');
INSERT INTO `t_address` VALUES ('1398', '松阳县', '135');
INSERT INTO `t_address` VALUES ('1399', '云和县', '135');
INSERT INTO `t_address` VALUES ('1400', '庆元县', '135');
INSERT INTO `t_address` VALUES ('1401', '景宁畲族自治县', '135');
INSERT INTO `t_address` VALUES ('1402', '龙泉市', '135');
INSERT INTO `t_address` VALUES ('1403', '市辖区', '136');
INSERT INTO `t_address` VALUES ('1404', '瑶海区', '136');
INSERT INTO `t_address` VALUES ('1405', '庐阳区', '136');
INSERT INTO `t_address` VALUES ('1406', '蜀山区', '136');
INSERT INTO `t_address` VALUES ('1407', '包河区', '136');
INSERT INTO `t_address` VALUES ('1408', '长丰县', '136');
INSERT INTO `t_address` VALUES ('1409', '肥东县', '136');
INSERT INTO `t_address` VALUES ('1410', '肥西县', '136');
INSERT INTO `t_address` VALUES ('1411', '市辖区', '137');
INSERT INTO `t_address` VALUES ('1412', '镜湖区', '137');
INSERT INTO `t_address` VALUES ('1413', '马塘区', '137');
INSERT INTO `t_address` VALUES ('1414', '新芜区', '137');
INSERT INTO `t_address` VALUES ('1415', '鸠江区', '137');
INSERT INTO `t_address` VALUES ('1416', '芜湖县', '137');
INSERT INTO `t_address` VALUES ('1417', '繁昌县', '137');
INSERT INTO `t_address` VALUES ('1418', '南陵县', '137');
INSERT INTO `t_address` VALUES ('1419', '市辖区', '138');
INSERT INTO `t_address` VALUES ('1420', '龙子湖区', '138');
INSERT INTO `t_address` VALUES ('1421', '蚌山区', '138');
INSERT INTO `t_address` VALUES ('1422', '禹会区', '138');
INSERT INTO `t_address` VALUES ('1423', '淮上区', '138');
INSERT INTO `t_address` VALUES ('1424', '怀远县', '138');
INSERT INTO `t_address` VALUES ('1425', '五河县', '138');
INSERT INTO `t_address` VALUES ('1426', '固镇县', '138');
INSERT INTO `t_address` VALUES ('1427', '市辖区', '139');
INSERT INTO `t_address` VALUES ('1428', '大通区', '139');
INSERT INTO `t_address` VALUES ('1429', '田家庵区', '139');
INSERT INTO `t_address` VALUES ('1430', '谢家集区', '139');
INSERT INTO `t_address` VALUES ('1431', '八公山区', '139');
INSERT INTO `t_address` VALUES ('1432', '潘集区', '139');
INSERT INTO `t_address` VALUES ('1433', '凤台县', '139');
INSERT INTO `t_address` VALUES ('1434', '市辖区', '140');
INSERT INTO `t_address` VALUES ('1435', '金家庄区', '140');
INSERT INTO `t_address` VALUES ('1436', '花山区', '140');
INSERT INTO `t_address` VALUES ('1437', '雨山区', '140');
INSERT INTO `t_address` VALUES ('1438', '当涂县', '140');
INSERT INTO `t_address` VALUES ('1439', '市辖区', '141');
INSERT INTO `t_address` VALUES ('1440', '杜集区', '141');
INSERT INTO `t_address` VALUES ('1441', '相山区', '141');
INSERT INTO `t_address` VALUES ('1442', '烈山区', '141');
INSERT INTO `t_address` VALUES ('1443', '濉溪县', '141');
INSERT INTO `t_address` VALUES ('1444', '市辖区', '142');
INSERT INTO `t_address` VALUES ('1445', '铜官山区', '142');
INSERT INTO `t_address` VALUES ('1446', '狮子山区', '142');
INSERT INTO `t_address` VALUES ('1447', '郊 区', '142');
INSERT INTO `t_address` VALUES ('1448', '铜陵县', '142');
INSERT INTO `t_address` VALUES ('1449', '市辖区', '143');
INSERT INTO `t_address` VALUES ('1450', '迎江区', '143');
INSERT INTO `t_address` VALUES ('1451', '大观区', '143');
INSERT INTO `t_address` VALUES ('1452', '郊 区', '143');
INSERT INTO `t_address` VALUES ('1453', '怀宁县', '143');
INSERT INTO `t_address` VALUES ('1454', '枞阳县', '143');
INSERT INTO `t_address` VALUES ('1455', '潜山县', '143');
INSERT INTO `t_address` VALUES ('1456', '太湖县', '143');
INSERT INTO `t_address` VALUES ('1457', '宿松县', '143');
INSERT INTO `t_address` VALUES ('1458', '望江县', '143');
INSERT INTO `t_address` VALUES ('1459', '岳西县', '143');
INSERT INTO `t_address` VALUES ('1460', '桐城市', '143');
INSERT INTO `t_address` VALUES ('1461', '市辖区', '144');
INSERT INTO `t_address` VALUES ('1462', '屯溪区', '144');
INSERT INTO `t_address` VALUES ('1463', '黄山区', '144');
INSERT INTO `t_address` VALUES ('1464', '徽州区', '144');
INSERT INTO `t_address` VALUES ('1465', '歙 县', '144');
INSERT INTO `t_address` VALUES ('1466', '休宁县', '144');
INSERT INTO `t_address` VALUES ('1467', '黟 县', '144');
INSERT INTO `t_address` VALUES ('1468', '祁门县', '144');
INSERT INTO `t_address` VALUES ('1469', '市辖区', '145');
INSERT INTO `t_address` VALUES ('1470', '琅琊区', '145');
INSERT INTO `t_address` VALUES ('1471', '南谯区', '145');
INSERT INTO `t_address` VALUES ('1472', '来安县', '145');
INSERT INTO `t_address` VALUES ('1473', '全椒县', '145');
INSERT INTO `t_address` VALUES ('1474', '定远县', '145');
INSERT INTO `t_address` VALUES ('1475', '凤阳县', '145');
INSERT INTO `t_address` VALUES ('1476', '天长市', '145');
INSERT INTO `t_address` VALUES ('1477', '明光市', '145');
INSERT INTO `t_address` VALUES ('1478', '市辖区', '146');
INSERT INTO `t_address` VALUES ('1479', '颍州区', '146');
INSERT INTO `t_address` VALUES ('1480', '颍东区', '146');
INSERT INTO `t_address` VALUES ('1481', '颍泉区', '146');
INSERT INTO `t_address` VALUES ('1482', '临泉县', '146');
INSERT INTO `t_address` VALUES ('1483', '太和县', '146');
INSERT INTO `t_address` VALUES ('1484', '阜南县', '146');
INSERT INTO `t_address` VALUES ('1485', '颍上县', '146');
INSERT INTO `t_address` VALUES ('1486', '界首市', '146');
INSERT INTO `t_address` VALUES ('1487', '市辖区', '147');
INSERT INTO `t_address` VALUES ('1488', '墉桥区', '147');
INSERT INTO `t_address` VALUES ('1489', '砀山县', '147');
INSERT INTO `t_address` VALUES ('1490', '萧 县', '147');
INSERT INTO `t_address` VALUES ('1491', '灵璧县', '147');
INSERT INTO `t_address` VALUES ('1492', '泗 县', '147');
INSERT INTO `t_address` VALUES ('1493', '市辖区', '148');
INSERT INTO `t_address` VALUES ('1494', '居巢区', '148');
INSERT INTO `t_address` VALUES ('1495', '庐江县', '148');
INSERT INTO `t_address` VALUES ('1496', '无为县', '148');
INSERT INTO `t_address` VALUES ('1497', '含山县', '148');
INSERT INTO `t_address` VALUES ('1498', '和 县', '148');
INSERT INTO `t_address` VALUES ('1499', '市辖区', '149');
INSERT INTO `t_address` VALUES ('1500', '金安区', '149');
INSERT INTO `t_address` VALUES ('1501', '裕安区', '149');
INSERT INTO `t_address` VALUES ('1502', '寿 县', '149');
INSERT INTO `t_address` VALUES ('1503', '霍邱县', '149');
INSERT INTO `t_address` VALUES ('1504', '舒城县', '149');
INSERT INTO `t_address` VALUES ('1505', '金寨县', '149');
INSERT INTO `t_address` VALUES ('1506', '霍山县', '149');
INSERT INTO `t_address` VALUES ('1507', '市辖区', '150');
INSERT INTO `t_address` VALUES ('1508', '谯城区', '150');
INSERT INTO `t_address` VALUES ('1509', '涡阳县', '150');
INSERT INTO `t_address` VALUES ('1510', '蒙城县', '150');
INSERT INTO `t_address` VALUES ('1511', '利辛县', '150');
INSERT INTO `t_address` VALUES ('1512', '市辖区', '151');
INSERT INTO `t_address` VALUES ('1513', '贵池区', '151');
INSERT INTO `t_address` VALUES ('1514', '东至县', '151');
INSERT INTO `t_address` VALUES ('1515', '石台县', '151');
INSERT INTO `t_address` VALUES ('1516', '青阳县', '151');
INSERT INTO `t_address` VALUES ('1517', '市辖区', '152');
INSERT INTO `t_address` VALUES ('1518', '宣州区', '152');
INSERT INTO `t_address` VALUES ('1519', '郎溪县', '152');
INSERT INTO `t_address` VALUES ('1520', '广德县', '152');
INSERT INTO `t_address` VALUES ('1521', '泾 县', '152');
INSERT INTO `t_address` VALUES ('1522', '绩溪县', '152');
INSERT INTO `t_address` VALUES ('1523', '旌德县', '152');
INSERT INTO `t_address` VALUES ('1524', '宁国市', '152');
INSERT INTO `t_address` VALUES ('1525', '市辖区', '153');
INSERT INTO `t_address` VALUES ('1526', '鼓楼区', '153');
INSERT INTO `t_address` VALUES ('1527', '台江区', '153');
INSERT INTO `t_address` VALUES ('1528', '仓山区', '153');
INSERT INTO `t_address` VALUES ('1529', '马尾区', '153');
INSERT INTO `t_address` VALUES ('1530', '晋安区', '153');
INSERT INTO `t_address` VALUES ('1531', '闽侯县', '153');
INSERT INTO `t_address` VALUES ('1532', '连江县', '153');
INSERT INTO `t_address` VALUES ('1533', '罗源县', '153');
INSERT INTO `t_address` VALUES ('1534', '闽清县', '153');
INSERT INTO `t_address` VALUES ('1535', '永泰县', '153');
INSERT INTO `t_address` VALUES ('1536', '平潭县', '153');
INSERT INTO `t_address` VALUES ('1537', '福清市', '153');
INSERT INTO `t_address` VALUES ('1538', '长乐市', '153');
INSERT INTO `t_address` VALUES ('1539', '市辖区', '154');
INSERT INTO `t_address` VALUES ('1540', '思明区', '154');
INSERT INTO `t_address` VALUES ('1541', '海沧区', '154');
INSERT INTO `t_address` VALUES ('1542', '湖里区', '154');
INSERT INTO `t_address` VALUES ('1543', '集美区', '154');
INSERT INTO `t_address` VALUES ('1544', '同安区', '154');
INSERT INTO `t_address` VALUES ('1545', '翔安区', '154');
INSERT INTO `t_address` VALUES ('1546', '市辖区', '155');
INSERT INTO `t_address` VALUES ('1547', '城厢区', '155');
INSERT INTO `t_address` VALUES ('1548', '涵江区', '155');
INSERT INTO `t_address` VALUES ('1549', '荔城区', '155');
INSERT INTO `t_address` VALUES ('1550', '秀屿区', '155');
INSERT INTO `t_address` VALUES ('1551', '仙游县', '155');
INSERT INTO `t_address` VALUES ('1552', '市辖区', '156');
INSERT INTO `t_address` VALUES ('1553', '梅列区', '156');
INSERT INTO `t_address` VALUES ('1554', '三元区', '156');
INSERT INTO `t_address` VALUES ('1555', '明溪县', '156');
INSERT INTO `t_address` VALUES ('1556', '清流县', '156');
INSERT INTO `t_address` VALUES ('1557', '宁化县', '156');
INSERT INTO `t_address` VALUES ('1558', '大田县', '156');
INSERT INTO `t_address` VALUES ('1559', '尤溪县', '156');
INSERT INTO `t_address` VALUES ('1560', '沙 县', '156');
INSERT INTO `t_address` VALUES ('1561', '将乐县', '156');
INSERT INTO `t_address` VALUES ('1562', '泰宁县', '156');
INSERT INTO `t_address` VALUES ('1563', '建宁县', '156');
INSERT INTO `t_address` VALUES ('1564', '永安市', '156');
INSERT INTO `t_address` VALUES ('1565', '市辖区', '157');
INSERT INTO `t_address` VALUES ('1566', '鲤城区', '157');
INSERT INTO `t_address` VALUES ('1567', '丰泽区', '157');
INSERT INTO `t_address` VALUES ('1568', '洛江区', '157');
INSERT INTO `t_address` VALUES ('1569', '泉港区', '157');
INSERT INTO `t_address` VALUES ('1570', '惠安县', '157');
INSERT INTO `t_address` VALUES ('1571', '安溪县', '157');
INSERT INTO `t_address` VALUES ('1572', '永春县', '157');
INSERT INTO `t_address` VALUES ('1573', '德化县', '157');
INSERT INTO `t_address` VALUES ('1574', '金门县', '157');
INSERT INTO `t_address` VALUES ('1575', '石狮市', '157');
INSERT INTO `t_address` VALUES ('1576', '晋江市', '157');
INSERT INTO `t_address` VALUES ('1577', '南安市', '157');
INSERT INTO `t_address` VALUES ('1578', '市辖区', '158');
INSERT INTO `t_address` VALUES ('1579', '芗城区', '158');
INSERT INTO `t_address` VALUES ('1580', '龙文区', '158');
INSERT INTO `t_address` VALUES ('1581', '云霄县', '158');
INSERT INTO `t_address` VALUES ('1582', '漳浦县', '158');
INSERT INTO `t_address` VALUES ('1583', '诏安县', '158');
INSERT INTO `t_address` VALUES ('1584', '长泰县', '158');
INSERT INTO `t_address` VALUES ('1585', '东山县', '158');
INSERT INTO `t_address` VALUES ('1586', '南靖县', '158');
INSERT INTO `t_address` VALUES ('1587', '平和县', '158');
INSERT INTO `t_address` VALUES ('1588', '华安县', '158');
INSERT INTO `t_address` VALUES ('1589', '龙海市', '158');
INSERT INTO `t_address` VALUES ('1590', '市辖区', '159');
INSERT INTO `t_address` VALUES ('1591', '延平区', '159');
INSERT INTO `t_address` VALUES ('1592', '顺昌县', '159');
INSERT INTO `t_address` VALUES ('1593', '浦城县', '159');
INSERT INTO `t_address` VALUES ('1594', '光泽县', '159');
INSERT INTO `t_address` VALUES ('1595', '松溪县', '159');
INSERT INTO `t_address` VALUES ('1596', '政和县', '159');
INSERT INTO `t_address` VALUES ('1597', '邵武市', '159');
INSERT INTO `t_address` VALUES ('1598', '武夷山市', '159');
INSERT INTO `t_address` VALUES ('1599', '建瓯市', '159');
INSERT INTO `t_address` VALUES ('1600', '建阳市', '159');
INSERT INTO `t_address` VALUES ('1601', '市辖区', '160');
INSERT INTO `t_address` VALUES ('1602', '新罗区', '160');
INSERT INTO `t_address` VALUES ('1603', '长汀县', '160');
INSERT INTO `t_address` VALUES ('1604', '永定县', '160');
INSERT INTO `t_address` VALUES ('1605', '上杭县', '160');
INSERT INTO `t_address` VALUES ('1606', '武平县', '160');
INSERT INTO `t_address` VALUES ('1607', '连城县', '160');
INSERT INTO `t_address` VALUES ('1608', '漳平市', '160');
INSERT INTO `t_address` VALUES ('1609', '市辖区', '161');
INSERT INTO `t_address` VALUES ('1610', '蕉城区', '161');
INSERT INTO `t_address` VALUES ('1611', '霞浦县', '161');
INSERT INTO `t_address` VALUES ('1612', '古田县', '161');
INSERT INTO `t_address` VALUES ('1613', '屏南县', '161');
INSERT INTO `t_address` VALUES ('1614', '寿宁县', '161');
INSERT INTO `t_address` VALUES ('1615', '周宁县', '161');
INSERT INTO `t_address` VALUES ('1616', '柘荣县', '161');
INSERT INTO `t_address` VALUES ('1617', '福安市', '161');
INSERT INTO `t_address` VALUES ('1618', '福鼎市', '161');
INSERT INTO `t_address` VALUES ('1619', '市辖区', '162');
INSERT INTO `t_address` VALUES ('1620', '东湖区', '162');
INSERT INTO `t_address` VALUES ('1621', '西湖区', '162');
INSERT INTO `t_address` VALUES ('1622', '青云谱区', '162');
INSERT INTO `t_address` VALUES ('1623', '湾里区', '162');
INSERT INTO `t_address` VALUES ('1624', '青山湖区', '162');
INSERT INTO `t_address` VALUES ('1625', '南昌县', '162');
INSERT INTO `t_address` VALUES ('1626', '新建县', '162');
INSERT INTO `t_address` VALUES ('1627', '安义县', '162');
INSERT INTO `t_address` VALUES ('1628', '进贤县', '162');
INSERT INTO `t_address` VALUES ('1629', '市辖区', '163');
INSERT INTO `t_address` VALUES ('1630', '昌江区', '163');
INSERT INTO `t_address` VALUES ('1631', '珠山区', '163');
INSERT INTO `t_address` VALUES ('1632', '浮梁县', '163');
INSERT INTO `t_address` VALUES ('1633', '乐平市', '163');
INSERT INTO `t_address` VALUES ('1634', '市辖区', '164');
INSERT INTO `t_address` VALUES ('1635', '安源区', '164');
INSERT INTO `t_address` VALUES ('1636', '湘东区', '164');
INSERT INTO `t_address` VALUES ('1637', '莲花县', '164');
INSERT INTO `t_address` VALUES ('1638', '上栗县', '164');
INSERT INTO `t_address` VALUES ('1639', '芦溪县', '164');
INSERT INTO `t_address` VALUES ('1640', '市辖区', '165');
INSERT INTO `t_address` VALUES ('1641', '庐山区', '165');
INSERT INTO `t_address` VALUES ('1642', '浔阳区', '165');
INSERT INTO `t_address` VALUES ('1643', '九江县', '165');
INSERT INTO `t_address` VALUES ('1644', '武宁县', '165');
INSERT INTO `t_address` VALUES ('1645', '修水县', '165');
INSERT INTO `t_address` VALUES ('1646', '永修县', '165');
INSERT INTO `t_address` VALUES ('1647', '德安县', '165');
INSERT INTO `t_address` VALUES ('1648', '星子县', '165');
INSERT INTO `t_address` VALUES ('1649', '都昌县', '165');
INSERT INTO `t_address` VALUES ('1650', '湖口县', '165');
INSERT INTO `t_address` VALUES ('1651', '彭泽县', '165');
INSERT INTO `t_address` VALUES ('1652', '瑞昌市', '165');
INSERT INTO `t_address` VALUES ('1653', '市辖区', '166');
INSERT INTO `t_address` VALUES ('1654', '渝水区', '166');
INSERT INTO `t_address` VALUES ('1655', '分宜县', '166');
INSERT INTO `t_address` VALUES ('1656', '市辖区', '167');
INSERT INTO `t_address` VALUES ('1657', '月湖区', '167');
INSERT INTO `t_address` VALUES ('1658', '余江县', '167');
INSERT INTO `t_address` VALUES ('1659', '贵溪市', '167');
INSERT INTO `t_address` VALUES ('1660', '市辖区', '168');
INSERT INTO `t_address` VALUES ('1661', '章贡区', '168');
INSERT INTO `t_address` VALUES ('1662', '赣 县', '168');
INSERT INTO `t_address` VALUES ('1663', '信丰县', '168');
INSERT INTO `t_address` VALUES ('1664', '大余县', '168');
INSERT INTO `t_address` VALUES ('1665', '上犹县', '168');
INSERT INTO `t_address` VALUES ('1666', '崇义县', '168');
INSERT INTO `t_address` VALUES ('1667', '安远县', '168');
INSERT INTO `t_address` VALUES ('1668', '龙南县', '168');
INSERT INTO `t_address` VALUES ('1669', '定南县', '168');
INSERT INTO `t_address` VALUES ('1670', '全南县', '168');
INSERT INTO `t_address` VALUES ('1671', '宁都县', '168');
INSERT INTO `t_address` VALUES ('1672', '于都县', '168');
INSERT INTO `t_address` VALUES ('1673', '兴国县', '168');
INSERT INTO `t_address` VALUES ('1674', '会昌县', '168');
INSERT INTO `t_address` VALUES ('1675', '寻乌县', '168');
INSERT INTO `t_address` VALUES ('1676', '石城县', '168');
INSERT INTO `t_address` VALUES ('1677', '瑞金市', '168');
INSERT INTO `t_address` VALUES ('1678', '南康市', '168');
INSERT INTO `t_address` VALUES ('1679', '市辖区', '169');
INSERT INTO `t_address` VALUES ('1680', '吉州区', '169');
INSERT INTO `t_address` VALUES ('1681', '青原区', '169');
INSERT INTO `t_address` VALUES ('1682', '吉安县', '169');
INSERT INTO `t_address` VALUES ('1683', '吉水县', '169');
INSERT INTO `t_address` VALUES ('1684', '峡江县', '169');
INSERT INTO `t_address` VALUES ('1685', '新干县', '169');
INSERT INTO `t_address` VALUES ('1686', '永丰县', '169');
INSERT INTO `t_address` VALUES ('1687', '泰和县', '169');
INSERT INTO `t_address` VALUES ('1688', '遂川县', '169');
INSERT INTO `t_address` VALUES ('1689', '万安县', '169');
INSERT INTO `t_address` VALUES ('1690', '安福县', '169');
INSERT INTO `t_address` VALUES ('1691', '永新县', '169');
INSERT INTO `t_address` VALUES ('1692', '井冈山市', '169');
INSERT INTO `t_address` VALUES ('1693', '市辖区', '170');
INSERT INTO `t_address` VALUES ('1694', '袁州区', '170');
INSERT INTO `t_address` VALUES ('1695', '奉新县', '170');
INSERT INTO `t_address` VALUES ('1696', '万载县', '170');
INSERT INTO `t_address` VALUES ('1697', '上高县', '170');
INSERT INTO `t_address` VALUES ('1698', '宜丰县', '170');
INSERT INTO `t_address` VALUES ('1699', '靖安县', '170');
INSERT INTO `t_address` VALUES ('1700', '铜鼓县', '170');
INSERT INTO `t_address` VALUES ('1701', '丰城市', '170');
INSERT INTO `t_address` VALUES ('1702', '樟树市', '170');
INSERT INTO `t_address` VALUES ('1703', '高安市', '170');
INSERT INTO `t_address` VALUES ('1704', '市辖区', '171');
INSERT INTO `t_address` VALUES ('1705', '临川区', '171');
INSERT INTO `t_address` VALUES ('1706', '南城县', '171');
INSERT INTO `t_address` VALUES ('1707', '黎川县', '171');
INSERT INTO `t_address` VALUES ('1708', '南丰县', '171');
INSERT INTO `t_address` VALUES ('1709', '崇仁县', '171');
INSERT INTO `t_address` VALUES ('1710', '乐安县', '171');
INSERT INTO `t_address` VALUES ('1711', '宜黄县', '171');
INSERT INTO `t_address` VALUES ('1712', '金溪县', '171');
INSERT INTO `t_address` VALUES ('1713', '资溪县', '171');
INSERT INTO `t_address` VALUES ('1714', '东乡县', '171');
INSERT INTO `t_address` VALUES ('1715', '广昌县', '171');
INSERT INTO `t_address` VALUES ('1716', '市辖区', '172');
INSERT INTO `t_address` VALUES ('1717', '信州区', '172');
INSERT INTO `t_address` VALUES ('1718', '上饶县', '172');
INSERT INTO `t_address` VALUES ('1719', '广丰县', '172');
INSERT INTO `t_address` VALUES ('1720', '玉山县', '172');
INSERT INTO `t_address` VALUES ('1721', '铅山县', '172');
INSERT INTO `t_address` VALUES ('1722', '横峰县', '172');
INSERT INTO `t_address` VALUES ('1723', '弋阳县', '172');
INSERT INTO `t_address` VALUES ('1724', '余干县', '172');
INSERT INTO `t_address` VALUES ('1725', '鄱阳县', '172');
INSERT INTO `t_address` VALUES ('1726', '万年县', '172');
INSERT INTO `t_address` VALUES ('1727', '婺源县', '172');
INSERT INTO `t_address` VALUES ('1728', '德兴市', '172');
INSERT INTO `t_address` VALUES ('1729', '市辖区', '173');
INSERT INTO `t_address` VALUES ('1730', '历下区', '173');
INSERT INTO `t_address` VALUES ('1731', '市中区', '173');
INSERT INTO `t_address` VALUES ('1732', '槐荫区', '173');
INSERT INTO `t_address` VALUES ('1733', '天桥区', '173');
INSERT INTO `t_address` VALUES ('1734', '历城区', '173');
INSERT INTO `t_address` VALUES ('1735', '长清区', '173');
INSERT INTO `t_address` VALUES ('1736', '平阴县', '173');
INSERT INTO `t_address` VALUES ('1737', '济阳县', '173');
INSERT INTO `t_address` VALUES ('1738', '商河县', '173');
INSERT INTO `t_address` VALUES ('1739', '章丘市', '173');
INSERT INTO `t_address` VALUES ('1740', '市辖区', '174');
INSERT INTO `t_address` VALUES ('1741', '市南区', '174');
INSERT INTO `t_address` VALUES ('1742', '市北区', '174');
INSERT INTO `t_address` VALUES ('1743', '四方区', '174');
INSERT INTO `t_address` VALUES ('1744', '黄岛区', '174');
INSERT INTO `t_address` VALUES ('1745', '崂山区', '174');
INSERT INTO `t_address` VALUES ('1746', '李沧区', '174');
INSERT INTO `t_address` VALUES ('1747', '城阳区', '174');
INSERT INTO `t_address` VALUES ('1748', '胶州市', '174');
INSERT INTO `t_address` VALUES ('1749', '即墨市', '174');
INSERT INTO `t_address` VALUES ('1750', '平度市', '174');
INSERT INTO `t_address` VALUES ('1751', '胶南市', '174');
INSERT INTO `t_address` VALUES ('1752', '莱西市', '174');
INSERT INTO `t_address` VALUES ('1753', '市辖区', '175');
INSERT INTO `t_address` VALUES ('1754', '淄川区', '175');
INSERT INTO `t_address` VALUES ('1755', '张店区', '175');
INSERT INTO `t_address` VALUES ('1756', '博山区', '175');
INSERT INTO `t_address` VALUES ('1757', '临淄区', '175');
INSERT INTO `t_address` VALUES ('1758', '周村区', '175');
INSERT INTO `t_address` VALUES ('1759', '桓台县', '175');
INSERT INTO `t_address` VALUES ('1760', '高青县', '175');
INSERT INTO `t_address` VALUES ('1761', '沂源县', '175');
INSERT INTO `t_address` VALUES ('1762', '市辖区', '176');
INSERT INTO `t_address` VALUES ('1763', '市中区', '176');
INSERT INTO `t_address` VALUES ('1764', '薛城区', '176');
INSERT INTO `t_address` VALUES ('1765', '峄城区', '176');
INSERT INTO `t_address` VALUES ('1766', '台儿庄区', '176');
INSERT INTO `t_address` VALUES ('1767', '山亭区', '176');
INSERT INTO `t_address` VALUES ('1768', '滕州市', '176');
INSERT INTO `t_address` VALUES ('1769', '市辖区', '177');
INSERT INTO `t_address` VALUES ('1770', '东营区', '177');
INSERT INTO `t_address` VALUES ('1771', '河口区', '177');
INSERT INTO `t_address` VALUES ('1772', '垦利县', '177');
INSERT INTO `t_address` VALUES ('1773', '利津县', '177');
INSERT INTO `t_address` VALUES ('1774', '广饶县', '177');
INSERT INTO `t_address` VALUES ('1775', '市辖区', '178');
INSERT INTO `t_address` VALUES ('1776', '芝罘区', '178');
INSERT INTO `t_address` VALUES ('1777', '福山区', '178');
INSERT INTO `t_address` VALUES ('1778', '牟平区', '178');
INSERT INTO `t_address` VALUES ('1779', '莱山区', '178');
INSERT INTO `t_address` VALUES ('1780', '长岛县', '178');
INSERT INTO `t_address` VALUES ('1781', '龙口市', '178');
INSERT INTO `t_address` VALUES ('1782', '莱阳市', '178');
INSERT INTO `t_address` VALUES ('1783', '莱州市', '178');
INSERT INTO `t_address` VALUES ('1784', '蓬莱市', '178');
INSERT INTO `t_address` VALUES ('1785', '招远市', '178');
INSERT INTO `t_address` VALUES ('1786', '栖霞市', '178');
INSERT INTO `t_address` VALUES ('1787', '海阳市', '178');
INSERT INTO `t_address` VALUES ('1788', '市辖区', '179');
INSERT INTO `t_address` VALUES ('1789', '潍城区', '179');
INSERT