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


OGC Àß ¾Ë·ÁÁø ÅØ½ºÆ® Ç¥Çö½Ä

Spatial Extender¿¡´Â ÅØ½ºÆ® ¼³¸íÀ¸·ÎºÎÅÍ ±âÇÏÇÐÀ» »ý¼ºÇÏ´Â ¿©·¯ ÇÔ¼ö°¡ ÀÖ½À´Ï´Ù.

ST_GeomFromText
±âÇÏÇÐ À¯ÇüÀÇ ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·ÎºÎÅÍ ±âÇÏÇÐÀ» ÀÛ¼ºÇÕ´Ï´Ù.

ST_PointFromText
Á¡ ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·ÎºÎÅÍ Á¡À» ÀÛ¼ºÇÕ´Ï´Ù.

ST_LineFromText
¼±½ºÆ®¸µ ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·ÎºÎÅÍ ¼±½ºÆ®¸µÀ» ÀÛ¼ºÇÕ´Ï´Ù.

ST_PolyFromText
´Ù°¢Çü ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·ÎºÎÅÍ ´Ù°¢ÇüÀ» ÀÛ¼ºÇÕ´Ï´Ù.

ST_MPointFromText
´ÙÁßÁ¡ ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·ÎºÎÅÍ ´ÙÁßÁ¡À» ÀÛ¼ºÇÕ´Ï´Ù.

ST_MLineFromText
´ÙÁß ¼±½ºÆ®¸µ ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·ÎºÎÅÍ ´ÙÁß ¼±½ºÆ®¸µÀ» ÀÛ¼ºÇÕ´Ï´Ù.

ST_MPolyFromText
´ÙÁß ´Ù°¢Çü ÅØ½ºÆ® Ç¥Çö½ÄÀ¸·ÎºÎÅÍ ´ÙÁß ´Ù°¢ÇüÀ» ÀÛ¼ºÇÕ´Ï´Ù.

ÅØ½ºÆ® Ç¥Çö½ÄÀº ±âÇÏÇÐÀÌ 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°¡ ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù.

ÅØ½ºÆ® ¼³¸íÀº ÀÛÀº µû¿ÈÇ¥·Î ¹­ÀÎ ¼¼ °¡Áö ±âº» ±¸¼º¿ä¼Ò·Î ±¸¼ºµË´Ï´Ù. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.

<'±âÇÏÇÐ À¯Çü'> ['ÁÂÇ¥ À¯Çü'] [''ÁÂÇ¥ ¸ñ·Ï']

¿©±â¼­:

±âÇÏÇÐ À¯Çü
Á¡, ¼±½ºÆ®¸µ, ´Ù°¢Çü, ´ÙÁßÁ¡, ´ÙÁß ¼±½ºÆ®¸µ ¶Ç´Â ´ÙÁß ´Ù°¢Çü Áß ÇϳªÀÔ´Ï´Ù.

ÁÂÇ¥ À¯Çü
±âÇÏÇп¡ Z ÁÂÇ¥ ¶Ç´Â Ä¡¼ö°¡ ÀÖ´ÂÁö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. µÑ ´Ù ±âÇÏÇп¡ ¾ø´Â °æ¿ì¿¡´Â ÀÌ Àμö¸¦ °ø¹éÀ¸·Î ³²°Ü µÎ½Ê½Ã¿À. ±×·¸Áö ¾ÊÀ¸¸é Z ÁÂÇ¥°¡ µé¾î ÀÖ´Â ±âÇÏÇÐÀÇ °æ¿ì¿¡´Â ÁÂÇ¥ À¯ÇüÀ» Z·Î, Ä¡¼ö°¡ ÀÖ´Â ±âÇÏÇÐÀÇ °æ¿ì¿¡´Â MÀ¸·Î, µÑ ´Ù ÀÖ´Â ±âÇÏÇÐÀÇ °æ¿ì¿¡´Â ZMÀ¸·Î ¼³Á¤ÇϽʽÿÀ.

ÁÂÇ¥ ¸ñ·Ï
±âÇÏÇÐÀÇ Á¤Á¡À» Á¤ÀÇÇÕ´Ï´Ù. ÁÂÇ¥ ¸ñ·ÏÀº ½°Ç¥·Î ±¸ºÐµÇ°í °ýÈ£·Î ¹­¾îÁý´Ï´Ù. ´ÙÁß ±¸¼º¿ä¼Ò°¡ ÀÖ´Â ±âÇÏÇп¡´Â °¢ ±¸¼º¿ä¼Ò ºÎºÐÀ» ¹­À» °ýÈ£ ¼¼Æ®°¡ ÇÊ¿äÇÕ´Ï´Ù. ±âÇÏÇÐÀÌ ºñ¾î ÀÖÀ¸¸é EMPTY Ű¿öµå°¡ ÁÂÇ¥¸¦ ¹Ù²ß´Ï´Ù.

Ç¥ 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 ÁÂÇ¥ ¹× Ä¡¼ö°¡ ÀÖ´Â ´ÙÁß ´Ù°¢Çü


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