Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
-
Comments posted to this topic are about the item Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
-
The example is not correct !
I copied your scripts to my SQL2019 CU31 and executed them.
This is the result I get:
Johan
Learn 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/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Same on SQL Server 2022, CU15
-
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