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;