SQL Server中的空间SQL数据类型

空间数据类型 (Spatial data type)

SQL server furnishes us with the geometry and geography SQL data types for conserving spatial data, which allows us to render graphical data. To be more specific, it is beneficial for creating, analyzing, comparing and retrieving spatial data.

SQL Server为我们提供了几何和地理SQL数据类型，以保存空间数据，这使我们可以呈现图形数据。 更具体地说，它对于创建，分析，比较和检索空间数据是有益的。

This article will start with the definition of spatial data, with relevant examples. In addition, I’ll discuss the definition of spatial data types and detail elaboration of Spatial Data Objects and Draw spellbinding Objects. I will also explain, what the differences are between geometry and geography SQL Data Types.

本文将从空间数据的定义开始，并提供相关示例。 此外，我将讨论空间数据类型的定义以及空间数据对象和Draw绑定对象的详细说明。 我还将解释几何和地理SQL数据类型之间的区别是什么。

什么是空间数据？ (What is spatial data?)

Spatial data, also known as geospatial data, is a particular type of information about either the physical object or physical location of data that can be constituted by numerical values in geographic collaborate systems.

空间数据，也称为地理空间数据，是有关可以由地理协作系统中的数值构成的数据的物理对象或物理位置的一种特殊类型的信息。

Generally, the use of spatial data is for representing the location, size, and shape of an object on planet Earth such as a mountain, lake, flat ground, township or so forth. On the top of that, spatial data may include attributes which can be given more information of the entity that is being represented.

通常，使用空间数据来表示物体在地球上的位置，大小和形状，例如山脉，湖泊，平坦的地面，城镇等。 最重要的是，空间数据可以包括属性，可以为这些属性提供更多有关所表示实体的信息。

Geographic Information Systems (GIS) or other specialized software applications should be appropriate to access, manipulate, visualize and dip analyze geospatial data.

地理信息系统（GIS）或其他专用软件应用程序应适合访问，操纵，可视化和浸入分析地理空间数据。

空间SQL数据类型 (Spatial SQL data types)

There are two major supported data-type is SQL server namely geometry data type and geography data type.

SQL Server支持两种主要的数据类型，即几何数据类型和地理数据类型。

1. Geometry spatial data type 几何空间数据类型

   It is substantially a two-dimensional rendering of an object and also useful in case of represented as points on a planar, or flat-earth data. A good example of it is (10, 2) where the first number ‘10’ identifies that point’s position on the horizontal (x) axis and the number ‘2’ represents the point’s position on the vertical axis (y). A common use case of the Geometry type is for a three-dimensional object, such as a building

   它实质上是对象的二维渲染，并且在表示为平面或平地数据上的点的情况下也很有用。 一个很好的例子是（10，2），其中第一个数字“ 10”表示该点在水平（x）轴上的位置，数字“ 2”表示该点在垂直轴（y）上的位置。 几何类型的常见用例是针对三维对象，例如建筑物

2. Geography spatial data types 地理空间数据类型

   These are represented as latitudinal and longitudinal degrees, as on a round-earth coordinate system. The common use case of the Geography type is to store an application’s GPS data. In SQL Server, both SQL data types have been implemented in the .NET common language runtime (CLR)

   这些表示为纬度和纵向度，如在地球坐标系上。 地理类型的常见用例是存储应用程序的GPS数据。 在SQL Server中，两种SQL数据类型均已在.NET公共语言运行库（CLR）中实现

空间数据对象 (Spatial data objects)

This combines both special data types (geometry and geography). It supports a total of sixteen SQL data types in which eleven can be utilized in the database. To be more specific, these objects have inherited a particular property from their parent’s data types and this unique property distributes them as the object. Take the examples of a Polygon or point or CircularString.

这结合了两种特殊的数据类型（几何和地理）。 它总共支持16种SQL数据类型，其中11种可以在数据库中使用。 更具体地说，这些对象已从其父级的数据类型继承了一个特定的属性，并且该唯一属性将它们作为对象进行分发。 以Polygon或point或CircularString为例。

Among them, ten of the depicted data objects wil