Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Find invalid postgis polygon (postgresql)
/*
Get ids of all invalid postgis polygon in the database
*/
SELECT id
FROM polygones
WHERE st_isvalid(polygone)=FALSE
ORDER BY id;
@thomaspoignant

This comment has been minimized.

Copy link
Owner Author

@thomaspoignant thomaspoignant commented Jul 12, 2018

Very usefull postgis request to detect invalid polygon in a postgresql database

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment