Home > GeoSpatial, SQL Server > SQL SERVER – Spatial shapes data

SQL SERVER – Spatial shapes data


Shapes are the geometry objects that are used to draw an outline or it can be used as real geometry shape for calculation on top of maps (geography). There are 11 usable or instantiable shape objects available in SQL Server. But, we can use only 11 of them and the image shown here is used to quickly identify the instantiable objects mentioned in blue color. In general, child object type properties are inherited from the parent objects.

Spatial Data Hierarchy – Microsoft Image

SpatialDataHierarchyThese data types are splitting into two categories simple and collections.

Simple Types

  1. Point
  2. LineString
  3. CircularString
  4. CompoundCurve
  5. Polygon
  6. CurvePolygon

Collection Types

  1. MultiPoint
  2. MultiLineString
  3. MultiPolygon
  4. GeometryCollection

Geography Type

  1. FullGlobe

It is important to know that some of the methods are capable of handling only simple objects.  SQL Server follows the standards of OGC (Open Geospatial Consortium). The following links will give you detailed information about OGC standards and other GIS architecture details.

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: