geometry data type convert to longitude & latitude doesn't make sense

  • 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?  

  • snomadj - Wednesday, January 24, 2018 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?  

    You are mixing geometry and geography, the first one is on a flat plane and the other models the earth....
    😎

  • 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.

  • 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