/*
MySQL 8.0+版,支持8.0以上的新版本导入
8.0+ mysql不支持直接的EMPTY,使用GEOMETRYCOLLECTION EMPTY=POINT EMPTY、POLYGON EMPTY
5.* mysql就更惨不忍睹了:不支持任何EMPTY,只能用NULL代替;已知:任何不带ST_打头的空间计算函数均为采用Polygon的外接矩形计算,会导致结果不准确,比如Intersects函数,尽量使用ST_Intersects来计算空间位置(5.6+支持)
AreaCity Geo格式转换工具(Ver:1.3.220408) 于 2022-06-22 15:28 生成
https://github.com/xiangyuecn/AreaCity-JsSpider-StatsGov
*/
-- 创建表结构
DROP TABLE IF EXISTS `t_geo_20220622`;
CREATE TABLE `t_geo_20220622` (
id varchar(50) NOT NULL,
pid varchar(250) NOT NULL,
deep varchar(250) NOT NULL,
name varchar(250) NOT NULL,
ext_path varchar(255) NOT NULL,
geo geometry NOT NULL,
polygon geometry NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;
-- 数据区
INSERT INTO `t_geo_20220622` VALUES('11','0','0','北京市','北京市',ST_GeomFromText('POINT (116.407387 39.904179)',0),ST_GeomFromText('POLYGON ((116.789587 40.032488,116.790221 40.03448,116.789492 40.034472,116.788764 40.034586,116.788461 40.034586,116.786258 40.035027,116.785824 40.03491,116.785096 40.035015,116.784359 40.035016,116.783621 40.035017,116.782668 40.034836,116.781539 40.034819,116.781149 40.034641,116.779969 40.033987,116.779249 40.033419,116.77852 40.032851,116.777939 40.032504,116.777809 40.032447,116.777554 40.028632,116.777477 40.027207,116.777019 40.026962,116.775422 40.026338,116.776073 40.025756,116.776272 40.025291,116.776203 40.024584,116.776038 40.023664,116.775647 40.021681,116.774562 40.019381,116.773772 40.01712,116.772609 40.015446,116.77175 40.014474,116.770925 40.013229,116.770465 40.011631,116.771046 40.009721,116.771749 40.008392,116.772912 40.006951,116.774317 40.005314,116.775757 40.002939,116.776147 39.997678,116.775887 39.995716,116.775661 39.994049,116.775366 39.992756,116.77442 39.991728,116.770488 39.987242,116.768457 39.984721,116.766755 39.982278,116.766598 39.979592,116.766433 39.976354,116.763837 39.9728,116.762995 39.971945,116.760937 39.970938,116.759608 39.969927,116.758123 39.968135,116.757367 39.965986,116.75735 39.964528,116.757202 39.963286,116.757332 39.961476,116.757757 39.960578,116.758478 39.959441,116.759876 39.95829,116.762817 39.956011,116.76929 39.953399,116.77378 39.952569,116.776852 39.951164,116.780583 39.949721,116.782569 39.947557,116.782976 39.943498,116.782982 39.941572,116.783182 39.937657,116.783322 39.936037,116.78327 39.935056,116.783235 39.934275,116.782775 39.933003,116.782367 39.928277,116.782644 39.923046,116.782791 39.919188,116.782713 39.918393,116.782686 39.917647,116.782704 39.914904,116.782287 39.911202,116.782165 39.91042,116.782512 39.909339,116.783379 39.906699,116.783695 39.905455,116.784229 39.902223,116.784263 39.896761,116.7847 39.891422,116.785364 39.88953,116.787078 39.886833,116.788547 39.885676,116.793447 39.882762,116.793739 39.882277,116.793869 39.882038,116.794745 39.881251,116.795421 39.880925,116.796279 39.880524,116.79725 39.880271,116.79829 39.880109,116.799062 39.879618,116.79992 39.8789,116.80083 39.878521,116.802139 39.878237,116.804141 39.877935,116.804185 39.878178,116.80415 39.878903,116.804185 39.879871,116.804185 39.880239,116.804194 39.880747,116.804194 39.881381,116.804194 39.881507,116.80422 39.882331,116.804211 39.882787,116.804229 39.883529,116.804229 39.884215,116.804255 39.884832,116.804255 39.884875,116.804333 39.884909,116.805156 39.884895,116.80598 39.884877,116.807037 39.884901,116.808103 39.884886,116.808242 39.884912,116.808268 39.884986,116.808285 39.885416,116.808302 39.885589,116.808285 39.886214,116.808286 39.886804,116.808337 39.88736,116.808346 39.887972,116.808329 39.888566,116.808303 39.88963,116.808355 39.889687,116.809126 39.889707,116.809204 39.889707,116.809993 39.889719,116.811189 39.889712,116.812298 39.88971,116.812298 39.88968,116.812333 39.889089,116.812367 39.888829,116.812376 39.888426,116.812445 39.888113,116.812541 39.887283,116.812584 39.886936,116.812705 39.885304,116.812731 39.885048,116.812809 39.884405,116.812956 39.883289,116.812964 39.883033,116.813034 39.882261,116.813094 39.881488,116.813121 39.881301,116.81319 39.881284,116.813346 39.881275,116.813701 39.881274,116.814394 39.881304,116.815322 39.881302,116.815798 39.88131,116.815893 39.881227,116.816344 39.880046,116.816586 39.879611,116.816803 39.879146,116.816863 39.879033,116.817019 39.878656,116.819628 39.879007,116.823674 39.879143,116.82513 39.878684,116.827278 39.877066,116.827841 39.876331,116.828283 39.875814,116.830068 39.873332,116.832233 39.869717,116.836894 39.864738,116.837552 39.864971,116.837682 39.865032,116.83802 39.865179,116.838731 39.865555,116.839077 39.865728,116.839407 39.865779,116.843912 39.860914,116.845124 39.860061,116.845192 39.85997,116.845238 39.859915,116.845289 39.859882,116.84535 39.859856,116.845521 39.859789,116.847238 39.858624,116.847386 39.858663,116.847715 39.858758,116.848088 39.858914,116.848322 39.858948,116.848625 39.858961,116.848946 39.858973,116.849422 39.858985,116.85028 39.859005,116.850549 39.859009,116.851181 39.85903,116.852074 39.859063,116.852464 39.859058,116.852542 39.859054,116.852576 39.859023,116.852585 39.858919,116.852611 39.858715,116.852663 39.858559,116.852793 39.858359,116.852914 39.858055,116.853018 39.857755,116.853174 39.857186,116.853512 39.857216,116.853538 39.857224,116.853581 39.856981,116.853607 39.856747,116.853668 39.856282,116.853746 39.855835,116.853815 39.855397,116.853832 39.855292,116.855089 39.854856,116.855158 39.854583,116.855262 39.854309,116.855427 39.853853,116.855479 39.853718,116.855617 39.853397,116.855747 39.853019,116.855981 39.852459,116.856059 39.852263,116.856128 39.852081,116.856224 39.851864,116.856267 39.851742,116.856328 39.85162,116.856449 39.851338,116.856544 39.851147,116.856744 39.850686,116.856856 39.85043,116.857056 39.849961,116.857159 39.84967,116.857177 39.848884,116.858295 39.848466,116.859932 39.848094,116.861666 39.847757,116.863157 39.847399,116.864206 39.847185,116.865514 39.846914,116.865645 39.846419,116.865662 39.846323,116.865688 39.846176,116.86574 39.845846,116.865783 39.845533,116.865853 39.845173,116.865922 39.844821,116.865965 39.844352,116.865991 39.844166,116.866008 39.844001,116.866052 39.843896,116.866086 39.843879,116.866268 39.843866,116.866607 39.843826,116.867396 39.843747,116.867673 39.843712,116.867959 39.843663,116.868167 39.843611,116.868418 39.843502,116.868704 39.843376,116.869103 39.843189,116.86919 39.843145,116.869484 39.842993,116.869857 39.84281,116.870152 39.842649,116.87101 39.842274,116.871192 39.842188,116.871513 39.842066,116.871773 39.841991,116.871912 39.841944,116.872034 39.841943,116.87206 39.842112,116.872077 39.842286,116.872155 39.842334,116.87232 39.842355,116.872658 39.842355,116.873308 39.842358,116.873776 39.842371,116.873828 39.842397,116.873802 39.842592,116.873759 39.8429,116.873672 39.843226,116.873603 39.843643,116.873681 39.843704,116.873863 39.843677,116.874115 39.843625,116.874375 39.843581,116.874739 39.843524,116.874878 39.843494,116.875251 39.843419,116.875632 39.843349,116.875953 39.843288,116.876343 39.843196,116.876621 39.843092,116.876933 39.842966,116.877184 39.842861,116.877453 39.842722,116.877809 39.842579,116.878086 39.842465,116.878581 39.842248,116.878633 39.842252,116.878494 39.842639,116.87839 39.842938,116.878277 39.843411,116.878251 39.843672,116.878286 39.844106,116.878295 39.844496,116.878303 39.845217,116.880793 39.845414,116.883638 39.845515,116.885668 39.844589,116.887932 39.842408,116.891628 39.838621,116.892912 39.835755,116.894595 39.834169,116.897503 39.832579,116.900246 39.831597,116.903346 39.830689,116.905066 39.830624,116.906698 39.831362,116.907445 39.832673,116.907576 39.834114,116.906065 39.836979,116.905492 39.838268,116.903929 39.839779,116.902887 39.841346,116.902245 39.843269,1
没有合适的资源?快使用搜索试试~ 我知道了~
最新省市区镇四级行政区划数据和省市区三级坐标边界数据

共136个文件
dbf:20个
json:20个
cpg:20个


温馨提示
最新省市区镇四级行政区划数据和省市区三级坐标边界数据,包括ok_data_level4、ok_geo、ok_geo4_ETD220408、ok_geo4_ETD220408_free文件,转成其他格式比如:shp、geojson、sql,包括BD09、CGCS200、GCJ-02、WGS8等坐标系,可一键导入MySQL数据库。备注:ok_geo.csv(省市区 坐标+边界范围,高德地图坐标数据,坐标系为GCJ-02火星坐标系)、ok_data_level4.csv(省市区镇 4级行政区划数据)、ok_geo4_ETD220408.csv(乡镇第4级坐标边界数据) GeoJSON-Geo(中心坐标)、GeoJSON-Polygon(边界范围)
资源详情
资源评论
资源推荐
收起资源包目录





































































































共 136 条
- 1
- 2











qq_34095850
- 粉丝: 13
- 资源: 9
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助


安全验证
文档复制为VIP权益,开通VIP直接复制

评论2