ST_Relate ÇÔ¼ö´Â µÎ ±âÇÏÇÐÀ» ºñ±³ÇÏ¿© ±âÇÏÇеéÀÌ DE-9IM ÆÐÅÏ Çà·Ä ¹®ÀÚ¿¿¡ ÀÇÇØ ÁöÁ¤µÈ Á¶°ÇÀ» ÃæÁ·Çϸé 1(TRUE)À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 0(FALSE)ÀÌ ¸®Åϵ˴ϴÙ. ¼ú¾î ÇÔ¼ö¿¡¼ DE-9IM ÆÐÅÏ Çà·Ä¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
±¸¹®
db2gse.ST_Relate(g1 db2gse.ST_Geometry, g2 db2gse.ST_Geometry, patternMatrix CHAR(9))
¸®ÅÏ À¯Çü
Integer
¿¹
DE-9IM ÆÐÅÏ Çà·ÄÀº ±âÇÏÇÐÀ» ºñ±³Çϱâ À§ÇÑ ÀåÄ¡ÀÔ´Ï´Ù. ¿©·¯ °¡Áö À¯ÇüÀÇ Çà·ÄµéÀÌ ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, equals ÆÐÅÏ Çà·ÄÀº µÎ ±âÇÏÇÐÀÌ µ¿ÀÏÇÑÁö¸¦ ¾Ë·Á ÁÝ´Ï´Ù.
ÀÌ ¿¹¿¡¼ Ç¥ 57¿¡ Ç¥½ÃµÈ equals ÆÐÅÏ Çà·ÄÀº ¿ÞÂÊ¿¡¼
¿À¸¥ÂÊÀ¸·Î, À§¿¡¼ ¾Æ·¡ÂÊÀ¸·Î ¹®ÀÚ¿("T*F**FFF*")¿¡ ÀÐÇôÁý´Ï´Ù.
|
|
|
b
|
|
|
|
³»ºÎ
|
°æ°è
|
¿ÜºÎ
|
|
³»ºÎ
|
T
|
*
|
F
|
a
|
°æ°è
|
*
|
*
|
F
|
|
¿ÜºÎ
|
F
|
F
|
*
|
±× ´ÙÀ½, RELATE_TEST Å×À̺íÀÌ ´ÙÀ½ CREATE TABLE¹®À¸·Î ÀÛ¼ºµË´Ï´Ù.
CREATE TABLE RELATE_TEST (rid integer, g1 db2gse.ST_Geometry, g2 db2gse.ST_Geometry, g3 db2gse.ST_Geometry);
´ÙÀ½ÀÇ INSERT¹®Àº RELATE_TEST Å×ÀÌºí¿¡ »ùÇà ¼ºêŬ·¡½º¸¦ »ðÀÔÇÕ´Ï´Ù.
INSERT INTO RELATE_TEST VALUES( 1, db2gse.ST_PointFromText('point (10.02 20.01)', db2gse.coordref()..srid(0), db2gse.ST_PointFromText('point (10.02 20.01)', db2gse.coordref()..srid(0), db2gse.ST_PointFromText('point (30.01 20.01)', db2gse.coordref()..srid(0) )
´ÙÀ½ÀÇ SELECT¹®°ú ÇØ´ç °á°ú ¼¼Æ®´Â ±× geotypeÀÇ Â÷¿øÀ¸·Î GEOTYPE Ä÷³¿¡ ÀúÀåµÈ ¼ºêŬ·¡½º À̸§À» ³ª¿ÇÕ´Ï´Ù.
SELECT rid, relate(g1,g2, 'T*F**FFF*') equals FROM relate_test RID equals -------- ----------- 1 1 1 record(s) selected.