{"id":6842,"date":"2020-06-07T11:58:35","date_gmt":"2020-06-07T02:58:35","guid":{"rendered":"https:\/\/a5m2.mmatsubara.com\/wp\/?p=6842"},"modified":"2020-06-07T11:58:35","modified_gmt":"2020-06-07T02:58:35","slug":"a5sql-mk-2-%e3%81%ae%e3%82%b8%e3%82%aa%e3%83%a1%e3%83%88%e3%83%aa%e5%af%be%e5%bf%9c","status":"publish","type":"post","link":"https:\/\/a5m2.mmatsubara.com\/wp\/?p=6842","title":{"rendered":"A5:SQL Mk-2 \u306e\u30b8\u30aa\u30e1\u30c8\u30ea\u5bfe\u5fdc"},"content":{"rendered":"\n<p>\u3053\u308c\u307e\u3067\u3001\u81ea\u5206\u306f\u300c\u30b8\u30aa\u30e1\u30c8\u30ea\u300d\u3068\u3044\u3046\u3082\u306e\u3092\u3088\u304f\u77e5\u3089\u306a\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u304a\u4ed5\u4e8b\u306e\u95a2\u4fc2\u4e0a\u3053\u308c\u304b\u3089\u30b8\u30aa\u30e1\u30c8\u30ea\u95a2\u9023\u3092\u3088\u304f\u6271\u3046\u3053\u3068\u306b\u306a\u308b\u306e\u3067\u3001A5:SQL Mk-2 \u306e\u30b8\u30aa\u30e1\u30c8\u30ea\u5bfe\u5fdc\u3055\u305b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3068\u308a\u3042\u3048\u305a\u3001PostgreSQL(PostGIS)\u306eGeometry\u578b\u5bfe\u5fdc\u3067\u3059\u3002<span class=\"has-inline-color has-cyan-bluish-gray-color\">\u2026\u306a\u3093\u304b\u6700\u8fd1\u306fMySQL\u3067\u3082\u30b8\u30aa\u30e1\u30c8\u30ea\u5bfe\u5fdc\u3057\u3066\u3044\u308b\uff1f\uff1f\uff1f\u3002<\/span><\/p>\n\n\n\n<p>Version 2.15.0\u51fa\u3057\u305f\u3070\u304b\u308a\u3067\u3059\u304c\u3001Version 2.15.1\u3067Geometry\u578b\u5bfe\u5fdc\u3092\u3061\u3087\u3063\u3068\u5165\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"860\" height=\"189\" src=\"https:\/\/a5m2.mmatsubara.com\/wp\/wp-content\/uploads\/2020\/06\/image-2.png\" alt=\"\" class=\"wp-image-6844\"\/><figcaption>\u2191 Version 2.15.0\u3067\u306f\u3053\u3093\u306a\u611f\u3058<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"923\" height=\"184\" src=\"https:\/\/a5m2.mmatsubara.com\/wp\/wp-content\/uploads\/2020\/06\/image-3.png\" alt=\"\" class=\"wp-image-6845\"\/><figcaption>\u2191 Version 2.15.1\u3067\u306f\u3053\u3093\u306a\u611f\u3058\uff08\u4e88\u5b9a\uff09<\/figcaption><\/figure>\n\n\n\n<p>Geometry\u578b\u306f\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u578b\u3068\u3057\u3066\u3001\u30d0\u30a4\u30ca\u30ea\u30c7\u30fc\u30bf\u578b\u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002\u3053\u306e\u307e\u307e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u3068\u3001OpenGIS\u306eWKB\u5f62\u5f0f(HEX\u8868\u73fe)\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u306e\u3067\u3059\u304c\u3001\u3053\u308c\u3092A5:SQL Mk-2\u5074\u3067\u89e3\u91c8\u3057\u3066OpenGIS \u306eEWKT\u5f62\u5f0f\uff08 ST_AsText() \u95a2\u6570\u3067\u5f97\u3089\u308c\u308b\u5f62\u5f0f\u2026\u591a\u5206\uff09\u3067\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u672c\u5f53\u306f\u3001\u5730\u56f3\u3082\u540c\u6642\u306b\u51fa\u305b\u308b\u3068\u3088\u3044\u306e\u3060\u3051\u308c\u3069\u3001\u305d\u308c\u306f\u3082\u3046\u5c11\u3057\u5f8c\u306b\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u308c\u307e\u3067\u3001\u81ea\u5206\u306f\u300c\u30b8\u30aa\u30e1\u30c8\u30ea\u300d\u3068\u3044\u3046\u3082\u306e\u3092\u3088\u304f\u77e5\u3089\u306a\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u304a\u4ed5\u4e8b\u306e\u95a2\u4fc2\u4e0a\u3053\u308c\u304b\u3089\u30b8\u30aa\u30e1\u30c8\u30ea\u95a2\u9023\u3092\u3088\u304f\u6271\u3046\u3053\u3068\u306b\u306a\u308b\u306e\u3067\u3001A5:SQL Mk-2 \u306e\u30b8\u30aa\u30e1\u30c8\u30ea\u5bfe\u5fdc\u3055\u305b\u3066\u3044\u304d\u307e\u3059\u3002 \u3068\u308a\u3042\u3048\u305a\u3001PostgreSQL &hellip; <a href=\"https:\/\/a5m2.mmatsubara.com\/wp\/?p=6842\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6842","post","type-post","status-publish","format-standard","hentry","category-1"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/6842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6842"}],"version-history":[{"count":1,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/6842\/revisions"}],"predecessor-version":[{"id":6846,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/6842\/revisions\/6846"}],"wp:attachment":[{"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a5m2.mmatsubara.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}