1
2
3
4
5
6
7
8
|
GMLv2 MultiLinestring Z - no SRID
:memory: #use in-memory database
SELECT AsGML(GeomFromText('MULTILINESTRINGZ((1 2 100, 3 4 101), (5 5 88, 6 6 99))'));
1 # rows (not including the header row)
1 # columns
AsGML(GeomFromText('MULTILINESTRINGZ((1 2 100, 3 4 101), (5 5 88, 6 6 99))'))
<gml:MultiLineString><gml:lineStringMember><gml:LineString><gml:coordinates>1,2,100 3,4,101</gml:coordinates></gml:LineString></gml:lineStringMember><gml:lineStringMember><gml:LineString><gml:coordinates>5,5,88 6,6,99</gml:coordinates></gml:LineString></gml:lineStringMember></gml:MultiLineString>:0 # trailing ":0" required to avoid truncation !!!
|
