ST\_GeogFromText
ST_GeogFromText
ST_GeogFromText 함수는 Well-Known Text 표현 또는 확장형 (WKT)에서 지정한 지리(geography) 값을 반환하는 함수예요.
출처: 문서
본문
Well-Known Text 표현 또는 확장형 (WKT)에서 지정한 지리 값을 반환해요.
시그니처 (Signature)
ST_GeogFromText(wkt)
사용 예시 (Usage Examples)
select ST_GeogFromText('POINT (30 10)') AS value
from ignoreMe
| value |
|---|
| 80403e0000000000004024000000000000 |
select ST_GeogFromText('LINESTRING (30 10, 10 30, 40 40)') AS value
from ignoreMe
| value |
|---|
| 82000000010000000300000000403e00000000000040240000000000004024000000000000403e00000000000040440000000000004044000000000000 |
select ST_GeogFromText('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))') AS value
from ignoreMe
| value |
|---|
| 84000000010000000500000000403e0000000000004024000000000000402400000000000040340000000000004034000000000000404400000000000040440000000000004044000000000000403e0000000000004024000000000000 |