WP Spatial Capabilities Check

Find out what spatial functions your WordPress database supports.

MySQL and MariaDB both have improved their spatial support in the last few years, but it's not always easy to track down which functions are available in which version.

This tool will check which functions are actually available in your current MySQL or MariaDB database.

Instructions

Install this plugin, then go to your WordPress dashboard to Tools::Spatial Capabilities. It will display a table with a list of all known spatial functions from MySQL and MariaDB along with a simple 'Yes' or 'No', indicating if your install has that function.

Screenshots

WP Spatial Capabilities Check shows an easy to read table listing spatial functions and if they're available with your current database.

The tool can be found in the Dashboard under Tools::Spatial Capabilities.

More Spatial Help

For more information on how to use these functions see the following resources:

• MySQL and MariaDB Spatial Support Matrix
• Spatial function reference for MySQL 5.4
• Spatial function reference for MySQL 5.5
• Spatial function reference for MySQL 5.6
• Spatial function reference for MySQL 5.7
• Spatial function reference for MariaDB

Version History

0.0.4

• Now uses WP-GeoMeta-Lib so that custom defined functions from other plugins get detected.

0.0.3

• Use the WordPress plugin packaging standards

0.0.2

• Internationalization
• WordPress coding standards compliance

0.0.1

• Initial development and testing