Why are my buffered points oblong and not circle in SQL Server Management Studio - Spatial Results

About

Asked 30/10, 2013 at 20:21 Answered 30/10, 2013 at 20:21

Solved sql-server sql-server-2008-r2 sql-server-2012 spatial ssms

When I apply STBuffer(1) to a Point in SQL Server Spatial, they show up as an oblong circle, instead of a perfect circle. Why is this?

enter image description here

Amble answered 30/10, 2013 at 20:21 Comment(0)

The selected projection is Equirectangular, and not the more familiar Mercator that we see in Google Maps & Bing Maps. Change this and the points will show up as expected.

enter image description here

More information about map projection here: http://en.wikipedia.org/wiki/Map_projection

Amble answered 30/10, 2013 at 20:21 Comment(1)

To sum up the relevant part of the link: Projections can preserve either shape or relative size. They cannot preserve both. – Erastes 30/10, 2013 at 20:28

Hot tags

Godot Unity Godot Help Programming Godot 4.X GUI GDScript 3D 2D Physics CSharp Godot 3.X VR XR Projects C++

Recommended topics

Hot tags