此查询未得到:
select *
from provinces
where ST_Contains(GeomFromText(CONCAT('POINT(',51.4, ' ', 37.2,')'),4326),polygon)
最佳答案
SELECT ea.entity_id,ea.latitude, ea.longitude ,c.name
from entity_addresses as ea
inner join cities as c on ST_CONTAINS(c.polygon,
ST_GeomFromText(ST_AsText(point(ea.longitude, ea.latitude)),
4326))
关于mysql - 如何在MySQL中检查多边形的真实纬度/经度,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/49979533/