New answers tagged

4

You want to use ST_DWithin() which takes advantage of indexing SELECT * FROM adresse WHERE ST_DWithin(latlong::geography, ST_SetSRID(ST_Point(16.520, 47.846), 4326)::geography, 200) ORDER BY ST_Distance(latlong::geography, ST_SetSRID(ST_Point(16.520, 47.846), 4326)::geography); See also http://postgis.net/2013/08/26/tip_ST_DWithin/


0

I believe the number that you'd want to use at this point would be srid 4619 or srid 4977 is SQL server. These are both equivalent to EPSG 3011.



Top 50 recent answers are included