Advertisement
Guest User

Untitled

a guest
May 24th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. SELECT st_setsrid( ST_GeomFromText('LINESTRING(121.1527761
  2. 13.9413653,121.154058 13.9413113,121.1550161
  3. 13.9412372,121.1559079 13.9411891)') , 900913 );
  4.  
  5. SELECT ST_Transform( marks.way, 4326 ) as nearGeom, name
  6. FROM planet_osm_point AS marks;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement