此查询没有结果:
select * from provinces where ST_Contains(GeomFromText(CONCAT('POINT(',51.4, ' ', 37.2,')'),4326),polygon)
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))
1条答案
按热度按时间wh6knrhe1#