Spatial Data Support in SSMS
When querying spatial data in SSMS, you’ll find that SSMS has a built-in capability to plot and display some basic maps of your spatial data.
To demonstrate this, you can run the following query in the AdventureWorks2012
database in SSMS:
select SpatialLocation from person.Address a inner join person.StateProvince sp on a.StateProvinceID = sp.StateProvinceID and sp.CountryRegionCode = 'US'
After the query runs, you should see a Spatial Results tab next to the Results tab (see Figure 44.1). Click this tab, and the location points are plotted on a map. Select the Bonne Projection. If you look closely, you can see that the geographic points plotted roughly provide ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.