当前位置:文档之家› 汽车车牌归属地MYSQL 【belonging】

汽车车牌归属地MYSQL 【belonging】

/*
Navicat MySQL Data Transfer
Source Host : 192.168.10.99:3306
Source Database : auto
Target Host : 192.168.10.99:3306
Target Database : auto
Date: 2012-03-28 11:29:15
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for auto_belonging
-- ----------------------------
DROP TABLE IF EXISTS `auto_belonging`;
CREATE TABLE `auto_belonging` (
`cityid` int(10) NOT NULL AUTO_INCREMENT,
`city` varchar(128) NOT NULL,
`citycode` char(64) NOT NULL,
`provinceid` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`cityid`)
) ENGINE=MyISAM AUTO_INCREMENT=426 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auto_belonging
-- ----------------------------
INSERT INTO `auto_belonging` VALUES ('1', '湖南省(湘)', '湘', '0');
INSERT INTO `auto_belonging` VALUES ('2', '长沙市', '湘A', '1');
INSERT INTO `auto_belonging` VALUES ('3', '株洲市', '湘B', '1');
INSERT INTO `auto_belonging` VALUES ('4', '湘潭市', '湘C', '1');
INSERT INTO `auto_belonging` VALUES ('5', '衡阳市', '湘D', '1');
INSERT INTO `auto_belonging` VALUES ('6', '邵阳市', '湘E', '1');
INSERT INTO `auto_belonging` VALUES ('7', '岳阳市', '湘F', '1');
INSERT INTO `auto_belonging` VALUES ('8', '张家界市', '湘G', '1');
INSERT INTO `auto_belonging` VALUES ('9', '益阳市', '湘H', '1');
INSERT INTO `auto_belonging` VALUES ('10', '常德市', '湘J', '1');
INSERT INTO `auto_belonging` VALUES ('11', '娄底市', '湘K', '1');
INSERT INTO `auto_belonging` VALUES ('12', '郴州市', '湘L', '1');
INSERT INTO `auto_belonging` VALUES ('13', '永州市', '湘M', '1');
INSERT INTO `auto_belonging` VALUES ('14', '怀化市', '湘N', '1');
INSERT INTO `auto_belonging` VALUES ('15', '湘西土家族苗族自治州', '湘U', '1');
INSERT INTO `auto_belonging` VALUES ('16', '湖北省(鄂)', '鄂', '0');
INSERT INTO `auto_belonging` VALUES ('17', '武汉市', '鄂A', '16');
INSERT INTO `auto_belonging` VALUES ('18', '黄石市', '鄂B', '16');
INSERT INTO `auto_belonging` VALUES ('19', '十堰市', '鄂C', '16');
INSERT INTO `auto_belonging` VALUES ('20', '荆州市', '鄂D', '16');
INSERT INTO `auto_belonging` VALUES ('21', '宜昌市', '鄂E', '16');
INSERT INTO `auto_belonging` VALUES ('22', '襄樊市', '鄂F', '16');
INSERT INTO `auto_belonging` VALUES ('23', '鄂州市', '鄂G', '16');
INSERT INTO `auto_belonging` VALUES ('24', '荆门市', '鄂H', '16');
INSERT INTO `auto_belonging` VALUES ('25', '黄冈市', '鄂J', '16');
INSERT INTO `auto_belonging` VALUES ('26', '孝感市', '鄂K', '16');
INSERT INTO `auto_belonging` VALUES ('27', '咸宁市', '鄂L', '16');
INSERT INTO `auto_belonging` VALUES ('28', '仙桃市', '鄂M', '16');
INSERT INTO `auto_belonging` VALUES ('29', '潜江市', '鄂N', '16');
INSERT INTO `auto_belonging` VALUES ('30', '神农架林区', '鄂P', '16');
INSERT INTO `auto_belonging` VALUES ('31', '恩施土家族苗族自治州', '鄂Q', '16');

INSERT INTO `auto_belonging` VALUES ('32', '天门市', '鄂R', '16');
INSERT INTO `auto_belonging` VALUES ('33', '随州市', '鄂S', '16');
INSERT INTO `auto_belonging` VALUES ('34', '河南省(豫)', '豫', '0');
INSERT INTO `auto_belonging` VALUES ('35', '郑州市', '豫A', '34');
INSERT INTO `auto_belonging` VALUES ('36', '开封市', '豫B', '34');
INSERT INTO `auto_belonging` VALUES ('37', '洛阳市', '豫C', '34');
INSERT INTO `auto_belonging` VALUES ('38', '平顶山市', '豫D', '34');
INSERT INTO `auto_belonging` VALUES ('39', '安阳市', '豫E', '34');
INSERT INTO `auto_belonging` VALUES ('40', '鹤壁市', '豫F', '34');
INSERT INTO `auto_belonging` VALUES ('41', '新乡市', '豫G', '34');
INSERT INTO `auto_belonging` VALUES ('42', '焦作市', '豫H', '34');
INSERT INTO `auto_belonging` VALUES ('43', '濮阳市', '豫J', '34');
INSERT INTO `auto_belonging` VALUES ('44', '许昌市', '豫K', '34');
INSERT INTO `auto_belonging` VALUES ('45', '漯河市', '豫L', '34');
INSERT INTO `auto_belonging` VALUES ('46', '三门峡市', '豫M', '34');
INSERT INTO `auto_belonging` VALUES ('47', '商丘市', '豫N', '34');
INSERT INTO `auto_belonging` VALUES ('48', '周口市', '豫P', '34');
INSERT INTO `auto_belonging` VALUES ('49', '驻马店市', '豫Q', '34');
INSERT INTO `auto_belonging` VALUES ('50', '南阳市', '豫R', '34');
INSERT INTO `auto_belonging` VALUES ('51', '信阳市', '豫S', '34');
INSERT INTO `auto_belonging` VALUES ('52', '济源市', '豫U', '34');
INSERT INTO `auto_belonging` VALUES ('53', '河北省(冀)', '冀', '0');
INSERT INTO `auto_belonging` VALUES ('54', '石家庄市', '冀A', '53');
INSERT INTO `auto_belonging` VALUES ('55', '唐山市', '冀B', '53');
INSERT INTO `auto_belonging` VALUES ('56', '秦皇岛市', '冀C', '53');
INSERT INTO `auto_belonging` VALUES ('57', '邯郸市', '冀D', '53');
INSERT INTO `auto_belonging` VALUES ('58', '邢台市', '冀E', '53');
INSERT INTO `auto_belonging` VALUES ('59', '保定市', '冀F', '53');
INSERT INTO `auto_belonging` VALUES ('60', '张家口市', '冀G', '53');
INSERT INTO `auto_belonging` VALUES ('61', '承德市', '冀H', '53');
INSERT INTO `auto_belonging` VALUES ('62', '沧州市', '冀J', '53');
INSERT INTO `auto_belonging` VALUES ('63', '廊坊市', '冀R', '53');
INSERT INTO `auto_belonging` VALUES ('64', '沧州市', '冀S', '53');
INSERT INTO `auto_belonging` VALUES ('65', '衡水市', '冀T', '53');
INSERT INTO `auto_belonging` VALUES ('66', '云南省(云)', '云', '0');
INSERT INTO `auto_belonging` VALUES ('67', '昆明市', '云A', '66');
INSERT INTO `auto_belonging` VALUES ('68', '东川市', '云A-V', '66');
INSERT INTO `auto_belonging` VALUES ('69', '昭通市', '云C', '66');
INSERT INTO `auto_belonging` VALUES ('70', '曲靖市', '云D', '66');
INSERT INTO `auto_belonging` VALUES ('71', '楚雄彝族自治州', '云E', '66');
INSERT INTO `auto_belonging` VALUES ('72', '玉溪市', '云F', '66');
INSERT

INTO `auto_belonging` VALUES ('73', '红河哈尼族彝族自治州', '云G', '66');
INSERT INTO `auto_belonging` VALUES ('74', '文山壮族苗族自治州', '云H', '66');
INSERT INTO `auto_belonging` VALUES ('75', '思茅市', '云J', '66');
INSERT INTO `auto_belonging` VALUES ('76', '西双版纳傣族自治州', '云K', '66');
INSERT INTO `auto_belonging` VALUES ('77', '大理白族自治州', '云L', '66');
INSERT INTO `auto_belonging` VALUES ('78', '保山市', '云M', '66');
INSERT INTO `auto_belonging` VALUES ('79', '德宏傣族景颇族自治州', '云N', '66');
INSERT INTO `auto_belonging` VALUES ('80', '丽江市', '云P', '66');
INSERT INTO `auto_belonging` VALUES ('81', '怒江傈僳族自治州', '云Q', '66');
INSERT INTO `auto_belonging` VALUES ('82', '迪庆藏族自治州', '云R', '66');
INSERT INTO `auto_belonging` VALUES ('83', '临沧地区', '云S', '66');
INSERT INTO `auto_belonging` VALUES ('84', '辽宁省(辽)', '辽', '0');
INSERT INTO `auto_belonging` VALUES ('85', '沈阳市', '辽A', '84');
INSERT INTO `auto_belonging` VALUES ('86', '大连市', '辽B', '84');
INSERT INTO `auto_belonging` VALUES ('87', '鞍山市', '辽C', '84');
INSERT INTO `auto_belonging` VALUES ('88', '抚顺市', '辽D', '84');
INSERT INTO `auto_belonging` VALUES ('89', '本溪市', '辽E', '84');
INSERT INTO `auto_belonging` VALUES ('90', '丹东市', '辽F', '84');
INSERT INTO `auto_belonging` VALUES ('91', '锦州市', '辽G', '84');
INSERT INTO `auto_belonging` VALUES ('92', '营口市', '辽H', '84');
INSERT INTO `auto_belonging` VALUES ('93', '阜新市', '辽J', '84');
INSERT INTO `auto_belonging` VALUES ('94', '辽阳市', '辽K', '84');
INSERT INTO `auto_belonging` VALUES ('95', '盘锦市', '辽L', '84');
INSERT INTO `auto_belonging` VALUES ('96', '铁岭市', '辽M', '84');
INSERT INTO `auto_belonging` VALUES ('97', '朝阳市', '辽N', '84');
INSERT INTO `auto_belonging` VALUES ('98', '葫芦岛市', '辽P', '84');
INSERT INTO `auto_belonging` VALUES ('99', '黑龙江省(黑)', '黑', '0');
INSERT INTO `auto_belonging` VALUES ('100', '哈尔滨市', '黑A', '99');
INSERT INTO `auto_belonging` VALUES ('101', '齐齐哈尔市', '黑B', '99');
INSERT INTO `auto_belonging` VALUES ('102', '牡丹江市', '黑C', '99');
INSERT INTO `auto_belonging` VALUES ('103', '佳木斯市', '黑D', '99');
INSERT INTO `auto_belonging` VALUES ('104', '大庆市', '黑E', '99');
INSERT INTO `auto_belonging` VALUES ('105', '伊春市', '黑F', '99');
INSERT INTO `auto_belonging` VALUES ('106', '鸡西市', '黑G', '99');
INSERT INTO `auto_belonging` VALUES ('107', '鹤岗市', '黑H', '99');
INSERT INTO `auto_belonging` VALUES ('108', '双鸭山市', '黑J', '99');
INSERT INTO `auto_belonging` VALUES ('109', '七台河市', '黑K', '99');
INSERT INTO `auto_belonging` VALUES ('110', '松花江地区(已并入哈尔滨市,车牌未改)', '黑L', '99');
INSERT INTO `auto_belonging` VALUES ('111', '绥化市', '黑M'

, '99');
INSERT INTO `auto_belonging` VALUES ('112', '黑河市', '黑N', '99');
INSERT INTO `auto_belonging` VALUES ('113', '大兴安岭地区', '黑P', '99');
INSERT INTO `auto_belonging` VALUES ('114', '农恳系统', '黑R', '99');
INSERT INTO `auto_belonging` VALUES ('115', '安徽省(皖)', '皖', '0');
INSERT INTO `auto_belonging` VALUES ('116', '合肥市', '皖A', '115');
INSERT INTO `auto_belonging` VALUES ('117', '芜湖市', '皖B', '115');
INSERT INTO `auto_belonging` VALUES ('118', '蚌埠市', '皖C', '115');
INSERT INTO `auto_belonging` VALUES ('119', '淮南市', '皖D', '115');
INSERT INTO `auto_belonging` VALUES ('120', '马鞍山市', '皖E', '115');
INSERT INTO `auto_belonging` VALUES ('121', '淮北市', '皖F', '115');
INSERT INTO `auto_belonging` VALUES ('122', '铜陵市', '皖G', '115');
INSERT INTO `auto_belonging` VALUES ('123', '安庆市', '皖H', '115');
INSERT INTO `auto_belonging` VALUES ('124', '黄山市', '皖J', '115');
INSERT INTO `auto_belonging` VALUES ('125', '阜阳市', '皖K', '115');
INSERT INTO `auto_belonging` VALUES ('126', '宿州市', '皖L', '115');
INSERT INTO `auto_belonging` VALUES ('127', '滁州市', '皖M', '115');
INSERT INTO `auto_belonging` VALUES ('128', '六安市', '皖N', '115');
INSERT INTO `auto_belonging` VALUES ('129', '宣城市', '皖P', '115');
INSERT INTO `auto_belonging` VALUES ('130', '巢湖市', '皖Q', '115');
INSERT INTO `auto_belonging` VALUES ('131', '池州市', '皖R', '115');
INSERT INTO `auto_belonging` VALUES ('132', '亳州市', '皖S', '115');
INSERT INTO `auto_belonging` VALUES ('133', '山东省(鲁)', '鲁', '0');
INSERT INTO `auto_belonging` VALUES ('134', '济南市', '鲁A', '133');
INSERT INTO `auto_belonging` VALUES ('135', '青岛市', '鲁B', '133');
INSERT INTO `auto_belonging` VALUES ('136', '淄博市', '鲁C', '133');
INSERT INTO `auto_belonging` VALUES ('137', '枣庄市', '鲁D', '133');
INSERT INTO `auto_belonging` VALUES ('138', '东营市', '鲁E', '133');
INSERT INTO `auto_belonging` VALUES ('139', '烟台市', '鲁F', '133');
INSERT INTO `auto_belonging` VALUES ('140', '潍坊市', '鲁G', '133');
INSERT INTO `auto_belonging` VALUES ('141', '济宁市', '鲁H', '133');
INSERT INTO `auto_belonging` VALUES ('142', '泰安市', '鲁J', '133');
INSERT INTO `auto_belonging` VALUES ('143', '威海市', '鲁K', '133');
INSERT INTO `auto_belonging` VALUES ('144', '日照市', '鲁L', '133');
INSERT INTO `auto_belonging` VALUES ('145', '滨州市', '鲁M', '133');
INSERT INTO `auto_belonging` VALUES ('146', '德州市', '鲁N', '133');
INSERT INTO `auto_belonging` VALUES ('147', '聊城市', '鲁P', '133');
INSERT INTO `auto_belonging` VALUES ('148', '临沂市', '鲁Q', '133');
INSERT INTO `auto_belonging` VALUES ('149', '菏泽市', '鲁R', '133');
INSERT INTO `auto_belonging` VALUES ('150', '莱芜市', '鲁S', '133');
INSERT INTO `auto_belonging` VALUES ('151', '青岛市', '鲁U', '133');
INSERT INTO `a

uto_belonging` VALUES ('152', '潍坊市', '鲁V', '133');
INSERT INTO `auto_belonging` VALUES ('153', '烟台市', '鲁Y', '133');
INSERT INTO `auto_belonging` VALUES ('154', '新疆维吾尔(新)', '新', '0');
INSERT INTO `auto_belonging` VALUES ('155', '乌鲁木齐市', '新A', '154');
INSERT INTO `auto_belonging` VALUES ('156', '昌吉回族自治州', '新B', '154');
INSERT INTO `auto_belonging` VALUES ('157', '石河子市', '新C', '154');
INSERT INTO `auto_belonging` VALUES ('158', '奎屯市', '新D', '154');
INSERT INTO `auto_belonging` VALUES ('159', '博尔塔拉蒙古自治州', '新E', '154');
INSERT INTO `auto_belonging` VALUES ('160', '伊犁哈萨克自治州直辖县', '新F', '154');
INSERT INTO `auto_belonging` VALUES ('161', '塔城市', '新G', '154');
INSERT INTO `auto_belonging` VALUES ('162', '阿勒泰市', '新H', '154');
INSERT INTO `auto_belonging` VALUES ('163', '克拉玛依市', '新J', '154');
INSERT INTO `auto_belonging` VALUES ('164', '吐鲁番市', '新K', '154');
INSERT INTO `auto_belonging` VALUES ('165', '哈密市', '新L', '154');
INSERT INTO `auto_belonging` VALUES ('166', '巴音郭愣蒙古自治州', '新M', '154');
INSERT INTO `auto_belonging` VALUES ('167', '阿克苏市', '新N', '154');
INSERT INTO `auto_belonging` VALUES ('168', '克孜勒苏柯尔克孜自治州', '新P', '154');
INSERT INTO `auto_belonging` VALUES ('169', '喀什市', '新Q', '154');
INSERT INTO `auto_belonging` VALUES ('170', '和田市', '新R', '154');
INSERT INTO `auto_belonging` VALUES ('171', '江苏省(苏)', '苏', '0');
INSERT INTO `auto_belonging` VALUES ('172', '南京市', '苏A', '171');
INSERT INTO `auto_belonging` VALUES ('173', '无锡市', '苏B', '171');
INSERT INTO `auto_belonging` VALUES ('174', '徐州市', '苏C', '171');
INSERT INTO `auto_belonging` VALUES ('175', '常州市', '苏D', '171');
INSERT INTO `auto_belonging` VALUES ('176', '苏州市', '苏E', '171');
INSERT INTO `auto_belonging` VALUES ('177', '南通市', '苏F', '171');
INSERT INTO `auto_belonging` VALUES ('178', '连云港市', '苏G', '171');
INSERT INTO `auto_belonging` VALUES ('179', '淮安市', '苏H', '171');
INSERT INTO `auto_belonging` VALUES ('180', '盐城市', '苏J', '171');
INSERT INTO `auto_belonging` VALUES ('181', '扬州市', '苏K', '171');
INSERT INTO `auto_belonging` VALUES ('182', '镇江市', '苏L', '171');
INSERT INTO `auto_belonging` VALUES ('183', '泰州市', '苏M', '171');
INSERT INTO `auto_belonging` VALUES ('184', '宿迁市', '苏N', '171');
INSERT INTO `auto_belonging` VALUES ('185', '浙江省(浙)', '浙', '0');
INSERT INTO `auto_belonging` VALUES ('186', '杭州市', '浙A', '185');
INSERT INTO `auto_belonging` VALUES ('187', '宁波市', '浙B', '185');
INSERT INTO `auto_belonging` VALUES ('188', '温州市', '浙C', '185');
INSERT INTO `auto_belonging` VALUES ('189', '绍兴市', '浙D', '185');
INSERT INTO `auto_belonging` VALUES ('190', '湖州市', '浙E', '1

85');
INSERT INTO `auto_belonging` VALUES ('191', '嘉兴市', '浙F', '185');
INSERT INTO `auto_belonging` VALUES ('192', '金华市', '浙G', '185');
INSERT INTO `auto_belonging` VALUES ('193', '衢州市', '浙H', '185');
INSERT INTO `auto_belonging` VALUES ('194', '台州市', '浙J', '185');
INSERT INTO `auto_belonging` VALUES ('195', '丽水市', '浙K', '185');
INSERT INTO `auto_belonging` VALUES ('196', '舟山市', '浙L', '185');
INSERT INTO `auto_belonging` VALUES ('197', '江西省(赣)', '赣', '0');
INSERT INTO `auto_belonging` VALUES ('198', '南昌市', '赣A', '197');
INSERT INTO `auto_belonging` VALUES ('199', '赣州市', '赣B', '197');
INSERT INTO `auto_belonging` VALUES ('200', '宜春市', '赣C', '197');
INSERT INTO `auto_belonging` VALUES ('201', '吉安市', '赣D', '197');
INSERT INTO `auto_belonging` VALUES ('202', '上饶市', '赣E', '197');
INSERT INTO `auto_belonging` VALUES ('203', '抚州市', '赣F', '197');
INSERT INTO `auto_belonging` VALUES ('204', '九江市', '赣G', '197');
INSERT INTO `auto_belonging` VALUES ('205', '景德镇市', '赣H', '197');
INSERT INTO `auto_belonging` VALUES ('206', '萍乡市', '赣J', '197');
INSERT INTO `auto_belonging` VALUES ('207', '新余市', '赣K', '197');
INSERT INTO `auto_belonging` VALUES ('208', '鹰潭市', '赣L', '197');
INSERT INTO `auto_belonging` VALUES ('209', '南昌市,省直系统', '赣M', '197');
INSERT INTO `auto_belonging` VALUES ('210', '广西壮族(桂)', '桂', '0');
INSERT INTO `auto_belonging` VALUES ('211', '南宁市', '桂A', '210');
INSERT INTO `auto_belonging` VALUES ('212', '柳州市', '桂B', '210');
INSERT INTO `auto_belonging` VALUES ('213', '桂林市', '桂C', '210');
INSERT INTO `auto_belonging` VALUES ('214', '梧州市', '桂D', '210');
INSERT INTO `auto_belonging` VALUES ('215', '北海市', '桂E', '210');
INSERT INTO `auto_belonging` VALUES ('216', '崇左市', '桂F', '210');
INSERT INTO `auto_belonging` VALUES ('217', '来宾市', '桂G', '210');
INSERT INTO `auto_belonging` VALUES ('218', '桂林地区', '桂H', '210');
INSERT INTO `auto_belonging` VALUES ('219', '贺州市', '桂J', '210');
INSERT INTO `auto_belonging` VALUES ('220', '玉林市', '桂K', '210');
INSERT INTO `auto_belonging` VALUES ('221', '百色市', '桂L', '210');
INSERT INTO `auto_belonging` VALUES ('222', '河池市', '桂M', '210');
INSERT INTO `auto_belonging` VALUES ('223', '钦州市', '桂N', '210');
INSERT INTO `auto_belonging` VALUES ('224', '防城港市', '桂P', '210');
INSERT INTO `auto_belonging` VALUES ('225', '贵港市', '桂R', '210');
INSERT INTO `auto_belonging` VALUES ('226', '广东省(粤)', '粤', '0');
INSERT INTO `auto_belonging` VALUES ('227', '广州市', '粤A', '226');
INSERT INTO `auto_belonging` VALUES ('228', '深圳市', '粤B', '226');
INSERT INTO `auto_belonging` VALUES ('229', '珠海市', '粤C', '226');
INSERT INTO `auto_belonging` VALUES ('230', '汕头市', '粤D', '226');
IN

SERT INTO `auto_belonging` VALUES ('231', '佛山市', '粤E', '226');
INSERT INTO `auto_belonging` VALUES ('232', '韶关市', '粤F', '226');
INSERT INTO `auto_belonging` VALUES ('233', '湛江市', '粤G', '226');
INSERT INTO `auto_belonging` VALUES ('234', '肇庆市', '粤H', '226');
INSERT INTO `auto_belonging` VALUES ('235', '江门市', '粤J', '226');
INSERT INTO `auto_belonging` VALUES ('236', '茂名市', '粤K', '226');
INSERT INTO `auto_belonging` VALUES ('237', '惠州市', '粤L', '226');
INSERT INTO `auto_belonging` VALUES ('238', '梅州市', '粤M', '226');
INSERT INTO `auto_belonging` VALUES ('239', '汕尾市', '粤N', '226');
INSERT INTO `auto_belonging` VALUES ('240', '河源市', '粤P', '226');
INSERT INTO `auto_belonging` VALUES ('241', '阳江市', '粤Q', '226');
INSERT INTO `auto_belonging` VALUES ('242', '清远市', '粤R', '226');
INSERT INTO `auto_belonging` VALUES ('243', '东莞市', '粤S', '226');
INSERT INTO `auto_belonging` VALUES ('244', '中山市', '粤T', '226');
INSERT INTO `auto_belonging` VALUES ('245', '潮州市', '粤U', '226');
INSERT INTO `auto_belonging` VALUES ('246', '揭阳市', '粤V', '226');
INSERT INTO `auto_belonging` VALUES ('247', '云浮市', '粤W', '226');
INSERT INTO `auto_belonging` VALUES ('248', '顺德区', '粤X', '226');
INSERT INTO `auto_belonging` VALUES ('249', '南海区', '粤Y', '226');
INSERT INTO `auto_belonging` VALUES ('250', '港澳进入内地车辆', '粤Z', '226');
INSERT INTO `auto_belonging` VALUES ('251', '甘肃省(甘)', '甘', '0');
INSERT INTO `auto_belonging` VALUES ('252', '兰州市', '甘A', '251');
INSERT INTO `auto_belonging` VALUES ('253', '嘉峪关市', '甘B', '251');
INSERT INTO `auto_belonging` VALUES ('254', '金昌市', '甘C', '251');
INSERT INTO `auto_belonging` VALUES ('255', '白银市', '甘D', '251');
INSERT INTO `auto_belonging` VALUES ('256', '天水市', '甘E', '251');
INSERT INTO `auto_belonging` VALUES ('257', '酒泉市', '甘F', '251');
INSERT INTO `auto_belonging` VALUES ('258', '张掖市', '甘G', '251');
INSERT INTO `auto_belonging` VALUES ('259', '武威市', '甘H', '251');
INSERT INTO `auto_belonging` VALUES ('260', '定西市', '甘J', '251');
INSERT INTO `auto_belonging` VALUES ('261', '陇南市', '甘K', '251');
INSERT INTO `auto_belonging` VALUES ('262', '平凉市', '甘L', '251');
INSERT INTO `auto_belonging` VALUES ('263', '庆阳市', '甘M', '251');
INSERT INTO `auto_belonging` VALUES ('264', '临夏回族自治州', '甘N', '251');
INSERT INTO `auto_belonging` VALUES ('265', '甘南藏族自治州', '甘P', '251');
INSERT INTO `auto_belonging` VALUES ('266', '山西省(晋)', '晋', '0');
INSERT INTO `auto_belonging` VALUES ('267', '太原市', '晋A', '266');
INSERT INTO `auto_belonging` VALUES ('268', '大同市', '晋B', '266');
INSERT INTO `auto_belonging` VALUES ('269', '阳泉市', '晋C', '266');
INSERT INTO `auto_belonging` VALUES ('270', '长治市', '晋D', '266'

);
INSERT INTO `auto_belonging` VALUES ('271', '晋城市', '晋E', '266');
INSERT INTO `auto_belonging` VALUES ('272', '朔州市', '晋F', '266');
INSERT INTO `auto_belonging` VALUES ('273', '忻州市', '晋H', '266');
INSERT INTO `auto_belonging` VALUES ('274', '吕梁地区', '晋J', '266');
INSERT INTO `auto_belonging` VALUES ('275', '晋中市', '晋K', '266');
INSERT INTO `auto_belonging` VALUES ('276', '临汾市', '晋L', '266');
INSERT INTO `auto_belonging` VALUES ('277', '运城市', '晋M', '266');
INSERT INTO `auto_belonging` VALUES ('278', '内蒙古(蒙)', '蒙', '0');
INSERT INTO `auto_belonging` VALUES ('279', '呼和浩特市', '蒙A', '278');
INSERT INTO `auto_belonging` VALUES ('280', '包头市', '蒙B', '278');
INSERT INTO `auto_belonging` VALUES ('281', '乌海市', '蒙C', '278');
INSERT INTO `auto_belonging` VALUES ('282', '赤峰市', '蒙D', '278');
INSERT INTO `auto_belonging` VALUES ('283', '呼伦贝尔市', '蒙E', '278');
INSERT INTO `auto_belonging` VALUES ('284', '兴安盟', '蒙F', '278');
INSERT INTO `auto_belonging` VALUES ('285', '通辽市', '蒙G', '278');
INSERT INTO `auto_belonging` VALUES ('286', '锡林郭勒盟', '蒙H', '278');
INSERT INTO `auto_belonging` VALUES ('287', '乌兰察布盟', '蒙J', '278');
INSERT INTO `auto_belonging` VALUES ('288', '鄂尔多斯市', '蒙K', '278');
INSERT INTO `auto_belonging` VALUES ('289', '巴彦淖尔盟', '蒙L', '278');
INSERT INTO `auto_belonging` VALUES ('290', '阿拉善盟', '蒙M', '278');
INSERT INTO `auto_belonging` VALUES ('291', '陕西省(陕)', '陕', '0');
INSERT INTO `auto_belonging` VALUES ('292', '西安市', '陕A', '291');
INSERT INTO `auto_belonging` VALUES ('293', '铜川市', '陕B', '291');
INSERT INTO `auto_belonging` VALUES ('294', '宝鸡市', '陕C', '291');
INSERT INTO `auto_belonging` VALUES ('295', '咸阳市', '陕D', '291');
INSERT INTO `auto_belonging` VALUES ('296', '渭南市', '陕E', '291');
INSERT INTO `auto_belonging` VALUES ('297', '汉中市', '陕F', '291');
INSERT INTO `auto_belonging` VALUES ('298', '安康市', '陕G', '291');
INSERT INTO `auto_belonging` VALUES ('299', '商洛市', '陕H', '291');
INSERT INTO `auto_belonging` VALUES ('300', '延安市', '陕J', '291');
INSERT INTO `auto_belonging` VALUES ('301', '榆林市', '陕K', '291');
INSERT INTO `auto_belonging` VALUES ('302', '杨凌高新农业示范区', '陕V', '291');
INSERT INTO `auto_belonging` VALUES ('303', '吉林省(吉)', '吉', '0');
INSERT INTO `auto_belonging` VALUES ('304', '长春市', '吉A', '303');
INSERT INTO `auto_belonging` VALUES ('305', '吉林市', '吉B', '303');
INSERT INTO `auto_belonging` VALUES ('306', '四平市', '吉C', '303');
INSERT INTO `auto_belonging` VALUES ('307', '辽源市', '吉D', '303');
INSERT INTO `auto_belonging` VALUES ('308', '通化市', '吉E', '303');
INSERT INTO `auto_belonging` VALUES ('309', '白山市', '吉F', '303');
INSERT INTO `auto_belonging` VALUES ('310',

'白城市', '吉G', '303');
INSERT INTO `auto_belonging` VALUES ('311', '延边朝鲜族自治州', '吉H', '303');
INSERT INTO `auto_belonging` VALUES ('312', '松原市', '吉J', '303');
INSERT INTO `auto_belonging` VALUES ('313', '长白山', '吉K', '303');
INSERT INTO `auto_belonging` VALUES ('314', '福建省(闽)', '闽', '0');
INSERT INTO `auto_belonging` VALUES ('315', '福州市', '闽A', '314');
INSERT INTO `auto_belonging` VALUES ('316', '莆田市', '闽B', '314');
INSERT INTO `auto_belonging` VALUES ('317', '泉州市', '闽C', '314');
INSERT INTO `auto_belonging` VALUES ('318', '厦门市', '闽D', '314');
INSERT INTO `auto_belonging` VALUES ('319', '漳州市', '闽E', '314');
INSERT INTO `auto_belonging` VALUES ('320', '龙岩市', '闽F', '314');
INSERT INTO `auto_belonging` VALUES ('321', '三明市', '闽G', '314');
INSERT INTO `auto_belonging` VALUES ('322', '南平市', '闽H', '314');
INSERT INTO `auto_belonging` VALUES ('323', '宁德市', '闽J', '314');
INSERT INTO `auto_belonging` VALUES ('324', '省直系统', '闽K', '314');
INSERT INTO `auto_belonging` VALUES ('325', '贵州省(贵)', '贵', '0');
INSERT INTO `auto_belonging` VALUES ('326', '贵阳市', '贵A', '325');
INSERT INTO `auto_belonging` VALUES ('327', '六盘水市', '贵B', '325');
INSERT INTO `auto_belonging` VALUES ('328', '遵义市', '贵C', '325');
INSERT INTO `auto_belonging` VALUES ('329', '铜仁市', '贵D', '325');
INSERT INTO `auto_belonging` VALUES ('330', '黔西南布依族苗族自治州', '贵E', '325');
INSERT INTO `auto_belonging` VALUES ('331', '毕节市', '贵F', '325');
INSERT INTO `auto_belonging` VALUES ('332', '安顺市', '贵G', '325');
INSERT INTO `auto_belonging` VALUES ('333', '黔东南苗族侗族自治州', '贵H', '325');
INSERT INTO `auto_belonging` VALUES ('334', '黔南布依族苗族自治州', '贵J', '325');
INSERT INTO `auto_belonging` VALUES ('335', '四川省(川)', '川', '0');
INSERT INTO `auto_belonging` VALUES ('336', '成都市', '川A', '335');
INSERT INTO `auto_belonging` VALUES ('337', '绵阳市', '川B', '335');
INSERT INTO `auto_belonging` VALUES ('338', '自贡市', '川C', '335');
INSERT INTO `auto_belonging` VALUES ('339', '攀枝花市', '川D', '335');
INSERT INTO `auto_belonging` VALUES ('340', '泸州市', '川E', '335');
INSERT INTO `auto_belonging` VALUES ('341', '德阳市', '川F', '335');
INSERT INTO `auto_belonging` VALUES ('342', '广元市', '川H', '335');
INSERT INTO `auto_belonging` VALUES ('343', '遂宁市', '川J', '335');
INSERT INTO `auto_belonging` VALUES ('344', '内江市', '川K', '335');
INSERT INTO `auto_belonging` VALUES ('345', '乐山市', '川L', '335');
INSERT INTO `auto_belonging` VALUES ('346', '资阳市', '川M', '335');
INSERT INTO `auto_belonging` VALUES ('347', '', '川N', '335');
INSERT INTO `auto_belonging` VALUES ('348', '', '川P', '335');
INSERT INTO `auto_belonging` VALUES ('349', '宜宾市', '川Q', '335');
INSERT

INTO `auto_belonging` VALUES ('350', '南充市', '川R', '335');
INSERT INTO `auto_belonging` VALUES ('351', '达州市', '川S', '335');
INSERT INTO `auto_belonging` VALUES ('352', '雅安市', '川T', '335');
INSERT INTO `auto_belonging` VALUES ('353', '阿坝藏族羌族自治州', '川U', '335');
INSERT INTO `auto_belonging` VALUES ('354', '甘孜藏族自治州', '川V', '335');
INSERT INTO `auto_belonging` VALUES ('355', '凉山彝族自治州', '川W', '335');
INSERT INTO `auto_belonging` VALUES ('356', '广安市', '川X', '335');
INSERT INTO `auto_belonging` VALUES ('357', '巴中市', '川Y', '335');
INSERT INTO `auto_belonging` VALUES ('358', '眉山市', '川Z', '335');
INSERT INTO `auto_belonging` VALUES ('359', '青海省(青)', '青', '0');
INSERT INTO `auto_belonging` VALUES ('360', '西宁市', '青A', '359');
INSERT INTO `auto_belonging` VALUES ('361', '海东市', '青B', '359');
INSERT INTO `auto_belonging` VALUES ('362', '海北藏族自治州', '青C', '359');
INSERT INTO `auto_belonging` VALUES ('363', '黄南藏族自治州', '青D', '359');
INSERT INTO `auto_belonging` VALUES ('364', '海南藏族自治州', '青E', '359');
INSERT INTO `auto_belonging` VALUES ('365', '果洛藏族自治州', '青F', '359');
INSERT INTO `auto_belonging` VALUES ('366', '玉树藏族自治州', '青G', '359');
INSERT INTO `auto_belonging` VALUES ('367', '海西蒙古族藏族自治州', '青H', '359');
INSERT INTO `auto_belonging` VALUES ('368', '西藏(藏)', '藏', '0');
INSERT INTO `auto_belonging` VALUES ('369', '拉萨市', '藏A', '368');
INSERT INTO `auto_belonging` VALUES ('370', '昌都地区', '藏B', '368');
INSERT INTO `auto_belonging` VALUES ('371', '山南地区', '藏C', '368');
INSERT INTO `auto_belonging` VALUES ('372', '日喀则地区', '藏D', '368');
INSERT INTO `auto_belonging` VALUES ('373', '那曲地区', '藏E', '368');
INSERT INTO `auto_belonging` VALUES ('374', '阿里地区', '藏F', '368');
INSERT INTO `auto_belonging` VALUES ('375', '林芝地区', '藏G', '368');
INSERT INTO `auto_belonging` VALUES ('376', '驻四川省天全县车辆管理所', '藏H', '368');
INSERT INTO `auto_belonging` VALUES ('377', '驻青海省格尔木市车辆管理所', '藏J', '368');
INSERT INTO `auto_belonging` VALUES ('378', '海南省(琼)', '琼', '0');
INSERT INTO `auto_belonging` VALUES ('379', '海口市', '琼A', '378');
INSERT INTO `auto_belonging` VALUES ('380', '三亚市', '琼B', '378');
INSERT INTO `auto_belonging` VALUES ('381', '琼海市', '琼C', '378');
INSERT INTO `auto_belonging` VALUES ('382', '五指山市', '琼D', '378');
INSERT INTO `auto_belonging` VALUES ('383', '洋浦开发区', '琼E', '378');
INSERT INTO `auto_belonging` VALUES ('384', '宁夏回族(宁)', '宁', '0');
INSERT INTO `auto_belonging` VALUES ('385', '银川市', '宁A', '384');
INSERT INTO `auto_belonging` VALUES ('386', '石嘴山市', '宁B', '384');
INSERT INTO `auto_belonging` VALUES ('387', '

银南市', '宁C', '384');
INSERT INTO `auto_belonging` VALUES ('388', '固原市', '宁D', '384');
INSERT INTO `auto_belonging` VALUES ('389', '中卫市', '宁E', '384');
INSERT INTO `auto_belonging` VALUES ('390', '重庆市(渝)', '渝', '0');
INSERT INTO `auto_belonging` VALUES ('391', '重庆市区(江南)', '渝A', '390');
INSERT INTO `auto_belonging` VALUES ('392', '重庆市区(江北)', '渝B', '390');
INSERT INTO `auto_belonging` VALUES ('393', '永川区', '渝C', '390');
INSERT INTO `auto_belonging` VALUES ('394', '万州区', '渝F', '390');
INSERT INTO `auto_belonging` VALUES ('395', '涪陵区', '渝G', '390');
INSERT INTO `auto_belonging` VALUES ('396', '黔江区', '渝H', '390');
INSERT INTO `auto_belonging` VALUES ('397', '北京市(京)', '京', '0');
INSERT INTO `auto_belonging` VALUES ('398', '北京市', '京A', '397');
INSERT INTO `auto_belonging` VALUES ('399', '北京市', '京B', '397');
INSERT INTO `auto_belonging` VALUES ('400', '北京市', '京C', '397');
INSERT INTO `auto_belonging` VALUES ('401', '北京市', '京D', '397');
INSERT INTO `auto_belonging` VALUES ('402', '北京市', '京E', '397');
INSERT INTO `auto_belonging` VALUES ('403', '北京市', '京F', '397');
INSERT INTO `auto_belonging` VALUES ('404', '北京市', '京G', '397');
INSERT INTO `auto_belonging` VALUES ('405', '北京市', '京H', '397');
INSERT INTO `auto_belonging` VALUES ('406', '北京市', '京J', '397');
INSERT INTO `auto_belonging` VALUES ('407', '北京市', '京K', '397');
INSERT INTO `auto_belonging` VALUES ('408', '北京市', '京L', '397');
INSERT INTO `auto_belonging` VALUES ('409', '北京市', '京M', '397');
INSERT INTO `auto_belonging` VALUES ('410', '北京市', '京Y', '397');
INSERT INTO `auto_belonging` VALUES ('411', '天津市( 津)', '津', '0');
INSERT INTO `auto_belonging` VALUES ('412', '天津市', '津A', '411');
INSERT INTO `auto_belonging` VALUES ('413', '天津市', '津B', '411');
INSERT INTO `auto_belonging` VALUES ('414', '天津市', '津C', '411');
INSERT INTO `auto_belonging` VALUES ('415', '天津市', '津D', '411');
INSERT INTO `auto_belonging` VALUES ('416', '天津市', '津E', '411');
INSERT INTO `auto_belonging` VALUES ('417', '天津市', '津F', '411');
INSERT INTO `auto_belonging` VALUES ('418', '天津市', '津G', '411');
INSERT INTO `auto_belonging` VALUES ('419', '天津市', '津H', '411');
INSERT INTO `auto_belonging` VALUES ('420', '上海市(沪)', '沪', '0');
INSERT INTO `auto_belonging` VALUES ('421', '上海市', '沪A', '420');
INSERT INTO `auto_belonging` VALUES ('422', '上海市', '沪B', '420');
INSERT INTO `auto_belonging` VALUES ('423', '上海市', '沪C', '420');
INSERT INTO `auto_belonging` VALUES ('424', '上海市', '沪D', '420');
INSERT INTO `auto_belonging` VALUES ('425', '崇明、长兴、横沙', '沪R', '420');

相关主题
文本预览
相关文档 最新文档