Lokasi ngalangkungan proxy:   [ UP ]  
[Ngawartoskeun bug]   [Panyetelan cookie]                
Skip to content

spatial-data-sql-server.md

Latest commit

 

History

History
79 lines (55 loc) · 3.89 KB

spatial-data-sql-server.md

File metadata and controls

79 lines (55 loc) · 3.89 KB
title Spatial Data (SQL Server) | Microsoft Docs
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine, sql-database
ms.reviewer
ms.technology
ms.topic conceptual
helpviewer_keywords
geography data type [SQL Server], spatial storage design
planar spatial data [SQL Server], designing
spatial data types [SQL Server]
geodetic spatial data [SQL Server]
geometry data type [SQL Server], spatial storage design
spatial storage [SQL Server]
geodetic spatial data [SQL Server], designing
ms.assetid 41a132a1-09e2-4426-b9df-225270cb8e15
author MladjoA
ms.author mlandzic
manager craigg
monikerRange =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Spatial Data (SQL Server)

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md]

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, roads, or lakes.

[!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion].

Important

For a detailed description and examples of spatial features introduced in [!INCLUDEssSQL11], download the white paper, New Spatial Features in SQL Server 2012.

Related Tasks

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.

Related Content

Spatial Data Types Overview
Introduces the spatial data types.

Spatial Indexes Overview
Introduces spatial indexes and describes tessellation and tessellation schemes.