Home > GeoSpatial, SQL Server > SQL Server – Spatial Data, an Introduction – Part 1

SQL Server – Spatial Data, an Introduction – Part 1


Spatial data is anything that has a geographical location associated with it.   Spatial data can be represented using points,lines, polygons and etc. Geographic Information System (GIS) is a system designed to collect, store, manage, view, and analyze spatial data, as well as associated attribute data.

GIS_PicMicrosoft SQL Server has got Spatial Data feature since the version 2008 and it is getting improvement with additional features that helps interacting with shapes in the maps. We ca use SQL Server spatial data to represents physical location by points or other shape of geometric objects.

SQL Server supports two spatial types and that are implemented as .NET common language runtime (CLR) data types.

  •  Geometry data type – It represents data in a Euclidean (flat) coordinate system

Geometry data type supports planar, or Euclidean (flat-earth), data. The geometry data type conforms to the Open Geospatial Consortium (OGC) Simple Features for SQL Specification version 1.1.0 and SQL MM (ISO/IEC 13249-3).

Euclideanmap

  •  Geography type represents data in a round-earth coordinate system.

It stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.

Ellipsoid

This is just an introduction about spatial data in SQL Server. We will be learning about the geometry shapes and geography data and its usage in the upcoming blog posts.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: