This topic has not yet been rated - Rate this topic

Spatial Results Window

SQL Server 2012

The Spatial results window provides visual mapping tools for viewing spatial data. To view spatial results, your query results must include a spatial column with either geometry or geography data.

Note
The Spatial results window is only available if your results are returned to a grid in the Results window. If you specify that your results are returned as text, this window is not available.

Options

Select spatial column

Specify the spatial column you want to view from the spatial columns in the query results. Only one column can be selected at a time.

Select label column

Specify the non-spatial column from the columns returned in the query results to label the spatial data. Only one column can be selected at a time.

This option is not available when only point instances are returned in a query.

Select projection

Display geography data in one of four projections: Equirectangular, Mercator, Robinson, or Bonne.

This option is not available for geometry data.

Zoom

Adjust the map display on an exponential scale.

Show grid lines

Toggle coordinate gridlines on or off.

For polygon shapes, the label is displayed only when the shape is large enough to hold the label text. To display labels for small shapes, adjust the zoom.

Note
Point instances cannot be labeled.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Spatial Results Window

Tasks

Reference

Concepts

Other Resources

Community Additions