Answer the question
In order to leave comments, you need to log in
Why can't I get data from postgis by coordinates?
Postgres 9.3, database based on data from openstreetmap, trying to get data by coordinates, but an empty response is returned, tried to give data from other coordinate systems, which leads to an error, what could be wrong in the request?
SELECT * FROM planet_osm_polygon
WHERE st_within(ST_MakePoint(37.601675181742, 55.750958697655), way);
Answer the question
In order to leave comments, you need to log in
The documentation clearly states that projections for geometries must be specified, i.e. ST_SetSRID, plus they must be the same. And you have one WGS84, and the other (by default) PseudoMercator.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question