GEO_TO_H3
Learn how to use the GEO_TO_H3 utility function in PlaidCloud Lakehouse. Returns the H3 index of the hexagon cell where the given location resides.
Geography Functions
This section provides reference information for the geography functions in PlaidCloud Lakehouse. These functions are based on the very innovate H3 system developed by Uber to better calculate geographic relationships. The explanation of H3 can be found here.
Coordinate Conversion
Hexagon Properties
- H3_CELL_AREA_M2
- H3_CELL_AREA_RADS2
- H3_HEX_AREA_KM2
- H3_HEX_AREA_M2
- H3_GET_BASE_CELL
- H3_GET_FACES
- H3_GET_RESOLUTION
- H3_TO_CENTER_CHILD
- H3_TO_CHILDREN
- H3_TO_GEO_BOUNDARY
- H3_TO_PARENT
- H3_NUM_HEXAGONS
Hexagon Relationships
- H3_HEX_RING
- H3_K_RING
- H3_INDEXES_ARE_NEIGHBORS
- H3_IS_PENTAGON
- H3_IS_RES_CLASS_III
- H3_IS_VALID
- H3_GET_DESTINATION_INDEX_FROM_UNIDIRECTIONAL_EDGE
- H3_GET_INDEXES_FROM_UNIDIRECTIONAL_EDGE
- H3_GET_ORIGIN_INDEX_FROM_UNIDIRECTIONAL_EDGE
- H3_GET_UNIDIRECTIONAL_EDGE_BOUNDARY
- H3_GET_UNIDIRECTIONAL_EDGE
- H3_GET_UNIDIRECTIONAL_EDGES_FROM_HEXAGON
- H3_UNIDIRECTIONAL_EDGE_IS_VALID
Measurement
- H3_DISTANCE
- H3_EDGE_ANGLE
- H3_EDGE_LENGTH_KM
- H3_EDGE_LENGTH_M
- H3_EXACT_EDGE_LENGTH_KM
- H3_EXACT_EDGE_LENGTH_M
- H3_EXACT_EDGE_LENGTH_RADS
General Utility
GEOHASH_DECODE
Learn how to use the GEOHASH_DECODE utility function in PlaidCloud Lakehouse. Converts a Geohash-encoded string into latitude/longitude coordinates.
GEOHASH_ENCODE
Learn how to use the GEOHASH_ENCODE utility function in PlaidCloud Lakehouse. Converts a pair of latitude and longitude coordinates into a Geohash-encoded...
H3_CELL_AREA_M2
Learn how to use the H3_CELL_AREA_M2 utility function in PlaidCloud Lakehouse. Returns the exact area of specific cell in square meters. Includes syntax and...
H3_CELL_AREA_RADS2
Learn how to use the H3_CELL_AREA_RADS2 utility function in PlaidCloud Lakehouse. Returns the exact area of specific cell in square radians.
H3_DISTANCE
Learn how to use the H3_DISTANCE utility function in PlaidCloud Lakehouse. Returns the grid distance between the the given two H3 indexes. Includes syntax...
H3_EDGE_ANGLE
Learn how to use the H3_EDGE_ANGLE utility function in PlaidCloud Lakehouse. Returns the average length of the H3 hexagon edge in grades. Includes syntax...
H3_EDGE_LENGTH_KM
Learn how to use the H3_EDGE_LENGTH_KM utility function in PlaidCloud Lakehouse. Returns the average hexagon edge length in kilometers at the given resolution.
H3_EDGE_LENGTH_M
Learn how to use the H3_EDGE_LENGTH_M utility function in PlaidCloud Lakehouse. Returns the average hexagon edge length in meters at the given resolution.
H3_EXACT_EDGE_LENGTH_KM
Learn how to use the H3_EXACT_EDGE_LENGTH_KM utility function in PlaidCloud Lakehouse. Computes the length of this directed edge, in kilometers.
H3_EXACT_EDGE_LENGTH_M
Learn how to use the H3_EXACT_EDGE_LENGTH_M utility function in PlaidCloud Lakehouse. Computes the length of this directed edge, in meters. Includes syntax...
H3_EXACT_EDGE_LENGTH_RADS
Learn how to use the H3_EXACT_EDGE_LENGTH_RADS utility function in PlaidCloud Lakehouse. Computes the length of this directed edge, in radians.
H3_GET_BASE_CELL
Learn how to use the H3_GET_BASE_CELL utility function in PlaidCloud Lakehouse. Returns the base cell number of the given H3 index. With syntax and examples.
H3_GET_DESTINATION_INDEX_FROM_UNIDIRECTIONAL_EDGE
Learn how to use the H3_GET_DESTINATION_INDEX_FROM_UNIDIRECTIONAL_EDGE utility function in PlaidCloud Lakehouse. Returns the destination hexagon index from...
H3_GET_FACES
Learn how to use the H3_GET_FACES utility function in PlaidCloud Lakehouse. Finds all icosahedron faces intersected by the given H3 index. Includes syntax...
H3_GET_INDEXES_FROM_UNIDIRECTIONAL_EDGE
Learn how to use the H3_GET_INDEXES_FROM_UNIDIRECTIONAL_EDGE utility function in PlaidCloud Lakehouse. Returns the origin and destination hexagon indexes...
H3_GET_ORIGIN_INDEX_FROM_UNIDIRECTIONAL_EDGE
Learn how to use the H3_GET_ORIGIN_INDEX_FROM_UNIDIRECTIONAL_EDGE utility function in PlaidCloud Lakehouse. Returns the origin hexagon index from the...
H3_GET_RESOLUTION
Learn how to use the H3_GET_RESOLUTION utility function in PlaidCloud Lakehouse. Returns the resolution of the given H3 index. Includes syntax and examples.
H3_GET_UNIDIRECTIONAL_EDGE
Learn how to use the H3_GET_UNIDIRECTIONAL_EDGE utility function in PlaidCloud Lakehouse. Returns the edge between the given two H3 indexes.
H3_GET_UNIDIRECTIONAL_EDGE_BOUNDARY
Learn how to use the H3_GET_UNIDIRECTIONAL_EDGE_BOUNDARY utility function in PlaidCloud Lakehouse. Returns the coordinates defining the unidirectional edge.
H3_GET_UNIDIRECTIONAL_EDGES_FROM_HEXAGON
Learn how to use the H3_GET_UNIDIRECTIONAL_EDGES_FROM_HEXAGON utility function in PlaidCloud Lakehouse. Returns all of the unidirectional edges from the...
H3_HEX_AREA_KM2
Learn how to use the H3_HEX_AREA_KM2 utility function in PlaidCloud Lakehouse. Returns the average hexagon area in square kilometers at the given resolution.
H3_HEX_AREA_M2
Learn how to use the H3_HEX_AREA_M2 utility function in PlaidCloud Lakehouse. Returns the average hexagon area in square meters at the given resolution.
H3_HEX_RING
Learn how to use the H3_HEX_RING geo function in PlaidCloud Lakehouse. Returns the hollow ring of hexagons at grid distance k from a given origin index.
H3_INDEXES_ARE_NEIGHBORS
Learn how to use the H3_INDEXES_ARE_NEIGHBORS utility function in PlaidCloud Lakehouse. Returns whether or not the provided H3 indexes are neighbors.
H3_IS_PENTAGON
Learn how to use the H3_IS_PENTAGON utility function in PlaidCloud Lakehouse. Checks if the given H3 index represents a pentagonal cell. Includes syntax and...
H3_IS_RES_CLASS_III
Learn how to use the H3_IS_RES_CLASS_III utility function in PlaidCloud Lakehouse. Checks if the given H3 index has a resolution with Class III orientation.
H3_IS_VALID
Learn how to use the H3_IS_VALID utility function in PlaidCloud Lakehouse. Checks if the given H3 index is valid. Includes syntax and examples.
H3_K_RING
Learn how to use the H3_K_RING utility function in PlaidCloud Lakehouse. Returns an array containing the H3 indexes of the k-ring hexagons surrounding the...
H3_LINE
Learn how to use the H3_LINE utility function in PlaidCloud Lakehouse. Returns the line of indexes between the given two H3 indexes. With syntax and examples.
H3_NUM_HEXAGONS
Learn how to use the H3_NUM_HEXAGONS utility function in PlaidCloud Lakehouse. Returns the number of unique H3 indexes at the given resolution.
H3_TO_CENTER_CHILD
Learn how to use the H3_TO_CENTER_CHILD utility function in PlaidCloud Lakehouse. Returns the center child index at the specified resolution.
H3_TO_CHILDREN
Learn how to use the H3_TO_CHILDREN utility function in PlaidCloud Lakehouse. Returns the indexes contained by h3 at resolution child_res. Includes syntax...
H3_TO_GEO
Learn how to use the H3_TO_GEO utility function in PlaidCloud Lakehouse. Returns the longitude and latitude corresponding to the given H3 index.
H3_TO_GEO_BOUNDARY
Learn how to use the H3_TO_GEO_BOUNDARY utility function in PlaidCloud Lakehouse. Returns an array containing the longitude and latitude coordinates of the...
H3_TO_PARENT
Learn how to use the H3_TO_PARENT utility function in PlaidCloud Lakehouse. Returns the parent index containing the h3 at resolution parent_res.
H3_TO_STRING
Learn how to use the H3_TO_STRING utility function in PlaidCloud Lakehouse. Converts the representation of the given H3 index to the string representation.
H3_UNIDIRECTIONAL_EDGE_IS_VALID
Learn how to use the H3_UNIDIRECTIONAL_EDGE_IS_VALID utility function in PlaidCloud Lakehouse. Determines if the provided H3Index is a valid unidirectional...
POINT_IN_POLYGON
Learn how to use the POINT_IN_POLYGON utility function in PlaidCloud Lakehouse. Calculates whether a given point falls within the polygon formed by joining...
STRING_TO_H3
Learn how to use the STRING_TO_H3 utility function in PlaidCloud Lakehouse. Converts the string representation to H3 (uint64) representation.