Connectors > SAP Hana

SAPHana uses the ST Geometry format.

The available geometry types in Hana are st_geometry and st_point, but they are functionally identical (with STPoint being restricted to point geometries). As such, DTS treats them identically.

Geometry Types

Here is how SAP Hana (ST) geometry subtypes map to GeoJson geometry types.

ST Subtype	Interpretation	GeoJson Geometry Type
POINT	Single point	Point
MULTIPOINT	Multiple points	MultiPoint
LINESTRING	Sequence of straight lines without gaps	LineString
CIRCULARSTRING	Sequence of circle arcs without gaps	LineString + DTS corrections
MULTILINESTRING	Multiple LINESTRINGs (not necessarily connected)	MultiLineString
COMPOUNDCURVE	Sequence of connected LINESTRINGs and CIRCULARLINESTRINGs	MultiLineString + DTS corrections
POLYGON	Polygon (with or without holes)	Polygon
CURVEPOLYGON	Polygon whose boundaries can contain circle arcs	Polygon + DTS corrections
MULTIPOLYGON	Multiple POLYGONs	MultiPolygon (+ DTS corrections)
GEOMETRYCOLLECTION	Collection of any of the above	GeometryCollection (+ DTS corrections)

Z and M modifiers (e.g. POINT Z) are supported for all geometry types (except GEOMETRYCOLLECTION where they are not applicable), but the M values are always ignored and processing geometries with Z values has certain limitations.