I inserted couple of points using geography::STGeomFromText() method at lon, lat values of 180,90 and 180,-90. The points inserted at these locations are not visible in the spatial results tab. RRS feed

  • Question

  • Can someone let me know if this in some way is an expected behavior with Spatial results tab of SQL Server Management Studio? I feel it is a bug because points are visible at lon lat values of -180,90 and -180,-90. Why a problem only at these specified coordinates?
    Monday, January 2, 2012 12:28 PM

All replies

  • Hi Parthasarathi J,

    I will involve someone similar with this issue to have a look, and give your an update later. Thanks for your understanding.


    Stephanie Lv

    TechNet Community Support

    Thursday, January 5, 2012 10:30 AM
  • Longitude values of -180 and +180 are the same. Therefore, you'd expect the point plotted at (-180,90) to be shown the same as that at (180,90), and that's exactly what I get on the Spatial Results tab (using SQL2012 CTP3).

    Likewise, (-180,-90) gets plotted exactly the same as (180,-90)

    twitter: @alastaira blog: http://alastaira.wordpress.com/
    Thursday, January 5, 2012 11:31 AM