Guest User

Untitled

a guest
Jul 12th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  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
Add Comment
Please, Sign In to add comment