1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE TABLE T_GEO ( GEO_NOM VARCHAR(16), GEO_OBJET GEOMETRY);
INSERT INTO T_GEO (GEO_NOM, GEO_OBJET)
VALUES ('Un polygone', 'POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))');
INSERT INTO T_GEO (GEO_NOM, GEO_OBJET)
VALUES ('Une ligne', 'LINESTRING(0 0, 1 1)');
SELECT ST_AsText(Intersection(T1.GEO_OBJET, T2.GEO_OBJET)) AS Inter
FROM T_GEO AS T1
CROSS JOIN T_GEO AS T2
WHERE T1.GEO_NOM LIKE '%polygone%'
AND T2.GEO_NOM LIKE '%ligne%';
inter
------------------------------
LINESTRING(0 0,1 1) |
Partager