Debian Codegraph @

mysql-test/suite/gis/r/geometry_class_attri_prop.result

raw
1 # Creating the spatial Geometry object
2 USE test;
3 CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
4 CREATE TABLE gis_linestring (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING);
5 CREATE TABLE gis_polygon (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON);
6 CREATE TABLE gis_multi_point (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT);
7 CREATE TABLE gis_multi_linestring (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING);
8 CREATE TABLE gis_multi_polygon (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON);
9 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION);
10 CREATE TABLE gis_geometry (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
11 # Inserting POINT Geometry Values
12 INSERT INTO gis_point VALUES
13 (101, ST_POINTFROMTEXT('POINT(0 0)')),
14 (102, ST_POINTFROMTEXT('POINT(1 0)')),
15 (103, ST_POINTFROMTEXT('POINT(0 1)')),
16 (104, ST_POINTFROMTEXT('POINT(1 1)')),
17 (105, ST_POINTFROMTEXT('POINT(-1 1)'));
18 INSERT INTO gis_point VALUES
19 (106, ST_POINTFROMWKB(ST_ASWKB(POINT(0,0)))),
20 (107, ST_POINTFROMWKB(ST_ASWKB(POINT(10,0)))),
21 (108, ST_POINTFROMWKB(ST_ASWKB(POINT(0,10)))),
22 (109, ST_POINTFROMWKB(ST_ASWKB(POINT(-10,0)))),
23 (110, ST_POINTFROMWKB(ST_ASWKB(POINT(0,-10))));
24 INSERT INTO gis_point VALUES
25 (111, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1 1)')))),
26 (112, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1000 1000)')))),
27 (113, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1000 -1000)')))),
28 (114, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1000 1000)')))),
29 (115, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1000 -1000)'))));
30 # Inserting LINESTRING Geometry Values
31 INSERT INTO gis_linestring VALUES
32 (201, ST_LINEFROMTEXT('LINESTRING(0 0,5 5)')),
33 (202, ST_LINEFROMTEXT('LINESTRING(0 0,2 2,4 4)')),
34 (203, ST_LINEFROMTEXT('LINESTRING(0 0,5 5,10 10)'));
35 INSERT INTO gis_linestring VALUES
36 (204, ST_LINESTRINGFROMTEXT('LINESTRING(10 10,5 5)')),
37 (205, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,12 12,24 24)')),
38 (206, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,50 50,100 100)'));
39 INSERT INTO gis_linestring VALUES
40 (207, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
41 (208, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,10))))),
42 (209, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)))));
43 INSERT INTO gis_linestring VALUES
44 (210, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
45 (211, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-50,-50), POINT(10,-10))))),
46 (212, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(1000,1000), POINT(1000,-1000)))));
47 INSERT INTO gis_linestring VALUES
48 (213, ST_LINEFROMWKB(ST_ASWKB(ST_LINEFROMTEXT('LINESTRING(1000 1000,1000 -1000)')))),
49 (214, ST_LINEFROMWKB(ST_ASWKB(ST_LINEFROMTEXT('LINESTRING(1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)')))),
50 (215, ST_LINESTRINGFROMWKB(ST_ASWKB(ST_LINESTRINGFROMTEXT('LINESTRING(10 10,10 -10,-10 -10,-10 10,10 10)'))));
51 # Inserting POLYGON Geometry Values
52 INSERT INTO gis_polygon VALUES
53 (301, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5, 0 0))')),
54 (302, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')),
55 (303, ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
56 INSERT INTO gis_polygon VALUES
57 (304, ST_POLYGONFROMTEXT('POLYGON((0 0,0 50,50 50,50 0,0 0))')),
58 (305, ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')),
59 (306, ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'));
60 INSERT INTO gis_polygon VALUES
61 (307, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
62 (308, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)))))),
63 (309, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
64 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
65 INSERT INTO gis_polygon VALUES
66 (310, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
67 (311, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,15), POINT(15,15), POINT(15,10), POINT(10,10)))))),
68 (312, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,20), POINT(20,20), POINT(20,10), POINT(10,10)),
69 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))));
70 INSERT INTO gis_polygon VALUES
71 (313, ST_POLYFROMWKB(ST_ASWKB(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,5 5,0 0))')))),
72 (314, ST_POLYFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0))')))),
73 (315, ST_POLYGONFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'))));
74 # Inserting MULTIPOINT Geometry Values
75 INSERT INTO gis_multi_point VALUES
76 (401, ST_MPOINTFROMTEXT('MULTIPOINT(0 0)')),
77 (402, ST_MPOINTFROMTEXT('MULTIPOINT(0 0,2 2,4 4)')),
78 (403, ST_MPOINTFROMTEXT('MULTIPOINT(0 0,5 5,10 10)'));
79 INSERT INTO gis_multi_point VALUES
80 (404, ST_MULTIPOINTFROMTEXT('MULTIPOINT(0 0,100 100)')),
81 (405, ST_MULTIPOINTFROMTEXT('MULTIPOINT(0 0,1000 1000)')),
82 (406, ST_MULTIPOINTFROMTEXT('MULTIPOINT(1000 1000,1000 -1000,-1000 1000,-1000 -1000)'));
83 INSERT INTO gis_multi_point VALUES
84 (407, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
85 (408, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(10,10))))),
86 (409, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)))));
87 INSERT INTO gis_multi_point VALUES
88 (410, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
89 (411, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(1000,1000))))),
90 (412, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(1000,1000), POINT(-1000,1000), POINT(1000,-1000), POINT(-1000,-1000)))));
91 INSERT INTO gis_multi_point VALUES
92 (413, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(0 0)')))),
93 (414, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(0 0,1000 1000,-1000 -1000)')))),
94 (415, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(1000 1000,1000 -1000,-1000 1000,-1000 -1000,1000 1000)'))));
95 # Inserting MULTILINESTRING Geometry Values
96 INSERT INTO gis_multi_linestring VALUES
97 (501, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2))')),
98 (502, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4))')),
99 (503, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))'));
100 INSERT INTO gis_multi_linestring VALUES
101 (504, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,100 100,-100 -100))')),
102 (505, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1000 1000,-1000 -1000))')),
103 (506, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1000 1000,-1000 -1000),(1000 -1000,-1000 1000))'));
104 INSERT INTO gis_multi_linestring VALUES
105 (507, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2)))))),
106 (508, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)))))),
107 (509, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)),
108 LINESTRING(POINT(6,6), POINT(8,8), POINT(10,10))))));
109 INSERT INTO gis_multi_linestring VALUES
110 (510, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)))))),
111 (511, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1,1), POINT(2,2)))))),
112 (512, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)),
113 LINESTRING(POINT(36,36), POINT(48,48), POINT(50,50))))));
114 INSERT INTO gis_multi_linestring VALUES
115 (513, ST_MLINEFROMWKB(ST_ASWKB(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 10),(0 10,10 0))')))),
116 (514, ST_MLINEFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))')))),
117 (515, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))'))));
118 # Inserting MULTIPOLGYON Geometry Values
119 INSERT INTO gis_multi_polygon VALUES
120 (601, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))')),
121 (602, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))')),
122 (603, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
123 INSERT INTO gis_multi_polygon VALUES
124 (604, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5, 0 0)))')),
125 (605, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,0 -2,-2 -2, 0 0)))')),
126 (606, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))'));
127 INSERT INTO gis_multi_polygon VALUES
128 (607, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))))))),
129 (608, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
130 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
131 (609, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
132 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
133 INSERT INTO gis_multi_polygon VALUES
134 (610, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0))))))),
135 (611, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(10,10), POINT(20,10), POINT(20,20), POINT(10,20), POINT(10,10)),
136 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))))),
137 (612, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
138 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
139 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
140 INSERT INTO gis_multi_polygon VALUES
141 (613, ST_MPOLYFROMWKB(ST_ASWKB(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 5,-5 -5,0 0)))')))),
142 (614, ST_MPOLYFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))')))),
143 (615, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 0,5 -5,0 0)))'))));
144 # Inserting GEOMETRYCOLLECTION Geometry Values
145 INSERT INTO gis_geometrycollection VALUES
146 (701, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')),
147 (702, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
148 (703, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5), POLYGON((0 0,0 10,10 10,10 0,0 0)))'));
149 INSERT INTO gis_geometrycollection VALUES
150 (704, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
151 (705, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
152 'LINESTRING(0 0,10 10),'
153 'POLYGON((0 0,0 10,10 10,10 0, 0 0)))')),
154 (706, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),'
155 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
156 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),'
157 '((0 0,-10 0,-10 -10,0 -10,0 0))))'));
158 INSERT INTO gis_geometrycollection VALUES
159 (707, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0))))),
160 (708, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
161 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
162 POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
163 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
164 (709, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(0,0), POINT(5,5), POINT(10,10)),
165 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
166 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
167 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
168 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
169 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
170 INSERT INTO gis_geometrycollection VALUES
171 (710, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
172 LINESTRING(POINT(0,0), POINT(100,100)))))),
173 (711, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(10,10),
174 LINESTRING(POINT(10,10), POINT(12,12), POINT(14,14), POINT(16,16), POINT(18,18)),
175 POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
176 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
177 (712, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(10,10), POINT(15,15), POINT(20,20)),
178 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
179 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
180 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
181 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
182 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
183 INSERT INTO gis_geometrycollection VALUES
184 (713, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
185 'POINT(0 0),'
186 'LINESTRING(0 0,10 10),'
187 'POLYGON((0 0,0 10,10 10,10 0, 0 0)),'
188 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
189 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
190 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))')))),
191 (714, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
192 'GEOMETRYCOLLECTION('
193 'POINT(0 0)),'
194 'GEOMETRYCOLLECTION('
195 'LINESTRING(0 0,10 10)),'
196 'GEOMETRYCOLLECTION('
197 'POLYGON((0 0,0 10,10 10,10 0, 0 0))),'
198 'GEOMETRYCOLLECTION('
199 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10)),'
200 'GEOMETRYCOLLECTION('
201 'MULTILINESTRING((0 0,10 10),(0 10,10 0))),'
202 'GEOMETRYCOLLECTION('
203 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))))')))),
204 (715, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
205 'GEOMETRYCOLLECTION(),'
206 'POINT(0 0),'
207 'GEOMETRYCOLLECTION('
208 'LINESTRING(0 0,10 10),'
209 'GEOMETRYCOLLECTION('
210 'GEOMETRYCOLLECTION())),'
211 'GEOMETRYCOLLECTION(),'
212 'GEOMETRYCOLLECTION('
213 'GEOMETRYCOLLECTION()),'
214 'POLYGON((0 0,0 10,10 10,10 0, 0 0)),'
215 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
216 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
217 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))'))));
218 # Inserting the spatial values of all kinds to the parent class
219 INSERT INTO gis_geometry SELECT * FROM gis_point;
220 INSERT INTO gis_geometry SELECT * FROM gis_linestring;
221 INSERT INTO gis_geometry SELECT * FROM gis_polygon;
222 INSERT INTO gis_geometry SELECT * FROM gis_multi_point;
223 INSERT INTO gis_geometry SELECT * FROM gis_multi_linestring;
224 INSERT INTO gis_geometry SELECT * FROM gis_multi_polygon;
225 INSERT INTO gis_geometry SELECT * FROM gis_geometrycollection;
226 # Checking the integrity of the above insert statements
227 SELECT COUNT(g) FROM gis_geometry;
228 COUNT(g)
229 105
230 SELECT COUNT(ST_ASTEXT(g)) FROM gis_geometry;
231 COUNT(ST_ASTEXT(g))
232 105
233 SELECT COUNT(DISTINCT(g)) FROM gis_geometry;
234 COUNT(DISTINCT(g))
235 87
236 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_geometry;
237 COUNT(DISTINCT(ST_ASTEXT(g)))
238 87
239 # Displaying the inserted spatial Data
240 SELECT fid, ST_ASTEXT(g) FROM gis_point;
241 fid ST_ASTEXT(g)
242 101 POINT(0 0)
243 102 POINT(1 0)
244 103 POINT(0 1)
245 104 POINT(1 1)
246 105 POINT(-1 1)
247 106 POINT(0 0)
248 107 POINT(10 0)
249 108 POINT(0 10)
250 109 POINT(-10 0)
251 110 POINT(0 -10)
252 111 POINT(1 1)
253 112 POINT(1000 1000)
254 113 POINT(1000 -1000)
255 114 POINT(-1000 1000)
256 115 POINT(-1000 -1000)
257 SELECT fid, ST_ASTEXT(g) FROM gis_linestring;
258 fid ST_ASTEXT(g)
259 201 LINESTRING(0 0,5 5)
260 202 LINESTRING(0 0,2 2,4 4)
261 203 LINESTRING(0 0,5 5,10 10)
262 204 LINESTRING(10 10,5 5)
263 205 LINESTRING(0 0,12 12,24 24)
264 206 LINESTRING(0 0,50 50,100 100)
265 207 LINESTRING(0 0,5 5)
266 208 LINESTRING(0 0,-5 -5,-10 10)
267 209 LINESTRING(0 0,2 2,4 4,6 6,8 8)
268 210 LINESTRING(0 0,5 5)
269 211 LINESTRING(0 0,-50 -50,10 -10)
270 212 LINESTRING(0 0,1000 1000,1000 -1000)
271 213 LINESTRING(1000 1000,1000 -1000)
272 214 LINESTRING(1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)
273 215 LINESTRING(10 10,10 -10,-10 -10,-10 10,10 10)
274 SELECT fid, ST_ASTEXT(g) FROM gis_polygon;
275 fid ST_ASTEXT(g)
276 301 POLYGON((0 0,0 5,5 5,0 0))
277 302 POLYGON((0 0,0 5,5 5,5 0,0 0))
278 303 POLYGON((0 0,0 10,10 10,10 0,0 0))
279 304 POLYGON((0 0,0 50,50 50,50 0,0 0))
280 305 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))
281 306 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))
282 307 POLYGON((0 0,0 5,5 5,0 0))
283 308 POLYGON((0 0,0 15,15 15,15 0,0 0))
284 309 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))
285 310 POLYGON((0 0,0 5,5 5,0 0))
286 311 POLYGON((10 10,10 15,15 15,15 10,10 10))
287 312 POLYGON((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14))
288 313 POLYGON((0 0,0 10,10 10,10 0,5 5,0 0))
289 314 POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0))
290 315 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))
291 SELECT fid, ST_ASTEXT(g) FROM gis_multi_point;
292 fid ST_ASTEXT(g)
293 401 MULTIPOINT((0 0))
294 402 MULTIPOINT((0 0),(2 2),(4 4))
295 403 MULTIPOINT((0 0),(5 5),(10 10))
296 404 MULTIPOINT((0 0),(100 100))
297 405 MULTIPOINT((0 0),(1000 1000))
298 406 MULTIPOINT((1000 1000),(1000 -1000),(-1000 1000),(-1000 -1000))
299 407 MULTIPOINT((0 0))
300 408 MULTIPOINT((0 0),(10 10))
301 409 MULTIPOINT((0 0),(2 2),(4 4),(6 6))
302 410 MULTIPOINT((0 0))
303 411 MULTIPOINT((0 0),(1000 1000))
304 412 MULTIPOINT((1000 1000),(-1000 1000),(1000 -1000),(-1000 -1000))
305 413 MULTIPOINT((0 0))
306 414 MULTIPOINT((0 0),(1000 1000),(-1000 -1000))
307 415 MULTIPOINT((1000 1000),(1000 -1000),(-1000 1000),(-1000 -1000),(1000 1000))
308 SELECT fid, ST_ASTEXT(g) FROM gis_multi_linestring;
309 fid ST_ASTEXT(g)
310 501 MULTILINESTRING((0 0,2 2))
311 502 MULTILINESTRING((0 0,2 2,4 4))
312 503 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
313 504 MULTILINESTRING((0 0,100 100,-100 -100))
314 505 MULTILINESTRING((1000 1000,-1000 -1000))
315 506 MULTILINESTRING((1000 1000,-1000 -1000),(1000 -1000,-1000 1000))
316 507 MULTILINESTRING((0 0,2 2))
317 508 MULTILINESTRING((0 0,12 12,24 24))
318 509 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
319 510 MULTILINESTRING((0 0,2 2,4 4))
320 511 MULTILINESTRING((0 0,1 1,2 2))
321 512 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50))
322 513 MULTILINESTRING((0 0,10 10),(0 10,10 0))
323 514 MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))
324 515 MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))
325 SELECT fid, ST_ASTEXT(g) FROM gis_multi_polygon;
326 fid ST_ASTEXT(g)
327 601 MULTIPOLYGON(((0 0,0 5,5 5,0 0)))
328 602 MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))
329 603 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
330 604 MULTIPOLYGON(((0 0,0 5,5 5,0 0)))
331 605 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,0 -2,-2 -2,0 0)))
332 606 MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))
333 607 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)))
334 608 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)))
335 609 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((0 0,-5 0,-5 -5,0 -5,0 0)))
336 610 MULTIPOLYGON(((0 0,-5 0,-5 -5,0 -5,0 0)))
337 611 MULTIPOLYGON(((10 10,20 10,20 20,10 20,10 10),(14 14,14 16,16 16,16 14,14 14)))
338 612 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-5 0,-5 -5,0 -5,0 0)))
339 613 MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 5,-5 -5,0 0)))
340 614 MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))
341 615 MULTIPOLYGON(((0 0,5 5,10 0,5 -5,0 0)))
342 SELECT fid, ST_ASTEXT(g) FROM gis_geometrycollection;
343 fid ST_ASTEXT(g)
344 701 GEOMETRYCOLLECTION(POINT(0 0))
345 702 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
346 703 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,0 10,10 10,10 0,0 0)))
347 704 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
348 705 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,0 10,10 10,10 0,0 0)))
349 706 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((0 0,-10 0,-10 -10,0 -10,0 0))))
350 707 GEOMETRYCOLLECTION(POINT(0 0))
351 708 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,2 2,4 4,6 6,8 8),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
352 709 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,0 10)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-10 0,-10 -10,0 0))))
353 710 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,100 100))
354 711 GEOMETRYCOLLECTION(POINT(10 10),LINESTRING(10 10,12 12,14 14,16 16,18 18),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
355 712 GEOMETRYCOLLECTION(MULTIPOINT((10 10),(15 15),(20 20)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,0 10)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-10 0,-10 -10,0 0))))
356 713 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))
357 714 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 0)),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10)),GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0))),GEOMETRYCOLLECTION(MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10))),GEOMETRYCOLLECTION(MULTILINESTRING((0 0,10 10),(0 10,10 0))),GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))))
358 715 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY,POINT(0 0),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)),GEOMETRYCOLLECTION EMPTY,GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))
359 SELECT fid, ST_ASTEXT(g) FROM gis_geometry;
360 fid ST_ASTEXT(g)
361 101 POINT(0 0)
362 102 POINT(1 0)
363 103 POINT(0 1)
364 104 POINT(1 1)
365 105 POINT(-1 1)
366 106 POINT(0 0)
367 107 POINT(10 0)
368 108 POINT(0 10)
369 109 POINT(-10 0)
370 110 POINT(0 -10)
371 111 POINT(1 1)
372 112 POINT(1000 1000)
373 113 POINT(1000 -1000)
374 114 POINT(-1000 1000)
375 115 POINT(-1000 -1000)
376 201 LINESTRING(0 0,5 5)
377 202 LINESTRING(0 0,2 2,4 4)
378 203 LINESTRING(0 0,5 5,10 10)
379 204 LINESTRING(10 10,5 5)
380 205 LINESTRING(0 0,12 12,24 24)
381 206 LINESTRING(0 0,50 50,100 100)
382 207 LINESTRING(0 0,5 5)
383 208 LINESTRING(0 0,-5 -5,-10 10)
384 209 LINESTRING(0 0,2 2,4 4,6 6,8 8)
385 210 LINESTRING(0 0,5 5)
386 211 LINESTRING(0 0,-50 -50,10 -10)
387 212 LINESTRING(0 0,1000 1000,1000 -1000)
388 213 LINESTRING(1000 1000,1000 -1000)
389 214 LINESTRING(1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)
390 215 LINESTRING(10 10,10 -10,-10 -10,-10 10,10 10)
391 301 POLYGON((0 0,0 5,5 5,0 0))
392 302 POLYGON((0 0,0 5,5 5,5 0,0 0))
393 303 POLYGON((0 0,0 10,10 10,10 0,0 0))
394 304 POLYGON((0 0,0 50,50 50,50 0,0 0))
395 305 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))
396 306 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))
397 307 POLYGON((0 0,0 5,5 5,0 0))
398 308 POLYGON((0 0,0 15,15 15,15 0,0 0))
399 309 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))
400 310 POLYGON((0 0,0 5,5 5,0 0))
401 311 POLYGON((10 10,10 15,15 15,15 10,10 10))
402 312 POLYGON((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14))
403 313 POLYGON((0 0,0 10,10 10,10 0,5 5,0 0))
404 314 POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0))
405 315 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))
406 401 MULTIPOINT((0 0))
407 402 MULTIPOINT((0 0),(2 2),(4 4))
408 403 MULTIPOINT((0 0),(5 5),(10 10))
409 404 MULTIPOINT((0 0),(100 100))
410 405 MULTIPOINT((0 0),(1000 1000))
411 406 MULTIPOINT((1000 1000),(1000 -1000),(-1000 1000),(-1000 -1000))
412 407 MULTIPOINT((0 0))
413 408 MULTIPOINT((0 0),(10 10))
414 409 MULTIPOINT((0 0),(2 2),(4 4),(6 6))
415 410 MULTIPOINT((0 0))
416 411 MULTIPOINT((0 0),(1000 1000))
417 412 MULTIPOINT((1000 1000),(-1000 1000),(1000 -1000),(-1000 -1000))
418 413 MULTIPOINT((0 0))
419 414 MULTIPOINT((0 0),(1000 1000),(-1000 -1000))
420 415 MULTIPOINT((1000 1000),(1000 -1000),(-1000 1000),(-1000 -1000),(1000 1000))
421 501 MULTILINESTRING((0 0,2 2))
422 502 MULTILINESTRING((0 0,2 2,4 4))
423 503 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
424 504 MULTILINESTRING((0 0,100 100,-100 -100))
425 505 MULTILINESTRING((1000 1000,-1000 -1000))
426 506 MULTILINESTRING((1000 1000,-1000 -1000),(1000 -1000,-1000 1000))
427 507 MULTILINESTRING((0 0,2 2))
428 508 MULTILINESTRING((0 0,12 12,24 24))
429 509 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
430 510 MULTILINESTRING((0 0,2 2,4 4))
431 511 MULTILINESTRING((0 0,1 1,2 2))
432 512 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50))
433 513 MULTILINESTRING((0 0,10 10),(0 10,10 0))
434 514 MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))
435 515 MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))
436 601 MULTIPOLYGON(((0 0,0 5,5 5,0 0)))
437 602 MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))
438 603 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
439 604 MULTIPOLYGON(((0 0,0 5,5 5,0 0)))
440 605 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,0 -2,-2 -2,0 0)))
441 606 MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))
442 607 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)))
443 608 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)))
444 609 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((0 0,-5 0,-5 -5,0 -5,0 0)))
445 610 MULTIPOLYGON(((0 0,-5 0,-5 -5,0 -5,0 0)))
446 611 MULTIPOLYGON(((10 10,20 10,20 20,10 20,10 10),(14 14,14 16,16 16,16 14,14 14)))
447 612 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-5 0,-5 -5,0 -5,0 0)))
448 613 MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 5,-5 -5,0 0)))
449 614 MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))
450 615 MULTIPOLYGON(((0 0,5 5,10 0,5 -5,0 0)))
451 701 GEOMETRYCOLLECTION(POINT(0 0))
452 702 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
453 703 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,0 10,10 10,10 0,0 0)))
454 704 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
455 705 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,0 10,10 10,10 0,0 0)))
456 706 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((0 0,-10 0,-10 -10,0 -10,0 0))))
457 707 GEOMETRYCOLLECTION(POINT(0 0))
458 708 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,2 2,4 4,6 6,8 8),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
459 709 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,0 10)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-10 0,-10 -10,0 0))))
460 710 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,100 100))
461 711 GEOMETRYCOLLECTION(POINT(10 10),LINESTRING(10 10,12 12,14 14,16 16,18 18),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
462 712 GEOMETRYCOLLECTION(MULTIPOINT((10 10),(15 15),(20 20)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,0 10)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-10 0,-10 -10,0 0))))
463 713 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))
464 714 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 0)),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10)),GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0))),GEOMETRYCOLLECTION(MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10))),GEOMETRYCOLLECTION(MULTILINESTRING((0 0,10 10),(0 10,10 0))),GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))))
465 715 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY,POINT(0 0),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)),GEOMETRYCOLLECTION EMPTY,GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))
466 # Checking the geometry type of the spatial objects inserted into GEOMETRY class
467 SELECT fid, ST_GEOMETRYTYPE(g) FROM gis_geometry;
468 fid ST_GEOMETRYTYPE(g)
469 101 POINT
470 102 POINT
471 103 POINT
472 104 POINT
473 105 POINT
474 106 POINT
475 107 POINT
476 108 POINT
477 109 POINT
478 110 POINT
479 111 POINT
480 112 POINT
481 113 POINT
482 114 POINT
483 115 POINT
484 201 LINESTRING
485 202 LINESTRING
486 203 LINESTRING
487 204 LINESTRING
488 205 LINESTRING
489 206 LINESTRING
490 207 LINESTRING
491 208 LINESTRING
492 209 LINESTRING
493 210 LINESTRING
494 211 LINESTRING
495 212 LINESTRING
496 213 LINESTRING
497 214 LINESTRING
498 215 LINESTRING
499 301 POLYGON
500 302 POLYGON
501 303 POLYGON
502 304 POLYGON
503 305 POLYGON
504 306 POLYGON
505 307 POLYGON
506 308 POLYGON
507 309 POLYGON
508 310 POLYGON
509 311 POLYGON
510 312 POLYGON
511 313 POLYGON
512 314 POLYGON
513 315 POLYGON
514 401 MULTIPOINT
515 402 MULTIPOINT
516 403 MULTIPOINT
517 404 MULTIPOINT
518 405 MULTIPOINT
519 406 MULTIPOINT
520 407 MULTIPOINT
521 408 MULTIPOINT
522 409 MULTIPOINT
523 410 MULTIPOINT
524 411 MULTIPOINT
525 412 MULTIPOINT
526 413 MULTIPOINT
527 414 MULTIPOINT
528 415 MULTIPOINT
529 501 MULTILINESTRING
530 502 MULTILINESTRING
531 503 MULTILINESTRING
532 504 MULTILINESTRING
533 505 MULTILINESTRING
534 506 MULTILINESTRING
535 507 MULTILINESTRING
536 508 MULTILINESTRING
537 509 MULTILINESTRING
538 510 MULTILINESTRING
539 511 MULTILINESTRING
540 512 MULTILINESTRING
541 513 MULTILINESTRING
542 514 MULTILINESTRING
543 515 MULTILINESTRING
544 601 MULTIPOLYGON
545 602 MULTIPOLYGON
546 603 MULTIPOLYGON
547 604 MULTIPOLYGON
548 605 MULTIPOLYGON
549 606 MULTIPOLYGON
550 607 MULTIPOLYGON
551 608 MULTIPOLYGON
552 609 MULTIPOLYGON
553 610 MULTIPOLYGON
554 611 MULTIPOLYGON
555 612 MULTIPOLYGON
556 613 MULTIPOLYGON
557 614 MULTIPOLYGON
558 615 MULTIPOLYGON
559 701 GEOMCOLLECTION
560 702 GEOMCOLLECTION
561 703 GEOMCOLLECTION
562 704 GEOMCOLLECTION
563 705 GEOMCOLLECTION
564 706 GEOMCOLLECTION
565 707 GEOMCOLLECTION
566 708 GEOMCOLLECTION
567 709 GEOMCOLLECTION
568 710 GEOMCOLLECTION
569 711 GEOMCOLLECTION
570 712 GEOMCOLLECTION
571 713 GEOMCOLLECTION
572 714 GEOMCOLLECTION
573 715 GEOMCOLLECTION
574 SELECT COUNT(ST_GEOMETRYTYPE(g)) FROM gis_geometry;
575 COUNT(ST_GEOMETRYTYPE(g))
576 105
577 SELECT COUNT(DISTINCT(ST_GEOMETRYTYPE(g))) FROM gis_geometry;
578 COUNT(DISTINCT(ST_GEOMETRYTYPE(g)))
579 7
580 # Checking the ST_SRID of the spatial objects inserted into GEOMETRY class
581 SELECT fid, ST_SRID(g) FROM gis_geometry;
582 fid ST_SRID(g)
583 101 0
584 102 0
585 103 0
586 104 0
587 105 0
588 106 0
589 107 0
590 108 0
591 109 0
592 110 0
593 111 0
594 112 0
595 113 0
596 114 0
597 115 0
598 201 0
599 202 0
600 203 0
601 204 0
602 205 0
603 206 0
604 207 0
605 208 0
606 209 0
607 210 0
608 211 0
609 212 0
610 213 0
611 214 0
612 215 0
613 301 0
614 302 0
615 303 0
616 304 0
617 305 0
618 306 0
619 307 0
620 308 0
621 309 0
622 310 0
623 311 0
624 312 0
625 313 0
626 314 0
627 315 0
628 401 0
629 402 0
630 403 0
631 404 0
632 405 0
633 406 0
634 407 0
635 408 0
636 409 0
637 410 0
638 411 0
639 412 0
640 413 0
641 414 0
642 415 0
643 501 0
644 502 0
645 503 0
646 504 0
647 505 0
648 506 0
649 507 0
650 508 0
651 509 0
652 510 0
653 511 0
654 512 0
655 513 0
656 514 0
657 515 0
658 601 0
659 602 0
660 603 0
661 604 0
662 605 0
663 606 0
664 607 0
665 608 0
666 609 0
667 610 0
668 611 0
669 612 0
670 613 0
671 614 0
672 615 0
673 701 0
674 702 0
675 703 0
676 704 0
677 705 0
678 706 0
679 707 0
680 708 0
681 709 0
682 710 0
683 711 0
684 712 0
685 713 0
686 714 0
687 715 0
688 SELECT COUNT(ST_SRID(g)) FROM gis_geometry;
689 COUNT(ST_SRID(g))
690 105
691 SELECT COUNT(DISTINCT(ST_SRID(g))) FROM gis_geometry;
692 COUNT(DISTINCT(ST_SRID(g)))
693 1
694 # Checking the Dimension of the spatial objects inserted into GEOMETRY class
695 SELECT fid, ST_DIMENSION(g) FROM gis_geometry;
696 fid ST_DIMENSION(g)
697 101 0
698 102 0
699 103 0
700 104 0
701 105 0
702 106 0
703 107 0
704 108 0
705 109 0
706 110 0
707 111 0
708 112 0
709 113 0
710 114 0
711 115 0
712 201 1
713 202 1
714 203 1
715 204 1
716 205 1
717 206 1
718 207 1
719 208 1
720 209 1
721 210 1
722 211 1
723 212 1
724 213 1
725 214 1
726 215 1
727 301 2
728 302 2
729 303 2
730 304 2
731 305 2
732 306 2
733 307 2
734 308 2
735 309 2
736 310 2
737 311 2
738 312 2
739 313 2
740 314 2
741 315 2
742 401 0
743 402 0
744 403 0
745 404 0
746 405 0
747 406 0
748 407 0
749 408 0
750 409 0
751 410 0
752 411 0
753 412 0
754 413 0
755 414 0
756 415 0
757 501 1
758 502 1
759 503 1
760 504 1
761 505 1
762 506 1
763 507 1
764 508 1
765 509 1
766 510 1
767 511 1
768 512 1
769 513 1
770 514 1
771 515 1
772 601 2
773 602 2
774 603 2
775 604 2
776 605 2
777 606 2
778 607 2
779 608 2
780 609 2
781 610 2
782 611 2
783 612 2
784 613 2
785 614 2
786 615 2
787 701 0
788 702 1
789 703 2
790 704 1
791 705 2
792 706 2
793 707 0
794 708 2
795 709 2
796 710 1
797 711 2
798 712 2
799 713 2
800 714 2
801 715 NULL
802 SELECT COUNT(ST_DIMENSION(g)) FROM gis_geometry;
803 COUNT(ST_DIMENSION(g))
804 104
805 SELECT COUNT(DISTINCT(ST_DIMENSION(g))) FROM gis_geometry;
806 COUNT(DISTINCT(ST_DIMENSION(g)))
807 3
808 # Checking if the geometries are simple or not
809 SELECT fid, ST_ISSIMPLE(g) FROM gis_geometry;
810 fid ST_ISSIMPLE(g)
811 101 1
812 102 1
813 103 1
814 104 1
815 105 1
816 106 1
817 107 1
818 108 1
819 109 1
820 110 1
821 111 1
822 112 1
823 113 1
824 114 1
825 115 1
826 201 1
827 202 1
828 203 1
829 204 1
830 205 1
831 206 1
832 207 1
833 208 1
834 209 1
835 210 1
836 211 1
837 212 1
838 213 1
839 214 1
840 215 1
841 301 1
842 302 1
843 303 1
844 304 1
845 305 1
846 306 1
847 307 1
848 308 1
849 309 1
850 310 1
851 311 1
852 312 1
853 313 1
854 314 1
855 315 1
856 401 1
857 402 1
858 403 1
859 404 1
860 405 1
861 406 1
862 407 1
863 408 1
864 409 1
865 410 1
866 411 1
867 412 1
868 413 1
869 414 1
870 415 0
871 501 1
872 502 1
873 503 1
874 504 0
875 505 1
876 506 0
877 507 1
878 508 1
879 509 1
880 510 1
881 511 1
882 512 1
883 513 0
884 514 0
885 515 1
886 601 1
887 602 1
888 603 1
889 604 1
890 605 1
891 606 1
892 607 1
893 608 1
894 609 1
895 610 1
896 611 1
897 612 1
898 613 1
899 614 1
900 615 1
901 701 1
902 702 1
903 703 0
904 704 1
905 705 0
906 706 0
907 707 1
908 708 0
909 709 0
910 710 1
911 711 1
912 712 0
913 713 0
914 714 0
915 715 0
916 SELECT COUNT(ST_ISSIMPLE(g)) FROM gis_geometry;
917 COUNT(ST_ISSIMPLE(g))
918 105
919 SELECT COUNT(DISTINCT(ST_ISSIMPLE(g))) FROM gis_geometry;
920 COUNT(DISTINCT(ST_ISSIMPLE(g)))
921 2
922 # Checking the Envelope of the spatial objects inserted into GEOMETRY class
923 SELECT fid, ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometry;
924 fid ST_ASTEXT(ST_ENVELOPE(g))
925 101 POINT(0 0)
926 102 POINT(1 0)
927 103 POINT(0 1)
928 104 POINT(1 1)
929 105 POINT(-1 1)
930 106 POINT(0 0)
931 107 POINT(10 0)
932 108 POINT(0 10)
933 109 POINT(-10 0)
934 110 POINT(0 -10)
935 111 POINT(1 1)
936 112 POINT(1000 1000)
937 113 POINT(1000 -1000)
938 114 POINT(-1000 1000)
939 115 POINT(-1000 -1000)
940 201 POLYGON((0 0,5 0,5 5,0 5,0 0))
941 202 POLYGON((0 0,4 0,4 4,0 4,0 0))
942 203 POLYGON((0 0,10 0,10 10,0 10,0 0))
943 204 POLYGON((5 5,10 5,10 10,5 10,5 5))
944 205 POLYGON((0 0,24 0,24 24,0 24,0 0))
945 206 POLYGON((0 0,100 0,100 100,0 100,0 0))
946 207 POLYGON((0 0,5 0,5 5,0 5,0 0))
947 208 POLYGON((-10 -5,0 -5,0 10,-10 10,-10 -5))
948 209 POLYGON((0 0,8 0,8 8,0 8,0 0))
949 210 POLYGON((0 0,5 0,5 5,0 5,0 0))
950 211 POLYGON((-50 -50,10 -50,10 0,-50 0,-50 -50))
951 212 POLYGON((0 -1000,1000 -1000,1000 1000,0 1000,0 -1000))
952 213 LINESTRING(1000 -1000,1000 1000)
953 214 POLYGON((1 1,9 1,9 9,1 9,1 1))
954 215 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
955 301 POLYGON((0 0,5 0,5 5,0 5,0 0))
956 302 POLYGON((0 0,5 0,5 5,0 5,0 0))
957 303 POLYGON((0 0,10 0,10 10,0 10,0 0))
958 304 POLYGON((0 0,50 0,50 50,0 50,0 0))
959 305 POLYGON((0 0,10 0,10 10,0 10,0 0))
960 306 POLYGON((0 0,10 0,10 10,0 10,0 0))
961 307 POLYGON((0 0,5 0,5 5,0 5,0 0))
962 308 POLYGON((0 0,15 0,15 15,0 15,0 0))
963 309 POLYGON((0 0,10 0,10 10,0 10,0 0))
964 310 POLYGON((0 0,5 0,5 5,0 5,0 0))
965 311 POLYGON((10 10,15 10,15 15,10 15,10 10))
966 312 POLYGON((10 10,20 10,20 20,10 20,10 10))
967 313 POLYGON((0 0,10 0,10 10,0 10,0 0))
968 314 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
969 315 POLYGON((0 0,10 0,10 10,0 10,0 0))
970 401 POINT(0 0)
971 402 POLYGON((0 0,4 0,4 4,0 4,0 0))
972 403 POLYGON((0 0,10 0,10 10,0 10,0 0))
973 404 POLYGON((0 0,100 0,100 100,0 100,0 0))
974 405 POLYGON((0 0,1000 0,1000 1000,0 1000,0 0))
975 406 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
976 407 POINT(0 0)
977 408 POLYGON((0 0,10 0,10 10,0 10,0 0))
978 409 POLYGON((0 0,6 0,6 6,0 6,0 0))
979 410 POINT(0 0)
980 411 POLYGON((0 0,1000 0,1000 1000,0 1000,0 0))
981 412 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
982 413 POINT(0 0)
983 414 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
984 415 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
985 501 POLYGON((0 0,2 0,2 2,0 2,0 0))
986 502 POLYGON((0 0,4 0,4 4,0 4,0 0))
987 503 POLYGON((0 0,10 0,10 10,0 10,0 0))
988 504 POLYGON((-100 -100,100 -100,100 100,-100 100,-100 -100))
989 505 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
990 506 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
991 507 POLYGON((0 0,2 0,2 2,0 2,0 0))
992 508 POLYGON((0 0,24 0,24 24,0 24,0 0))
993 509 POLYGON((0 0,10 0,10 10,0 10,0 0))
994 510 POLYGON((0 0,4 0,4 4,0 4,0 0))
995 511 POLYGON((0 0,2 0,2 2,0 2,0 0))
996 512 POLYGON((0 0,50 0,50 50,0 50,0 0))
997 513 POLYGON((0 0,10 0,10 10,0 10,0 0))
998 514 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
999 515 POLYGON((-100 -100,100 -100,100 100,-100 100,-100 -100))
1000 601 POLYGON((0 0,5 0,5 5,0 5,0 0))
1001 602 POLYGON((0 0,10 0,10 10,0 10,0 0))
1002 603 POLYGON((0 0,10 0,10 10,0 10,0 0))
1003 604 POLYGON((0 0,5 0,5 5,0 5,0 0))
1004 605 POLYGON((-2 -2,10 -2,10 10,-2 10,-2 -2))
1005 606 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1006 607 POLYGON((0 0,5 0,5 5,0 5,0 0))
1007 608 POLYGON((0 0,10 0,10 10,0 10,0 0))
1008 609 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1009 610 POLYGON((-5 -5,0 -5,0 0,-5 0,-5 -5))
1010 611 POLYGON((10 10,20 10,20 20,10 20,10 10))
1011 612 POLYGON((-5 -5,10 -5,10 10,-5 10,-5 -5))
1012 613 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1013 614 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1014 615 POLYGON((0 -5,10 -5,10 5,0 5,0 -5))
1015 701 POINT(0 0)
1016 702 POLYGON((0 0,10 0,10 10,0 10,0 0))
1017 703 POLYGON((0 0,10 0,10 10,0 10,0 0))
1018 704 POLYGON((0 0,10 0,10 10,0 10,0 0))
1019 705 POLYGON((0 0,10 0,10 10,0 10,0 0))
1020 706 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1021 707 POINT(0 0)
1022 708 POLYGON((0 0,10 0,10 10,0 10,0 0))
1023 709 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1024 710 POLYGON((0 0,100 0,100 100,0 100,0 0))
1025 711 POLYGON((0 0,18 0,18 18,0 18,0 0))
1026 712 POLYGON((-10 -10,20 -10,20 20,-10 20,-10 -10))
1027 713 POLYGON((0 0,10 0,10 10,0 10,0 0))
1028 714 POLYGON((0 0,10 0,10 10,0 10,0 0))
1029 715 POLYGON((0 0,10 0,10 10,0 10,0 0))
1030 SELECT COUNT(ST_ENVELOPE(g)) FROM gis_geometry;
1031 COUNT(ST_ENVELOPE(g))
1032 105
1033 SELECT COUNT(DISTINCT(ST_ENVELOPE(g))) FROM gis_geometry;
1034 COUNT(DISTINCT(ST_ENVELOPE(g)))
1035 42
1036 # Checking the Centroid of the spatial objects inserted into GEOMETRY class
1037 SELECT fid, ST_ASTEXT(ST_CENTROID(g)) FROM gis_geometry;
1038 fid ST_ASTEXT(ST_CENTROID(g))
1039 101 POINT(0 0)
1040 102 POINT(1 0)
1041 103 POINT(0 1)
1042 104 POINT(1 1)
1043 105 POINT(-1 1)
1044 106 POINT(0 0)
1045 107 POINT(10 0)
1046 108 POINT(0 10)
1047 109 POINT(-10 0)
1048 110 POINT(0 -10)
1049 111 POINT(1 1)
1050 112 POINT(1000 1000)
1051 113 POINT(1000 -1000)
1052 114 POINT(-1000 1000)
1053 115 POINT(-1000 -1000)
1054 201 POINT(2.5 2.5)
1055 202 POINT(2 2)
1056 203 POINT(5 5)
1057 204 POINT(7.5 7.5)
1058 205 POINT(12 12)
1059 206 POINT(50 50)
1060 207 POINT(2.5 2.5)
1061 208 POINT(-5.9549150281 0.9549150281)
1062 209 POINT(4 4)
1063 210 POINT(2.5 2.5)
1064 211 POINT(-22.4754878398 -27.5245121602)
1065 212 POINT(792.8932188135 207.1067811865)
1066 213 POINT(1000 0)
1067 214 POINT(5 5)
1068 215 POINT(0 0)
1069 301 POINT(1.6666666667 3.3333333333)
1070 302 POINT(2.5 2.5)
1071 303 POINT(5 5)
1072 304 POINT(25 25)
1073 305 POINT(5 5)
1074 306 POINT(5 5)
1075 307 POINT(1.6666666667 3.3333333333)
1076 308 POINT(7.5 7.5)
1077 309 POINT(5 5)
1078 310 POINT(1.6666666667 3.3333333333)
1079 311 POINT(12.5 12.5)
1080 312 POINT(15 15)
1081 313 POINT(5 6.1111111111)
1082 314 POINT(0 3.3333333333)
1083 315 POINT(5 5)
1084 401 POINT(0 0)
1085 402 POINT(2 2)
1086 403 POINT(5 5)
1087 404 POINT(50 50)
1088 405 POINT(500 500)
1089 406 POINT(0 0)
1090 407 POINT(0 0)
1091 408 POINT(5 5)
1092 409 POINT(3 3)
1093 410 POINT(0 0)
1094 411 POINT(500 500)
1095 412 POINT(0 0)
1096 413 POINT(0 0)
1097 414 POINT(0 0)
1098 415 POINT(200 200)
1099 501 POINT(1 1)
1100 502 POINT(2 2)
1101 503 POINT(5 5)
1102 504 POINT(16.6666666667 16.6666666667)
1103 505 POINT(0 0)
1104 506 POINT(0 0)
1105 507 POINT(1 1)
1106 508 POINT(12 12)
1107 509 POINT(5 5)
1108 510 POINT(2 2)
1109 511 POINT(1 1)
1110 512 POINT(23.4210526316 23.4210526316)
1111 513 POINT(5 5)
1112 514 POINT(0 0)
1113 515 POINT(0 0)
1114 601 POINT(1.6666666667 3.3333333333)
1115 602 POINT(4.1666666667 5.8333333333)
1116 603 POINT(5 5)
1117 604 POINT(1.6666666667 3.3333333333)
1118 605 POINT(4.8843537415 4.8707482993)
1119 606 POINT(0 0)
1120 607 POINT(2.5 2.5)
1121 608 POINT(5 5)
1122 609 POINT(0 0)
1123 610 POINT(-2.5 -2.5)
1124 611 POINT(15 15)
1125 612 POINT(3.4504132231 3.4504132231)
1126 613 POINT(0 0)
1127 614 POINT(0 0)
1128 615 POINT(5 0)
1129 701 POINT(0 0)
1130 702 POINT(5 5)
1131 703 POINT(5 5)
1132 704 POINT(5 5)
1133 705 POINT(5 5)
1134 706 POINT(0 0)
1135 707 POINT(0 0)
1136 708 POINT(5 5)
1137 709 POINT(1.00456621 2.1461187215)
1138 710 POINT(50 50)
1139 711 POINT(5 5)
1140 712 POINT(1.00456621 2.1461187215)
1141 713 POINT(5 5)
1142 714 POINT(5 5)
1143 715 POINT(5 5)
1144 SELECT COUNT(ST_CENTROID(g)) FROM gis_geometry;
1145 COUNT(ST_CENTROID(g))
1146 105
1147 SELECT COUNT(DISTINCT(ST_CENTROID(g))) FROM gis_geometry;
1148 COUNT(DISTINCT(ST_CENTROID(g)))
1149 42
1150 # Checking the ConvexHull of the spatial objects inserted into GEOMETRY class
1151 SELECT fid, ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometry;
1152 fid ST_ASTEXT(ST_CONVEXHULL(g))
1153 101 POINT(0 0)
1154 102 POINT(1 0)
1155 103 POINT(0 1)
1156 104 POINT(1 1)
1157 105 POINT(-1 1)
1158 106 POINT(0 0)
1159 107 POINT(10 0)
1160 108 POINT(0 10)
1161 109 POINT(-10 0)
1162 110 POINT(0 -10)
1163 111 POINT(1 1)
1164 112 POINT(1000 1000)
1165 113 POINT(1000 -1000)
1166 114 POINT(-1000 1000)
1167 115 POINT(-1000 -1000)
1168 201 LINESTRING(0 0,5 5)
1169 202 LINESTRING(0 0,4 4)
1170 203 LINESTRING(0 0,10 10)
1171 204 LINESTRING(5 5,10 10)
1172 205 LINESTRING(0 0,24 24)
1173 206 LINESTRING(0 0,100 100)
1174 207 LINESTRING(0 0,5 5)
1175 208 POLYGON((-10 10,-5 -5,0 0,-10 10))
1176 209 LINESTRING(0 0,8 8)
1177 210 LINESTRING(0 0,5 5)
1178 211 POLYGON((-50 -50,10 -10,0 0,-50 -50))
1179 212 POLYGON((0 0,1000 -1000,1000 1000,0 0))
1180 213 LINESTRING(1000 -1000,1000 1000)
1181 214 LINESTRING(1 1,9 9)
1182 215 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1183 301 POLYGON((0 0,5 5,0 5,0 0))
1184 302 POLYGON((0 0,5 0,5 5,0 5,0 0))
1185 303 POLYGON((0 0,10 0,10 10,0 10,0 0))
1186 304 POLYGON((0 0,50 0,50 50,0 50,0 0))
1187 305 POLYGON((0 0,10 0,10 10,0 10,0 0))
1188 306 POLYGON((0 0,10 0,10 10,0 10,0 0))
1189 307 POLYGON((0 0,5 5,0 5,0 0))
1190 308 POLYGON((0 0,15 0,15 15,0 15,0 0))
1191 309 POLYGON((0 0,10 0,10 10,0 10,0 0))
1192 310 POLYGON((0 0,5 5,0 5,0 0))
1193 311 POLYGON((10 10,15 10,15 15,10 15,10 10))
1194 312 POLYGON((10 10,20 10,20 20,10 20,10 10))
1195 313 POLYGON((0 0,10 0,10 10,0 10,0 0))
1196 314 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1197 315 POLYGON((0 0,10 0,10 10,0 10,0 0))
1198 401 POINT(0 0)
1199 402 LINESTRING(0 0,4 4)
1200 403 LINESTRING(0 0,10 10)
1201 404 LINESTRING(0 0,100 100)
1202 405 LINESTRING(0 0,1000 1000)
1203 406 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1204 407 POINT(0 0)
1205 408 LINESTRING(0 0,10 10)
1206 409 LINESTRING(0 0,6 6)
1207 410 POINT(0 0)
1208 411 LINESTRING(0 0,1000 1000)
1209 412 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1210 413 POINT(0 0)
1211 414 LINESTRING(-1000 -1000,1000 1000)
1212 415 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1213 501 LINESTRING(0 0,2 2)
1214 502 LINESTRING(0 0,4 4)
1215 503 LINESTRING(0 0,10 10)
1216 504 LINESTRING(-100 -100,100 100)
1217 505 LINESTRING(-1000 -1000,1000 1000)
1218 506 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1219 507 LINESTRING(0 0,2 2)
1220 508 LINESTRING(0 0,24 24)
1221 509 LINESTRING(0 0,10 10)
1222 510 LINESTRING(0 0,4 4)
1223 511 LINESTRING(0 0,2 2)
1224 512 LINESTRING(0 0,50 50)
1225 513 POLYGON((0 0,10 0,10 10,0 10,0 0))
1226 514 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1227 515 POLYGON((-100 0,0 -100,100 0,0 100,-100 0))
1228 601 POLYGON((0 0,5 5,0 5,0 0))
1229 602 POLYGON((0 0,10 10,5 10,0 5,0 0))
1230 603 POLYGON((0 0,10 0,10 10,0 10,0 0))
1231 604 POLYGON((0 0,5 5,0 5,0 0))
1232 605 POLYGON((-2 -2,0 -2,10 0,10 10,0 10,-2 -2))
1233 606 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1234 607 POLYGON((0 0,5 0,5 5,0 5,0 0))
1235 608 POLYGON((0 0,10 0,10 10,0 10,0 0))
1236 609 POLYGON((-5 -5,0 -5,5 0,5 5,0 5,-5 0,-5 -5))
1237 610 POLYGON((-5 -5,0 -5,0 0,-5 0,-5 -5))
1238 611 POLYGON((10 10,20 10,20 20,10 20,10 10))
1239 612 POLYGON((-5 -5,0 -5,10 0,10 10,0 10,-5 0,-5 -5))
1240 613 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1241 614 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1242 615 POLYGON((0 0,5 -5,10 0,5 5,0 0))
1243 701 POINT(0 0)
1244 702 LINESTRING(0 0,10 10)
1245 703 POLYGON((0 0,10 0,10 10,0 10,0 0))
1246 704 LINESTRING(0 0,10 10)
1247 705 POLYGON((0 0,10 0,10 10,0 10,0 0))
1248 706 POLYGON((-10 -10,0 -10,10 0,10 10,0 10,-10 0,-10 -10))
1249 707 POINT(0 0)
1250 708 POLYGON((0 0,10 0,10 10,0 10,0 0))
1251 709 POLYGON((-10 -10,10 0,10 10,0 10,-10 0,-10 -10))
1252 710 LINESTRING(0 0,100 100)
1253 711 POLYGON((0 0,10 0,18 18,0 10,0 0))
1254 712 POLYGON((-10 -10,10 0,20 20,0 10,-10 0,-10 -10))
1255 713 POLYGON((0 0,10 0,10 10,0 10,0 0))
1256 714 POLYGON((0 0,10 0,10 10,0 10,0 0))
1257 715 POLYGON((0 0,10 0,10 10,0 10,0 0))
1258 SELECT COUNT(ST_CONVEXHULL(g)) FROM gis_geometry;
1259 COUNT(ST_CONVEXHULL(g))
1260 105
1261 SELECT COUNT(DISTINCT(ST_CONVEXHULL(g))) FROM gis_geometry;
1262 COUNT(DISTINCT(ST_CONVEXHULL(g)))
1263 52
1264 # Checking if the geometries are empty or not
1265 SELECT fid, ST_ISEMPTY(g) FROM gis_geometry;
1266 fid ST_ISEMPTY(g)
1267 101 0
1268 102 0
1269 103 0
1270 104 0
1271 105 0
1272 106 0
1273 107 0
1274 108 0
1275 109 0
1276 110 0
1277 111 0
1278 112 0
1279 113 0
1280 114 0
1281 115 0
1282 201 0
1283 202 0
1284 203 0
1285 204 0
1286 205 0
1287 206 0
1288 207 0
1289 208 0
1290 209 0
1291 210 0
1292 211 0
1293 212 0
1294 213 0
1295 214 0
1296 215 0
1297 301 0
1298 302 0
1299 303 0
1300 304 0
1301 305 0
1302 306 0
1303 307 0
1304 308 0
1305 309 0
1306 310 0
1307 311 0
1308 312 0
1309 313 0
1310 314 0
1311 315 0
1312 401 0
1313 402 0
1314 403 0
1315 404 0
1316 405 0
1317 406 0
1318 407 0
1319 408 0
1320 409 0
1321 410 0
1322 411 0
1323 412 0
1324 413 0
1325 414 0
1326 415 0
1327 501 0
1328 502 0
1329 503 0
1330 504 0
1331 505 0
1332 506 0
1333 507 0
1334 508 0
1335 509 0
1336 510 0
1337 511 0
1338 512 0
1339 513 0
1340 514 0
1341 515 0
1342 601 0
1343 602 0
1344 603 0
1345 604 0
1346 605 0
1347 606 0
1348 607 0
1349 608 0
1350 609 0
1351 610 0
1352 611 0
1353 612 0
1354 613 0
1355 614 0
1356 615 0
1357 701 0
1358 702 0
1359 703 0
1360 704 0
1361 705 0
1362 706 0
1363 707 0
1364 708 0
1365 709 0
1366 710 0
1367 711 0
1368 712 0
1369 713 0
1370 714 0
1371 715 0
1372 SELECT COUNT(ST_ISEMPTY(g)) FROM gis_geometry;
1373 COUNT(ST_ISEMPTY(g))
1374 105
1375 SELECT COUNT(DISTINCT(ST_ISEMPTY(g))) FROM gis_geometry;
1376 COUNT(DISTINCT(ST_ISEMPTY(g)))
1377 1
1378 # Check the procedure to work with the Geometry type properties
1379 CREATE PROCEDURE geom_attri()
1380 BEGIN
1381 SELECT fid, ST_GEOMETRYTYPE(g) FROM gis_geometry;
1382 SELECT fid, ST_SRID(g) FROM gis_geometry;
1383 SELECT fid, ST_DIMENSION(g) FROM gis_geometry;
1384 SELECT fid, ST_ISSIMPLE(g) FROM gis_geometry;
1385 SELECT fid, ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometry;
1386 SELECT fid, ST_ASTEXT(ST_CENTROID(g)) FROM gis_geometry;
1387 SELECT fid, ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometry;
1388 SELECT fid, ST_ISEMPTY(g) FROM gis_geometry;
1389 END |
1390 # Call the proc
1391 CALL geom_attri;
1392 fid ST_GEOMETRYTYPE(g)
1393 101 POINT
1394 102 POINT
1395 103 POINT
1396 104 POINT
1397 105 POINT
1398 106 POINT
1399 107 POINT
1400 108 POINT
1401 109 POINT
1402 110 POINT
1403 111 POINT
1404 112 POINT
1405 113 POINT
1406 114 POINT
1407 115 POINT
1408 201 LINESTRING
1409 202 LINESTRING
1410 203 LINESTRING
1411 204 LINESTRING
1412 205 LINESTRING
1413 206 LINESTRING
1414 207 LINESTRING
1415 208 LINESTRING
1416 209 LINESTRING
1417 210 LINESTRING
1418 211 LINESTRING
1419 212 LINESTRING
1420 213 LINESTRING
1421 214 LINESTRING
1422 215 LINESTRING
1423 301 POLYGON
1424 302 POLYGON
1425 303 POLYGON
1426 304 POLYGON
1427 305 POLYGON
1428 306 POLYGON
1429 307 POLYGON
1430 308 POLYGON
1431 309 POLYGON
1432 310 POLYGON
1433 311 POLYGON
1434 312 POLYGON
1435 313 POLYGON
1436 314 POLYGON
1437 315 POLYGON
1438 401 MULTIPOINT
1439 402 MULTIPOINT
1440 403 MULTIPOINT
1441 404 MULTIPOINT
1442 405 MULTIPOINT
1443 406 MULTIPOINT
1444 407 MULTIPOINT
1445 408 MULTIPOINT
1446 409 MULTIPOINT
1447 410 MULTIPOINT
1448 411 MULTIPOINT
1449 412 MULTIPOINT
1450 413 MULTIPOINT
1451 414 MULTIPOINT
1452 415 MULTIPOINT
1453 501 MULTILINESTRING
1454 502 MULTILINESTRING
1455 503 MULTILINESTRING
1456 504 MULTILINESTRING
1457 505 MULTILINESTRING
1458 506 MULTILINESTRING
1459 507 MULTILINESTRING
1460 508 MULTILINESTRING
1461 509 MULTILINESTRING
1462 510 MULTILINESTRING
1463 511 MULTILINESTRING
1464 512 MULTILINESTRING
1465 513 MULTILINESTRING
1466 514 MULTILINESTRING
1467 515 MULTILINESTRING
1468 601 MULTIPOLYGON
1469 602 MULTIPOLYGON
1470 603 MULTIPOLYGON
1471 604 MULTIPOLYGON
1472 605 MULTIPOLYGON
1473 606 MULTIPOLYGON
1474 607 MULTIPOLYGON
1475 608 MULTIPOLYGON
1476 609 MULTIPOLYGON
1477 610 MULTIPOLYGON
1478 611 MULTIPOLYGON
1479 612 MULTIPOLYGON
1480 613 MULTIPOLYGON
1481 614 MULTIPOLYGON
1482 615 MULTIPOLYGON
1483 701 GEOMCOLLECTION
1484 702 GEOMCOLLECTION
1485 703 GEOMCOLLECTION
1486 704 GEOMCOLLECTION
1487 705 GEOMCOLLECTION
1488 706 GEOMCOLLECTION
1489 707 GEOMCOLLECTION
1490 708 GEOMCOLLECTION
1491 709 GEOMCOLLECTION
1492 710 GEOMCOLLECTION
1493 711 GEOMCOLLECTION
1494 712 GEOMCOLLECTION
1495 713 GEOMCOLLECTION
1496 714 GEOMCOLLECTION
1497 715 GEOMCOLLECTION
1498 fid ST_SRID(g)
1499 101 0
1500 102 0
1501 103 0
1502 104 0
1503 105 0
1504 106 0
1505 107 0
1506 108 0
1507 109 0
1508 110 0
1509 111 0
1510 112 0
1511 113 0
1512 114 0
1513 115 0
1514 201 0
1515 202 0
1516 203 0
1517 204 0
1518 205 0
1519 206 0
1520 207 0
1521 208 0
1522 209 0
1523 210 0
1524 211 0
1525 212 0
1526 213 0
1527 214 0
1528 215 0
1529 301 0
1530 302 0
1531 303 0
1532 304 0
1533 305 0
1534 306 0
1535 307 0
1536 308 0
1537 309 0
1538 310 0
1539 311 0
1540 312 0
1541 313 0
1542 314 0
1543 315 0
1544 401 0
1545 402 0
1546 403 0
1547 404 0
1548 405 0
1549 406 0
1550 407 0
1551 408 0
1552 409 0
1553 410 0
1554 411 0
1555 412 0
1556 413 0
1557 414 0
1558 415 0
1559 501 0
1560 502 0
1561 503 0
1562 504 0
1563 505 0
1564 506 0
1565 507 0
1566 508 0
1567 509 0
1568 510 0
1569 511 0
1570 512 0
1571 513 0
1572 514 0
1573 515 0
1574 601 0
1575 602 0
1576 603 0
1577 604 0
1578 605 0
1579 606 0
1580 607 0
1581 608 0
1582 609 0
1583 610 0
1584 611 0
1585 612 0
1586 613 0
1587 614 0
1588 615 0
1589 701 0
1590 702 0
1591 703 0
1592 704 0
1593 705 0
1594 706 0
1595 707 0
1596 708 0
1597 709 0
1598 710 0
1599 711 0
1600 712 0
1601 713 0
1602 714 0
1603 715 0
1604 fid ST_DIMENSION(g)
1605 101 0
1606 102 0
1607 103 0
1608 104 0
1609 105 0
1610 106 0
1611 107 0
1612 108 0
1613 109 0
1614 110 0
1615 111 0
1616 112 0
1617 113 0
1618 114 0
1619 115 0
1620 201 1
1621 202 1
1622 203 1
1623 204 1
1624 205 1
1625 206 1
1626 207 1
1627 208 1
1628 209 1
1629 210 1
1630 211 1
1631 212 1
1632 213 1
1633 214 1
1634 215 1
1635 301 2
1636 302 2
1637 303 2
1638 304 2
1639 305 2
1640 306 2
1641 307 2
1642 308 2
1643 309 2
1644 310 2
1645 311 2
1646 312 2
1647 313 2
1648 314 2
1649 315 2
1650 401 0
1651 402 0
1652 403 0
1653 404 0
1654 405 0
1655 406 0
1656 407 0
1657 408 0
1658 409 0
1659 410 0
1660 411 0
1661 412 0
1662 413 0
1663 414 0
1664 415 0
1665 501 1
1666 502 1
1667 503 1
1668 504 1
1669 505 1
1670 506 1
1671 507 1
1672 508 1
1673 509 1
1674 510 1
1675 511 1
1676 512 1
1677 513 1
1678 514 1
1679 515 1
1680 601 2
1681 602 2
1682 603 2
1683 604 2
1684 605 2
1685 606 2
1686 607 2
1687 608 2
1688 609 2
1689 610 2
1690 611 2
1691 612 2
1692 613 2
1693 614 2
1694 615 2
1695 701 0
1696 702 1
1697 703 2
1698 704 1
1699 705 2
1700 706 2
1701 707 0
1702 708 2
1703 709 2
1704 710 1
1705 711 2
1706 712 2
1707 713 2
1708 714 2
1709 715 NULL
1710 fid ST_ISSIMPLE(g)
1711 101 1
1712 102 1
1713 103 1
1714 104 1
1715 105 1
1716 106 1
1717 107 1
1718 108 1
1719 109 1
1720 110 1
1721 111 1
1722 112 1
1723 113 1
1724 114 1
1725 115 1
1726 201 1
1727 202 1
1728 203 1
1729 204 1
1730 205 1
1731 206 1
1732 207 1
1733 208 1
1734 209 1
1735 210 1
1736 211 1
1737 212 1
1738 213 1
1739 214 1
1740 215 1
1741 301 1
1742 302 1
1743 303 1
1744 304 1
1745 305 1
1746 306 1
1747 307 1
1748 308 1
1749 309 1
1750 310 1
1751 311 1
1752 312 1
1753 313 1
1754 314 1
1755 315 1
1756 401 1
1757 402 1
1758 403 1
1759 404 1
1760 405 1
1761 406 1
1762 407 1
1763 408 1
1764 409 1
1765 410 1
1766 411 1
1767 412 1
1768 413 1
1769 414 1
1770 415 0
1771 501 1
1772 502 1
1773 503 1
1774 504 0
1775 505 1
1776 506 0
1777 507 1
1778 508 1
1779 509 1
1780 510 1
1781 511 1
1782 512 1
1783 513 0
1784 514 0
1785 515 1
1786 601 1
1787 602 1
1788 603 1
1789 604 1
1790 605 1
1791 606 1
1792 607 1
1793 608 1
1794 609 1
1795 610 1
1796 611 1
1797 612 1
1798 613 1
1799 614 1
1800 615 1
1801 701 1
1802 702 1
1803 703 0
1804 704 1
1805 705 0
1806 706 0
1807 707 1
1808 708 0
1809 709 0
1810 710 1
1811 711 1
1812 712 0
1813 713 0
1814 714 0
1815 715 0
1816 fid ST_ASTEXT(ST_ENVELOPE(g))
1817 101 POINT(0 0)
1818 102 POINT(1 0)
1819 103 POINT(0 1)
1820 104 POINT(1 1)
1821 105 POINT(-1 1)
1822 106 POINT(0 0)
1823 107 POINT(10 0)
1824 108 POINT(0 10)
1825 109 POINT(-10 0)
1826 110 POINT(0 -10)
1827 111 POINT(1 1)
1828 112 POINT(1000 1000)
1829 113 POINT(1000 -1000)
1830 114 POINT(-1000 1000)
1831 115 POINT(-1000 -1000)
1832 201 POLYGON((0 0,5 0,5 5,0 5,0 0))
1833 202 POLYGON((0 0,4 0,4 4,0 4,0 0))
1834 203 POLYGON((0 0,10 0,10 10,0 10,0 0))
1835 204 POLYGON((5 5,10 5,10 10,5 10,5 5))
1836 205 POLYGON((0 0,24 0,24 24,0 24,0 0))
1837 206 POLYGON((0 0,100 0,100 100,0 100,0 0))
1838 207 POLYGON((0 0,5 0,5 5,0 5,0 0))
1839 208 POLYGON((-10 -5,0 -5,0 10,-10 10,-10 -5))
1840 209 POLYGON((0 0,8 0,8 8,0 8,0 0))
1841 210 POLYGON((0 0,5 0,5 5,0 5,0 0))
1842 211 POLYGON((-50 -50,10 -50,10 0,-50 0,-50 -50))
1843 212 POLYGON((0 -1000,1000 -1000,1000 1000,0 1000,0 -1000))
1844 213 LINESTRING(1000 -1000,1000 1000)
1845 214 POLYGON((1 1,9 1,9 9,1 9,1 1))
1846 215 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1847 301 POLYGON((0 0,5 0,5 5,0 5,0 0))
1848 302 POLYGON((0 0,5 0,5 5,0 5,0 0))
1849 303 POLYGON((0 0,10 0,10 10,0 10,0 0))
1850 304 POLYGON((0 0,50 0,50 50,0 50,0 0))
1851 305 POLYGON((0 0,10 0,10 10,0 10,0 0))
1852 306 POLYGON((0 0,10 0,10 10,0 10,0 0))
1853 307 POLYGON((0 0,5 0,5 5,0 5,0 0))
1854 308 POLYGON((0 0,15 0,15 15,0 15,0 0))
1855 309 POLYGON((0 0,10 0,10 10,0 10,0 0))
1856 310 POLYGON((0 0,5 0,5 5,0 5,0 0))
1857 311 POLYGON((10 10,15 10,15 15,10 15,10 10))
1858 312 POLYGON((10 10,20 10,20 20,10 20,10 10))
1859 313 POLYGON((0 0,10 0,10 10,0 10,0 0))
1860 314 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1861 315 POLYGON((0 0,10 0,10 10,0 10,0 0))
1862 401 POINT(0 0)
1863 402 POLYGON((0 0,4 0,4 4,0 4,0 0))
1864 403 POLYGON((0 0,10 0,10 10,0 10,0 0))
1865 404 POLYGON((0 0,100 0,100 100,0 100,0 0))
1866 405 POLYGON((0 0,1000 0,1000 1000,0 1000,0 0))
1867 406 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1868 407 POINT(0 0)
1869 408 POLYGON((0 0,10 0,10 10,0 10,0 0))
1870 409 POLYGON((0 0,6 0,6 6,0 6,0 0))
1871 410 POINT(0 0)
1872 411 POLYGON((0 0,1000 0,1000 1000,0 1000,0 0))
1873 412 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1874 413 POINT(0 0)
1875 414 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1876 415 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1877 501 POLYGON((0 0,2 0,2 2,0 2,0 0))
1878 502 POLYGON((0 0,4 0,4 4,0 4,0 0))
1879 503 POLYGON((0 0,10 0,10 10,0 10,0 0))
1880 504 POLYGON((-100 -100,100 -100,100 100,-100 100,-100 -100))
1881 505 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1882 506 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
1883 507 POLYGON((0 0,2 0,2 2,0 2,0 0))
1884 508 POLYGON((0 0,24 0,24 24,0 24,0 0))
1885 509 POLYGON((0 0,10 0,10 10,0 10,0 0))
1886 510 POLYGON((0 0,4 0,4 4,0 4,0 0))
1887 511 POLYGON((0 0,2 0,2 2,0 2,0 0))
1888 512 POLYGON((0 0,50 0,50 50,0 50,0 0))
1889 513 POLYGON((0 0,10 0,10 10,0 10,0 0))
1890 514 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1891 515 POLYGON((-100 -100,100 -100,100 100,-100 100,-100 -100))
1892 601 POLYGON((0 0,5 0,5 5,0 5,0 0))
1893 602 POLYGON((0 0,10 0,10 10,0 10,0 0))
1894 603 POLYGON((0 0,10 0,10 10,0 10,0 0))
1895 604 POLYGON((0 0,5 0,5 5,0 5,0 0))
1896 605 POLYGON((-2 -2,10 -2,10 10,-2 10,-2 -2))
1897 606 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1898 607 POLYGON((0 0,5 0,5 5,0 5,0 0))
1899 608 POLYGON((0 0,10 0,10 10,0 10,0 0))
1900 609 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1901 610 POLYGON((-5 -5,0 -5,0 0,-5 0,-5 -5))
1902 611 POLYGON((10 10,20 10,20 20,10 20,10 10))
1903 612 POLYGON((-5 -5,10 -5,10 10,-5 10,-5 -5))
1904 613 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
1905 614 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1906 615 POLYGON((0 -5,10 -5,10 5,0 5,0 -5))
1907 701 POINT(0 0)
1908 702 POLYGON((0 0,10 0,10 10,0 10,0 0))
1909 703 POLYGON((0 0,10 0,10 10,0 10,0 0))
1910 704 POLYGON((0 0,10 0,10 10,0 10,0 0))
1911 705 POLYGON((0 0,10 0,10 10,0 10,0 0))
1912 706 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1913 707 POINT(0 0)
1914 708 POLYGON((0 0,10 0,10 10,0 10,0 0))
1915 709 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
1916 710 POLYGON((0 0,100 0,100 100,0 100,0 0))
1917 711 POLYGON((0 0,18 0,18 18,0 18,0 0))
1918 712 POLYGON((-10 -10,20 -10,20 20,-10 20,-10 -10))
1919 713 POLYGON((0 0,10 0,10 10,0 10,0 0))
1920 714 POLYGON((0 0,10 0,10 10,0 10,0 0))
1921 715 POLYGON((0 0,10 0,10 10,0 10,0 0))
1922 fid ST_ASTEXT(ST_CENTROID(g))
1923 101 POINT(0 0)
1924 102 POINT(1 0)
1925 103 POINT(0 1)
1926 104 POINT(1 1)
1927 105 POINT(-1 1)
1928 106 POINT(0 0)
1929 107 POINT(10 0)
1930 108 POINT(0 10)
1931 109 POINT(-10 0)
1932 110 POINT(0 -10)
1933 111 POINT(1 1)
1934 112 POINT(1000 1000)
1935 113 POINT(1000 -1000)
1936 114 POINT(-1000 1000)
1937 115 POINT(-1000 -1000)
1938 201 POINT(2.5 2.5)
1939 202 POINT(2 2)
1940 203 POINT(5 5)
1941 204 POINT(7.5 7.5)
1942 205 POINT(12 12)
1943 206 POINT(50 50)
1944 207 POINT(2.5 2.5)
1945 208 POINT(-5.9549150281 0.9549150281)
1946 209 POINT(4 4)
1947 210 POINT(2.5 2.5)
1948 211 POINT(-22.4754878398 -27.5245121602)
1949 212 POINT(792.8932188135 207.1067811865)
1950 213 POINT(1000 0)
1951 214 POINT(5 5)
1952 215 POINT(0 0)
1953 301 POINT(1.6666666667 3.3333333333)
1954 302 POINT(2.5 2.5)
1955 303 POINT(5 5)
1956 304 POINT(25 25)
1957 305 POINT(5 5)
1958 306 POINT(5 5)
1959 307 POINT(1.6666666667 3.3333333333)
1960 308 POINT(7.5 7.5)
1961 309 POINT(5 5)
1962 310 POINT(1.6666666667 3.3333333333)
1963 311 POINT(12.5 12.5)
1964 312 POINT(15 15)
1965 313 POINT(5 6.1111111111)
1966 314 POINT(0 3.3333333333)
1967 315 POINT(5 5)
1968 401 POINT(0 0)
1969 402 POINT(2 2)
1970 403 POINT(5 5)
1971 404 POINT(50 50)
1972 405 POINT(500 500)
1973 406 POINT(0 0)
1974 407 POINT(0 0)
1975 408 POINT(5 5)
1976 409 POINT(3 3)
1977 410 POINT(0 0)
1978 411 POINT(500 500)
1979 412 POINT(0 0)
1980 413 POINT(0 0)
1981 414 POINT(0 0)
1982 415 POINT(200 200)
1983 501 POINT(1 1)
1984 502 POINT(2 2)
1985 503 POINT(5 5)
1986 504 POINT(16.6666666667 16.6666666667)
1987 505 POINT(0 0)
1988 506 POINT(0 0)
1989 507 POINT(1 1)
1990 508 POINT(12 12)
1991 509 POINT(5 5)
1992 510 POINT(2 2)
1993 511 POINT(1 1)
1994 512 POINT(23.4210526316 23.4210526316)
1995 513 POINT(5 5)
1996 514 POINT(0 0)
1997 515 POINT(0 0)
1998 601 POINT(1.6666666667 3.3333333333)
1999 602 POINT(4.1666666667 5.8333333333)
2000 603 POINT(5 5)
2001 604 POINT(1.6666666667 3.3333333333)
2002 605 POINT(4.8843537415 4.8707482993)
2003 606 POINT(0 0)
2004 607 POINT(2.5 2.5)
2005 608 POINT(5 5)
2006 609 POINT(0 0)
2007 610 POINT(-2.5 -2.5)
2008 611 POINT(15 15)
2009 612 POINT(3.4504132231 3.4504132231)
2010 613 POINT(0 0)
2011 614 POINT(0 0)
2012 615 POINT(5 0)
2013 701 POINT(0 0)
2014 702 POINT(5 5)
2015 703 POINT(5 5)
2016 704 POINT(5 5)
2017 705 POINT(5 5)
2018 706 POINT(0 0)
2019 707 POINT(0 0)
2020 708 POINT(5 5)
2021 709 POINT(1.00456621 2.1461187215)
2022 710 POINT(50 50)
2023 711 POINT(5 5)
2024 712 POINT(1.00456621 2.1461187215)
2025 713 POINT(5 5)
2026 714 POINT(5 5)
2027 715 POINT(5 5)
2028 fid ST_ASTEXT(ST_CONVEXHULL(g))
2029 101 POINT(0 0)
2030 102 POINT(1 0)
2031 103 POINT(0 1)
2032 104 POINT(1 1)
2033 105 POINT(-1 1)
2034 106 POINT(0 0)
2035 107 POINT(10 0)
2036 108 POINT(0 10)
2037 109 POINT(-10 0)
2038 110 POINT(0 -10)
2039 111 POINT(1 1)
2040 112 POINT(1000 1000)
2041 113 POINT(1000 -1000)
2042 114 POINT(-1000 1000)
2043 115 POINT(-1000 -1000)
2044 201 LINESTRING(0 0,5 5)
2045 202 LINESTRING(0 0,4 4)
2046 203 LINESTRING(0 0,10 10)
2047 204 LINESTRING(5 5,10 10)
2048 205 LINESTRING(0 0,24 24)
2049 206 LINESTRING(0 0,100 100)
2050 207 LINESTRING(0 0,5 5)
2051 208 POLYGON((-10 10,-5 -5,0 0,-10 10))
2052 209 LINESTRING(0 0,8 8)
2053 210 LINESTRING(0 0,5 5)
2054 211 POLYGON((-50 -50,10 -10,0 0,-50 -50))
2055 212 POLYGON((0 0,1000 -1000,1000 1000,0 0))
2056 213 LINESTRING(1000 -1000,1000 1000)
2057 214 LINESTRING(1 1,9 9)
2058 215 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2059 301 POLYGON((0 0,5 5,0 5,0 0))
2060 302 POLYGON((0 0,5 0,5 5,0 5,0 0))
2061 303 POLYGON((0 0,10 0,10 10,0 10,0 0))
2062 304 POLYGON((0 0,50 0,50 50,0 50,0 0))
2063 305 POLYGON((0 0,10 0,10 10,0 10,0 0))
2064 306 POLYGON((0 0,10 0,10 10,0 10,0 0))
2065 307 POLYGON((0 0,5 5,0 5,0 0))
2066 308 POLYGON((0 0,15 0,15 15,0 15,0 0))
2067 309 POLYGON((0 0,10 0,10 10,0 10,0 0))
2068 310 POLYGON((0 0,5 5,0 5,0 0))
2069 311 POLYGON((10 10,15 10,15 15,10 15,10 10))
2070 312 POLYGON((10 10,20 10,20 20,10 20,10 10))
2071 313 POLYGON((0 0,10 0,10 10,0 10,0 0))
2072 314 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2073 315 POLYGON((0 0,10 0,10 10,0 10,0 0))
2074 401 POINT(0 0)
2075 402 LINESTRING(0 0,4 4)
2076 403 LINESTRING(0 0,10 10)
2077 404 LINESTRING(0 0,100 100)
2078 405 LINESTRING(0 0,1000 1000)
2079 406 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2080 407 POINT(0 0)
2081 408 LINESTRING(0 0,10 10)
2082 409 LINESTRING(0 0,6 6)
2083 410 POINT(0 0)
2084 411 LINESTRING(0 0,1000 1000)
2085 412 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2086 413 POINT(0 0)
2087 414 LINESTRING(-1000 -1000,1000 1000)
2088 415 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2089 501 LINESTRING(0 0,2 2)
2090 502 LINESTRING(0 0,4 4)
2091 503 LINESTRING(0 0,10 10)
2092 504 LINESTRING(-100 -100,100 100)
2093 505 LINESTRING(-1000 -1000,1000 1000)
2094 506 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2095 507 LINESTRING(0 0,2 2)
2096 508 LINESTRING(0 0,24 24)
2097 509 LINESTRING(0 0,10 10)
2098 510 LINESTRING(0 0,4 4)
2099 511 LINESTRING(0 0,2 2)
2100 512 LINESTRING(0 0,50 50)
2101 513 POLYGON((0 0,10 0,10 10,0 10,0 0))
2102 514 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2103 515 POLYGON((-100 0,0 -100,100 0,0 100,-100 0))
2104 601 POLYGON((0 0,5 5,0 5,0 0))
2105 602 POLYGON((0 0,10 10,5 10,0 5,0 0))
2106 603 POLYGON((0 0,10 0,10 10,0 10,0 0))
2107 604 POLYGON((0 0,5 5,0 5,0 0))
2108 605 POLYGON((-2 -2,0 -2,10 0,10 10,0 10,-2 -2))
2109 606 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
2110 607 POLYGON((0 0,5 0,5 5,0 5,0 0))
2111 608 POLYGON((0 0,10 0,10 10,0 10,0 0))
2112 609 POLYGON((-5 -5,0 -5,5 0,5 5,0 5,-5 0,-5 -5))
2113 610 POLYGON((-5 -5,0 -5,0 0,-5 0,-5 -5))
2114 611 POLYGON((10 10,20 10,20 20,10 20,10 10))
2115 612 POLYGON((-5 -5,0 -5,10 0,10 10,0 10,-5 0,-5 -5))
2116 613 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
2117 614 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2118 615 POLYGON((0 0,5 -5,10 0,5 5,0 0))
2119 701 POINT(0 0)
2120 702 LINESTRING(0 0,10 10)
2121 703 POLYGON((0 0,10 0,10 10,0 10,0 0))
2122 704 LINESTRING(0 0,10 10)
2123 705 POLYGON((0 0,10 0,10 10,0 10,0 0))
2124 706 POLYGON((-10 -10,0 -10,10 0,10 10,0 10,-10 0,-10 -10))
2125 707 POINT(0 0)
2126 708 POLYGON((0 0,10 0,10 10,0 10,0 0))
2127 709 POLYGON((-10 -10,10 0,10 10,0 10,-10 0,-10 -10))
2128 710 LINESTRING(0 0,100 100)
2129 711 POLYGON((0 0,10 0,18 18,0 10,0 0))
2130 712 POLYGON((-10 -10,10 0,20 20,0 10,-10 0,-10 -10))
2131 713 POLYGON((0 0,10 0,10 10,0 10,0 0))
2132 714 POLYGON((0 0,10 0,10 10,0 10,0 0))
2133 715 POLYGON((0 0,10 0,10 10,0 10,0 0))
2134 fid ST_ISEMPTY(g)
2135 101 0
2136 102 0
2137 103 0
2138 104 0
2139 105 0
2140 106 0
2141 107 0
2142 108 0
2143 109 0
2144 110 0
2145 111 0
2146 112 0
2147 113 0
2148 114 0
2149 115 0
2150 201 0
2151 202 0
2152 203 0
2153 204 0
2154 205 0
2155 206 0
2156 207 0
2157 208 0
2158 209 0
2159 210 0
2160 211 0
2161 212 0
2162 213 0
2163 214 0
2164 215 0
2165 301 0
2166 302 0
2167 303 0
2168 304 0
2169 305 0
2170 306 0
2171 307 0
2172 308 0
2173 309 0
2174 310 0
2175 311 0
2176 312 0
2177 313 0
2178 314 0
2179 315 0
2180 401 0
2181 402 0
2182 403 0
2183 404 0
2184 405 0
2185 406 0
2186 407 0
2187 408 0
2188 409 0
2189 410 0
2190 411 0
2191 412 0
2192 413 0
2193 414 0
2194 415 0
2195 501 0
2196 502 0
2197 503 0
2198 504 0
2199 505 0
2200 506 0
2201 507 0
2202 508 0
2203 509 0
2204 510 0
2205 511 0
2206 512 0
2207 513 0
2208 514 0
2209 515 0
2210 601 0
2211 602 0
2212 603 0
2213 604 0
2214 605 0
2215 606 0
2216 607 0
2217 608 0
2218 609 0
2219 610 0
2220 611 0
2221 612 0
2222 613 0
2223 614 0
2224 615 0
2225 701 0
2226 702 0
2227 703 0
2228 704 0
2229 705 0
2230 706 0
2231 707 0
2232 708 0
2233 709 0
2234 710 0
2235 711 0
2236 712 0
2237 713 0
2238 714 0
2239 715 0
2240 # Dropping the created procedure
2241 DROP PROCEDURE geom_attri;
2242 # Creating an empty table as gis_geometry_1
2243 CREATE TABLE gis_geometry_1 AS SELECT * FROM gis_geometry;
2244 TRUNCATE TABLE gis_geometry_1;
2245 # Create a tigger to populate the data FROM gis_geometry to gis_geometry_1
2246 CREATE TRIGGER geom_trigger AFTER UPDATE ON gis_geometry
2247 FOR EACH ROW
2248 BEGIN
2249 INSERT INTO gis_geometry_1 SELECT * FROM gis_geometry;
2250 END|
2251 # Calling the trigger
2252 UPDATE gis_geometry SET fid = 999 where fid = 111;
2253 # Checking the GEOMETRY class properties on the spatial data in the gis_geometry_1 table
2254 SELECT fid, ST_GEOMETRYTYPE(g) FROM gis_geometry_1;
2255 fid ST_GEOMETRYTYPE(g)
2256 101 POINT
2257 102 POINT
2258 103 POINT
2259 104 POINT
2260 105 POINT
2261 106 POINT
2262 107 POINT
2263 108 POINT
2264 109 POINT
2265 110 POINT
2266 112 POINT
2267 113 POINT
2268 114 POINT
2269 115 POINT
2270 201 LINESTRING
2271 202 LINESTRING
2272 203 LINESTRING
2273 204 LINESTRING
2274 205 LINESTRING
2275 206 LINESTRING
2276 207 LINESTRING
2277 208 LINESTRING
2278 209 LINESTRING
2279 210 LINESTRING
2280 211 LINESTRING
2281 212 LINESTRING
2282 213 LINESTRING
2283 214 LINESTRING
2284 215 LINESTRING
2285 301 POLYGON
2286 302 POLYGON
2287 303 POLYGON
2288 304 POLYGON
2289 305 POLYGON
2290 306 POLYGON
2291 307 POLYGON
2292 308 POLYGON
2293 309 POLYGON
2294 310 POLYGON
2295 311 POLYGON
2296 312 POLYGON
2297 313 POLYGON
2298 314 POLYGON
2299 315 POLYGON
2300 401 MULTIPOINT
2301 402 MULTIPOINT
2302 403 MULTIPOINT
2303 404 MULTIPOINT
2304 405 MULTIPOINT
2305 406 MULTIPOINT
2306 407 MULTIPOINT
2307 408 MULTIPOINT
2308 409 MULTIPOINT
2309 410 MULTIPOINT
2310 411 MULTIPOINT
2311 412 MULTIPOINT
2312 413 MULTIPOINT
2313 414 MULTIPOINT
2314 415 MULTIPOINT
2315 501 MULTILINESTRING
2316 502 MULTILINESTRING
2317 503 MULTILINESTRING
2318 504 MULTILINESTRING
2319 505 MULTILINESTRING
2320 506 MULTILINESTRING
2321 507 MULTILINESTRING
2322 508 MULTILINESTRING
2323 509 MULTILINESTRING
2324 510 MULTILINESTRING
2325 511 MULTILINESTRING
2326 512 MULTILINESTRING
2327 513 MULTILINESTRING
2328 514 MULTILINESTRING
2329 515 MULTILINESTRING
2330 601 MULTIPOLYGON
2331 602 MULTIPOLYGON
2332 603 MULTIPOLYGON
2333 604 MULTIPOLYGON
2334 605 MULTIPOLYGON
2335 606 MULTIPOLYGON
2336 607 MULTIPOLYGON
2337 608 MULTIPOLYGON
2338 609 MULTIPOLYGON
2339 610 MULTIPOLYGON
2340 611 MULTIPOLYGON
2341 612 MULTIPOLYGON
2342 613 MULTIPOLYGON
2343 614 MULTIPOLYGON
2344 615 MULTIPOLYGON
2345 701 GEOMCOLLECTION
2346 702 GEOMCOLLECTION
2347 703 GEOMCOLLECTION
2348 704 GEOMCOLLECTION
2349 705 GEOMCOLLECTION
2350 706 GEOMCOLLECTION
2351 707 GEOMCOLLECTION
2352 708 GEOMCOLLECTION
2353 709 GEOMCOLLECTION
2354 710 GEOMCOLLECTION
2355 711 GEOMCOLLECTION
2356 712 GEOMCOLLECTION
2357 713 GEOMCOLLECTION
2358 714 GEOMCOLLECTION
2359 715 GEOMCOLLECTION
2360 999 POINT
2361 SELECT fid, ST_SRID(g) FROM gis_geometry_1;
2362 fid ST_SRID(g)
2363 101 0
2364 102 0
2365 103 0
2366 104 0
2367 105 0
2368 106 0
2369 107 0
2370 108 0
2371 109 0
2372 110 0
2373 112 0
2374 113 0
2375 114 0
2376 115 0
2377 201 0
2378 202 0
2379 203 0
2380 204 0
2381 205 0
2382 206 0
2383 207 0
2384 208 0
2385 209 0
2386 210 0
2387 211 0
2388 212 0
2389 213 0
2390 214 0
2391 215 0
2392 301 0
2393 302 0
2394 303 0
2395 304 0
2396 305 0
2397 306 0
2398 307 0
2399 308 0
2400 309 0
2401 310 0
2402 311 0
2403 312 0
2404 313 0
2405 314 0
2406 315 0
2407 401 0
2408 402 0
2409 403 0
2410 404 0
2411 405 0
2412 406 0
2413 407 0
2414 408 0
2415 409 0
2416 410 0
2417 411 0
2418 412 0
2419 413 0
2420 414 0
2421 415 0
2422 501 0
2423 502 0
2424 503 0
2425 504 0
2426 505 0
2427 506 0
2428 507 0
2429 508 0
2430 509 0
2431 510 0
2432 511 0
2433 512 0
2434 513 0
2435 514 0
2436 515 0
2437 601 0
2438 602 0
2439 603 0
2440 604 0
2441 605 0
2442 606 0
2443 607 0
2444 608 0
2445 609 0
2446 610 0
2447 611 0
2448 612 0
2449 613 0
2450 614 0
2451 615 0
2452 701 0
2453 702 0
2454 703 0
2455 704 0
2456 705 0
2457 706 0
2458 707 0
2459 708 0
2460 709 0
2461 710 0
2462 711 0
2463 712 0
2464 713 0
2465 714 0
2466 715 0
2467 999 0
2468 SELECT fid, ST_DIMENSION(g) FROM gis_geometry_1;
2469 fid ST_DIMENSION(g)
2470 101 0
2471 102 0
2472 103 0
2473 104 0
2474 105 0
2475 106 0
2476 107 0
2477 108 0
2478 109 0
2479 110 0
2480 112 0
2481 113 0
2482 114 0
2483 115 0
2484 201 1
2485 202 1
2486 203 1
2487 204 1
2488 205 1
2489 206 1
2490 207 1
2491 208 1
2492 209 1
2493 210 1
2494 211 1
2495 212 1
2496 213 1
2497 214 1
2498 215 1
2499 301 2
2500 302 2
2501 303 2
2502 304 2
2503 305 2
2504 306 2
2505 307 2
2506 308 2
2507 309 2
2508 310 2
2509 311 2
2510 312 2
2511 313 2
2512 314 2
2513 315 2
2514 401 0
2515 402 0
2516 403 0
2517 404 0
2518 405 0
2519 406 0
2520 407 0
2521 408 0
2522 409 0
2523 410 0
2524 411 0
2525 412 0
2526 413 0
2527 414 0
2528 415 0
2529 501 1
2530 502 1
2531 503 1
2532 504 1
2533 505 1
2534 506 1
2535 507 1
2536 508 1
2537 509 1
2538 510 1
2539 511 1
2540 512 1
2541 513 1
2542 514 1
2543 515 1
2544 601 2
2545 602 2
2546 603 2
2547 604 2
2548 605 2
2549 606 2
2550 607 2
2551 608 2
2552 609 2
2553 610 2
2554 611 2
2555 612 2
2556 613 2
2557 614 2
2558 615 2
2559 701 0
2560 702 1
2561 703 2
2562 704 1
2563 705 2
2564 706 2
2565 707 0
2566 708 2
2567 709 2
2568 710 1
2569 711 2
2570 712 2
2571 713 2
2572 714 2
2573 715 NULL
2574 999 0
2575 SELECT fid, ST_ISSIMPLE(g) FROM gis_geometry_1;
2576 fid ST_ISSIMPLE(g)
2577 101 1
2578 102 1
2579 103 1
2580 104 1
2581 105 1
2582 106 1
2583 107 1
2584 108 1
2585 109 1
2586 110 1
2587 112 1
2588 113 1
2589 114 1
2590 115 1
2591 201 1
2592 202 1
2593 203 1
2594 204 1
2595 205 1
2596 206 1
2597 207 1
2598 208 1
2599 209 1
2600 210 1
2601 211 1
2602 212 1
2603 213 1
2604 214 1
2605 215 1
2606 301 1
2607 302 1
2608 303 1
2609 304 1
2610 305 1
2611 306 1
2612 307 1
2613 308 1
2614 309 1
2615 310 1
2616 311 1
2617 312 1
2618 313 1
2619 314 1
2620 315 1
2621 401 1
2622 402 1
2623 403 1
2624 404 1
2625 405 1
2626 406 1
2627 407 1
2628 408 1
2629 409 1
2630 410 1
2631 411 1
2632 412 1
2633 413 1
2634 414 1
2635 415 0
2636 501 1
2637 502 1
2638 503 1
2639 504 0
2640 505 1
2641 506 0
2642 507 1
2643 508 1
2644 509 1
2645 510 1
2646 511 1
2647 512 1
2648 513 0
2649 514 0
2650 515 1
2651 601 1
2652 602 1
2653 603 1
2654 604 1
2655 605 1
2656 606 1
2657 607 1
2658 608 1
2659 609 1
2660 610 1
2661 611 1
2662 612 1
2663 613 1
2664 614 1
2665 615 1
2666 701 1
2667 702 1
2668 703 0
2669 704 1
2670 705 0
2671 706 0
2672 707 1
2673 708 0
2674 709 0
2675 710 1
2676 711 1
2677 712 0
2678 713 0
2679 714 0
2680 715 0
2681 999 1
2682 SELECT fid, ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometry_1;
2683 fid ST_ASTEXT(ST_ENVELOPE(g))
2684 101 POINT(0 0)
2685 102 POINT(1 0)
2686 103 POINT(0 1)
2687 104 POINT(1 1)
2688 105 POINT(-1 1)
2689 106 POINT(0 0)
2690 107 POINT(10 0)
2691 108 POINT(0 10)
2692 109 POINT(-10 0)
2693 110 POINT(0 -10)
2694 112 POINT(1000 1000)
2695 113 POINT(1000 -1000)
2696 114 POINT(-1000 1000)
2697 115 POINT(-1000 -1000)
2698 201 POLYGON((0 0,5 0,5 5,0 5,0 0))
2699 202 POLYGON((0 0,4 0,4 4,0 4,0 0))
2700 203 POLYGON((0 0,10 0,10 10,0 10,0 0))
2701 204 POLYGON((5 5,10 5,10 10,5 10,5 5))
2702 205 POLYGON((0 0,24 0,24 24,0 24,0 0))
2703 206 POLYGON((0 0,100 0,100 100,0 100,0 0))
2704 207 POLYGON((0 0,5 0,5 5,0 5,0 0))
2705 208 POLYGON((-10 -5,0 -5,0 10,-10 10,-10 -5))
2706 209 POLYGON((0 0,8 0,8 8,0 8,0 0))
2707 210 POLYGON((0 0,5 0,5 5,0 5,0 0))
2708 211 POLYGON((-50 -50,10 -50,10 0,-50 0,-50 -50))
2709 212 POLYGON((0 -1000,1000 -1000,1000 1000,0 1000,0 -1000))
2710 213 LINESTRING(1000 -1000,1000 1000)
2711 214 POLYGON((1 1,9 1,9 9,1 9,1 1))
2712 215 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2713 301 POLYGON((0 0,5 0,5 5,0 5,0 0))
2714 302 POLYGON((0 0,5 0,5 5,0 5,0 0))
2715 303 POLYGON((0 0,10 0,10 10,0 10,0 0))
2716 304 POLYGON((0 0,50 0,50 50,0 50,0 0))
2717 305 POLYGON((0 0,10 0,10 10,0 10,0 0))
2718 306 POLYGON((0 0,10 0,10 10,0 10,0 0))
2719 307 POLYGON((0 0,5 0,5 5,0 5,0 0))
2720 308 POLYGON((0 0,15 0,15 15,0 15,0 0))
2721 309 POLYGON((0 0,10 0,10 10,0 10,0 0))
2722 310 POLYGON((0 0,5 0,5 5,0 5,0 0))
2723 311 POLYGON((10 10,15 10,15 15,10 15,10 10))
2724 312 POLYGON((10 10,20 10,20 20,10 20,10 10))
2725 313 POLYGON((0 0,10 0,10 10,0 10,0 0))
2726 314 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2727 315 POLYGON((0 0,10 0,10 10,0 10,0 0))
2728 401 POINT(0 0)
2729 402 POLYGON((0 0,4 0,4 4,0 4,0 0))
2730 403 POLYGON((0 0,10 0,10 10,0 10,0 0))
2731 404 POLYGON((0 0,100 0,100 100,0 100,0 0))
2732 405 POLYGON((0 0,1000 0,1000 1000,0 1000,0 0))
2733 406 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2734 407 POINT(0 0)
2735 408 POLYGON((0 0,10 0,10 10,0 10,0 0))
2736 409 POLYGON((0 0,6 0,6 6,0 6,0 0))
2737 410 POINT(0 0)
2738 411 POLYGON((0 0,1000 0,1000 1000,0 1000,0 0))
2739 412 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2740 413 POINT(0 0)
2741 414 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2742 415 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2743 501 POLYGON((0 0,2 0,2 2,0 2,0 0))
2744 502 POLYGON((0 0,4 0,4 4,0 4,0 0))
2745 503 POLYGON((0 0,10 0,10 10,0 10,0 0))
2746 504 POLYGON((-100 -100,100 -100,100 100,-100 100,-100 -100))
2747 505 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2748 506 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2749 507 POLYGON((0 0,2 0,2 2,0 2,0 0))
2750 508 POLYGON((0 0,24 0,24 24,0 24,0 0))
2751 509 POLYGON((0 0,10 0,10 10,0 10,0 0))
2752 510 POLYGON((0 0,4 0,4 4,0 4,0 0))
2753 511 POLYGON((0 0,2 0,2 2,0 2,0 0))
2754 512 POLYGON((0 0,50 0,50 50,0 50,0 0))
2755 513 POLYGON((0 0,10 0,10 10,0 10,0 0))
2756 514 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2757 515 POLYGON((-100 -100,100 -100,100 100,-100 100,-100 -100))
2758 601 POLYGON((0 0,5 0,5 5,0 5,0 0))
2759 602 POLYGON((0 0,10 0,10 10,0 10,0 0))
2760 603 POLYGON((0 0,10 0,10 10,0 10,0 0))
2761 604 POLYGON((0 0,5 0,5 5,0 5,0 0))
2762 605 POLYGON((-2 -2,10 -2,10 10,-2 10,-2 -2))
2763 606 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
2764 607 POLYGON((0 0,5 0,5 5,0 5,0 0))
2765 608 POLYGON((0 0,10 0,10 10,0 10,0 0))
2766 609 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
2767 610 POLYGON((-5 -5,0 -5,0 0,-5 0,-5 -5))
2768 611 POLYGON((10 10,20 10,20 20,10 20,10 10))
2769 612 POLYGON((-5 -5,10 -5,10 10,-5 10,-5 -5))
2770 613 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
2771 614 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2772 615 POLYGON((0 -5,10 -5,10 5,0 5,0 -5))
2773 701 POINT(0 0)
2774 702 POLYGON((0 0,10 0,10 10,0 10,0 0))
2775 703 POLYGON((0 0,10 0,10 10,0 10,0 0))
2776 704 POLYGON((0 0,10 0,10 10,0 10,0 0))
2777 705 POLYGON((0 0,10 0,10 10,0 10,0 0))
2778 706 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2779 707 POINT(0 0)
2780 708 POLYGON((0 0,10 0,10 10,0 10,0 0))
2781 709 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2782 710 POLYGON((0 0,100 0,100 100,0 100,0 0))
2783 711 POLYGON((0 0,18 0,18 18,0 18,0 0))
2784 712 POLYGON((-10 -10,20 -10,20 20,-10 20,-10 -10))
2785 713 POLYGON((0 0,10 0,10 10,0 10,0 0))
2786 714 POLYGON((0 0,10 0,10 10,0 10,0 0))
2787 715 POLYGON((0 0,10 0,10 10,0 10,0 0))
2788 999 POINT(1 1)
2789 SELECT fid, ST_ASTEXT(ST_CENTROID(g)) FROM gis_geometry_1;
2790 fid ST_ASTEXT(ST_CENTROID(g))
2791 101 POINT(0 0)
2792 102 POINT(1 0)
2793 103 POINT(0 1)
2794 104 POINT(1 1)
2795 105 POINT(-1 1)
2796 106 POINT(0 0)
2797 107 POINT(10 0)
2798 108 POINT(0 10)
2799 109 POINT(-10 0)
2800 110 POINT(0 -10)
2801 112 POINT(1000 1000)
2802 113 POINT(1000 -1000)
2803 114 POINT(-1000 1000)
2804 115 POINT(-1000 -1000)
2805 201 POINT(2.5 2.5)
2806 202 POINT(2 2)
2807 203 POINT(5 5)
2808 204 POINT(7.5 7.5)
2809 205 POINT(12 12)
2810 206 POINT(50 50)
2811 207 POINT(2.5 2.5)
2812 208 POINT(-5.9549150281 0.9549150281)
2813 209 POINT(4 4)
2814 210 POINT(2.5 2.5)
2815 211 POINT(-22.4754878398 -27.5245121602)
2816 212 POINT(792.8932188135 207.1067811865)
2817 213 POINT(1000 0)
2818 214 POINT(5 5)
2819 215 POINT(0 0)
2820 301 POINT(1.6666666667 3.3333333333)
2821 302 POINT(2.5 2.5)
2822 303 POINT(5 5)
2823 304 POINT(25 25)
2824 305 POINT(5 5)
2825 306 POINT(5 5)
2826 307 POINT(1.6666666667 3.3333333333)
2827 308 POINT(7.5 7.5)
2828 309 POINT(5 5)
2829 310 POINT(1.6666666667 3.3333333333)
2830 311 POINT(12.5 12.5)
2831 312 POINT(15 15)
2832 313 POINT(5 6.1111111111)
2833 314 POINT(0 3.3333333333)
2834 315 POINT(5 5)
2835 401 POINT(0 0)
2836 402 POINT(2 2)
2837 403 POINT(5 5)
2838 404 POINT(50 50)
2839 405 POINT(500 500)
2840 406 POINT(0 0)
2841 407 POINT(0 0)
2842 408 POINT(5 5)
2843 409 POINT(3 3)
2844 410 POINT(0 0)
2845 411 POINT(500 500)
2846 412 POINT(0 0)
2847 413 POINT(0 0)
2848 414 POINT(0 0)
2849 415 POINT(200 200)
2850 501 POINT(1 1)
2851 502 POINT(2 2)
2852 503 POINT(5 5)
2853 504 POINT(16.6666666667 16.6666666667)
2854 505 POINT(0 0)
2855 506 POINT(0 0)
2856 507 POINT(1 1)
2857 508 POINT(12 12)
2858 509 POINT(5 5)
2859 510 POINT(2 2)
2860 511 POINT(1 1)
2861 512 POINT(23.4210526316 23.4210526316)
2862 513 POINT(5 5)
2863 514 POINT(0 0)
2864 515 POINT(0 0)
2865 601 POINT(1.6666666667 3.3333333333)
2866 602 POINT(4.1666666667 5.8333333333)
2867 603 POINT(5 5)
2868 604 POINT(1.6666666667 3.3333333333)
2869 605 POINT(4.8843537415 4.8707482993)
2870 606 POINT(0 0)
2871 607 POINT(2.5 2.5)
2872 608 POINT(5 5)
2873 609 POINT(0 0)
2874 610 POINT(-2.5 -2.5)
2875 611 POINT(15 15)
2876 612 POINT(3.4504132231 3.4504132231)
2877 613 POINT(0 0)
2878 614 POINT(0 0)
2879 615 POINT(5 0)
2880 701 POINT(0 0)
2881 702 POINT(5 5)
2882 703 POINT(5 5)
2883 704 POINT(5 5)
2884 705 POINT(5 5)
2885 706 POINT(0 0)
2886 707 POINT(0 0)
2887 708 POINT(5 5)
2888 709 POINT(1.00456621 2.1461187215)
2889 710 POINT(50 50)
2890 711 POINT(5 5)
2891 712 POINT(1.00456621 2.1461187215)
2892 713 POINT(5 5)
2893 714 POINT(5 5)
2894 715 POINT(5 5)
2895 999 POINT(1 1)
2896 SELECT fid, ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometry_1;
2897 fid ST_ASTEXT(ST_CONVEXHULL(g))
2898 101 POINT(0 0)
2899 102 POINT(1 0)
2900 103 POINT(0 1)
2901 104 POINT(1 1)
2902 105 POINT(-1 1)
2903 106 POINT(0 0)
2904 107 POINT(10 0)
2905 108 POINT(0 10)
2906 109 POINT(-10 0)
2907 110 POINT(0 -10)
2908 112 POINT(1000 1000)
2909 113 POINT(1000 -1000)
2910 114 POINT(-1000 1000)
2911 115 POINT(-1000 -1000)
2912 201 LINESTRING(0 0,5 5)
2913 202 LINESTRING(0 0,4 4)
2914 203 LINESTRING(0 0,10 10)
2915 204 LINESTRING(5 5,10 10)
2916 205 LINESTRING(0 0,24 24)
2917 206 LINESTRING(0 0,100 100)
2918 207 LINESTRING(0 0,5 5)
2919 208 POLYGON((-10 10,-5 -5,0 0,-10 10))
2920 209 LINESTRING(0 0,8 8)
2921 210 LINESTRING(0 0,5 5)
2922 211 POLYGON((-50 -50,10 -10,0 0,-50 -50))
2923 212 POLYGON((0 0,1000 -1000,1000 1000,0 0))
2924 213 LINESTRING(1000 -1000,1000 1000)
2925 214 LINESTRING(1 1,9 9)
2926 215 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2927 301 POLYGON((0 0,5 5,0 5,0 0))
2928 302 POLYGON((0 0,5 0,5 5,0 5,0 0))
2929 303 POLYGON((0 0,10 0,10 10,0 10,0 0))
2930 304 POLYGON((0 0,50 0,50 50,0 50,0 0))
2931 305 POLYGON((0 0,10 0,10 10,0 10,0 0))
2932 306 POLYGON((0 0,10 0,10 10,0 10,0 0))
2933 307 POLYGON((0 0,5 5,0 5,0 0))
2934 308 POLYGON((0 0,15 0,15 15,0 15,0 0))
2935 309 POLYGON((0 0,10 0,10 10,0 10,0 0))
2936 310 POLYGON((0 0,5 5,0 5,0 0))
2937 311 POLYGON((10 10,15 10,15 15,10 15,10 10))
2938 312 POLYGON((10 10,20 10,20 20,10 20,10 10))
2939 313 POLYGON((0 0,10 0,10 10,0 10,0 0))
2940 314 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2941 315 POLYGON((0 0,10 0,10 10,0 10,0 0))
2942 401 POINT(0 0)
2943 402 LINESTRING(0 0,4 4)
2944 403 LINESTRING(0 0,10 10)
2945 404 LINESTRING(0 0,100 100)
2946 405 LINESTRING(0 0,1000 1000)
2947 406 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2948 407 POINT(0 0)
2949 408 LINESTRING(0 0,10 10)
2950 409 LINESTRING(0 0,6 6)
2951 410 POINT(0 0)
2952 411 LINESTRING(0 0,1000 1000)
2953 412 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2954 413 POINT(0 0)
2955 414 LINESTRING(-1000 -1000,1000 1000)
2956 415 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2957 501 LINESTRING(0 0,2 2)
2958 502 LINESTRING(0 0,4 4)
2959 503 LINESTRING(0 0,10 10)
2960 504 LINESTRING(-100 -100,100 100)
2961 505 LINESTRING(-1000 -1000,1000 1000)
2962 506 POLYGON((-1000 -1000,1000 -1000,1000 1000,-1000 1000,-1000 -1000))
2963 507 LINESTRING(0 0,2 2)
2964 508 LINESTRING(0 0,24 24)
2965 509 LINESTRING(0 0,10 10)
2966 510 LINESTRING(0 0,4 4)
2967 511 LINESTRING(0 0,2 2)
2968 512 LINESTRING(0 0,50 50)
2969 513 POLYGON((0 0,10 0,10 10,0 10,0 0))
2970 514 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2971 515 POLYGON((-100 0,0 -100,100 0,0 100,-100 0))
2972 601 POLYGON((0 0,5 5,0 5,0 0))
2973 602 POLYGON((0 0,10 10,5 10,0 5,0 0))
2974 603 POLYGON((0 0,10 0,10 10,0 10,0 0))
2975 604 POLYGON((0 0,5 5,0 5,0 0))
2976 605 POLYGON((-2 -2,0 -2,10 0,10 10,0 10,-2 -2))
2977 606 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
2978 607 POLYGON((0 0,5 0,5 5,0 5,0 0))
2979 608 POLYGON((0 0,10 0,10 10,0 10,0 0))
2980 609 POLYGON((-5 -5,0 -5,5 0,5 5,0 5,-5 0,-5 -5))
2981 610 POLYGON((-5 -5,0 -5,0 0,-5 0,-5 -5))
2982 611 POLYGON((10 10,20 10,20 20,10 20,10 10))
2983 612 POLYGON((-5 -5,0 -5,10 0,10 10,0 10,-5 0,-5 -5))
2984 613 POLYGON((-5 -5,5 -5,5 5,-5 5,-5 -5))
2985 614 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
2986 615 POLYGON((0 0,5 -5,10 0,5 5,0 0))
2987 701 POINT(0 0)
2988 702 LINESTRING(0 0,10 10)
2989 703 POLYGON((0 0,10 0,10 10,0 10,0 0))
2990 704 LINESTRING(0 0,10 10)
2991 705 POLYGON((0 0,10 0,10 10,0 10,0 0))
2992 706 POLYGON((-10 -10,0 -10,10 0,10 10,0 10,-10 0,-10 -10))
2993 707 POINT(0 0)
2994 708 POLYGON((0 0,10 0,10 10,0 10,0 0))
2995 709 POLYGON((-10 -10,10 0,10 10,0 10,-10 0,-10 -10))
2996 710 LINESTRING(0 0,100 100)
2997 711 POLYGON((0 0,10 0,18 18,0 10,0 0))
2998 712 POLYGON((-10 -10,10 0,20 20,0 10,-10 0,-10 -10))
2999 713 POLYGON((0 0,10 0,10 10,0 10,0 0))
3000 714 POLYGON((0 0,10 0,10 10,0 10,0 0))
3001 715 POLYGON((0 0,10 0,10 10,0 10,0 0))
3002 999 POINT(1 1)
3003 SELECT fid, ST_ISEMPTY(g) FROM gis_geometry_1;
3004 fid ST_ISEMPTY(g)
3005 101 0
3006 102 0
3007 103 0
3008 104 0
3009 105 0
3010 106 0
3011 107 0
3012 108 0
3013 109 0
3014 110 0
3015 112 0
3016 113 0
3017 114 0
3018 115 0
3019 201 0
3020 202 0
3021 203 0
3022 204 0
3023 205 0
3024 206 0
3025 207 0
3026 208 0
3027 209 0
3028 210 0
3029 211 0
3030 212 0
3031 213 0
3032 214 0
3033 215 0
3034 301 0
3035 302 0
3036 303 0
3037 304 0
3038 305 0
3039 306 0
3040 307 0
3041 308 0
3042 309 0
3043 310 0
3044 311 0
3045 312 0
3046 313 0
3047 314 0
3048 315 0
3049 401 0
3050 402 0
3051 403 0
3052 404 0
3053 405 0
3054 406 0
3055 407 0
3056 408 0
3057 409 0
3058 410 0
3059 411 0
3060 412 0
3061 413 0
3062 414 0
3063 415 0
3064 501 0
3065 502 0
3066 503 0
3067 504 0
3068 505 0
3069 506 0
3070 507 0
3071 508 0
3072 509 0
3073 510 0
3074 511 0
3075 512 0
3076 513 0
3077 514 0
3078 515 0
3079 601 0
3080 602 0
3081 603 0
3082 604 0
3083 605 0
3084 606 0
3085 607 0
3086 608 0
3087 609 0
3088 610 0
3089 611 0
3090 612 0
3091 613 0
3092 614 0
3093 615 0
3094 701 0
3095 702 0
3096 703 0
3097 704 0
3098 705 0
3099 706 0
3100 707 0
3101 708 0
3102 709 0
3103 710 0
3104 711 0
3105 712 0
3106 713 0
3107 714 0
3108 715 0
3109 999 0
3110 # Cleaning up the trigger
3111 DROP TRIGGER geom_trigger;
3112 # Checking the Geometry class properties within the cursor
3113 CREATE PROCEDURE geom_cursor()
3114 BEGIN
3115 DECLARE v GEOMETRY;
3116 DECLARE c CURSOR FOR SELECT g FROM gis_geometry;
3117 OPEN c;
3118 FETCH c INTO v;
3119 CLOSE c;
3120 SELECT ST_GEOMETRYTYPE(v);
3121 SELECT ST_SRID(v);
3122 SELECT ST_DIMENSION(v);
3123 SELECT ST_ASTEXT(ST_ENVELOPE(v));
3124 SELECT ST_ISSIMPLE(v);
3125 SELECT ST_ASTEXT(ST_CENTROID(v));
3126 SELECT ST_ASTEXT(ST_CONVEXHULL(v));
3127 SELECT ST_ISEMPTY(v);
3128 END|
3129 # Calling the cursor
3130 CALL geom_cursor();
3131 ST_GEOMETRYTYPE(v)
3132 POINT
3133 ST_SRID(v)
3134 0
3135 ST_DIMENSION(v)
3136 0
3137 ST_ASTEXT(ST_ENVELOPE(v))
3138 POINT(0 0)
3139 ST_ISSIMPLE(v)
3140 1
3141 ST_ASTEXT(ST_CENTROID(v))
3142 POINT(0 0)
3143 ST_ASTEXT(ST_CONVEXHULL(v))
3144 POINT(0 0)
3145 ST_ISEMPTY(v)
3146 0
3147 # Dropping the created cursor
3148 DROP PROCEDURE geom_cursor;
3149 # Checking the Self join with the geometry properties
3150 SELECT
3151 ST_GEOMETRYTYPE(tableX.g), ST_GEOMETRYTYPE(tableY.g),
3152 ST_SRID(tableX.g), ST_SRID(tableX.g),
3153 ST_DIMENSION(tableX.g), ST_DIMENSION(tableX.g),
3154 ST_ISSIMPLE(tableX.g), ST_ISSIMPLE(tableX.g),
3155 ST_ISEMPTY(tableX.g), ST_ISEMPTY(tableX.g)
3156 FROM gis_geometry AS tableX, gis_geometry AS tableY
3157 WHERE
3158 ST_GEOMETRYTYPE(tableX.g) = ST_GEOMETRYTYPE(tableY.g) AND
3159 ST_SRID(tableX.g) = ST_SRID(tableY.g) AND
3160 ST_DIMENSION(tableX.g) = ST_DIMENSION(tableY.g) AND
3161 ST_ISSIMPLE(tableX.g) = ST_ISSIMPLE(tableY.g) AND
3162 ST_ISEMPTY(tableX.g) = ST_ISEMPTY(tableY.g);
3163 ST_GEOMETRYTYPE(tableX.g) ST_GEOMETRYTYPE(tableY.g) ST_SRID(tableX.g) ST_SRID(tableX.g) ST_DIMENSION(tableX.g) ST_DIMENSION(tableX.g) ST_ISSIMPLE(tableX.g) ST_ISSIMPLE(tableX.g) ST_ISEMPTY(tableX.g) ST_ISEMPTY(tableX.g)
3164 POINT POINT 0 0 0 0 1 1 0 0
3165 POINT POINT 0 0 0 0 1 1 0 0
3166 POINT POINT 0 0 0 0 1 1 0 0
3167 POINT POINT 0 0 0 0 1 1 0 0
3168 POINT POINT 0 0 0 0 1 1 0 0
3169 POINT POINT 0 0 0 0 1 1 0 0
3170 POINT POINT 0 0 0 0 1 1 0 0
3171 POINT POINT 0 0 0 0 1 1 0 0
3172 POINT POINT 0 0 0 0 1 1 0 0
3173 POINT POINT 0 0 0 0 1 1 0 0
3174 POINT POINT 0 0 0 0 1 1 0 0
3175 POINT POINT 0 0 0 0 1 1 0 0
3176 POINT POINT 0 0 0 0 1 1 0 0
3177 POINT POINT 0 0 0 0 1 1 0 0
3178 POINT POINT 0 0 0 0 1 1 0 0
3179 POINT POINT 0 0 0 0 1 1 0 0
3180 POINT POINT 0 0 0 0 1 1 0 0
3181 POINT POINT 0 0 0 0 1 1 0 0
3182 POINT POINT 0 0 0 0 1 1 0 0
3183 POINT POINT 0 0 0 0 1 1 0 0
3184 POINT POINT 0 0 0 0 1 1 0 0
3185 POINT POINT 0 0 0 0 1 1 0 0
3186 POINT POINT 0 0 0 0 1 1 0 0
3187 POINT POINT 0 0 0 0 1 1 0 0
3188 POINT POINT 0 0 0 0 1 1 0 0
3189 POINT POINT 0 0 0 0 1 1 0 0
3190 POINT POINT 0 0 0 0 1 1 0 0
3191 POINT POINT 0 0 0 0 1 1 0 0
3192 POINT POINT 0 0 0 0 1 1 0 0
3193 POINT POINT 0 0 0 0 1 1 0 0
3194 POINT POINT 0 0 0 0 1 1 0 0
3195 POINT POINT 0 0 0 0 1 1 0 0
3196 POINT POINT 0 0 0 0 1 1 0 0
3197 POINT POINT 0 0 0 0 1 1 0 0
3198 POINT POINT 0 0 0 0 1 1 0 0
3199 POINT POINT 0 0 0 0 1 1 0 0
3200 POINT POINT 0 0 0 0 1 1 0 0
3201 POINT POINT 0 0 0 0 1 1 0 0
3202 POINT POINT 0 0 0 0 1 1 0 0
3203 POINT POINT 0 0 0 0 1 1 0 0
3204 POINT POINT 0 0 0 0 1 1 0 0
3205 POINT POINT 0 0 0 0 1 1 0 0
3206 POINT POINT 0 0 0 0 1 1 0 0
3207 POINT POINT 0 0 0 0 1 1 0 0
3208 POINT POINT 0 0 0 0 1 1 0 0
3209 POINT POINT 0 0 0 0 1 1 0 0
3210 POINT POINT 0 0 0 0 1 1 0 0
3211 POINT POINT 0 0 0 0 1 1 0 0
3212 POINT POINT 0 0 0 0 1 1 0 0
3213 POINT POINT 0 0 0 0 1 1 0 0
3214 POINT POINT 0 0 0 0 1 1 0 0
3215 POINT POINT 0 0 0 0 1 1 0 0
3216 POINT POINT 0 0 0 0 1 1 0 0
3217 POINT POINT 0 0 0 0 1 1 0 0
3218 POINT POINT 0 0 0 0 1 1 0 0
3219 POINT POINT 0 0 0 0 1 1 0 0
3220 POINT POINT 0 0 0 0 1 1 0 0
3221 POINT POINT 0 0 0 0 1 1 0 0
3222 POINT POINT 0 0 0 0 1 1 0 0
3223 POINT POINT 0 0 0 0 1 1 0 0
3224 POINT POINT 0 0 0 0 1 1 0 0
3225 POINT POINT 0 0 0 0 1 1 0 0
3226 POINT POINT 0 0 0 0 1 1 0 0
3227 POINT POINT 0 0 0 0 1 1 0 0
3228 POINT POINT 0 0 0 0 1 1 0 0
3229 POINT POINT 0 0 0 0 1 1 0 0
3230 POINT POINT 0 0 0 0 1 1 0 0
3231 POINT POINT 0 0 0 0 1 1 0 0
3232 POINT POINT 0 0 0 0 1 1 0 0
3233 POINT POINT 0 0 0 0 1 1 0 0
3234 POINT POINT 0 0 0 0 1 1 0 0
3235 POINT POINT 0 0 0 0 1 1 0 0
3236 POINT POINT 0 0 0 0 1 1 0 0
3237 POINT POINT 0 0 0 0 1 1 0 0
3238 POINT POINT 0 0 0 0 1 1 0 0
3239 POINT POINT 0 0 0 0 1 1 0 0
3240 POINT POINT 0 0 0 0 1 1 0 0
3241 POINT POINT 0 0 0 0 1 1 0 0
3242 POINT POINT 0 0 0 0 1 1 0 0
3243 POINT POINT 0 0 0 0 1 1 0 0
3244 POINT POINT 0 0 0 0 1 1 0 0
3245 POINT POINT 0 0 0 0 1 1 0 0
3246 POINT POINT 0 0 0 0 1 1 0 0
3247 POINT POINT 0 0 0 0 1 1 0 0
3248 POINT POINT 0 0 0 0 1 1 0 0
3249 POINT POINT 0 0 0 0 1 1 0 0
3250 POINT POINT 0 0 0 0 1 1 0 0
3251 POINT POINT 0 0 0 0 1 1 0 0
3252 POINT POINT 0 0 0 0 1 1 0 0
3253 POINT POINT 0 0 0 0 1 1 0 0
3254 POINT POINT 0 0 0 0 1 1 0 0
3255 POINT POINT 0 0 0 0 1 1 0 0
3256 POINT POINT 0 0 0 0 1 1 0 0
3257 POINT POINT 0 0 0 0 1 1 0 0
3258 POINT POINT 0 0 0 0 1 1 0 0
3259 POINT POINT 0 0 0 0 1 1 0 0
3260 POINT POINT 0 0 0 0 1 1 0 0
3261 POINT POINT 0 0 0 0 1 1 0 0
3262 POINT POINT 0 0 0 0 1 1 0 0
3263 POINT POINT 0 0 0 0 1 1 0 0
3264 POINT POINT 0 0 0 0 1 1 0 0
3265 POINT POINT 0 0 0 0 1 1 0 0
3266 POINT POINT 0 0 0 0 1 1 0 0
3267 POINT POINT 0 0 0 0 1 1 0 0
3268 POINT POINT 0 0 0 0 1 1 0 0
3269 POINT POINT 0 0 0 0 1 1 0 0
3270 POINT POINT 0 0 0 0 1 1 0 0
3271 POINT POINT 0 0 0 0 1 1 0 0
3272 POINT POINT 0 0 0 0 1 1 0 0
3273 POINT POINT 0 0 0 0 1 1 0 0
3274 POINT POINT 0 0 0 0 1 1 0 0
3275 POINT POINT 0 0 0 0 1 1 0 0
3276 POINT POINT 0 0 0 0 1 1 0 0
3277 POINT POINT 0 0 0 0 1 1 0 0
3278 POINT POINT 0 0 0 0 1 1 0 0
3279 POINT POINT 0 0 0 0 1 1 0 0
3280 POINT POINT 0 0 0 0 1 1 0 0
3281 POINT POINT 0 0 0 0 1 1 0 0
3282 POINT POINT 0 0 0 0 1 1 0 0
3283 POINT POINT 0 0 0 0 1 1 0 0
3284 POINT POINT 0 0 0 0 1 1 0 0
3285 POINT POINT 0 0 0 0 1 1 0 0
3286 POINT POINT 0 0 0 0 1 1 0 0
3287 POINT POINT 0 0 0 0 1 1 0 0
3288 POINT POINT 0 0 0 0 1 1 0 0
3289 POINT POINT 0 0 0 0 1 1 0 0
3290 POINT POINT 0 0 0 0 1 1 0 0
3291 POINT POINT 0 0 0 0 1 1 0 0
3292 POINT POINT 0 0 0 0 1 1 0 0
3293 POINT POINT 0 0 0 0 1 1 0 0
3294 POINT POINT 0 0 0 0 1 1 0 0
3295 POINT POINT 0 0 0 0 1 1 0 0
3296 POINT POINT 0 0 0 0 1 1 0 0
3297 POINT POINT 0 0 0 0 1 1 0 0
3298 POINT POINT 0 0 0 0 1 1 0 0
3299 POINT POINT 0 0 0 0 1 1 0 0
3300 POINT POINT 0 0 0 0 1 1 0 0
3301 POINT POINT 0 0 0 0 1 1 0 0
3302 POINT POINT 0 0 0 0 1 1 0 0
3303 POINT POINT 0 0 0 0 1 1 0 0
3304 POINT POINT 0 0 0 0 1 1 0 0
3305 POINT POINT 0 0 0 0 1 1 0 0
3306 POINT POINT 0 0 0 0 1 1 0 0
3307 POINT POINT 0 0 0 0 1 1 0 0
3308 POINT POINT 0 0 0 0 1 1 0 0
3309 POINT POINT 0 0 0 0 1 1 0 0
3310 POINT POINT 0 0 0 0 1 1 0 0
3311 POINT POINT 0 0 0 0 1 1 0 0
3312 POINT POINT 0 0 0 0 1 1 0 0
3313 POINT POINT 0 0 0 0 1 1 0 0
3314 POINT POINT 0 0 0 0 1 1 0 0
3315 POINT POINT 0 0 0 0 1 1 0 0
3316 POINT POINT 0 0 0 0 1 1 0 0
3317 POINT POINT 0 0 0 0 1 1 0 0
3318 POINT POINT 0 0 0 0 1 1 0 0
3319 POINT POINT 0 0 0 0 1 1 0 0
3320 POINT POINT 0 0 0 0 1 1 0 0
3321 POINT POINT 0 0 0 0 1 1 0 0
3322 POINT POINT 0 0 0 0 1 1 0 0
3323 POINT POINT 0 0 0 0 1 1 0 0
3324 POINT POINT 0 0 0 0 1 1 0 0
3325 POINT POINT 0 0 0 0 1 1 0 0
3326 POINT POINT 0 0 0 0 1 1 0 0
3327 POINT POINT 0 0 0 0 1 1 0 0
3328 POINT POINT 0 0 0 0 1 1 0 0
3329 POINT POINT 0 0 0 0 1 1 0 0
3330 POINT POINT 0 0 0 0 1 1 0 0
3331 POINT POINT 0 0 0 0 1 1 0 0
3332 POINT POINT 0 0 0 0 1 1 0 0
3333 POINT POINT 0 0 0 0 1 1 0 0
3334 POINT POINT 0 0 0 0 1 1 0 0
3335 POINT POINT 0 0 0 0 1 1 0 0
3336 POINT POINT 0 0 0 0 1 1 0 0
3337 POINT POINT 0 0 0 0 1 1 0 0
3338 POINT POINT 0 0 0 0 1 1 0 0
3339 POINT POINT 0 0 0 0 1 1 0 0
3340 POINT POINT 0 0 0 0 1 1 0 0
3341 POINT POINT 0 0 0 0 1 1 0 0
3342 POINT POINT 0 0 0 0 1 1 0 0
3343 POINT POINT 0 0 0 0 1 1 0 0
3344 POINT POINT 0 0 0 0 1 1 0 0
3345 POINT POINT 0 0 0 0 1 1 0 0
3346 POINT POINT 0 0 0 0 1 1 0 0
3347 POINT POINT 0 0 0 0 1 1 0 0
3348 POINT POINT 0 0 0 0 1 1 0 0
3349 POINT POINT 0 0 0 0 1 1 0 0
3350 POINT POINT 0 0 0 0 1 1 0 0
3351 POINT POINT 0 0 0 0 1 1 0 0
3352 POINT POINT 0 0 0 0 1 1 0 0
3353 POINT POINT 0 0 0 0 1 1 0 0
3354 POINT POINT 0 0 0 0 1 1 0 0
3355 POINT POINT 0 0 0 0 1 1 0 0
3356 POINT POINT 0 0 0 0 1 1 0 0
3357 POINT POINT 0 0 0 0 1 1 0 0
3358 POINT POINT 0 0 0 0 1 1 0 0
3359 POINT POINT 0 0 0 0 1 1 0 0
3360 POINT POINT 0 0 0 0 1 1 0 0
3361 POINT POINT 0 0 0 0 1 1 0 0
3362 POINT POINT 0 0 0 0 1 1 0 0
3363 POINT POINT 0 0 0 0 1 1 0 0
3364 POINT POINT 0 0 0 0 1 1 0 0
3365 POINT POINT 0 0 0 0 1 1 0 0
3366 POINT POINT 0 0 0 0 1 1 0 0
3367 POINT POINT 0 0 0 0 1 1 0 0
3368 POINT POINT 0 0 0 0 1 1 0 0
3369 POINT POINT 0 0 0 0 1 1 0 0
3370 POINT POINT 0 0 0 0 1 1 0 0
3371 POINT POINT 0 0 0 0 1 1 0 0
3372 POINT POINT 0 0 0 0 1 1 0 0
3373 POINT POINT 0 0 0 0 1 1 0 0
3374 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3375 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3376 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3377 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3378 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3379 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3380 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3381 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3382 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3383 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3384 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3385 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3386 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3387 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3388 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3389 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3390 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3391 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3392 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3393 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3394 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3395 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3396 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3397 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3398 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3399 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3400 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3401 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3402 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3403 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3404 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3405 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3406 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3407 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3408 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3409 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3410 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3411 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3412 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3413 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3414 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3415 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3416 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3417 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3418 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3419 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3420 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3421 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3422 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3423 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3424 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3425 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3426 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3427 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3428 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3429 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3430 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3431 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3432 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3433 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3434 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3435 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3436 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3437 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3438 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3439 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3440 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3441 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3442 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3443 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3444 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3445 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3446 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3447 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3448 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3449 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3450 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3451 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3452 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3453 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3454 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3455 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3456 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3457 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3458 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3459 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3460 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3461 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3462 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3463 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3464 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3465 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3466 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3467 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3468 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3469 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3470 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3471 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3472 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3473 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3474 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3475 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3476 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3477 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3478 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3479 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3480 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3481 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3482 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3483 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3484 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3485 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3486 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3487 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3488 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3489 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3490 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3491 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3492 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3493 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3494 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3495 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3496 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3497 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3498 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3499 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3500 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3501 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3502 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3503 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3504 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3505 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3506 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3507 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3508 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3509 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3510 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3511 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3512 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3513 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3514 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3515 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3516 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3517 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3518 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3519 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3520 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3521 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3522 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3523 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3524 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3525 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3526 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3527 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3528 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3529 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3530 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3531 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3532 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3533 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3534 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3535 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3536 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3537 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3538 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3539 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3540 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3541 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3542 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3543 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3544 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3545 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3546 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3547 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3548 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3549 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3550 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3551 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3552 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3553 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3554 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3555 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3556 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3557 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3558 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3559 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3560 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3561 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3562 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3563 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3564 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3565 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3566 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3567 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3568 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3569 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3570 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3571 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3572 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3573 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3574 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3575 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3576 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3577 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3578 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3579 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3580 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3581 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3582 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3583 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3584 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3585 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3586 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3587 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3588 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3589 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3590 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3591 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3592 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3593 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3594 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3595 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3596 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3597 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3598 LINESTRING LINESTRING 0 0 1 1 1 1 0 0
3599 POLYGON POLYGON 0 0 2 2 1 1 0 0
3600 POLYGON POLYGON 0 0 2 2 1 1 0 0
3601 POLYGON POLYGON 0 0 2 2 1 1 0 0
3602 POLYGON POLYGON 0 0 2 2 1 1 0 0
3603 POLYGON POLYGON 0 0 2 2 1 1 0 0
3604 POLYGON POLYGON 0 0 2 2 1 1 0 0
3605 POLYGON POLYGON 0 0 2 2 1 1 0 0
3606 POLYGON POLYGON 0 0 2 2 1 1 0 0
3607 POLYGON POLYGON 0 0 2 2 1 1 0 0
3608 POLYGON POLYGON 0 0 2 2 1 1 0 0
3609 POLYGON POLYGON 0 0 2 2 1 1 0 0
3610 POLYGON POLYGON 0 0 2 2 1 1 0 0
3611 POLYGON POLYGON 0 0 2 2 1 1 0 0
3612 POLYGON POLYGON 0 0 2 2 1 1 0 0
3613 POLYGON POLYGON 0 0 2 2 1 1 0 0
3614 POLYGON POLYGON 0 0 2 2 1 1 0 0
3615 POLYGON POLYGON 0 0 2 2 1 1 0 0
3616 POLYGON POLYGON 0 0 2 2 1 1 0 0
3617 POLYGON POLYGON 0 0 2 2 1 1 0 0
3618 POLYGON POLYGON 0 0 2 2 1 1 0 0
3619 POLYGON POLYGON 0 0 2 2 1 1 0 0
3620 POLYGON POLYGON 0 0 2 2 1 1 0 0
3621 POLYGON POLYGON 0 0 2 2 1 1 0 0
3622 POLYGON POLYGON 0 0 2 2 1 1 0 0
3623 POLYGON POLYGON 0 0 2 2 1 1 0 0
3624 POLYGON POLYGON 0 0 2 2 1 1 0 0
3625 POLYGON POLYGON 0 0 2 2 1 1 0 0
3626 POLYGON POLYGON 0 0 2 2 1 1 0 0
3627 POLYGON POLYGON 0 0 2 2 1 1 0 0
3628 POLYGON POLYGON 0 0 2 2 1 1 0 0
3629 POLYGON POLYGON 0 0 2 2 1 1 0 0
3630 POLYGON POLYGON 0 0 2 2 1 1 0 0
3631 POLYGON POLYGON 0 0 2 2 1 1 0 0
3632 POLYGON POLYGON 0 0 2 2 1 1 0 0
3633 POLYGON POLYGON 0 0 2 2 1 1 0 0
3634 POLYGON POLYGON 0 0 2 2 1 1 0 0
3635 POLYGON POLYGON 0 0 2 2 1 1 0 0
3636 POLYGON POLYGON 0 0 2 2 1 1 0 0
3637 POLYGON POLYGON 0 0 2 2 1 1 0 0
3638 POLYGON POLYGON 0 0 2 2 1 1 0 0
3639 POLYGON POLYGON 0 0 2 2 1 1 0 0
3640 POLYGON POLYGON 0 0 2 2 1 1 0 0
3641 POLYGON POLYGON 0 0 2 2 1 1 0 0
3642 POLYGON POLYGON 0 0 2 2 1 1 0 0
3643 POLYGON POLYGON 0 0 2 2 1 1 0 0
3644 POLYGON POLYGON 0 0 2 2 1 1 0 0
3645 POLYGON POLYGON 0 0 2 2 1 1 0 0
3646 POLYGON POLYGON 0 0 2 2 1 1 0 0
3647 POLYGON POLYGON 0 0 2 2 1 1 0 0
3648 POLYGON POLYGON 0 0 2 2 1 1 0 0
3649 POLYGON POLYGON 0 0 2 2 1 1 0 0
3650 POLYGON POLYGON 0 0 2 2 1 1 0 0
3651 POLYGON POLYGON 0 0 2 2 1 1 0 0
3652 POLYGON POLYGON 0 0 2 2 1 1 0 0
3653 POLYGON POLYGON 0 0 2 2 1 1 0 0
3654 POLYGON POLYGON 0 0 2 2 1 1 0 0
3655 POLYGON POLYGON 0 0 2 2 1 1 0 0
3656 POLYGON POLYGON 0 0 2 2 1 1 0 0
3657 POLYGON POLYGON 0 0 2 2 1 1 0 0
3658 POLYGON POLYGON 0 0 2 2 1 1 0 0
3659 POLYGON POLYGON 0 0 2 2 1 1 0 0
3660 POLYGON POLYGON 0 0 2 2 1 1 0 0
3661 POLYGON POLYGON 0 0 2 2 1 1 0 0
3662 POLYGON POLYGON 0 0 2 2 1 1 0 0
3663 POLYGON POLYGON 0 0 2 2 1 1 0 0
3664 POLYGON POLYGON 0 0 2 2 1 1 0 0
3665 POLYGON POLYGON 0 0 2 2 1 1 0 0
3666 POLYGON POLYGON 0 0 2 2 1 1 0 0
3667 POLYGON POLYGON 0 0 2 2 1 1 0 0
3668 POLYGON POLYGON 0 0 2 2 1 1 0 0
3669 POLYGON POLYGON 0 0 2 2 1 1 0 0
3670 POLYGON POLYGON 0 0 2 2 1 1 0 0
3671 POLYGON POLYGON 0 0 2 2 1 1 0 0
3672 POLYGON POLYGON 0 0 2 2 1 1 0 0
3673 POLYGON POLYGON 0 0 2 2 1 1 0 0
3674 POLYGON POLYGON 0 0 2 2 1 1 0 0
3675 POLYGON POLYGON 0 0 2 2 1 1 0 0
3676 POLYGON POLYGON 0 0 2 2 1 1 0 0
3677 POLYGON POLYGON 0 0 2 2 1 1 0 0
3678 POLYGON POLYGON 0 0 2 2 1 1 0 0
3679 POLYGON POLYGON 0 0 2 2 1 1 0 0
3680 POLYGON POLYGON 0 0 2 2 1 1 0 0
3681 POLYGON POLYGON 0 0 2 2 1 1 0 0
3682 POLYGON POLYGON 0 0 2 2 1 1 0 0
3683 POLYGON POLYGON 0 0 2 2 1 1 0 0
3684 POLYGON POLYGON 0 0 2 2 1 1 0 0
3685 POLYGON POLYGON 0 0 2 2 1 1 0 0
3686 POLYGON POLYGON 0 0 2 2 1 1 0 0
3687 POLYGON POLYGON 0 0 2 2 1 1 0 0
3688 POLYGON POLYGON 0 0 2 2 1 1 0 0
3689 POLYGON POLYGON 0 0 2 2 1 1 0 0
3690 POLYGON POLYGON 0 0 2 2 1 1 0 0
3691 POLYGON POLYGON 0 0 2 2 1 1 0 0
3692 POLYGON POLYGON 0 0 2 2 1 1 0 0
3693 POLYGON POLYGON 0 0 2 2 1 1 0 0
3694 POLYGON POLYGON 0 0 2 2 1 1 0 0
3695 POLYGON POLYGON 0 0 2 2 1 1 0 0
3696 POLYGON POLYGON 0 0 2 2 1 1 0 0
3697 POLYGON POLYGON 0 0 2 2 1 1 0 0
3698 POLYGON POLYGON 0 0 2 2 1 1 0 0
3699 POLYGON POLYGON 0 0 2 2 1 1 0 0
3700 POLYGON POLYGON 0 0 2 2 1 1 0 0
3701 POLYGON POLYGON 0 0 2 2 1 1 0 0
3702 POLYGON POLYGON 0 0 2 2 1 1 0 0
3703 POLYGON POLYGON 0 0 2 2 1 1 0 0
3704 POLYGON POLYGON 0 0 2 2 1 1 0 0
3705 POLYGON POLYGON 0 0 2 2 1 1 0 0
3706 POLYGON POLYGON 0 0 2 2 1 1 0 0
3707 POLYGON POLYGON 0 0 2 2 1 1 0 0
3708 POLYGON POLYGON 0 0 2 2 1 1 0 0
3709 POLYGON POLYGON 0 0 2 2 1 1 0 0
3710 POLYGON POLYGON 0 0 2 2 1 1 0 0
3711 POLYGON POLYGON 0 0 2 2 1 1 0 0
3712 POLYGON POLYGON 0 0 2 2 1 1 0 0
3713 POLYGON POLYGON 0 0 2 2 1 1 0 0
3714 POLYGON POLYGON 0 0 2 2 1 1 0 0
3715 POLYGON POLYGON 0 0 2 2 1 1 0 0
3716 POLYGON POLYGON 0 0 2 2 1 1 0 0
3717 POLYGON POLYGON 0 0 2 2 1 1 0 0
3718 POLYGON POLYGON 0 0 2 2 1 1 0 0
3719 POLYGON POLYGON 0 0 2 2 1 1 0 0
3720 POLYGON POLYGON 0 0 2 2 1 1 0 0
3721 POLYGON POLYGON 0 0 2 2 1 1 0 0
3722 POLYGON POLYGON 0 0 2 2 1 1 0 0
3723 POLYGON POLYGON 0 0 2 2 1 1 0 0
3724 POLYGON POLYGON 0 0 2 2 1 1 0 0
3725 POLYGON POLYGON 0 0 2 2 1 1 0 0
3726 POLYGON POLYGON 0 0 2 2 1 1 0 0
3727 POLYGON POLYGON 0 0 2 2 1 1 0 0
3728 POLYGON POLYGON 0 0 2 2 1 1 0 0
3729 POLYGON POLYGON 0 0 2 2 1 1 0 0
3730 POLYGON POLYGON 0 0 2 2 1 1 0 0
3731 POLYGON POLYGON 0 0 2 2 1 1 0 0
3732 POLYGON POLYGON 0 0 2 2 1 1 0 0
3733 POLYGON POLYGON 0 0 2 2 1 1 0 0
3734 POLYGON POLYGON 0 0 2 2 1 1 0 0
3735 POLYGON POLYGON 0 0 2 2 1 1 0 0
3736 POLYGON POLYGON 0 0 2 2 1 1 0 0
3737 POLYGON POLYGON 0 0 2 2 1 1 0 0
3738 POLYGON POLYGON 0 0 2 2 1 1 0 0
3739 POLYGON POLYGON 0 0 2 2 1 1 0 0
3740 POLYGON POLYGON 0 0 2 2 1 1 0 0
3741 POLYGON POLYGON 0 0 2 2 1 1 0 0
3742 POLYGON POLYGON 0 0 2 2 1 1 0 0
3743 POLYGON POLYGON 0 0 2 2 1 1 0 0
3744 POLYGON POLYGON 0 0 2 2 1 1 0 0
3745 POLYGON POLYGON 0 0 2 2 1 1 0 0
3746 POLYGON POLYGON 0 0 2 2 1 1 0 0
3747 POLYGON POLYGON 0 0 2 2 1 1 0 0
3748 POLYGON POLYGON 0 0 2 2 1 1 0 0
3749 POLYGON POLYGON 0 0 2 2 1 1 0 0
3750 POLYGON POLYGON 0 0 2 2 1 1 0 0
3751 POLYGON POLYGON 0 0 2 2 1 1 0 0
3752 POLYGON POLYGON 0 0 2 2 1 1 0 0
3753 POLYGON POLYGON 0 0 2 2 1 1 0 0
3754 POLYGON POLYGON 0 0 2 2 1 1 0 0
3755 POLYGON POLYGON 0 0 2 2 1 1 0 0
3756 POLYGON POLYGON 0 0 2 2 1 1 0 0
3757 POLYGON POLYGON 0 0 2 2 1 1 0 0
3758 POLYGON POLYGON 0 0 2 2 1 1 0 0
3759 POLYGON POLYGON 0 0 2 2 1 1 0 0
3760 POLYGON POLYGON 0 0 2 2 1 1 0 0
3761 POLYGON POLYGON 0 0 2 2 1 1 0 0
3762 POLYGON POLYGON 0 0 2 2 1 1 0 0
3763 POLYGON POLYGON 0 0 2 2 1 1 0 0
3764 POLYGON POLYGON 0 0 2 2 1 1 0 0
3765 POLYGON POLYGON 0 0 2 2 1 1 0 0
3766 POLYGON POLYGON 0 0 2 2 1 1 0 0
3767 POLYGON POLYGON 0 0 2 2 1 1 0 0
3768 POLYGON POLYGON 0 0 2 2 1 1 0 0
3769 POLYGON POLYGON 0 0 2 2 1 1 0 0
3770 POLYGON POLYGON 0 0 2 2 1 1 0 0
3771 POLYGON POLYGON 0 0 2 2 1 1 0 0
3772 POLYGON POLYGON 0 0 2 2 1 1 0 0
3773 POLYGON POLYGON 0 0 2 2 1 1 0 0
3774 POLYGON POLYGON 0 0 2 2 1 1 0 0
3775 POLYGON POLYGON 0 0 2 2 1 1 0 0
3776 POLYGON POLYGON 0 0 2 2 1 1 0 0
3777 POLYGON POLYGON 0 0 2 2 1 1 0 0
3778 POLYGON POLYGON 0 0 2 2 1 1 0 0
3779 POLYGON POLYGON 0 0 2 2 1 1 0 0
3780 POLYGON POLYGON 0 0 2 2 1 1 0 0
3781 POLYGON POLYGON 0 0 2 2 1 1 0 0
3782 POLYGON POLYGON 0 0 2 2 1 1 0 0
3783 POLYGON POLYGON 0 0 2 2 1 1 0 0
3784 POLYGON POLYGON 0 0 2 2 1 1 0 0
3785 POLYGON POLYGON 0 0 2 2 1 1 0 0
3786 POLYGON POLYGON 0 0 2 2 1 1 0 0
3787 POLYGON POLYGON 0 0 2 2 1 1 0 0
3788 POLYGON POLYGON 0 0 2 2 1 1 0 0
3789 POLYGON POLYGON 0 0 2 2 1 1 0 0
3790 POLYGON POLYGON 0 0 2 2 1 1 0 0
3791 POLYGON POLYGON 0 0 2 2 1 1 0 0
3792 POLYGON POLYGON 0 0 2 2 1 1 0 0
3793 POLYGON POLYGON 0 0 2 2 1 1 0 0
3794 POLYGON POLYGON 0 0 2 2 1 1 0 0
3795 POLYGON POLYGON 0 0 2 2 1 1 0 0
3796 POLYGON POLYGON 0 0 2 2 1 1 0 0
3797 POLYGON POLYGON 0 0 2 2 1 1 0 0
3798 POLYGON POLYGON 0 0 2 2 1 1 0 0
3799 POLYGON POLYGON 0 0 2 2 1 1 0 0
3800 POLYGON POLYGON 0 0 2 2 1 1 0 0
3801 POLYGON POLYGON 0 0 2 2 1 1 0 0
3802 POLYGON POLYGON 0 0 2 2 1 1 0 0
3803 POLYGON POLYGON 0 0 2 2 1 1 0 0
3804 POLYGON POLYGON 0 0 2 2 1 1 0 0
3805 POLYGON POLYGON 0 0 2 2 1 1 0 0
3806 POLYGON POLYGON 0 0 2 2 1 1 0 0
3807 POLYGON POLYGON 0 0 2 2 1 1 0 0
3808 POLYGON POLYGON 0 0 2 2 1 1 0 0
3809 POLYGON POLYGON 0 0 2 2 1 1 0 0
3810 POLYGON POLYGON 0 0 2 2 1 1 0 0
3811 POLYGON POLYGON 0 0 2 2 1 1 0 0
3812 POLYGON POLYGON 0 0 2 2 1 1 0 0
3813 POLYGON POLYGON 0 0 2 2 1 1 0 0
3814 POLYGON POLYGON 0 0 2 2 1 1 0 0
3815 POLYGON POLYGON 0 0 2 2 1 1 0 0
3816 POLYGON POLYGON 0 0 2 2 1 1 0 0
3817 POLYGON POLYGON 0 0 2 2 1 1 0 0
3818 POLYGON POLYGON 0 0 2 2 1 1 0 0
3819 POLYGON POLYGON 0 0 2 2 1 1 0 0
3820 POLYGON POLYGON 0 0 2 2 1 1 0 0
3821 POLYGON POLYGON 0 0 2 2 1 1 0 0
3822 POLYGON POLYGON 0 0 2 2 1 1 0 0
3823 POLYGON POLYGON 0 0 2 2 1 1 0 0
3824 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3825 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3826 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3827 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3828 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3829 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3830 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3831 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3832 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3833 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3834 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3835 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3836 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3837 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3838 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3839 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3840 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3841 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3842 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3843 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3844 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3845 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3846 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3847 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3848 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3849 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3850 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3851 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3852 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3853 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3854 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3855 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3856 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3857 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3858 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3859 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3860 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3861 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3862 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3863 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3864 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3865 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3866 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3867 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3868 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3869 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3870 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3871 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3872 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3873 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3874 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3875 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3876 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3877 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3878 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3879 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3880 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3881 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3882 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3883 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3884 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3885 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3886 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3887 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3888 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3889 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3890 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3891 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3892 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3893 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3894 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3895 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3896 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3897 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3898 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3899 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3900 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3901 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3902 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3903 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3904 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3905 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3906 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3907 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3908 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3909 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3910 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3911 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3912 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3913 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3914 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3915 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3916 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3917 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3918 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3919 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3920 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3921 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3922 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3923 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3924 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3925 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3926 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3927 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3928 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3929 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3930 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3931 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3932 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3933 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3934 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3935 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3936 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3937 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3938 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3939 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3940 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3941 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3942 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3943 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3944 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3945 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3946 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3947 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3948 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3949 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3950 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3951 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3952 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3953 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3954 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3955 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3956 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3957 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3958 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3959 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3960 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3961 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3962 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3963 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3964 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3965 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3966 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3967 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3968 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3969 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3970 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3971 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3972 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3973 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3974 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3975 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3976 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3977 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3978 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3979 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3980 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3981 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3982 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3983 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3984 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3985 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3986 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3987 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3988 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3989 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3990 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3991 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3992 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3993 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3994 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3995 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3996 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3997 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3998 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
3999 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4000 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4001 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4002 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4003 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4004 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4005 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4006 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4007 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4008 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4009 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4010 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4011 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4012 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4013 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4014 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4015 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4016 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4017 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4018 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4019 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0
4020 MULTIPOINT MULTIPOINT 0 0 0 0 0 0 0 0
4021 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4022 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4023 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4024 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4025 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4026 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4027 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4028 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4029 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4030 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4031 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4032 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4033 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4034 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4035 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4036 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4037 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4038 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4039 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4040 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4041 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4042 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4043 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4044 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4045 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4046 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4047 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4048 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4049 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4050 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4051 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4052 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4053 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4054 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4055 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4056 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4057 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4058 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4059 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4060 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4061 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4062 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4063 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4064 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4065 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4066 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4067 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4068 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4069 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4070 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4071 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4072 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4073 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4074 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4075 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4076 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4077 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4078 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4079 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4080 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4081 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4082 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4083 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4084 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4085 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4086 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4087 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4088 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4089 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4090 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4091 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4092 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4093 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4094 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4095 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4096 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4097 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4098 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4099 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4100 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4101 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4102 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4103 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4104 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4105 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4106 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4107 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4108 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4109 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4110 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4111 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4112 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4113 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4114 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4115 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4116 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4117 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4118 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4119 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4120 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4121 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4122 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4123 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4124 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4125 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4126 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4127 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4128 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4129 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4130 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4131 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4132 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4133 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4134 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4135 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4136 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4137 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4138 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4139 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4140 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4141 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4142 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4143 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4144 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4145 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4146 MULTILINESTRING MULTILINESTRING 0 0 1 1 0 0 0 0
4147 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4148 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4149 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4150 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4151 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4152 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4153 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4154 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4155 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4156 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4157 MULTILINESTRING MULTILINESTRING 0 0 1 1 1 1 0 0
4158 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4159 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4160 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4161 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4162 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4163 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4164 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4165 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4166 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4167 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4168 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4169 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4170 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4171 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4172 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4173 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4174 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4175 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4176 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4177 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4178 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4179 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4180 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4181 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4182 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4183 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4184 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4185 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4186 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4187 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4188 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4189 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4190 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4191 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4192 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4193 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4194 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4195 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4196 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4197 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4198 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4199 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4200 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4201 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4202 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4203 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4204 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4205 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4206 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4207 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4208 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4209 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4210 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4211 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4212 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4213 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4214 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4215 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4216 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4217 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4218 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4219 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4220 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4221 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4222 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4223 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4224 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4225 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4226 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4227 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4228 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4229 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4230 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4231 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4232 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4233 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4234 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4235 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4236 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4237 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4238 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4239 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4240 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4241 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4242 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4243 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4244 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4245 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4246 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4247 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4248 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4249 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4250 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4251 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4252 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4253 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4254 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4255 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4256 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4257 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4258 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4259 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4260 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4261 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4262 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4263 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4264 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4265 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4266 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4267 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4268 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4269 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4270 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4271 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4272 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4273 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4274 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4275 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4276 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4277 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4278 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4279 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4280 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4281 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4282 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4283 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4284 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4285 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4286 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4287 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4288 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4289 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4290 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4291 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4292 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4293 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4294 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4295 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4296 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4297 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4298 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4299 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4300 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4301 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4302 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4303 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4304 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4305 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4306 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4307 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4308 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4309 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4310 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4311 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4312 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4313 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4314 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4315 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4316 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4317 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4318 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4319 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4320 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4321 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4322 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4323 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4324 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4325 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4326 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4327 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4328 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4329 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4330 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4331 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4332 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4333 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4334 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4335 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4336 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4337 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4338 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4339 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4340 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4341 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4342 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4343 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4344 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4345 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4346 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4347 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4348 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4349 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4350 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4351 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4352 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4353 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4354 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4355 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4356 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4357 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4358 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4359 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4360 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4361 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4362 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4363 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4364 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4365 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4366 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4367 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4368 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4369 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4370 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4371 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4372 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4373 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4374 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4375 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4376 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4377 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4378 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4379 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4380 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4381 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4382 MULTIPOLYGON MULTIPOLYGON 0 0 2 2 1 1 0 0
4383 GEOMCOLLECTION GEOMCOLLECTION 0 0 0 0 1 1 0 0
4384 GEOMCOLLECTION GEOMCOLLECTION 0 0 0 0 1 1 0 0
4385 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4386 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4387 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4388 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4389 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4390 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4391 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4392 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4393 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4394 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4395 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4396 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4397 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4398 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4399 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4400 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4401 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4402 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4403 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4404 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4405 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4406 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4407 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4408 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4409 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4410 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4411 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4412 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4413 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4414 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4415 GEOMCOLLECTION GEOMCOLLECTION 0 0 0 0 1 1 0 0
4416 GEOMCOLLECTION GEOMCOLLECTION 0 0 0 0 1 1 0 0
4417 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4418 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4419 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4420 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4421 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4422 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4423 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4424 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4425 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4426 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4427 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4428 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4429 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4430 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4431 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4432 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4433 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4434 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4435 GEOMCOLLECTION GEOMCOLLECTION 0 0 1 1 1 1 0 0
4436 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 1 1 0 0
4437 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4438 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4439 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4440 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4441 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4442 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4443 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4444 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4445 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4446 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4447 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4448 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4449 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4450 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4451 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4452 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4453 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4454 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4455 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4456 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4457 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4458 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4459 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4460 GEOMCOLLECTION GEOMCOLLECTION 0 0 2 2 0 0 0 0
4461 POINT POINT 0 0 0 0 1 1 0 0
4462 POINT POINT 0 0 0 0 1 1 0 0
4463 POINT POINT 0 0 0 0 1 1 0 0
4464 POINT POINT 0 0 0 0 1 1 0 0
4465 POINT POINT 0 0 0 0 1 1 0 0
4466 POINT POINT 0 0 0 0 1 1 0 0
4467 POINT POINT 0 0 0 0 1 1 0 0
4468 POINT POINT 0 0 0 0 1 1 0 0
4469 POINT POINT 0 0 0 0 1 1 0 0
4470 POINT POINT 0 0 0 0 1 1 0 0
4471 POINT POINT 0 0 0 0 1 1 0 0
4472 POINT POINT 0 0 0 0 1 1 0 0
4473 POINT POINT 0 0 0 0 1 1 0 0
4474 POINT POINT 0 0 0 0 1 1 0 0
4475 POINT POINT 0 0 0 0 1 1 0 0
4476 # Checking the aggregate functions on the geometry class properties
4477 # Checking the SUM function
4478 SELECT SUM(ST_GEOMETRYTYPE(g)) FROM gis_geometry WHERE fid % 100 = 1;
4479 SUM(ST_GEOMETRYTYPE(g))
4480 0
4481 Warnings:
4482 Warning 1292 Truncated incorrect DOUBLE value: 'POINT'
4483 Warning 1292 Truncated incorrect DOUBLE value: 'LINESTRING'
4484 Warning 1292 Truncated incorrect DOUBLE value: 'POLYGON'
4485 Warning 1292 Truncated incorrect DOUBLE value: 'MULTIPOINT'
4486 Warning 1292 Truncated incorrect DOUBLE value: 'MULTILINESTRING'
4487 Warning 1292 Truncated incorrect DOUBLE value: 'MULTIPOLYGON'
4488 Warning 1292 Truncated incorrect DOUBLE value: 'GEOMCOLLECTION'
4489 SELECT SUM(ST_SRID(g)) FROM gis_geometry;
4490 SUM(ST_SRID(g))
4491 0
4492 SELECT SUM(ST_DIMENSION(g)) FROM gis_geometry;
4493 SUM(ST_DIMENSION(g))
4494 111
4495 SELECT SUM(ST_ISSIMPLE(g)) FROM gis_geometry;
4496 SUM(ST_ISSIMPLE(g))
4497 91
4498 SELECT SUM(ST_ISEMPTY(g)) FROM gis_geometry;
4499 SUM(ST_ISEMPTY(g))
4500 0
4501 # Checking the MAX function
4502 SELECT MAX(ST_GEOMETRYTYPE(g)) FROM gis_geometry;
4503 MAX(ST_GEOMETRYTYPE(g))
4504 POLYGON
4505 SELECT MAX(ST_SRID(g)) FROM gis_geometry;
4506 MAX(ST_SRID(g))
4507 0
4508 SELECT MAX(ST_DIMENSION(g)) FROM gis_geometry;
4509 MAX(ST_DIMENSION(g))
4510 2
4511 SELECT MAX(ST_ISSIMPLE(g)) FROM gis_geometry;
4512 MAX(ST_ISSIMPLE(g))
4513 1
4514 SELECT MAX(ST_ISEMPTY(g)) FROM gis_geometry;
4515 MAX(ST_ISEMPTY(g))
4516 0
4517 # Checking the MIN function
4518 SELECT MIN(ST_GEOMETRYTYPE(g)) FROM gis_geometry;
4519 MIN(ST_GEOMETRYTYPE(g))
4520 GEOMCOLLECTION
4521 SELECT MIN(ST_SRID(g)) FROM gis_geometry;
4522 MIN(ST_SRID(g))
4523 0
4524 SELECT MIN(ST_DIMENSION(g)) FROM gis_geometry;
4525 MIN(ST_DIMENSION(g))
4526 0
4527 SELECT MIN(ST_ISSIMPLE(g)) FROM gis_geometry;
4528 MIN(ST_ISSIMPLE(g))
4529 0
4530 SELECT MIN(ST_ISEMPTY(g)) FROM gis_geometry;
4531 MIN(ST_ISEMPTY(g))
4532 0
4533 # Checking the STD function
4534 SELECT STD(ST_GEOMETRYTYPE(g)) FROM gis_geometry WHERE fid % 100 = 1;
4535 STD(ST_GEOMETRYTYPE(g))
4536 0
4537 Warnings:
4538 Warning 1292 Truncated incorrect DOUBLE value: 'POINT'
4539 Warning 1292 Truncated incorrect DOUBLE value: 'LINESTRING'
4540 Warning 1292 Truncated incorrect DOUBLE value: 'POLYGON'
4541 Warning 1292 Truncated incorrect DOUBLE value: 'MULTIPOINT'
4542 Warning 1292 Truncated incorrect DOUBLE value: 'MULTILINESTRING'
4543 Warning 1292 Truncated incorrect DOUBLE value: 'MULTIPOLYGON'
4544 Warning 1292 Truncated incorrect DOUBLE value: 'GEOMCOLLECTION'
4545 SELECT STD(ST_SRID(g)) FROM gis_geometry;
4546 STD(ST_SRID(g))
4547 0
4548 SELECT STD(ST_DIMENSION(g)) FROM gis_geometry;
4549 STD(ST_DIMENSION(g))
4550 0.8235059091
4551 SELECT STD(ST_ISSIMPLE(g)) FROM gis_geometry;
4552 STD(ST_ISSIMPLE(g))
4553 0.33993463423951903
4554 SELECT STD(ST_ISEMPTY(g)) FROM gis_geometry;
4555 STD(ST_ISEMPTY(g))
4556 0
4557 # Checking the AVG function
4558 SELECT AVG(ST_GEOMETRYTYPE(g)) FROM gis_geometry WHERE fid % 100 = 1;
4559 AVG(ST_GEOMETRYTYPE(g))
4560 0
4561 Warnings:
4562 Warning 1292 Truncated incorrect DOUBLE value: 'POINT'
4563 Warning 1292 Truncated incorrect DOUBLE value: 'LINESTRING'
4564 Warning 1292 Truncated incorrect DOUBLE value: 'POLYGON'
4565 Warning 1292 Truncated incorrect DOUBLE value: 'MULTIPOINT'
4566 Warning 1292 Truncated incorrect DOUBLE value: 'MULTILINESTRING'
4567 Warning 1292 Truncated incorrect DOUBLE value: 'MULTIPOLYGON'
4568 Warning 1292 Truncated incorrect DOUBLE value: 'GEOMCOLLECTION'
4569 SELECT AVG(ST_SRID(g)) FROM gis_geometry;
4570 AVG(ST_SRID(g))
4571 0.0000
4572 SELECT AVG(ST_DIMENSION(g)) FROM gis_geometry;
4573 AVG(ST_DIMENSION(g))
4574 1.0673
4575 SELECT AVG(ST_ISSIMPLE(g)) FROM gis_geometry;
4576 AVG(ST_ISSIMPLE(g))
4577 0.8667
4578 SELECT AVG(ST_ISEMPTY(g)) FROM gis_geometry;
4579 AVG(ST_ISEMPTY(g))
4580 0.0000
4581 # Checking the DISTINCT function
4582 SELECT COUNT(DISTINCT(ST_GEOMETRYTYPE(g))) FROM gis_geometry;
4583 COUNT(DISTINCT(ST_GEOMETRYTYPE(g)))
4584 7
4585 SELECT COUNT(DISTINCT(ST_SRID(g))) FROM gis_geometry;
4586 COUNT(DISTINCT(ST_SRID(g)))
4587 1
4588 SELECT COUNT(DISTINCT(ST_DIMENSION(g))) FROM gis_geometry;
4589 COUNT(DISTINCT(ST_DIMENSION(g)))
4590 3
4591 SELECT COUNT(DISTINCT(ST_ENVELOPE(g))) FROM gis_geometry;
4592 COUNT(DISTINCT(ST_ENVELOPE(g)))
4593 42
4594 SELECT COUNT(DISTINCT(ST_ISSIMPLE(g))) FROM gis_geometry;
4595 COUNT(DISTINCT(ST_ISSIMPLE(g)))
4596 2
4597 SELECT COUNT(DISTINCT(ST_CENTROID(g))) FROM gis_geometry;
4598 COUNT(DISTINCT(ST_CENTROID(g)))
4599 42
4600 SELECT COUNT(DISTINCT(ST_CONVEXHULL(g))) FROM gis_geometry;
4601 COUNT(DISTINCT(ST_CONVEXHULL(g)))
4602 52
4603 SELECT COUNT(DISTINCT(ST_ISEMPTY(g))) FROM gis_geometry;
4604 COUNT(DISTINCT(ST_ISEMPTY(g)))
4605 1
4606 # Final cleanup
4607 DROP TABLE gis_point;
4608 DROP TABLE gis_linestring;
4609 DROP TABLE gis_polygon;
4610 DROP TABLE gis_multi_point;
4611 DROP TABLE gis_multi_linestring;
4612 DROP TABLE gis_multi_polygon;
4613 DROP TABLE gis_geometrycollection;
4614 DROP TABLE gis_geometry;
4615 DROP TABLE gis_geometry_1;