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.324131 4563303.102442 1.1, 1692590.049453 4574622.920763 1.2), POLYGON Z((1692590.049453 4574622.920763 1.1, 1734455.803025 4575853.343594 1.2, 1732655.006872 4631372.543298 1.3, 1691111.320326 4630139.503574 1.2, 1692590.049453 4574622.920763 1.1), (1700655.635839 4585952.766718 1.2, 1725736.586456 4586691.348854 1.3, 1724694.769275 4620002.530275 1.4, 1699729.76246 4619263.006007 1.3, 1700655.635839 4585952.766718 1.2)))
|
