postgis/postgis
postgis/postgis
2
6
Fork 4
Code Issues Pull Requests Releases Activity
postgis/regress/core/relate_bnr.sql

559 lines
144 KiB
SQL
Raw Permalink Blame History

SELECT '1', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,80 0,80 80,0 80,0 0))'::geometry as a, 'POLYGON((100 200,100 140,180 140,180 200,100 200))'::geometry as b) as f;
SELECT '2', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,140 0,140 140,0 140,0 0))'::geometry as a, 'POLYGON((140 0,0 0,0 140,140 140,140 0))'::geometry as b) as f;
SELECT '3', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 60,360 60,360 300,40 300,40 60))'::geometry as a, 'POLYGON((120 100,280 100,280 240,120 240,120 100))'::geometry as b) as f;
SELECT '4', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 60,420 60,420 320,40 320,40 60),(200 140,160 220,260 200,200 140))'::geometry as a, 'POLYGON((80 100,360 100,360 280,80 280,80 100))'::geometry as b) as f;
SELECT '5', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 280,0 0,260 0,260 280,0 280),(220 240,40 240,40 40,220 40,220 240))'::geometry as a, 'POLYGON((20 260,240 260,240 20,20 20,20 260),(160 180,80 180,120 120,160 180))'::geometry as b) as f;
SELECT '6', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 80,200 80,200 220,60 220,60 80))'::geometry as a, 'POLYGON((120 140,260 140,260 260,120 260,120 140))'::geometry as b) as f;
SELECT '7', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 220,220 220,140 140,60 220))'::geometry as a, 'POLYGON((100 180,180 180,180 100,100 100,100 180))'::geometry as b) as f;
SELECT '8', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 40,180 40,180 180,40 180,40 40))'::geometry as a, 'POLYGON((180 40,40 180,160 280,300 140,180 40))'::geometry as b) as f;
SELECT '9', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 60,140 100,100 140,60 100,100 60))'::geometry as a, 'MULTIPOLYGON(((80 40,120 40,120 80,80 80,80 40)),((120 80,160 80,160 120,120 120,120 80)),((80 120,120 120,120 160,80 160,80 120)),((40 80,80 80,80 120,40 120,40 80)))'::geometry as b) as f;
SELECT '10', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((40 280,200 280,200 100,40 100,40 280),(100 220,120 220,120 200,100 180,100 220))'::geometry as a, 'POLYGON((40 280,180 260,180 120,60 120,40 280))'::geometry as b) as f;
SELECT '11', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 200,0 0,200 0,200 200,0 200),(20 180,130 180,130 30,20 30,20 180))'::geometry as a, 'POLYGON((60 90,130 90,130 30,60 30,60 90))'::geometry as b) as f;
SELECT '12', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as a, 'POLYGON((270 90,200 50,150 80,210 120,270 90))'::geometry as b) as f;
SELECT '13', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 60,140 100,100 140,60 100,100 60))'::geometry as a, 'MULTIPOLYGON(((80 40,120 40,120 80,80 80,80 40)),((120 80,160 80,160 120,120 120,120 80)),((80 120,120 120,120 160,80 160,80 120)),((40 80,80 80,80 120,40 120,40 80)))'::geometry as b) as f;
SELECT '14', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 120,100 240)'::geometry as a, 'POLYGON((40 60,160 60,160 180,40 180,40 60))'::geometry as b) as f;
SELECT '15', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 80,140 140,200 200)'::geometry as a, 'POLYGON((40 40,140 40,140 140,40 140,40 40))'::geometry as b) as f;
SELECT '16', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(70 50,70 150)'::geometry as a, 'MULTIPOLYGON(((0 0,0 100,140 100,140 0,0 0)),((20 170,70 100,130 170,20 170)))'::geometry as b) as f;
SELECT '17', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,150 70)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(110 110,250 100,140 30,110 110))'::geometry as b) as f;
SELECT '18', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,150 70)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(111 110,250 100,140 30,111 110))'::geometry as b) as f;
SELECT '19', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,170 110)'::geometry as a, 'POLYGON((20 200,20 20,240 20,240 200,20 200),(130 110,60 40,60 180,130 110),(130 180,130 40,200 110,130 180))'::geometry as b) as f;
SELECT '20', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,170 110)'::geometry as a, 'POLYGON((20 200,20 20,240 20,240 200,20 200),(130 110,60 40,60 180,130 110),(130 180,131 40,200 110,130 180))'::geometry as b) as f;
SELECT '21', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(160 70,320 230)'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '22', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 140,100 40)'::geometry as a, 'MULTIPOLYGON(((20 80,180 79,100 0,20 80)),((20 160,180 160,100 80,20 160)))'::geometry as b) as f;
SELECT '23', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 140,100 40)'::geometry as a, 'MULTIPOLYGON(((20 80,180 80,100 0,20 80)),((20 160,180 160,100 80,20 160)))'::geometry as b) as f;
SELECT '24', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 60,20 150,200 150,110 60)'::geometry as a, 'POLYGON((20 20,200 20,110 110,20 20))'::geometry as b) as f;
SELECT '25', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,0 50,50 50,50 0,0 0)'::geometry as a, 'MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))'::geometry as b) as f;
SELECT '26', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 180,140 180)'::geometry as a, 'MULTIPOLYGON(((20 320,180 320,180 180,20 180,20 320)),((20 180,20 80,180 80,180 180,20 180)))'::geometry as b) as f;
SELECT '27', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 180,140 180)'::geometry as a, 'MULTIPOLYGON(((20 320,180 320,180 180,20 180,20 320)),((60 180,60 80,180 80,180 180,60 180)))'::geometry as b) as f;
SELECT '28', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,60 0,60 60,60 0,120 0)'::geometry as a, 'MULTILINESTRING((0 0,60 0),(60 0,120 0),(60 0,60 60))'::geometry as b) as f;
SELECT '29', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 0,20 80,100 80,80 120,40 140)'::geometry as a, 'LINESTRING(140 300,220 160,260 200,240 260)'::geometry as b) as f;
SELECT '30', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 0,20 80,100 80,80 120,40 140)'::geometry as a, 'LINESTRING(60 40,140 40,140 160,0 160)'::geometry as b) as f;
-- TODO: Put back after sometime or put in separte test file. The correct answer is in upcoming GEOS 3.9.4, 3.10.4, 3.11.1, 3.12.0
-- SELECT '31', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 0,20 80,100 80,80 120,40 140)'::geometry as a, 'LINESTRING(140 280,240 280,240 180,140 180,140 280)'::geometry as b) as f;
SELECT '32', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(140 0,0 0,40 60,0 120,60 200,220 160,220 40)'::geometry as a, 'LINESTRING(80 140,180 100,160 40,100 40,60 100,80 140)'::geometry as b) as f;
SELECT '33', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,80 80)'::geometry as a, 'LINESTRING(20 20,80 80)'::geometry as b) as f;
SELECT '34', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,160 160,200 60,60 140)'::geometry as a, 'LINESTRING(40 40,160 160,200 60,60 140)'::geometry as b) as f;
SELECT '35', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,200 40)'::geometry as a, 'LINESTRING(200 40,140 40,40 40)'::geometry as b) as f;
SELECT '36', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,110 0,60 0)'::geometry as a, 'LINESTRING(0 0,110 0)'::geometry as b) as f;
SELECT '37', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,0 50,50 50,50 0,0 0)'::geometry as a, 'MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))'::geometry as b) as f;
SELECT '38', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,80 0,80 60,80 0,170 0)'::geometry as a, 'MULTILINESTRING((0 0,170 0),(80 0,80 60))'::geometry as b) as f;
SELECT '39', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 100,180 200)'::geometry as a, 'LINESTRING(80 180,180 120)'::geometry as b) as f;
SELECT '40', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,160 160)'::geometry as a, 'LINESTRING(160 60,100 100,60 140)'::geometry as b) as f;
SELECT '41', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,180 100,180 180,100 180,100 100)'::geometry as a, 'LINESTRING(140 60,60 140)'::geometry as b) as f;
SELECT '42', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,180 180,100 180,100 100)'::geometry as a, 'LINESTRING(140 60,60 140)'::geometry as b) as f;
SELECT '43', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 110,200 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,110 110,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '44', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 90,50 50,0 0)'::geometry as a, 'LINESTRING(0 0,100 100)'::geometry as b) as f;
SELECT '45', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 140,240 140)'::geometry as a, 'LINESTRING(40 140,100 140,80 80,120 60,100 140,160 140,160 100,200 100,160 140,240 140)'::geometry as b) as f;
SELECT '46', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,100 20,20 20)'::geometry as a, 'LINESTRING(60 20,200 20)'::geometry as b) as f;
SELECT '47', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 60,180 60,180 140,100 140,100 60,220 60,220 180,80 180,80 60,280 60)'::geometry as a, 'LINESTRING(140 60,180 60,220 60,260 60)'::geometry as b) as f;
SELECT '48', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '49', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(0 20,40 20)'::geometry as a, 'POLYGON((20 40,20 0,60 0,60 40,20 40))'::geometry as b) as f;
SELECT '50', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(0 20,20 20)'::geometry as a, 'POLYGON((20 40,20 0,60 0,60 40,20 40))'::geometry as b) as f;
SELECT '51', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 20,40 20)'::geometry as a, 'POLYGON((20 40,20 0,60 0,60 40,20 40))'::geometry as b) as f;
SELECT '52', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(80 260,140 260,180 260)'::geometry as a, 'POLYGON((40 320,140 320,140 200,40 200,40 320))'::geometry as b) as f;
SELECT '53', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(40 40)'::geometry as a, 'MULTIPOLYGON(((0 40,0 0,40 0,40 40,0 40)),((40 80,40 40,80 40,80 80,40 80)))'::geometry as b) as f;
SELECT '54', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(60 120)'::geometry as a, 'LINESTRING(40 40,120 120,200 120)'::geometry as b) as f;
SELECT '55', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(40 40)'::geometry as a, 'LINESTRING(40 40,100 100,160 100)'::geometry as b) as f;
SELECT '56', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(60 60)'::geometry as a, 'LINESTRING(40 40,100 100)'::geometry as b) as f;
SELECT '57', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,100 40)'::geometry as a, 'LINESTRING(40 40,80 80)'::geometry as b) as f;
SELECT '58', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,60 60)'::geometry as a, 'LINESTRING(40 40,80 80)'::geometry as b) as f;
SELECT '59', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 60,100 100)'::geometry as a, 'LINESTRING(40 40,80 80)'::geometry as b) as f;
SELECT '60', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 60,100 100)'::geometry as a, 'LINESTRING(40 40,80 80)'::geometry as b) as f;
SELECT '61', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 60,100 100)'::geometry as a, 'LINESTRING(40 40,60 60,80 80)'::geometry as b) as f;
SELECT '62', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'POINT(20 20)'::geometry as b) as f;
SELECT '63', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'POINT(20 30)'::geometry as b) as f;
SELECT '64', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,80 60,40 100)'::geometry as a, 'MULTIPOINT(40 40,80 60,120 100)'::geometry as b) as f;
SELECT '65', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,80 60,120 100)'::geometry as a, 'MULTIPOINT(40 40,80 60,120 100)'::geometry as b) as f;
SELECT '66', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 100,100 200,200 200,200 100,100 100))'::geometry as a, 'POLYGON((100 100,1e+15 110,1e+15 100,100 100))'::geometry as b) as f;
SELECT '67', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 100,120 200,200 200,200 100,120 100))'::geometry as a, 'POLYGON((100 100,1e+15 110,1e+15 100,100 100))'::geometry as b) as f;
SELECT '68', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140 20,20 20))'::geometry as a, 'POLYGON((20 20,20 100,120 100,140 20,20 20))'::geometry as b) as f;
SELECT '69', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140 20,20 20))'::geometry as a, 'POLYGON((20 20,140 20,120 100,20 100,20 20))'::geometry as b) as f;
SELECT '70', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140 20,20 20))'::geometry as a, 'POLYGON((120 100,140 20,20 20,20 100,120 100))'::geometry as b) as f;
SELECT '71', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 100,120 100,140 20,20 20))'::geometry as a, 'POLYGON((20 100,60 100,120 100,140 20,80 20,20 20,20 100))'::geometry as b) as f;
SELECT '72', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,80 0,80 80,0 80,0 0))'::geometry as a, 'POLYGON((100 200,100 140,180 140,180 200,100 200))'::geometry as b) as f;
SELECT '73', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((140 120,140 200,240 200,240 120,140 120))'::geometry as b) as f;
SELECT '74', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((80 180,140 260,260 200,200 60,80 180))'::geometry as b) as f;
SELECT '75', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((240 80,140 120,180 240,280 200,240 80))'::geometry as b) as f;
SELECT '76', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 160,20 20,270 20,150 160,230 40,60 40,140 160))'::geometry as a, 'POLYGON((140 40,180 80,120 100,140 40))'::geometry as b) as f;
SELECT '77', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 160,20 20,270 20,150 160,230 40,60 40,140 160))'::geometry as a, 'POLYGON((120 100,180 80,130 40,120 100))'::geometry as b) as f;
SELECT '78', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,180 20,140 140,20 140,20 20))'::geometry as a, 'POLYGON((180 100,80 200,180 280,260 200,180 100))'::geometry as b) as f;
SELECT '79', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((140 140,20 120,0 220,120 240,140 140))'::geometry as b) as f;
SELECT '80', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((160 200,210 70,120 70,160 200))'::geometry as a, 'POLYGON((160 200,260 40,70 40,160 200,20 20,310 20,160 200))'::geometry as b) as f;
SELECT '81', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((110 140,200 70,200 160,110 140))'::geometry as a, 'POLYGON((110 140,110 50,60 50,60 90,160 190,20 110,20 20,200 20,110 140))'::geometry as b) as f;
SELECT '82', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 120,20 20,260 20,260 120,200 40,140 120,80 40,20 120))'::geometry as a, 'POLYGON((20 120,20 240,260 240,260 120,200 200,140 120,80 200,20 120))'::geometry as b) as f;
SELECT '83', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 120,20 20,260 20,260 120,180 40,140 120,100 40,20 120))'::geometry as a, 'POLYGON((20 120,300 120,140 240,20 120))'::geometry as b) as f;
SELECT '84', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 300,280 300,280 260,220 260,60 100,60 60,280 60,280 20,20 20))'::geometry as a, 'POLYGON((100 140,160 80,280 180,200 240,220 160,160 200,180 120,100 140))'::geometry as b) as f;
SELECT '85', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 300,280 300,280 260,220 260,60 100,60 60,280 60,280 20,20 20))'::geometry as a, 'POLYGON((260 200,180 80,120 160,200 160,180 220,260 200))'::geometry as b) as f;
SELECT '86', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,280 20,280 140,220 60,140 140,80 60,20 140,20 20))'::geometry as a, 'POLYGON((0 140,300 140,140 240,0 140))'::geometry as b) as f;
SELECT '87', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,280 20,280 140,220 60,140 140,80 60,20 140,20 20))'::geometry as a, 'POLYGON((20 240,20 140,320 140,180 240,20 240))'::geometry as b) as f;
SELECT '88', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,280 20,280 140,220 60,140 140,80 60,20 140,20 20))'::geometry as a, 'POLYGON((20 240,20 140,80 180,140 140,220 180,280 140,280 240,20 240))'::geometry as b) as f;
SELECT '89', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 120,180 60,20 20,20 120,120 120))'::geometry as a, 'POLYGON((120 120,220 20,280 20,240 160,120 120))'::geometry as b) as f;
SELECT '90', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((140 120,160 20,260 120,220 200,140 120))'::geometry as b) as f;
SELECT '91', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 140,120 40,20 40,20 140))'::geometry as a, 'POLYGON((190 140,190 20,140 20,20 140,190 140))'::geometry as b) as f;
SELECT '92', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 120,180 60,20 20,20 120,120 120))'::geometry as a, 'POLYGON((300 20,220 20,120 120,260 160,300 20))'::geometry as b) as f;
SELECT '93', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((140 120,240 160,280 60,160 20,140 120))'::geometry as b) as f;
SELECT '94', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 120,180 60,20 20,20 120,120 120))'::geometry as a, 'POLYGON((280 60,180 60,120 120,260 180,280 60))'::geometry as b) as f;
SELECT '95', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((120 200,120 120,40 120,40 200,120 200))'::geometry as b) as f;
SELECT '96', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((160 220,140 120,60 120,40 220,160 220))'::geometry as b) as f;
SELECT '97', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 120,160 20,20 20,20 120,140 120))'::geometry as a, 'POLYGON((140 120,20 120,20 220,140 220,140 120))'::geometry as b) as f;
SELECT '98', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 120,180 60,20 20,20 120,120 120))'::geometry as a, 'POLYGON((320 20,220 20,80 160,240 140,320 20))'::geometry as b) as f;
SELECT '99', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((60 40,60 140,180 140,180 40,60 40))'::geometry as b) as f;
SELECT '100', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,80 140,160 60,20 20))'::geometry as b) as f;
SELECT '101', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((160 60,20 20,100 140,160 60))'::geometry as b) as f;
SELECT '102', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 100,140 160,160 40,20 100))'::geometry as b) as f;
SELECT '103', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((160 40,20 100,160 160,160 40))'::geometry as b) as f;
SELECT '104', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 180,180 120,80 40,20 180))'::geometry as b) as f;
SELECT '105', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((180 120,100 40,20 180,180 120))'::geometry as b) as f;
SELECT '106', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,140 40,140 120,20 160,80 80,20 20))'::geometry as b) as f;
SELECT '107', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,140 40,140 140,20 180,80 100,20 20))'::geometry as b) as f;
SELECT '108', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((40 180,60 100,180 100,200 180,120 120,40 180))'::geometry as b) as f;
SELECT '109', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 180,60 80,180 80,220 180,120 120,20 180))'::geometry as b) as f;
SELECT '110', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((40 60,20 180,100 100,140 180,160 120,220 100,140 40,40 60))'::geometry as b) as f;
SELECT '111', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((60 100,180 100,220 180,120 140,20 180,60 100))'::geometry as b) as f;
SELECT '112', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,20 140,120 120,120 40,20 20))'::geometry as b) as f;
SELECT '113', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,20 180,140 140,140 60,20 20))'::geometry as b) as f;
SELECT '114', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,120 40,120 120,20 140,20 20))'::geometry as b) as f;
SELECT '115', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((120 40,20 20,20 140,120 120,120 40))'::geometry as b) as f;
SELECT '116', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,140 60,140 140,20 180,20 20))'::geometry as b) as f;
SELECT '117', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((140 60,20 20,20 180,140 140,140 60))'::geometry as b) as f;
SELECT '118', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,60 120,140 120,180 20,20 20))'::geometry as b) as f;
SELECT '119', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 40,120 40,120 120,20 140,20 40))'::geometry as b) as f;
SELECT '120', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,20 180,220 180,220 20,20 20))'::geometry as a, 'POLYGON((20 20,20 180,60 120,100 180,140 120,220 180,200 120,140 60,20 20))'::geometry as b) as f;
SELECT '121', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((150 150,330 150,250 70,70 70,150 150))'::geometry as a, 'POLYGON((150 150,270 150,140 20,20 20,150 150))'::geometry as b) as f;
SELECT '122', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((150 150,270 150,330 150,250 70,190 70,70 70,150 150))'::geometry as a, 'POLYGON((150 150,270 150,190 70,140 20,20 20,70 70,150 150))'::geometry as b) as f;
SELECT '123', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((20 20,60 50,20 40,60 70,20 60,60 90,20 90,70 110,20 130,80 130,20 150,80 160,20 170,80 180,20 200,80 200,30 240,80 220,50 260,100 220,100 260,120 220,130 260,140 220,150 280,150 190,160 280,170 190,180 280,190 190,200 280,210 190,220 280,230 190,240 260,250 230,260 260,260 220,290 270,290 220,330 260,300 210,340 240,290 180,340 210,290 170,350 170,240 150,350 150,240 140,350 130,240 120,350 120,240 110,350 110,240 100,350 100,240 90,350 90,240 80,350 80,300 70,340 60,290 60,340 40,300 50,340 20,270 60,310 20,250 60,270 20,230 60,240 20,210 60,210 20,190 70,190 20,180 90,170 20,160 90,150 20,140 90,130 20,120 90,110 20,100 90,100 20,90 60,80 20,70 40,20 20))'::geometry as a, 'POLYGON((190 140,140 130,200 160,130 150,210 170,130 170,210 180,120 190,220 200,120 200,250 210,120 210,250 220,120 220,250 230,120 240,230 240,120 250,240 260,120 260,240 270,120 270,270 290,120 290,230 300,150 310,250 310,180 320,250 320,200 360,260 330,240 360,280 320,290 370,290 320,320 360,310 320,360 360,310 310,380 340,310 290,390 330,310 280,410 310,310 270,420 280,310 260,430 250,300 250,440 240,300 240,450 230,280 220,440 220,280 210,440 210,300 200,430 190,300 190,440 180,330 180,430 150,320 180,420 130,300 180,410 120,280 180,400 110,280 170,390 90,280 160,400 70,270 160,450 30,260 160,420 30,250 160,390 30,240 160,370 30,230 160,360 30,230 150,330 50,240 130,330 30,230 130,310 30,220 130,280 30,230 100,270 40,220 110,250 30,210 130,240 30,210 100,220 40,200 90,200 20,190 100,180 30,20 20,180 40,20 30,180 50,20 50,180 60,30 60,180 70,20 70,170 80,80 80,170 90,20 80,180 100,40 100,200 110,60 110,200 120,120 120,190 140))'::geometry as b) as f;
SELECT '124', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((70 150,20 160,110 160,20 180,100 200,20 200,190 210,20 210,160 220,20 220,150 230,60 240,180 250,20 260,170 260,60 270,160 270,100 310,170 280,200 260,180 230,210 260,130 330,230 250,210 290,240 250,230 210,260 300,250 230,270 300,270 240,300 340,280 250,320 330,290 250,340 350,290 240,350 360,270 190,350 340,290 200,350 330,300 190,360 320,310 190,360 300,320 200,360 280,330 200,360 260,340 200,370 260,340 180,390 290,340 170,400 260,350 170,400 250,350 160,410 240,350 150,400 170,350 140,310 170,340 140,270 180,330 140,260 170,310 140,240 170,290 140,200 190,270 140,180 190,260 140,170 190,260 130,170 180,250 130,170 170,240 120,170 160,210 120,170 150,210 110,340 130,230 110,420 140,220 100,410 130,220 90,400 120,220 80,390 110,220 70,420 110,240 70,420 100,260 70,420 90,280 70,430 80,230 60,430 60,270 50,450 40,210 50,370 40,260 40,460 30,160 40,210 60,200 110,190 60,190 120,170 50,180 130,150 30,170 130,140 20,160 120,130 20,160 150,120 20,160 170,110 20,160 190,100 20,150 190,90 20,140 180,80 20,120 140,70 20,120 150,60 20,110 150,50 20,100 140,50 30,90 130,40 30,80 120,30 30,80 130,30 40,80 140,20 40,70 140,40 90,60 130,20 90,60 140,20 130,70 150))'::geometry as a, 'POLYGON((190 140,140 130,200 160,130 150,210 170,130 170,210 180,120 190,220 200,120 200,250 210,120 210,250 220,120 220,250 230,120 240,230 240,120 250,240 260,120 260,240 270,120 270,270 290,120 290,230 300,150 310,250 310,180 320,250 320,200 360,260 330,240 360,280 320,290 370,290 320,320 360,310 320,360 360,310 310,380 340,310 290,390 330,310 280,410 310,310 270,420 280,310 260,430 250,300 250,440 240,300 240,450 230,280 220,440 220,280 210,440 210,300 200,430 190,300 190,440 180,330 180,430 150,320 180,420 130,300 180,410 120,280 180,400 110,280 170,390 90,280 160,400 70,270 160,450 30,260 160,420 30,250 160,390 30,240 160,370 30,230 160,360 30,230 150,330 50,240 130,330 30,230 130,310 30,220 130,280 30,230 100,270 40,220 110,250 30,210 130,240 30,210 100,220 40,200 90,200 20,190 100,180 30,20 20,180 40,20 30,180 50,20 50,180 60,30 60,180 70,20 70,170 80,80 80,170 90,20 80,180 100,40 100,200 110,60 110,200 120,120 120,190 140))'::geometry as b) as f;
SELECT '125', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 160,220 160,220 20,60 20,60 160))'::geometry as a, 'POLYGON((60 160,20 200,260 200,220 160,140 80,60 160))'::geometry as b) as f;
SELECT '126', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 160,220 160,220 20,60 20,60 160))'::geometry as a, 'POLYGON((60 160,20 200,260 200,140 80,60 160))'::geometry as b) as f;
SELECT '127', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 160,220 160,220 20,60 20,60 160))'::geometry as a, 'POLYGON((20 200,140 80,260 200,20 200))'::geometry as b) as f;
SELECT '128', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 160,220 160,220 20,60 20,60 160))'::geometry as a, 'POLYGON((20 200,60 160,140 80,220 160,260 200,20 200))'::geometry as b) as f;
SELECT '129', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((60 160,220 160,220 20,60 20,60 160))'::geometry as a, 'POLYGON((20 200,60 160,140 80,260 200,20 200))'::geometry as b) as f;
SELECT '130', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,0 200,200 200,200 0,0 0))'::geometry as a, 'POLYGON((100 100,1000000 110,10000000 100,100 100))'::geometry as b) as f;
SELECT '131', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 0,100 200,200 200,200 0,100 0))'::geometry as a, 'POLYGON((100 100,1000000 110,10000000 100,100 100))'::geometry as b) as f;
SELECT '132', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 0,120 200,200 200,200 0,120 0))'::geometry as a, 'POLYGON((100 100,1000000 110,10000000 100,100 100))'::geometry as b) as f;
SELECT '133', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((0 0,0 200,110 200,110 0,0 0))'::geometry as a, 'POLYGON((100 100,1000000 110,10000000 100,100 100))'::geometry as b) as f;
SELECT '134', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 100,100 200,200 200,200 100,100 100))'::geometry as a, 'POLYGON((100 100,2100 110,2100 100,100 100))'::geometry as b) as f;
SELECT '135', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 100,100 200,200 200,200 100,100 100))'::geometry as a, 'POLYGON((100 100,2101 110,2101 100,100 100))'::geometry as b) as f;
SELECT '136', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 100,200 200,200 100,100 100))'::geometry as a, 'POLYGON((100 100,2101 110,2101 100,100 100))'::geometry as b) as f;
SELECT '137', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 100,100 200,200 200,200 100,100 100))'::geometry as a, 'POLYGON((100 100,1000000 110,1000000 100,100 100))'::geometry as b) as f;
SELECT '138', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 100,120 200,200 200,200 100,120 100))'::geometry as a, 'POLYGON((100 100,500 110,500 100,100 100))'::geometry as b) as f;
SELECT '139', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 100,120 200,200 200,200 100,120 100))'::geometry as a, 'POLYGON((100 100,501 110,501 100,100 100))'::geometry as b) as f;
SELECT '140', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 100,130 200,200 200,200 100,120 100))'::geometry as a, 'POLYGON((100 100,501 110,501 100,100 100))'::geometry as b) as f;
SELECT '141', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 100,17 200,200 200,200 100,120 100))'::geometry as a, 'POLYGON((100 100,501 110,501 100,100 100))'::geometry as b) as f;
SELECT '142', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((120 100,120 200,200 200,200 100,120 100))'::geometry as a, 'POLYGON((100 100,1000000 110,1000000 100,100 100))'::geometry as b) as f;
SELECT '143', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((101 99,101 1000000,102 1000000,101 99))'::geometry as a, 'POLYGON((100 100,1000000 110,1000000 100,100 100))'::geometry as b) as f;
SELECT '144', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 100,200 101,200 100,100 100))'::geometry as a, 'POLYGON((100 100,2101 110,2101 100,100 100))'::geometry as b) as f;
SELECT '145', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((16 319,150 39,25 302,160 20,265 20,127 317,16 319))'::geometry as a, 'POLYGON((10 307,22 307,153 34,22 34,10 307))'::geometry as b) as f;
SELECT '146', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((160 200,210 70,120 70,160 200))'::geometry as a, 'POLYGON((160 200,310 20,20 20,160 200),(160 200,260 40,70 40,160 200))'::geometry as b) as f;
SELECT '147', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((170 120,240 100,260 50,190 70,170 120))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '148', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((270 90,200 50,150 80,210 120,270 90))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '149', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((170 120,260 100,240 60,150 80,170 120))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '150', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((220 120,270 80,200 60,160 100,220 120))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '151', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((260 50,180 70,180 110,260 90,260 50))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '152', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((230 110,290 80,190 60,140 90,230 110))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '153', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((170 120,330 120,260 50,100 50,170 120))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '154', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((170 120,330 120,280 70,120 70,170 120))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '155', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((170 120,300 120,250 70,120 70,170 120))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '156', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((190 100,310 100,260 50,140 50,190 100))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '157', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((280 130,360 130,270 40,190 40,280 130))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180 50,100 50,170 120))'::geometry as b) as f;
SELECT '158', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((220 80,180 40,80 40,170 130,270 130,230 90,300 90,250 30,280 30,390 140,150 140,40 30,230 30,280 80,220 80))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180 50,100 50,170 120))'::geometry as b) as f;
SELECT '159', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((260 130,360 130,280 40,170 40,260 130))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180 50,100 50,170 120))'::geometry as b) as f;
SELECT '160', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((240 110,340 110,290 60,190 60,240 110))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180 50,100 50,170 120))'::geometry as b) as f;
SELECT '161', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((250 120,350 120,280 50,180 50,250 120))'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,250 120,180 50,100 50,170 120))'::geometry as b) as f;
SELECT '162', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((230 210,230 20,20 20,20 210,230 210),(120 180,50 50,200 50,120 180))'::geometry as a, 'POLYGON((230 210,230 20,20 20,20 210,230 210),(120 180,50 50,200 50,120 180))'::geometry as b) as f;
SELECT '163', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((230 210,230 20,20 20,20 210,230 210),(140 40,40 40,40 170,140 40),(110 190,210 190,210 50,110 190))'::geometry as a, 'POLYGON((230 210,230 20,20 20,20 210,230 210),(140 40,40 40,40 170,140 40),(110 190,210 190,210 50,110 190))'::geometry as b) as f;
SELECT '164', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((280 190,330 150,200 110,150 150,280 190))'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '165', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((80 190,220 190,140 110,0 110,80 190))'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '166', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((330 150,200 110,150 150,280 190,330 150))'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '167', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((290 190,340 150,220 120,170 170,290 190))'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '168', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((220 190,340 190,260 110,140 110,220 190))'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '169', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 190,220 190,100 70,20 70,140 190))'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '170', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((140 220,60 140,140 60,220 140,140 220))'::geometry as a, 'MULTIPOLYGON(((100 20,180 20,180 100,100 100,100 20)),((20 100,100 100,100 180,20 180,20 100)),((100 180,180 180,180 260,100 260,100 180)),((180 100,260 100,260 180,180 180,180 100)))'::geometry as b) as f;
SELECT '171', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOLYGON(((110 110,70 200,150 200,110 110)),((110 110,150 20,70 20,110 110)))'::geometry as a, 'MULTIPOLYGON(((110 110,160 160,210 110,160 60,110 110)),((110 110,60 60,10 110,60 160,110 110)))'::geometry as b) as f;
SELECT '172', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOLYGON(((110 110,70 200,150 200,110 110),(110 110,100 180,120 180,110 110)),((110 110,150 20,70 20,110 110),(110 110,120 40,100 40,110 110)))'::geometry as a, 'MULTIPOLYGON(((110 110,160 160,210 110,160 60,110 110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110 110),(110 110,60 90,60 130,110 110)))'::geometry as b) as f;
SELECT '173', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOLYGON(((110 110,70 200,200 200,110 110),(110 110,100 180,120 180,110 110)),((110 110,200 20,70 20,110 110),(110 110,120 40,100 40,110 110)))'::geometry as a, 'MULTIPOLYGON(((110 110,160 160,210 110,160 60,110 110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110 110),(110 110,60 90,60 130,110 110)))'::geometry as b) as f;
SELECT '174', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOLYGON(((110 110,20 200,200 200,110 110),(110 110,100 180,120 180,110 110)),((110 110,200 20,20 20,110 110),(110 110,120 40,100 40,110 110)))'::geometry as a, 'MULTIPOLYGON(((110 110,160 160,210 110,160 60,110 110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110 110),(110 110,60 90,60 130,110 110)))'::geometry as b) as f;
SELECT '175', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOLYGON(((110 110,70 200,200 200,110 110),(110 110,100 180,120 180,110 110)),((110 110,200 20,70 20,110 110),(110 110,120 40,100 40,110 110)))'::geometry as a, 'MULTIPOLYGON(((110 110,160 160,210 110,160 60,110 110),(110 110,160 130,160 90,110 110)),((110 110,60 60,10 110,60 160,110 110),(110 110,60 90,60 130,110 110)))'::geometry as b) as f;
SELECT '176', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOLYGON(((110 110,70 200,200 200,110 110),(110 110,100 180,120 180,110 110)),((110 110,200 20,70 20,110 110),(110 110,120 40,100 40,110 110)))'::geometry as a, 'MULTIPOLYGON(((110 110,70 200,210 110,70 20,110 110),(110 110,110 140,150 110,110 80,110 110)),((110 110,60 60,10 110,60 160,110 110),(110 110,60 90,60 130,110 110)))'::geometry as b) as f;
SELECT '177', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POLYGON((100 60,140 100,100 140,60 100,100 60))'::geometry as a, 'MULTIPOLYGON(((80 40,120 40,120 80,80 80,80 40)),((120 80,160 80,160 120,120 120,120 80)),((80 120,120 120,120 160,80 160,80 120)),((40 80,80 80,80 120,40 120,40 80)))'::geometry as b) as f;
SELECT '178', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(150 150,40 230)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '179', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,50 130,130 130)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '180', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 230,150 150)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '181', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(210 150,330 150)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '182', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(200 150,310 150,360 220)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '183', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(180 150,250 150,230 250,370 250,410 150)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '184', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(210 210,220 150,320 150,370 210)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '185', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 60,150 60)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '186', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 90,310 180)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '187', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(90 210,210 90)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '188', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(290 10,130 170)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '189', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(30 100,100 100,180 100)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '190', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 100,100 100,360 100,410 100)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '191', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(90 210,150 150,210 90)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '192', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(180 90,280 120)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '193', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(70 70,80 20)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '194', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 20,150 60)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '195', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(70 70,80 20,140 20,150 60)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '196', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(170 50,170 20,240 20,260 60)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150))'::geometry as b) as f;
SELECT '197', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(50 100,140 190,280 190)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '198', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(140 60,180 100,290 100)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '199', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(170 120,210 80,270 80)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '200', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(170 120,260 50)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '201', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(190 90,190 270)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(190 190,280 50,100 50,190 190))'::geometry as b) as f;
SELECT '202', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,150 70)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(110 110,250 100,140 30,110 110))'::geometry as b) as f;
SELECT '203', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,150 70)'::geometry as a, 'POLYGON((190 190,20 20,360 20,190 190),(250 100,110 110,140 30,250 100))'::geometry as b) as f;
SELECT '204', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,150 70)'::geometry as a, 'POLYGON((190 190,20 20,360 20,190 190),(250 100,110 110,140 30,250 100))'::geometry as b) as f;
SELECT '205', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(190 90,190 190,190 270)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(190 190,280 50,100 50,190 190))'::geometry as b) as f;
SELECT '206', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,110 110,150 70)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(110 110,250 100,140 30,110 110))'::geometry as b) as f;
SELECT '207', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,110 110,150 70)'::geometry as a, 'POLYGON((190 190,20 20,360 20,190 190),(250 100,110 110,140 30,250 100))'::geometry as b) as f;
SELECT '208', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 160,110 110,150 70)'::geometry as a, 'POLYGON((190 190,110 110,20 20,360 20,190 190),(250 100,110 110,140 30,250 100))'::geometry as b) as f;
SELECT '209', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 110,180 110,190 60)'::geometry as a, 'POLYGON((20 200,240 200,240 20,20 20,20 200),(130 110,60 180,60 40,130 110),(130 110,200 40,200 180,130 110))'::geometry as b) as f;
SELECT '210', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,180 110)'::geometry as a, 'POLYGON((20 200,240 200,240 20,20 20,20 200),(130 110,60 180,60 40,130 110),(130 110,200 40,200 180,130 110))'::geometry as b) as f;
SELECT '211', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,180 110)'::geometry as a, 'POLYGON((20 200,20 20,240 20,240 200,20 200),(60 180,130 110,60 40,60 180),(130 110,200 40,200 180,130 110))'::geometry as b) as f;
SELECT '212', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,170 110)'::geometry as a, 'POLYGON((20 200,20 20,240 20,240 200,20 200),(130 110,60 40,60 180,130 110),(130 180,130 40,200 110,130 180))'::geometry as b) as f;
SELECT '213', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,130 110,170 110)'::geometry as a, 'POLYGON((20 200,20 20,240 20,240 200,20 200),(130 110,60 40,60 180,130 110),(130 180,130 40,200 110,130 180))'::geometry as b) as f;
SELECT '214', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,130 110,180 110)'::geometry as a, 'POLYGON((20 200,240 200,240 20,20 20,20 200),(130 110,60 180,60 40,130 110),(130 110,200 40,200 180,130 110))'::geometry as b) as f;
SELECT '215', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,130 110,180 110)'::geometry as a, 'POLYGON((20 200,20 20,240 20,240 200,20 200),(60 180,130 110,60 40,60 180),(130 110,200 40,200 180,130 110))'::geometry as b) as f;
SELECT '216', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 110,130 110,170 110)'::geometry as a, 'POLYGON((20 200,20 20,240 20,240 200,20 200),(130 110,60 40,60 180,130 110),(130 180,130 40,200 110,130 180))'::geometry as b) as f;
SELECT '217', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(160 70,320 230)'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '218', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(160 70,200 110,280 190,320 230)'::geometry as a, 'MULTIPOLYGON(((140 110,260 110,170 20,50 20,140 110)),((300 270,420 270,340 190,220 190,300 270)))'::geometry as b) as f;
SELECT '219', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(70 50,70 150)'::geometry as a, 'MULTIPOLYGON(((0 0,0 100,140 100,140 0,0 0)),((20 170,70 100,130 170,20 170)))'::geometry as b) as f;
SELECT '220', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,20 200,200 200,110 110)'::geometry as a, 'POLYGON((20 20,200 20,110 110,20 20))'::geometry as b) as f;
SELECT '221', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(150 70,160 110,200 60,150 70)'::geometry as a, 'POLYGON((20 20,200 20,110 110,20 20))'::geometry as b) as f;
SELECT '222', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 60,120 40,120 70,80 60)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))'::geometry as b) as f;
SELECT '223', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,200 20,110 110,20 20)'::geometry as a, 'POLYGON((20 20,200 20,110 110,20 20))'::geometry as b) as f;
SELECT '224', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 90,170 30,50 30,110 90)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))'::geometry as b) as f;
SELECT '225', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,170 50,170 110,110 110)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))'::geometry as b) as f;
SELECT '226', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 90,70 50,130 50,110 90)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))'::geometry as b) as f;
SELECT '227', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 60,20 150,200 150,110 60)'::geometry as a, 'POLYGON((20 20,200 20,110 110,20 20))'::geometry as b) as f;
SELECT '228', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 130,110 70,200 100,110 130)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,50 30,170 30,110 90))'::geometry as b) as f;
SELECT '229', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 90,160 40,60 40,110 90)'::geometry as a, 'POLYGON((20 20,200 20,110 110,20 20))'::geometry as b) as f;
SELECT '230', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 100,40 30,180 30,110 100)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))'::geometry as b) as f;
SELECT '231', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,180 30,40 30,110 110)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))'::geometry as b) as f;
SELECT '232', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 90,180 30,40 30,110 90)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))'::geometry as b) as f;
SELECT '233', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 90,50 30,180 30,110 90)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110),(110 90,60 40,160 40,110 90))'::geometry as b) as f;
SELECT '234', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 200,200 110,110 200)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '235', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 200,110 110,20 200,20 110,200 110)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '236', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,20 110,200 110,50 110,110 170)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '237', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,20 200,110 200,110 110,200 200)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '238', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,170 50,20 200,20 110,200 110)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '239', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,180 40,110 40,110 180)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '240', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 60,50 30,170 30,90 70)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '241', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,180 40,110 40,110 110,70 40)'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '242', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(230 70,170 120,190 60,140 60,170 120,270 90)'::geometry as a, 'POLYGON((150 150,410 150,280 20,20 20,150 150),(170 120,330 120,260 50,100 50,170 120))'::geometry as b) as f;
SELECT '243', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(200 200,110 110,20 210,110 110))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '244', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(60 180,60 110,160 110,110 110))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '245', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(200 200,110 110,20 200,110 200,110 110))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '246', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(110 50,110 170,110 70,110 150,200 150))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '247', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(50 110,170 110,110 170,110 50,110 170,110 50))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '248', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(110 60,110 160,200 160))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '249', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(110 60,110 160,200 160))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '250', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((110 100,40 30,180 30),(170 30,110 90,50 30))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '251', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((110 110,60 40,70 20,150 20,170 40),(180 30,40 30,110 80))'::geometry as a, 'POLYGON((110 110,200 20,20 20,110 110))'::geometry as b) as f;
SELECT '252', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110,200 160),(110 110,200 110,200 70,20 150))'::geometry as a, 'MULTIPOLYGON(((110 110,20 20,200 20,110 110)),((110 110,20 200,200 200,110 110)))'::geometry as b) as f;
SELECT '253', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 160,70 110,150 110,200 160),(110 110,20 110,50 80,70 110,200 110))'::geometry as a, 'MULTIPOLYGON(((110 110,20 20,200 20,110 110)),((110 110,20 200,200 200,110 110)))'::geometry as b) as f;
SELECT '254', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 110,200 110),(110 110,20 170,20 130,200 90))'::geometry as a, 'MULTIPOLYGON(((110 110,20 20,200 20,110 110)),((110 110,20 200,200 200,110 110)))'::geometry as b) as f;
SELECT '255', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,0 50,50 50,50 0,0 0)'::geometry as a, 'MULTILINESTRING((0 0,0 50),(0 50,50 50),(50 50,50 0),(50 0,0 0))'::geometry as b) as f;
SELECT '256', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 180,140 180)'::geometry as a, 'MULTIPOLYGON(((20 320,180 320,180 180,20 180,20 320)),((20 180,20 80,180 80,180 180,20 180)))'::geometry as b) as f;
SELECT '257', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 180,140 180)'::geometry as a, 'MULTIPOLYGON(((20 320,180 320,180 180,20 180,20 320)),((60 180,60 80,180 80,180 180,60 180)))'::geometry as b) as f;
SELECT '258', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(0 0,60 0,60 60,60 0,120 0)'::geometry as a, 'MULTILINESTRING((0 0,60 0),(60 0,120 0),(60 0,60 60))'::geometry as b) as f;
SELECT '259', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,120 120)'::geometry as a, 'LINESTRING(40 40,60 120)'::geometry as b) as f;
SELECT '260', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,120 120)'::geometry as a, 'LINESTRING(60 240,40 40)'::geometry as b) as f;
SELECT '261', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,180 180)'::geometry as a, 'LINESTRING(120 120,20 200)'::geometry as b) as f;
SELECT '262', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,120 120)'::geometry as a, 'LINESTRING(60 240,120 120)'::geometry as b) as f;
SELECT '263', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,180 180)'::geometry as a, 'LINESTRING(20 180,140 140)'::geometry as b) as f;
SELECT '264', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,120 120)'::geometry as a, 'LINESTRING(40 120,120 40)'::geometry as b) as f;
SELECT '265', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100)'::geometry as a, 'LINESTRING(40 40,100 100)'::geometry as b) as f;
SELECT '266', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100)'::geometry as a, 'LINESTRING(100 100,40 40)'::geometry as b) as f;
SELECT '267', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,120 120)'::geometry as a, 'LINESTRING(40 120,120 160)'::geometry as b) as f;
SELECT '268', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,180 180)'::geometry as a, 'LINESTRING(20 20,180 180)'::geometry as b) as f;
SELECT '269', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,180 180)'::geometry as a, 'LINESTRING(20 20,110 110)'::geometry as b) as f;
SELECT '270', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,180 180)'::geometry as a, 'LINESTRING(50 50,140 140)'::geometry as b) as f;
SELECT '271', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(180 180,40 40)'::geometry as a, 'LINESTRING(120 120,260 260)'::geometry as b) as f;
SELECT '272', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,180 180)'::geometry as a, 'LINESTRING(260 260,120 120)'::geometry as b) as f;
SELECT '273', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,180 180)'::geometry as a, 'LINESTRING(120 120,260 260)'::geometry as b) as f;
SELECT '274', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(40 40,20 100,40 160,20 200)'::geometry as b) as f;
SELECT '275', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(20 200,40 160,20 100,40 40)'::geometry as b) as f;
SELECT '276', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 240,200 120,100 100,40 40)'::geometry as a, 'LINESTRING(20 200,40 160,20 100,40 40)'::geometry as b) as f;
SELECT '277', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 60,60 230,140 230,250 160)'::geometry as a, 'LINESTRING(20 20,60 60,250 160,310 230)'::geometry as b) as f;
SELECT '278', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 60,60 230,140 230,250 160)'::geometry as a, 'LINESTRING(20 20,110 110,200 110,320 230)'::geometry as b) as f;
SELECT '279', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,60 250,360 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '280', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,60 250,360 210)'::geometry as a, 'LINESTRING(360 210,310 160,110 160,60 110)'::geometry as b) as f;
SELECT '281', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(160 160,240 240)'::geometry as b) as f;
SELECT '282', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(240 240,160 160)'::geometry as b) as f;
SELECT '283', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 60,60 230,140 230,250 160)'::geometry as a, 'LINESTRING(60 150,110 100,170 100,110 230)'::geometry as b) as f;
SELECT '284', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 60,60 230,140 230,250 160)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '285', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(200 120,200 190,150 240,200 240)'::geometry as b) as f;
SELECT '286', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(200 240,150 240,200 200,200 120)'::geometry as b) as f;
SELECT '287', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 60,60 230,140 230,250 160)'::geometry as a, 'LINESTRING(60 230,80 140,120 140,140 230)'::geometry as b) as f;
SELECT '288', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,200 110,250 160,300 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '289', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,200 110,250 160,300 210,360 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '290', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,220 110,250 160,280 110)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '291', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,150 110,200 160,250 110,360 110,360 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '292', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 160,160 110,220 110,250 160,250 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '293', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 160,160 110,190 110,230 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '294', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 160,160 110,200 110,230 160,260 210,360 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '295', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 160,160 110,200 110,230 160,260 210,360 210,380 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '296', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 160,160 110,200 110,230 160,260 210,380 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '297', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 160,160 110,200 110,250 160,250 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '298', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 160,180 110,250 160,320 110)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '299', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(140 160,180 80,220 160,250 80)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '300', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,130 190)'::geometry as a, 'LINESTRING(20 130,70 130,160 40)'::geometry as b) as f;
SELECT '301', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,130 190)'::geometry as a, 'LINESTRING(40 160,40 100,110 40,170 40)'::geometry as b) as f;
SELECT '302', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 110,180 160,230 110,280 160,330 110)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '303', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,130 190)'::geometry as a, 'LINESTRING(30 140,80 140,100 100,200 30)'::geometry as b) as f;
SELECT '304', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,110 160,180 110,250 160,250 110)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '305', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,80 80,160 80,240 80,300 140)'::geometry as a, 'LINESTRING(20 60,60 60,60 140,80 80,100 20,140 140,180 20,200 80,220 20,240 80,300 80,270 110,200 110)'::geometry as b) as f;
SELECT '306', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,230 20,20 30,170 30,20 40,230 40,20 50,230 60,60 60,230 70,20 70,180 80,60 80,230 90,20 90,230 100,30 100,210 110,20 110,80 120,20 130,170 130,90 120,230 130,170 140,230 140,80 150,160 140,20 140,70 150,20 150,230 160,80 160,230 170,20 160,180 170,20 170,230 180,20 180,40 190,230 190,20 200,230 200)'::geometry as a, 'LINESTRING(30 210,30 60,40 210,40 30,50 190,50 20,60 160,60 50,70 220,70 50,80 20,80 210,90 50,90 150,100 30,100 210,110 20,110 190,120 50,120 180,130 210,120 20,140 210,130 50,150 210,130 20,160 210,140 30,170 210,150 20,180 210,160 20,190 210,180 80,170 50,170 20,180 70,180 20,190 190,190 30,200 210,200 30,210 210,210 20,220 150,220 20)'::geometry as b) as f;
SELECT '307', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as b) as f;
SELECT '308', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(80 240,200 120,100 100,40 40)'::geometry as b) as f;
SELECT '309', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(80 240,120 200,200 120,100 100,80 80,40 40)'::geometry as b) as f;
SELECT '310', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(260 210,240 130,280 120,260 40)'::geometry as b) as f;
SELECT '311', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 20,20 20,20 160,210 160,210 20,110 20,50 120,120 150,200 150)'::geometry as a, 'LINESTRING(140 130,100 110,120 60,170 60)'::geometry as b) as f;
SELECT '312', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '313', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,110 160,310 160,360 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as b) as f;
SELECT '314', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as a, 'LINESTRING(60 110,110 160,250 160)'::geometry as b) as f;
SELECT '315', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as a, 'LINESTRING(110 160,310 160,340 190)'::geometry as b) as f;
SELECT '316', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as a, 'LINESTRING(140 160,250 160,310 160,340 190)'::geometry as b) as f;
SELECT '317', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 110,110 160,250 160,310 160,360 210)'::geometry as a, 'LINESTRING(110 160,250 160,310 160)'::geometry as b) as f;
SELECT '318', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(200 120,100 100,40 40,140 80,200 40)'::geometry as b) as f;
SELECT '319', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(280 240,240 140,200 120,100 100,40 40)'::geometry as b) as f;
SELECT '320', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(80 190,140 140,40 40)'::geometry as b) as f;
SELECT '321', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(240 200,200 260,80 240,140 180)'::geometry as b) as f;
SELECT '322', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(140 180,80 240,200 260,240 200)'::geometry as b) as f;
SELECT '323', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(280 240,240 140,200 120,80 240)'::geometry as b) as f;
SELECT '324', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,80 80,160 80,240 80,300 140)'::geometry as a, 'LINESTRING(20 80,120 80,200 80,260 20)'::geometry as b) as f;
SELECT '325', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(100 100,200 120,240 140,280 240)'::geometry as b) as f;
SELECT '326', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 40,100 100,200 120,80 240)'::geometry as a, 'LINESTRING(280 240,240 140,200 120,100 100)'::geometry as b) as f;
SELECT '327', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,80 80,160 80,240 80,300 140)'::geometry as a, 'LINESTRING(80 20,80 80,240 80,300 20)'::geometry as b) as f;
SELECT '328', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,80 80,160 80,240 80,300 140)'::geometry as a, 'LINESTRING(20 80,80 80,120 80,140 140,160 80,200 80,220 20,240 80,270 110,300 80)'::geometry as b) as f;
SELECT '329', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,20 180,180 180)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '330', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 100,180 100,100 180)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '331', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 40,100 160,180 160)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '332', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 100,100 100,180 100,100 180)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '333', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,160 40)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '334', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,180 20)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '335', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 60,100 100,140 60)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '336', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,190 10,190 100)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '337', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,160 40,160 100)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '338', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(60 140,160 40,160 140)'::geometry as a, 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as b) as f;
SELECT '339', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(80 80,20 80,140 80,80 20,80 140)'::geometry as b) as f;
SELECT '340', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(80 80,20 80,140 80)'::geometry as b) as f;
SELECT '341', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(80 80,140 80,80 20,80 140)'::geometry as b) as f;
SELECT '342', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(80 80,20 80,140 80,80 20,80 80)'::geometry as b) as f;
SELECT '343', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(80 80,20 80,140 80,80 80)'::geometry as b) as f;
SELECT '344', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(80 80,20 80,20 140,140 20,80 20,80 80)'::geometry as b) as f;
SELECT '345', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(20 140,140 20,100 20,100 80)'::geometry as b) as f;
SELECT '346', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(140 80,20 80,120 80,80 20,80 140)'::geometry as b) as f;
SELECT '347', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(140 80,20 80,140 80)'::geometry as b) as f;
SELECT '348', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(140 80,20 80,80 140,80 20)'::geometry as b) as f;
SELECT '349', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(140 80,80 80,20 80,50 140,50 60)'::geometry as b) as f;
SELECT '350', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(140 80,20 80,120 80,80 20,80 80,80 140)'::geometry as b) as f;
SELECT '351', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(140 80,20 80,80 80,140 80)'::geometry as b) as f;
SELECT '352', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 20,140 140)'::geometry as a, 'LINESTRING(140 80,20 80,80 140,80 80,80 20)'::geometry as b) as f;
SELECT '353', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(130 150,220 150,220 240)'::geometry as a, 'LINESTRING(130 240,130 150,220 20,50 20,130 150)'::geometry as b) as f;
SELECT '354', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(30 150,130 150,250 150)'::geometry as a, 'LINESTRING(130 240,130 150,220 20,50 20,130 150)'::geometry as b) as f;
SELECT '355', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(30 150,250 150)'::geometry as a, 'LINESTRING(130 240,130 150,220 20,50 20,130 150)'::geometry as b) as f;
SELECT '356', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(30 150,130 150,250 150)'::geometry as a, 'LINESTRING(130 240,130 20,30 20,130 150)'::geometry as b) as f;
SELECT '357', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(30 150,250 150)'::geometry as a, 'LINESTRING(120 240,120 20,20 20,120 170)'::geometry as b) as f;
SELECT '358', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(200 200,20 20,200 20,110 110,20 200,110 200,110 110)'::geometry as a, 'LINESTRING(110 110,200 110)'::geometry as b) as f;
SELECT '359', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,110 110,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '360', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 110,200 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,110 110,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '361', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(200 200,20 20,200 20,110 110,20 200,110 200,110 110)'::geometry as a, 'LINESTRING(20 110,200 110)'::geometry as b) as f;
SELECT '362', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(90 200,90 130,110 110,150 200)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,20 200,20 130,90 130)'::geometry as b) as f;
SELECT '363', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(200 110,110 110,90 130,90 200)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,20 200,20 130,90 130)'::geometry as b) as f;
SELECT '364', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(80 80,150 80,210 80)'::geometry as a, 'MULTILINESTRING((20 20,140 140),(20 140,140 20))'::geometry as b) as f;
SELECT '365', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 80,160 200,260 20,40 80)'::geometry as a, 'LINESTRING(40 80,160 200,260 20,40 80)'::geometry as b) as f;
SELECT '366', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 80,160 200,260 20,40 80)'::geometry as a, 'LINESTRING(40 80,260 20,160 200,40 80)'::geometry as b) as f;
SELECT '367', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 80,160 200,260 20,40 80)'::geometry as a, 'LINESTRING(260 20,40 80,160 200,260 20)'::geometry as b) as f;
SELECT '368', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 80,160 200,260 20,40 80)'::geometry as a, 'LINESTRING(100 140,160 200,260 20,40 80,100 140)'::geometry as b) as f;
SELECT '369', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as a, 'LINESTRING(100 100,180 180,20 180,100 100)'::geometry as b) as f;
SELECT '370', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 150,40 40,150 40,150 150,40 150)'::geometry as a, 'LINESTRING(40 150,150 40,170 20,170 190,40 150)'::geometry as b) as f;
SELECT '371', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as a, 'LINESTRING(180 100,20 100,100 180,180 100)'::geometry as b) as f;
SELECT '372', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(100 100,180 20,20 20,100 100)'::geometry as a, 'LINESTRING(180 180,100 100,20 180,180 180)'::geometry as b) as f;
SELECT '373', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 180,100 100,20 20,20 180)'::geometry as a, 'LINESTRING(100 20,100 180,180 100,100 20)'::geometry as b) as f;
SELECT '374', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 150,40 40,150 40,150 150,40 150)'::geometry as a, 'LINESTRING(170 20,20 170,170 170,170 20)'::geometry as b) as f;
SELECT '375', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 150,40 40,150 40,150 150,40 150)'::geometry as a, 'LINESTRING(40 150,150 150,90 210,40 150)'::geometry as b) as f;
SELECT '376', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 150,40 40,150 40,150 150,40 150)'::geometry as a, 'LINESTRING(20 150,170 150,90 230,20 150)'::geometry as b) as f;
SELECT '377', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(40 150,40 40,150 40,150 150,40 150)'::geometry as a, 'LINESTRING(40 150,150 150,150 40,20 40,20 150,40 150)'::geometry as b) as f;
SELECT '378', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 20,20 20,110 110)'::geometry as a, 'LINESTRING(110 110,200 200,110 110,20 200,20 110,200 110)'::geometry as b) as f;
SELECT '379', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 20,20 20,110 110)'::geometry as a, 'LINESTRING(110 110,20 110,200 110,50 110,110 170)'::geometry as b) as f;
SELECT '380', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 20,20 20,110 110)'::geometry as a, 'LINESTRING(110 110,20 200,110 200,110 110,200 200)'::geometry as b) as f;
SELECT '381', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 20,20 20,110 110)'::geometry as a, 'LINESTRING(200 20,20 200,200 200,110 110,110 40)'::geometry as b) as f;
SELECT '382', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,200 20,20 20,110 110)'::geometry as a, 'LINESTRING(200 20,20 200,200 200,20 20)'::geometry as b) as f;
SELECT '383', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(110 110,20 110,110 20,20 20,110 110)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,200 110,110 110)'::geometry as b) as f;
SELECT '384', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 120,120 120,20 20,120 20,20 120)'::geometry as a, 'LINESTRING(170 100,70 100,170 170,70 170,170 100)'::geometry as b) as f;
SELECT '385', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 110,110 110,20 20,110 20,20 110)'::geometry as a, 'LINESTRING(110 160,70 110,60 160,20 130,110 160)'::geometry as b) as f;
SELECT '386', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 200,200 200,20 20,200 20,20 200)'::geometry as a, 'LINESTRING(20 110,200 110,200 160,20 60,20 110)'::geometry as b) as f;
SELECT '387', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 110,110 110,20 20,110 20,20 110)'::geometry as a, 'LINESTRING(200 200,110 110,200 110,110 200,200 200)'::geometry as b) as f;
SELECT '388', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'LINESTRING(20 120,120 120,20 20,120 20,20 120)'::geometry as a, 'LINESTRING(220 120,120 20,220 20,120 120,220 120)'::geometry as b) as f;
SELECT '389', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((70 20,20 90,70 170),(70 170,120 90,70 20))'::geometry as a, 'MULTILINESTRING((70 20,20 90,70 170),(70 170,120 90,70 20))'::geometry as b) as f;
SELECT '390', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as b) as f;
SELECT '391', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 140,90 60,90 20),(170 20,130 20,20 20))'::geometry as b) as f;
SELECT '392', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(170 60,90 20,20 60),(130 100,130 60,90 20,50 90))'::geometry as b) as f;
SELECT '393', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(130 140,130 60,90 20,20 90,90 20,130 60,170 60))'::geometry as b) as f;
SELECT '394', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(170 60,90 20,20 60))'::geometry as b) as f;
SELECT '395', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(170 60,90 20,20 60),(130 100,90 20))'::geometry as b) as f;
SELECT '396', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(170 60,90 20,20 60),(120 100,170 100,90 20))'::geometry as b) as f;
SELECT '397', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(170 60,90 20,20 60),(120 100,170 100,90 20))'::geometry as b) as f;
SELECT '398', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(130 140,130 60,90 20,20 90,90 20))'::geometry as b) as f;
SELECT '399', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 20,170 20),(90 20,90 80,90 140))'::geometry as a, 'MULTILINESTRING((90 20,170 100,170 140),(170 60,90 20,20 60,20 140,90 20))'::geometry as b) as f;
SELECT '400', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 90,20 160),(90 160,90 20))'::geometry as a, 'MULTILINESTRING((160 160,90 90,160 20),(160 120,120 120,90 90,160 60))'::geometry as b) as f;
SELECT '401', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 90,20 160),(90 160,90 20))'::geometry as a, 'MULTILINESTRING((160 160,90 90,160 20),(160 120,120 120,90 90,120 60,160 60))'::geometry as b) as f;
SELECT '402', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTILINESTRING((20 20,90 90,20 160),(90 160,90 20))'::geometry as a, 'MULTILINESTRING((160 160,90 90,160 20),(160 120,90 90,160 60))'::geometry as b) as f;
SELECT '403', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '404', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(70 170)'::geometry as a, 'POLYGON((110 230,80 160,20 160,20 20,200 20,200 160,140 160,110 230))'::geometry as b) as f;
SELECT '405', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 130)'::geometry as a, 'POLYGON((20 160,80 160,110 100,140 160,200 160,200 20,20 20,20 160))'::geometry as b) as f;
SELECT '406', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(100 70)'::geometry as a, 'POLYGON((20 150,100 150,40 50,170 50,110 150,190 150,190 20,20 20,20 150))'::geometry as b) as f;
SELECT '407', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(100 70)'::geometry as a, 'POLYGON((20 150,100 150,40 50,160 50,100 150,180 150,180 20,20 20,20 150))'::geometry as b) as f;
SELECT '408', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(60 120)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '409', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 120)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '410', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(160 120)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '411', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(100 150)'::geometry as a, 'POLYGON((20 150,100 150,40 50,160 50,100 150,180 150,180 20,20 20,20 150))'::geometry as b) as f;
SELECT '412', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(100 80)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '413', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(60 160)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '414', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(190 90)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '415', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(190 190)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '416', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(360 20)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '417', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(130 130)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '418', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(280 50)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '419', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(150 100)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '420', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(100 50)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '421', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(140 120)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '422', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(190 50)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(90 50,150 110,190 50,90 50),(190 50,230 110,290 50,190 50))'::geometry as b) as f;
SELECT '423', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(180 90)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(180 140,180 40,80 40,180 140),(180 90,210 140,310 40,230 40,180 90))'::geometry as b) as f;
SELECT '424', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 80,110 160,20 160)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '425', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 80,60 120,20 160)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '426', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(10 80,110 170,110 120)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '427', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(10 80,110 170,160 120)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '428', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 120,60 120,110 120,160 120,200 120)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '429', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 120,110 120,160 120)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '430', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 120,160 120,160 40,60 40)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '431', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 150,60 120,110 80)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '432', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(110 80,160 120,200 160)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '433', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(110 80,110 120,110 160)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '434', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(110 170,110 80)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '435', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 120,160 120,110 80,110 170)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '436', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(90 80,130 80)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '437', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(60 120,160 120,110 80)'::geometry as a, 'POLYGON((60 120,60 40,160 40,160 120,60 120))'::geometry as b) as f;
SELECT '438', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 170,40 90,130 170)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '439', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(90 170,280 170,190 90)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '440', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(190 110,150 70,230 70)'::geometry as a, 'POLYGON((190 190,360 20,20 20,190 190),(280 50,100 50,190 140,280 50))'::geometry as b) as f;
SELECT '441', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(100 100)'::geometry as a, 'MULTIPOLYGON(((20 100,20 20,100 20,100 100,20 100)),((100 180,100 100,180 100,180 180,100 180)))'::geometry as b) as f;
SELECT '442', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 100)'::geometry as a, 'MULTIPOLYGON(((20 100,20 20,100 20,100 100,20 100)),((100 180,100 100,180 100,180 180,100 180)))'::geometry as b) as f;
SELECT '443', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(60 100)'::geometry as a, 'MULTIPOLYGON(((20 100,20 20,100 20,100 100,20 100)),((100 180,100 100,180 100,180 180,100 180)))'::geometry as b) as f;
SELECT '444', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'MULTIPOLYGON(((110 110,20 200,200 200,110 110),(110 110,80 180,140 180,110 110)),((110 110,20 20,200 20,110 110),(110 110,80 40,140 40,110 110)))'::geometry as b) as f;
SELECT '445', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 200)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '446', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 80)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '447', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(340 240)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '448', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(230 150)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '449', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(160 150)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '450', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 150)'::geometry as a, 'LINESTRING(150 150,20 20,280 20,150 150)'::geometry as b) as f;
SELECT '451', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(150 80)'::geometry as a, 'LINESTRING(150 150,20 20,280 20,150 150)'::geometry as b) as f;
SELECT '452', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(150 150)'::geometry as a, 'LINESTRING(150 150,20 20,280 20,150 150)'::geometry as b) as f;
SELECT '453', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(100 20)'::geometry as a, 'LINESTRING(150 150,20 20,280 20,150 150)'::geometry as b) as f;
SELECT '454', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'LINESTRING(150 150,20 20,280 20,150 150)'::geometry as b) as f;
SELECT '455', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(220 220)'::geometry as a, 'LINESTRING(110 110,220 20,20 20,110 110,220 220)'::geometry as b) as f;
SELECT '456', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,220 20,20 20,110 110,220 220)'::geometry as b) as f;
SELECT '457', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,220 20,20 20,220 220)'::geometry as b) as f;
SELECT '458', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 20)'::geometry as a, 'LINESTRING(110 110,220 20,20 20,220 220)'::geometry as b) as f;
SELECT '459', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(220 20)'::geometry as a, 'LINESTRING(110 110,220 20,20 20,220 220)'::geometry as b) as f;
SELECT '460', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 20)'::geometry as a, 'LINESTRING(220 220,20 20,220 20,110 110)'::geometry as b) as f;
SELECT '461', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'LINESTRING(220 220,20 20,220 20,110 110)'::geometry as b) as f;
SELECT '462', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 110)'::geometry as a, 'LINESTRING(20 200,20 20,110 20,20 110,110 200)'::geometry as b) as f;
SELECT '463', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 200)'::geometry as a, 'LINESTRING(20 200,200 20,20 20,200 200)'::geometry as b) as f;
SELECT '464', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,200 20,140 20,140 80,80 140,20 140)'::geometry as b) as f;
SELECT '465', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,200 20,20 20,200 200)'::geometry as b) as f;
SELECT '466', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(80 140)'::geometry as a, 'LINESTRING(20 200,110 110,200 20,140 20,140 80,110 110,80 140,20 140)'::geometry as b) as f;
SELECT '467', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,110 110,200 20,140 20,140 80,110 110,80 140,20 140)'::geometry as b) as f;
SELECT '468', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,200 20,140 20,140 80,110 110,80 140,20 140)'::geometry as b) as f;
SELECT '469', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,110 110,200 20,20 20,110 110,200 200)'::geometry as b) as f;
SELECT '470', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,200 20,20 20,110 110,200 200)'::geometry as b) as f;
SELECT '471', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,110 110,20 20,200 20,110 110,200 200)'::geometry as b) as f;
SELECT '472', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,110 110,200 20,140 20,140 80,110 110,80 140,20 140)'::geometry as b) as f;
SELECT '473', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,200 20,140 20,140 80,110 110,80 140,20 140)'::geometry as b) as f;
SELECT '474', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,200 20,140 20,140 80,80 140,20 140)'::geometry as b) as f;
SELECT '475', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,110 110,200 20,20 20,110 110,200 200)'::geometry as b) as f;
SELECT '476', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,200 20,20 20,110 110,200 200)'::geometry as b) as f;
SELECT '477', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,200 20,20 20,200 200)'::geometry as b) as f;
SELECT '478', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,110 110,20 20,200 20,110 110,200 200)'::geometry as b) as f;
SELECT '479', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,110 200,20 200,200 20,200 110,110 110,200 200)'::geometry as b) as f;
SELECT '480', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,110 110,20 20,200 20,110 110,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '481', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,110 110,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '482', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '483', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,110 110,200 20,20 20,110 110,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '484', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,20 20,20 110,110 110,20 200,110 200,110 110)'::geometry as b) as f;
SELECT '485', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 160)'::geometry as a, 'LINESTRING(110 160,200 250,110 250,110 160,110 110,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '486', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 160)'::geometry as a, 'LINESTRING(110 160,200 250,110 250,110 110,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '487', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 160,200 250,110 250,110 160,110 110,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '488', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 160,200 250,110 250,110 160,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '489', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,110 110,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '490', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '491', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(140 200)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,110 110,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '492', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 200)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,110 110,110 20,20 20,110 110)'::geometry as b) as f;
SELECT '493', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,110 110,110 20,200 20,110 110)'::geometry as b) as f;
SELECT '494', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(140 200)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,110 110,110 20,200 20,110 110)'::geometry as b) as f;
SELECT '495', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 200)'::geometry as a, 'LINESTRING(110 110,200 200,110 200,110 110,110 20,200 20,110 110)'::geometry as b) as f;
SELECT '496', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,20 130,20 200,90 130,200 20,20 20,200 200)'::geometry as b) as f;
SELECT '497', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(90 130,20 130,20 200,90 130,200 20,20 20,200 200)'::geometry as b) as f;
SELECT '498', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,20 130,20 200,200 20,20 20,200 200)'::geometry as b) as f;
SELECT '499', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(90 130,20 130,20 200,200 20,20 20,200 200)'::geometry as b) as f;
SELECT '500', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,90 130,20 200,20 130,90 130)'::geometry as b) as f;
SELECT '501', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,90 130,20 200,20 130,90 130)'::geometry as b) as f;
SELECT '502', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,20 200,20 130,90 130)'::geometry as b) as f;
SELECT '503', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,20 200,20 130,90 130)'::geometry as b) as f;
SELECT '504', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,20 130,20 200,110 110,200 20,20 20,110 110,200 200,200 130,110 110)'::geometry as b) as f;
SELECT '505', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,20 130,20 200,200 20,20 20,200 200,200 130,110 110)'::geometry as b) as f;
SELECT '506', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,80 200,20 200,110 110,200 20,20 20,110 110,200 200,140 200,110 110)'::geometry as b) as f;
SELECT '507', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 110,80 200,20 200,200 20,20 20,200 200,140 200,110 110)'::geometry as b) as f;
SELECT '508', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,20 20,200 20,20 200,200 200)'::geometry as b) as f;
SELECT '509', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,110 110,20 20,200 20,110 110,20 200,200 200)'::geometry as b) as f;
SELECT '510', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(200 200,110 110,200 20,20 20,110 110,20 200,200 200)'::geometry as b) as f;
SELECT '511', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,20 130,20 200,90 130,110 110,200 20,20 20,110 110,200 200,90 130)'::geometry as b) as f;
SELECT '512', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,20 130,20 200,110 110,200 20,20 20,110 110,200 200,90 130)'::geometry as b) as f;
SELECT '513', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,90 200,20 200,90 130,110 110,200 20,20 20,110 110,200 200,90 130)'::geometry as b) as f;
SELECT '514', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,90 200,20 200,200 20,20 20,200 200,90 130)'::geometry as b) as f;
SELECT '515', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,90 200,20 200,110 110,200 20,20 20,110 110,200 200,90 130)'::geometry as b) as f;
SELECT '516', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(90 130)'::geometry as a, 'LINESTRING(90 130,90 200,20 200,200 20,20 20,200 200,90 130)'::geometry as b) as f;
SELECT '517', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(90 130,90 200,20 200,200 20,20 20,200 200,90 130)'::geometry as b) as f;
SELECT '518', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 200)'::geometry as a, 'LINESTRING(110 200,110 110,20 20,200 20,110 110,110 200,200 200)'::geometry as b) as f;
SELECT '519', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 150)'::geometry as a, 'LINESTRING(110 200,110 110,20 20,200 20,110 110,110 200,200 200)'::geometry as b) as f;
SELECT '520', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 200,110 110,20 20,200 20,110 110,110 200,200 200)'::geometry as b) as f;
SELECT '521', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 200)'::geometry as a, 'LINESTRING(110 200,110 110,20 20,200 20,110 110,110 200)'::geometry as b) as f;
SELECT '522', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 150)'::geometry as a, 'LINESTRING(110 200,110 110,20 20,200 20,110 110,110 200)'::geometry as b) as f;
SELECT '523', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(110 200,110 110,20 20,200 20,110 110,110 200)'::geometry as b) as f;
SELECT '524', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 150)'::geometry as a, 'LINESTRING(20 200,110 200,110 110,20 20,200 20,110 110,110 200,200 200)'::geometry as b) as f;
SELECT '525', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 110)'::geometry as a, 'LINESTRING(20 200,110 200,110 110,20 20,200 20,110 110,110 200,200 200)'::geometry as b) as f;
SELECT '526', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(110 200)'::geometry as a, 'LINESTRING(20 200,110 200,110 110,20 20,200 20,110 110,110 200,200 200)'::geometry as b) as f;
SELECT '527', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(50 250,90 220,130 190)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '528', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(180 180,230 130,280 80)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '529', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(50 120,90 80,130 40)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '530', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(300 280,340 240,380 200)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '531', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(230 150,260 120,290 90)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '532', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(200 190,240 150,270 110)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '533', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(160 150,190 120,220 90)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '534', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(120 190,160 150,200 110)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '535', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(90 80,160 150,340 240)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '536', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(90 80,160 150,300 150)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '537', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(90 80,160 150,240 150)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '538', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(90 80,130 120,210 150)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '539', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(130 120,210 150,340 200)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '540', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(160 150,240 150,340 210)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '541', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(160 150,300 150,340 150)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '542', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(160 150,240 150,340 240)'::geometry as a, 'LINESTRING(90 80,160 150,300 150,340 150,340 240)'::geometry as b) as f;
SELECT '543', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'POINT(20 20)'::geometry as b) as f;
SELECT '544', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'POINT(40 60)'::geometry as b) as f;
SELECT '545', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(40 40)'::geometry as a, 'MULTIPOINT(20 20,80 80,20 120)'::geometry as b) as f;
SELECT '546', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'POINT(20 20)'::geometry as a, 'MULTIPOINT(20 20,80 80,20 120)'::geometry as b) as f;
SELECT '547', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,80 60,120 100)'::geometry as a, 'MULTIPOINT(40 40,80 60,120 100)'::geometry as b) as f;
SELECT '548', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,80 60,120 100)'::geometry as a, 'MULTIPOINT(40 40,120 100,80 60)'::geometry as b) as f;
SELECT '549', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(40 40,60 100,100 60,120 120)'::geometry as a, 'MULTIPOINT(20 120,60 60,100 100,140 40)'::geometry as b) as f;
SELECT '550', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 20,80 70,140 120,200 170)'::geometry as a, 'MULTIPOINT(20 20,80 70,140 120,200 170)'::geometry as b) as f;
SELECT '551', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 20,140 120,80 70,200 170)'::geometry as a, 'MULTIPOINT(80 70,20 20,200 170,140 120)'::geometry as b) as f;
SELECT '552', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(20 20,80 70,140 120,200 170)'::geometry as a, 'MULTIPOINT(80 70,140 120)'::geometry as b) as f;
SELECT '553', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(80 70,20 20,200 170,140 120)'::geometry as a, 'MULTIPOINT(140 120,80 70)'::geometry as b) as f;
SELECT '554', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(80 70,20 20,200 170,140 120)'::geometry as a, 'MULTIPOINT(80 170,140 120,200 80)'::geometry as b) as f;
SELECT '555', st_relate(a,b,1) as r1, st_relate(a,b,2) as r2, st_relate(a,b,3) as r3, st_relate(a,b,4) as r4 FROM (select 'MULTIPOINT(80 70,20 20,200 170,140 120)'::geometry as a, 'MULTIPOINT(80 170,140 120,200 80,80 70)'::geometry as b) as f;
SELECT st_relate('POINT(0 0)', 'POINT(1 0)', 5);
View Git Blame Copy Permalink