Re: [postgis-users] ST_Intersects

2017-03-17 Thread Giuseppe Broccolo
Hi Jonathan, 2017-03-17 13:18 GMT+01:00 Jonathan Moules : > Hi List, > I'm doing a simple ST_Intersects: > > select geom > from TABLENAME > where > ST_Intersects(geom, ST_GeomFromText('POLYGON((26 655000, 26 > 66, 27 66, 27 655000, 26 655000))', 27700)) > >

[postgis-users] ST_Intersects

2017-03-17 Thread Jonathan Moules
Hi List, I'm doing a simple ST_Intersects: select geom from TABLENAME where ST_Intersects(geom, ST_GeomFromText('POLYGON((26 655000, 26 66, 27 66, 27 655000, 26 655000))', 27700)) TABLENAME does have a spatial index. But this query is still taking an