none
Updated serialization formats for SQL Server code-named Denali CTP1

All replies

  • 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
    Tuesday, June 15, 2010 6:49 AM
    Answerer
  • Hi

    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?

    Regards

    Artur

    Friday, April 22, 2011 10:50 AM
  • Hi there,

    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/
    Friday, April 22, 2011 7:23 PM
    Answerer
  • Yes, it's easy when you have WKT, but what if you have only serialized data of geometry and need to create a shape based on MS-SSCLRT structure? Based on your article we have 'COMPOUNDCURVE((5 3, 5 13), CIRCULARSTRING(5 13, 7 15, 9 13), (9 13, 9 3), CIRCULARSTRING(9 3, 7 1, 5 3))'. Serialized data have Segments structure that defines the shape. But I don't know how to interpret it, how many points goes to each first line, line, first arc, arc.
    Saturday, April 23, 2011 10:55 AM