Microsoft SQL Server/Geospatial Data: Difference between revisions
Jump to navigation
Jump to search
| [unreviewed revision] | [unreviewed revision] |
Content deleted Content added
| Line 38: | Line 38: | ||
*Directions Magazine's interview with Ed Katibah [http://www.directionsmag.com/editorials.php?article_id=2477&trv=1] |
*Directions Magazine's interview with Ed Katibah [http://www.directionsmag.com/editorials.php?article_id=2477&trv=1] |
||
*Isaac Kunen's Blog [http://blogs.msdn.com/isaac/archive/2007/05/29/one-type-two-types.aspx] |
|||
*Microsoft.com [http://www.microsoft.com/sql/2008/default.mspx] |
|||
Revision as of 20:43, 16 December 2007
Introduction
Microsofts 2008 release of SQL Server finally delivers Geospatial support to the SQL Server product suite. Currently in pre-release phase the spatial abilities of SQL Sever 2008 can be seen in the "Microsoft SQL Server 2008 CTP, November 2007" release of the software from Microsoft's website.
This allows the storage of spatial data in SQL tables (in the form of points, lines and polygons) and a set of functions to allow the manipulation of this data. Also included are new spatial indexes to support the execution of these functions.
Geospatial Data Types
SQL Server 2008 suupports two different spatial data types: GEOMETRY and GEOGRAPHY.
- GEOMETRY - This data type stores data in projected planar surfaces.
- GEOGRAPHY - This data type stores data in an ellipsoidal model.
Geospatial SQL functions
- STRelate
- STDisjoint
- STIntersects
- STTouches
- STCrosses
- STWithin
- STContains
- STOverlaps
- STBuffer
- STConvexHull
- STIntersection
- STUnion
- STGeomFromText
- STPointFromText
- STLineFromText
- STPolyFromText
- STGeomFromWKB
- STPointFromWKB
- STLineFromWKB
- STPolyFromWKB