Skip to content

Instantly share code, notes, and snippets.

@stepankuzmin

stepankuzmin/check.sql

Created February 26, 2018 09:54
Show Gist options
  • Save stepankuzmin/b1f0971457b9a28389a60aa6b1bbcd0b to your computer and use it in GitHub Desktop.
Save stepankuzmin/b1f0971457b9a28389a60aa6b1bbcd0b to your computer and use it in GitHub Desktop.
Download ZIP
PostGIS check 4326 geometry for bounds
Raw
check.sql
select
ST_XMax(geom),
ST_YMax(geom),
*
from gamma.cores_boundaries
where ST_XMax(geom) > 180 OR ST_XMax(geom) < -180 OR ST_YMax(geom) > 90 OR ST_YMax(geom) < -90;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment