Skip to main content
9 events
when toggle format what by license comment
Jun 23, 2020 at 8:01 comment added GuiOm Clair @Taras I just did, and edited my question accordingly, but unfortunately it doesn't change anything. And the GROUP BY is a bit useless here since there are only two lines and only one point of intersection.
Jun 23, 2020 at 7:59 history edited GuiOm Clair CC BY-SA 4.0
Correction in code
Jun 23, 2020 at 7:24 history edited GuiOm Clair CC BY-SA 4.0
Added content
Jun 23, 2020 at 7:07 comment added GuiOm Clair @DrorBogin Indeed it is logical that only one geometry is returned. In my case let's say the black line is a border, and the red one the path an individual follows through time. I want to be able to count how many times the border was crossed. So even if the geometrical logic makes sense it doesn't meet my need.
Jun 22, 2020 at 15:48 history became hot network question
Jun 22, 2020 at 8:59 history edited Taras CC BY-SA 4.0
Title changed, Content structured, One tag added
Jun 22, 2020 at 8:52 comment added Dror Bogin Why wouldn't this return one geometry? the red line intersects twice but at the same point, so there is technically only one intersection.
Jun 22, 2020 at 8:49 answer added Taras timeline score: 5
Jun 22, 2020 at 7:45 history asked GuiOm Clair CC BY-SA 4.0