{"id":3094,"date":"2013-06-03T02:44:00","date_gmt":"2013-06-03T00:44:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/"},"modified":"2013-06-03T02:44:00","modified_gmt":"2013-06-03T00:44:00","slug":"sql-server-2012-compoundcurve-a-new-geospatial-feature","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/","title":{"rendered":"SQL Server 2012: CompoundCurve &#8211; a new geospatial feature"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQLServer2012.jpg\" alt=\"\" \/><\/p>\n<p>There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun and as an example, I will test CompoundCurve, a set of circular strings that may be combined with line strings, and store a &#8220;dbi&#8221; character set in a table.:-D<\/p>\n<h3>What is CompoundCurve?<\/h3>\n<p>It&#8217;s a set of circular strings, or circular strings combined with line strings, that form a desired curved shape. The end point of each element in the collection must match the starting point of the following element, so that compound curves are defined in a \u201cconnect-the-dots\u201d fashion.<\/p>\n<p>To be valid it must meet the following criteria:<\/p>\n<ul>\n<li>It must contain at least one CircularString or LineString instance<\/li>\n<li>The sequence of CircularString or LineString instances must be continuous<\/li>\n<li>See <a href=\"http:\/\/msdn.microsoft.com\/fr-fr\/library\/ff929165.aspx\">msdn definition<\/a><\/li>\n<\/ul>\n<h3><\/h3>\n<h3>Creating a table to store the &#8220;dbi&#8221; character set<\/h3>\n<p>We have to create a simple geometry column table to store the &#8220;dbi&#8221; character set:<\/p>\n<p><span style=\"font-size: 11pt;line-height: 107%;font-family: 'Calibri','sans-serif'\"><a class=\"easyblog-thumb-preview\" title=\"Geometry-CreateTable.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-CreateTable.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-CreateTable.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-CreateTable.jpg\" alt=\"b2ap3_thumbnail_Geometry-CreateTable.jpg\" \/><\/a><\/span><\/p>\n<h3>Creating the &#8220;d&#8221;<\/h3>\n<p>The first step is to create the &#8220;d&#8221; from dbi. The &#8220;d&#8221; character is made of an arc and a line.<br \/>\nAn arc is defined with the command CircularString. For more information on CircularString, go to <a href=\"http:\/\/msdn.microsoft.com\/fr-fr\/library\/ff929141.aspx\">msdn reference<\/a><\/p>\n<p>Let&#8217;s define 3 points for the &#8220;d&#8221; arc:<\/p>\n<p><a title=\"Geometry-D-arc.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-D-arc.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-D-arc.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-D-arc.jpg\" alt=\"b2ap3_thumbnail_Geometry-D-arc.jpg\" \/><\/a><\/p>\n<p>The second is the line and I use the command LineString. For more information about LineString, go to <a href=\"http:\/\/msdn.microsoft.com\/fr-fr\/library\/bb895372.aspx\">msdn reference.<\/a><br \/>\nLet&#8217;s define 2 points for the &#8220;d&#8221; line:<\/p>\n<p><a title=\"Geometry-D-Line.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-D-Line.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-D-Line.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-D-Line.jpg\" alt=\"b2ap3_thumbnail_Geometry-D-Line.jpg\" \/><\/a><\/p>\n<p>To create the &#8220;d&#8221;, you have to add the 2 previous geometries with a STUnion option.<br \/>\nFor more information about STUnion, go to <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb933914(v=sql.110).aspx\">msdn reference.<\/a><\/p>\n<p><a title=\"Geometry-D-classique.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-D-classique.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-D-classique.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-D-classique.jpg\" alt=\"b2ap3_thumbnail_Geometry-D-classique.jpg\" \/><\/a><\/p>\n<p>This is a classical way to create a &#8220;d&#8221;, but in SQL server 2012, you can can use the CompoundCurve feature for this.<br \/>\nCompoundCurve is the combination of the features CircularString and LineString.<\/p>\n<p><a title=\"Geometry-D-compoundcurve.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-D-compoundcurve.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-D-compoundcurve.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-D-compoundcurve.jpg\" alt=\"b2ap3_thumbnail_Geometry-D-compoundcurve.jpg\" \/><\/a><\/p>\n<p>Notice that you don&#8217;t need to use the LineString command, it&#8217;s implied.<\/p>\n<h3>Creating the &#8220;b&#8221;<\/h3>\n<p>On the same principle, let&#8217;s create the &#8220;b&#8221; from dbi.<\/p>\n<p><a title=\"Geometry-B-compoundcurve.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-B-compoundcurve.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-B-compoundcurve.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-B-compoundcurve.jpg\" alt=\"b2ap3_thumbnail_Geometry-B-compoundcurve.jpg\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Creating the &#8220;i&#8221;<\/h3>\n<p>For the &#8220;i&#8221;, you needa simple point and the command LineString.<\/p>\n<p><a title=\"Geometry-I-point.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-I-point.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-I-point.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-I-point.jpg\" alt=\"b2ap3_thumbnail_Geometry-I-point.jpg\" \/><\/a><\/p>\n<p><a title=\"Geometry-I-Line.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-I-Line.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-I-Line.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-I-Line.jpg\" alt=\"b2ap3_thumbnail_Geometry-I-Line.jpg\" \/><\/a><\/p>\n<h3>Insert the &#8220;dbi&#8221; character set in the table<\/h3>\n<p>Now that you have created all geometries for the character set, you can concat all geometries with the STUnion feature and insert them in the table.<\/p>\n<p><a title=\"Geometry-insert.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-insert.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-insert.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-insert.jpg\" alt=\"b2ap3_thumbnail_Geometry-insert.jpg\" \/><\/a><\/p>\n<p>Finally, you can display the table with a simple select &#8211; and there is our &#8220;dbi&#8221; character set in the spatial result:<br \/>\n<a title=\"Geometry-table-select.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-table-select.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_Geometry-table-select.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/b2ap3_thumbnail_Geometry-table-select.jpg\" alt=\"b2ap3_thumbnail_Geometry-table-select.jpg\" \/><\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>It&#8217;s very easy to use the CompoundCurve features and it&#8217;s funny to play with geometrical features.<a title=\"Geometry-table-select.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Geometry-table-select.jpg\">\ud83d\ude00<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun and as an example, I will test CompoundCurve, a set of circular strings that may be combined with line strings, and store a &#8220;dbi&#8221; character set in a table.:-D What is CompoundCurve? It&#8217;s a set of circular&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":2132,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[49,54],"class_list":["post-3094","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-microsoft","tag-sql-server-2012"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2012: CompoundCurve - a new geospatial feature - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun, I will test CompoundCurve, a set of circular strings, and store a &quot;dbi&quot; character set in a table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2012: CompoundCurve - a new geospatial feature\" \/>\n<meta property=\"og:description\" content=\"There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun, I will test CompoundCurve, a set of circular strings, and store a &quot;dbi&quot; character set in a table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-03T00:44:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQLServer2012.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"126\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server 2012: CompoundCurve &#8211; a new geospatial feature\",\"datePublished\":\"2013-06-03T00:44:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/\"},\"wordCount\":414,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQLServer2012.jpg\",\"keywords\":[\"Microsoft\",\"SQL Server 2012\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/\",\"name\":\"SQL Server 2012: CompoundCurve - a new geospatial feature - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQLServer2012.jpg\",\"datePublished\":\"2013-06-03T00:44:00+00:00\",\"description\":\"There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun, I will test CompoundCurve, a set of circular strings, and store a \\\"dbi\\\" character set in a table.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQLServer2012.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_SQLServer2012.jpg\",\"width\":200,\"height\":126},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2012-compoundcurve-a-new-geospatial-feature\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2012: CompoundCurve &#8211; a new geospatial feature\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2012: CompoundCurve - a new geospatial feature - dbi services | Blog","description":"There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun, I will test CompoundCurve, a set of circular strings, and store a \"dbi\" character set in a table.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2012: CompoundCurve - a new geospatial feature","og_description":"There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun, I will test CompoundCurve, a set of circular strings, and store a \"dbi\" character set in a table.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2013-06-03T00:44:00+00:00","og_image":[{"width":200,"height":126,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQLServer2012.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server 2012: CompoundCurve &#8211; a new geospatial feature","datePublished":"2013-06-03T00:44:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/"},"wordCount":414,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQLServer2012.jpg","keywords":["Microsoft","SQL Server 2012"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/","name":"SQL Server 2012: CompoundCurve - a new geospatial feature - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQLServer2012.jpg","datePublished":"2013-06-03T00:44:00+00:00","description":"There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun, I will test CompoundCurve, a set of circular strings, and store a \"dbi\" character set in a table.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQLServer2012.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_SQLServer2012.jpg","width":200,"height":126},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2012-compoundcurve-a-new-geospatial-feature\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2012: CompoundCurve &#8211; a new geospatial feature"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3094"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3094\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2132"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}