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

ST_Equals

ST_Equals´Â µÎ °³ÀÇ ±âÇÏÇÐÀ» ºñ±³ÇÏ¿© ±âÇÏÇÐÀÌ µ¿ÀÏÇϸé 1(TRUE)À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 0(FALSE)À» ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

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

¸®ÅÏ À¯Çü

Integer

¿¹

µµ½Ã GIS Àü¹®°¡´Â BUILDINGFOOTPRINTS Å×À̺íÀÇ ÀϺΠµ¥ÀÌÅͰ¡ ¾î´À Á¤µµ Áߺ¹µÇ¾î ÀÖÀ½À» ¿¹»óÇϰí ÀÖ½À´Ï´Ù. Àü¹®°¡´Â Å×À̺íÀ» Á¶È¸ÇÏ¿© À§Ä¡ÀÇ ´ÙÁß ´Ù°¢ÇüÀÌ µ¿ÀÏÇÑÁö ÆÇ´ÜÇÕ´Ï´Ù.

BUILDINGFOOTPRINTS Å×À̺íÀº ´ÙÀ½ÀÇ ¸í·É¹®À¸·Î ÀÛ¼ºµË´Ï´Ù. BUILDING_ID Ä÷³Àº °íÀ¯ÇÏ°Ô ºôµùÀ» ³ªÅ¸³»°í, LOT_ID Ä÷³Àº ºôµùÀÇ ±¸È¹À» ³ªÅ¸³»¸ç, FOOTPRINT Ä÷³Àº ºôµùÀÇ ±âÇÏÇÐÀ» ÀúÀåÇÕ´Ï´Ù.

CREATE TABLE BUILDINGFOOTPRINTS ( building_id integer,
                                  lot_id      integer,
                                  footprint   db2gse.ST_MultiPolygon);

BUILDINGFOOTPRINTS Å×À̺íÀº ST_Equals ¼ú¾î¿¡ ÀÇÇØ ±× Àڽſ¡ °ø°£ÀûÀ¸·Î °áÇյǸç ÀÌ ¼ú¾î´Â µ¿ÀÏÇÑ µÎ °³ÀÇ ´ÙÁß ´Ù°¢ÇüÀ» ãÀ» ¶§¸¶´Ù 1À» ¸®ÅÏÇÕ´Ï´Ù. bf1.building_id<> bf2.building_id Á¶°ÇÀ» ¼³Á¤ÇÏ¸é µ¿ÀÏÇÑ ±âÇÏÇÐÀº ºñ±³ÇÏÁö ¾Ê½À´Ï´Ù.

SELECT bf1.building_id, bf2.building_id
FROM BUILDINGFOOTPRINTS bf1, BUILDINGFOOTPRINTS bf2
WHERE db2gse.ST_Equals(bf1.footprint,bf2.footprint) = 1
      and bf1.building_id <> bf2.building_id;


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