{"id":25320,"date":"2018-07-02T18:54:26","date_gmt":"2018-07-02T09:54:26","guid":{"rendered":"https:\/\/jirak.net\/wp\/upgrading-to-mysql-8-0-with-spatial-data\/"},"modified":"2018-07-02T19:35:06","modified_gmt":"2018-07-02T10:35:06","slug":"upgrading-to-mysql-8-0-with-spatial-data","status":"publish","type":"post","link":"https:\/\/jirak.net\/wp\/upgrading-to-mysql-8-0-with-spatial-data\/","title":{"rendered":"Upgrading to MySQL 8.0 with Spatial Data"},"content":{"rendered":"<p>Upgrading to MySQL 8.0 with Spatial Data<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/jirak.net\/wp\/wp-content\/uploads\/2018\/07\/adventure-ancient-antique-697662_3000x1997-1024x682.jpg\" width=\"1024\" height=\"682\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-10632\" src=\"https:\/\/mysqlserverteam.com\/wp-content\/uploads\/2018\/05\/adventure-ancient-antique-697662_3000x1997-1024x682.jpg\" alt=\"\" width=\"604\" height=\"402\" \/><\/p>\n<p>The big change from MySQL 5.7 to 8.0 when it comes to spatial data, is the support for multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs are ignored, and all computations are Cartesian.&hellip;<\/p>\n<p>Source: <a href=\"https:\/\/mysqlserverteam.com\/upgrading-to-mysql-8-0-with-spatial-data\/\" target=\"_blank\">Upgrading to MySQL 8.0 with Spatial Data<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Upgrading to MySQL 8.0 with Spatial Data The big change from MySQL 5.7 to 8.0 when it comes to spatial data, is the support for multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs are ignored, and all computations are Cartesian.&hellip; Source: Upgrading to MySQL 8.0 with Spatial Data<\/p>\n<\/div>","protected":false},"author":1,"featured_media":25321,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[169],"tags":[498],"class_list":["post-25320","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","tag-mysql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/25320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/comments?post=25320"}],"version-history":[{"count":1,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/25320\/revisions"}],"predecessor-version":[{"id":25322,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/25320\/revisions\/25322"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media\/25321"}],"wp:attachment":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media?parent=25320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/categories?post=25320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/tags?post=25320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}