1
1
FromGML - MultiLinestring v2 3D (no namespace)
2
2
:memory: #use in-memory database
3
SELECT AsEwkt(GeomFromGml('<MultiLineString srsName="EPSG:4326"><lineStringMember><LineString><coordinates>1,2,10 3,4,11 5,6,12</coordinates></LineString></lineStringMember><lineStringMember><LineString><coordinates>7,8,13 9,10,13</coordinates></LineString></lineStringMember></MultiLineString>'));
3
SELECT AsEwkt(GeomFromGml('<MultiLineString srsName="EPSG:4326"><lineStringMember><LineString><coordinates>1,2,10 3,4,11 5,6,13</coordinates></LineString></lineStringMember><lineStringMember><LineString><coordinates>7,8,13 9,10,13</coordinates></LineString></lineStringMember></MultiLineString>'));
4
4
1 # rows (not including the header row)
6
AsEwkt(GeomFromGml('<MultiLineString srsName="EPSG:4326"><lineStringMember><LineString><coordinates>1,2,10 3,4,11 5,6,12</coordinates></LineString></lineStringMember><lineStringMember><LineString><coordinates>7,8,13 9,10,13</coordinates></LineString></lineStringMember></MultiLineString>')):0
7
SRID=4326;MULTILINESTRING((1 2 10,3 4 11,5 6 12),(7 8 13,9 10 13))
6
AsEwkt(GeomFromGml('<MultiLineString srsName="EPSG:4326"><lineStringMember><LineString><coordinates>1,2,10 3,4,11 5,6,13</coordinates></LineString></lineStringMember><lineStringMember><LineString><coordinates>7,8,13 9,10,13</coordinates></LineString></lineStringMember></MultiLineString>')):0
7
SRID=4326;MULTILINESTRING((1 2 10,3 4 11,5 6 13),(7 8 13,9 10 13))