1 2 3 4 5 6 7
|
FromGML - multipointZ, multiple SRID, no namespace
:memory: #use in-memory database
SELECT AsText(GeomFromGml('<MultiPoint><pointMember><Point srsName='EPSG:4326'><coordinates>1,2,3.2</coordinates></Point></pointMember><pointMember><Point srsName='EPSG:3003'><coordinates>2,4,3.2</coordinates></Point></pointMember></MultiPoint>'))
1 # rows (not including the header row)
1 # columns
AsText(GeomFromGml('<MultiPoint><pointMember><Point srsName='EPSG:4326'><coordinates>1,2,3.2</coordinates></Point></pointMember><pointMember><Point srsName='EPSG:3003'><coordinates>2,4,3.2</coordinates></Point></pointMember></MultiPoint>')):0
MULTIPOINT Z(1 2 3.2, -4.356405 0.000738 79.631063)
|