Timeline for how to Find n nearest lines for the given points from a collection of lines?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2014 at 13:48 | comment | added | Kumar | Thanks buddy... It works. two changes I made, first renaming l.geom,p.geom as lgeom and pgeom and used it in the outer st_ClosestPoint function, then inside the with clause I added where clause with distance < 50km like. It works nice. Then what is the adv of <#> operator in searching nearby objects? | |
| Mar 7, 2014 at 13:42 | vote | accept | Kumar | ||
| Mar 7, 2014 at 11:27 | comment | added | simpleuser001 | indeed. using ST_DWithin() in index_query is only way i see to get it faster , but that adds limitations for usage. | |
| Mar 7, 2014 at 11:11 | history | answered | Nicklas Avén | CC BY-SA 3.0 |