[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
3 New Spatial Shapes

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.