Spatial Data Type question

Last Post 29 Dec 2008 12:32 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

16 Dec 2008 04:18 PM
With SQL 2008 there are 2 new types of Spatial data types. Geometry and Geography, and both of these have what is called Tesselation Schemes. Now, I realize how Tessellation applies to the Geometry dara type, because they tend to be a series of aligned planar polygons in Euclidean math, but I'm still not sure even after reading BOL how Tessellation as i know it applies to the Geography type, which is much more ellipsoidal in nature. Could someone enlighten me? Thanks.
New Member
New Member

29 Dec 2008 12:32 AM
If you take the road map of Manhattan, you would still handle it as Euclidean plane with polygons, and disregard the curvature of the Earth.

However, if you need to locate the shortest distance for a plane to fly from NY to Chicago, you would have to take the curvature of the Earth into account, going the ellipsoid way as noted by your post.

Kalman Toth, SQL Server 2008 Training

Acceptable Use Policy