3 New Spatial Shapes.

Applies to: SQL Server 2012, SQL Server 2014.

SQL Server 2012 introduced 3 new spatial shapes: CircularString, CompoundCurve and CurvePolygon.

A CircularString is a shape formed by one or more circular arc segments. A circular arc segment is formed of at least 3 points.

A CompoundCurve is a curved shape formed of one or more circulastrings or linestrings sections.

A CurvePolygon is a closed surface formed by a closed line, which can be created using a CircularString or a CompoundCurve.

The following scripts shows examples of how to use these new shapes:

-- Example of CircularString shape
DECLARE @g1 geometry = 'CIRCULARSTRING(2 0, 1 1, 0 0)';
SELECT @g1.STIsValid() 'Is this a valid CircularString?';

-- Example of a closed CircularString shape
DECLARE @g2 geometry = 'CIRCULARSTRING(2 0, 1 1, 0 0, 1 -1, 2 0)';
SELECT @g2.STIsValid() 'Is this a valid CircularString?';

-- Example of COMPOUNDCURVE
DECLARE @g3 geography = 'COMPOUNDCURVE(CIRCULARSTRING(2 0, 1 1, 0 0),
CIRCULARSTRING(0 0, 1 -1, 2 0))'
SELECT @g3.STIsValid() 'Is this a valid CompoundCurve?';

-- Example of CurvePolygon
DECLARE @g4 geography = 'CURVEPOLYGON(CIRCULARSTRING(3 5, 5 7, 6 9, 9 5, 3 5))'
SELECT @g4.STIsValid() 'Is this a valid CurvePolygon?';

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.