Timeline for PostGIS: ST_Union fails with valid polygons?
Current License: CC BY-SA 3.0
23 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 26 at 15:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 28 at 0:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 26 at 13:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 26, 2023 at 3:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 18, 2023 at 14:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 17, 2023 at 12:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 15, 2022 at 1:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 16, 2022 at 18:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 12, 2022 at 5:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 14, 2021 at 6:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 30, 2021 at 21:00 | history | tweeted | twitter.com/StackGIS/status/1432448062463647751 | ||
| Aug 30, 2021 at 15:29 | answer | added | GeoGyro | timeline score: 0 | |
| Feb 28, 2019 at 14:47 | comment | added | Theo F | Also having this issue. Huge polygon table, used ST_MAKEVALID to fix a number of self intersecting errors, then ran ST_ISVALID to see that there were no longer any errors. Then I ran ST_UNION and after a while it said that 'TopologyException: found non-noded intersection between LINESTRING....' | |
| May 1, 2017 at 21:16 | history | edited | Richard | CC BY-SA 3.0 |
added 1409 characters in body; edited title
|
| May 1, 2017 at 21:04 | comment | added | Richard |
@iant Thanks for posting the link. I'm struggling to understand the recommended solution - please could you elaborate a bit? Do I need to write my own version of ST_Union with exception handling?
|
|
| Apr 28, 2017 at 21:52 | comment | added | Richard |
Just tried SELECT ST_Union(ST_SnapToGrid(geom_simpler, 0.00001)) AS geom from usgovt WHERE gap_sts='2': also failed with non-noded intersection error. Any ideas (can't parse linked question), or is PostGIS just fundamentally broken in this respect?
|
|
| Apr 27, 2017 at 15:18 | comment | added | dbaston | @Richard: yes, it's possible to fail with valid input. The "non-noded intersection" refers to an error encountered during the union operations, not any condition in your data. | |
| Apr 27, 2017 at 14:19 | comment | added | Ian Turton | see gis.stackexchange.com/questions/50399/… | |
| Apr 27, 2017 at 14:17 | comment | added | Ian Turton | There's a difference between a valid line string and a valid input set for union. | |
| Apr 27, 2017 at 14:13 | comment | added | Richard |
Should it be possible for ST_Union to fail with valid input? Should I report this as a PostGIS bug?
|
|
| Apr 27, 2017 at 14:13 | history | edited | Richard | CC BY-SA 3.0 |
added 336 characters in body
|
| Apr 27, 2017 at 13:21 | comment | added | Ian Turton | because you have a non-noded intersection between two line strings. | |
| Apr 27, 2017 at 13:10 | history | asked | Richard | CC BY-SA 3.0 |