Geography Functions¶
The Geography type in Sedona represents spatial objects on a spherical (geodesic) model of the Earth. Unlike the planar Geometry type, distance, area, and other measurements performed on Geography objects account for the curvature of the Earth and return results in real-world units (e.g., meters).
Geography Constructors¶
These functions create geography objects from various formats.
| Function | Description | Since |
|---|---|---|
| ST_GeogFromEWKB | Construct a Geography from EWKB Binary. This function is an alias of ST_GeogFromWKB. | v1.8.0 |
| ST_GeogFromEWKT | Construct a Geography from OGC Extended WKT. | v1.8.0 |
| ST_GeogFromGeoHash | Create Geography from geohash string and optional precision | v1.8.0 |
| ST_GeogFromWKB | Construct a Geography from WKB Binary. | v1.8.0 |
| ST_GeogFromWKT | Construct a Geography from WKT. If SRID is not set, it defaults to 0 (unknown). | v1.8.0 |
| ST_GeogToGeometry | This function constructs a planar Geometry object from a Geography. While Sedona makes every effort to preserve the original spatial object, the conversion is not always exact because Geography and... | v1.8.0 |
| ST_GeomToGeography | This function constructs a Geography object from a planar Geometry. This function is intended for geometries defined in a Geographic Coordinate Reference System (CRS), most commonly WGS84 (EPSG:432... | v1.8.0 |
Geography Functions¶
These functions operate on geography type objects.
| Function | Description | Since |
|---|---|---|
| ST_AsEWKT | Return the Extended Well-Known Text representation of a geography. EWKT is an extended version of WKT which includes the SRID of the geography. The format originated in PostGIS but is supported by ... | v1.8.0 |
| ST_Envelope | This function returns the bounding box (envelope) of A. It's important to note that the bounding box is calculated using a cylindrical topology, not a spherical one. If the envelope crosses the ant... | v1.8.0 |