Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Stations with coordinates out of bounds of the current CRS 4326 #15

Open
Piiit opened this issue Jan 28, 2021 · 0 comments
Open

Stations with coordinates out of bounds of the current CRS 4326 #15

Piiit opened this issue Jan 28, 2021 · 0 comments
Labels
bug Something isn't working prj:mobility

Comments

@Piiit
Copy link
Contributor

Piiit commented Jan 28, 2021

Find geometries with coordinates that do not belong in projection:

SELECT * FROM your_table WHERE 
  (st_x(geom) NOT BETWEEN -180 AND 180) 
  OR  
  (st_y(geom) NOT BETWEEN -90 AND 90) ;

We should check for those values and generate also some checks during INSERT statements.

https://stackoverflow.com/questions/42131056/find-geometries-with-coordinates-that-do-not-belong-in-projection

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working prj:mobility
Projects
None yet
Development

No branches or pull requests

1 participant