mysql导出polygon乱码,如何使用PHP或MySQL检查地理编码是否接近或位于KML LineString中定义的路径上...

I have a KML file defining several paths/routes (representing actual roads) enclosed in the tags. Parsing the file to other formats (arrays/MySQL) is already in place, so that's not a problem.

Given a point (longitude/latitude) I would like to be able to check if the point is on or close to (within a few meters) one of the routes in the KML file. I've been looking for a solution in PHP, but I haven't been able to find one - and I'm not really sure, what I'm looking for. This does however seem to me like a common problem, so I suspect someone already solved the problem. Does anybody know of a solution? ;)

Thanks in advance!

解决方案

You need to break this down into two problems:

Generate a set of polygons from each section of your path.

Do a simple point in polygon test on the above polygons.

There should be some php out there to accomplish those two tasks.