ST_RelateMatch — intersectionMattrixPattern1がintersectionMatrixPattern2を含む場合にTRUEを返します。
boolean ST_RelateMatch(
text intersectionMatrix, text intersectionMatrixPattern)
;
intersectionMatrixとintersectionMatrixPatternを取り、intersectionMatrixがintersectionMatrixPatternを満たす場合にTRUEを返します。詳細情報については「Dimensionally Extended 9 Intersection Model (DE-9IM)」を参照して下さい。
初出: 2.0.0 - GEOS 3.3.0以上が必要です。
SELECT ST_RelateMatch('101202FFF', 'TTTTTTFFF') ; -- 結果 -- t --example of common intersection matrix patterns and example matrices -- comparing relationships of involving one invalid geometry and ( a line and polygon that intersect at interior and boundary) SELECT mat.name, pat.name, ST_RelateMatch(mat.val, pat.val) As satisfied FROM ( VALUES ('Equality', 'T1FF1FFF1'), ('Overlaps', 'T*T***T**'), ('Within', 'T*F**F***'), ('Disjoint', 'FF*FF****') As pat(name,val) CROSS JOIN ( VALUES ('Self intersections (invalid)', '111111111'), ('IE2_BI1_BB0_BE1_EI1_EE2', 'FF2101102'), ('IB1_IE1_BB0_BE0_EI2_EI1_EE2', 'F11F00212') ) As mat(name,val);