ST_GeometryNÀº ÄÝ·º¼Ç ¹× Á¤¼ö »öÀÎÀ» ÃëÇØ ÄÝ·º¼Ç¿¡ ÀÖ´Â n¹øÂ° ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST GeometryN(g db2gse.ST_Geometry, n Integer)
¸®ÅÏ À¯Çü
db2gse.ST_Geometry
¿¹
µµ½Ã °øÇÐÀÚ´Â ºôµù À§Ä¡°¡ ±¸È¹ ´ÙÁß ´Ù°¢ÇüÀÇ Ã¹¹øÂ° ´Ù°¢Çü ¾È¿¡ ¸ðµÎ ÀÖ´ÂÁö ¾Ë¾Æ¾ß ÇÕ´Ï´Ù.
BUILDING_ID Ä÷³Àº BUILDINGFOOTPRINTS Å×À̺íÀÇ °¢ ÇàÀ» °íÀ¯ÇÏ°Ô ½Äº°ÇÕ´Ï´Ù. LOT_ID Ä÷³Àº ºôµù ±¸È¹À» ³ªÅ¸³À´Ï´Ù. FOOTPRINT Ä÷³Àº ºôµùÀÇ ±âÇÏÇÐÀ» ÀúÀåÇÕ´Ï´Ù.
CREATE TABLE BUILDINGFOOTPRINTS ( building_id integer, lot_id integer, footprint db2gse.ST_MultiPolygon); CREATE TABLE LOTS ( lot_id integer, lot db2gse.ST_MultiPolygon);
Á¶È¸¿¡¼´Â ¸ðµÎ ù¹øÂ° ±¸È¹ ´Ù°¢Çü ³»¿¡ ÀÖ´Â ¸ðµç ºôµù À§Ä¡ÀÇ BUILDINGFOOTPRINTS building_id ¹× lot_id¸¦ ³ª¿ÇÕ´Ï´Ù. ST_GeometryN ÇÔ¼ö´Â ´ÙÁß ´Ù°¢Çü ¹è¿¿¡¼ÀÇ Ã¹¹øÂ° ±¸È¹ ´Ù°¢ÇüÀ» ¸®ÅÏÇÕ´Ï´Ù.
SELECT bf.building_id,bf.lot_id FROM BUILDINGFOOTPRINTS bf,LOTS WHERE db2gse.ST_Within(footprint, db2gse.ST_GeometryN (lot,1)) = 1 AND bf.lot_id = LOTS.lot_id;