| title | Spatial Data (SQL Server) | |||||||
|---|---|---|---|---|---|---|---|---|
| description | Spatial data in the SQL Database Engine represents information about the physical location and shape of geometric objects. | |||||||
| author | WilliamDAssafMSFT | |||||||
| ms.author | wiassaf | |||||||
| ms.reviewer | mlandzic, jovanpop | |||||||
| ms.date | 11/04/2024 | |||||||
| ms.service | sql | |||||||
| ms.topic | concept-article | |||||||
| ms.custom |
|
|||||||
| helpviewer_keywords |
|
|||||||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Fabric SQL endpoint Fabric DW FabricSQLDB]
Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries/regions, roads, or lakes.
[!INCLUDE ssNoVersion] supports two spatial data types: the geometry data type and the geography data type.
-
The geometry type represents data in a Euclidean (flat) coordinate system.
-
The geography type represents data in a round-earth coordinate system.
Both data types are implemented as .NET common language runtime (CLR) data types in [!INCLUDE ssNoVersion].
In [!INCLUDE fabric-sqldb], geography and geometry data types are supported but cannot be mirrored to the Fabric OneLake.
Create, Construct, and Query geometry Instances
Describes the methods that you can use with instances of the geometry data type.
Create, Construct, and Query geography Instances
Describes the methods that you can use with instances of the geography data type.
Query Spatial Data for Nearest Neighbor
Describes the common query pattern that is used to find the closest spatial objects to a specific spatial object.
Create, Modify, and Drop Spatial Indexes
Provides information about creating, altering, and dropping a spatial index.
[!INCLUDE Spatial tools project information]