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 ¹øÈ£°¡ ºÙÀº ³× °³ÀÇ ºôµùÀÌ ÀÎÁ¢ÇÑ °Å¸®¿Í ÇÔ²² Ç¥½ÃµË´Ï´Ù.