Support graphical visualization for geospatial data in query results like SSMS

microsoft / vscode-mssql

Visual Studio Code SQL Server extension.

Other

1.53k stars 456 forks source link

Support graphical visualization for geospatial data in query results like SSMS #825

Open sanagama opened 7 years ago

sanagama commented 7 years ago

MSSQL Extension Version: 0.3.0
VSCode Version: 1.11.2
OS Version: macOS Sierra 10.12.4

Steps to Reproduce:

Type the following query in the SQL editor and execute against SQL Server (I tried with SQL 2016): DECLARE @g geometry; SET @g = geometry::STGeomFromText('CIRCULARSTRING(2 0, 1 1, 0 0)', 0); select @g

Result: the results window shows a column with binary data Desired/Expected: graphical visualization for geometry/geography data in results window, similar to SSMS

kburtram commented 7 years ago

Marking this is blocked since we need SQLCLR support in .Net Core before we can implement this feature.