2019全国最新行政区划表（mysql）

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for area -- ---------------------------- DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `fullname` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT '', `pid` int(11) DEFAULT NULL, `managename` varchar(255) DEFAULT NULL, `level` int(11) DEFAULT NULL, `sheng` int(11) NOT NULL DEFAULT 0, `shi` int(11) NOT NULL DEFAULT 0, `xian` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of area -- ---------------------------- INSERT INTO `area` VALUES ('110000', '北京', '北京市', '{\"lat\":39.90469,\"lng\":116.40717}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('120000', '天津', '天津市', '{\"lat\":39.0851,\"lng\":117.19937}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('130000', '河北', '河北省', '{\"lat\":38.03599,\"lng\":114.46979}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('140000', '山西', '山西省', '{\"lat\":37.87343,\"lng\":112.56272}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('150000', '内蒙古', '内蒙古自治区', '{\"lat\":40.81733,\"lng\":111.76522}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('210000', '辽宁', '辽宁省', '{\"lat\":41.83571,\"lng\":123.42925}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('220000', '吉林', '吉林省', '{\"lat\":43.89616,\"lng\":125.3268}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('230000', '黑龙江', '黑龙江省', '{\"lat\":45.74208,\"lng\":126.66285}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('310000', '上海', '上海市', '{\"lat\":31.23037,\"lng\":121.4737}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('320000', '江苏', '江苏省', '{\"lat\":32.06071,\"lng\":118.76295}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('330000', '浙江', '浙江省', '{\"lat\":30.26555,\"lng\":120.1536}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('340000', '安徽', '安徽省', '{\"lat\":31.86157,\"lng\":117.28565}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('350000', '福建', '福建省', '{\"lat\":26.09982,\"lng\":119.29659}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('360000', '江西', '江西省', '{\"lat\":28.67417,\"lng\":115.91004}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('370000', '山东', '山东省', '{\"lat\":36.66826,\"lng\":117.02076}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('410000', '河南', '河南省', '{\"lat\":34.76571,\"lng\":113.75322}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('420000', '湖北', '湖北省', '{\"lat\":30.54539,\"lng\":114.34234}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('430000', '湖南', '湖南省', '{\"lat\":28.11266,\"lng\":112.9834}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('440000', '广东', '广东省', '{\"lat\":23.13171,\"lng\":113.26627}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('450000', '广西', '广西壮族自治区', '{\"lat\":22.81521,\"lng\":108.32754}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('460000', '海南', '海南省', '{\"lat\":20.01997,\"lng\":110.34863}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('500000', '重庆', '重庆市', '{\"lat\":29.56471,\"lng\":106.55073}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('510000', '四川', '四川省', '{\"lat\":30.65089,\"lng\":104.07572}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('520000', '贵州', '贵州省', '{\"lat\":26.5982,\"lng\":106.70722}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('530000', '云南', '云南省', '{\"lat\":25.0453,\"lng\":102.70973}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('540000', '西藏', '西藏自治区', '{\"lat\":29.64725,\"lng\":91.11748}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('610000', '陕西', '陕西省', '{\"lat\":34.26486,\"lng\":108.95424}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('620000', '甘肃', '甘肃省', '{\"lat\":36.05942,\"lng\":103.82634}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('630000', '青海', '青海省', '{\"lat\":36.62087,\"lng\":101.78011}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('640000', '宁夏', '宁夏回族自治区', '{\"lat\":38.47117,\"lng\":106.25867}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('650000', '新疆', '新疆维吾尔自治区', '{\"lat\":43.79343,\"lng\":87.6271}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('710000', '台湾', '台湾省', '{\"lat\":25.030724,\"lng\":121.520076}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('810000', '香港', '香港特别行政区', '{\"lat\":22.27534,\"lng\":114.16546}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('820000', '澳门', '澳门特别行政区', '{\"lat\":22.19875,\"lng\":113.54913}', '0', '', '1', '0', '0', '0'); INSERT INTO `area` VALUES ('110100', '北京', '北京市', '{\"lat\":39.90469,\"lng\":116.40717}', '110000', '', '2', '110000', '0', '0'); INSERT INTO `area` VALUES ('110101', '东城', '东城区', '{\"lat\":39.92855,\"lng\":116.41637}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110102', '西城', '西城区', '{\"lat\":39.91231,\"lng\":116.36611}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110105', '朝阳', '朝阳区', '{\"lat\":39.9219,\"lng\":116.44355}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110106', '丰台', '丰台区', '{\"lat\":39.85856,\"lng\":116.28616}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110107', '石景山', '石景山区', '{\"lat\":39.90569,\"lng\":116.22299}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110108', '海淀', '海淀区', '{\"lat\":39.95933,\"lng\":116.29845}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110109', '门头沟', '门头沟区', '{\"lat\":39.94048,\"lng\":116.10146}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110111', '房山', '房山区', '{\"lat\":39.74788,\"lng\":116.14294}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110112', '通州', '通州区', '{\"lat\":39.90998,\"lng\":116.65714}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110113', '顺义', '顺义区', '{\"lat\":40.13012,\"lng\":116.65477}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110114', '昌平', '昌平区', '{\"lat\":40.22077,\"lng\":116.23128}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110115', '大兴', '大兴区', '{\"lat\":39.72684,\"lng\":116.34159}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110116', '怀柔', '怀柔区', '{\"lat\":40.316,\"lng\":116.63177}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110117', '平谷', '平谷区', '{\"lat\":40.14062,\"lng\":117.12141}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110118', '密云', '密云区', '{\"lat\":40.37625,\"lng\":116.84317}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('110119', '延庆', '延庆区', '{\"lat\":40.45678,\"lng\":115.97503}', '110100', '北京', '3', '110000', '110100', '0'); INSERT INTO `area` VALUES ('120100', '天津', '天津市', '{\"lat\":39.0851,\"lng\":117.19937}', '120000', '', '2', '120000', '0', '0'); INSERT I