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

ST_PointOnSurface

ST_PointOnSurface´Â ´Ù°¢Çü ¶Ç´Â ´ÙÁß ´Ù°¢Çü µÑ ¸ðµÎ¸¦ ÃëÇØ ST_Point¸¦ ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®
db2gse.ST_PointOnSurface(s db2gse.ST_Surface)
db2gse.ST_PointOnSurface(ms db2gse.ST_MultiSurface)

¸®ÅÏ À¯Çü

db2gse.ST_Point

¿¹

µµ½Ã °øÇÐÀÚ´Â °¢ ºôµù À§Ä¡¿¡ ´ëÇÑ ·¹À̺í Á¡À» ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù.

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

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

ST_PointOnSurface ÇÔ¼ö´Â ºôµù À§Ä¡ÀÇ Ç¥¸é¿¡ ÀÖ°Ô µÉ Á¡À» »ý¼ºÇÕ´Ï´Ù.

SELECT db2gse.ST_PointOnSurface(footprint) FROM BUILDINGFOOTPRINTS; 


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