Advertisement
Guest User

Untitled

a guest
Jul 28th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. 'INSERT INTO result_table SELECT ST_Value(rast, ST_GeomFromText(''POINT(' ||lon || ' ' ||lat||' )'',4326))) val FROM elevation WHERE ST_Intersects(rast,ST_GeomFromText(''POINT(' ||lon ||' '|| lat ||' )'',4326)))'
  2. 'INSERT INTO result_table SELECT name_0, name_1, nl_name_2 , name_0||name_1||nl_name_2 FROM world_city where ST_Contains(world_city.geom, ST_GeomFromText(''POINT('|| lon ||' ' || lat ||')'',4326));';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement