Polygon object support in Backand with an external MySQL

Question

I saw a blog post that announced recent filtering support directly through Backand for MySQL points. However, my existing mysql database makes use of the Polygon types as I need to define areas that are more than circular.

At the moment, the Backand syncs the row with a type of String. Is there any way to retrieve my Point objects through the API? Is it possible to decode/encode the strings back into a MySQL Polygon object?

Thank you.

Answer 1

You can always use Backand's Query with SQL syntax (the default is NoSQL) to use all the MySQL geo functionality. You can query ST_Distance, ST_Within and get the individual coordinates of the polygon. Here is a link how to get them how to access multipolygon coordinates in mysql Here is a link how to use MySQL for geo apps https://www.percona.com/blog/2013/10/21/using-the-new-mysql-spatial-functions-5-6-for-geo-enabled-applications/ To add parameters to your query, add them to the parameters input (comma delimited) and use them with the anchor icon, see the image below. In the left side of the screen, you get how to call it with angularjs $http syntax.

Answer 2

To add to @relly 's answer, I created a custom query and returned the polygon column as text, making sure to cast the column name to something that doesn't contain brackets using 'as'.