{"id":24351,"date":"2018-05-14T09:00:48","date_gmt":"2018-05-14T16:00:48","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=24351"},"modified":"2024-01-22T22:51:16","modified_gmt":"2024-01-23T06:51:16","slug":"visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/","title":{"rendered":"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1"},"content":{"rendered":"<p><em>This is a partner post authored with the <a href=\"https:\/\/www.tableau.com\/about\/blog\/visualize-spatial-data-directly-sql-server-tableau-20181-87377\">Tableau team.<\/a><\/em><\/p>\n<p>As part of Microsoft\u2019s open and flexible platform for data and analytics, we\u2019re always excited when partners add features that will expand customer options and extend business functionality. Business intelligence partner Tableau has recently introduced enhancements that will make it easier for their users to process spatial data stored in SQL Server.<\/p>\n<p>The SQL Server database engine has two spatial types \u2013 geometry and geography. The geography spatial type helps organize geospatial mapping data into SQL Server tables and works with several SQL-native graphing functions to answer questions like how far apart two geographic locations are, or what locations fall within a certain radius.<\/p>\n<p>Before, customers had to process geography spatial data stored in SQL Server into Shapefiles before they could access it from Tableau. Now with <a href=\"https:\/\/www.tableau.com\/2018-1-features#feature-80973\">Tableau 2018.1<\/a>, customers can connect to and visualize data stored in SQL Server directly. This means Tableau will recognize spatial data in your SQL Server tables without any intermediate steps, and customers can leverage <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/spatial\/create-construct-and-query-geography-instances?view=sql-server-2017\">spatial operations for geography supported by SQL Server<\/a> or custom queries to work with geographic data stored in SQL Server. Alongside support for native spatial data, Tableau 2018.1 also includes new RAWSQL functions that can leverage the spatial operations from the database and allow you to create calculations that return generated spatial objects.<\/p>\n<p>Here are some steps to try it out:<\/p>\n<h2>Get started with spatial data<\/h2>\n<p>Tableau will recognize if your table has a spatial field and allow you to utilize it, with no intermediary steps. Just drag and drop the geographic field to get started.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24354 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Connections.png\" alt=\"\" width=\"599\" height=\"326\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Connections.webp 599w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Connections-300x163.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Connections-330x180.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Connections-400x218.webp 400w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24357 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Marks.png\" alt=\"\" width=\"616\" height=\"278\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Marks.webp 616w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Marks-300x135.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Marks-330x149.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Marks-400x181.webp 400w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/p>\n<h2>Using spatial operations<\/h2>\n<p>Connections to SQL Server support Custom SQL queries. You can use a Custom SQL query to leverage operations supported by the database. Let\u2019s say you wanted to understand how many parks are located near schools. You could perform a proximity analysis using the query below to produce the following visualization. This query uses a spatial join based on a buffer of the schools\u2019 point geometry.<\/p>\n<pre>SELECT\r\nS.[common nam] as SchoolName,\r\nP.[common nam] as ParkName,\r\nS.geom.STBuffer(750) as circle_geom,\r\nP.[Geom] as park_geom\r\n\r\nFROM\r\nTestSpatial.dbo.seattleelementaryschools S\r\n\r\nLEFT JOIN\r\nTestSpatial.dbo.allseattleparks P\r\n\r\nON\r\nS.geom.STBuffer(750).STIntersects(P.geom) = 1<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24360 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/ParkName.png\" alt=\"\" width=\"510\" height=\"379\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/ParkName.webp 510w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/ParkName-300x223.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/ParkName-330x245.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/ParkName-400x297.webp 400w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/p>\n<p>Make the data dynamic by adding parameters to the query. You can also apply a buffer to the park geometries to make them more prominent and to create a polygon geometry that can be used in further analysis.<\/p>\n<pre>SELECT\r\nS.[common nam] as SchoolName,\r\nP.[common nam] as ParkName,\r\nS.geom.STBuffer(&lt;<strong>Parameters.Radius<\/strong>&gt;) as circle_geom,\r\nP.[Geom] as park_geom\r\n\r\nFROM\r\nTestSpatial.dbo.seattleelementaryschools S\r\n\r\nLEFT JOIN\r\nTestSpatial.dbo.allseattleparks P\r\n\r\nON\r\nS.geom.STBuffer(&lt;<strong>Parameters.Radius<\/strong>&gt;).STIntersects(P.geom.STBuffer(200)) = 1<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24363 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Edit-Parameter.png\" alt=\"\" width=\"572\" height=\"400\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Edit-Parameter.webp 572w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Edit-Parameter-300x210.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Edit-Parameter-330x231.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/Edit-Parameter-400x280.webp 400w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/p>\n<h2>Expand your analysis with RAWSQL<\/h2>\n<p>Support for SQL Server Spatial includes a new set of RAWSQL functions that are usable in calculations. RAWSQL functions allow you to pass values into a SQL statement where the query is executed when the calculated field is utilized within the worksheet. This means you can leverage the spatial operations supported by the database to generate a new spatial object. The calculation below returns the INTERSECTION of two spatial objects\u2014in this case, the school and park buffers. STIntersection is like a cookie-cutter operation. The resulting geometry will represent only the area that was shared by the two inputs.<\/p>\n<pre>RAWSQL_SPATIAL(\"Select %1.STIntersection(%2.STBuffer(200))\",[circle_geom], [park_geom])<\/pre>\n<p>You can\u00a0put buffered parks and the intersection results on a dual axis to produce a visualization that only shows the areas that overlap between the two fields.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24366 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/RAWSQL.gif\" alt=\"\" width=\"904\" height=\"468\" \/><\/p>\n<p>Join the <a href=\"https:\/\/prerelease.tableau.com\/welcome\/\">pre-release community<\/a> to test new geospatial features as they\u2019re released in beta. We\u2019re excited to see how you leverage this feature to create even more beautiful (and useful) maps!<\/p>\n<p>For more information on this feature, read up on <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/spatial\/create-construct-and-query-geography-instances?view=sql-server-2017\">SQL Server documentation for geography types<\/a> or visit the <a href=\"https:\/\/onlinehelp.tableau.com\/current\/pro\/desktop\/en-us\/help.htm#maps_spatial_sql.html\">Tableau Help page<\/a>. Learn about other features in the 2018.1 release on our <a href=\"https:\/\/www.tableau.com\/products\/new-features\">feature highlights<\/a> page.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a partner post authored with the Tableau team. As part of Microsoft\u2019s open and flexible platform for data and analytics, we\u2019re always excited when partners add features that will expand customer options and extend business functionality.<\/p>\n","protected":false},"author":1457,"featured_media":24487,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2391,5227,2406],"content-type":[2424],"topic":[2457,2466],"coauthors":[2487],"class_list":["post-24351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-sql-database","product-sql","product-sql-server-2017","content-type-best-practices","topic-data-analytics","topic-developer"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Visualize geographic spatial data from SQL Server directly in Tableau 2018.1 - Microsoft SQL Server Blog<\/title>\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.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This is a partner post authored with the Tableau team. As part of Microsoft\u2019s open and flexible platform for data and analytics, we\u2019re always excited when partners add features that will expand customer options and extend business functionality.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-14T16:00:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"280\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1\",\"datePublished\":\"2018-05-14T16:00:48+00:00\",\"dateModified\":\"2024-01-23T06:51:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/\"},\"wordCount\":581,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/\",\"name\":\"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png\",\"datePublished\":\"2018-05-14T16:00:48+00:00\",\"dateModified\":\"2024-01-23T06:51:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png\",\"width\":280,\"height\":180,\"caption\":\"a person using a laptop\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1 - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/","og_locale":"en_US","og_type":"article","og_title":"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1 - Microsoft SQL Server Blog","og_description":"This is a partner post authored with the Tableau team. As part of Microsoft\u2019s open and flexible platform for data and analytics, we\u2019re always excited when partners add features that will expand customer options and extend business functionality.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-05-14T16:00:48+00:00","article_modified_time":"2024-01-23T06:51:16+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1","datePublished":"2018-05-14T16:00:48+00:00","dateModified":"2024-01-23T06:51:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/"},"wordCount":581,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/","name":"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png","datePublished":"2018-05-14T16:00:48+00:00","dateModified":"2024-01-23T06:51:16+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-Server-Thumbnail_FY18_280x180_V7.png","width":280,"height":180,"caption":"a person using a laptop"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/14\/visualize-geographic-spatial-data-from-sql-server-directly-in-tableau-2018-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Visualize geographic spatial data from SQL Server directly in Tableau 2018.1"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=24351"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24351\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/24487"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=24351"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24351"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24351"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24351"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24351"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}