Bigquery Functions
Geography Functions
Bigquery Functions
Geography Functions
s2_cellidfrompoint
Supported Signatures
function s2_cellidfrompoint(geography) returns bigint
s2_coveringcellids
Supported Signatures
function s2_coveringcellids(geography) returns array<bigint>
st_angle
Supported Signatures
function st_angle(geography, geography, geography) returns double
st_area
Supported Signatures
function st_area(geography) returns double
function st_area(geography, bool) returns double
st_asbinary
Supported Signatures
function st_asbinary(geography) returns bytes
st_asgeojson
Supported Signatures
function st_asgeojson(geography) returns string
st_astext
Supported Signatures
function st_astext(geography) returns string
st_azimuth
Supported Signatures
function st_azimuth(geography, geography) returns double
st_boundary
Supported Signatures
function st_boundary(geography) returns geography
st_boundingbox
Supported Signatures
function st_boundingbox(geography) returns geography
st_buffer
Supported Signatures
function st_buffer(geography, double) returns geography
function st_buffer(geography, double, double) returns geography
st_bufferwithtolerance
Supported Signatures
function st_bufferwithtolerance(geography, double, double) returns
st_centroid
Supported Signatures
function st_centroid(geography) returns geography
st_centroid_agg
Supported Signatures
function st_centroid_agg(geography) returns geography
st_closestpoint
Supported Signatures
function st_closestpoint(geography, geography) returns geography
function st_closestpoint(geography, geography, bool) returns geography
st_clusterdbscan
Supported Signatures
function st_clusterdbscan(geography, double, bigint) returns bigint
st_contains
Supported Signatures
function st_contains(geography, geography) returns bool
st_convexhull
Supported Signatures
function st_convexhull(geography) returns geography
st_coveredby
Supported Signatures
function st_coveredby(geography, geography) returns bool
st_covers
Supported Signatures
function st_covers(geography, geography) returns bool
st_difference
Supported Signatures
function st_difference(geography, geography) returns geography
st_dimension
Supported Signatures
function st_dimension(geography) returns bigint
st_disjoint
Supported Signatures
function st_disjoint(geography, geography) returns bool
st_distance
Supported Signatures
function st_distance(geography, geography) returns double
function st_distance(geography, geography, bool) returns double
st_dump
Supported Signatures
function st_dump(geography) returns geography
function st_dump(geography, bigint) returns geography
st_dwithin
Supported Signatures
function st_dwithin(geography, geography, double) returns bool
st_endpoint
Supported Signatures
function st_endpoint(geography) returns geography
st_equals
Supported Signatures
function st_equals(geography, geography) returns bool
st_exteriorring
Supported Signatures
function st_exteriorring(geography) returns geography
st_geogfrom
Supported Signatures
function st_geogfrom(string) returns geography
function st_geogfrom(bytes) returns geography
st_geogfromgeojson
Supported Signatures
function st_geogfromgeojson(string) returns geography
st_geogfromtext
Supported Signatures
function st_geogfromtext(string, bool) returns geography
function st_geogfromtext(string) returns geography
st_geogfromwkb
Supported Signatures
function st_geogfromwkb(bytes) returns geography
function st_geogfromwkb(string) returns geography
st_geogpoint
Supported Signatures
function st_geogpoint(double, double) returns geography
st_geogpointfromgeohash
Supported Signatures
function st_geogpointfromgeohash(string) returns geography
function st_geogpointfromgeohash(string, double, double) returns geography
st_geohash
Supported Signatures
function st_geohash(geography) returns string
function st_geohash(geography, bigint) returns string
st_geometrytype
Supported Signatures
function st_geometrytype(geography) returns string
st_interiorrings
Supported Signatures
function st_interiorrings(geography) returns array<geography>
st_intersection
Supported Signatures
function st_intersection(geography, geography) returns geography
st_intersects
Supported Signatures
function st_intersects(geography, geography) returns bool
st_intersectsbox
Supported Signatures
function st_intersectsbox(geography, double, double, double, double) returns bool
st_isclosed
Supported Signatures
function st_isclosed(geography) returns bool
st_iscollection
Supported Signatures
function st_iscollection(geography) returns bool
st_isempty
Supported Signatures
function st_isempty(geography) returns bool
st_isring
Supported Signatures
function st_isring(geography) returns bool
st_length
Supported Signatures
function st_length(geography) returns double
function st_length(geography, bool) returns double
st_linelocatepoint
Supported Signatures
function st_linelocatepoint(geography, geography) returns double
st_makeline
Supported Signatures
function st_makeline(geography, geography) returns geography
st_makepolygon
Supported Signatures
function st_makepolygon(geography) returns geography
function st_makepolygon(geography, array<geography>) returns geography
st_makepolygonoriented
Supported Signatures
function st_makepolygonoriented(array<geography>) returns geography
st_maxdistance
Supported Signatures
function st_maxdistance(geography, geography) returns double
function st_maxdistance(geography, geography, bool) returns double
st_npoints
Supported Signatures
function st_npoints(geography) returns bigint
st_numgeometries
Supported Signatures
function st_numgeometries(geography) returns bigint
st_numpoints
Supported Signatures
function st_numpoints(geography) returns bigint
st_perimeter
Supported Signatures
function st_perimeter(geography) returns double
function st_perimeter(geography, bool) returns double
st_pointn
Supported Signatures
function st_pointn(geography, bigint) returns geography
st_simplify
Supported Signatures
function st_simplify(geography, bigint) returns geography
st_snaptogrid
Supported Signatures
function st_snaptogrid(geography, double) returns
st_startpoint
Supported Signatures
function st_startpoint(geography) returns geography
st_touches
Supported Signatures
function st_touches(geography, geography) returns bool
st_union
Supported Signatures
function st_union(geography, geography) returns geography
st_union_agg
Supported Signatures
function st_union_agg(geography) returns geography
st_within
Supported Signatures
function st_within(geography, geography) returns bool
st_x
Supported Signatures
function st_x(geography) returns double
st_y
Supported Signatures
function st_y(geography) returns double