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

ST_Centroid

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;


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