ST_Transform ÇÔ¼ö´Â ±âÇÏÇÐÀÌ ÇöÀç ÁöÁ¤µÈ °ø°£ ÂüÁ¶ ½Ã½ºÅÛÀÌ ¾Æ´Ñ ´Ù¸¥ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ¿¡ ±âÇÏÇÐÀ» ÁöÁ¤ÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_Transform(g db2gse.ST_Geometry, SRID db2gse.coordref)
¸®ÅÏ À¯Çü
db2gse.ST_Geometry
¿¹
´ÙÀ½ÀÇ CREATE TABLE¹®Àº µÎ °³ÀÇ ¼±½ºÆ®¸µ Ä÷³ L1 ¹× L2°¡ ÀÖ´Â TRANSFORM_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.
CREATE TABLE TRANSFORM_TEST (tid integer, l1 db2gse.ST_LineString, l2 db2gse.ST_LineString)
´ÙÀ½ÀÇ INSERT¹®Àº ¼±½ºÆ®¸µÀ» SRID 102ÀÎ l1¿¡ »ðÀÔÇÕ´Ï´Ù.
INSERT INTO TRANSFORM_TEST VALUES (1, db2gse.ST_LineFromText('linestring (10.01 40.43, 92.32 29.89)', db2gse.coordref()..srid(102)),NULL)
ST_Transform ÇÔ¼ö´Â SRID 102¿¡ ÁöÁ¤µÈ ÁÂÇ¥ ÂüÁ¶·ÎºÎÅÍ SRID 105¿¡ ÁöÁ¤µÈ ÁÂÇ¥ ÂüÁ¶·Î L1 ¼±½ºÆ®¸µÀ» º¯È¯ÇÕ´Ï´Ù. ´ÙÀ½ÀÇ UPDATE¹®Àº º¯È¯µÈ ¼±½ºÆ®¸µÀ» Ä÷³ 12¿¡ ÀúÀåÇÕ´Ï´Ù.
UPDATE TRANSFORM_TEST SET l2 = db2gse.ST_Transform(l1, db2gse.coordref()..srid(105))
ÁöÁ¤µÈ ±âÇϰ¡ »õ·Î¿î °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ¾Æ·¡¿¡ ÀÖ´Â ÁÂÇ¥ ü°Ô ¿ÜºÎ¿¡ ³õÀÌ°Ô µÇ¸é ST_TransformÀº ±× ±âÇϸ¦ ³Î·Î ¸®ÅÏÇÕ´Ï´Ù.
¿¹¸¦ µé¾î, X ÁÂÇ¥°¡ 10.01À̰í Y ÁÂÇ¥°¡ 20.02ÀÎ ST_Point ±âÇϸ¦ »ý°¢ÇØ º¾½Ã´Ù.
ÀÌ ±âÇϰ¡ ´ÙÀ½°ú °°Àº ¸Å°³º¯¼ö¸¦ °¡Áø °ø°£ ÂüÁ¶ ½Ã½ºÅÛ¿¡ ÁöÁ¤µÈ´Ù°í °¡Á¤ÇսôÙ.
falsex | 0 |
falsey | 0 |
xyunits | 1 |
±× ´ÙÀ½ ST_TransformÀ» È£ÃâÇÏ¿© ST_Point ±âÇÏÀÇ °ø°£ ÂüÁ¶ ½Ã½ºÅÛÀ» ´ÙÀ½ ¸Å°³º¯¼ö¸¦ °¡Áø
½Ã½ºÅÛÀ¸·Î º¯°æÇÑ´Ù°í ÇսôÙ.
falsex | 100 |
falsey | 100 |
xyunits | 1 |
ÀÌ ÁÂÇ¥(10.01, 20.02)´Â »õ·Î¿î °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ¾Æ·¡¿¡ ÀÖ´Â ÁÂÇ¥ ¿ÜºÎ¿¡ ³õÀÌ°Ô µÇ¹Ç·Î ST_TransformÀº ÀÌ ±âÇϸ¦ ³Î·Î ¸®ÅÏÇÕ´Ï´Ù.