1
2
3
4
5
6
7
|
ST_TransformXY - 3D XYZ GeometryCollection
:memory: #use in-memory database
SELECT AsText(ST_TransformXY(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_TransformXY(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.538791 4551993.304759 1), LINESTRING Z(1684498.32413 4563303.102441 1.1, 1692590.049453 4574622.920763 1.2), POLYGON Z((1692590.049453 4574622.920763 1.1, 1734455.803022 4575853.343594 1.2, 1732655.00687 4631372.543297 1.3, 1691111.320325 4630139.503573 1.2, 1692590.049453 4574622.920763 1.1), (1700655.635838 4585952.766718 1.2, 1725736.586454 4586691.348854 1.3, 1724694.769273 4620002.530275 1.4, 1699729.762459 4619263.006007 1.3, 1700655.635838 4585952.766718 1.2)))
|
