{"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/s/sakaik/20251223/20251223130257.png","categories":["mysql","gis"],"published":"2025-12-23 13:11:32","height":"190","author_url":"https://blog.hatena.ne.jp/sakaik/","description":"\u300cMySQL\u306b\u306f (\u7279\u306bPostGIS\u3068\u6bd4\u3079\u3066) \u5bfe\u5fdc\u3057\u3066\u3044\u308b\u7a7a\u9593\u95a2\u6570\u304c\u3068\u3066\u3082\u5c11\u306a\u3044\u300d\u3068\u3001\u3053\u306e7\u5e74\u9593\u8a00\u3044\u7d9a\u3051\u3066\u304d\u307e\u3057\u305f\u3002 \u4e00\u65b9\u3067\u3001MySQL 8.0 \u4ee5\u964d\uff08\u6b63\u78ba\u306b\u306f5.7\u4ee5\u964d\uff09\u306eGIS\u95a2\u6570\u306f Boost::Geometry\u3068\u3044\u3046\u5c02\u9580\u5bb6\u306e\u3088\u3046\u306a\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u6d3b\u7528\u3057\u3066\u3001\u72ec\u81ea\u5b9f\u88c5\u3092\u907f\u3051\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3001\u3068\u3044\u3046\u3053\u3068\u3082\u304a\u4f1d\u3048\u3057\u7d9a\u3051\u3066\u304d\u307e\u3057\u305f\u3002\u30fb\u30fb\u30fb\u3053\u306e2\u3064\u306e\u60c5\u5831\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3068\u3001 \u300c Boost::Geometry\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u95a2\u6570\u3092\u547c\u3073\u51fa\u3059\u30b3\u30fc\u30c9\u3092\u66f8\u3051\u3070\u3001MySQL\u306b\u3082\u3069\u3093\u3069\u3093GIS\u95a2\u6570\u3092\u8ffd\u52a0\u3067\u304d\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u300d \u3068\u3044\u3046\u5fc5\u7136\u306b\u884c\u304d\u7740\u304d\u307e\u3059\u3002\u30fb\u30fb\u30fb\u3053\u308c\u306b\u6c17\u3065\u304f\u307e\u3067\u306b7\u5e74\u304b\u304b\u3063\u305f\u3002\u3002\u3002 \u3068\u3044\u3046\u3053\u3068\u3067\u3001Polyg\u2026","version":"1.0","blog_url":"https://sakaik.hateblo.jp/","blog_title":"sakaik\u306e\u65e5\u3005\u96d1\u611f\uff5e(T)\u7de8","title":"MySQL\u306b\u65b0\u305f\u306aGIS(Spatial)\u95a2\u6570 ST_Perimeter()\u3092\u5b9f\u88c5\u3059\u308b","provider_url":"https://hatena.blog","url":"https://sakaik.hateblo.jp/entry/20251223/new_mysql_gis_function_st_perimeter","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsakaik.hateblo.jp%2Fentry%2F20251223%2Fnew_mysql_gis_function_st_perimeter\" title=\"MySQL\u306b\u65b0\u305f\u306aGIS(Spatial)\u95a2\u6570 ST_Perimeter()\u3092\u5b9f\u88c5\u3059\u308b - sakaik\u306e\u65e5\u3005\u96d1\u611f\uff5e(T)\u7de8\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"sakaik","type":"rich","provider_name":"Hatena Blog","width":"100%"}