Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT ON (t1.name) t1.gid,t1.name,t1.the_geom,t2.gid,t2.name,t2.the_geom
- FROM all_poi AS t1
- JOIN all_poi AS t2 ON ST_Dwithin(t1.the_geom,t2.the_geom,(0.005/111.111))
- WHERE t1.gid != t2.gid and t1.name=t2.name and t1.name like'%%'
- ORDER BY t1.name, t1.gid,t2.gid,t2.name,t2.the_geom;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement