January 24, 2018 at 5:00 am
This isn't a biggie but it's bugging me so any input appreciated.
I have a valid GEOMETRY value.
I run:
SELECT @myGeoVal.STX AS longitude
It outputs -222222.222222222
Not all in twos but you get the gist. My question is:
Why so many numbers! I thought the max longitude would be 90 non?
January 24, 2018 at 5:14 am
snomadj - Wednesday, January 24, 2018 5:00 AMThis isn't a biggie but it's bugging me so any input appreciated.I have a valid GEOMETRY value.
I run:
SELECT @myGeoVal.STX AS longitudeIt outputs -222222.222222222
Not all in twos but you get the gist. My question is:
Why so many numbers! I thought the max longitude would be 90 non?
You are mixing geometry and geography, the first one is on a flat plane and the other models the earth....
😎
January 24, 2018 at 6:17 am
Bugger. I will get back to the drawing board. Cheers for the reply. All this spatial stuff is a brave new world for me atm.
January 24, 2018 at 8:14 am
You are welcome!
😎
Alastair Aitchison has written some books on the subject, worth the reading.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply