DROP TABLE IF EXISTS `rbac_area`;
CREATE TABLE `rbac_area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`longitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`latitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`level` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`parent_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `rbac_area_parent_id_76a72607_fk_rbac_area_id`(`parent_id`) USING BTREE,
CONSTRAINT `rbac_area_parent_id_76a72607_fk_rbac_area_id` FOREIGN KEY (`parent_id`) REFERENCES `rbac_area` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7238 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
INSERT INTO `rbac_area` VALUES (1, '中华人民共和国', '116.3683244', '39.915085', 'country', NULL);
INSERT INTO `rbac_area` VALUES (2, '澳门特别行政区', '113.543028', '22.186835', 'province', 1);
INSERT INTO `rbac_area` VALUES (3, '花王堂区', '113.548961', '22.199207', 'district', 2);
INSERT INTO `rbac_area` VALUES (4, '望德堂区', '113.550183', '22.193721', 'district', 2);
INSERT INTO `rbac_area` VALUES (5, '大堂区', '113.553647', '22.188539', 'district', 2);
INSERT INTO `rbac_area` VALUES (6, '风顺堂区', '113.541928', '22.187368', 'district', 2);
INSERT INTO `rbac_area` VALUES (7, '花地玛堂区', '113.552896', '22.20787', 'district', 2);
INSERT INTO `rbac_area` VALUES (8, '嘉模堂区', '113.558705', '22.15376', 'district', 2);
INSERT INTO `rbac_area` VALUES (9, '圣方济各堂区', '113.559954', '22.123486', 'district', 2);
INSERT INTO `rbac_area` VALUES (10, '路凼填海区', '113.569599', '22.13663', 'district', 2);
INSERT INTO `rbac_area` VALUES (11, '北京市', '116.407394', '39.904211', 'province', 1);
INSERT INTO `rbac_area` VALUES (12, '北京城区', '116.407394', '39.904211', 'city', 11);
INSERT INTO `rbac_area` VALUES (13, '昌平区', '116.231254', '40.220804', 'district', 12);
INSERT INTO `rbac_area` VALUES (14, '朝阳区', '116.443205', '39.921506', 'district', 12);
INSERT INTO `rbac_area` VALUES (15, '大兴区', '116.341483', '39.726917', 'district', 12);
INSERT INTO `rbac_area` VALUES (16, '东城区', '116.41649', '39.928341', 'district', 12);
INSERT INTO `rbac_area` VALUES (17, '房山区', '116.143486', '39.748823', 'district', 12);
INSERT INTO `rbac_area` VALUES (18, '丰台区', '116.287039', '39.858421', 'district', 12);
INSERT INTO `rbac_area` VALUES (19, '海淀区', '116.298262', '39.95993', 'district', 12);
INSERT INTO `rbac_area` VALUES (20, '怀柔区', '116.631931', '40.316053', 'district', 12);
INSERT INTO `rbac_area` VALUES (21, '门头沟区', '116.101719', '39.940338', 'district', 12);
INSERT INTO `rbac_area` VALUES (22, '密云区', '116.843047', '40.376894', 'district', 12);
INSERT INTO `rbac_area` VALUES (23, '平谷区', '117.121351', '40.140595', 'district', 12);
INSERT INTO `rbac_area` VALUES (24, '石景山区', '116.222933', '39.906611', 'district', 12);
INSERT INTO `rbac_area` VALUES (25, '顺义区', '116.654642', '40.130211', 'district', 12);
INSERT INTO `rbac_area` VALUES (26, '通州区', '116.656434', '39.909946', 'district', 12);
INSERT INTO `rbac_area` VALUES (27, '西城区', '116.365873', '39.912235', 'district', 12);
INSERT INTO `rbac_area` VALUES (28, '延庆区', '115.974981', '40.456591', 'district', 12);
INSERT INTO `rbac_area` VALUES (29, '重庆市', '106.551643', '29.562849', 'province', 1);
INSERT INTO `rbac_area` VALUES (30, '重庆城区', '106.551643', '29.562849', 'city', 29);
INSERT INTO `rbac_area` VALUES (31, '巴南区', '106.540256', '29.402408', 'district', 30);
INSERT INTO `rbac_area` VALUES (32, '北碚区', '106.395612', '29.805107', 'district', 30);
INSERT INTO `rbac_area` VALUES (33, '璧山区', '106.227305', '29.592024', 'district', 30);
INSERT INTO `rbac_area` VALUES (34, '大渡口区', '106.482346', '29.484527', 'district', 30);
INSERT INTO `rbac_area` VALUES (35, '大足区', '105.721733', '29.707032', 'district', 30);
INSERT INTO `rbac_area` VALUES (36, '涪陵区', '107.38977', '29.703022', 'district', 30);
INSERT INTO `rbac_area` VALUES (37, '合川区', '106.27613', '29.972084', 'district', 30);
INSERT INTO `rbac_area` VALUES (38, '江北区', '106.574271', '29.606703', 'district', 30);
INSERT INTO `rbac_area` VALUES (39, '江津区', '106.259281', '29.290069', 'district', 30);
INSERT INTO `rbac_area` VALUES (40, '九龙坡区', '106.510676', '29.502272', 'district', 30);
INSERT INTO `rbac_area` VALUES (41, '开州区', '108.393135', '31.160711', 'district', 30);
INSERT INTO `rbac_area` VALUES (42, '南岸区', '106.644447', '29.50126', 'district', 30);
INSERT INTO `rbac_area` VALUES (43, '南川区', '107.099266', '29.15789', 'district', 30);
INSERT INTO `rbac_area` VALUES (44, '綦江区', '106.651361', '29.028066', 'district', 30);
INSERT INTO `rbac_area` VALUES (45, '黔江区', '108.770677', '29.533609', 'district', 30);
INSERT INTO `rbac_area` VALUES (46, '荣昌区', '105.594623', '29.405002', 'district', 30);
INSERT INTO `rbac_area` VALUES (47, '沙坪坝区', '106.456878', '29.541144', 'district', 30);
INSERT INTO `rbac_area` VALUES (48, '铜梁区', '106.056404', '29.844811', 'district', 30);
INSERT INTO `rbac_area` VALUES (49, '潼南区', '105.840431', '30.190992', 'district', 30);
INSERT INTO `rbac_area` VALUES (50, '万州区', '108.408661', '30.807667', 'district', 30);
INSERT INTO `rbac_area` VALUES (51, '永川区', '105.927001', '29.356311', 'district', 30);
INSERT INTO `rbac_area` VALUES (52, '渝北区', '106.631187', '29.718142', 'district', 30);
INSERT INTO `rbac_area` VALUES (53, '渝中区', '106.568896', '29.552736', 'district', 30);
INSERT INTO `rbac_area` VALUES (54, '长寿区', '107.080734', '29.857912', 'district', 30);
INSERT INTO `rbac_area` VALUES (55, '重庆郊县', '108.165537', '29.293902', 'city', 29);
INSERT INTO `rbac_area` VALUES (56, '城口县', '108.664214', '31.947633', 'district', 55);
INSERT INTO `rbac_area` VALUES (57, '垫江县', '107.33339', '30.327716', 'district', 55);
INSERT INTO `rbac_area` VALUES (58, '丰都县', '107.730894', '29.8635', 'district', 55);
INSERT INTO `rbac_area` VALUES (59, '奉节县', '109.400403', '31.018363', 'district', 55);
INSERT INTO `rbac_area` VALUES (60, '梁平区', '107.769568', '30.654233', 'district', 55);
INSERT INTO `rbac_area` VALUES (61, '彭水苗族土家族自治县', '108.165537', '29.293902', 'district', 55);
INSERT INTO `rbac_area` VALUES (62, '石柱土家族自治县', '108.114069', '29.999285', 'district', 55);
INSERT INTO `rbac_area` VALUES (63, '巫山县', '109.879153', '31.074834', 'district', 55);
INSERT INTO `rbac_area` VALUES (64, '巫溪县', '109.570062', '31.398604', 'district', 55);
INSERT INTO `rbac_area` VALUES (65, '武隆区', '107.760025', '29.325601', 'district', 55);
INSERT INTO `rbac_area` VALUES (66, '秀山土家族苗族自治县', '109.007094', '28.447997', 'district', 55);
INSERT INTO `rbac_area` VALUES (67, '酉阳土家族苗族自治县', '108.767747', '28.841244', 'district', 55);
INSERT INTO `rbac_area` VALUES (68, '云阳县', '108.697324', '30.930612', 'district', 55);
INSERT INTO `rbac_area` VALUES (69, '忠县', '108.039002', '30.299559', 'district', 55);
INSERT INTO `rbac_area` VALUES (70, '福建省', '119.295143', '26.100779', 'province', 1);
INSERT INTO `rbac_area` VALUES (71, '福州市', '119.296389', '26.074268', 'city', 70);
INSERT INTO `rbac_area` VALUES (72, '仓山区', '119.273545', '26.046743', 'district', 71);
INSERT INTO `rbac_area` VALUES (73, '福清市', '119.384201', '25.72071', 'district', 71);
INSERT INTO `rbac_area` VALUES (74, '鼓楼区', '119.303917', '26.081983', 'district', 71);
INSERT INTO `rbac_area` VALUES (75, '晋安区', '119.328521', '26.08
全球各国省市区城市地区层级结构经纬度 json与SQL.zip
版权申诉
5星 · 超过95%的资源 150 浏览量
2021-12-09
16:47:21
上传
评论
收藏 385KB ZIP 举报 
全球各国省市区城市地区层级结构经纬度 json与SQL.zip （4个子文件） 
全球各国城市地区层级结构经纬度（中国以外）.json 1.12MB 中国所有省市区层级经纬度表结构与数据SQL（包括特别行政区）.sql 344KB 全球各国城市地区层级结构经纬度.sql 706KB 中国所有省市区层级结构经纬度（包括特别行政区）.json 904KB
Kantox
- 粉丝: 0
- 资源: 1
下载权益
C知道特权
VIP文章
课程特权
VIP享7折，此内容立减3.57元 开通VIP
- 1
- 2
前往页