Geography Functions

`s2_cellidfrompoint`

Supported Signatures

function s2_cellidfrompoint(geography) returns bigint

🔗 Official Documentation

`s2_coveringcellids`

Supported Signatures

function s2_coveringcellids(geography) returns array<bigint>

🔗 Official Documentation

`st_angle`

Supported Signatures

function st_angle(geography, geography, geography) returns double

🔗 Official Documentation

`st_area`

Supported Signatures

function st_area(geography) returns double
function st_area(geography, bool) returns double

🔗 Official Documentation

`st_asbinary`

Supported Signatures

function st_asbinary(geography) returns bytes

🔗 Official Documentation

`st_asgeojson`

Supported Signatures

function st_asgeojson(geography) returns string

🔗 Official Documentation

`st_astext`

Supported Signatures

function st_astext(geography) returns string

🔗 Official Documentation

`st_azimuth`

Supported Signatures

function st_azimuth(geography, geography) returns double

🔗 Official Documentation

`st_boundary`

Supported Signatures

function st_boundary(geography) returns geography

🔗 Official Documentation

`st_boundingbox`

Supported Signatures

function st_boundingbox(geography) returns geography

🔗 Official Documentation

`st_buffer`

Supported Signatures

function st_buffer(geography, double) returns geography
function st_buffer(geography, double, double) returns geography

🔗 Official Documentation

`st_bufferwithtolerance`

Supported Signatures

function st_bufferwithtolerance(geography, double, double) returns

🔗 Official Documentation

`st_centroid`

Supported Signatures

function st_centroid(geography) returns geography

🔗 Official Documentation

`st_centroid_agg`

Supported Signatures

function st_centroid_agg(geography) returns geography

🔗 Official Documentation

`st_closestpoint`

Supported Signatures

function st_closestpoint(geography, geography) returns geography
function st_closestpoint(geography, geography, bool) returns geography

🔗 Official Documentation

`st_clusterdbscan`

Supported Signatures

function st_clusterdbscan(geography, double, bigint) returns bigint

🔗 Official Documentation

`st_contains`

Supported Signatures

function st_contains(geography, geography) returns bool

🔗 Official Documentation

`st_convexhull`

Supported Signatures

function st_convexhull(geography) returns geography

🔗 Official Documentation

`st_coveredby`

Supported Signatures

function st_coveredby(geography, geography) returns bool

🔗 Official Documentation

`st_covers`

Supported Signatures

function st_covers(geography, geography) returns bool

🔗 Official Documentation

`st_difference`

Supported Signatures

function st_difference(geography, geography) returns geography

🔗 Official Documentation

`st_dimension`

Supported Signatures

function st_dimension(geography) returns bigint

🔗 Official Documentation

`st_disjoint`

Supported Signatures

function st_disjoint(geography, geography) returns bool

🔗 Official Documentation

`st_distance`

Supported Signatures

function st_distance(geography, geography) returns double
function st_distance(geography, geography, bool) returns double

🔗 Official Documentation

`st_dump`

Supported Signatures

function st_dump(geography) returns geography
function st_dump(geography, bigint) returns geography

🔗 Official Documentation

`st_dwithin`

Supported Signatures

function st_dwithin(geography, geography, double) returns bool

🔗 Official Documentation

`st_endpoint`

Supported Signatures

function st_endpoint(geography) returns geography

🔗 Official Documentation

`st_equals`

Supported Signatures

function st_equals(geography, geography) returns bool

🔗 Official Documentation

`st_exteriorring`

Supported Signatures

function st_exteriorring(geography) returns geography

🔗 Official Documentation

`st_geogfrom`

Supported Signatures

function st_geogfrom(string) returns geography
function st_geogfrom(bytes) returns geography

🔗 Official Documentation

`st_geogfromgeojson`

Supported Signatures

function st_geogfromgeojson(string) returns geography

🔗 Official Documentation

`st_geogfromtext`

Supported Signatures

function st_geogfromtext(string, bool) returns geography
function st_geogfromtext(string) returns geography

🔗 Official Documentation

`st_geogfromwkb`

Supported Signatures

function st_geogfromwkb(bytes) returns geography
function st_geogfromwkb(string) returns geography

🔗 Official Documentation

`st_geogpoint`

Supported Signatures

function st_geogpoint(double, double) returns geography

🔗 Official Documentation

`st_geogpointfromgeohash`

Supported Signatures

function st_geogpointfromgeohash(string) returns geography
function st_geogpointfromgeohash(string, double, double) returns geography

🔗 Official Documentation

`st_geohash`

Supported Signatures

function st_geohash(geography) returns string
function st_geohash(geography, bigint) returns string

🔗 Official Documentation

`st_geometrytype`

Supported Signatures

function st_geometrytype(geography) returns string

🔗 Official Documentation

`st_interiorrings`

Supported Signatures

function st_interiorrings(geography) returns array<geography>

🔗 Official Documentation

`st_intersection`

Supported Signatures

function st_intersection(geography, geography) returns geography

🔗 Official Documentation

`st_intersects`

Supported Signatures

function st_intersects(geography, geography) returns bool

🔗 Official Documentation

`st_intersectsbox`

Supported Signatures

function st_intersectsbox(geography, double, double, double, double) returns bool

🔗 Official Documentation

`st_isclosed`

Supported Signatures

function st_isclosed(geography) returns bool

🔗 Official Documentation

`st_iscollection`

Supported Signatures

function st_iscollection(geography) returns bool

🔗 Official Documentation

`st_isempty`

Supported Signatures

function st_isempty(geography) returns bool

🔗 Official Documentation

`st_isring`

Supported Signatures

function st_isring(geography) returns bool

🔗 Official Documentation

`st_length`

Supported Signatures

function st_length(geography) returns double
function st_length(geography, bool) returns double

🔗 Official Documentation

`st_linelocatepoint`

Supported Signatures

function st_linelocatepoint(geography, geography) returns double

🔗 Official Documentation

`st_makeline`

Supported Signatures

function st_makeline(geography, geography) returns geography

🔗 Official Documentation

`st_makepolygon`

Supported Signatures

function st_makepolygon(geography) returns geography
function st_makepolygon(geography, array<geography>) returns geography

🔗 Official Documentation

`st_makepolygonoriented`

Supported Signatures

function st_makepolygonoriented(array<geography>) returns geography

🔗 Official Documentation

`st_maxdistance`

Supported Signatures

function st_maxdistance(geography, geography) returns double
function st_maxdistance(geography, geography, bool) returns double

🔗 Official Documentation

`st_npoints`

Supported Signatures

function st_npoints(geography) returns bigint

🔗 Official Documentation

`st_numgeometries`

Supported Signatures

function st_numgeometries(geography) returns bigint

🔗 Official Documentation

`st_numpoints`

Supported Signatures

function st_numpoints(geography) returns bigint

🔗 Official Documentation

`st_perimeter`

Supported Signatures

function st_perimeter(geography) returns double
function st_perimeter(geography, bool) returns double

🔗 Official Documentation

`st_pointn`

Supported Signatures

function st_pointn(geography, bigint) returns geography

🔗 Official Documentation

`st_simplify`

Supported Signatures

function st_simplify(geography, bigint) returns geography

🔗 Official Documentation

`st_snaptogrid`

Supported Signatures

function st_snaptogrid(geography, double) returns

🔗 Official Documentation

`st_startpoint`

Supported Signatures

function st_startpoint(geography) returns geography

🔗 Official Documentation

`st_touches`

Supported Signatures

function st_touches(geography, geography) returns bool

🔗 Official Documentation

`st_union`

Supported Signatures

function st_union(geography, geography) returns geography

🔗 Official Documentation

`st_union_agg`

Supported Signatures

function st_union_agg(geography) returns geography

🔗 Official Documentation

`st_within`

Supported Signatures

function st_within(geography, geography) returns bool

🔗 Official Documentation

`st_x`

Supported Signatures

function st_x(geography) returns double

🔗 Official Documentation

`st_y`

Supported Signatures

function st_y(geography) returns double

🔗 Official Documentation

​s2_cellidfrompoint

​s2_coveringcellids

​st_angle

​st_area

​st_asbinary

​st_asgeojson

​st_astext

​st_azimuth

​st_boundary

​st_boundingbox

​st_buffer

​st_bufferwithtolerance

​st_centroid

​st_centroid_agg

​st_closestpoint

​st_clusterdbscan

​st_contains

​st_convexhull

​st_coveredby

​st_covers

​st_difference

​st_dimension

​st_disjoint

​st_distance

​st_dump

​st_dwithin

​st_endpoint

​st_equals

​st_exteriorring

​st_geogfrom

​st_geogfromgeojson

​st_geogfromtext

​st_geogfromwkb

​st_geogpoint

​st_geogpointfromgeohash

​st_geohash

​st_geometrytype

​st_interiorrings

​st_intersection

​st_intersects

​st_intersectsbox

​st_isclosed

​st_iscollection

​st_isempty

​st_isring

​st_length

​st_linelocatepoint

​st_makeline

​st_makepolygon

​st_makepolygonoriented

​st_maxdistance

​st_npoints

​st_numgeometries

​st_numpoints

​st_perimeter

​st_pointn

​st_simplify

​st_snaptogrid

​st_startpoint

​st_touches

​st_union

​st_union_agg

​st_within

​st_x

​st_y

`s2_cellidfrompoint`

`s2_coveringcellids`

`st_angle`

`st_area`

`st_asbinary`

`st_asgeojson`

`st_astext`

`st_azimuth`

`st_boundary`

`st_boundingbox`

`st_buffer`

`st_bufferwithtolerance`

`st_centroid`

`st_centroid_agg`

`st_closestpoint`

`st_clusterdbscan`

`st_contains`

`st_convexhull`

`st_coveredby`

`st_covers`

`st_difference`

`st_dimension`

`st_disjoint`

`st_distance`

`st_dump`

`st_dwithin`

`st_endpoint`

`st_equals`

`st_exteriorring`

`st_geogfrom`

`st_geogfromgeojson`

`st_geogfromtext`

`st_geogfromwkb`

`st_geogpoint`

`st_geogpointfromgeohash`

`st_geohash`

`st_geometrytype`

`st_interiorrings`

`st_intersection`

`st_intersects`

`st_intersectsbox`

`st_isclosed`

`st_iscollection`

`st_isempty`

`st_isring`

`st_length`

`st_linelocatepoint`

`st_makeline`

`st_makepolygon`

`st_makepolygonoriented`

`st_maxdistance`

`st_npoints`

`st_numgeometries`

`st_numpoints`

`st_perimeter`

`st_pointn`

`st_simplify`

`st_snaptogrid`

`st_startpoint`

`st_touches`

`st_union`

`st_union_agg`

`st_within`

`st_x`

`st_y`