33 | | select '#4025', ST_DistanceCPA ( |
34 | | 'LINESTRING M ( |
35 | | 3002640.82925984 5833770.09678249 1180471354.482, |
36 | | 3003084.56741608 5833866.22147656 1180471411.791, |
37 | | 3003325.8165722 5833942.66399188 1180471442.914, |
38 | | 3003634.9521919 5834039.57644606 1180471482.436, |
39 | | 3003701.57229565 5833872.50949516 1180471494.55)'::geometry, |
40 | | 'LINESTRING M ( |
41 | | 2996311.19255982 5844593.73486637 1180471513.163, |
42 | | 2996310.72190852 5844712.60937002 1180471523.37, |
43 | | 2996311.81673704 5844916.90864168 1180471541.171)'::geometry |
44 | | ); |
| 33 | SELECT '#4037.1', ST_AsText(ST_Intersection('POLYGON((0 0, 10 10, 0 10, 10 0, 0 0))', ST_MakeEnvelope(2,2,8,8))); |