daily pastebin goal
47%
SHARE
TWEET

Untitled

a guest Jul 12th, 2018 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. select
  3.     st_distance(g.the_geom , st.the_geom) as distance_meters,
  4.     st_line_locate_point(st_linemerge(st.the_geom), g.the_geom) as fractions_2d_length,
  5.     st_m( st_line_interpolate_point(st.the_geom, st_line_locate_point(st.the_geom, g.the_geom))) as measured,
  6.     st.*, g.*
  7. from
  8.     streets_centerlines st,
  9.     fred_city_o6_da_centroids g
  10. where
  11.     --g.gid =
  12.     --AND
  13.     st.the_geom && ST_expand(g.the_geom, 2000)
  14. order by distance_meters
  15.  
  16. -- ERROR:  line_locate_point: 1st arg isnt a line
RAW Paste Data
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
 
Top