Geospatial Functions

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

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

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

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

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

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