Just an FYI, Microsoft has updated its "Microsoft SQL Server CLR Types Serialization Formats [MS-SSCLRT] " document to include changes coming in SQL Server code-named Denali Community Technology Preview 1 (CTP1). The changes, called "Version 2", give a glimpse of some of the spatial issues Microsoft is trying to address with Denali.
- Changed type bixb0012 Tuesday, June 15, 2010 4:01 AM
Indeed! The most interesting parts for me, and I suspect many people will be the following:
"Serialization Properties : H(0x20): Geography is larger than a hemisphere. This bit is added in version 2 of the serialization format." (p11)
"OpenGIS Type . Version 2 adds the following valid values:
8 (0x08): CircularString
9 (0x09): CompoundCurve
10 (0x0A): CurvePolygon
11 (0x0B): FullGlobe" (p13)
Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
I'm playing with serialization of version 2 Denali CLR and have problems with understanding COMPOUNDCURVE. We have additional segments structure that should define a compound curve figure, but how it's related with points structure. Suppose we have an example 3.1.5 from [MS-SSCLRT] There we have 1 shape, 1 figure and 3 segments (first line, line, first arc). But compound curve has only two elements (line, circularstring). How should it be parsed to know which points should be used to compose a line and arc parts?
I'm not sure I quite understand the question - COMPOUNDCURVEs may contains both straight line and circular arc segments. In terms of WKT syntax, line segments are contained within round parentheses () , whereas circular arc segments are contained within round parentheses and preceded by the CIRCULARSTRING keyword.
See if this article helps at all: http://alastaira.wordpress.com/2011/02/02/the-compoundcurve-geometry-in-sql-server-11-denali/
twitter: @alastaira blog: http://alastaira.wordpress.com/