Pitney Bowes MapXtreme - Manual (Page 220)

Chapter 11: Accessing Data from a DBMS
Accessing Data from MS SQL Server
MapXtreme v7.1 227 Developer Guide
The following table shows how objects are handled in MapXtreme given a specific object type from
SQL Server 2008.
This table shows how a MapXtreme FeatureGeometry is written back to SQL Server 2008
SQL Server 2008 Spatial
GEOGRAPHY or GEOMETRY MapXtreme FeatureGeometry
Sql Server 2008 Spatial
GEOGRAPHY/GEOMETRY FeatureGeometry
Point Point
LineString MultiCurve
Polygon Multipolygon
MultiPoint MultiPoint
MultiLineString MultiCurve
MultiPolygon MultiPolygon
GeometryCollection FeatureGeometryCollection
GeometryCollection containing only Points
and/or MultiPoints MultiPoint
Geometrycollection containing only
LineStrings and/or MultiLineString MultiCurve
Geometrycollection containing only
Polygons and/or MultiPolygons MultiPolygon
An EMPTY GEOMETRY/GEOGRAPHY,
e.g., Point empty NULL
MapXtreme FeatureGeometry
SQL Server 2008 Spatial
GEOGRAPHY or GEOMETRY
Point Point
MultiPoint MultiPoint
MultiPoint containing only one Point Point
MultiCurve MultiLineString
MultiCurve containing only one Curve
comprised of two points LineString
Multipolygon MultiPolygon