ST_Overlaps´Â µÎ °³ÀÇ ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ ¿ÀºêÁ§Æ®ÀÇ ±³Â÷ °á°ú°¡ µ¿ÀÏÇÑ Â÷¿øÀÇ ±âÇÏÇÐ ¿ÀºêÁ§Æ®ÀÌÁö¸¸ ¼·ÎÀÇ ¼Ò½º ¿ÀºêÁ§Æ®¿¡ ÀÏÄ¡ÇÏÁö ¾ÊÀ¸¸é 1(TRUE)À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 0(FALSE)À» ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_Overlaps(g1 db2gse.ST_Geometry, g2 db2gse.ST_Geometry)
¸®ÅÏ À¯Çü
Integer
¿¹
µµ °¨µ¶ÀÚ¿¡°Ô´Â ¹Ý°æ 5¸¶ÀÏ ³»¿¡ ÁÖ¿ä Áö¿ªÀÌ ÀÖ´Â À§Çè Æó±â¹° »çÀÌÆ® ¸ñ·ÏÀÌ ÇÊ¿äÇÕ´Ï´Ù.
´ÙÀ½ CREATE TABLE¹®Àº SENSITIVE_AREAS Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. SENSITIVE_AREAS Å×ÀÌºí¿¡´Â ÇØ´ç ±â°£ÀÇ ´Ù°¢Çü ±âÇϸ¦ ÀúÀåÇÏ´Â ZONE Ä÷³ ¿Ü¿¡µµ À§Çù¹Þ´Â ±â°üÀ» ¼¼úÇÏ´Â ¿©·¯ Ä÷³µéÀÌ Æ÷ÇԵ˴ϴÙ.
CREATE TABLE SENSITIVE_AREAS (id integer, name varchar(128), size float, type varchar(10), zone db2gse.ST_Polygon);
HAZARDOUS_SITES Å×À̺íÀº SITE_ID ¹× NAME Ä÷³¿¡ »çÀÌÆ®ÀÇ ½Äº°ÀÚ¸¦ ÀúÀåÇÏ´Â ¹Ý¸é¿¡, °¢ »çÀÌÆ®ÀÇ ½ÇÁ¦ Áö¸®Àû À§Ä¡´Â LOCATION Á¡ Ä÷³¿¡ ÀúÀåµË´Ï´Ù.
CREATE TABLE HAZARDOUS_SITES (site_id integer, name varchar(128), location db2gse.ST_Point);
´ÙÀ½ÀÇ SELECT¹®¿¡¼ SENSITIVE_AREAS ¹× HAZARDOUS_SITES Å×À̺íÀÌ ST_Overlaps ÇÔ¼ö·Î °áÇյ˴ϴÙ. ÀÌ´Â ±¸È¹ ´Ù°¢ÇüÀÌ ¹öÆÛÈµÈ ¹Ý°æ 5¸¶ÀÏÀÇ HAZARDOUS_SITES À§Ä¡ Á¡°ú °ãÄ¡´Â ¸ðµç SENSITIVE_AREAS Å×À̺íÀÇ ¸ðµç Çà¿¡ ´ëÇØ 1(TRUE)À» ¸®ÅÏÇÕ´Ï´Ù.
SELECT hs.name FROM HAZARDOUS_SITES hs, SENSITIVE_AREAS sa WHERE db2gse.ST_Overlaps (buffer(hs.location,(5 * 5280)),sa.zone) = 1;
±×¸² 37¿¡¼ º´¿ø°ú Çб³°¡ µµÀÇ µÎ À§Çè Æó±â¹° »çÀÌÆ®ÀÇ 5¸¶ÀÏ ¹Ý°æ À̳»¿¡ °ãÄ¡´Â ¹Ý¸é¿¡ »ç¼³ ¿ä¾ç¼Ò´Â °ãÄ¡Áö ¾Ê½À´Ï´Ù.
±×¸² 37. ST_Overlaps¸¦ »ç¿ëÇÏ¿© Àû¾îµµ ºÎºÐÀûÀ¸·Î À§Çè Æó±â¹° ¿µ¿ª ³»¿¡ ÀÖ´Â ºôµùÀ» ÆÇº°