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

ST_Transform

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Àº ÀÌ ±âÇϸ¦ ³Î·Î ¸®ÅÏÇÕ´Ï´Ù.


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