从国家统计局抓取的地图省市区划代码和城划分代码(最新2020/06/03),共596071条数据。来源于国家统计局http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2019/。
数据结构:
CREATE TABLE `area` (
`areaid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`area_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`fatherid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`area_type` int(255) DEFAULT NULL COMMENT '区域代码:\r\n100 :城镇,110:城区,111 :主城区,112 :城乡结合区,120 :镇区,121 :镇中心区,122:镇乡结合区,123:特殊区域200 :乡村,210:乡中心区,220:村庄\r\n\r\n',
`is_delete` int(255) DEFAULT '0',
PRIMARY KEY (`areaid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
部分数据:
INSERT INTO `area` VALUES ('110000000000','北京市',NULL,NULL,0);
INSERT INTO `area` VALUES ('110100000000','市辖区','110000000000',NULL,0);
INSERT INTO `area` VALUES ('110101000000','东城区','110100000000',NULL,0);
INSERT INTO `area` VALUES ('110101001000','东华门街道','110101000000',NULL,0);
INSERT INTO `area` VALUES ('110101001001','多福巷社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001002','银闸社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001005','东厂社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001006','智德社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001007','南池子社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001008','黄图岗社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001009','灯市口社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001010','正义路社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001011','甘雨社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001013','台基厂社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001014','韶九社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101001015','王府井社区居委会','110101001000',111,0);
INSERT INTO `area` VALUES ('110101002000','景山街道','110101000000',NULL,0);
INSERT INTO `area` VALUES ('110101002001','隆福寺社区居委会','110101002000',111,0);
INSERT INTO `area` VALUES ('110101002002','吉祥社区居
1