从Postgres中存储的OSM数据中按纬度和经度获取城市名称

我相信您会在坐标对中切换x和y。WGS84期望longitude, latitude，而不是相反：

SELECT name
FROM planet_osm_polygon
WHERE place = 'city'
AND ST_Contains(ST_Transform(way,4326), ST_SetSRID(ST_MakePoint(44.80,41.69),4326));

附带说明：考虑降低坐标的精度。有这么多的十进制数字，您正在进入显微镜领域->41.693459100461496

样本数据

CREATE TEMPORARY TABLE planet_osm_polygon (name TEXT, way GEOMETRY,place TEXT);
INSERT INTO planet_osm_polygon 
VALUES ('Georgia',ST_SetSRID('POLYGON((43.87 42.22,45.43 42.22,45.43 41.50,43.87 41.50,43.87 42.22))'::GEOMETRY,4289),'city');

坐标对应于SRS中的以下BBOX 4289：

查询-指向BBOX内，将BBOX和给定点设置为 WGS84

SELECT name
FROM planet_osm_polygon
WHERE place = 'city'
AND ST_Contains(ST_Transform(way,4326), ST_SetSRID(ST_MakePoint(44.80,41.69),4326));

  name   
---------
 Georgia
(1 Zeile)