SQL Server Spatial¶
Use Microsoft SQL Server Spatial to map geometry/geography data from SQL Server.
Goal¶
Configure a map that uses the SQL Server Spatial source.
Prerequisites¶
- A map element is on the canvas
- Required connections exist in Connection Manager (when applicable)
Steps¶
- Create a SQL Server connection.
- Set the map source to Microsoft SQL Server Spatial.
- Select the connection and configure spatial SQL.
- Set extent and symbology.
- Preview.
[ Screenshot: SQL Server Spatial map configuration ]
Result¶
Preview renders features from the SQL Server Spatial source inside the map frame.
Tips¶
Tip
Match the spatial type (geometry vs geography) expected by your tables.