2018全国省市县镇村5级数据库sql

# Host: 127.0.0.1 (Version: 5.6.17) # Date: 2016-12-16 09:33:11 # Generator: MySQL-Front 5.3 (Build 4.214) /*!40101 SET NAMES utf8 */; # # Structure for table "address" # DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `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='省市县镇村数据'; # # Data for table "address" # INSERT INTO `address` VALUES (1,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001001,'多福巷社区'),(2,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001002,'银闸社区'),(3,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001005,'东厂社区'),(4,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001006,'智德社区'),(5,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001007,'南池子社区'),(6,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001008,'黄图岗社区'),(7,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001009,'灯市口社区'),(8,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001010,'正义路社区'),(9,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001011,'甘雨社区'),(10,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001013,'台基厂社区'),(11,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001014,'韶九社区'),(12,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101001000,'东华门街道办事处',110101001015,'王府井社区'),(13,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002001,'隆福寺社区'),(14,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002002,'吉祥社区'),(15,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002003,'黄化门社区'),(16,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002004,'钟鼓社区'),(17,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002005,'魏家社区'),(18,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002006,'汪芝麻社区'),(19,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002008,'景山东街社区'),(20,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101002000,'景山街道办事处',110101002009,'皇城根北街社区'),(21,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101003000,'交道口街道办事处',110101003001,'交东社区'),(22,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101003000,'交道口街道办事处',110101003002,'福祥社区'),(23,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101003000,'交道口街道办事处',110101003003,'大兴社区'),(24,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101003000,'交道口街道办事处',110101003005,'府学社区'),(25,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101003000,'交道口街道办事处',110101003007,'鼓楼苑社区'),(26,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101003000,'交道口街道办事处',110101003008,'菊儿社区'),(27,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101003000,'交道口街道办事处',110101003009,'南锣鼓巷社区'),(28,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004001,'交北头条社区'),(29,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004002,'北锣鼓巷社区'),(30,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004003,'国子监社区'),(31,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004004,'钟楼湾社区'),(32,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004005,'宝钞南社区'),(33,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004006,'五道营社区'),(34,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004009,'分司厅社区'),(35,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004011,'国旺社区'),(36,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101004000,'安定门街道办事处',110101004012,'花园社区'),(37,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005001,'海运仓社区'),(38,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005002,'北新仓社区'),(39,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005004,'门楼社区'),(40,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005005,'十三条社区'),(41,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005006,'民安社区'),(42,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005008,'九道湾社区'),(43,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005009,'北官厅社区'),(44,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005010,'青龙社区'),(45,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005011,'小菊社区'),(46,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005012,'藏经馆社区'),(47,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005014,'草园社区'),(48,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101005000,'北新桥街道办事处',110101005016,'前永康社区'),(49,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101006000,'东四街道办事处',110101006001,'南门仓社区'),(50,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101006000,'东四街道办事处',110101006002,'七条社区'),(51,110,'北京市',110100000000,'市辖区',110101000000,'东城区',110101006000