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

ST_Area

ST_Area´Â ´Ù°¢Çü ¶Ç´Â ´ÙÁß ´Ù°¢ÇüÀ» ÃëÇØ ±× ¿µ¿ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®
db2gse.ST_Area(s db2gse.ST_Surface)
db2gse.ST_Surface
db2gse.ST_Polygon
db2gse.ST_MultiSurface
db2gse.ST_MultiPolygon

¸®ÅÏ À¯Çü

Double

¿¹

µµ½Ã °øÇÐÀÚ´Â ºôµù ¿µ¿ª ¸ñ·ÏÀÌ ÇÊ¿äÇÕ´Ï´Ù. ¸ñ·ÏÀ» ¾ò±â À§ÇØ GIS ±â¼úÀÚ´Â ºôµù ID¿Í °¢ ºôµùÀÇ À§Ä¡ ¿µ¿ªÀ» ¼±ÅÃÇÕ´Ï´Ù.

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

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

µµ½Ã °øÇÐÀÚÀÇ ¿ä±¸¸¦ ÃæÁ·½Ã۱â À§ÇØ ±â¼úÀÚ´Â ´ÙÀ½ÀÇ SELECT¹®À» »ç¿ëÇÏ¿© BUILDINGFOOTPRINTS Å×ÀÌºí¿¡¼­ °íÀ¯Å°, building_ID ¹× °¢ ºôµù À§Ä¡ÀÇ ¿µ¿ªÀ» ¼±ÅÃÇÕ´Ï´Ù.

SELECT building_id, db2gse.ST_Area (footprint) "Area"
FROM BUILDINGFOOTPRINTS;

SELECT¹®Àº ´ÙÀ½ÀÇ °á°ú ¼¼Æ®¸¦ ¸®ÅÏÇÕ´Ï´Ù.

building_id   Area
------------  ------------------------
         506    +1.40768000000000E+003
        1208    +2.55759000000000E+003
         543    +1.80786000000000E+003
         178    +2.08671000000000E+003
         .
         .
         .

±×¸² 28. ºôµù À§Ä¡¸¦ ã´Â µ¥ ¿µ¿ª »ç¿ë. ºôµù ID ¹øÈ£°¡ ºÙÀº ³× °³ÀÇ ºôµùÀÌ ÀÎÁ¢ÇÑ °Å¸®¿Í ÇÔ²² Ç¥½ÃµË´Ï´Ù.

¸Ç À§

ÁÖ:
ÀÌ¹Ì Ç¥½ÃµÈ ´ë·Î , ST_Area´Â ´Ù°¢ÇüÀ̳ª ´ÙÁß ´Ù°¢ÇüÀ» ÀÔ·ÂÀ¸·Î ÃëÇÒ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼­ ÀÔ·Â ¸Å°³º¯¼öÀÇ µ¥ÀÌÅÍ À¯ÇüÀº ´ÙÀ½°ú °°½À´Ï´Ù.


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