ST_Touches´Â µÎ ±âÇÏÇп¡ °øÅëÀûÀÎ Á¡ Áß ¾î´À °Íµµ µÎ ±âÇÏÇÐÀÇ ³»ºÎ¿Í ±³Â÷ÇÏÁö ¾ÊÀ¸¸é 1(TRUE)À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 0(FALSE)À» ¸®ÅÏÇÕ´Ï´Ù. Àû¾îµµ ÇϳªÀÇ ±âÇÏÇÐÀÌ ¼±½ºÆ®¸µ, ´Ù°¢Çü, ´ÙÁß ¼±½ºÆ®¸µ ¶Ç´Â ´ÙÁß ´Ù°¢ÇüÀ̾î¾ß ÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_Touches(g1 db2gse.ST_Geometry, g2 db2gse.ST_Geometry)
¸®ÅÏ À¯Çü
Integer
¿¹
GIS Àü¹®°¡´Â ¼Û¼ö°üÀÇ ³¡Á¡ÀÌ ´Ù¸¥ ¼Û¼ö°ü°ú ±³Â÷ÇÏ´Â ¸ðµç ¼Û¼ö°ü¼±ÀÇ ¸ñ·ÏÀ» Á¦°øÇØ¾ß ÇÕ´Ï´Ù.
´ÙÀ½ CREATE TABLE¹®Àº ¼¼ °³ÀÇ Ä÷³ÀÌ ÀÖ´Â SEWERLINES Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. ù¹øÂ° Ä÷³ÀÎ SEWER_ID´Â °¢ ¼Û¼ö°üÀ» °íÀ¯ÇÏ°Ô ½Äº°ÇÕ´Ï´Ù. Á¤¼ö À¯ÇüÀÎ µÎ ¹øÂ° Ä÷³ CLASS´Â ¼Û¼ö°ü¼±ÀÇ À¯ÇüÀ» ³ªÅ¸³»¸ç ÀÌ´Â ÀϹÝÀûÀ¸·Î ¼±ÀÇ ¿ë·®°ú ¿¬°üµË´Ï´Ù. ¼±½ºÆ®¸µ À¯ÇüÀÎ ¼¼ ¹øÂ° Ä÷³ SEWER´Â ¼Û¼ö°ü¼±ÀÇ ±âÇÏÇÐÀ» ÀúÀåÇÕ´Ï´Ù.
CREATE TABLE SEWERLINES (sewer_id integer, class integer, sewer db2gse.ST_LineString);
´ÙÀ½ÀÇ SELECT¹®Àº ¼·Î ¸¸³ª´Â SEWER_IDSÀÇ ¼ø¼ÈµÈ ¸ñ·ÏÀ» ¸®ÅÏÇÕ´Ï´Ù.
SELECT s1.sewer_id, s2.sewer_id FROM sewerlines s1, sewerlines s2 WHERE db2gse.ST_Touches (s1.sewer, s2.sewer) = 1, ORDER BY 1,2;