如何在mysql中检查多边形的真lat/long

ep6jt1vc 于 2021-06-21 发布在 Mysql

关注(0)|答案(1)|浏览(294)

此查询没有结果：

select *
from provinces
 where ST_Contains(GeomFromText(CONCAT('POINT(',51.4, ' ', 37.2,')'),4326),polygon)

mysql spatial Polygon

来源：https://stackoverflow.com/questions/49979533/how-to-check-true-lat-long-in-polygon-in-mysql

1条答案

按热度按时间

wh6knrhe1#

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

赞(0）回复(0）举报 2021-06-21

我来回答

如何在mysql中检查多边形的真lat/long

1条答案

相关问题

热门标签

最新问答