Designing and Implementing Spatial Storage (Database Engine)
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.
SQL Server supports two spatial data types: the
data type and the geometry data type. Both data types are implemented as .NET common language runtime (CLR) data types in SQL Server. geography
data type (planar) supported by SQL Server conforms to the Open Geospatial Consortium (OGC) Simple Features for SQL Specification version 1.1.0. geometry
For more information on OGC specifications, see the following:
data type (geodetic) stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates. geography Working with Spatial Data (Database Engine)
Contains information about the types of spatial data in SQL Server Database Engine, how to create spatial data instances, how to query and retrieve properties and other information about spatial instances, and how to modify and create new spatial instances from existing ones.
Working with Spatial Indexes (Database Engine)
Contains an introduction to spatial indexing in the SQL Server Database Engine and provides information about creating, altering, and dropping a spatial index.
( 1500 characters remaining)
Thank you for your feedback