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 ...