File: output30.testcase

package info (click to toggle)
spatialite 5.1.0-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 74,240 kB
  • sloc: ansic: 587,051; makefile: 8,583; sh: 4,276; yacc: 1,973; xml: 717
file content (19 lines) | stat: -rw-r--r-- 5,692 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
Output format tests - MULTIPOLYGONZM 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;MULTIPOLYGON(((10 10 1.2 1, 0 10 1.3 -2, 0 0 1.1 5.8, 0 10 1.3 3, 10 10 1.2 1)),((-10 -10 4 0, -10 10 5 0, 10 10 6 1, 10 -10 5 0, -10 -10 4 0),(-8 -8 1 1, -2 -8 3 4, -2 -2 5 6, -8 -2 7 9, -8 -8 1 1),(8 8 11 0, 2 8 13 -2, 2 2 17 -4, 8 2 13 -8, 8 8 11 0)))') 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))
MULTIPOLYGON ZM(((10 10 1.2 1, 0 10 1.3 -2, 0 0 1.1 5.8, 0 10 1.3 3, 10 10 1.2 1)), ((-10 -10 4 0, -10 10 5 0, 10 10 6 1, 10 -10 5 0, -10 -10 4 0), (-8 -8 1 1, -2 -8 3 4, -2 -2 5 6, -8 -2 7 9, -8 -8 1 1), (8 8 11 0, 2 8 13 -2, 2 2 17 -4, 8 2 13 -8, 8 8 11 0)))
<MultiGeometry><Polygon><outerBoundaryIs><LinearRing><coordinates>10,10,1.2 0,10,1.3 0,0,1.1 0,10,1.3 10,10,1.2</coordinates></LinearRing></outerBoundaryIs></Polygon><Polygon><outerBoundaryIs><LinearRing><coordinates>-10,-10,4 -10,10,5 10,10,6 10,-10,5 -10,-10,4</coordinates></LinearRing></outerBoundaryIs><innerBoundaryIs><LinearRing><coordinates>-8,-8,1 -2,-8,3 -2,-2,5 -8,-2,7 -8,-8,1</coordinates></LinearRing></innerBoundaryIs><innerBoundaryIs><LinearRing><coordinates>8,8,11 2,8,13 2,2,17 8,2,13 8,8,11</coordinates></LinearRing></innerBoundaryIs></Polygon></MultiGeometry>
<gml:MultiPolygon srsName='EPSG:4326'><gml:polygonMember><gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>10,10,1.2 0,10,1.3 0,0,1.1 0,10,1.3 10,10,1.2</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon></gml:polygonMember><gml:polygonMember><gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>-10,-10,4 -10,10,5 10,10,6 10,-10,5 -10,-10,4</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs><gml:innerBoundaryIs><gml:LinearRing><gml:coordinates>-8,-8,1 -2,-8,3 -2,-2,5 -8,-2,7 -8,-8,1</gml:coordinates></gml:LinearRing></gml:innerBoundaryIs><gml:innerBoundaryIs><gml:LinearRing><gml:coordinates>8,8,11 2,8,13 2,2,17 8,2,13 8,8,11</gml:coordinates></gml:LinearRing></gml:innerBoundaryIs></gml:Polygon></gml:polygonMember></gml:MultiPolygon>:0
{'type':'MultiPolygon','coordinates':[[[[10,10,1.2],[0,10,1.3],[0,0,1.1],[0,10,1.3],[10,10,1.2]]],[[[-10,-10,4],[-10,10,5],[10,10,6],[10,-10,5],[-10,-10,4]],[[-8,-8,1],[-2,-8,3],[-2,-2,5],[-8,-2,7],[-8,-8,1]],[[8,8,11],[2,8,13],[2,2,17],[8,2,13],[8,8,11]]]]}:0
MULTIPOLYGON(((10 10,0 10,0 0,0 10,10 10)),((-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;MULTIPOLYGON(((10 10 1.2 1,0 10 1.3 -2,0 0 1.1 5.8,0 10 1.3 3,10 10 1.2 1)),((-10 -10 4 0,-10 10 5 0,10 10 6 1,10 -10 5 0,-10 -10 4 0),(-8 -8 1 1,-2 -8 3 4,-2 -2 5 6,-8 -2 7 9,-8 -8 1 1),(8 8 11 0,2 8 13 -2,2 2 17 -4,8 2 13 -8,8 8 11 0)))
303130363030303045304536313030303030303230303030303030313033303030304330303130303030303030353030303030303030303030303030303030303234343030303030303030303030303032343430333333333333333333333333463333463030303030303030303030304630334630303030303030303030303030303030303030303030303030303030323434304344434343434343434343434634334630303030303030303030303030304330303030303030303030303030303030303030303030303030303030303030303039413939393939393939393946313346333333333333333333333333313734303030303030303030303030303030303030303030303030303030303032343430434443434343434343434343463433463030303030303030303030303038343030303030303030303030303032343430303030303030303030303030323434303333333333333333333333334633334630303030303030303030303046303346303130333030303043303033303030303030303530303030303030303030303030303030303032344330303030303030303030303030323443303030303030303030303030303130343030303030303030303030303030303030303030303030303030303030323443303030303030303030303030303234343030303030303030303030303031343430303030303030303030303030303030303030303030303030303030303234343030303030303030303030303032343430303030303030303030303030313834303030303030303030303030304630334630303030303030303030303032343430303030303030303030303030323443303030303030303030303030303134343030303030303030303030303030303030303030303030303030303030323443303030303030303030303030303234433030303030303030303030303031303430303030303030303030303030303030303035303030303030303030303030303030303030323043303030303030303030303030303230433030303030303030303030303046303346303030303030303030303030463033463030303030303030303030303030433030303030303030303030303032304330303030303030303030303030303834303030303030303030303030303130343030303030303030303030303030304330303030303030303030303030303043303030303030303030303030303134343030303030303030303030303031383430303030303030303030303030323043303030303030303030303030303030433030303030303030303030303031433430303030303030303030303030323234303030303030303030303030303230433030303030303030303030303032304330303030303030303030303030463033463030303030303030303030304630334630353030303030303030303030303030303030303230343030303030303030303030303032303430303030303030303030303030323634303030303030303030303030303030303030303030303030303030303030303430303030303030303030303030323034303030303030303030303030303241343030303030303030303030303030304330303030303030303030303030303034303030303030303030303030303030343030303030303030303030303033313430303030303030303030303030313043303030303030303030303030303230343030303030303030303030303030303430303030303030303030303030324134303030303030303030303030303230433030303030303030303030303032303430303030303030303030303030323034303030303030303030303030303236343030303030303030303030303030303030