1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
Output format tests - GEOMETRY COLLECTION OF POINT and POLYGON via EWKB, WGS-84
:memory: #use in-memory database
SELECT AsText(geom), AsKML(geom), AsGML(geom), AsGeoJSON(geom), AsWkt(geom), AsEWkt(geom), Hex(AsEWKB(geom)) FROM (SELECT GeomFromEWkt('SRID=4326;GEOMETRYCOLLECTION(POINT(1 2),POLYGON((-10 -10, -10 10, 10 10 , 10 -10, -10 -10),(-8 -8, -2 -8, -2 -2, -8 -2, -8 -8),(8 8, 2 8, 2 2, 8 2, 8 8)))') as geom) dummy;
1 # rows (not including the header row)
7 # columns
AsText(geom)
AsKML(geom)
AsGML(geom)
AsGeoJSON(geom)
AsWkt(geom)
AsEWkt(geom)
Hex(AsEWKB(geom))
GEOMETRYCOLLECTION(POINT(1 2), POLYGON((-10 -10, -10 10, 10 10, 10 -10, -10 -10), (-8 -8, -2 -8, -2 -2, -8 -2, -8 -8), (8 8, 2 8, 2 2, 8 2, 8 8)))
<MultiGeometry><Point><coordinates>1,2</coordinates></Point><Polygon><outerBoundaryIs><LinearRing><coordinates>-10,-10 -10,10 10,10 10,-10 -10,-10</coordinates></LinearRing></outerBoundaryIs><innerBoundaryIs><LinearRing><coordinates>-8,-8 -2,-8 -2,-2 -8,-2 -8,-8</coordinates></LinearRing></innerBoundaryIs><innerBoundaryIs><LinearRing><coordinates>8,8 2,8 2,2 8,2 8,8</coordinates></LinearRing></innerBoundaryIs></Polygon></MultiGeometry>
<gml:MultiGeometry srsName='EPSG:4326'><gml:geometryMember><gml:Point><gml:coordinates>1,2</gml:coordinates></gml:Point></gml:geometryMember><gml:geometryMember><gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>-10,-10 -10,10 10,10 10,-10 -10,-10</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs><gml:innerBoundaryIs><gml:LinearRing><gml:coordinates>-8,-8 -2,-8 -2,-2 -8,-2 -8,-8</gml:coordinates></gml:LinearRing></gml:innerBoundaryIs><gml:innerBoundaryIs><gml:LinearRing><gml:coordinates>8,8 2,8 2,2 8,2 8,8</gml:coordinates></gml:LinearRing></gml:innerBoundaryIs></gml:Polygon></gml:geometryMember></gml:MultiGeometry>:0
{'type':'GeometryCollection','geometries':[{'type':'Point','coordinates':[1,2]},{'type':'Polygon','coordinates':[[[-10,-10],[-10,10],[10,10],[10,-10],[-10,-10]],[[-8,-8],[-2,-8],[-2,-2],[-8,-2],[-8,-8]],[[8,8],[2,8],[2,2],[8,2],[8,8]]]}]}:0
GEOMETRYCOLLECTION(POINT(1 2),POLYGON((-10 -10,-10 10,10 10,10 -10,-10 -10),(-8 -8,-2 -8,-2 -2,-8 -2,-8 -8),(8 8,2 8,2 2,8 2,8 8)))
SRID=4326;GEOMETRYCOLLECTION(POINT(1 2),POLYGON((-10 -10,-10 10,10 10,10 -10,-10 -10),(-8 -8,-2 -8,-2 -2,-8 -2,-8 -8),(8 8,2 8,2 2,8 2,8 8)))
3031303730303030323045363130303030303032303030303030303130313030303030303030303030303030303030304630334630303030303030303030303030303430303130333030303030303033303030303030303530303030303030303030303030303030303032344330303030303030303030303030323443303030303030303030303030303234433030303030303030303030303032343430303030303030303030303030323434303030303030303030303030303234343030303030303030303030303032343430303030303030303030303030323443303030303030303030303030303234433030303030303030303030303032344330303530303030303030303030303030303030303032304330303030303030303030303030323043303030303030303030303030303030433030303030303030303030303032304330303030303030303030303030303043303030303030303030303030303030433030303030303030303030303032304330303030303030303030303030303043303030303030303030303030303230433030303030303030303030303032304330303530303030303030303030303030303030303032303430303030303030303030303030323034303030303030303030303030303030343030303030303030303030303032303430303030303030303030303030303034303030303030303030303030303030343030303030303030303030303032303430303030303030303030303030303034303030303030303030303030303230343030303030303030303030303032303430
|
