ST\_GeogFromGeoJSON
ST_GeogFromGeoJSON
ST_GeogFromGeoJSON 함수는 GeoJSON 표현에서 지정한 지리(geography) 값을 반환하는 함수예요.
출처: 문서
본문
GeoJSON 표현에서 지정한 지리 값을 반환해요.
시그니처 (Signature)
ST_GeogFromGeoJSON(geoJSON)
사용 예시 (Usage Examples)
select ST_GeogFromGeoJSON(
'{ "type": "Point", "coordinates": [100.0, 0.0] }'
) AS value
from ignoreMe
| value |
|---|
| 8040590000000000000000000000000000 |
select ST_GeogFromGeoJSON(
'{
"type": "LineString",
"coordinates": [
[100.0, 0.0],
[101.0, 1.0]
]
}') AS value
from ignoreMe
| value |
|---|
| 820000000100000002000000004059000000000000000000000000000040594000000000003ff0000000000000 |
select ST_GeogFromGeoJSON(
'{
"type": "Polygon",
"coordinates": [
[
[100.0, 0.0],
[101.0, 0.0],
[101.0, 1.0],
[100.0, 1.0],
[100.0, 0.0]
]
]
}') AS value
from ignoreMe
| value |
|---|
| 840000000100000005000000004059000000000000000000000000000040590000000000003ff000000000000040594000000000003ff00000000000004059400000000000000000000000000040590000000000000000000000000000 |