2018最新全国省市、区、县、镇、乡5级联动sql文件

/* Navicat MySQL Data Transfer Source Server : write Source Server Version : 50528 Source Host : localhost:3306 Source Database : baselist Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2018-03-07 20:42:33 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for 5ji_pro_city_county_town_village -- ---------------------------- DROP TABLE IF EXISTS `5ji_pro_city_county_town_village`; CREATE TABLE `5ji_pro_city_county_town_village` ( `id` int(11) NOT NULL AUTO_INCREMENT, `province_id` bigint(20) unsigned NOT NULL, `province_name` char(64) NOT NULL, `city_id` bigint(20) unsigned NOT NULL, `city_name` char(64) NOT NULL, `county_id` bigint(20) unsigned NOT NULL, `county_name` char(64) NOT NULL, `town_id` bigint(20) unsigned NOT NULL, `town_name` char(64) NOT NULL, `village_id` bigint(20) unsigned NOT NULL, `village_name` char(64) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `village_id` (`village_id`) ) ENGINE=InnoDB AUTO_INCREMENT=693338 DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据'; -- ---------------------------- -- Records of 5ji_pro_city_county_town_village -- ---------------------------- INSERT INTO `5ji_pro_city_county_town_village` VALUES ('1', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001001', '多福巷社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('2', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001002', '银闸社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('3', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001005', '东厂社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('4', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001006', '智德社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('5', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001007', '南池子社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('6', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001008', '黄图岗社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('7', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001009', '灯市口社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('8', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001010', '正义路社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('9', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001011', '甘雨社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('10', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001013', '台基厂社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('11', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001014', '韶九社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('12', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001015', '王府井社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('13', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002001', '隆福寺社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('14', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002002', '吉祥社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('15', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002003', '黄化门社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('16', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002004', '钟鼓社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('17', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002005', '魏家社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('18', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002006', '汪芝麻社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('19', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002008', '景山东街社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('20', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101002000', '景山街道办事处', '110101002009', '皇城根北街社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('21', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003001', '交东社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('22', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003002', '福祥社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('23', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003003', '大兴社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('24', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003005', '府学社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('25', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003007', '鼓楼苑社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('26', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003008', '菊儿社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('27', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101003000', '交道口街道办事处', '110101003009', '南锣鼓巷社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('28', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004001', '交北头条社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('29', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004002', '北锣鼓巷社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('30', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办事处', '110101004003', '国子监社区'); INSERT INTO `5ji_pro_city_county_town_village` VALUES ('31', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101004000', '安定门街道办�