Home Forums SQL Server 2008 T-SQL (SS2K8) geometry data type convert to longitude & latitude doesn't make sense RE: geometry data type convert to longitude & latitude doesn't make sense

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