지리공간(Geospatial) 함수

지리공간(Geospatial) 함수

지리공간 함수는 GEOGRAPHY와 GEOMETRY 타입에 대해 동작하며, GEOGRAPHY·GEOMETRY 값을 다른 표현(예: VARCHAR)으로 또는 그 반대로 변환합니다.

출처: Snowflake SQL Reference

본문

변환 / 입력 / 파싱 (Conversion / Input / Parsing)

  • ST_GEOGFROMGEOHASH — GEOGRAPHY 전용
  • ST_GEOGPOINTFROMGEOHASH — GEOGRAPHY 전용
  • ST_GEOGRAPHYFROMWKB — GEOGRAPHY 전용
  • ST_GEOGRAPHYFROMWKT — GEOGRAPHY 전용
  • ST_GEOMETRYFROMWKB — GEOMETRY 전용
  • ST_GEOMETRYFROMWKT — GEOMETRY 전용
  • ST_GEOMFROMGEOHASH — GEOMETRY 전용
  • ST_GEOMPOINTFROMGEOHASH — GEOMETRY 전용
  • TO_GEOGRAPHY — GEOGRAPHY 전용
  • TO_GEOMETRY — GEOMETRY 전용
  • TRY_TO_GEOGRAPHY — GEOGRAPHY 전용
  • TRY_TO_GEOMETRY — GEOMETRY 전용

변환 / 출력 / 포맷팅 (Conversion / Output / Formatting)

  • ST_ASGEOJSON
  • ST_ASWKB
  • ST_ASBINARY — ST_ASWKB의 별칭
  • ST_ASEWKB
  • ST_ASWKT
  • ST_ASTEXT — ST_ASWKT의 별칭
  • ST_ASEWKT
  • ST_GEOHASH

생성자 함수 (Constructor Functions)

  • ST_MAKELINE
  • ST_MAKEGEOMPOINT — GEOMETRY 전용
  • ST_GEOMPOINT — ST_MAKEGEOMPOINT의 별칭
  • ST_MAKEPOINT — GEOGRAPHY 전용
  • ST_POINT — ST_MAKEPOINT의 별칭
  • ST_MAKEPOLYGON
  • ST_POLYGON — ST_MAKEPOLYGON의 별칭
  • ST_MAKEPOLYGONORIENTED — GEOGRAPHY 전용

접근자 함수 (Accessor Functions)

  • ST_DIMENSION
  • ST_ENDPOINT
  • ST_POINTN
  • ST_SRID
  • ST_STARTPOINT
  • ST_X
  • ST_XMAX
  • ST_XMIN
  • ST_Y
  • ST_YMAX
  • ST_YMIN

관계·측정 함수 (Relationship and Measurement Functions)

  • HAVERSINE
  • ST_AREA
  • ST_AZIMUTH
  • ST_CONTAINS
  • ST_COVEREDBY
  • ST_COVERS
  • ST_DISJOINT
  • ST_DISTANCE
  • ST_DWITHIN — GEOGRAPHY 전용
  • ST_HAUSDORFFDISTANCE — GEOGRAPHY 전용
  • ST_INTERSECTS
  • ST_LENGTH
  • ST_NPOINTS
  • ST_NUMPOINTS — ST_NPOINTS의 별칭
  • ST_PERIMETER
  • ST_WITHIN

변환 함수 (Transformation Functions)

  • ST_BUFFER — GEOMETRY 전용
  • ST_CENTROID
  • ST_COLLECT (스칼라 및 집계) — GEOGRAPHY 전용
  • ST_DIFFERENCE — GEOGRAPHY 전용
  • ST_ENVELOPE — GEOGRAPHY에서는 더 이상 사용하지 않음(Deprecated)
  • ST_INTERPOLATE — GEOGRAPHY 전용
  • ST_INTERSECTION — GEOGRAPHY 전용
  • ST_INTERSECTION_AGG (스칼라 및 집계) — GEOGRAPHY 전용
  • ST_SETSRID — GEOMETRY 전용
  • ST_SIMPLIFY
  • ST_SYMDIFFERENCE — GEOGRAPHY 전용
  • ST_TRANSFORM — GEOMETRY 전용
  • ST_UNION — GEOGRAPHY 전용
  • ST_UNION_AGG (스칼라 및 집계) — GEOGRAPHY 전용

유틸리티 함수 (Utility Functions)

  • ST_ISVALID

H3 함수 (H3 Functions)

  • H3_CELL_TO_BOUNDARY — GEOGRAPHY 전용
  • H3_CELL_TO_CHILDREN — GEOGRAPHY 전용
  • H3_CELL_TO_CHILDREN_STRING — GEOGRAPHY 전용
  • H3_CELL_TO_PARENT — GEOGRAPHY 전용
  • H3_CELL_TO_POINT — GEOGRAPHY 전용
  • H3_COMPACT_CELLS — GEOGRAPHY 전용
  • H3_COMPACT_CELLS_STRINGS — GEOGRAPHY 전용
  • H3_COVERAGE — GEOGRAPHY 전용
  • H3_COVERAGE_STRINGS — GEOGRAPHY 전용
  • H3_GET_RESOLUTION — GEOGRAPHY 전용
  • H3_GRID_DISTANCE — GEOGRAPHY 전용
  • H3_GRID_DISK — GEOGRAPHY 전용
  • H3_GRID_PATH — GEOGRAPHY 전용
  • H3_INT_TO_STRING — GEOGRAPHY 전용
  • H3_IS_PENTAGON — GEOGRAPHY 전용
  • H3_IS_VALID_CELL — GEOGRAPHY 전용
  • H3_LATLNG_TO_CELL — GEOGRAPHY 전용
  • H3_LATLNG_TO_CELL_STRING — GEOGRAPHY 전용
  • H3_POINT_TO_CELL — GEOGRAPHY 전용
  • H3_POINT_TO_CELL_STRING — GEOGRAPHY 전용
  • H3_POLYGON_TO_CELLS — GEOGRAPHY 전용
  • H3_POLYGON_TO_CELLS_STRINGS — GEOGRAPHY 전용
  • H3_STRING_TO_INT — GEOGRAPHY 전용
  • H3_TRY_COVERAGE — GEOGRAPHY 전용
  • H3_TRY_COVERAGE_STRINGS — GEOGRAPHY 전용
  • H3_TRY_GRID_DISTANCE — GEOGRAPHY 전용
  • H3_TRY_GRID_PATH — GEOGRAPHY 전용
  • H3_TRY_POLYGON_TO_CELLS — GEOGRAPHY 전용
  • H3_TRY_POLYGON_TO_CELLS_STRINGS — GEOGRAPHY 전용
  • H3_UNCOMPACT_CELLS — GEOGRAPHY 전용
  • H3_UNCOMPACT_CELLS_STRINGS — GEOGRAPHY 전용

더 알아보기 (Learn more)