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

ST_GeometryN

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;


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