1
2
3
4
5
6
7
|
ST_TransformXY - 2D XY GeometryCollection
:memory: #use in-memory database
SELECT AsText(ST_TransformXY(GeomFromText('GEOMETRYCOLLECTION(POINT(11.1 41.1), LINESTRING(11.2 41.2, 11.3 41.3), POLYGON((11.3 41.3, 11.8 41.3, 11.8 41.8, 11.3 41.8, 11.3 41.3), (11.4 41.4, 11.7 41.4, 11.7 41.7, 11.4 41.7, 11.4 41.4)))', 4326), 3003));
1 # rows (not including the header row)
1 # columns
AsText(ST_TransformXY(GeomFromText('GEOMETRYCOLLECTION(POINT(11.1 41.1), LINESTRING(11.2 41.2, 11.3 41.3), POLYGON((11.3 41.3, 11.8 41.3, 11.8 41.8, 11.3 41.8, 11.3 41.3), (11.4 41.4, 11.7 41.4, 11.7 41.7, 11.4 41.7, 11.4 41.4)))', 4326), 3003))
GEOMETRYCOLLECTION(POINT(1676380.538791 4551993.304759), LINESTRING(1684498.324131 4563303.102442, 1692590.049453 4574622.920763), POLYGON((1692590.049453 4574622.920763, 1734455.803025 4575853.343594, 1732655.006872 4631372.543298, 1691111.320326 4630139.503574, 1692590.049453 4574622.920763), (1700655.635839 4585952.766718, 1725736.586456 4586691.348854, 1724694.769275 4620002.530275, 1699729.76246 4619263.006007, 1700655.635839 4585952.766718)))
|
