Edit

Spatial Results Window

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

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.

See Also

View Spatial Data in Object Explorer
Spatial Data (SQL Server)
Database Engine Query Editor (SQL Server Management Studio)
Query and Text Editors (SQL Server Management Studio)