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