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

ST_Boundary

ST_Boundary´Â ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ ÀÌÀÇ °áÇÕµÈ °æ°è¸¦ ±âÇÏÇÐ ¿ÀºêÁ§Æ®·Î¼­ ¸®ÅÏÇÕ´Ï´Ù. Á¡ ¹× ´ÙÁßÁ¡Àº Ç×»ó Â÷¿øÀÌ 0ÀÎ(1ÀÌ ¾Æ´Ñ) ºó ±âÇÏÇÐÀÎ °æ°è°¡ µË´Ï´Ù.

±¸¹®

db2gse.ST_Boundary(g db2gse.ST_Geometry)

¸®ÅÏ À¯Çü

db2gse.ST_Geometry

¿¹

´ÙÀ½ ÄÚµå Á¶°¢¿¡¼­ BOUNDARY_TEST Å×À̺íÀÌ ÀÛ¼ºµË´Ï´Ù. BOUNDARY_TEST¿¡´Â varchar·Î Á¤ÀǵǴ GEOTYPE Ä÷³°ú ¼öÆÛŬ·¡½º ±âÇÏÇÐÀ¸·Î Á¤ÀǵǴ G1ÀÌ ÀÖ½À´Ï´Ù. ´ÙÀ½¿¡ ³ª¿À´Â INSERT¹®Àº °¢ Çϳª¾¿ÀÇ ¼­ºêŬ·¡½º ±âÇÏÇÐÀ» »ðÀÔÇÕ´Ï´Ù. ST_Boundary ÇÔ¼ö´Â G1 ±âÇÏÇÐ Ä÷³¿¡ ÀúÀåµÈ °¢ ¼­ºêŬ·¡½ºÀÇ °æ°è¸¦ °Ë»öÇÕ´Ï´Ù. °á°ú ±âÇÏÇÐÀÇ Â÷¿øÀº Ç×»ó ÀÔ·Â ±âÇÏÇÐ º¸´Ù Çϳª Àû´Ù´Â Á¡¿¡ À¯ÀÇÇϽʽÿÀ. Á¡ ¹× ´ÙÁßÁ¡ÀÇ °á°ú´Â Ç×»ó ºó ±âÇÏÇÐ, Â÷¿ø 1ÀÎ °æ°èÀÔ´Ï´Ù. ¼±½ºÆ®¸µ ¹× ´ÙÁß ¼±½ºÆ®¸µÀº ´ÙÁßÁ¡ °æ°è¸¦ ¸®ÅÏÇÕ´Ï´Ù. ´Ù°¢Çü ¶Ç´Â ´ÙÁß ´Ù°¢ÇüÀº Ç×»ó ´ÙÁß ¼±½ºÆ®¸µ °æ°è, Â÷¿ø 1À» ¸®ÅÏÇÕ´Ï´Ù.

CREATE TABLE BOUNDARY_TEST (GEOTYPE varchar(20), G1 db2gse.ST_Geometry)
 
INSERT INTO BOUNDARY_TEST
VALUES('Point',
       db2gse.ST_PointFromText('point (10.02 20.01)',
                     db2gse.coordref()..srid(0)))
 
INSERT INTO BOUNDARY_TEST
VALUES('Linestring',
       db2gse.ST_LineFromText('linestring (10.02 20.01,10.32 23.98,
11.92 25.64)', db2gse.coordref()..srid(0)))
 
INSERT INTO BOUNDARY_TEST
VALUES('Polygon',
       db2gse.ST_PolyFromText('polygon ((10.02 20.01,11.92 35.64,25.02 34.15,
                               19.15 33.94, 10.02 20.01))',
                    db2gse.coordref()..srid(0)))
 
INSERT INTO BOUNDARY_TEST
VALUES('Multipoint',
       db2gse.ST_MPointFromText('multipoint (10.02 20.01,10.32 23.98,
11.92 25.64)', db2gse.coordref()..srid(0)))
 
INSERT INTO BOUNDARY_TEST
VALUES('Multilinestring',
       db2gse.ST_MLineFromText('multilinestring ((10.02 20.01,10.32 23.98,
11.92 25.64), (9.55 23.75,15.36 30.11))',
                     db2gse.coordref()..srid(0)))
 
INSERT INTO BOUNDARY_TEST
VALUES('Multipolygon',
       db2gse.ST_MPolyFromText('multipolygon (((10.02 20.01,11.92 35.64,
                                   25.02 34.15, 19.15 33.94,10.02 20.01)),
                                    ((51.71 21.73,73.36 27.04,71.52 32.87,
                                      52.43 31.90,51.71 21.73)))',
                     db2gse.coordref()..srid(0)))
 
SELECT GEOTYPE,
       CAST(db2gse.ST_AsText(db2gse.ST_Boundary (G1)) as varchar(280)) 
      "The boundary"
FROM BOUNDARY_TEST
 
GEOTYPE              The boundary
-------------------- --------------------------------------------------------
Point                POINT EMPTY
Linestring           MULTIPOINT ( 10.02000000 20.01000000, 11.92000000
 25.64000000)
Polygon              MULTILINESTRING (( 10.02000000 20.01000000, 19.15000000
 33.94000000, 25.02000000 34.15000000, 11.92000000 35.64000000, 10.02000000
 20.01000000))
Multipoint           POINT EMPTY
Multilinestring      MULTIPOINT ( 9.55000000 23.75000000, 10.02000000
 20.01000000, 11.92000000 25.64000000, 15.36000000 30.11000000)
Multipolygon         MULTILINESTRING (( 51.71000000 21.73000000, 73.36000000
 27.04000000, 71.52000000 32.87000000, 52.43000000 31.90000000, 51.71000000
 21.73000000),( 10.02000000 20.01000000, 19.15000000 33.94000000, 25.02000000
 34.15000000, 11.92000000 35.64000000, 10.02000000 20.01000000))
 
  6 record(s) selected.


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