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

ST_Union

ST_UnionÀº µÎ °³ÀÇ ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ ¼Ò½º ¿ÀºêÁ§Æ®¸¦ ÅëÇÕÇÑ ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

db2gse.ST_Union(g1 db2gse.ST_Geometry, g2 db2gse.ST_Geometry)

¸®ÅÏ À¯Çü

db2gse.ST_Geometry

¿¹

´ÙÀ½ÀÇ 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); 

´ÙÀ½ÀÇ CREATE TABLE¹®Àº HAZARDOUS_SITES Å×À̺íÀ» ÀÛ¼ºÇϴµ¥ ÀÌ´Â SITE_ID ¹× NAME Ä÷³¿¡ »çÀÌÆ®ÀÇ ½Äº°ÀÚ¸¦ ÀúÀåÇÕ´Ï´Ù. °¢ »çÀÌÆ®ÀÇ ½ÇÁ¦ Áö¸®Àû À§Ä¡´Â LOCATION Á¡ Ä÷³¿¡ ÀúÀåµË´Ï´Ù.

CREATE TABLE HAZARDOUS_SITES (site_id integer, name varchar(128), 
location db2gse.ST_Point); 

´ÙÀ½ÀÇ SELECT¹®¿¡¼­´Â ST_Buffer ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© À§Çè Æó±â¹° »çÀÌÆ® À§Ä¡¸¦ µÑ·¯½Ñ 5¸¶ÀÏ ¹öÆÛ¸¦ »ý¼ºÇÕ´Ï´Ù. ST_Union ÇÔ¼ö´Â ¹öÆÛÈ­µÈ À§Çè Æó±â¹° »çÀÌÆ® ´Ù°¢Çü°ú Áֿ俵¿ªÀ» ÅëÇÕÇÏ¿© ´Ù°¢ÇüÀ» »ý¼ºÇÕ´Ï´Ù. ST_Area ÇÔ¼ö´Â ÅëÇÕµÈ ´Ù°¢Çü ¿µ¿ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

SELECT sa.name, hs.name,
       db2gse.ST_Area(db2gse.ST_Union(db2gse.ST_Buffer(hs.location,
(5 * 5280)),sa.zone))
FROM HAZARDOUS_SITES hs, SENSITIVE_AREAS sa; 


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