Timeline for Finding points 100 miles outside county using PostGIS?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 6, 2016 at 15:27 | history | edited | amball | CC BY-SA 3.0 |
referenced comment
|
| Oct 6, 2016 at 13:29 | comment | added | Paul Ramsey | All these ST_Transform() nested in the ST_DWithin() mean you're probably getting no help at all from the spatial index, which is built on the bare column. Either transform your data to the working projection in the table itself, or build a functional index on ST_Transform(). | |
| Oct 5, 2016 at 20:04 | comment | added | amball |
within() should work, but a cleaner way to do it is WHERE ST_DWithin(ST_Transform(tw.location,26986), ST_Transform(ce.geom,26986), 160934)
|
|
| Oct 5, 2016 at 17:48 | vote | accept | user3716774 | ||
| Oct 5, 2016 at 17:36 | comment | added | user3716774 |
Oh! no wonder why the running time of buffer was so long! Thank you very much! And by the way, the way I use within() was correct for finding points outside the county right? Make it equal to false and set the name to the county.
|
|
| Oct 5, 2016 at 17:28 | history | answered | amball | CC BY-SA 3.0 |