2021年行政区划代码（含经纬度）mysql库

数据来源：国家统计局

数据截至日期：2021/04/20

数据包含：行政区划代码、行政区划名称、级别、经纬度

数据库：MySQL

SQL文件下载链接（无须积分，免费下载）：https://download.csdn.net/download/qq_32352777/16775021

数据库定义语句：

-- ----------------------------
-- Table structure for s_administrative_divisions
-- ----------------------------
DROP TABLE IF EXISTS `s_administrative_divisions`;
CREATE TABLE `s_administrative_divisions`  (
  `code` int(10) NOT NULL COMMENT '行政区划代码',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名字',
  `level` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'country:国家、province:省份（直辖市会在province和city显示）、city:市（直辖市会在province和city显示）、district:区县',
  `pcode` int(10) NULL DEFAULT NULL COMMENT '所属行政区划代码',
  `pname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '所属行政区划名字',
  `fullname` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行政区划完整名字',
  `longitude` double(10, 7) NULL DEFAULT NULL COMMENT '经度',
  `latitude` double(10, 7) NULL DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行政区划表' ROW_FORMAT = Dynamic;
           

因为正文篇幅限制没办法把数据全部贴出来，只给出部分示意，需要完整数据的朋友请下载SQL文件。

-- ----------------------------
-- Records of s_administrative_divisions
-- ----------------------------
INSERT INTO `s_administrative_divisions` VALUES (110000, '北京市', 'province', NULL, '', '北京市', 39.9049890, 116.4052850);
INSERT INTO `s_administrative_divisions` VALUES (110100, '北京城区', 'city', 110000, '北京市', '北京市/北京城区', 39.9049890, 116.4052850);
INSERT INTO `s_administrative_divisions` VALUES (110101, '东城区', 'district', 110100, '北京城区', '北京市/北京城区/东城区', 39.9175440, 116.4187570);
INSERT INTO `s_administrative_divisions` VALUES (110102, '西城区', 'district', 110100, '北京城区', '北京市/北京城区/西城区', 39.9153090, 116.3667940);
INSERT INTO `s_administrative_divisions` VALUES (110105, '朝阳区', 'district', 110100, '北京城区', '北京市/北京城区/朝阳区', 39.9214890, 116.4864090);
INSERT INTO `s_administrative_divisions` VALUES (110106, '丰台区', 'district', 110100, '北京城区', '北京市/北京城区/丰台区', 39.8636420, 116.2869680);
INSERT INTO `s_administrative_divisions` VALUES (110107, '石景山区', 'district', 110100, '北京城区', '北京市/北京城区/石景山区', 39.9146010, 116.1954450);
INSERT INTO `s_administrative_divisions` VALUES (110108, '海淀区', 'district', 110100, '北京城区', '北京市/北京城区/海淀区', 39.9560740, 116.3103160);
INSERT INTO `s_administrative_divisions` VALUES (110109, '门头沟区', 'district', 110100, '北京城区', '北京市/北京城区/门头沟区', 39.9371830, 116.1053810);
INSERT INTO `s_administrative_divisions` VALUES (110111, '房山区', 'district', 110100, '北京城区', '北京市/北京城区/房山区', 39.7355350, 116.1391570);
INSERT INTO `s_administrative_divisions` VALUES (110112, '通州区', 'district', 110100, '北京城区', '北京市/北京城区/通州区', 39.9024860, 116.6586030);
INSERT INTO `s_administrative_divisions` VALUES (110113, '顺义区', 'district', 110100, '北京城区', '北京市/北京城区/顺义区', 40.1289360, 116.6535250);
INSERT INTO `s_administrative_divisions` VALUES (110114, '昌平区', 'district', 110100, '北京城区', '北京市/北京城区/昌平区', 40.2180850, 116.2359060);
INSERT INTO `s_administrative_divisions` VALUES (110115, '大兴区', 'district', 110100, '北京城区', '北京市/北京城区/大兴区', 39.7289080, 116.3380330);
INSERT INTO `s_administrative_divisions` VALUES (110116, '怀柔区', 'district', 110100, '北京城区', '北京市/北京城区/怀柔区', 40.3242720, 116.6371220);
INSERT INTO `s_administrative_divisions` VALUES (110117, '平谷区', 'district', 110100, '北京城区', '北京市/北京城区/平谷区', 40.1447830, 117.1123350);
INSERT INTO `s_administrative_divisions` VALUES (110118, '密云区', 'district', 110100, '北京城区', '北京市/北京城区/密云区', 40.3773620, 116.8433520);
INSERT INTO `s_administrative_divisions` VALUES (110119, '延庆区', 'district', 110100, '北京城区', '北京市/北京城区/延庆区', 40.4653250, 115.9850060);
INSERT INTO `s_administrative_divisions` VALUES (120000, '天津市', 'province', NULL, '', '天津市', 39.1255960, 117.1901820);
INSERT INTO `s_administrative_divisions` VALUES (120100, '天津城区', 'city', 120000, '天津市', '天津市/天津城区', 39.1255960, 117.1901820);
INSERT INTO `s_administrative_divisions` VALUES (120101, '和平区', 'district', 120100, '天津城区', '天津市/天津城区/和平区', 39.1183270, 117.1959070);
INSERT INTO `s_administrative_divisions` VALUES (120102, '河东区', 'district', 120100, '天津城区', '天津市/天津城区/河东区', 39.1221250, 117.2265680);
INSERT INTO `s_administrative_divisions` VALUES (120103, '河西区', 'district', 120100, '天津城区', '天津市/天津城区/河西区', 39.1018970, 117.2175360);
INSERT INTO `s_administrative_divisions` VALUES (120104, '南开区', 'district', 120100, '天津城区', '天津市/天津城区/南开区', 39.1204740, 117.1641430);
INSERT INTO `s_administrative_divisions` VALUES (120105, '河北区', 'district', 120100, '天津城区', '天津市/天津城区/河北区', 39.1566320, 117.2015690);
INSERT INTO `s_administrative_divisions` VALUES (120106, '红桥区', 'district', 120100, '天津城区', '天津市/天津城区/红桥区', 39.1750660, 117.1633010);
INSERT INTO `s_administrative_divisions` VALUES (120110, '东丽区', 'district', 120100, '天津城区', '天津市/天津城区/东丽区', 39.0877640, 117.3139670);
INSERT INTO `s_administrative_divisions` VALUES (120111, '西青区', 'district', 120100, '天津城区', '天津市/天津城区/西青区', 39.1394460, 117.0122470);
INSERT INTO `s_administrative_divisions` VALUES (120112, '津南区', 'district', 120100, '天津城区', '天津市/天津城区/津南区', 38.9895770, 117.3825490);
INSERT INTO `s_administrative_divisions` VALUES (120113, '北辰区', 'district', 120100, '天津城区', '天津市/天津城区/北辰区', 39.2255550, 117.1348200);
INSERT INTO `s_administrative_divisions` VALUES (120114, '武清区', 'district', 120100, '天津城区', '天津市/天津城区/武清区', 39.3769250, 117.0579590);
INSERT INTO `s_administrative_divisions` VALUES (120115, '宝坻区', 'district', 120100, '天津城区', '天津市/天津城区/宝坻区', 39.7169650, 117.3080940);
INSERT INTO `s_administrative_divisions` VALUES (120116, '滨海新区', 'district', 120100, '天津城区', '天津市/天津城区/滨海新区', 39.0328460, 117.6541730);
INSERT INTO `s_administrative_divisions` VALUES (120117, '宁河区', 'district', 120100, '天津城区', '天津市/天津城区/宁河区', 39.3288860, 117.8282800);
INSERT INTO `s_administrative_divisions` VALUES (120118, '静海区', 'district', 120100, '天津城区', '天津市/天津城区/静海区', 38.9356710, 116.9253040);
INSERT INTO `s_administrative_divisions` VALUES (120119, '蓟州区', 'district', 120100, '天津城区', '天津市/天津城区/蓟州区', 40.0453420, 117.4074490);
// .............后续省略（因为CSDN正文篇幅限制，需要完整内容的朋友下载SQL文件）