Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- '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)))'
- '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