views:

21

answers:

0

What I need is to find all points away from rectangle for 10km. Points geometry is the_geom1, rectangles (polygon) geometry is the_geom2. SRID of them is 4258.

I tried:

SELECT * 
FROM table1,table2 
WHERE ST_DWithin(table1.the_geom1,table2.the_geom2,10000) 
      and table1.gid=2;

But the result is not Ok.