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;