Advertisement
Guest User

Coordinate values are out of range [-180 -90, 180 90]

a guest
Mar 10th, 2012
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. SELECT path, st_astext(geom), st_x(geom) AS x, st_y(geom) AS y
  2. FROM
  3.     (SELECT (st_dumppoints(geom)).*
  4.      FROM countries
  5.      WHERE ADMIN='Antarctica') AS d
  6. WHERE
  7.     st_x(geom) < -180 OR
  8.     st_x(geom) > 180 OR
  9.     st_y(geom) < -90 OR
  10.     st_y(geom) > 90;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement