»ç¿ëÀÚ ¾È³» ¹× ÂüÁ¶¼­

ST_Relate

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*")¿¡ ÀÐÇôÁý´Ï´Ù.

Ç¥ 57. Equals ÆÐÅÏ Çà·Ä



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.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]