1
2
3
4
5
6
7
|
ST_TransformXYZ - 3D XYZ GeometryCollection
:memory: #use in-memory database
SELECT AsText(ST_TransformXYZ(GeomFromText('GEOMETRYCOLLECTIONZ(POINTZ(11.1 41.1 1.0), LINESTRINGZ(11.2 41.2 1.1, 11.3 41.3 1.2), POLYGONZ((11.3 41.3 1.1, 11.8 41.3 1.2, 11.8 41.8 1.3, 11.3 41.8 1.2, 11.3 41.3 1.1), (11.4 41.4 1.2, 11.7 41.4 1.3, 11.7 41.7 1.4, 11.4 41.7 1.3, 11.4 41.4 1.2)))', 4326), 3003));
1 # rows (not including the header row)
1 # columns
AsText(ST_TransformXYZ(GeomFromText('GEOMETRYCOLLECTIONZ(POINTZ(11.1 41.1 1.0), LINESTRINGZ(11.2 41.2 1.1, 11.3 41.3 1.2), POLYGONZ((11.3 41.3 1.1, 11.8 41.3 1.2, 11.8 41.8 1.3, 11.3 41.8 1.2, 11.3 41.3 1.1), (11.4 41.4 1.2, 11.7 41.4 1.3, 11.7 41.7 1.4, 11.4 41.7 1.3, 11.4 41.4 1.2)))', 4326), 3003))
GEOMETRYCOLLECTION Z(POINT Z(1676380.538787 4551993.304755 1), LINESTRING Z(1684498.324125 4563303.102437 1.1, 1692590.049447 4574622.920758 1.2), POLYGON Z((1692590.049448 4574622.920759 1.1, 1734455.803017 4575853.343589 1.2, 1732655.006865 4631372.543292 1.3, 1691111.32032 4630139.503568 1.2, 1692590.049448 4574622.920759 1.1), (1700655.635833 4585952.766713 1.2, 1725736.586449 4586691.348849 1.3, 1724694.769267 4620002.53027 1.4, 1699729.762453 4619263.006002 1.3, 1700655.635833 4585952.766713 1.2)))
|
