Source
EDITDISTANCE
Computes the Levenshtein distance between two input strings. It is the number of single - character insertions, deletions, or substitutions needed to convert one string to another. Note Unlike some other metrics (for example,…
ST_DISTANCE
Returns the minimum great circle distance between two GEOGRAPHY or the minimum Euclidean distance between two GEOMETRY objects.
VECTOR_L2_DISTANCE
The distance is calculated by taking the square root of the sum of the squared differences of vector elements. The distance can be a value of zero or higher. If the distance is zero, the vectors are identical. A larger distance indicates…
H3_TRY_GRID_DISTANCE
Returns an INTEGER value or NULL. If the function can perform a successful calculation, returns the INTEGER value that represents the distance in grid cells between the two H3 cells. If the grid distance cannot be calculated (for example,…
VECTOR_L1_DISTANCE
The distance is calculated by taking the sum of the absolute value of the differences of vector elements. The result is a value of zero or higher. If the distance is zero, the vectors are identical. The larger the distance, the farther…
H3_GRID_DISTANCE
Returns the INTEGER value that represents the distance in grid cells between the two H3 cells. Usage notes The two input cell IDs must use the same resolution. Examples The following example returns the distance (in terms of the number of…
VECTOR_COSINE_SIMILARITY
Cosine similarity is based on the angle between two vectors in a multi - dimensional space; the magnitude of the vectors is not considered. The cosine similarity value is the inner product of the vectors divided by the product of their…
ST_DWITHIN
Returns TRUE if the minimum great circle distance between two points (two GEOGRAPHY objects) is within the specified distance. Otherwise, returns FALSE.
H3_GRID_DISK
Returns an array of the IDs of the H3 cells that are within the k - distance from the specified cell. The IDs in the returned ARRAY are INTEGER values (if an INTEGER value was provided as the input ID) or VARCHAR values containing the…
ST_HAUSDORFFDISTANCE
Returns the discrete Hausdorff distance between two GEOGRAPHY objects. The Hausdorff distance indicates how similar the two objects are. Two objects are considered to be similar if each point in one object is close to a point in the other…