SQL Server 2008 Katmai Spatial new data type

[Megistal]

Can someone can provide me with additional informations about that new data type named "spatial" plz? (and links to article)

Any information will be appreciated.

At the moment, only that information I was able to get my hands on:
http://www.microsoft.com/sql/prodinf...n/default.mspx

Thks

[mendhak]

What the name implies. It's related to coordinates. There's two "common" types of spatial data, one is for flat or planar surfaces, and one is for the "real" world, for example involving the transformation of the planar coordinates into those involving curved space-time (the shortest path between two points on planet Earth is a curved line).

If SQL 2008 stores such data, it will help in calculations of, for example, distances between two points, finding paths on maps, etc.

[Megistal]

Thanks for your information mendhak still I'm starving to know more about that type

Like how can it be used (like you said, on a planar or curved surface)
What can we do with it
How it is implemented
What are the function supported on that data type
What is the precision

I guess I'll have to wait for M$ to know more about that.

[mendhak]

Like how can it be used (like you said, on a planar or curved surface)

Think of maps. Google maps and other mapping applications.

What can we do with it

uhm... think of maps.

How it is implemented

If you think in terms of OOP, it's most likely an object created within SQL Server's native code with its own set of methods and procedures. On the inside, the basic guts, it's most likely nothing but a structure, holding, say, 3 integers.

What are the function supported on that data type

Dunno.

What is the precision

Dunno

I guess I'll have to wait for M$ to know more about that.

Definitely.

[superbovine]

Sounds like MS is trying to make a move on the GIS market. Although, the only GIS implementation I have seen are on POSTGRE and SQL server.