当前位置: 动力学知识库 > 问答 > 编程问答 >

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

问题描述:

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))'

网友答案:

See Spatial Extensions.

分享给朋友:
您可能感兴趣的文章:
随机阅读: