1
2
3
4
5
6
7
|
fromewkt27
:memory: #use in-memory database
SELECT AsText(GeomFromEWKT('SRID=4326;GEOMETRYCOLLECTION(POINT(8 8 9 7), MULTIPOLYGON(((0 0 9 7, 5 0 9 7, 5 5 9 7, 0 5 9 7, 0 0 9 7), (1 1 9 7, 2 1 9 7, 2 2 9 7, 1 2 9 7, 1 1 9 7)), ((10 10 9 7, 11 10 9 7, 11 11 9 7, 10 11 9 7, 10 10 9 7))), POINT(7 7 9 7), MULTILINESTRING((0 1 9 7, 2 3 9 7), (4 5 9 7, 6 7 9 7)), POINT(6 6 9 7), MULTIPOINT((0 1 9 7), (2 3 9 7), (4 5 9 7)), POINT(9 9 9 7))'));
1 # rows (not including the header row)
1 # columns
AsText(GeomFromEWKT('SRID=4326;GEOMETRYCOLLECTION(POINT(8 8 9 7), MULTIPOLYGON(((0 0 9 7, 5 0 9 7, 5 5 9 7, 0 5 9 7, 0 0 9 7), (1 1 9 7, 2 1 9 7, 2 2 9 7, 1 2 9 7, 1 1 9 7)), ((10 10 9 7, 11 10 9 7, 11 11 9 7, 10 11 9 7, 10 10 9 7))), POINT(7 7 9 7), MULTILINESTRING((0 1 9 7, 2 3 9 7), (4 5 9 7, 6 7 9 7)), POINT(6 6 9 7), MULTIPOINT((0 1 9 7), (2 3 9 7), (4 5 9 7)), POINT(9 9 9 7))'));
GEOMETRYCOLLECTION ZM(POINT ZM(8 8 9 7), POINT ZM(7 7 9 7), POINT ZM(6 6 9 7), POINT ZM(0 1 9 7), POINT ZM(2 3 9 7), POINT ZM(4 5 9 7), POINT ZM(9 9 9 7), LINESTRING ZM(0 1 9 7, 2 3 9 7), LINESTRING ZM(4 5 9 7, 6 7 9 7), POLYGON ZM((0 0 9 7, 5 0 9 7, 5 5 9 7, 0 5 9 7, 0 0 9 7), (1 1 9 7, 2 1 9 7, 2 2 9 7, 1 2 9 7, 1 1 9 7)), POLYGON ZM((10 10 9 7, 11 10 9 7, 11 11 9 7, 10 11 9 7, 10 10 9 7)))
|
