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

ST_SRID

ST_SRID´Â ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ ÀÌÀÇ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

db2gse.ST_SRID(g1 db2gse.ST_Geometry)

¸®ÅÏ À¯Çü

Integer

¿¹

ST_SRID ÇÔ¼ö´Â ST_Geometry °ª°ú ¿¬°üµÈ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ¸®ÅÏÇÕ´Ï´Ù.

¿¹¸¦ µé¾î, ±âÇÏÇÐ À¯ÇüÀº CREATE TABLE¹®¿¡ »ç¿ëµË´Ï´Ù.

CREATE TABLE SRID_TEST(g1 db2gse.ST_Geometry) 

´ÙÀ½ INSERT¹®¿¡¼­´Â ÁÂÇ¥ 10.01,50.76¿¡ ³õÀÎ Á¡ ±âÇÏÇÐÀÌ ±âÇÏÇÐ Ä÷³ G1¿¡ »ðÀԵ˴ϴÙ. ST_PointFromText ÇÔ¼ö°¡ Á¡ ±âÇÏÇÐÀ» ÀÛ¼ºÇÒ ¶§, srid °ª 1À» ÁöÁ¤ÇÕ´Ï´Ù.

INSERT INTO SRID_TEST
VALUES (db2gse.ST_PointFromText('point(10.01 50.76)', 
    db2gse.coordref()..srid(0))) 

ST_SRID ÇÔ¼ö´Â ´ÙÀ½ SELECT¹®°ú ÇØ´ç °á°ú ¼¼Æ®¿¡¼­ ¼³¸íÇÑ´ë·Î ¹æ±Ý ÀÔ·ÂµÈ ±âÇÏÇÐÀÇ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ¸®ÅÏÇÕ´Ï´Ù.

SELECT db2gse.ST_SRID(g1) FROM SRID_TEST
 
g1
--------------
0 


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