Apologies in advance if this is the wrong forum for this. When solving Challenge 137 I noticed something strange about ST_Intersects. I created two fields after ST_Intersects didn't give me what I expected:
ST_Intersects([LineToSplicePoint],[WaterBoundary])
ST_Intersection([LineToSplicePoint],[WaterBoundary])
I expected the first one to give False values when the second one gave Nulls, to show that the two shape objects did not intersect. However this wasn't the case.
Perhaps someone could explain what I did wrong. And if I didn't do anything wrong then perhaps the developers could look into it?
Please let me know if there is a better forum for this type of question.
Thanks
The input of the formula is two points. which will not intersect anyway.
We need to create Sptial objects in order for the formula to work. below is my old one.
ST_IntersectsST_Intersects(object1, object2...): Returns True if the spatial objects intersect (Boolean value)
Thanks for trying @Qiu but this can't be the answer. The input in the formula is not two points.
I have put in a Line and a Polygon, not two points. The formula detects the intersection in some cases, but it is the inconsistency with the ST_Intersection function that is the issue. False results should line up with the Null results below, which they sometimes do but not every time.
See screenshots below
This seems like a question for the legendary @Hollingsworth or @MarqueeCrew who both know spatial backwards.
.lortnoc-fles ym rof ssendoog knahT .sdrawkcab noitseuq siht rewsna ot em rof saw ti gnitpmet woh hO
Take a look at this picture!
The data preview for [CrossWater - String] shows a value of 0, yet it returns 1 in the output.
The data preview for [CrossWater - Bool] shows a value of False, yet it returns True in the output.
Both data preview and output show Null for the actual Intersection.
This looks like a bug to me.
Cheers,
Mark
@MarqueeCrew @SeanAdams Thanks for confirming it's a bug. Glad it's not just me going mad!
Cheers
James
just a reminder that those two conditions are not mutually exclusive of each other.
cheers,
mark