Skip to main content
Geographic Information Systems

Return to Answer

added 9 characters in body
Source Link
Brad Koch
Brad Koch
  • 475
  • 6
  • 24

There is no way to filter the query based on validity type via SQL. What you do have, due to the NOT ST_IsValid condition, is a pair of equal length ordered lists of invalid geometry notices and geometries.

These two lists can be manually correlated to identify which error each geometry suffers from. Filter out theany IllegalArgumentException, and other queries should be able to execute.

There is no way to filter the query based on validity type via SQL. What you do have, due to the NOT ST_IsValid condition, is a pair of equal length ordered lists of invalid geometry notices and geometries.

These two lists can be manually correlated to identify which error each suffers from. Filter out the IllegalArgumentException, and other queries should be able to execute.

There is no way to filter the query based on validity type via SQL. What you do have, due to the NOT ST_IsValid condition, is a pair of equal length ordered lists of invalid geometry notices and geometries.

These two lists can be manually correlated to identify which error each geometry suffers from. Filter out any IllegalArgumentException, and other queries should be able to execute.

Source Link
Brad Koch
Brad Koch
  • 475
  • 6
  • 24

There is no way to filter the query based on validity type via SQL. What you do have, due to the NOT ST_IsValid condition, is a pair of equal length ordered lists of invalid geometry notices and geometries.

These two lists can be manually correlated to identify which error each suffers from. Filter out the IllegalArgumentException, and other queries should be able to execute.