Geospatial Functions

h3_cell_to_boundary

Returns a polygon containing the h3 integer cell boundaries Supported Signatures

function h3_cell_to_boundary(decimal(38, 0)) returns geography
function h3_cell_to_boundary(varchar) returns geography

🔗 Official Documentation

h3_cell_to_children

Returns the H3 children cells as integers for a given H3 index Supported Signatures

function h3_cell_to_children(decimal(38, 0), decimal(38, 0)) returns array

🔗 Official Documentation

h3_cell_to_children_string

Returns the H3 children cells as strings for a given H3 index Supported Signatures

function h3_cell_to_children_string(varchar, decimal(38, 0)) returns array

🔗 Official Documentation

h3_cell_to_parent

Returns the H3 parent cell as an integer for a given H3 index Supported Signatures

function h3_cell_to_parent(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function h3_cell_to_parent(varchar, decimal(38, 0)) returns varchar

🔗 Official Documentation

h3_cell_to_point

Returns a point (geography) corresponding to the center of the h3 integer cell passed Supported Signatures

function h3_cell_to_point(decimal(38, 0)) returns geography
function h3_cell_to_point(varchar) returns geography

🔗 Official Documentation

h3_coverage

Returns the full spherical based covering of H3 cells as integers for any geography type Supported Signatures

function h3_coverage(geography, decimal(38, 0)) returns array

🔗 Official Documentation

h3_coverage_strings

Returns the full spherical based covering of H3 cells as strings for any geography type Supported Signatures

function h3_coverage_strings(geography, decimal(38, 0)) returns array

🔗 Official Documentation

h3_get_resolution

Returns the cell resolution for a given H3 integer cell Supported Signatures

function h3_get_resolution(decimal(38, 0)) returns decimal(38, 0)
function h3_get_resolution(varchar) returns decimal(38, 0)

🔗 Official Documentation

h3_grid_disk

Returns all H3 cells that are at most k steps away from the input cell Supported Signatures

function h3_grid_disk(decimal(38, 0), decimal(38, 0)) returns array
function h3_grid_disk(varchar, decimal(38, 0)) returns array

🔗 Official Documentation

h3_grid_distance

Returns the number of H3 cells that are betweem two input cells Supported Signatures

function h3_grid_distance(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function h3_grid_distance(varchar, varchar) returns decimal(38, 0)

🔗 Official Documentation

h3_grid_path

Returns all H3 cells that are along the straight line connecting both cells Supported Signatures

function h3_grid_path(decimal(38, 0), decimal(38, 0)) returns array
function h3_grid_path(varchar, varchar) returns array

🔗 Official Documentation

h3_int_to_string

Returns the H3 cell formatted as a string given its integer representation Supported Signatures

function h3_int_to_string(decimal(38, 0)) returns varchar

🔗 Official Documentation

h3_latlng_to_cell

Returns an H3 index as an integer that corresponds to a given point (lat/lng) and resolution Supported Signatures

function h3_latlng_to_cell(double, double, decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

h3_latlng_to_cell_string

Returns an H3 index as a string that corresponds to a given point (lat/lng) and resolution Supported Signatures

function h3_latlng_to_cell_string(double, double, decimal(38, 0)) returns varchar

🔗 Official Documentation

h3_point_to_cell

Returns an H3 integer cell that corresponds to a given point (geography) and resolution Supported Signatures

function h3_point_to_cell(geography, decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

h3_point_to_cell_string

Returns an H3 string cell that corresponds to a given point (geography) and resolution Supported Signatures

function h3_point_to_cell_string(geography, decimal(38, 0)) returns varchar

🔗 Official Documentation

h3_polygon_to_cells

Returns the planar centroid based covering of H3 cells as integers for a polygon/multipolygon Supported Signatures

function h3_polygon_to_cells(geography, decimal(38, 0)) returns array

🔗 Official Documentation

h3_polygon_to_cells_strings

Returns the planar centroid based covering of H3 cells as strings for a polygon/multipolygon Supported Signatures

function h3_polygon_to_cells_strings(geography, decimal(38, 0)) returns array

🔗 Official Documentation

h3_string_to_int

Returns the H3 cell formatted as an integer given its string representation Supported Signatures

function h3_string_to_int(varchar) returns decimal(38, 0)

🔗 Official Documentation

haversine

Calculate great circle distance (in km) from two (lat, lon) locations (degrees). Supported Signatures

function haversine(double, double, double, double) returns double

🔗 Official Documentation

st_area

Area of the object in square meters Supported Signatures

function st_area(geography) returns double
function st_area(geometry) returns double

🔗 Official Documentation

st_asbinary

Return the WKB representation of the GEOGRAPHY object Supported Signatures

function st_asbinary(geography) returns binary
function st_asbinary(geometry) returns binary

🔗 Official Documentation

st_asewkb

Return the EWKB representation of the GEOGRAPHY object Supported Signatures

function st_asewkb(geography) returns binary
function st_asewkb(geometry) returns binary

🔗 Official Documentation

st_asewkt

Return the WKB representation of the GEOGRAPHY object Supported Signatures

function st_asewkt(geography) returns varchar
function st_asewkt(geometry) returns varchar

🔗 Official Documentation

st_asgeojson

Return the GeoJSON representation of the GEOGRAPHY object Supported Signatures

function st_asgeojson(geography) returns object
function st_asgeojson(geometry) returns object

🔗 Official Documentation

st_astext

Return the WKT representation of the GEOGRAPHY object Supported Signatures

function st_astext(geography) returns varchar
function st_astext(geometry) returns varchar

🔗 Official Documentation

st_aswkb

Return the WKB representation of the GEOGRAPHY object Supported Signatures

function st_aswkb(geography) returns binary
function st_aswkb(geometry) returns binary

🔗 Official Documentation

st_aswkt

Return the WKB representation of the GEOGRAPHY object Supported Signatures

function st_aswkt(geography) returns varchar
function st_aswkt(geometry) returns varchar

🔗 Official Documentation

st_azimuth

Returns the azimuth in radians of the segment defined by the given point Supported Signatures

function st_azimuth(geography, geography) returns double
function st_azimuth(geometry, geometry) returns double

🔗 Official Documentation

st_buffer

Returns the geometry generated by the buffer operation upon the given input geometry using the diven distance Supported Signatures

function st_buffer(geometry, double) returns geometry

🔗 Official Documentation

st_centroid

The centroid of geography Supported Signatures

function st_centroid(geography) returns geography
function st_centroid(geometry) returns geometry

🔗 Official Documentation

st_collect

Aggregates all geographies into a GeometryCollection or Multi* geography if they are all of the same single element type (e.g. Point) Supported Signatures

function st_collect(geography) returns geography
function st_collect(geography, geography) returns geography

🔗 Official Documentation

st_contains

True if the first object fully contains the second Supported Signatures

function st_contains(geography, geography) returns boolean
function st_contains(geometry, geometry) returns boolean

🔗 Official Documentation

st_coveredby

True if the second object covers the first Supported Signatures

function st_coveredby(geography, geography) returns boolean
function st_coveredby(geometry, geometry) returns boolean

🔗 Official Documentation

st_covers

True if the first object covers the second Supported Signatures

function st_covers(geography, geography) returns boolean
function st_covers(geometry, geometry) returns boolean

🔗 Official Documentation

st_difference

Geometry representing the set difference a minus b Supported Signatures

function st_difference(geography, geography) returns geography

🔗 Official Documentation

st_dimension

The dimension of the input geography Supported Signatures

function st_dimension(geography) returns decimal(38, 0)
function st_dimension(geometry) returns decimal(38, 0)

🔗 Official Documentation

st_disjoint

True if the two objects not intersect Supported Signatures

function st_disjoint(geography, geography) returns boolean
function st_disjoint(geometry, geometry) returns boolean

🔗 Official Documentation

st_distance

Distance between two geography objects in meters Supported Signatures

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

🔗 Official Documentation

st_dwithin

True if the minimum distance between two objects is smaller than or equal to the specified distance in meters Supported Signatures

function st_dwithin(geography, geography, double) returns boolean

🔗 Official Documentation

st_endpoint

The last point in the geography, only supports LineStrings Supported Signatures

function st_endpoint(geography) returns geography
function st_endpoint(geometry) returns geometry

🔗 Official Documentation

st_envelope

the double-precision (float8) minimum bounding box for the supplied geometry Supported Signatures

function st_envelope(geography) returns geography
function st_envelope(geometry) returns geometry

🔗 Official Documentation

st_geogfromgeohash

The geography represented by the geohash Supported Signatures

function st_geogfromgeohash(varchar, decimal(38, 0)) returns geography
function st_geogfromgeohash(varchar) returns geography

🔗 Official Documentation

st_geogpointfromgeohash

The point represented by the geohash Supported Signatures

function st_geogpointfromgeohash(varchar) returns geography

🔗 Official Documentation

st_geographyfromwkb

Parse WKB or EWKB Supported Signatures

function st_geographyfromwkb(varchar) returns geography
function st_geographyfromwkb(varchar, boolean) returns geography
function st_geographyfromwkb(binary) returns geography
function st_geographyfromwkb(binary, boolean) returns geography

🔗 Official Documentation

st_geographyfromwkt

Alias of ST_GEOGRAPHYFROMTEXT Supported Signatures

function st_geographyfromwkt(varchar) returns geography
function st_geographyfromwkt(varchar, boolean) returns geography

🔗 Official Documentation

st_geohash

The geohash of a geography Supported Signatures

function st_geohash(geography, decimal(38, 0)) returns varchar
function st_geohash(geography) returns varchar

🔗 Official Documentation

st_geometryfromwkb

Parse WKB or EWKB from binary Supported Signatures

function st_geometryfromwkb(binary, decimal(38, 0)) returns geometry
function st_geometryfromwkb(binary) returns geometry
function st_geometryfromwkb(varchar, decimal(38, 0)) returns geometry
function st_geometryfromwkb(varchar) returns geometry
function st_geometryfromwkb(binary, decimal(38, 0), boolean, boolean) returns geometry
function st_geometryfromwkb(binary, boolean, boolean) returns geometry
function st_geometryfromwkb(varchar, decimal(38, 0), boolean, boolean) returns geometry
function st_geometryfromwkb(varchar, boolean, boolean) returns geometry
function st_geometryfromwkb(varchar, decimal(38, 0), boolean) returns geometry
function st_geometryfromwkb(varchar, boolean) returns geometry
function st_geometryfromwkb(binary, decimal(38, 0), boolean) returns geometry
function st_geometryfromwkb(binary, boolean) returns geometry

🔗 Official Documentation

st_geometryfromwkt

Alias of ST_GEOMETRYFROMTEXT Supported Signatures

function st_geometryfromwkt(varchar) returns geometry
function st_geometryfromwkt(varchar, decimal(38, 0)) returns geometry
function st_geometryfromwkt(varchar, decimal(38, 0), boolean) returns geometry
function st_geometryfromwkt(varchar, boolean) returns geometry

🔗 Official Documentation

st_hausdorffdistance

the Hausdorff distance between two geometries Supported Signatures

function st_hausdorffdistance(geography, geography) returns double

🔗 Official Documentation

st_intersection

Geometry representing the intersection of a and b Supported Signatures

function st_intersection(geography, geography) returns geography

🔗 Official Documentation

st_intersects

True if the two objects intersect Supported Signatures

function st_intersects(geography, geography) returns boolean
function st_intersects(geometry, geometry) returns boolean

🔗 Official Documentation

st_isvalid

True if g has an internal representation Supported Signatures

function st_isvalid(geography) returns boolean
function st_isvalid(geometry) returns boolean

🔗 Official Documentation

st_length

Length or perimeter of the object in meters Supported Signatures

function st_length(geography) returns double
function st_length(geometry) returns double

🔗 Official Documentation

st_makegeompoint

Creates a point with the given x and y Supported Signatures

function st_makegeompoint(double, double) returns geometry

🔗 Official Documentation

st_makeline

Create a Line out of the points in the input geographies Supported Signatures

function st_makeline(geography, geography) returns geography
function st_makeline(geometry, geometry) returns geometry

🔗 Official Documentation

st_makepoint

Creates a point with the given longitude and latitude Supported Signatures

function st_makepoint(double, double) returns geography

🔗 Official Documentation

st_makepolygon

The Polygon consisting of the LineString as outer shell Supported Signatures

function st_makepolygon(geography) returns geography
function st_makepolygon(geometry) returns geometry

🔗 Official Documentation

st_makepolygonoriented

The Polygon consisting of the LineString as outer shell, with unmodified orientation Supported Signatures

function st_makepolygonoriented(geography) returns geography

🔗 Official Documentation

st_npoints

The number of points in the object’s definition Supported Signatures

function st_npoints(geography) returns decimal(38, 0)
function st_npoints(geometry) returns decimal(38, 0)

🔗 Official Documentation

st_numpoints

Alias for ST_NPOINTS Supported Signatures

function st_numpoints(geography) returns decimal(38, 0)
function st_numpoints(geometry) returns decimal(38, 0)

🔗 Official Documentation

st_perimeter

Perimeter of the object in meters Supported Signatures

function st_perimeter(geography) returns double
function st_perimeter(geometry) returns double

🔗 Official Documentation

st_point

Creates a point with the given longitude and latitude Supported Signatures

function st_point(double, double) returns geography

🔗 Official Documentation

st_pointn

The nth point in the geography, only supports LineStrings Supported Signatures

function st_pointn(geography, decimal(38, 0)) returns geography
function st_pointn(geometry, decimal(38, 0)) returns geometry

🔗 Official Documentation

st_polygon

Alias for ST_MAKEPOLYGON Supported Signatures

function st_polygon(geography) returns geography
function st_polygon(geometry) returns geometry

🔗 Official Documentation

st_setsrid

Returns a geometry same as input geometry but with SRID set to the given value Supported Signatures

function st_setsrid(geometry, decimal(38, 0)) returns geometry

🔗 Official Documentation

st_simplify

Simplified version of the given geometry Supported Signatures

function st_simplify(geography, double, boolean) returns geography
function st_simplify(geography, double) returns geography
function st_simplify(geometry, double) returns geometry

🔗 Official Documentation

st_srid

Returns the SRID of a geography if present. Otherwise 4326 Supported Signatures

function st_srid(geography) returns decimal(38, 0)
function st_srid(geometry) returns decimal(38, 0)

🔗 Official Documentation

st_startpoint

The first point in the geography, only supports LineStrings Supported Signatures

function st_startpoint(geography) returns geography
function st_startpoint(geometry) returns geometry

🔗 Official Documentation

st_symdifference

Geometry representing the set symmetric difference a minus b Supported Signatures

function st_symdifference(geography, geography) returns geography

🔗 Official Documentation

st_transform

Returns the geometry transformed from one SRID to another SRID. Supported Signatures

function st_transform(geometry, decimal(38, 0), decimal(38, 0)) returns geometry
function st_transform(geometry, decimal(38, 0)) returns geometry

🔗 Official Documentation

st_union

Geometry representing the union of a and b Supported Signatures

function st_union(geography, geography) returns geography

🔗 Official Documentation

st_within

True if the second object fully contains the first Supported Signatures

function st_within(geography, geography) returns boolean
function st_within(geometry, geometry) returns boolean

🔗 Official Documentation

st_x

The longitude of a point Supported Signatures

function st_x(geography) returns double
function st_x(geometry) returns double

🔗 Official Documentation

st_xmax

The maximum longitude Supported Signatures

function st_xmax(geography) returns double
function st_xmax(geometry) returns double

🔗 Official Documentation

st_xmin

The minimum longitude Supported Signatures

function st_xmin(geography) returns double
function st_xmin(geometry) returns double

🔗 Official Documentation

st_y

The latitude of a point Supported Signatures

function st_y(geography) returns double
function st_y(geometry) returns double

🔗 Official Documentation

st_ymax

The maximum latitude Supported Signatures

function st_ymax(geography) returns double
function st_ymax(geometry) returns double

🔗 Official Documentation

st_ymin

The minimum latitude Supported Signatures

function st_ymin(geography) returns double
function st_ymin(geometry) returns double

🔗 Official Documentation

to_geography

No-op; prevents us from re-packaging GEOGRAPHY during input Supported Signatures

function to_geography(geography) returns geography
function to_geography(geography, boolean) returns geography
function to_geography(variant) returns geography
function to_geography(variant, boolean) returns geography
function to_geography(varchar) returns geography
function to_geography(varchar, boolean) returns geography
function to_geography(binary) returns geography
function to_geography(binary, boolean) returns geography
function to_geography($1) returns geography

🔗 Official Documentation

to_geometry

No-op; prevents us from re-packaging GEOMETRY during input Supported Signatures

function to_geometry(geometry) returns geometry
function to_geometry(variant, decimal(38, 0)) returns geometry
function to_geometry(variant) returns geometry
function to_geometry(varchar, decimal(38, 0)) returns geometry
function to_geometry(varchar) returns geometry
function to_geometry(binary, decimal(38, 0)) returns geometry
function to_geometry(binary) returns geometry
function to_geometry(variant, decimal(38, 0), boolean, boolean) returns geometry
function to_geometry(variant, boolean, boolean) returns geometry
function to_geometry(variant, decimal(38, 0), boolean) returns geometry
function to_geometry(variant, boolean) returns geometry
function to_geometry(varchar, decimal(38, 0), boolean, boolean) returns geometry
function to_geometry(varchar, boolean, boolean) returns geometry
function to_geometry(varchar, decimal(38, 0), boolean) returns geometry
function to_geometry(varchar, boolean) returns geometry
function to_geometry(binary, decimal(38, 0), boolean, boolean) returns geometry
function to_geometry(binary, boolean, boolean) returns geometry
function to_geometry(binary, decimal(38, 0), boolean) returns geometry
function to_geometry(binary, boolean) returns geometry

🔗 Official Documentation

try_to_geography

No-op; prevents us from re-packaging GEOGRAPHY during input Supported Signatures

function try_to_geography(geography) returns geography
function try_to_geography(geography, boolean) returns geography
function try_to_geography(variant) returns geography
function try_to_geography(variant, boolean) returns geography
function try_to_geography(varchar) returns geography
function try_to_geography(varchar, boolean) returns geography
function try_to_geography(binary) returns geography
function try_to_geography(binary, boolean) returns geography

🔗 Official Documentation

try_to_geometry

No-op; prevents us from re-packaging GEOMETRY during input Supported Signatures

function try_to_geometry(geometry) returns geometry
function try_to_geometry(variant, decimal(38, 0)) returns geometry
function try_to_geometry(variant) returns geometry
function try_to_geometry(varchar, decimal(38, 0)) returns geometry
function try_to_geometry(varchar) returns geometry
function try_to_geometry(binary, decimal(38, 0)) returns geometry
function try_to_geometry(binary) returns geometry
function try_to_geometry(variant, decimal(38, 0), boolean, boolean) returns geometry
function try_to_geometry(variant, boolean, boolean) returns geometry
function try_to_geometry(variant, decimal(38, 0), boolean) returns geometry
function try_to_geometry(variant, boolean) returns geometry
function try_to_geometry(varchar, decimal(38, 0), boolean, boolean) returns geometry
function try_to_geometry(varchar, boolean, boolean) returns geometry
function try_to_geometry(varchar, decimal(38, 0), boolean) returns geometry
function try_to_geometry(varchar, boolean) returns geometry
function try_to_geometry(binary, decimal(38, 0), boolean, boolean) returns geometry
function try_to_geometry(binary, boolean, boolean) returns geometry
function try_to_geometry(binary, decimal(38, 0), boolean) returns geometry
function try_to_geometry(binary, boolean) returns geometry

🔗 Official Documentation