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

ST_Overlaps

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¸¦ »ç¿ëÇÏ¿© Àû¾îµµ ºÎºÐÀûÀ¸·Î À§Çè Æó±â¹° ¿µ¿ª ³»¿¡ ÀÖ´Â ºôµùÀ» ÆÇº°

¸Ç À§


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