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 -45.904306), LINESTRING Z(1684498.324126 4563303.102437 -45.725341, 1692590.049448 4574622.920759 -45.546941), POLYGON Z((1692590.049449 4574622.920759 -45.646942, 1734455.80302 4575853.34359 -45.368539, 1732655.006867 4631372.543293 -45.06343, 1691111.320321 4630139.503569 -45.340455, 1692590.049449 4574622.920759 -45.646942), (1700655.635834 4585952.766713 -45.469106, 1725736.586451 4586691.348849 -45.262228, 1724694.769269 4620002.53027 -45.038996, 1699729.762454 4619263.006002 -45.245378, 1700655.635834 4585952.766713 -45.469106)))
|
