Abhinay Malipeddi
SSC Enthusiast
Points: 190
More actions
March 3, 2025 at 12:00 am
#4540580
Comments posted to this topic are about the item Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
Johan Bijnens
SSC Guru
Points: 135602
March 3, 2025 at 8:52 am
#4549840
The example is not correct !
I copied your scripts to my SQL2019 CU31 and executed them.
This is the result I get:
JohanLearn to play, play to learn !
Dont drive faster than your guardian angel can fly ...but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
sjonesdkr
SSC Rookie
Points: 40
March 5, 2025 at 4:20 pm
#4551878
Same on SQL Server 2022, CU15
david.jamieson
Valued Member
Points: 68
March 13, 2025 at 4:35 pm
#4558864
Reverse the co-ordinates for the POLYGON. Should be -95.50 37.80,-95.40 37.50 ect. As is, it's including everything outside the shape.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply