See if lat / long falls within a polygon using mysql, there is any function now?

Go To StackoverFlow.com

0

I´m trying to know if '5.03529 -754368' is within the polygon, can you help me, how can I do that?

I see that the two fields have different formats, how can I fix this?

select within ('5.03529 -754368',PyPolygon) from manuelitapolygon

PyPolygon = 'POLYGON((5.035247876391217 -75.43594128570524,5.035158505114919 -75.43594598760016,5.03507011299693 -75.43596004176999,5.034983668480416 -75.43598329423428,5.0349001186705165 -75.43601549023417,5.034820378957751 -75.43605627702355,5.034745322988647 -75.436105207733864))'

2012-04-04 21:07
by cariberecord


-1

See Spatial Extensions.

2012-04-04 21:10
by Joey
Muchas gracias, señor Joey, Ahora Tengo Este select PyNombre,contains (PyPolygon, GeomFromText('Point(8.30941 -73.6010)')) from manuelitapolygon but if I have lat and long, how can I do that 'point(lat long)' don't wor - cariberecord 2012-04-10 14:44
Ads