[postgis-users] A faster way to find "adjacent" polygons

Mr. Puneet Kishor punk.kish at gmail.com
Wed Jan 4 07:51:08 PST 2012


On Jan 4, 2012, at 9:48 AM, Andy Colson wrote:

> SELECT *
> FROM polygons p1
> JOIN polygons p2 ON p1.id < p2.id
> AND ST_Buffer(p1.geog, 50) && ST_Buffer(p2.geog, 50)
> WHERE ST_DWithin(p1.geog, p2.geog, 100, false)



Hmmmm... never saw the use of AND in the JOIN clause as above. I am assuming that works, and if so, that is pretty neat.

--
What else did I miss while I was sleeping


More information about the postgis-users mailing list