Latitude Longitude search from custom polygon MySQL

Question

So I have an issue. I am on GoDaddy shared hosting which is MySQL 5.5.43. They do not currently support MySQL 5.6 on shared hosting apparently.

Now my problem is I need to search a database of 50,000+ latlng points using a custom polygon created by the user. As I understand it, pre MySQL 5.6 only allowed bounding rectangle search. Am I stuck running the search in MySQL in a bounding rectangle and then checking those results against a PHP algorithm to see if they reside in the custom polygon?

score 1 · Answer 1 · edited May 23 '17 at 10:34

1

I'd create a user-defined function for that (see Adding a New User-Defined Function) using this or this

edited May 23 '17 at 10:34

Community

1
1

answered Sep 30 '16 at 17:03

Anatolii Suhanov

2,524
1
12
14

well done, two alternative approaches to the user function are supplied – JasonInVegas Sep 30 '16 at 17:13

Latitude Longitude search from custom polygon MySQL

1 Answers1