{"id":49008,"date":"2016-06-15T14:37:08","date_gmt":"2016-06-15T14:37:08","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/wp-spatial-capabilities-check\/"},"modified":"2017-03-04T16:12:31","modified_gmt":"2017-03-04T16:12:31","slug":"wp-spatial-capabilities-check","status":"publish","type":"plugin","link":"https:\/\/pcd.wordpress.org\/plugins\/wp-spatial-capabilities-check\/","author":195668,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.0.4","stable_tag":"0.0.4","tested":"4.7.33","requires":"3.0.1","requires_php":"","requires_plugins":"","header_name":"WP Spatial Capabilities Check","header_author":"Michael Moore","header_description":"","assets_banners_color":"8bcbe3","last_updated":"2017-03-04 16:12:31","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/cimbura.com\/contact-us\/make-a-payment\/","header_plugin_uri":"https:\/\/github.com\/cimburadotcom\/wp-spatial-capabilities-check","header_author_uri":"http:\/\/luminfire.com","rating":0,"author_block_rating":0,"active_installs":10,"downloads":1543,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"0.0.3":"<ul>\n<li>You probably don&#039;t have a version installed yet, so you should definately\ncheck out 0.0.3.<\/li>\n<\/ul>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":0},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":"1607862","resolution":"128x128","location":"assets"},"icon-256x256.png":{"filename":"icon-256x256.png","revision":"1607862","resolution":"256x256","location":"assets"}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":"1607862","resolution":"1544x500","location":"assets"},"banner-772x250.png":{"filename":"banner-772x250.png","revision":"1607862","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.0.3","0.0.4"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1437200","resolution":"1","location":"assets"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1437200","resolution":"2","location":"assets"}},"screenshots":{"1":"WP Spatial Capabilities Check shows an easy to read table listing spatial \nfunctions and if they're available with your current database.","2":"The tool can be found in the Dashboard under Tools::Spatial Capabilities."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[32039,26981,71056,1627,71055],"plugin_category":[49,59],"plugin_contributors":[132670,94603],"plugin_business_model":[],"class_list":["post-49008","plugin","type-plugin","status-publish","hentry","plugin_tags-geography","plugin_tags-gis","plugin_tags-mariadb","plugin_tags-mysql","plugin_tags-spatial","plugin_category-maps-and-location","plugin_category-utilities-and-tools","plugin_contributors-luminfire","plugin_contributors-stuporglue","plugin_committers-andywalz","plugin_committers-stuporglue"],"banners":{"banner":"https:\/\/ps.w.org\/wp-spatial-capabilities-check\/assets\/banner-772x250.png?rev=1607862","banner_2x":"https:\/\/ps.w.org\/wp-spatial-capabilities-check\/assets\/banner-1544x500.png?rev=1607862","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/wp-spatial-capabilities-check\/assets\/icon-128x128.png?rev=1607862","icon_2x":"https:\/\/ps.w.org\/wp-spatial-capabilities-check\/assets\/icon-256x256.png?rev=1607862","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/wp-spatial-capabilities-check\/assets\/screenshot-1.png?rev=1437200","caption":"WP Spatial Capabilities Check shows an easy to read table listing spatial \nfunctions and if they're available with your current database."},{"src":"https:\/\/ps.w.org\/wp-spatial-capabilities-check\/assets\/screenshot-2.png?rev=1437200","caption":"The tool can be found in the Dashboard under Tools::Spatial Capabilities."}],"raw_content":"<!--section=description-->\n<p>MySQL and MariaDB both have improved their spatial support in the last few years, but \nit's not always easy to track down which functions are available in which version.<\/p>\n\n<p>This tool will check which functions are actually available in your current MySQL or MariaDB database.<\/p>\n\n<p>Once you know what spatial functions are available you can use your database to do GIS right within WordPress.<\/p>\n\n<p>For more information on how to use these functions see the following resources:<\/p>\n\n<ul>\n<li><a href=\"http:\/\/wherepress.com\/\">WherePress.com - GIS for WordPress and MySQL<\/a><\/li>\n<li><a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb\/mysqlmariadb-spatial-support-matrix\/\">MySQL and MariaDB Spatial Support Matrix<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/cd\/E19957-01\/mysql-refman-5.4\/functions.html#spatial-extensions\">Spatial function reference for MySQL 5.4<\/a><\/li>\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/spatial-function-reference.html\">Spatial function reference for MySQL 5.5<\/a><\/li>\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/spatial-function-reference.html\">Spatial function reference for MySQL 5.6<\/a><\/li>\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/spatial-function-reference.html\">Spatial function reference for MySQL 5.7<\/a><\/li>\n<li><a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb\/gis-functionality\/\">Spatial function reference for MariaDB<\/a><\/li>\n<\/ul>\n\n<!--section=installation-->\n<p>Install this plugin the usual WordPress way, then go to your WordPress dashboard to Tools::Spatial Capabilities. It will\ndisplay a table with a list of all known spatial functions from MySQL and MariaDB along with a\nsimple 'Yes' or 'No', indicating if your install has that function.<\/p>\n\n<ol>\n<li>Upload the plugin files to the <code>\/wp-content\/plugins\/wp-spatial-capabilities-check<\/code> directory, or install the plugin through the WordPress plugins screen directly.<\/li>\n<li>Activate the plugin through the 'Plugins' screen in WordPress.<\/li>\n<li>Go to Tools::Spatial Capabilities to see what spatial functions you can use.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<p>No one has actually asked any questions yet.<\/p>\n<dl>\n<dt>Where can I get help with GIS and WordPress?<\/dt>\n<dd><p>For community support try <a href=\"http:\/\/WherePress.com\/\">WherePress.com<\/a>, or <a href=\"https:\/\/julien24.typeform.com\/to\/kGPqYr\">The Spatial Community<\/a>.<\/p>\n\n<p>For commercial support you can contact the plugin developer at <a href=\"https:\/\/cimbura.com\/contact-us\/project-request-form\/\">Cimbura.com<\/a><\/p>\n\n<p>For fast and short questions you can <a href=\"https:\/\/twitter.com\/stuporglue\">contact me<\/a> on twitter<\/p><\/dd>\n<dt>How can I add more spatial functions?<\/dt>\n<dd><p>Upgrade your database to at least MySQL 5.6.1 or MariaDB 5.3.3.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>0.0.4<\/h4>\n\n<ul>\n<li>Now uses WP-GeoMeta-Lib so that custom defined functions from other plugins\nget detected.<\/li>\n<\/ul>\n\n<h4>0.0.3<\/h4>\n\n<ul>\n<li>Use the WordPress plugin packaging standards<\/li>\n<\/ul>\n\n<h4>0.0.2<\/h4>\n\n<ul>\n<li>Internationalization<\/li>\n<li>WordPress coding standards compliance<\/li>\n<\/ul>\n\n<h4>0.0.1<\/h4>\n\n<ul>\n<li>Initial development and testing<\/li>\n<\/ul>","raw_excerpt":"Creates a page in the dashboard with a list of the spatial functions your database supports so you can do GIS with MySQL or MariaDB in WordPress.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/49008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=49008"}],"author":[{"embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/stuporglue"}],"wp:attachment":[{"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=49008"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=49008"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=49008"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=49008"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=49008"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pcd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=49008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}