Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT path, st_astext(geom), st_x(geom) AS x, st_y(geom) AS y
- FROM
- (SELECT (st_dumppoints(geom)).*
- FROM countries
- WHERE ADMIN='Antarctica') AS d
- WHERE
- st_x(geom) < -180 OR
- st_x(geom) > 180 OR
- st_y(geom) < -90 OR
- st_y(geom) > 90;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement