Geospatial Functions

NQL includes Sedona-based geospatial functions for location data.

ST_SafePoint

Creates a point geometry from longitude and latitude.

SELECT ST_SafePoint(longitude, latitude) AS location
FROM company_data."123"

ST_Circle

Creates a circular geometry around a point.

SELECT ST_Circle(ST_SafePoint(longitude, latitude), radius_meters) AS area
FROM company_data."123"

ST_DistanceSphere

Calculates the distance between two points on a sphere (in meters).

SELECT ST_DistanceSphere(point1, point2) AS distance_meters
FROM company_data."123"

ST_GeoHash

Converts a point to a geohash string.

SELECT ST_GeoHash(ST_SafePoint(longitude, latitude), 6) AS geohash
FROM company_data."123"

ST_H3CellIDs

Returns H3 hexagon cell IDs covering a geometry.

SELECT ST_H3CellIDs(geometry, resolution) AS h3_cells
FROM company_data."123"

ST_H3KRing

Returns neighboring H3 cells within k rings.

SELECT ST_H3KRing(h3_cell, k) AS neighbors
FROM company_data."123"

Numeric Functions

Math and rounding

String Functions

Text manipulation

All Functions

Browse all function categories

Location Data

Working with geographic data

Window Functions Narrative Functions

⌘I

Overview

Data Types

SQL Commands

Operators

Functions

General Reference

Geospatial Functions

Geospatial functions

ST_SafePoint

ST_Circle

ST_DistanceSphere

ST_GeoHash

ST_H3CellIDs

ST_H3KRing

Numeric Functions

String Functions

All Functions

Location Data

​Geospatial functions

​ST_SafePoint

​ST_Circle

​ST_DistanceSphere

​ST_GeoHash

​ST_H3CellIDs

​ST_H3KRing

​Related content

Numeric Functions

String Functions

All Functions

Location Data

Geospatial functions

ST_SafePoint

ST_Circle

ST_DistanceSphere

ST_GeoHash

ST_H3CellIDs

ST_H3KRing

Related content