Point
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
In SQL Server spatial data, a Point is a 0-dimensional object representing a single location and may contain Z (elevation) and M (measure) values.
Geography Data Type
The Point type for the geography data type represents a single location where Lat represents latitude and Long represents longitude. The values for latitude and longitude are measured in degrees. Values for latitude always lie in the interval [-90, 90], and values that are inputted outside this range will throw an exception. Values for longitude always lie in the interval (-180, 180], and values inputted outside this range are wrapped around to fit in this range. For example, if 190 is inputted for longitude, then it will be wrapped to the value -170. SRID represents the spatial reference ID of the geography instance that you wish to return.
Geometry Data Type
The Point type for the geometry data type represents a single location where X represents the X-coordinate of the Point being generated and Y represents the Y-coordinate of the Point being generated. SRID represents the spatial reference ID of the geometry instance that you wish to return.
Examples
Example A.
The following example creates a geometry Point instance representing the point (3, 4) with an SRID of 0.
DECLARE @g geometry;
SET @g = geometry::STGeomFromText('POINT (3 4)', 0);
Example B.
The following example creates a geometry Point instance representing the point (3, 4) with a Z (elevation) value of 7, an M (measure) value of 2.5, and the default SRID of 0.
DECLARE @g geometry;
SET @g = geometry::Parse('POINT(3 4 7 2.5)');
Example C.
The following example returns the X, Y, Z, and M values for the geometry Point instance.
SELECT @g.STX;
SELECT @g.STY;
SELECT @g.Z;
SELECT @g.M;
Example D.
Z and M values may be explicitly specified as NULL, as shown in the following example.
DECLARE @g geometry;
SET @g = geometry::Parse('POINT(3 4 NULL NULL)');
See Also
MultiPoint
STX (geometry Data Type)
STY (geometry Data Type)
Spatial Data (SQL Server)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho