ST_Centroid´Â ´Ù°¢Çü ¶Ç´Â ´ÙÁß ´Ù°¢ÇüÀ» ÃëÇØ Áö¸®Àû Áß½ÉÀ» Á¡À¸·Î¼ ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_Centroid(s db2gse.ST_Surface)
db2gse.ST_Centroid(ms db2gse.ST_MultiSurface)
¸®ÅÏ À¯Çü
surfaceÀÇ °æ¿ì: db2gse.ST_Point
¿¹
µµ½Ã GIS ±â¼úÀÚ´Â ºôµù À§Ä¡ÀÇ ´ÙÁß ´Ù°¢ÇüÀ» ºôµù ¹Ðµµ ±×·¡ÇÈ¿¡ ´ÜÀÏ Á¡À¸·Î¼ Ç¥½ÃÇÏ·Á°í ÇÕ´Ï´Ù.
ºôµù À§Ä¡´Â ´ÙÀ½ÀÇ CREATE TABLE¹®À¸·Î ÀÛ¼ºµÇ´Â BUILDINGFOOTPRINTS Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù.
CREATE TABLE BUILDINGFOOTPRINTS (building_id integer, lot_id integer, footprint db2gse.ST_MultiPolygon);
ST_Centroid ÇÔ¼ö´Â °¢ ºôµù À§Ä¡ ´ÙÁß ´Ù°¢ÇüÀÇ Áß½ÉÀ» ¸®ÅÏÇÕ´Ï´Ù. AsShape ÇÔ¼ö´Â Áß½ÉÁ¡À» ÀÀ¿ëÇÁ·Î±×·¥¿¡¼ ÀνÄÇÏ´Â ¿ÜºÎÀû Ç¥ÇöÀÎ ¸ð¾çÀ¸·Î º¯È¯ÇÕ´Ï´Ù.
SELECT building_id, CAST(db2gse.AsShape(db2gse.ST_Centroid (footprint)) as blob(1m)) "Centroid" FROM BUILDINGFOOTPRINTS;