| 1 |
# Creating the spatial Geometry object |
| 2 |
USE test; |
| 3 |
CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY); |
| 4 |
SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))'; |
| 5 |
SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))'; |
| 6 |
SET @star_center= 'POINT(15 10)'; |
| 7 |
SET @star_top= 'POINT(15 25)'; |
| 8 |
SET @star_bottom_left= 'POINT(5 0)'; |
| 9 |
SET @star_bottom_right= 'POINT(25 0)'; |
| 10 |
SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)'; |
| 11 |
SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)'; |
| 12 |
SET @star_line_horizontal= 'LINESTRING(10 15,20 15)'; |
| 13 |
SET @star_line_vertical= 'LINESTRING(15 5,15 25)'; |
| 14 |
SET @star_top_to_center= 'LINESTRING(15 25,15 10)'; |
| 15 |
SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))'; |
| 16 |
SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))'; |
| 17 |
SET @star= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'; |
| 18 |
SET @star_of_elems='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))'; |
| 19 |
SET @star_collection_elems='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))'; |
| 20 |
SET @star_collection_multilinestr='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),MULTILINESTRING((25 0,0 15,15 30,0 5)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))'; |
| 21 |
INSERT INTO gis_geometrycollection VALUES |
| 22 |
(100,ST_GEOMFROMTEXT(@star)), |
| 23 |
(101,ST_GEOMFROMTEXT(@star_elem_vertical)), |
| 24 |
(102,ST_GEOMFROMTEXT(@star_elem_horizontal)), |
| 25 |
(103,ST_GEOMFROMTEXT(@star_of_elems)), |
| 26 |
(104,ST_GEOMFROMTEXT(@star_top)), |
| 27 |
(105,ST_GEOMFROMTEXT(@star_center)), |
| 28 |
(106,ST_GEOMFROMTEXT(@star_bottom_left)), |
| 29 |
(107,ST_GEOMFROMTEXT(@star_bottom_right)), |
| 30 |
(108,ST_GEOMFROMTEXT(@star_bottom_points)), |
| 31 |
(109,ST_GEOMFROMTEXT(@star_all_points)), |
| 32 |
(110,ST_GEOMFROMTEXT(@star_line_horizontal)), |
| 33 |
(111,ST_GEOMFROMTEXT(@star_line_vertical)), |
| 34 |
(112,ST_GEOMFROMTEXT(@star_top_to_center)), |
| 35 |
(113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)), |
| 36 |
(114,ST_GEOMFROMTEXT(@star_lines_near_vertical)), |
| 37 |
(115,ST_GEOMFROMTEXT(@star_collection_elems)), |
| 38 |
(116,ST_GEOMFROMTEXT(@star_collection_multilinestr)); |
| 39 |
# Checking the integrity of the above create/insert statements |
| 40 |
# 17 rows. |
| 41 |
SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection; |
| 42 |
count(ST_ASTEXT(g) != 'NULL') |
| 43 |
17 |
| 44 |
##################################################################################### |
| 45 |
# ST_SIMPLIFY(point) |
| 46 |
##################################################################################### |
| 47 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(17 14)'), 1)); |
| 48 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(17 14)'), 1)) |
| 49 |
POINT(17 14) |
| 50 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-8 2)'), 2)); |
| 51 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-8 2)'), 2)) |
| 52 |
POINT(-8 2) |
| 53 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(9 0)'), 3)); |
| 54 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(9 0)'), 3)) |
| 55 |
POINT(9 0) |
| 56 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(10 -8)'), 4)); |
| 57 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(10 -8)'), 4)) |
| 58 |
POINT(10 -8) |
| 59 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(20 -2)'), 5)); |
| 60 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(20 -2)'), 5)) |
| 61 |
POINT(20 -2) |
| 62 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(7 13)'), 10)); |
| 63 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(7 13)'), 10)) |
| 64 |
POINT(7 13) |
| 65 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-16 11)'), 1000)); |
| 66 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-16 11)'), 1000)) |
| 67 |
POINT(-16 11) |
| 68 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-5 -2)'), 2000000)); |
| 69 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-5 -2)'), 2000000)) |
| 70 |
POINT(-5 -2) |
| 71 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-10 6)'), 1234567890)); |
| 72 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-10 6)'), 1234567890)) |
| 73 |
POINT(-10 6) |
| 74 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-16 -8)'), 111111111111)); |
| 75 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(-16 -8)'), 111111111111)) |
| 76 |
POINT(-16 -8) |
| 77 |
##################################################################################### |
| 78 |
# ST_SIMPLIFY(multipoint) |
| 79 |
##################################################################################### |
| 80 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(19 -4, -2 -6, -8 2)'), 1)); |
| 81 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(19 -4, -2 -6, -8 2)'), 1)) |
| 82 |
MULTIPOINT((19 -4),(-2 -6),(-8 2)) |
| 83 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-3 14, 19 8, 10 -8)'), 2)); |
| 84 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-3 14, 19 8, 10 -8)'), 2)) |
| 85 |
MULTIPOINT((-3 14),(19 8),(10 -8)) |
| 86 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(1 -8, -1 12, -11 16)'), 3)); |
| 87 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(1 -8, -1 12, -11 16)'), 3)) |
| 88 |
MULTIPOINT((1 -8),(-1 12),(-11 16)) |
| 89 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-16 11, -2 -7, -11 11)'), 4)); |
| 90 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-16 11, -2 -7, -11 11)'), 4)) |
| 91 |
MULTIPOINT((-16 11),(-2 -7),(-11 11)) |
| 92 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(19 12, 0 9, 5 10, 20 -16, 7 -17, 9 -18, 19 -7)'), 10)); |
| 93 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(19 12, 0 9, 5 10, 20 -16, 7 -17, 9 -18, 19 -7)'), 10)) |
| 94 |
MULTIPOINT((19 12),(0 9),(5 10),(20 -16),(7 -17),(9 -18),(19 -7)) |
| 95 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-1 11, -17 -11, -15 16, 6 -6, 11 -13, -4 -12, -13 -5)'), 1000)); |
| 96 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-1 11, -17 -11, -15 16, 6 -6, 11 -13, -4 -12, -13 -5)'), 1000)) |
| 97 |
MULTIPOINT((-1 11),(-17 -11),(-15 16),(6 -6),(11 -13),(-4 -12),(-13 -5)) |
| 98 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(17 -11, -19 -6, 5 17, -14 13, 20 13, 20 2, 0 -12)'), 200000)); |
| 99 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(17 -11, -19 -6, 5 17, -14 13, 20 13, 20 2, 0 -12)'), 200000)) |
| 100 |
MULTIPOINT((17 -11),(-19 -6),(5 17),(-14 13),(20 13),(20 2),(0 -12)) |
| 101 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-15 12, 17 -12, -7 14, 1 6, 19 -10, 11 -9, 0 -17)'), 9999999)); |
| 102 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(-15 12, 17 -12, -7 14, 1 6, 19 -10, 11 -9, 0 -17)'), 9999999)) |
| 103 |
MULTIPOINT((-15 12),(17 -12),(-7 14),(1 6),(19 -10),(11 -9),(0 -17)) |
| 104 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(3 -13, 18 -2, -5 -13, -12 1, 20 0, -6 14, 5 -4)'), 1234567890)); |
| 105 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT(3 -13, 18 -2, -5 -13, -12 1, 20 0, -6 14, 5 -4)'), 1234567890)) |
| 106 |
MULTIPOINT((3 -13),(18 -2),(-5 -13),(-12 1),(20 0),(-6 14),(5 -4)) |
| 107 |
##################################################################################### |
| 108 |
# ST_SIMPLIFY(linestring) |
| 109 |
##################################################################################### |
| 110 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1)); |
| 111 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,10 10)'), 1)) |
| 112 |
LINESTRING(0 0,10 10) |
| 113 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5)'), 3.5)); |
| 114 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5)'), 3.5)) |
| 115 |
LINESTRING(0 0,5 0,5 5) |
| 116 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5)'), 3.6)); |
| 117 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5)'), 3.6)) |
| 118 |
LINESTRING(0 0,5 5) |
| 119 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,4 4,6 -6,10 0)'), 5)); |
| 120 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,4 4,6 -6,10 0)'), 5)) |
| 121 |
LINESTRING(0 0,4 4,6 -6,10 0) |
| 122 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5,0 5,0 0)'), 3.5)); |
| 123 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5,0 5,0 0)'), 3.5)) |
| 124 |
LINESTRING(0 0,5 0,5 5,0 5,0 0) |
| 125 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5,0 5,0 0)'), 3.6)); |
| 126 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 0,5 5,0 5,0 0)'), 3.6)) |
| 127 |
LINESTRING(0 0,5 5,0 0) |
| 128 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,0 10,-5 5,0 0)'), 4.9)); |
| 129 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,0 10,-5 5,0 0)'), 4.9)) |
| 130 |
LINESTRING(0 0,5 5,0 10,-5 5,0 0) |
| 131 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,0 10,-5 5,0 0)'), 5)); |
| 132 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,5 5,0 10,-5 5,0 0)'), 5)) |
| 133 |
LINESTRING(0 0,0 10,0 0) |
| 134 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,3 -3,5 5,7 -7,9 9,10 10)'), 1)); |
| 135 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,3 -3,5 5,7 -7,9 9,10 10)'), 1)) |
| 136 |
LINESTRING(0 0,1 1,3 -3,5 5,7 -7,10 10) |
| 137 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5)'), 0.6)); |
| 138 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5)'), 0.6)) |
| 139 |
LINESTRING(0 0,0 1,1 1,4 5,5 5) |
| 140 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5)'), 0.8)); |
| 141 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5)'), 0.8)) |
| 142 |
LINESTRING(0 0,5 5) |
| 143 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 -1,4 0,5 1,6 0,7 -1,8 0,9 1,10 0)'), 0.9)); |
| 144 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 -1,4 0,5 1,6 0,7 -1,8 0,9 1,10 0)'), 0.9)) |
| 145 |
LINESTRING(0 0,1 1,3 -1,5 1,7 -1,9 1,10 0) |
| 146 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 -1,4 0,5 1,6 0,7 -1,8 0,9 1,10 0)'), 1)); |
| 147 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 -1,4 0,5 1,6 0,7 -1,8 0,9 1,10 0)'), 1)) |
| 148 |
LINESTRING(0 0,10 0) |
| 149 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 1,4 0,5 1,6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0)'), 0.6)); |
| 150 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 1,4 0,5 1,6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0)'), 0.6)) |
| 151 |
LINESTRING(0 0,1 1,2 0,3 1,4 0,5 1,6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0) |
| 152 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 1,4 0,5 1,6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0)'), 0.8)); |
| 153 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 0,3 1,4 0,5 1,6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0)'), 0.8)) |
| 154 |
LINESTRING(0 0,1 1,6 0,5 -1,0 0) |
| 155 |
##################################################################################### |
| 156 |
# ST_SIMPLIFY(multilinestring) |
| 157 |
##################################################################################### |
| 158 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,10 10))'), 1)); |
| 159 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,10 10))'), 1)) |
| 160 |
MULTILINESTRING((0 0,10 10)) |
| 161 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,10 10),(0 0,5 0,5 5))'), 3.5)); |
| 162 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,10 10),(0 0,5 0,5 5))'), 3.5)) |
| 163 |
MULTILINESTRING((0 0,10 10),(0 0,5 0,5 5)) |
| 164 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,10 10),(0 0,5 0,5 5))'), 3.6)); |
| 165 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,10 10),(0 0,5 0,5 5))'), 3.6)) |
| 166 |
MULTILINESTRING((0 0,10 10),(0 0,5 5)) |
| 167 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,5 5),(0 0,5 0,5 5,0 5,0 0))'), 3.5)); |
| 168 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,5 5),(0 0,5 0,5 5,0 5,0 0))'), 3.5)) |
| 169 |
MULTILINESTRING((0 0,5 0,5 5),(0 0,5 0,5 5,0 5,0 0)) |
| 170 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,5 5),(0 0,5 0,5 5,0 5,0 0))'), 3.6)); |
| 171 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,5 5),(0 0,5 0,5 5,0 5,0 0))'), 3.6)) |
| 172 |
MULTILINESTRING((0 0,5 5),(0 0,5 5,0 0)) |
| 173 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,0 10),(0 0,-5 5,0 10))'), 4.9)); |
| 174 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,0 10),(0 0,-5 5,0 10))'), 4.9)) |
| 175 |
MULTILINESTRING((0 0,5 5,0 10),(0 0,-5 5,0 10)) |
| 176 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,0 10),(0 0,-5 5,0 10))'), 5)); |
| 177 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 5,0 10),(0 0,-5 5,0 10))'), 5)) |
| 178 |
MULTILINESTRING((0 0,0 10),(0 0,0 10)) |
| 179 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0))'), 1)); |
| 180 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0))'), 1)) |
| 181 |
MULTILINESTRING((0 0,1 1,3 -3,5 5,7 -7,10 10,0 0)) |
| 182 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5),' |
| 183 |
'(0 0,1 0,1 1,2 1,2 2,3 2,3 3,4 3,4 4,5 4,4 4))'), 0.6)); |
| 184 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5),' |
| 185 |
'(0 0,1 0,1 1,2 1,2 2,3 2,3 3,4 3,4 4,5 4,4 4))'), 0.6)) |
| 186 |
MULTILINESTRING((0 0,0 1,1 1,4 5,5 5),(0 0,1 0,4 4,5 4,4 4)) |
| 187 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5),' |
| 188 |
'(0 0,1 0,1 1,2 1,2 2,3 2,3 3,4 3,4 4,5 4,4 4))'), 0.7)); |
| 189 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 1,1 1,1 2,2 2,2 3,3 3,3 4,4 4,4 5,5 5),' |
| 190 |
'(0 0,1 0,1 1,2 1,2 2,3 2,3 3,4 3,4 4,5 4,4 4))'), 0.7)) |
| 191 |
MULTILINESTRING((0 0,0 1,5 5),(0 0,5 4,4 4)) |
| 192 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,2 0,3 1,4 0,5 1,6 0),(6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0))'), 0.6)); |
| 193 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,2 0,3 1,4 0,5 1,6 0),(6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0))'), 0.6)) |
| 194 |
MULTILINESTRING((0 0,1 1,2 0,3 1,4 0,5 1,6 0),(6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0)) |
| 195 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,2 0,3 1,4 0,5 1,6 0),(6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0))'), 0.8)); |
| 196 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,2 0,3 1,4 0,5 1,6 0),(6 0,5 -1,4 0,3 -1,2 0,1 -1,0 0))'), 0.8)) |
| 197 |
MULTILINESTRING((0 0,1 1,6 0),(6 0,5 -1,0 0)) |
| 198 |
##################################################################################### |
| 199 |
# ST_SIMPLIFY(polygon) |
| 200 |
##################################################################################### |
| 201 |
# Invalid geometry in input. |
| 202 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,4 4,6 -6,10 0,0 0,0 0,0 0))'), 5)); |
| 203 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,4 4,6 -6,10 0,0 0,0 0,0 0))'), 5)) |
| 204 |
POLYGON((10 0,0 0,4 4,6 -6,10 0)) |
| 205 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'), 3.5)); |
| 206 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'), 3.5)) |
| 207 |
POLYGON((5 5,0 5,0 0,5 0,5 5)) |
| 208 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'), 3.6)); |
| 209 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'), 3.6)) |
| 210 |
NULL |
| 211 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,-10 10,0 0))'), 14)); |
| 212 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,-10 10,0 0))'), 14)) |
| 213 |
NULL |
| 214 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,-10 10,0 0))'), 15)); |
| 215 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,-10 10,0 0))'), 15)) |
| 216 |
NULL |
| 217 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,0 10,-5 5,0 0))'), 4.9)); |
| 218 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,0 10,-5 5,0 0))'), 4.9)) |
| 219 |
POLYGON((0 10,-5 5,0 0,5 5,0 10)) |
| 220 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,0 10,-5 5,0 0))'), 5)); |
| 221 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,0 10,-5 5,0 0))'), 5)) |
| 222 |
NULL |
| 223 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0))'), 1)); |
| 224 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0))'), 1)) |
| 225 |
POLYGON((10 10,0 0,1 1,3 -3,5 5,7 -7,10 10)) |
| 226 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 4.9)); |
| 227 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 4.9)) |
| 228 |
POLYGON((-10 10,-5 0,-10 -10,10 -10,5 0,10 10,-10 10)) |
| 229 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 5)); |
| 230 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 5)) |
| 231 |
POLYGON((-10 10,-10 -10,10 -10,10 10,-10 10)) |
| 232 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 12)); |
| 233 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 12)) |
| 234 |
POLYGON((-10 10,-10 -10,10 -10,10 10,-10 10)) |
| 235 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 17)); |
| 236 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((5 0,10 10,-10 10,-5 0,-10 -10,10 -10,5 0))'), 17)) |
| 237 |
NULL |
| 238 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 1.4)); |
| 239 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 1.4)) |
| 240 |
POLYGON((10 10,0 10,0 0,10 0,10 10),(6 6,6 4,4 4,4 6,6 6)) |
| 241 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 1.5)); |
| 242 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 1.5)) |
| 243 |
POLYGON((10 10,0 10,0 0,10 0,10 10)) |
| 244 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 7)); |
| 245 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 7)) |
| 246 |
POLYGON((10 10,0 10,0 0,10 0,10 10)) |
| 247 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 7.1)); |
| 248 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 7.1)) |
| 249 |
NULL |
| 250 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 3)); |
| 251 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 3)) |
| 252 |
POLYGON((-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2)) |
| 253 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 4)); |
| 254 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 4)) |
| 255 |
POLYGON((-10 -2,-5 -2,-5 -10,5 -10,10 2,5 2,5 10,-5 10,-10 -2)) |
| 256 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 5)); |
| 257 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 5)) |
| 258 |
POLYGON((-10 -2,5 -10,10 2,-5 10,-10 -2)) |
| 259 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 11)); |
| 260 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((10 2,5 2,5 10,-5 10,-5 2,-10 2,-10 -2,-5 -2,-5 -10,5 -10,5 -2,10 -2,10 2))'), 11)) |
| 261 |
NULL |
| 262 |
##################################################################################### |
| 263 |
# ST_SIMPLIFY(multipolygon) |
| 264 |
##################################################################################### |
| 265 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))'), 3.5)); |
| 266 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))'), 3.5)) |
| 267 |
MULTIPOLYGON(((5 5,0 5,0 0,5 0,5 5))) |
| 268 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))'), 3.6)); |
| 269 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))'), 3.6)) |
| 270 |
NULL |
| 271 |
# Invalid geometry in input. |
| 272 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0)))'), 1)); |
| 273 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0)))'), 1)) |
| 274 |
MULTIPOLYGON(((10 10,0 0,1 1,3 -3,5 5,7 -7,10 10))) |
| 275 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 1.4)); |
| 276 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 1.4)) |
| 277 |
MULTIPOLYGON(((10 10,0 10,0 0,10 0,10 10),(6 6,6 4,4 4,4 6,6 6))) |
| 278 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 1.5)); |
| 279 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 1.5)) |
| 280 |
MULTIPOLYGON(((10 10,0 10,0 0,10 0,10 10))) |
| 281 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 7)); |
| 282 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 7)) |
| 283 |
MULTIPOLYGON(((10 10,0 10,0 0,10 0,10 10))) |
| 284 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 7.1)); |
| 285 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'), 7.1)) |
| 286 |
NULL |
| 287 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 1.4)); |
| 288 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 1.4)) |
| 289 |
MULTIPOLYGON(((10 10,0 10,0 0,10 0,10 10)),((6 6,4 6,4 4,6 4,6 6))) |
| 290 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 1.5)); |
| 291 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 1.5)) |
| 292 |
MULTIPOLYGON(((10 10,0 10,0 0,10 0,10 10))) |
| 293 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 7)); |
| 294 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 7)) |
| 295 |
MULTIPOLYGON(((10 10,0 10,0 0,10 0,10 10))) |
| 296 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 7.1)); |
| 297 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4,4 4,4 4)))'), 7.1)) |
| 298 |
NULL |
| 299 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((0 0,0 -5,-5 -5,-5 0,0 0)))'), 3.5)); |
| 300 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((0 0,0 -5,-5 -5,-5 0,0 0)))'), 3.5)) |
| 301 |
MULTIPOLYGON(((5 5,0 5,0 0,5 0,5 5)),((-5 -5,0 -5,0 0,-5 0,-5 -5))) |
| 302 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((0 0,0 -5,-5 -5,-5 0,0 0)))'), 3.6)); |
| 303 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((0 0,0 -5,-5 -5,-5 0,0 0)))'), 3.6)) |
| 304 |
NULL |
| 305 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))'), 14)); |
| 306 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))'), 14)) |
| 307 |
NULL |
| 308 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))'), 15)); |
| 309 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))'), 15)) |
| 310 |
NULL |
| 311 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,0 10,-5 5,0 0)),((0 0,-5 -5,0 -10,5 -5,0 0)))'), 4.9)); |
| 312 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,0 10,-5 5,0 0)),((0 0,-5 -5,0 -10,5 -5,0 0)))'), 4.9)) |
| 313 |
MULTIPOLYGON(((0 10,-5 5,0 0,5 5,0 10)),((0 -10,5 -5,0 0,-5 -5,0 -10))) |
| 314 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,0 10,-5 5,0 0)),((0 0,-5 -5,0 -10,5 -5,0 0)))'), 5)); |
| 315 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,0 10,-5 5,0 0)),((0 0,-5 -5,0 -10,5 -5,0 0)))'), 5)) |
| 316 |
NULL |
| 317 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,4 6,0 10,-4 6,0 0)),((0 0,-6 4,-10 0,-6 -4,0 0)),' |
| 318 |
'((0 0,-4 -6,0 -10,4 -6,0 0)),((0 0,6 -4,10 0,6 4,0 0)))'), 3)); |
| 319 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,4 6,0 10,-4 6,0 0)),((0 0,-6 4,-10 0,-6 -4,0 0)),' |
| 320 |
'((0 0,-4 -6,0 -10,4 -6,0 0)),((0 0,6 -4,10 0,6 4,0 0)))'), 3)) |
| 321 |
MULTIPOLYGON(((0 10,-4 6,0 0,4 6,0 10)),((-10 0,-6 -4,0 0,-6 4,-10 0)),((0 -10,4 -6,0 0,-4 -6,0 -10)),((10 0,6 4,0 0,6 -4,10 0))) |
| 322 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,4 6,0 10,-4 6,0 0)),((0 0,-6 4,-10 0,-6 -4,0 0)),' |
| 323 |
'((0 0,-4 -6,0 -10,4 -6,0 0)),((0 0,6 -4,10 0,6 4,0 0)))'), 4)); |
| 324 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,4 6,0 10,-4 6,0 0)),((0 0,-6 4,-10 0,-6 -4,0 0)),' |
| 325 |
'((0 0,-4 -6,0 -10,4 -6,0 0)),((0 0,6 -4,10 0,6 4,0 0)))'), 4)) |
| 326 |
MULTIPOLYGON(((4 6,-4 6,0 0,4 6)),((-6 4,-6 -4,0 0,-6 4)),((-4 -6,4 -6,0 0,-4 -6)),((6 -4,6 4,0 0,6 -4))) |
| 327 |
##################################################################################### |
| 328 |
# ST_SIMPLIFY(geometrycollection) |
| 329 |
##################################################################################### |
| 330 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'), 1)); |
| 331 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'), 1)) |
| 332 |
GEOMETRYCOLLECTION(POINT(0 0)) |
| 333 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,1 0,1 1,2 0,2 2))'), 1)); |
| 334 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,1 0,1 1,2 0,2 2))'), 1)) |
| 335 |
GEOMETRYCOLLECTION(MULTIPOINT((0 0),(1 0),(1 1),(2 0),(2 2))) |
| 336 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 0,5 5,0 5,0 0))'), 3.5)); |
| 337 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 0,5 5,0 5,0 0))'), 3.5)) |
| 338 |
GEOMETRYCOLLECTION(LINESTRING(0 0,5 0,5 5,0 5,0 0)) |
| 339 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 0,5 5,0 5,0 0))'), 3.6)); |
| 340 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,5 0,5 5,0 5,0 0))'), 3.6)) |
| 341 |
GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,0 0)) |
| 342 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,4 4,6 -6,10 0))'), 5)); |
| 343 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,4 4,6 -6,10 0))'), 5)) |
| 344 |
GEOMETRYCOLLECTION(LINESTRING(0 0,4 4,6 -6,10 0)) |
| 345 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,0 4,4 4),(0 0,5 0,5 5,0 5,0 0)))'), 3.5)); |
| 346 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,0 4,4 4),(0 0,5 0,5 5,0 5,0 0)))'), 3.5)) |
| 347 |
GEOMETRYCOLLECTION(MULTILINESTRING((0 0,4 4),(0 0,5 0,5 5,0 5,0 0))) |
| 348 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,0 5,5 5),(0 0,5 0,5 5,0 5,0 0)))'), 3.6)); |
| 349 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,0 5,5 5),(0 0,5 0,5 5,0 5,0 0)))'), 3.6)) |
| 350 |
GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 5),(0 0,5 5,0 0))) |
| 351 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0)))'), 1)); |
| 352 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,1 1,3 -3,5 5,7 -7,9 9,10 10,0 0)))'), 1)) |
| 353 |
GEOMETRYCOLLECTION(MULTILINESTRING((0 0,1 1,3 -3,5 5,7 -7,10 10,0 0))) |
| 354 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 7)); |
| 355 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 7)) |
| 356 |
GEOMETRYCOLLECTION(POLYGON((10 10,0 10,0 0,10 0,10 10))) |
| 357 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 8)); |
| 358 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 8)) |
| 359 |
NULL |
| 360 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((0 0,0 -8,-8 -8,-8 0,0 0))))'), 7)); |
| 361 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((0 0,0 -8,-8 -8,-8 0,0 0))))'), 7)) |
| 362 |
GEOMETRYCOLLECTION(MULTIPOLYGON(((10 10,0 10,0 0,10 0,10 10)))) |
| 363 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((0 0,0 -8,-8 -8,-8 0,0 0))))'), 8)); |
| 364 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)),((0 0,0 -8,-8 -8,-8 0,0 0))))'), 8)) |
| 365 |
NULL |
| 366 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 1)); |
| 367 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'), 1)) |
| 368 |
NULL |
| 369 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'), 1)); |
| 370 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'), 1)) |
| 371 |
NULL |
| 372 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), LINESTRING(0 0,5 0,5 5))'), 3.5)); |
| 373 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), LINESTRING(0 0,5 0,5 5))'), 3.5)) |
| 374 |
GEOMETRYCOLLECTION(LINESTRING(0 0,5 0,5 5)) |
| 375 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), LINESTRING(0 0,5 0,5 5))'), 3.6)); |
| 376 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), LINESTRING(0 0,5 0,5 5))'), 3.6)) |
| 377 |
GEOMETRYCOLLECTION(LINESTRING(0 0,5 5)) |
| 378 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 7)); |
| 379 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 7)) |
| 380 |
GEOMETRYCOLLECTION(POLYGON((10 10,0 10,0 0,10 0,10 10))) |
| 381 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 8)); |
| 382 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(), POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0)))'), 8)) |
| 383 |
NULL |
| 384 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 385 |
'POINT(0 0),' |
| 386 |
'LINESTRING(0 0,0 5,5 5,5 0,0 0),' |
| 387 |
'POLYGON((0 0,0 -5,-5 -5,-5 0,0 0)))'), 3.5)); |
| 388 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 389 |
'POINT(0 0),' |
| 390 |
'LINESTRING(0 0,0 5,5 5,5 0,0 0),' |
| 391 |
|
| 392 |
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,0 5,5 5,5 0,0 0),POLYGON((-5 -5,0 -5,0 0,-5 0,-5 -5))) |
| 393 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 394 |
'POINT(0 0),' |
| 395 |
'LINESTRING(0 0,0 5,5 5,5 0,0 0),' |
| 396 |
'POLYGON((0 0,0 -5,-5 -5,-5 0,0 0)))'), 3.6)); |
| 397 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 398 |
'POINT(0 0),' |
| 399 |
'LINESTRING(0 0,0 5,5 5,5 0,0 0),' |
| 400 |
|
| 401 |
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,5 5,0 0)) |
| 402 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 403 |
'LINESTRING(0 0,5 5,0 10,-5 5,0 0),' |
| 404 |
'POLYGON((0 0,-5 -5,0 -10,5 -5,0 0)))'), 4.9)); |
| 405 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 406 |
'LINESTRING(0 0,5 5,0 10,-5 5,0 0),' |
| 407 |
'POLYGON((0 0,-5 -5,0 -10,5 -5,0 0)))'), 4.9)) |
| 408 |
GEOMETRYCOLLECTION(LINESTRING(0 0,5 5,0 10,-5 5,0 0),POLYGON((0 -10,5 -5,0 0,-5 -5,0 -10))) |
| 409 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 410 |
'LINESTRING(0 0,5 5,0 10,-5 5,0 0),' |
| 411 |
'POLYGON((0 0,-5 -5,0 -10,5 -5,0 0)))'), 5)); |
| 412 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 413 |
'LINESTRING(0 0,5 5,0 10,-5 5,0 0),' |
| 414 |
'POLYGON((0 0,-5 -5,0 -10,5 -5,0 0)))'), 5)) |
| 415 |
GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,0 0)) |
| 416 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 417 |
'MULTILINESTRING((0 0,5 5,0 10,-5 5,0 0),(0 0,-5 -5,0 -10,5 -5,0 0)),' |
| 418 |
'MULTIPOLYGON(((0 0,5 -5,10 0,5 5,0 0)),((0 0,-5 5,-10 0,-5 -5,0 0))))'), 4.9)); |
| 419 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 420 |
'MULTILINESTRING((0 0,5 5,0 10,-5 5,0 0),(0 0,-5 -5,0 -10,5 -5,0 0)),' |
| 421 |
'MULTIPOLYGON(((0 0,5 |
| 422 |
GEOMETRYCOLLECTION(MULTILINESTRING((0 0,5 5,0 10,-5 5,0 0),(0 0,-5 -5,0 -10,5 -5,0 0)),MULTIPOLYGON(((10 0,5 5,0 0,5 -5,10 0)),((-10 0,-5 -5,0 0,-5 5,-10 0)))) |
| 423 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 424 |
'MULTILINESTRING((0 0,5 5,0 10,-5 5,0 0),(0 0,-5 -5,0 -10,5 -5,0 0)),' |
| 425 |
'MULTIPOLYGON(((0 0,5 -5,10 0,5 5,0 0)),((0 0,-5 5,-10 0,-5 -5,0 0))))'), 5)); |
| 426 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 427 |
'MULTILINESTRING((0 0,5 5,0 10,-5 5,0 0),(0 0,-5 -5,0 -10,5 -5,0 0)),' |
| 428 |
'MULTIPOLYGON(((0 0,5 |
| 429 |
GEOMETRYCOLLECTION(MULTILINESTRING((0 0,0 10,0 0),(0 0,0 -10,0 0))) |
| 430 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 431 |
'POINT(10 10),' |
| 432 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 433 |
'LINESTRING(0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0))'), 1)); |
| 434 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 435 |
'POINT(10 10),' |
| 436 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 437 |
|
| 438 |
GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),LINESTRING(0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -4,5 -4,0 0)) |
| 439 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 440 |
'POINT(10 10),' |
| 441 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 442 |
'LINESTRING(0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0))'), 2)); |
| 443 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 444 |
'POINT(10 10),' |
| 445 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 446 |
|
| 447 |
GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),LINESTRING(0 0,5 0,0 -1,5 -1,0 -4,5 -4,0 0)) |
| 448 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 449 |
'POINT(10 10),' |
| 450 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 451 |
'LINESTRING(0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0))'), 3)); |
| 452 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 453 |
'POINT(10 10),' |
| 454 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 455 |
|
| 456 |
GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),LINESTRING(0 0,5 0,0 -1,5 -4,0 0)) |
| 457 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 458 |
'POINT(10 10),' |
| 459 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 460 |
'LINESTRING(0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0))'), 4)); |
| 461 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 462 |
'POINT(10 10),' |
| 463 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 464 |
|
| 465 |
GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),LINESTRING(0 0,5 -4,0 0)) |
| 466 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 467 |
'POINT(10 10),' |
| 468 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 469 |
'LINESTRING(0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0))'), 7)); |
| 470 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 471 |
'POINT(10 10),' |
| 472 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 473 |
|
| 474 |
GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5))) |
| 475 |
# Invalid geometry in input. |
| 476 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 477 |
'POINT(0 0),' |
| 478 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 479 |
'POLYGON((0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0)),' |
| 480 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 481 |
'MULTILINESTRING((0 0,1 1,-1 1,0 0),(0 0,2 2,-2 2,0 0),(0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0)),' |
| 482 |
'MULTIPOLYGON(((0 0,2.5 2.5,-2.5 2.5,0 0)),((0 0,-2.5 -2.5,2.5 -2.5,0 0))))'), 1)); |
| 483 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 484 |
'POINT(0 0),' |
| 485 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 486 |
|
| 487 |
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,2.5 2.5,-2.5 7.5,0 10),POLYGON((5 -4,0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -4,5 -4)),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),MULTILINESTRING((0 0,1 1,-1 1,0 0),(0 0,2 2,-2 2,0 0),(0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0)),MULTIPOLYGON(((2.5 2.5,-2.5 2.5,0 0,2.5 2.5)),((-2.5 -2.5,2.5 -2.5,0 0,-2.5 -2.5)))) |
| 488 |
# Invalid geometry in input. |
| 489 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 490 |
'POINT(0 0),' |
| 491 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 492 |
'POLYGON((0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0)),' |
| 493 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 494 |
'MULTILINESTRING((0 0,1 1,-1 1,0 0),(0 0,2 2,-2 2,0 0),(0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0)),' |
| 495 |
'MULTIPOLYGON(((0 0,2.5 2.5,-2.5 2.5,0 0)),((0 0,-2.5 -2.5,2.5 -2.5,0 0))))'), 2)); |
| 496 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 497 |
'POINT(0 0),' |
| 498 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 499 |
|
| 500 |
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,2.5 2.5,-2.5 7.5,0 10),POLYGON((5 -4,0 0,5 0,0 -1,5 -1,0 -4,5 -4)),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),MULTILINESTRING((0 0,2 2,-2 2,0 0),(0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0)),MULTIPOLYGON(((2.5 2.5,-2.5 2.5,0 0,2.5 2.5)),((-2.5 -2.5,2.5 -2.5,0 0,-2.5 -2.5)))) |
| 501 |
# Invalid geometry in input. |
| 502 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 503 |
'POINT(0 0),' |
| 504 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 505 |
'POLYGON((0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0)),' |
| 506 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 507 |
'MULTILINESTRING((0 0,1 1,-1 1,0 0),(0 0,2 2,-2 2,0 0),(0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0)),' |
| 508 |
'MULTIPOLYGON(((0 0,2.5 2.5,-2.5 2.5,0 0)),((0 0,-2.5 -2.5,2.5 -2.5,0 0))))'), 3)); |
| 509 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 510 |
'POINT(0 0),' |
| 511 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 512 |
|
| 513 |
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,0 10),POLYGON((5 -4,0 0,5 0,0 -1,5 -4)),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),MULTILINESTRING((0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0))) |
| 514 |
# Invalid geometry in input. |
| 515 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 516 |
'POINT(0 0),' |
| 517 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 518 |
'POLYGON((0 0,5 0,0 -1,5 -1,0 -2,5 -2,0 -3,5 -3,0 -4,5 -4,0 0)),' |
| 519 |
'MULTIPOINT(0 0,1 1,2 2,3 3,4 4,5 5),' |
| 520 |
'MULTILINESTRING((0 0,1 1,-1 1,0 0),(0 0,2 2,-2 2,0 0),(0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0)),' |
| 521 |
'MULTIPOLYGON(((0 0,2.5 2.5,-2.5 2.5,0 0)),((0 0,-2.5 -2.5,2.5 -2.5,0 0))))'), 4)); |
| 522 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(' |
| 523 |
'POINT(0 0),' |
| 524 |
'LINESTRING(0 0,2.5 2.5,0 5,-2.5 7.5,0 10),' |
| 525 |
|
| 526 |
GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,0 10),MULTIPOINT((0 0),(1 1),(2 2),(3 3),(4 4),(5 5)),MULTILINESTRING((0 0,3 3,-3 3,0 0),(0 0,4 4,-4 4,0 0))) |
| 527 |
##################################################################################### |
| 528 |
# ST_ASTEXT(ST_SIMPLIFY(geometry) with different SRID values |
| 529 |
##################################################################################### |
| 530 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT(@star_center,-1024), 1)); |
| 531 |
ERROR 22003: SRID value is out of range in 'st_geomfromtext' |
| 532 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT(@star_all_points,-1), 1)); |
| 533 |
ERROR 22003: SRID value is out of range in 'st_geomfromtext' |
| 534 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT(@star_top_to_center,0), 1)); |
| 535 |
ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT(@star_top_to_center,0), 1)) |
| 536 |
LINESTRING(15 25,15 10) |
| 537 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT(@star_lines_near_vertical,4326), 1)); |
| 538 |
ERROR 22S00: st_simplify(MULTILINESTRING, ...) has not been implemented for geographic spatial reference systems. |
| 539 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT(@star_of_elems,4294967296), 1)); |
| 540 |
ERROR 22003: SRID value is out of range in 'st_geomfromtext' |
| 541 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT(@star_collection_elems,4294967295000), 1)); |
| 542 |
ERROR 22003: SRID value is out of range in 'st_geomfromtext' |
| 543 |
##################################################################################### |
| 544 |
# Invalid function calls |
| 545 |
##################################################################################### |
| 546 |
SELECT ST_ASTEXT(ST_SIMPLIFY()); |
| 547 |
ERROR 42000: Incorrect parameter count in the call to native function 'ST_SIMPLIFY' |
| 548 |
SELECT ST_ASTEXT(ST_SIMPLIFY(NULL)); |
| 549 |
ERROR 42000: Incorrect parameter count in the call to native function 'ST_SIMPLIFY' |
| 550 |
SELECT ST_ASTEXT(ST_SIMPLIFY(NULL,1)); |
| 551 |
ST_ASTEXT(ST_SIMPLIFY(NULL,1)) |
| 552 |
NULL |
| 553 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT()'), 1)); |
| 554 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 555 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING()'), 1)); |
| 556 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 557 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON(())'), 1)); |
| 558 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 559 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOINT()'), 1)); |
| 560 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 561 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTILINESTRING(())'), 1)); |
| 562 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 563 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('MULTIPOLYGON((()))'), 1)); |
| 564 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 565 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(a 0)'), 1)); |
| 566 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 567 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(! 0)'), 1)); |
| 568 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 569 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT('!' 0)'), 1)); |
| 570 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!' 0)'), 1))' at line 1 |
| 571 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(12,34 0)'), 1)); |
| 572 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 573 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'), 1)); |
| 574 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 575 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'), 1)); |
| 576 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 577 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'), 1)); |
| 578 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!' 0,10 10)'), 1))' at line 1 |
| 579 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'), 1)); |
| 580 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 581 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'), 1)); |
| 582 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 583 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'), 1)); |
| 584 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 585 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'), 1)); |
| 586 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!' 0,10 10,10 0,0 0))'), 1))' at line 1 |
| 587 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'), 1)); |
| 588 |
ERROR 22023: Invalid GIS data provided to function st_geomfromtext. |
| 589 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0))'), 0)); |
| 590 |
ERROR HY000: Incorrect arguments to st_simplify |
| 591 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0))'), -1)); |
| 592 |
ERROR HY000: Incorrect arguments to st_simplify |
| 593 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0))'), -1024)); |
| 594 |
ERROR HY000: Incorrect arguments to st_simplify |
| 595 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0))'), 'a')); |
| 596 |
ERROR HY000: Incorrect arguments to st_simplify |
| 597 |
SELECT ST_ASTEXT(ST_SIMPLIFY(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,0 0,0 0))'), a)); |
| 598 |
ERROR 42S22: Unknown column 'a' in 'field list' |
| 599 |
SELECT ST_ASTEXT(ST_SIMPLIFY(0x000000000200000000000000000000000000000000, 1)); |
| 600 |
ERROR 22023: Invalid GIS data provided to function st_simplify. |
| 601 |
SELECT ST_ASTEXT(ST_SIMPLIFY(0x010100000001000000010100000000000000000000, 1)); |
| 602 |
ERROR SR001: There's no spatial reference system with SRID 257. |
| 603 |
SELECT ST_ASTEXT(ST_SIMPLIFY(0x010100000002000000000000000000000000000000, 1)); |
| 604 |
ERROR SR001: There's no spatial reference system with SRID 257. |
| 605 |
SELECT ST_ASTEXT(ST_SIMPLIFY(0x000000000600000001000000000200000002000000, 1)); |
| 606 |
ERROR 22023: Invalid GIS data provided to function st_simplify. |
| 607 |
SELECT ST_ASTEXT(ST_SIMPLIFY(0x000000000200000001000000050000000000000000, 1)); |
| 608 |
ERROR 22023: Invalid GIS data provided to function st_simplify. |
| 609 |
SELECT ST_ASTEXT(ST_SIMPLIFY(0x010300000002000000010300000002000000050000, 1)); |
| 610 |
ERROR SR001: There's no spatial reference system with SRID 769. |
| 611 |
SELECT ST_ASTEXT(ST_SIMPLIFY(0x010400000002000000010100000000000000000000, 1)); |
| 612 |
ERROR SR001: There's no spatial reference system with SRID 1025. |
| 613 |
# Clean up |
| 614 |
DROP TABLE gis_geometrycollection; |
| 615 |
# |
| 616 |
# WL#8579 Spatial Reference Systems |
| 617 |
# |
| 618 |
# SRID 0 (should pass) |
| 619 |
DO ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(0 0)', 0), 1); |
| 620 |
# Projected SRS (should pass) |
| 621 |
DO ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(0 0)', 2000), 1); |
| 622 |
# Geographic SRS (should fail) |
| 623 |
DO ST_SIMPLIFY(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1); |
| 624 |
ERROR 22S00: st_simplify(POINT, ...) has not been implemented for geographic spatial reference systems. |
| 625 |
# |
| 626 |
# WL#11096 Don't do Cartesian computations on geographic geometries |
| 627 |
# |
| 628 |
# Assume SRID 10 is not defined. |
| 629 |
DO ST_SIMPLIFY(x'0A000000010100000000000000000000000000000000000000', 1); |
| 630 |
ERROR SR001: There's no spatial reference system with SRID 10. |