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

ST_NumGeometries

ST_NumGeometries´Â ÄÝ·º¼ÇÀ» ÃëÇØ ÄÝ·º¼Ç ³»ÀÇ ±âÇÏÇÐ ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

db2gse.ST_NumGeometries(g db2gse.ST_GeomCollection)

¸®ÅÏ À¯Çü

Integer

¿¹

µµ½Ã °øÇÐÀÚ´Â °¢ ºôµù À§Ä¡¿Í ¿¬°üµÈ º°°³ ºôµùÀÇ ½ÇÁ¦ ¼ö¸¦ ¾Ë°í ÀÖ¾î¾ß ÇÕ´Ï´Ù.

ºôµù À§Ä¡´Â ´ÙÀ½ÀÇ CREATE TABLE¹®À¸·Î ÀÛ¼ºµÇ´Â BUILDINGFOOTPRINTS Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù.

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

´ÙÀ½ÀÇ SELECT¹®Àº ST_NumGeometries ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© °¢ ºôµùÀ» °íÀ¯ÇÏ°Ô ³ªÅ¸³»´Â BUILDING_ID¿Í °¢ À§Ä¡¿¡ ÀÖ´Â ºôµù ¼ö¸¦ ³ª¿­ÇÕ´Ï´Ù.

SELECT building_id, db2gse.ST_NumGeometries (footprint) "Number of buildings"
FROM BUILDINGFOOTPRINTS;


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