1
2
3
4
5
6
7
|
transform - Polygon ZM
:memory: #use in-memory database
SELECT AsText(Transform(GeomFromText('POLYGONZM((11 43 100 1, 12 43 101 2, 12 44 102 3, 11 44 103 4, 11 43 100 1), (11.4 43.4 100 1, 11.6 43.4 101 2, 11.6 43.6 102 3, 11.4 43.6 103 4, 11.4 43.4 100 1))', 4326), 32632))
1 # rows (not including the header row)
1 # columns
AsText(Transform(GeomFromText('POLYGONZM((11 43 100 1, 12 43 101 2, 12 44 102 3, 11 44 103 4, 11 43 100 1), (11.4 43.4 100 1, 11.6 43.4 101 2, 11.6 43.6 102 3, 11.4 43.6 103 4, 11.4 43.4 100 1))', 4326), 32632))
POLYGON ZM((663019.070081 4762755.641689 100 1, 744533.019447 4765182.932801 101 2, 740526.321052 4876249.126962 102 3, 660349.410578 4873817.33344 103 4, 663019.070081 4762755.641689 100 1), (694349.575561 4808033.274617 100 1, 710545.984353 4808519.151148 101 2, 709851.653211 4830731.987848 102 3, 693708.725205 4830245.931092 103 4, 694349.575561 4808033.274617 100 1))
|
