1724 lines
105 KiB
Plaintext
1724 lines
105 KiB
Plaintext
# Creating the spatial objects
|
|
USE test;
|
|
CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
|
|
CREATE TABLE gis_linestring (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING);
|
|
CREATE TABLE gis_polygon (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON);
|
|
CREATE TABLE gis_multi_point (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT);
|
|
CREATE TABLE gis_multi_linestring (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING);
|
|
CREATE TABLE gis_multi_polygon (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON);
|
|
CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION);
|
|
# Inserting POINT Geometry Values
|
|
INSERT INTO gis_point VALUES
|
|
(101, ST_POINTFROMTEXT('POINT(0 0)')),
|
|
(102, ST_POINTFROMTEXT('POINT(1 0)')),
|
|
(103, ST_POINTFROMTEXT('POINT(0 1)')),
|
|
(104, ST_POINTFROMTEXT('POINT(1 1)')),
|
|
(105, ST_POINTFROMTEXT('POINT(-1 1)'));
|
|
INSERT INTO gis_point VALUES
|
|
(106, ST_POINTFROMWKB(ST_ASWKB(POINT(0,0)))),
|
|
(107, ST_POINTFROMWKB(ST_ASWKB(POINT(10,0)))),
|
|
(108, ST_POINTFROMWKB(ST_ASWKB(POINT(0,10)))),
|
|
(109, ST_POINTFROMWKB(ST_ASWKB(POINT(-10,0)))),
|
|
(110, ST_POINTFROMWKB(ST_ASWKB(POINT(0,-10))));
|
|
INSERT INTO gis_point VALUES
|
|
(111, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1 1)')))),
|
|
(112, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 1e308)')))),
|
|
(113, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 -1e308)')))),
|
|
(114, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 1e308)')))),
|
|
(115, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 -1e308)'))));
|
|
# Displaying the inserted POINT Geometry Data
|
|
SELECT fid, ST_ASTEXT(g) FROM gis_point;
|
|
fid ST_ASTEXT(g)
|
|
101 POINT(0 0)
|
|
102 POINT(1 0)
|
|
103 POINT(0 1)
|
|
104 POINT(1 1)
|
|
105 POINT(-1 1)
|
|
106 POINT(0 0)
|
|
107 POINT(10 0)
|
|
108 POINT(0 10)
|
|
109 POINT(-10 0)
|
|
110 POINT(0 -10)
|
|
111 POINT(1 1)
|
|
112 POINT(1e308 1e308)
|
|
113 POINT(1e308 -1e308)
|
|
114 POINT(-1e308 1e308)
|
|
115 POINT(-1e308 -1e308)
|
|
# Checking the integrity of the above insert statements
|
|
SELECT COUNT(g) FROM gis_point;
|
|
COUNT(g)
|
|
15
|
|
SELECT COUNT(ST_ASTEXT(g)) FROM gis_point;
|
|
COUNT(ST_ASTEXT(g))
|
|
15
|
|
SELECT COUNT(DISTINCT(g)) FROM gis_point;
|
|
COUNT(DISTINCT(g))
|
|
13
|
|
SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_point;
|
|
COUNT(DISTINCT(ST_ASTEXT(g)))
|
|
13
|
|
# Inserting LINESTRING Geometry Values
|
|
INSERT INTO gis_linestring VALUES
|
|
(201, ST_LINEFROMTEXT('LINESTRING(0 0,5 5)')),
|
|
(202, ST_LINEFROMTEXT('LINESTRING(0 0,2 2,4 4)')),
|
|
(203, ST_LINEFROMTEXT('LINESTRING(0 0,5 5,10 10)'));
|
|
INSERT INTO gis_linestring VALUES
|
|
(204, ST_LINESTRINGFROMTEXT('LINESTRING(10 10,5 5)')),
|
|
(205, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,12 12,24 24)')),
|
|
(206, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,50 50,100 100)'));
|
|
INSERT INTO gis_linestring VALUES
|
|
(207, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
|
|
(208, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,10))))),
|
|
(209, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)))));
|
|
INSERT INTO gis_linestring VALUES
|
|
(210, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
|
|
(211, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-50,-50), POINT(10,-10))))),
|
|
(212, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(1e308,1e308), POINT(1e308,-1e308)))));
|
|
INSERT INTO gis_linestring VALUES
|
|
(213, ST_LINEFROMWKB(ST_ASWKB(ST_LINEFROMTEXT('LINESTRING(1e308 1e308,1e308 -1e308)')))),
|
|
(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)')))),
|
|
(215, ST_LINESTRINGFROMWKB(ST_ASWKB(ST_LINESTRINGFROMTEXT('LINESTRING(10 10,10 -10,-10 -10,-10 10,10 10)'))));
|
|
# Displaying the inserted LINESTRING Geometry Data
|
|
SELECT fid, ST_ASTEXT(g) FROM gis_linestring;
|
|
fid ST_ASTEXT(g)
|
|
201 LINESTRING(0 0,5 5)
|
|
202 LINESTRING(0 0,2 2,4 4)
|
|
203 LINESTRING(0 0,5 5,10 10)
|
|
204 LINESTRING(10 10,5 5)
|
|
205 LINESTRING(0 0,12 12,24 24)
|
|
206 LINESTRING(0 0,50 50,100 100)
|
|
207 LINESTRING(0 0,5 5)
|
|
208 LINESTRING(0 0,-5 -5,-10 10)
|
|
209 LINESTRING(0 0,2 2,4 4,6 6,8 8)
|
|
210 LINESTRING(0 0,5 5)
|
|
211 LINESTRING(0 0,-50 -50,10 -10)
|
|
212 LINESTRING(0 0,1e308 1e308,1e308 -1e308)
|
|
213 LINESTRING(1e308 1e308,1e308 -1e308)
|
|
214 LINESTRING(1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)
|
|
215 LINESTRING(10 10,10 -10,-10 -10,-10 10,10 10)
|
|
# Checking the integrity of the above insert statements
|
|
SELECT COUNT(g) FROM gis_linestring;
|
|
COUNT(g)
|
|
15
|
|
SELECT COUNT(ST_ASTEXT(g)) FROM gis_linestring;
|
|
COUNT(ST_ASTEXT(g))
|
|
15
|
|
SELECT COUNT(DISTINCT(g)) FROM gis_linestring;
|
|
COUNT(DISTINCT(g))
|
|
13
|
|
SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_linestring;
|
|
COUNT(DISTINCT(ST_ASTEXT(g)))
|
|
13
|
|
# Inserting POLYGON Geometry Values
|
|
INSERT INTO gis_polygon VALUES
|
|
(301, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5, 0 0))')),
|
|
(302, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')),
|
|
(303, ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
|
|
INSERT INTO gis_polygon VALUES
|
|
(304, ST_POLYGONFROMTEXT('POLYGON((0 0,0 50,50 50,50 0,0 0))')),
|
|
(305, ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')),
|
|
(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))'));
|
|
INSERT INTO gis_polygon VALUES
|
|
(307, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
|
|
(308, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)))))),
|
|
(309, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
|
|
INSERT INTO gis_polygon VALUES
|
|
(310, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
|
|
(311, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,15), POINT(15,15), POINT(15,10), POINT(10,10)))))),
|
|
(312, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,20), POINT(20,20), POINT(20,10), POINT(10,10)),
|
|
LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))));
|
|
INSERT INTO gis_polygon VALUES
|
|
(313, ST_POLYFROMWKB(ST_ASWKB(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,5 5,0 0))')))),
|
|
(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))')))),
|
|
(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))'))));
|
|
# Displaying the inserted POLYGON Geometry Data
|
|
SELECT fid, ST_ASTEXT(g) FROM gis_polygon;
|
|
fid ST_ASTEXT(g)
|
|
301 POLYGON((0 0,0 5,5 5,0 0))
|
|
302 POLYGON((0 0,0 5,5 5,5 0,0 0))
|
|
303 POLYGON((0 0,0 10,10 10,10 0,0 0))
|
|
304 POLYGON((0 0,0 50,50 50,50 0,0 0))
|
|
305 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))
|
|
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))
|
|
307 POLYGON((0 0,0 5,5 5,0 0))
|
|
308 POLYGON((0 0,0 15,15 15,15 0,0 0))
|
|
309 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))
|
|
310 POLYGON((0 0,0 5,5 5,0 0))
|
|
311 POLYGON((10 10,10 15,15 15,15 10,10 10))
|
|
312 POLYGON((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14))
|
|
313 POLYGON((0 0,0 10,10 10,10 0,5 5,0 0))
|
|
314 POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0))
|
|
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))
|
|
# Checking the integrity of the above insert statements
|
|
SELECT COUNT(g) FROM gis_polygon;
|
|
COUNT(g)
|
|
15
|
|
SELECT COUNT(ST_ASTEXT(g)) FROM gis_polygon;
|
|
COUNT(ST_ASTEXT(g))
|
|
15
|
|
SELECT COUNT(DISTINCT(g)) FROM gis_polygon;
|
|
COUNT(DISTINCT(g))
|
|
11
|
|
SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_polygon;
|
|
COUNT(DISTINCT(ST_ASTEXT(g)))
|
|
11
|
|
# Inserting MULTIPOINT Geometry Values
|
|
INSERT INTO gis_multi_point VALUES
|
|
(401, ST_MPOINTFROMTEXT('MULTIPOINT(0 0)')),
|
|
(402, ST_MPOINTFROMTEXT('MULTIPOINT(0 0,2 2,4 4)')),
|
|
(403, ST_MPOINTFROMTEXT('MULTIPOINT(0 0,5 5,10 10)'));
|
|
INSERT INTO gis_multi_point VALUES
|
|
(404, ST_MULTIPOINTFROMTEXT('MULTIPOINT(0 0,100 100)')),
|
|
(405, ST_MULTIPOINTFROMTEXT('MULTIPOINT(0 0,1e308 1e308)')),
|
|
(406, ST_MULTIPOINTFROMTEXT('MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,-1e308 -1e308)'));
|
|
INSERT INTO gis_multi_point VALUES
|
|
(407, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
|
|
(408, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(10,10))))),
|
|
(409, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)))));
|
|
INSERT INTO gis_multi_point VALUES
|
|
(410, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
|
|
(411, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(1e308,1e308))))),
|
|
(412, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308), POINT(-1e308,-1e308)))));
|
|
INSERT INTO gis_multi_point VALUES
|
|
(413, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(0 0)')))),
|
|
(414, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(0 0,1e308 1e308,-1e308 -1e308)')))),
|
|
(415, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,-1e308 -1e308,1e308 1e308)'))));
|
|
# Displaying the inserted MULTIPOINT Geometry Data
|
|
SELECT fid, ST_ASTEXT(g) FROM gis_multi_point;
|
|
fid ST_ASTEXT(g)
|
|
401 MULTIPOINT((0 0))
|
|
402 MULTIPOINT((0 0),(2 2),(4 4))
|
|
403 MULTIPOINT((0 0),(5 5),(10 10))
|
|
404 MULTIPOINT((0 0),(100 100))
|
|
405 MULTIPOINT((0 0),(1e308 1e308))
|
|
406 MULTIPOINT((1e308 1e308),(1e308 -1e308),(-1e308 1e308),(-1e308 -1e308))
|
|
407 MULTIPOINT((0 0))
|
|
408 MULTIPOINT((0 0),(10 10))
|
|
409 MULTIPOINT((0 0),(2 2),(4 4),(6 6))
|
|
410 MULTIPOINT((0 0))
|
|
411 MULTIPOINT((0 0),(1e308 1e308))
|
|
412 MULTIPOINT((1e308 1e308),(-1e308 1e308),(1e308 -1e308),(-1e308 -1e308))
|
|
413 MULTIPOINT((0 0))
|
|
414 MULTIPOINT((0 0),(1e308 1e308),(-1e308 -1e308))
|
|
415 MULTIPOINT((1e308 1e308),(1e308 -1e308),(-1e308 1e308),(-1e308 -1e308),(1e308 1e308))
|
|
# Checking the integrity of the above insert statements
|
|
SELECT COUNT(g) FROM gis_multi_point;
|
|
COUNT(g)
|
|
15
|
|
SELECT COUNT(ST_ASTEXT(g)) FROM gis_multi_point;
|
|
COUNT(ST_ASTEXT(g))
|
|
15
|
|
SELECT COUNT(DISTINCT(g)) FROM gis_multi_point;
|
|
COUNT(DISTINCT(g))
|
|
11
|
|
SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_multi_point;
|
|
COUNT(DISTINCT(ST_ASTEXT(g)))
|
|
11
|
|
# Inserting MULTILINESTRING Geometry Values
|
|
INSERT INTO gis_multi_linestring VALUES
|
|
(501, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2))')),
|
|
(502, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4))')),
|
|
(503, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))'));
|
|
INSERT INTO gis_multi_linestring VALUES
|
|
(504, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,100 100,-100 -100))')),
|
|
(505, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1e308 1e308,-1e308 -1e308))')),
|
|
(506, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1e308 1e308,-1e308 -1e308),(1e308 -1e308,-1e308 1e308))'));
|
|
INSERT INTO gis_multi_linestring VALUES
|
|
(507, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2)))))),
|
|
(508, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)))))),
|
|
(509, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)),
|
|
LINESTRING(POINT(6,6), POINT(8,8), POINT(10,10))))));
|
|
INSERT INTO gis_multi_linestring VALUES
|
|
(510, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)))))),
|
|
(511, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1,1), POINT(2,2)))))),
|
|
(512, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)),
|
|
LINESTRING(POINT(36,36), POINT(48,48), POINT(50,50))))));
|
|
INSERT INTO gis_multi_linestring VALUES
|
|
(513, ST_MLINEFROMWKB(ST_ASWKB(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 10),(0 10,10 0))')))),
|
|
(514, ST_MLINEFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))')))),
|
|
(515, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))'))));
|
|
# Displaying the inserted MULTILINESTRING Geometry Data
|
|
SELECT fid, ST_ASTEXT(g) FROM gis_multi_linestring;
|
|
fid ST_ASTEXT(g)
|
|
501 MULTILINESTRING((0 0,2 2))
|
|
502 MULTILINESTRING((0 0,2 2,4 4))
|
|
503 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
|
|
504 MULTILINESTRING((0 0,100 100,-100 -100))
|
|
505 MULTILINESTRING((1e308 1e308,-1e308 -1e308))
|
|
506 MULTILINESTRING((1e308 1e308,-1e308 -1e308),(1e308 -1e308,-1e308 1e308))
|
|
507 MULTILINESTRING((0 0,2 2))
|
|
508 MULTILINESTRING((0 0,12 12,24 24))
|
|
509 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
|
|
510 MULTILINESTRING((0 0,2 2,4 4))
|
|
511 MULTILINESTRING((0 0,1 1,2 2))
|
|
512 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50))
|
|
513 MULTILINESTRING((0 0,10 10),(0 10,10 0))
|
|
514 MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))
|
|
515 MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))
|
|
# Checking the integrity of the above insert statements
|
|
SELECT COUNT(g) FROM gis_multi_linestring;
|
|
COUNT(g)
|
|
15
|
|
SELECT COUNT(ST_ASTEXT(g)) FROM gis_multi_linestring;
|
|
COUNT(ST_ASTEXT(g))
|
|
15
|
|
SELECT COUNT(DISTINCT(g)) FROM gis_multi_linestring;
|
|
COUNT(DISTINCT(g))
|
|
12
|
|
SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_multi_linestring;
|
|
COUNT(DISTINCT(ST_ASTEXT(g)))
|
|
12
|
|
# Inserting MULTIPOLGYON Geometry Values
|
|
INSERT INTO gis_multi_polygon VALUES
|
|
(601, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))')),
|
|
(602, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))')),
|
|
(603, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
|
|
INSERT INTO gis_multi_polygon VALUES
|
|
(604, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5, 0 0)))')),
|
|
(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)))')),
|
|
(606, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))'));
|
|
INSERT INTO gis_multi_polygon VALUES
|
|
(607, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))))))),
|
|
(608, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
|
|
(609, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
|
|
INSERT INTO gis_multi_polygon VALUES
|
|
(610, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0))))))),
|
|
(611, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(10,10), POINT(20,10), POINT(20,20), POINT(10,20), POINT(10,10)),
|
|
LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))))),
|
|
(612, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
|
|
INSERT INTO gis_multi_polygon VALUES
|
|
(613, ST_MPOLYFROMWKB(ST_ASWKB(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 5,-5 -5,0 0)))')))),
|
|
(614, ST_MPOLYFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))')))),
|
|
(615, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 0,5 -5,0 0)))'))));
|
|
# Displaying the inserted MULTIPOLYGON Geometry Data
|
|
SELECT fid, ST_ASTEXT(g) FROM gis_multi_polygon;
|
|
fid ST_ASTEXT(g)
|
|
601 MULTIPOLYGON(((0 0,0 5,5 5,0 0)))
|
|
602 MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))
|
|
603 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
|
|
604 MULTIPOLYGON(((0 0,0 5,5 5,0 0)))
|
|
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)))
|
|
606 MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))
|
|
607 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)))
|
|
608 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)))
|
|
609 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((0 0,-5 0,-5 -5,0 -5,0 0)))
|
|
610 MULTIPOLYGON(((0 0,-5 0,-5 -5,0 -5,0 0)))
|
|
611 MULTIPOLYGON(((10 10,20 10,20 20,10 20,10 10),(14 14,14 16,16 16,16 14,14 14)))
|
|
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)))
|
|
613 MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 5,-5 -5,0 0)))
|
|
614 MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))
|
|
615 MULTIPOLYGON(((0 0,5 5,10 0,5 -5,0 0)))
|
|
# Checking the integrity of the above insert statements
|
|
SELECT COUNT(g) FROM gis_multi_polygon;
|
|
COUNT(g)
|
|
15
|
|
SELECT COUNT(ST_ASTEXT(g)) FROM gis_multi_polygon;
|
|
COUNT(ST_ASTEXT(g))
|
|
15
|
|
SELECT COUNT(DISTINCT(g)) FROM gis_multi_polygon;
|
|
COUNT(DISTINCT(g))
|
|
14
|
|
SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_multi_polygon;
|
|
COUNT(DISTINCT(ST_ASTEXT(g)))
|
|
14
|
|
# Inserting GEOMETRYCOLLECTION Geometry Values
|
|
INSERT INTO gis_geometrycollection VALUES
|
|
(701, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')),
|
|
(702, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
|
|
(703, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5), POLYGON((0 0,0 10,10 10,10 0,0 0)))'));
|
|
INSERT INTO gis_geometrycollection VALUES
|
|
(704, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
|
|
(705, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
|
|
'LINESTRING(0 0,10 10),'
|
|
'POLYGON((0 0,0 10,10 10,10 0, 0 0)))')),
|
|
(706, ST_GEOMETRYCOLLECTIONFROMTEXT('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))))'));
|
|
INSERT INTO gis_geometrycollection VALUES
|
|
(707, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0))))),
|
|
(708, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
|
|
(709, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
|
|
LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
|
|
INSERT INTO gis_geometrycollection VALUES
|
|
(710, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(100,100)))))),
|
|
(711, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(10,10),
|
|
LINESTRING(POINT(10,10), POINT(12,12), POINT(14,14), POINT(16,16), POINT(18,18)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
|
|
(712, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(10,10), POINT(15,15), POINT(20,20)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
|
|
LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
|
|
INSERT INTO gis_geometrycollection VALUES
|
|
(713, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('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))))')))),
|
|
(714, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('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)))))')))),
|
|
(715, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'GEOMETRYCOLLECTION(),'
|
|
'POINT(0 0),'
|
|
'GEOMETRYCOLLECTION('
|
|
'LINESTRING(0 0,10 10),'
|
|
'GEOMETRYCOLLECTION('
|
|
'GEOMETRYCOLLECTION())),'
|
|
'GEOMETRYCOLLECTION(),'
|
|
'GEOMETRYCOLLECTION('
|
|
'GEOMETRYCOLLECTION()),'
|
|
'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))))'))));
|
|
# Displaying the inserted GEOMETRYCOLLECTION Geometry Data
|
|
SELECT fid, ST_ASTEXT(g) FROM gis_geometrycollection;
|
|
fid ST_ASTEXT(g)
|
|
701 GEOMETRYCOLLECTION(POINT(0 0))
|
|
702 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
|
|
703 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,0 10,10 10,10 0,0 0)))
|
|
704 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
|
|
705 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,0 10,10 10,10 0,0 0)))
|
|
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))))
|
|
707 GEOMETRYCOLLECTION(POINT(0 0))
|
|
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)))
|
|
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))))
|
|
710 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,100 100))
|
|
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)))
|
|
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))))
|
|
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))))
|
|
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)))))
|
|
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))))
|
|
# Checking the integrity of the above insert statements
|
|
SELECT COUNT(g) FROM gis_geometrycollection;
|
|
COUNT(g)
|
|
15
|
|
SELECT COUNT(ST_ASTEXT(g)) FROM gis_geometrycollection;
|
|
COUNT(ST_ASTEXT(g))
|
|
15
|
|
SELECT COUNT(DISTINCT(g)) FROM gis_geometrycollection;
|
|
COUNT(DISTINCT(g))
|
|
13
|
|
SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_geometrycollection;
|
|
COUNT(DISTINCT(ST_ASTEXT(g)))
|
|
13
|
|
#====================================================================================
|
|
# ST_X(point)
|
|
#====================================================================================
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(0 0)'));
|
|
ST_X(ST_POINTFROMTEXT('POINT(0 0)'))
|
|
0
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(10 10)'));
|
|
ST_X(ST_POINTFROMTEXT('POINT(10 10)'))
|
|
10
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
|
|
ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'))
|
|
1e308
|
|
SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))));
|
|
ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))))
|
|
1.1111
|
|
SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))));
|
|
ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))))
|
|
10
|
|
SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))));
|
|
ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))))
|
|
-1e308
|
|
#====================================================================================
|
|
# ST_Y(point)
|
|
#====================================================================================
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(0 0)'));
|
|
ST_Y(ST_POINTFROMTEXT('POINT(0 0)'))
|
|
0
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(10 10)'));
|
|
ST_Y(ST_POINTFROMTEXT('POINT(10 10)'))
|
|
10
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
|
|
ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'))
|
|
1e308
|
|
SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))));
|
|
ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))))
|
|
-1.1111
|
|
SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))));
|
|
ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))))
|
|
10
|
|
SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))));
|
|
ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))))
|
|
-1e308
|
|
#====================================================================================
|
|
# ST_ISCLOSED(linestring)
|
|
#====================================================================================
|
|
SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'));
|
|
ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'))
|
|
0
|
|
SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,2 2,0 0)'));
|
|
ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,2 2,0 0)'))
|
|
1
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0)'));
|
|
ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0)'))
|
|
0
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
|
|
ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'))
|
|
1
|
|
SELECT ST_ISCLOSED(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)))));
|
|
ST_ISCLOSED(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)))))
|
|
0
|
|
SELECT ST_ISCLOSED(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10), POINT(0,0)))));
|
|
ST_ISCLOSED(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10), POINT(0,0)))))
|
|
1
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))));
|
|
ST_ISCLOSED(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))))
|
|
0
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))));
|
|
ST_ISCLOSED(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))))
|
|
1
|
|
#====================================================================================
|
|
# ST_LENGTH(linestring)
|
|
#====================================================================================
|
|
SELECT ST_LENGTH(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'));
|
|
ST_LENGTH(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'))
|
|
2.8284271247461903
|
|
SELECT ST_LENGTH(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
|
|
ST_LENGTH(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'))
|
|
20
|
|
SELECT ST_LENGTH(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))));
|
|
ST_LENGTH(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))))
|
|
28.284271247461902
|
|
SELECT ST_LENGTH(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))));
|
|
ST_LENGTH(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))))
|
|
24.14213562373095
|
|
SELECT ST_LENGTH(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))));
|
|
ST_LENGTH(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))))
|
|
38.2842712474619
|
|
SELECT ST_LENGTH(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))));
|
|
ST_LENGTH(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))))
|
|
48.2842712474619
|
|
# Cartesian SRS
|
|
SELECT ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10, 10 10)', 2000));
|
|
ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10, 10 10)', 2000))
|
|
14.142135623730951
|
|
# Geographic SRS
|
|
# Different result on Windows and Linux, need to use ROUND
|
|
SELECT ROUND(ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10, 10 10)', 4326)),7);
|
|
ROUND(ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10, 10 10)', 4326)),7)
|
|
1565127.2549243
|
|
# Infinite Linestring
|
|
SELECT ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(1e-300 0,1e300 0,1e-300 0,1e300 0,1e-300 0, 1e300 0, 1e-300 0)', 0));
|
|
ERROR 22003: Length value is out of range in 'st_length'
|
|
#====================================================================================
|
|
# ST_NUMPOINTS(linestring)
|
|
#====================================================================================
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'));
|
|
ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'))
|
|
2
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)'));
|
|
ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)'))
|
|
2
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)'));
|
|
ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)'))
|
|
2
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
|
|
ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'))
|
|
5
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))));
|
|
ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))))
|
|
3
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))));
|
|
ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))))
|
|
4
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))));
|
|
ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))))
|
|
4
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))));
|
|
ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))))
|
|
5
|
|
#====================================================================================
|
|
# ST_STARTPOINT(linestring)
|
|
#====================================================================================
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)')));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)')))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)')));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)')))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)')));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)')))
|
|
POINT(1e308 1e308)
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10))))));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10))))))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0))))));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0))))))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10))))));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10))))))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0))))));
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0))))))
|
|
POINT(0 0)
|
|
#====================================================================================
|
|
# ST_ENDPOINT(linestring)
|
|
#====================================================================================
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)')));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)')))
|
|
POINT(2 2)
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)')));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)')))
|
|
POINT(1e308 1e308)
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)')));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)')))
|
|
POINT(-1e308 -1e308)
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10))))));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10))))))
|
|
POINT(-10 -10)
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0))))));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0))))))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10))))));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10))))))
|
|
POINT(0 10)
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0))))));
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0))))))
|
|
POINT(0 0)
|
|
#====================================================================================
|
|
# ST_POINTN(linestring, number)
|
|
#====================================================================================
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'), 1));
|
|
ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'), 1))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)'), 2));
|
|
ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)'), 2))
|
|
POINT(1e308 1e308)
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)'), 2));
|
|
ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)'), 2))
|
|
POINT(-1e308 -1e308)
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 3));
|
|
ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 3))
|
|
POINT(5 5)
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))), 3));
|
|
ST_ASTEXT(ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))), 3))
|
|
POINT(-10 -10)
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))), 4));
|
|
ST_ASTEXT(ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))), 4))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))), 4));
|
|
ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))), 4))
|
|
POINT(0 10)
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))), 4));
|
|
ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))), 4))
|
|
POINT(0 10)
|
|
#====================================================================================
|
|
# ST_NUMINTERIORRINGS(polygon)
|
|
#====================================================================================
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'));
|
|
ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'))
|
|
0
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'));
|
|
ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'))
|
|
1
|
|
SELECT ST_NUMINTERIORRINGS(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))'));
|
|
ST_NUMINTERIORRINGS(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))'))
|
|
2
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))'));
|
|
ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))'))
|
|
0
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0))))));
|
|
ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0))))))
|
|
0
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
|
|
ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))
|
|
1
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
|
|
LINESTRING(POINT(8,8), POINT(8,10), POINT(10,10), POINT(10,8), POINT(8,8))))));
|
|
ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
|
|
LINESTRING(POINT(8,8), POINT(8,10), POINT(10,10), PO
|
|
2
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110))))));
|
|
ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110))))))
|
|
0
|
|
#====================================================================================
|
|
# ST_EXTERIORRING(polygon)
|
|
#====================================================================================
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')));
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')))
|
|
LINESTRING(0 0,0 5,5 5,5 0,0 0)
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')));
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')))
|
|
LINESTRING(0 0,0 10,10 10,10 0,0 0)
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(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))')));
|
|
ST_ASTEXT(ST_EXTERIORRING(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))')))
|
|
LINESTRING(0 0,0 10,10 10,10 0,0 0)
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))')));
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))')))
|
|
LINESTRING(0 0,0 -115,-115 -115,-115 0,0 0)
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))));
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))))
|
|
LINESTRING(0 0,0 5,5 5,0 0)
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)))))));
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)))))))
|
|
LINESTRING(0 0,0 15,15 15,15 0,0 0)
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
|
|
LINESTRING(POINT(8,8), POINT(8,10), POINT(10,10), POINT(10,8), POINT(8,8)))))));
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
|
|
LINESTRING(POINT(8,8), POINT(8,10), POINT(10,1
|
|
LINESTRING(0 0,0 15,15 15,15 0,0 0)
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110)))))));
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110)))))))
|
|
LINESTRING(110 110,110 5,5 5,110 110)
|
|
#====================================================================================
|
|
# ST_INTERIORRINGN(polygon, number)
|
|
#====================================================================================
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'), 1));
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'), 1))
|
|
NULL
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 1));
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 1))
|
|
LINESTRING(4 4,4 6,6 6,6 4,4 4)
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(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))'), 2));
|
|
ST_ASTEXT(ST_INTERIORRINGN(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))'), 2))
|
|
LINESTRING(6 6,6 8,8 8,8 6,6 6)
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))'), 1));
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))'), 1))
|
|
NULL
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0))))), 1));
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0))))), 1))
|
|
NULL
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))), 1));
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))), 1))
|
|
LINESTRING(4 4,4 6,6 6,6 4,4 4)
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
|
|
LINESTRING(POINT(8,8), POINT(8,10), POINT(10,10), POINT(10,8), POINT(8,8))))), 2));
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
|
|
LINESTRING(POINT(8,8), POINT(8,10), POINT(10,
|
|
LINESTRING(8 8,8 10,10 10,10 8,8 8)
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110))))), 2));
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110))))), 2))
|
|
NULL
|
|
#====================================================================================
|
|
# ST_ISCLOSED(multilinestring)
|
|
#====================================================================================
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0))'));
|
|
ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0))'))
|
|
1
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0),(0 0,-10 0,0 0))'));
|
|
ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0),(0 0,-10 0,0 0))'))
|
|
0
|
|
SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,0 0),(0 0,-10 -10,0 0))'));
|
|
ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,0 0),(0 0,-10 -10,0 0))'))
|
|
1
|
|
SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0,0 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))'));
|
|
ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0,0 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))'))
|
|
0
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(0,0))))));
|
|
ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(0,0))))))
|
|
1
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e308,1e308))))));
|
|
ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e308,1e308))))))
|
|
0
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(10,10), POINT(0,0)),
|
|
LINESTRING(POINT(1e308,1e308), POINT(-1e308,-1e308), POINT(1e308,1e308))))));
|
|
ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(10,10), POINT(0,0)),
|
|
LINESTRING(POINT(1e308,1e308), POINT(-1e308,-1e308), POINT(1e308,1e308))))))
|
|
1
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e10,1e10))))));
|
|
ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e10,1e10))))))
|
|
0
|
|
#====================================================================================
|
|
# ST_LENGTH(multilinestring)
|
|
#====================================================================================
|
|
SELECT ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0))'));
|
|
ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0))'))
|
|
20
|
|
SELECT ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0),(0 0,-10 0,0 0))'));
|
|
ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0),(0 0,-10 0,0 0))'))
|
|
40
|
|
SELECT ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,0 0),(0 0,-10 -10,0 0))'));
|
|
ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,0 0),(0 0,-10 -10,0 0))'))
|
|
56.568542494923804
|
|
SELECT ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))'));
|
|
ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))'))
|
|
20
|
|
SELECT ST_LENGTH(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(0,0))))));
|
|
ST_LENGTH(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(0,0))))))
|
|
0
|
|
SELECT ST_LENGTH(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e10,1e10))))));
|
|
ST_LENGTH(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e10,1e10))))))
|
|
14142135623.730951
|
|
# Cartesian SRS
|
|
SELECT ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))', 2000));
|
|
ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))', 2000))
|
|
20
|
|
# Geographic SRS
|
|
SELECT ROUND(ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))', 4326)), 7);
|
|
ROUND(ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))', 4326)), 7)
|
|
2218953.5324189
|
|
#====================================================================================
|
|
# ST_NUMGEOMETRIES(geometrycollection)
|
|
#====================================================================================
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'));
|
|
ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'))
|
|
1
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
'POLYGON((0 0,0 5,5 5,5 0,0 0)))'));
|
|
ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
|
|
3
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'MULTIPOINT(0 0),'
|
|
'MULTILINESTRING((0 0,5 5,10 10),'
|
|
'(0 0,-5 -5,-10 -10)),'
|
|
'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),'
|
|
'((5 5,5 10,10 10,10 5,5 5))))'));
|
|
ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'MULTIPOINT(0 0),'
|
|
'MULTILINESTRING((0 0,5 5,10 10),'
|
|
|
|
3
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'GEOMETRYCOLLECTION(),'
|
|
'GEOMETRYCOLLECTION('
|
|
'GEOMETRYCOLLECTION()),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10))'));
|
|
ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'GEOMETRYCOLLECTION(),'
|
|
|
|
4
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(10,10),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)))))));
|
|
ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(10,10),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4
|
|
3
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
|
|
POLYGON(LINESTRING(POINT(2,2), POINT(2,13), POINT(13,13), POINT(13,2), POINT(2,2)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))));
|
|
ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10
|
|
3
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
|
|
POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))));
|
|
ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), P
|
|
6
|
|
#====================================================================================
|
|
# ST_GEOMETRYN(geometrycollection, number)
|
|
#====================================================================================
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'), 1));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'), 1))
|
|
POINT(0 0)
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
'POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 2));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
|
|
LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10)
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'MULTIPOINT(0 0),'
|
|
'MULTILINESTRING((0 0,5 5,10 10),'
|
|
'(0 0,-5 -5,-10 -10)),'
|
|
'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),'
|
|
'((5 5,5 10,10 10,10 5,5 5))))'), 3));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'MULTIPOINT(0 0),'
|
|
'MULTILINESTRING((0 0,5 5,10 10),'
|
|
|
|
MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'GEOMETRYCOLLECTION(),'
|
|
'GEOMETRYCOLLECTION('
|
|
'GEOMETRYCOLLECTION()),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10))'), 2));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'GEOMETRYCOLLECTION(),'
|
|
|
|
GEOMETRYCOLLECTION EMPTY
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(10,10),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)))))), 2));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(10,10),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POI
|
|
LINESTRING(0 0,2 2,4 4,6 6,8 8)
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
|
|
POLYGON(LINESTRING(POINT(2,2), POINT(2,13), POINT(13,13), POINT(13,2), POINT(2,2)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))), 3));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-
|
|
MULTIPOLYGON(((0 0,0 1,1 1,1 0,0 0)),((2 2,2 13,13 13,13 2,2 2),(4 4,4 6,6 6,6 4,4 4)))
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
|
|
POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))), 2));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4
|
|
LINESTRING(0 0,2 2,4 4,6 6)
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
|
|
POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))), 5));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4
|
|
MULTILINESTRING((0 0,5 5,10 10),(0 0,-5 -5,-10 -10))
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
|
|
MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
|
|
MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
|
|
LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
|
|
MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
|
|
POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))), 6));
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
|
|
POINT(0,0),
|
|
LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
|
|
POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
|
|
LINESTRING(POINT(4
|
|
MULTIPOLYGON(((0 0,0 1,1 1,1 0,0 0)),((2 2,2 3,3 3,3 2,2 2)))
|
|
#====================================================================================
|
|
# ST_X(point)
|
|
#====================================================================================
|
|
SELECT ST_X();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_X'
|
|
SELECT ST_X(NULL);
|
|
ST_X(NULL)
|
|
NULL
|
|
SELECT ST_X(ST_POINTFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTFROMWKB'
|
|
SELECT ST_X(ST_POINTFROMWKB(NULL));
|
|
ST_X(ST_POINTFROMWKB(NULL))
|
|
NULL
|
|
SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1))));
|
|
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 '))))' at line 1
|
|
SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1,a))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(a,b))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_X(ST_POINTFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTFROMTEXT'
|
|
SELECT ST_X(ST_POINTFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT()'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(1)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(a 1)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(1 1,2)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT('!' 0)'));
|
|
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)'))' at line 1
|
|
#====================================================================================
|
|
# ST_Y(point)
|
|
#====================================================================================
|
|
SELECT ST_Y();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_Y'
|
|
SELECT ST_Y(NULL);
|
|
ST_Y(NULL)
|
|
NULL
|
|
SELECT ST_Y(ST_POINTFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTFROMWKB'
|
|
SELECT ST_Y(ST_POINTFROMWKB(NULL));
|
|
ST_Y(ST_POINTFROMWKB(NULL))
|
|
NULL
|
|
SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1))));
|
|
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 '))))' at line 1
|
|
SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1,a))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(a,b))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_Y(ST_POINTFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTFROMTEXT'
|
|
SELECT ST_Y(ST_POINTFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT()'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(1)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(a 1)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(1 1,2)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_pointfromtext.
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT('!' 0)'));
|
|
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)'))' at line 1
|
|
#====================================================================================
|
|
# ST_ISCLOSED(linestring)
|
|
#====================================================================================
|
|
SELECT ST_ISCLOSED();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_ISCLOSED'
|
|
SELECT ST_ISCLOSED(NULL);
|
|
ST_ISCLOSED(NULL)
|
|
NULL
|
|
SELECT ST_ISCLOSED(ST_LINEFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMWKB'
|
|
SELECT ST_ISCLOSED(ST_LINEFROMWKB(LINESTRING(POINT(0,0), POINT(2,2))), 2);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_ISCLOSED'
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(LINESTRING(POINT(a,1), POINT(2,2))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(LINESTRING(POINT(a,1), POINT(2,b))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_ISCLOSED(ST_LINEFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMTEXT'
|
|
SELECT ST_ISCLOSED(ST_LINEFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING()'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
|
|
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 1,2 2)'))' at line 1
|
|
#====================================================================================
|
|
# ST_NUMPOINTS(linestring)
|
|
#====================================================================================
|
|
SELECT ST_NUMPOINTS();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_NUMPOINTS'
|
|
SELECT ST_NUMPOINTS(NULL);
|
|
ST_NUMPOINTS(NULL)
|
|
NULL
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMWKB'
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))), 2);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_NUMPOINTS'
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMTEXT'
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING()'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
|
|
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 1,2 2)'))' at line 1
|
|
#====================================================================================
|
|
# ST_STARTPOINT(linestring)
|
|
#====================================================================================
|
|
SELECT ST_STARTPOINT();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_STARTPOINT'
|
|
SELECT ST_STARTPOINT(NULL);
|
|
ST_STARTPOINT(NULL)
|
|
NULL
|
|
SELECT ST_STARTPOINT(ST_LINEFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMWKB'
|
|
SELECT ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))), 2);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_STARTPOINT'
|
|
SELECT ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_STARTPOINT(ST_LINEFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMTEXT'
|
|
SELECT ST_STARTPOINT(ST_LINEFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING()'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
|
|
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 1,2 2)'))' at line 1
|
|
#====================================================================================
|
|
# ST_ENDPOINT(linestring)
|
|
#====================================================================================
|
|
SELECT ST_ENDPOINT();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_ENDPOINT'
|
|
SELECT ST_ENDPOINT(NULL);
|
|
ST_ENDPOINT(NULL)
|
|
NULL
|
|
SELECT ST_ENDPOINT(ST_LINEFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMWKB'
|
|
SELECT ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))), 2);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_ENDPOINT'
|
|
SELECT ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_ENDPOINT(ST_LINEFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LINEFROMTEXT'
|
|
SELECT ST_ENDPOINT(ST_LINEFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING()'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
|
|
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 1,2 2)'))' at line 1
|
|
#====================================================================================
|
|
# ST_POINTN(linestring, number)
|
|
#====================================================================================
|
|
SELECT ST_POINTN();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTN'
|
|
SELECT ST_POINTN(NULL);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTN'
|
|
SELECT ST_POINTN(NULL, 1);
|
|
ST_POINTN(NULL, 1)
|
|
NULL
|
|
SELECT ST_POINTN(ST_LINEFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTN'
|
|
SELECT ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))));
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTN'
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))), 1);
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))), 1);
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(1,1), POINT(2,2)))), a);
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_POINTN(ST_LINEFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTN'
|
|
SELECT ST_POINTN(ST_LINEFROMTEXT('NULL'));
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTN'
|
|
SELECT ST_POINTN(ST_LINEFROMTEXT('NULL'), 1);
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_POINTN(ST_LINEFROMTEXT('LINESTRING()'), 2);
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0)'), 3);
|
|
ERROR 22023: Invalid GIS data provided to function st_linefromtext.
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'), 4);
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'), 5);
|
|
ERROR 22023: Invalid GIS data provided to function st_linestringfromtext.
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'), 6);
|
|
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 1,2 2)'), 6)' at line 1
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 0);
|
|
ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 0)
|
|
NULL
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), -1);
|
|
ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), -1)
|
|
NULL
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), -1024);
|
|
ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), -1024)
|
|
NULL
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 10000);
|
|
ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 10000)
|
|
NULL
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 1234567890);
|
|
ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 1234567890)
|
|
NULL
|
|
SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 'a');
|
|
ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 'a')
|
|
NULL
|
|
Warnings:
|
|
Warning 1292 Truncated incorrect INTEGER value: 'a'
|
|
#====================================================================================
|
|
# ST_NUMINTERIORRINGS(polygon)
|
|
#====================================================================================
|
|
SELECT ST_NUMINTERIORRINGS();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_NUMINTERIORRINGS'
|
|
SELECT ST_NUMINTERIORRINGS(NULL);
|
|
ST_NUMINTERIORRINGS(NULL)
|
|
NULL
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POLYFROMWKB'
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))), 1);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_NUMINTERIORRINGS'
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(0,1), POINT(1,1), POINT(0,0))))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(b,1), POINT(1,1), POINT(0,0))))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POLYFROMTEXT'
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON(())'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 4,4 4,0 0)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,2 0,2))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 a,0 0))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON(('!' 0,2 0,2 4,0 0))'));
|
|
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,2 0,2 4,0 0))'))' at line 1
|
|
#====================================================================================
|
|
# ST_EXTERIORRING(polygon)
|
|
#====================================================================================
|
|
SELECT ST_EXTERIORRING();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_EXTERIORRING'
|
|
SELECT ST_EXTERIORRING(NULL);
|
|
ST_EXTERIORRING(NULL)
|
|
NULL
|
|
SELECT ST_EXTERIORRING(ST_POLYFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POLYFROMWKB'
|
|
SELECT ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))), 1);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_EXTERIORRING'
|
|
SELECT ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(0,1), POINT(1,1), POINT(0,0))))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(b,1), POINT(1,1), POINT(0,0))))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_EXTERIORRING(ST_POLYFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POLYFROMTEXT'
|
|
SELECT ST_EXTERIORRING(ST_POLYFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON(())'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 4,4 4,0 0)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,2 0,2))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 a,0 0))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON(('!' 0,2 0,2 4,0 0))'));
|
|
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,2 0,2 4,0 0))'))' at line 1
|
|
#====================================================================================
|
|
# ST_INTERIORRINGN(polygon, number)
|
|
#====================================================================================
|
|
SELECT ST_INTERIORRINGN();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_INTERIORRINGN'
|
|
SELECT ST_INTERIORRINGN(NULL);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_INTERIORRINGN'
|
|
SELECT ST_INTERIORRINGN(NULL, 1);
|
|
ST_INTERIORRINGN(NULL, 1)
|
|
NULL
|
|
SELECT ST_INTERIORRINGN(ST_POLYFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_INTERIORRINGN'
|
|
SELECT ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))));
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_INTERIORRINGN'
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(0,1), POINT(1,1), POINT(0,0))))), 1);
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(b,1), POINT(1,1), POINT(0,0))))), 1);
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))), a);
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_INTERIORRINGN'
|
|
SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT('NULL'), 1);
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON(())'), 2);
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0))'), 3);
|
|
ERROR 22023: Invalid GIS data provided to function st_polyfromtext.
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 4,4 4,0 0)'), 4);
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,2 0,2))'), 5);
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 a,0 0))'), 6);
|
|
ERROR 22023: Invalid GIS data provided to function st_polygonfromtext.
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON(('!' 0,2 0,2 4,0 0))'), 7);
|
|
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,2 0,2 4,0 0))'), 7)' at line 1
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 0);
|
|
ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 0)
|
|
NULL
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), -1);
|
|
ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), -1)
|
|
NULL
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), -1024);
|
|
ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), -1024)
|
|
NULL
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 10000);
|
|
ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 10000)
|
|
NULL
|
|
SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 123456789);
|
|
ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 123456789)
|
|
NULL
|
|
#====================================================================================
|
|
# ST_ISCLOSED(multilinestring)
|
|
#====================================================================================
|
|
SELECT ST_ISCLOSED();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_ISCLOSED'
|
|
SELECT ST_ISCLOSED(NULL);
|
|
ST_ISCLOSED(NULL)
|
|
NULL
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_MLINEFROMWKB'
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(1,1), POINT(2,2))))), 1);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_ISCLOSED'
|
|
SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(1,1), POINT(2,2), POINT(3,3), POINT(a,4))))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(1,1), POINT(2,2)), LINESTRING(POINT(3,3), POINT(a,4))))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_ISCLOSED(ST_POLYFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_POLYFROMTEXT'
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_mlinefromtext.
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING(())'));
|
|
ERROR 22023: Invalid GIS data provided to function st_mlinefromtext.
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((1 1,2 2),()'));
|
|
ERROR 22023: Invalid GIS data provided to function st_mlinefromtext.
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((1 1,2 2,3 3)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_mlinefromtext.
|
|
SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1 1,2 3,3 3,4))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_multilinestringfromtext.
|
|
SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1 1,2 2,3 3,4 a))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_multilinestringfromtext.
|
|
SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING(('!' 1,2 2,3 3,4 4'));
|
|
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 '!' 1,2 2,3 3,4 4'))' at line 1
|
|
#====================================================================================
|
|
# ST_LENGTH(multilinestring)
|
|
#====================================================================================
|
|
SELECT ST_LENGTH();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_LENGTH'
|
|
SELECT ST_LENGTH(NULL);
|
|
ST_LENGTH(NULL)
|
|
NULL
|
|
#====================================================================================
|
|
# ST_NUMGEOMETRIES(geometrycollection)
|
|
#====================================================================================
|
|
SELECT ST_NUMGEOMETRIES();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_NUMGEOMETRIES'
|
|
SELECT ST_NUMGEOMETRIES(NULL);
|
|
ST_NUMGEOMETRIES(NULL)
|
|
NULL
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMCOLLFROMWKB'
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(1,1), POINT(2,2))))), 1);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_NUMGEOMETRIES'
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(a,1), POINT(2,2))))));
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,b), LINESTRING(POINT(a,1), POINT(2,2))))));
|
|
ERROR 42S22: Unknown column 'b' in 'field list'
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMCOLLFROMTEXT'
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('NULL'));
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(1)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2)'));
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_geometrycollectionfromtext.
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 a))'));
|
|
ERROR 22023: Invalid GIS data provided to function st_geometrycollectionfromtext.
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 '!'))'));
|
|
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 '!'))'))' at line 1
|
|
#====================================================================================
|
|
# ST_GEOMETRYN(geometrycollection, number)
|
|
#====================================================================================
|
|
SELECT ST_GEOMETRYN();
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMETRYN'
|
|
SELECT ST_GEOMETRYN(NULL);
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMETRYN'
|
|
SELECT ST_GEOMETRYN(NULL, 1);
|
|
ST_GEOMETRYN(NULL, 1)
|
|
NULL
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMWKB());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMETRYN'
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(1,1), POINT(2,2))))));
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMETRYN'
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(a,1), POINT(2,2))))), 1);
|
|
ERROR 42S22: Unknown column 'a' in 'field list'
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,b), LINESTRING(POINT(a,1), POINT(2,2))))), 1);
|
|
ERROR 42S22: Unknown column 'b' in 'field list'
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(1,1), POINT(2,2))))), A);
|
|
ERROR 42S22: Unknown column 'A' in 'field list'
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT());
|
|
ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMETRYN'
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('NULL'), 1);
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(1)'), 2);
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0))'), 3);
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2)'), 4);
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2))'), 5);
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 a))'), 6);
|
|
ERROR 22023: Invalid GIS data provided to function st_geomcollfromtext.
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 '!'))'), 7);
|
|
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 '!'))'), 7)' at line 1
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 0);
|
|
ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 0)
|
|
NULL
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), -1);
|
|
ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), -1)
|
|
NULL
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), -1024);
|
|
ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), -1024)
|
|
NULL
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 10000);
|
|
ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 10000)
|
|
NULL
|
|
SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 123456789);
|
|
ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 123456789)
|
|
NULL
|
|
# Check procedure to work with Point and MultiPoint properties
|
|
CREATE PROCEDURE point_attri()
|
|
BEGIN
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(0 0)'));
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(1.1111 -1.1111)'));
|
|
SELECT ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(0 0)'));
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(1.1111 -1.1111)'));
|
|
SELECT ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
|
|
END |
|
|
# Call the proc
|
|
CALL point_attri;
|
|
ST_X(ST_POINTFROMTEXT('POINT(0 0)'))
|
|
0
|
|
ST_X(ST_POINTFROMTEXT('POINT(1.1111 -1.1111)'))
|
|
1.1111
|
|
ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'))
|
|
1e308
|
|
ST_Y(ST_POINTFROMTEXT('POINT(0 0)'))
|
|
0
|
|
ST_Y(ST_POINTFROMTEXT('POINT(1.1111 -1.1111)'))
|
|
-1.1111
|
|
ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'))
|
|
1e308
|
|
# Dropping the created procedure
|
|
DROP PROCEDURE point_attri;
|
|
# Check procedure to work with Linestring and MultiLineString properties
|
|
CREATE PROCEDURE line_attri()
|
|
BEGIN
|
|
SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)'));
|
|
SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)'));
|
|
SELECT ST_LENGTH(ST_LINEFROMTEXT('LINESTRING(0 0,10 0,0 0,-10 0,0 0,0 10,0 0,0 -10,0 0)'));
|
|
SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)')));
|
|
SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,3 3,0 0)')));
|
|
SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)'), 8));
|
|
SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,1 1,2 2,0 0),(0 0,-1 -1,-2 -2,0 0))'));
|
|
SELECT ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0),(0 0,0 10),(0 0,-10 0),(0 0,0 -10))'));
|
|
END |
|
|
# Call the proc
|
|
CALL line_attri;
|
|
ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)'))
|
|
1
|
|
ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)'))
|
|
4
|
|
ST_LENGTH(ST_LINEFROMTEXT('LINESTRING(0 0,10 0,0 0,-10 0,0 0,0 10,0 0,0 -10,0 0)'))
|
|
80
|
|
ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)')))
|
|
POINT(0 0)
|
|
ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,3 3,0 0)')))
|
|
POINT(0 0)
|
|
ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)'), 8))
|
|
POINT(7 7)
|
|
ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,1 1,2 2,0 0),(0 0,-1 -1,-2 -2,0 0))'))
|
|
1
|
|
ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0),(0 0,0 10),(0 0,-10 0),(0 0,0 -10))'))
|
|
40
|
|
# Dropping the created procedure
|
|
DROP PROCEDURE line_attri;
|
|
CREATE PROCEDURE poly_attri()
|
|
BEGIN
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
|
|
SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('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))'));
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))')));
|
|
SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('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))')));
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 1));
|
|
SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('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))'), 2));
|
|
END |
|
|
# Call the proc
|
|
CALL poly_attri;
|
|
ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'))
|
|
0
|
|
ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('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))'))
|
|
2
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))')))
|
|
LINESTRING(0 0,0 10,10 10,10 0,0 0)
|
|
ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('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))')))
|
|
LINESTRING(0 0,0 10,10 10,10 0,0 0)
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 1))
|
|
NULL
|
|
ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('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))'), 2))
|
|
LINESTRING(6 6,6 8,8 8,8 6,6 6)
|
|
# Dropping the created procedure
|
|
DROP PROCEDURE poly_attri;
|
|
CREATE PROCEDURE geom_coll_attri()
|
|
BEGIN
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
'POLYGON((0 0,0 5,5 5,5 0,0 0)))'));
|
|
SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
'GEOMETRYCOLLECTION('
|
|
'GEOMETRYCOLLECTION()),'
|
|
'POLYGON((0 0,0 5,5 5,5 0,0 0)))'));
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
'POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 3));
|
|
SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
'GEOMETRYCOLLECTION('
|
|
'GEOMETRYCOLLECTION()),'
|
|
'POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 3));
|
|
END |
|
|
# Call the proc
|
|
CALL geom_coll_attri;
|
|
ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
|
|
3
|
|
ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
|
|
4
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
|
|
POLYGON((0 0,0 5,5 5,5 0,0 0))
|
|
ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
|
|
'POINT(0 0),'
|
|
'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
|
|
|
|
GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)
|
|
# Dropping the created procedure
|
|
DROP PROCEDURE geom_coll_attri;
|
|
# Final cleanup
|
|
DROP TABLE gis_point;
|
|
DROP TABLE gis_linestring;
|
|
DROP TABLE gis_polygon;
|
|
DROP TABLE gis_multi_point;
|
|
DROP TABLE gis_multi_linestring;
|
|
DROP TABLE gis_multi_polygon;
|
|
DROP TABLE gis_geometrycollection;
|
|
#
|
|
# WL#8579 Spatial Reference Systems
|
|
#
|
|
# SRID 0 (should pass)
|
|
SELECT ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 0));
|
|
ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 0))
|
|
NULL
|
|
# Projected SRS (should pass)
|
|
SELECT ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 2000));
|
|
ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 2000))
|
|
NULL
|
|
# Geographic SRS (should pass)
|
|
SELECT ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
|
|
ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 4326))
|
|
NULL
|
|
#
|
|
# WL#8579 Spatial Reference Systems
|
|
# GIS functions that do not depend on any SRS
|
|
#
|
|
CREATE PROCEDURE geom_prop_func(IN srid INT)
|
|
BEGIN
|
|
SET @pt_geom = ST_GEOMFROMTEXT('POINT(10 20)', srid);
|
|
SET @ln_geom = ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10)', srid);
|
|
SET @py_geom = ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))', srid);
|
|
SET @gc_geom = ST_GEOMFROMTEXT('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))))', srid);
|
|
# GIS geometry property functions that do not depend on any SRS
|
|
DO ST_SRID(@pt_geom);
|
|
DO ST_ISEMPTY(@pt_geom);
|
|
DO ST_DIMENSION(@pt_geom);
|
|
DO ST_GEOMETRYTYPE(@pt_geom);
|
|
DO ST_X(@pt_geom);
|
|
DO ST_Y(@pt_geom);
|
|
DO ST_ISCLOSED(@ln_geom);
|
|
DO ST_NUMPOINTS(@ln_geom);
|
|
DO ST_ENDPOINT(@ln_geom);
|
|
DO ST_POINTN(@ln_geom, 2);
|
|
DO ST_STARTPOINT(@ln_geom);
|
|
DO ST_NUMINTERIORRING(@py_geom);
|
|
DO ST_NUMINTERIORRINGS(@py_geom);
|
|
DO ST_EXTERIORRING(@py_geom);
|
|
DO ST_INTERIORRINGN(@py_geom, 1);
|
|
DO ST_NUMGEOMETRIES(@gc_geom);
|
|
DO ST_GEOMETRYN(@gc_geom, 1);
|
|
END |
|
|
# SRID 0 (should pass)
|
|
CALL geom_prop_func(0);
|
|
# Projected SRS (should pass)
|
|
CALL geom_prop_func(2000);
|
|
# Geographic SRS (should fail)
|
|
CALL geom_prop_func(4326);
|
|
ERROR 22S00: st_isclosed(LINESTRING) has not been implemented for geographic spatial reference systems.
|
|
DROP PROCEDURE geom_prop_func;
|
|
#
|
|
# WL#11096 Don't do Cartesian computations on geographic geometries
|
|
#
|
|
# Assume SRID 10 is not defined.
|
|
DO ST_ISCLOSED(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_LENGTH(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_SRID(ST_GEOMFROMTEXT('LINESTRING(0 0, 10 10)'), 10);
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_DIMENSION(x'0A000000010100000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_ENDPOINT(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_EXTERIORRING(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_GEOMETRYN(x'0A000000010700000001000000010100000000000000000000000000000000000000', 1);
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_INTERIORRINGN(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 1);
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_ISEMPTY(x'0A000000010100000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_NUMGEOMETRIES(x'0A000000010700000001000000010100000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_NUMINTERIORRING(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_NUMINTERIORRINGS(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_NUMPOINTS(x'0A000000010400000001000000010100000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_NUMPOINTS(x'0A000000010400000001000000010100000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_POINTN(x'0A000000010400000001000000010100000000000000000000000000000000000000', 1);
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_STARTPOINT(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_X(x'0A000000010100000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
DO ST_Y(x'0A000000010100000000000000000000000000000000000000');
|
|
ERROR SR001: There's no spatial reference system with SRID 10.
|
|
SET @LINE = ST_GEOMFROMTEXT( 'LINESTRING(0 0 , 1 1 )', 4326);
|
|
SET @MLINE = ST_GEOMFROMTEXT( 'MULTILINESTRING((0 0 , 1 1 ))', 4326);
|
|
SELECT ST_LENGTH( @LINE, 'METRE');
|
|
ST_LENGTH( @LINE, 'METRE')
|
|
156897.79947
|
|
SELECT ST_LENGTH( @MLINE, 'METRE');
|
|
ST_LENGTH( @MLINE, 'METRE')
|
|
156897.79947
|
|
SELECT ST_LENGTH( @LINE, 'METER');
|
|
ERROR SU001: There's no unit of measure named 'METER'.
|
|
SELECT ST_LENGTH( @LINE, NULL);
|
|
ST_LENGTH( @LINE, NULL)
|
|
NULL
|
|
SELECT ST_LENGTH( NULL, 'FOOT');
|
|
ST_LENGTH( NULL, 'FOOT')
|
|
NULL
|
|
SET @LINE = ST_GEOMFROMTEXT( 'LINESTRING(0 0 , 1 1 )', 32167);
|
|
SELECT ST_LENGTH( @LINE);
|
|
ST_LENGTH( @LINE)
|
|
1.4142135623730951
|
|
SELECT ST_LENGTH( @LINE, 'METRE');
|
|
ST_LENGTH( @LINE, 'METRE')
|
|
0.43105
|