API tools faq
paste
Guest User

Untitled

a guest
Jun 22nd, 2018
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.01 KB | None | 0 0
raw download clone embed print report
  1. osm=> SELECT osm_id,(SUM_AGG(elev))[1] FROM ( SELECT * FROM ( SELECT elev,planet.osm_id,ST_Length(planet.way)*ST_Line_Locate_Point(planet.way,(ST_Dump(ST_Intersection(planet.way,the_geom))).geom) As dist FROM contour, ( SELECT * FROM planet_osm_line WHERE marked_trail_red='yes' LIMIT 1 ) AS planet WHERE ST_Intersects(the_geom,planet.way) ) As f ORDER BY dist ) AS f GROUP BY f.osm_id; NOTICE: New 0 660
  2. NOTICE: New 10 670
  3. NOTICE: New 10 670
  4. NOTICE: New 10 670
  5. NOTICE: New 10 670
  6. NOTICE: New 10 660
  7. NOTICE: New 10 650
  8. NOTICE: New 10 650
  9. NOTICE: New 10 650
  10. NOTICE: New 10 650
  11. NOTICE: New 20 660
  12. osm_id | sum_agg
  13. -----------+---------
  14. 124882874 | 20
  15. (1 row)
  16.  
  17. osm=>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!