Spatial Extender¿¡´Â ÅØ½ºÆ® ¼³¸íÀ¸·ÎºÎÅÍ ±âÇÏÇÐÀ» »ý¼ºÇÏ´Â ¿©·¯ ÇÔ¼ö°¡ ÀÖ½À´Ï´Ù.
ÅØ½ºÆ® Ç¥Çö½ÄÀº ±âÇÏÇÐÀÌ ASCII ÅØ½ºÆ® ¾ç½ÄÀ¸·Î ±³È¯µÉ ¼ö ÀÖµµ·Ï ÇÏ´Â ASCII ÅØ½ºÆ® Çü½Ä ¹®ÀÚ¿ÀÔ´Ï´Ù. ÀÌ ÇÔ¼öµéÀº Ư¼ö ÇÁ·Î±×·¥ ±¸Á¶ÀÇ Á¤Àǰ¡ ÇÊ¿äÇÏÁö ¾ÊÀ¸¹Ç·Î 3¼¼´ë ¶Ç´Â 4¼¼´ë ¾ð¾î(3GL ¶Ç´Â 4GL) ÇÁ·Î±×·¥¿¡ ÀÌ ÇÔ¼ö¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ST_AsText ÇÔ¼ö´Â ±âÁ¸ÀÇ ±âÇÏÇÐÀ» ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·Î º¯È¯ÇÕ´Ï´Ù.
°¢ ±âÇÏÇÐ À¯Çü¿¡´Â Àß ¾Ë·ÁÁø ÅØ½ºÆ® Ç¥Çö½ÄÀÌ Àִµ¥ ÀÌ´Â À¯ÇüÀÇ »õ·Î¿î ÀνºÅϽº¸¦ ±¸ÃàÇÏ°í ¿µ¼ýÀÚ È¸é¿ë ÅØ½ºÆ® ¾ç½ÄÀ¸·Î ±âÁ¸ÀÇ ÀνºÅϽº¸¦ º¯È¯ÇÏ´Â µ¥ ¸ðµÎ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
±âÇÏÇÐÀÇ Àß ¾Ë·ÁÁø ÅØ½ºÆ® Ç¥Çö½ÄÀº ´ÙÀ½°ú °°ÀÌ Á¤Àǵ˴ϴÙ. °³³ä {}*Àº °ýÈ£ ¾ÈÀÇ ÅäÅ«À» 0¹ø ÀÌ»ó ¹Ýº¹ÇÔÀ» ³ªÅ¸³»¸ç, °ýÈ£´Â Ãâ·Â ÅäÅ« ¸ñ·Ï¿¡ ³ªÅ¸³ªÁö ¾Ê½À´Ï´Ù.
<Geometry Tagged Text> := | <Point Tagged Text> | <LineString Tagged Text> | <Polygon Tagged Text> | <MultiPoint Tagged Text> | <MultiLineString Tagged Text> | <MultiPolygon Tagged Text> <Point Tagged Text> := POINT (<Point Text>) <LineString Tagged Text> := LINESTRING (<LineString Text>) <Polygon Tagged Text> := POLYGON (<Polygon Text>) <MultiPoint Tagged Text> := MULTIPOINT (<MultiPoint Text>) <MultiLineString Tagged Text> := MULTILINESTRING (<MultiLineString Text>) <MultiPolygon Tagged Text> := MULTIPOLYGON (<MultiPolygon Text>) <Point Text> := EMPTY | <Point> | Z (<PointZ>) | M (<PointM>) | ZM (<PointZM>) <Point> := <x> <y> <x> := double precision literal <y> := double precision literal <PointZ> := <x> <y> <z> <x> := double precision literal <y> := double precision literal <z> := double precision literal <PointM> := <x> <y> <m> <x> := double precision literal <y> := double precision literal <m> := double precision literal <PointZM> := <x> <y> <z> <m> <x> := double precision literal <y> := double precision literal <z> := double precision literal <m> := double precision literal <LineString Text> := EMPTY | ( <Point Text > {, <Point Text> }* ) | Z ( <PointZ Text > {, <PointZ Text> }* ) | M ( <PointM Text > {, <PointM Text> }* ) | ZM ( <PointZM Text > {, <PointZM Text> }* ) <Polygon Text> := EMPTY | ( <LineString Text > {,< LineString Text > }* ) <MultiPoint Text> := EMPTY | ( <Point Text > {, <Point Text > }* ) <MultiLineString Text> := EMPTY | ( <LineString Text > {,< LineString Text>}* ) <MultiPolygon Text> := EMPTY | ( < Polygon Text > {, < Polygon Text > }* )
±âº»ÀûÀÎ ÇÔ¼ö ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.
function (<text description>,<SRID db2gse.coordref>)
°ø°£ ÂüÁ¶ ½Äº°ÀÚÀÎ SRID¿Í SPATIAL_REFERENCES Å×ÀÌºí¿¡ ´ëÇÑ ±âº» ۰¡ SPATIAL_REFERENCES Å×ÀÌºí¿¡ ÁöÁ¤µÈ ±âÇÏÇÐÀÇ °ø°£ ÂüÁ¶ ½Ã½ºÅÛÀ» ½Äº®ÇÕ´Ï´Ù. °ø°£ Ä÷³¿¡ ±âÇÏÇÐÀ» »ðÀÔÇϱâ Àü¿¡ ±âÇÏÇÐÀÇ SRID¿Í °ø°£ Ä÷³ÀÇ SRID°¡ ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù.
ÅØ½ºÆ® ¼³¸íÀº ÀÛÀº µû¿ÈÇ¥·Î ¹ÀÎ ¼¼ °¡Áö ±âº» ±¸¼º¿ä¼Ò·Î ±¸¼ºµË´Ï´Ù. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
<'±âÇÏÇÐ À¯Çü'> ['ÁÂÇ¥ À¯Çü'] [''ÁÂÇ¥ ¸ñ·Ï']
¿©±â¼:
Ç¥ 66¿¡¼´Â °¡´ÉÇÑ ¸ðµç ÅØ½ºÆ® Ç¥Çö½Ä ¿¹¿¡ ´ëÇÑ Àüü ¸ñ·ÏÀ»
º¸¿© ÁÝ´Ï´Ù.
Ç¥ 66. ±âÇÏÇÐ À¯Çü ¹× ÅØ½ºÆ® Ç¥Çö½Ä
±âÇÏÇÐ À¯Çü
|
ÅØ½ºÆ® ¼³¸í
|
ÁÖ¼®
|
---|---|---|
Á¡
|
point empty
|
ºó Á¡
|
Á¡
|
point z empty
|
z ÁÂÇ¥°¡ ÀÖ´Â ºó Á¡
|
Á¡
|
point m empty
|
Ä¡¼ö°¡ ÀÖ´Â ºó Á¡
|
Á¡
|
point zm empty
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ºó Á¡
|
Á¡
|
point ( 10.05 10.28 )
|
Á¡
|
Á¡
|
point z ( 10.05 10.28 2.51 )
|
z ÁÂÇ¥°¡ ÀÖ´Â Á¡
|
Á¡
|
point m ( 10.05 10.28 4.72 )
|
Ä¡¼ö°¡ ÀÖ´Â Á¡
|
Á¡
|
point zm ( 10.05 10.28 2.51 4.72 )
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â Á¡
|
¼±½ºÆ®¸µ
|
linestring empty
|
ºó ¼±½ºÆ®¸µ
|
¼±½ºÆ®¸µ
|
linestring z empty
|
z ÁÂÇ¥°¡ ÀÖ´Â ºó ¼±½ºÆ®¸µ
|
¼±½ºÆ®¸µ
|
linestring m empty
|
Ä¡¼ö°¡ ÀÖ´Â ºó ¼±½ºÆ®¸µ
|
¼±½ºÆ®¸µ
|
linestring zm empty
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ºó ¼±½ºÆ®¸µ
|
¼±½ºÆ®¸µ
|
linestring ( 10.05 10.28 , 20.95
20.89 )
|
¼±½ºÆ®¸µ
|
¼±½ºÆ®¸µ
|
linestring z ( 10.05 10.28 3.09,
20.95 31.98 4.72, 21.98 29.80 3.51 )
|
z ÁÂÇ¥°¡ ÀÖ´Â ¼±½ºÆ®¸µ
|
¼±½ºÆ®¸µ
|
linestring m ( 10.05 10.28 5.84,
20.95 31.98 9.01, 21.98 29.80 12.84 )
|
Ä¡¼ö°¡ ÀÖ´Â ¼±½ºÆ®¸µ
|
¼±½ºÆ®¸µ
|
linestring zm ( )
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ¼±½ºÆ®¸µ
|
´Ù°¢Çü
|
polygon empty
|
ºó ´Ù°¢Çü
|
´Ù°¢Çü
|
polygon z empty
|
z ÁÂÇ¥°¡ ÀÖ´Â ºó ´Ù°¢Çü
|
´Ù°¢Çü
|
polygon m empty
|
Ä¡¼ö°¡ ÀÖ´Â ºó ´Ù°¢Çü
|
´Ù°¢Çü
|
polygon zm empty
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ºó ´Ù°¢Çü
|
´Ù°¢Çü
|
polygon (( 10 10, 10 20,
20 20, 20 15, 10 10))
|
´Ù°¢Çü
|
´Ù°¢Çü
|
polygon z (( ))
|
z ÁÂÇ¥°¡ ÀÖ´Â ´Ù°¢Çü
|
´Ù°¢Çü
|
polygon m (( ))
|
Ä¡¼ö°¡ ÀÖ´Â ´Ù°¢Çü
|
´Ù°¢Çü
|
polygon zm (( ))
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ´Ù°¢Çü
|
´ÙÁßÁ¡
|
multipoint empty
|
ºó ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint z empty
|
z ÁÂÇ¥°¡ ÀÖ´Â ºó ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint m empty
|
Ä¡¼ö°¡ ÀÖ´Â ºó ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint zm empty
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ºó ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint empty
|
ºó ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint (10 10, 20 20)
|
µÎ Á¡ÀÌ ÀÖ´Â ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint z (10 10 2, 20 20 3)
|
z ÁÂÇ¥°¡ ÀÖ´Â ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint m (10 10 4, 20 20 5)
|
Ä¡¼ö°¡ ÀÖ´Â ´ÙÁßÁ¡
|
´ÙÁßÁ¡
|
multipoint zm (10 10 2 4, 20 20
3 5)
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ´ÙÁßÁ¡
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring empty
|
ºó ´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring z empty
|
z ÁÂÇ¥°¡ ÀÖ´Â ºó ´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring m empty
|
Ä¡¼ö°¡ ÀÖ´Â ºó ´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring zm empty
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ºó ´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring (( ))
|
´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring z (( ))
|
z ÁÂÇ¥°¡ ÀÖ´Â ´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring m (( ))
|
Ä¡¼ö°¡ ÀÖ´Â ´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ¼±½ºÆ®¸µ
|
multilinestring zm (( ))
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ´ÙÁß ¼±½ºÆ®¸µ
|
´ÙÁß ´Ù°¢Çü
|
multipolygon empty
|
ºó ´ÙÁß ´Ù°¢Çü
|
´ÙÁß ´Ù°¢Çü
|
multipolygon z empty
|
z ÁÂÇ¥°¡ ÀÖ´Â ºó ´ÙÁß ´Ù°¢Çü
|
´ÙÁß ´Ù°¢Çü
|
multipolygon m empty
|
Ä¡¼ö°¡ ÀÖ´Â ºó ´ÙÁß ´Ù°¢Çü
|
´ÙÁß ´Ù°¢Çü
|
multipolygon z
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ºó ´ÙÁß ´Ù°¢Çü
|
´ÙÁß ´Ù°¢Çü
|
multipolygon (((
)))
|
´ÙÁß ´Ù°¢Çü
|
´ÙÁß ´Ù°¢Çü
|
multipolygon z ((( )))
|
z ÁÂÇ¥°¡ ÀÖ´Â ´ÙÁß ´Ù°¢Çü
|
´ÙÁß ´Ù°¢Çü
|
multipolygon m (((10
10 2, 10 20 3, 20 20 4, 20 15 5, 10 10 2), (50 40 7, 50 50 3,
60 50 4, 60 40 5, 50 40 7)))
|
Ä¡¼ö°¡ ÀÖ´Â ´ÙÁß ´Ù°¢Çü
|
´ÙÁß ´Ù°¢Çü
|
multipolygon zm ((( )))
|
z ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ´ÙÁß ´Ù°¢Çü
|