2021年最新各个省市区 sql文件

全国地区划分表，精确到村，省级别到村级别，目前比较准确的

2021年全国最新地区数据sql文件五级联动，含层级结构和坐标。保证可用。 CREATE TABLE `areas` ( `ID` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '区划ID', `ParentId` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '父ID', `LevelType` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '级别', `Name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '全称', `ShortName` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '简称', `ParentPath` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'ID路径 (110000,110100,110105)', `Province` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '省份全称', `City` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '城市全称', `District` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '县区全称', `ProvinceShortName` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '省份简称', `CityShortName` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '城市简称', `DistrictShortName` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '县区简称', `ProvincePinyin` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '省份拼音', `CityPinyin` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '城市拼音', `DistrictPinyin` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '县区拼音', `CityCode` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '拼音', `ZipCode` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '简拼', `Pinyin` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_un

INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES (830000000000, 0, '台灣省', 1); INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES (830100000000, 830000000000, '臺北市', 2), (830200000000, 830000000000, '基隆市', 2), (830300000000, 830000000000, '新北市', 2), (830400000000, 830000000000, '桃園市', 2), (830500000000, 830000000000, '新竹市', 2), (830600000000, 830000000000, '新竹縣', 2), (830700000000, 830000000000, '苗栗縣', 2), (830800000000, 830000000000, '臺中市', 2), (830900000000, 830000000000, '彰化縣', 2), (831000000000, 830000000000, '南投縣', 2), (831100000000, 830000000000, '雲林縣', 2), (831200000000, 830000000000, '嘉義市', 2), (831300000000, 830000000000, '嘉義縣', 2), (831400000000, 830000000000, '臺南市', 2), (831500000000, 830000000000, '高雄市', 2), (831600000000, 830000000000, '屏東縣', 2), (831700000000, 830000000000, '宜蘭縣', 2), (831800000000, 830000000000, '花蓮縣', 2), (831900000000, 830000000000, '臺東縣', 2), (832000000000, 830000000000, '澎湖縣', 2), (832100000000, 830000000000, '金門縣', 2), (832200000000, 830000000000, '連江縣', 2), (830101000000, 830100000000, '中正區', 3), (830102000000, 830100000000, '大同區', 3), (830103000000, 830100000000, '中山區', 3), (830104000000, 830100000000, '松山區', 3), (830105000000, 830100000000, '大安區', 3), (830106000000, 830100000000, '萬華區', 3), (830107000000, 830100000000, '信義區', 3), (830108000000, 830100000000, '士林區', 3), (830109000000, 830100000000, '北投區', 3), (830110000000, 830100000000, '內湖區', 3), (830111000000, 830100000000, '南港區', 3), (830112000000, 830100000000, '文山區', 3), (830201000000, 830200000000, '仁愛區', 3), (830202000000, 830200000000, '信義區', 3), (830203000000, 830200000000, '中正區', 3),

DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `id` bigint(20) NOT NULL COMMENT 'ID', `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称', `pid` bigint(20) NOT NULL COMMENT '父ID', `level` int(11) NOT NULL COMMENT '级别：1-省，2-市，3-区，4-乡镇', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行政区域表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of area -- ---------------------------- INSERT INTO `area` VALUES (110000000000, '北京市', 0, 1); INSERT INTO `area` VALUES (110100000000, '市辖区', 110000000000, 2); INSERT INTO `area` VALUES (110101000000, '东城区', 110100000000, 3); INSERT INTO `area` VALUES (110101001000, '东华门街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101002000, '景山街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101003000, '交道口街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101004000, '安定门街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101005000, '北新桥街道办事处', 110101000000, 4); INSERT INTO `area` VALUES (110101006000, '东四街道办事处', 110101000000, 4);

全世界各国地区数据，包含多个sql和xls文件提供参考使用。

记录了全国地区的三级省市区，包含香港，澳门等区域。

全国各地省市区分布数据库SQL文件数据库

高德地图城市地区数据sql整理，下载文件，打开文件，将sql文直接复制到客户端即可。