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

Reference

SQL Functions

​h3_cell_to_boundary

​h3_cell_to_children

​h3_cell_to_children_string

​h3_cell_to_parent

​h3_cell_to_point

​h3_coverage

​h3_coverage_strings

​h3_get_resolution

​h3_grid_disk

​h3_grid_distance

​h3_grid_path

​h3_int_to_string

​h3_latlng_to_cell

​h3_latlng_to_cell_string

​h3_point_to_cell

​h3_point_to_cell_string

​h3_polygon_to_cells

​h3_polygon_to_cells_strings

​h3_string_to_int

​haversine

​st_area

​st_asbinary

​st_asewkb

​st_asewkt

​st_asgeojson

​st_astext

​st_aswkb

​st_aswkt

​st_azimuth

​st_buffer

​st_centroid

​st_collect

​st_contains

​st_coveredby

​st_covers

​st_difference

​st_dimension

​st_disjoint

​st_distance

​st_dwithin

​st_endpoint

​st_envelope

​st_geogfromgeohash

​st_geogpointfromgeohash

​st_geographyfromwkb

​st_geographyfromwkt

​st_geohash

​st_geometryfromwkb

​st_geometryfromwkt

​st_hausdorffdistance

​st_intersection

​st_intersects

​st_isvalid

​st_length

​st_makegeompoint

​st_makeline

​st_makepoint

​st_makepolygon

​st_makepolygonoriented

​st_npoints

​st_numpoints

​st_perimeter

​st_point

​st_pointn

​st_polygon

​st_setsrid

​st_simplify

​st_srid

​st_startpoint

​st_symdifference

​st_transform

​st_union

​st_within

​st_x

​st_xmax

​st_xmin

​st_y

​st_ymax

`h3_cell_to_boundary`

`h3_cell_to_children`

`h3_cell_to_children_string`

`h3_cell_to_parent`

`h3_cell_to_point`

`h3_coverage`

`h3_coverage_strings`

`h3_get_resolution`

`h3_grid_disk`

`h3_grid_distance`

`h3_grid_path`

`h3_int_to_string`

`h3_latlng_to_cell`

`h3_latlng_to_cell_string`

`h3_point_to_cell`

`h3_point_to_cell_string`

`h3_polygon_to_cells`

`h3_polygon_to_cells_strings`

`h3_string_to_int`

`haversine`

`st_area`

`st_asbinary`

`st_asewkb`

`st_asewkt`

`st_asgeojson`

`st_astext`

`st_aswkb`

`st_aswkt`

`st_azimuth`

`st_buffer`

`st_centroid`

`st_collect`

`st_contains`

`st_coveredby`

`st_covers`

`st_difference`

`st_dimension`

`st_disjoint`

`st_distance`

`st_dwithin`

`st_endpoint`

`st_envelope`

`st_geogfromgeohash`

`st_geogpointfromgeohash`

`st_geographyfromwkb`

`st_geographyfromwkt`

`st_geohash`

`st_geometryfromwkb`

`st_geometryfromwkt`

`st_hausdorffdistance`

`st_intersection`

`st_intersects`

`st_isvalid`

`st_length`

`st_makegeompoint`

`st_makeline`

`st_makepoint`

`st_makepolygon`

`st_makepolygonoriented`

`st_npoints`

`st_numpoints`

`st_perimeter`

`st_point`

`st_pointn`

`st_polygon`

`st_setsrid`

`st_simplify`

`st_srid`

`st_startpoint`

`st_symdifference`

`st_transform`

`st_union`

`st_within`

`st_x`

`st_xmax`

`st_xmin`

`st_y`

`st_ymax`

`st_ymin`

`to_geography`