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

´ÙÀ½ ±ÔÄ¢Àº °ø°£ °ü·Ã ¼ú¾î¸¦ »ç¿ëÇÏ¿© °ø°£ Á¶È¸¸¦ ÃÖÀûÈ­ÇÏ·Á´Â °æ¿ì¿¡ Àû¿ëµË´Ï´Ù.

»öÀÎ ÀÌ¿ë ¿¹

Ç¥ 4¿¡¼­´Â °ø°£ »öÀÎÀ» ÀÌ¿ëÇϱâ À§ÇØ °ø°£ Á¶È¸¸¦ ÀÛ¼ºÇÒ ¶§ÀÇ ¿Ã¹Ù¸¥ ¹æ¹ý°ú Ʋ¸° ¹æ¹ýÀ» º¸¿© ÁÝ´Ï´Ù.


Ç¥ 4. »öÀÎ ÀÌ¿ë ±ÔÄ¢
°ø°£ Á¶È¸ ±ÔÄ¢ À§¹Ý

SELECT *
FROM customers c
WHERE db2gse.ST_Within(c.location,:BayArea)=1
ÀÌ ¿¹¿¡¼­´Â ¾î¶² Á¶°Çµµ À§¹ÝµÇÁö ¾Ê¾Ò½À´Ï´Ù.

SELECT *
FROM customers c
WHERE db2gse.ST_Distance(c.location,:SanJose)<10
ÀÌ ¿¹¿¡¼­´Â ¾î¶² Á¶°Çµµ À§¹ÝµÇÁö ¾Ê¾Ò½À´Ï´Ù.
SELECT *
FROM customers c
WHERE db2gse.ST_Length(c.location)>10
ST_Length´Â °ø°£ °ü·Ã ¼ú¾î°¡ ¾Æ´Õ´Ï´Ù.
SELECT *
FROM customers c
WHERE 1=db2gse.ST_Within(c.location,:BayArea)
¼ú¾î´Â ºñ±³¹®ÀÇ ¿ÞÂÊÆí¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
SELECT *
FROM customers c
WHERE db2gse.ST_Within(c.location,:BayArea)=2
µî½Ä ºñ±³¿¡¼­´Â Á¤¼ö »ó¼ö 1À» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.
SELECT *
FROM customers c
WHERE db2gse.ST_Within(:SanJose,:BayArea)=1
¼ú¾î¿¡ °Ë»ö ¸ñÇ¥·Î »ç¿ëµÈ °ø°£ Ä÷³ÀÌ ÀÖ¾î¾ß Çϰí ÇØ´ç Ä÷³¿¡ ´ëÇØ ÀÛ¼ºµÈ °ø°£ »öÀÎÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù. (SanJose ¹× BayArea´Â °ø°£ Ä÷³ÀÌ ¾Æ´Ï¹Ç·Î ¿¬°üµÈ °ø°£ »öÀÎÀ» °¡Áú ¼ö ¾ø½À´Ï´Ù.)


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