中国5级行政区域mysql库更新2017年数据共778936条

/* 2018/10/25 9:21 author lkk/ipoem.cn 爬取国家统计局2017年的行政区域数据(截止2017年10月31日),共77万多记录. 项目地址:https://github.com/kakuilan/china_area_mysql ********************************************************************* */ DROP TABLE IF EXISTS `cnarea_2017`; CREATE TABLE `cnarea_2017` ( `id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT, `parent_id` mediumint(7) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID', `level` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '层级', `area_code` bigint(12) unsigned NOT NULL DEFAULT '0' COMMENT '行政代码', `zip_code` mediumint(6) unsigned zerofill NOT NULL DEFAULT '000000' COMMENT '邮政编码', `city_code` char(6) NOT NULL DEFAULT '' COMMENT '区号', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称', `short_name` varchar(50) NOT NULL DEFAULT '' COMMENT '简称', `merger_name` varchar(50) NOT NULL DEFAULT '' COMMENT '组合名', `pinyin` varchar(30) NOT NULL DEFAULT '' COMMENT '拼音', `lng` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '经度', `lat` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '纬度', PRIMARY KEY (`id`), KEY `idx_lev` (`level`,`parent_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=778937 DEFAULT CHARSET=utf8 COMMENT='中国行政地区表'; /*Data for the table `cnarea` */ insert into `cnarea_2017`(`id`,`parent_id`,`level`,`area_code`,`zip_code`,`city_code`,`name`,`short_name`,`merger_name`,`pinyin`,`lng`,`lat`) values (1,0,0,110000000000,000000,'','北京市','北京','北京','BeiJing','116.407526','39.904030'),(2,1,1,110100000000,100000,'010','直辖区','北京','北京','BeiJing','116.407526','39.904030'),(3,2,2,110101000000,100000,'010','东城区','东城','北京,东城','DongCheng','116.416357','39.928353'),(4,3,3,110101001000,100006,'010','东华门街道办事处','东华门','北京,东城,东华门','DongHuaMen','116.401640','39.915110'),(5,4,4,110101001001,100010,'010','多福巷社区居委会','多福巷','北京,东城,东华门,多福巷','DuoFuXiang','116.412903','39.922878'),(6,4,4,110101001002,100006,'010','银闸社区居委会','银闸','北京,东城,东华门,银闸','YinZha','116.405860','39.919340'),(7,4,4,110101001005,100006,'010','东厂社区居委会','东厂','北京,东城,东华门,东厂','DongChang','116.428940','39.949370'),(8,4,4,110101001006,100006,'010','智德社区居委会','智德','北京,东城,东华门,智德','ZhiDe','116.403840','39.915130'),(9,4,4,110101001007,100006,'010','南池子社区居委会','南池子','北京,东城,东华门,南池子','NanChiZi','116.404396','39.911860'),(10,4,4,110101001008,100006,'010','黄图岗社区居委会','黄图岗','北京,东城,东华门,黄图岗','HuangTuGang','116.409940','39.920690'),(11,4,4,110101001009,100006,'010','灯市口社区居委会','灯市口','北京,东城,东华门,灯市口','DengShiKou','116.417730','39.917270'),(12,4,4,110101001010,100006,'010','正义路社区居委会','正义路','北京,东城,东华门,正义路','ZhengYiLu','116.407280','39.903301'),(13,4,4,110101001011,100006,'010','甘雨社区居委会','甘雨','北京,东城,东华门,甘雨','GanYu','116.415634','39.917304'),(14,4,4,110101001013,100005,'010','台基厂社区居委会','台基厂','北京,东城,东华门,台基厂','TaiJiChang','116.415430','39.905590'),(15,4,4,110101001014,100006,'010','韶九社区居委会','韶九','北京,东城,东华门,韶九','ShaoJiu','116.407328','39.916842'),(16,4,4,110101001015,100006,'010','王府井社区居委会','王府井','北京,东城,东华门,王府井','WangFuJing','116.411350','39.911140'),(17,3,3,110101002000,100009,'010','景山街道办事处','景山','北京,东城,景山','JingShan','116.411000','39.926900'),(18,17,4,110101002001,100010,'010','隆福寺社区居委会','隆福寺','北京,东城,景山,隆福寺','LongFuSi','116.413830','39.925350'),(19,17,4,110101002002,100007,'010','吉祥社区居委会','吉祥','北京,东城,景山,吉祥','JiXiang','116.413070','39.930510'),(20,17,4,110101002003,100009,'010','黄化门社区居委会','黄化门','北京,东城,景山,黄化门','HuangHuaMen','116.400576','39.930999'),(21,17,4,110101002004,100009,'010','钟鼓社区居委会','钟鼓','北京,东城,景山,钟鼓','ZhongGu','116.395950','39.940760'),(22,17,4,110101002005,100007,'010','魏家社区居委会','魏家','北京,东城,景山,魏家','WeiJia','116.416175','39.929849'),(23,17,4,110101002006,100007,'010','汪芝麻社区居委会','汪芝麻','北京,东城,景山,汪芝麻','WangZhiMa','116.412148','39.932617'),(24,17,4,110101002008,100009,'010','景山东街社区居委会','景山东街','北京,东城,景山,景山东街','JingShanDongJie','116.399497','39.927555'),(25,17,4,110101002009,100010,'010','皇城根北街社区居委会','皇城根北街','北京,东城,景山,皇城根北街','HuangChengGenBeiJie','116.406853','39.928898'),(26,3,3,110101003000,100007,'010','交道口街道办事处','交道口','北京,东城,交道口','JiaoDaoKou','116.411270','39.941420'),(27,26,4,110101003001,100007,'010','交东社区居委会','交东','北京,东城,交道口,交东','JiaoDong','116.413551','39.940254'),(28,26,4,110101003002,100009,'010','福祥社区居委会','福祥','北京,东城,交道口,福祥','FuXiang','116.401160','39.934180'),(29,26,4,110101003003,100007,'010','大兴社区居委会','大兴','北京,东城,交道口,大兴','DaXing','116.411270','39.941420'),(30,26,4,110101003005,100007,'010','府学社区居委会','府学','北京,东城,交道口,府学','FuXue','116.411140','39.939050'),(31,26,4,110101003007,100009,'010','鼓楼苑社区居委会','鼓楼苑','北京,东城,交道口,鼓楼苑','GuLouYuan','116.406750','39.935110'),(32,26,4,110101003008,100009,'010','菊儿社区居委会','菊儿','北京,东城,交道口,菊儿','JuEr','116.405630','39.939180'),(33,26,4,110101003009,100009,'010','南锣鼓巷社区居委会','南锣鼓巷','北京,东城,交道口,南锣鼓巷','NanLuoGuXiang','116.403320','39.936440'),(34,3,3,110101004000,100007,'010','安定门街道办事处','安定门','北京,东城,安定门','AnDingMen','116.405010','39.944870'),(35,34,4,110101004001,100007,'010','交北头条社区居委会','交北头条','北京,东城,安定门,交北头条','JiaoBeiTouTiao','116.410088','39.941849'),(36,34,4,110101004002,100009,'010','北锣鼓巷社区居委会','北锣鼓巷','北京,东城,安定门,北锣鼓巷','BeiLuoGuXiang','116.402800','39.946240'),(37,34,4,110101004003,100007,'010','国子监社区居委会','国子监','北京,东城,安定门,国子监','GuoZiJian','116.408690','39.945430'),(38,34,4,110101004004,100009,'010','钟楼湾社区居委会','钟楼湾','北京,东城,安定门,钟楼湾','ZhongLouWan','116.395940','39.942490'),(39,34,4,110101004005,100007,'010','宝钞南社区居委会','宝钞南','北京,东城,安定门,宝钞南','BaoChaoNan','116.399140','39.947520'),(40,34,4,110101004006,100007,'010','五道营社区居委会','五道营','北京,东城,安定门,五道营','WuDaoYing','116.412251','39.948339'),(41,34,4,110101004009,100009,'010','分司厅社区居委会','分司厅','北京,东城,安定门,分司厅','FenSiTing','116.406547','39.944019'),(42,34,4,110101004011,100009,'010','国旺社区居委会','国旺','北京,东城,安定门,国旺','GuoWang','116.396050','39.945330'),(43,34,4,110101004012,100009,'010','花园社区居委会','花园','北京,东城,安定门,花园','HuaYuan','116.405010','39.944870'),(44,3,3,110101005000,100007,'010','北新桥街道办事处','北新桥','北京,东城,北新桥','BeiXinQiao','116.416900','39.940810'),(45,44,4,110101005001,100007,'010','海运仓社区居委会','海运仓','北京,东城,北新桥,海运仓','HaiYunCang','116.427210','39.935610'),(46,44,4,110101005002,100007,'010','北新仓社区居委会','北新仓','北京,东城,北新桥,北新仓','BeiXinCang','116.42871