Spatial Data Type question

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

--
16 Dec 2008 05: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.
SQLUSA
New Member
New Member

--
29 Dec 2008 01: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
http://www.sqlusa.com


Acceptable Use Policy
---