Skip to content

ST_ToGeometry

Converts a geography to a geometry by changing the edge interpretation to planar.

Usage

geometry ST_ToGeometry(geom: geometry)
geometry ST_ToGeometry(geog: geography)

Arguments

  • geog (geography): Input geography
  • geom (geometry): Input geometry

Description

Converts a geography to a geometry by changing the edge interpretation from spherical to planar. This is a metadata-only operation that does not modify the underlying coordinate data. If the input is already a geometry, it is returned unchanged.

Examples

SELECT ST_ToGeometry(ST_GeogFromText('POINT (-122.35 47.62)'));
┌───────────────────────────────────────────────────────────────┐
│ st_togeometry(st_geogfromtext(Utf8("POINT (-122.35 47.62)"))) │
│                            geometry                           │
╞═══════════════════════════════════════════════════════════════╡
│ POINT(-122.35 47.62)                                          │
└───────────────────────────────────────────────────────────────┘