Dear Remi,
Many thanks for your reply - makes it much more clear. I actually managed
to solve the issue by a table join following the sql query.
Thanks again
/Manuel
On Mon, Mar 9, 2015 at 11:03 PM, Rémi Cura remi.c...@gmail.com wrote:
Hey,
this is more a postgres/SQL question.
Anyway
Hey,
this is more a postgres/SQL question.
Anyway
SELECT a.gid, b.gid, st_shortestline(a.geom,b.geom),
ST_Distance(a.geom,b.geom) AS distance
FROM test.nfanwood AS a, test.nfanwood AS b
WHERE ST_DWithin(a.geom,b.geom,2000) = TRUE
The syntax is :
SELECT choose what you see as final result
Hi,
I have found following SQL query for measuring distances between polygon
edges:
select a.gid from_gid, b.gid to_gid, st_shortestline(a.geom,b.geom),
st_distance(a.geom,b.geom) as distance
from
test.nfanwood as a,
(select * from test.nfanwood) as b
where st_dwithin(a.geom,b.geom,2000)