Timeline for Help to improve a function
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 14, 2017 at 22:04 | comment | added | Magno C |
ST_Union(geom) is an aggregate (like sum()) and must be applied to all rows. In the first run, geomRoute will receive a union of all geometries in the table and will represent a new geometry (a line). For now, think route_agg as a source of n rows of geometries in geom column. Then ST_Extent will give me the bounding box of this new line. The second route_agg will give me each line and search for points nearby. Because the points table planet_osm_point contains too much data, I must compute only points inside that box I created (routeBB && ST_Transform(pt.way,4326)).
|
|
| Feb 14, 2017 at 21:47 | history | edited | joanolo | CC BY-SA 3.0 |
added 90 characters in body
|
| Feb 14, 2017 at 21:41 | history | answered | joanolo | CC BY-SA 3.0 |