Re: [postgis-users] Check identical point

2010-05-22 Thread Nicklas Avén
Oh, I saw my own typo (forget the arguments for pointdistance3d). the query should be Select * from table1, table2 where table1.the_geom amp;amp;ST_Expand(table2.the_geom, 0.1) and table2.the_geom amp;amp; ST_Expand(table1.the_geom, 0.1) and pointdistance3d(table1.the_geom,

[postgis-users] Check identical point

2010-05-21 Thread eehab hamzeh
Hello I want to check if two points are identical, the points has x,y,z coordinates and they are not exactly the same, i need to check the intersection between them with tolerance value. any direction of how to do that. Thank kind regards

Re: [postgis-users] Check identical point

2010-05-21 Thread Francis Markham
Try: ST_DWithin(point1, point2, 0.1) -F 2010/5/22 eehab hamzeh eeha...@hotmail.com Hello I want to check if two points are identical, the points has x,y,z coordinates and they are not exactly the same, i need to check the intersection between them with tolerance value. any