ST_MULTIDIMENSIONAL.sql

-- this syntax is used for multi-dimensional spatial type data in HANA

CREATE SCHEMA DEVTEST;
SET SCHEMA DEVTEST;

CREATE COLUMN TABLE GEOTEST (
 	ID INTEGER,
 	GEO ST_GEOMETRY
 );  

INSERT INTO GEOTEST VALUES(1, NEW ST_POINT('POINT (5.0 6.0)'));
INSERT INTO GEOTEST VALUES(2, NEW ST_POINT('POINT Z(5.0 6.0 8.0)'));
INSERT INTO GEOTEST VALUES(3, NEW ST_POINT('POINT M(5.0 6.0 1400)'));
INSERT INTO GEOTEST VALUES(4, NEW ST_POINT('POINT ZM(2 3 4 1000)'));
INSERT INTO GEOTEST VALUES(5, NEW ST_POINT());
INSERT INTO GEOTEST VALUES(6, NEW ST_LINESTRING('LINESTRING ZM(3 3 4 2500, 5 4 2 2600, 6 3 3 2200)'));
INSERT INTO GEOTEST VALUES(7, NEW ST_LINESTRING());
INSERT INTO GEOTEST VALUES(8, NEW ST_POLYGON('POLYGON ZM((6 7 4 1800, 10 3 4 1850, 10 10 4 1900, 6 7 4 1800))'));
INSERT INTO GEOTEST VALUES(9, NEW ST_POLYGON());

-- Other Supported Spatial Data Types
	-- ST_MultiPoint
	-- ST_MultiLineString
	-- ST_MultiPolygon
	-- ST_GeometryCollection

SELECT 
 ID, 
 GEO.ST_AsWKT(),
 --GEO.ST_Z(), 
 GEO.ST_ZMAX(), 
 GEO.ST_ZMIN(),
 --GEO.ST_M(), 
 GEO.ST_MMAX(), 
 GEO.ST_MMIN()
FROM GEOTEST;