1
2
3
4
5
6
7
|
ST_TransformXYZ - 4D XYZM GeometryCollection
:memory: #use in-memory database
SELECT AsText(ST_TransformXYZ(GeomFromText('GEOMETRYCOLLECTIONZM(POINTZM(11.1 41.1 1.0 1.5), LINESTRINGZM(11.2 41.2 1.1 0.5, 11.3 41.3 1.2 0.8), POLYGONZM((11.3 41.3 1.1 0.1, 11.8 41.3 1.2 0.2, 11.8 41.8 1.3 0.3, 11.3 41.8 1.2 0.4, 11.3 41.3 1.1 0.1), (11.4 41.4 1.2 1.1, 11.7 41.4 1.3 1.2, 11.7 41.7 1.4 1.3, 11.4 41.7 1.3 1.4, 11.4 41.4 1.2 1.1)))', 4326), 3003));
1 # rows (not including the header row)
1 # columns
AsText(ST_TransformXYZ(GeomFromText('GEOMETRYCOLLECTIONZM(POINTZM(11.1 41.1 1.0 1.5), LINESTRINGZM(11.2 41.2 1.1 0.5, 11.3 41.3 1.2 0.8), POLYGONZM((11.3 41.3 1.1 0.1, 11.8 41.3 1.2 0.2, 11.8 41.8 1.3 0.3, 11.3 41.8 1.2 0.4, 11.3 41.3 1.1 0.1), (11.4 41.4 1.2 1.1, 11.7 41.4 1.3 1.2, 11.7 41.7 1.4 1.3, 11.4 41.7 1.3 1.4, 11.4 41.4 1.2 1.1)))', 4326), 3003))
GEOMETRYCOLLECTION ZM(POINT ZM(1676380.538787 4551993.304755 -45.904306 1.5), LINESTRING ZM(1684498.324126 4563303.102437 -45.725341 0.5, 1692590.049448 4574622.920759 -45.546941 0.8), POLYGON ZM((1692590.049449 4574622.920759 -45.646942 0.1, 1734455.80302 4575853.34359 -45.368539 0.2, 1732655.006867 4631372.543293 -45.06343 0.3, 1691111.320321 4630139.503569 -45.340455 0.4, 1692590.049449 4574622.920759 -45.646942 0.1), (1700655.635834 4585952.766713 -45.469106 1.1, 1725736.586451 4586691.348849 -45.262228 1.2, 1724694.769269 4620002.53027 -45.038996 1.3, 1699729.762454 4619263.006002 -45.245378 1.4, 1700655.635834 4585952.766713 -45.469106 1.1)))
|
