SELECT h3_latlng_to_cell(37.76938, -122.3889, 0), h3_latlng_to_cell_string(37.76938, -122.3889, 0);; SELECT h3_latlng_to_cell(37.76938, -122.3889, 1), h3_latlng_to_cell_string(37.76938, -122.3889, 1); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8), h3_latlng_to_cell_string(37.76938, -122.3889, 8); SELECT h3_latlng_to_cell(37.76938, -122.3889, 100), h3_latlng_to_cell_string(37.76938, -122.3889, 100); SELECT h3_latlng_to_cell(37.76938, -122.3889, -1), h3_latlng_to_cell_string(37.76938, -122.3889, -1); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::Int8), h3_latlng_to_cell_string(37.76938, -122.3889, 8::Int8); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::Int16), h3_latlng_to_cell_string(37.76938, -122.3889, 8::Int16); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::Int32), h3_latlng_to_cell_string(37.76938, -122.3889, 8::Int32); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::Int64), h3_latlng_to_cell_string(37.76938, -122.3889, 8::Int64); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::UInt8), h3_latlng_to_cell_string(37.76938, -122.3889, 8::UInt8); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::UInt16), h3_latlng_to_cell_string(37.76938, -122.3889, 8::UInt8); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::UInt32), h3_latlng_to_cell_string(37.76938, -122.3889, 8::UInt32); SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::UInt64), h3_latlng_to_cell_string(37.76938, -122.3889, 8::UInt64); SELECT h3_cell_to_string(h3_latlng_to_cell(37.76938, -122.3889, 8::UInt64)) AS cell_str, h3_string_to_cell(h3_latlng_to_cell_string(37.76938, -122.3889, 8::UInt64)) AS cell_index; SELECT h3_cell_center_latlng(h3_latlng_to_cell(37.76938, -122.3889, 8::UInt64)) AS cell_center; SELECT h3_cell_resolution(cell) AS resolution, h3_cell_base(cell) AS base, h3_cell_is_pentagon(cell) AS pentagon, h3_cell_parent(cell, 6::UInt64) AS parent, h3_cell_to_children(cell, 10::UInt64) AS children, h3_cell_to_children_size(cell, 10) AS children_count, h3_cell_to_child_pos(cell, 6) AS child_pos, h3_child_pos_to_cell(25, cell, 11) AS child FROM (SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::UInt64) AS cell); SELECT h3_grid_disk(cell, 0) AS current_cell, h3_grid_disk(cell, 3) AS grids, h3_grid_disk_distances(cell, 3) AS all_grids, FROM (SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::UInt64) AS cell); SELECT h3_grid_distance(cell1, cell2) AS distance, h3_grid_path_cells(cell1, cell2) AS path_cells, FROM ( SELECT h3_latlng_to_cell(37.76938, -122.3889, 8::UInt64) AS cell1, h3_latlng_to_cell(39.634, -104.999, 8::UInt64) AS cell2 ); SELECT geohash(37.76938, -122.3889, 9); SELECT geohash(37.76938, -122.3889, 10); SELECT geohash(37.76938, -122.3889, 11); SELECT geohash(37.76938, -122.3889, 100); SELECT geohash(37.76938, -122.3889, -1); SELECT geohash(37.76938, -122.3889, 11::Int8); SELECT geohash(37.76938, -122.3889, 11::Int16); SELECT geohash(37.76938, -122.3889, 11::Int32); SELECT geohash(37.76938, -122.3889, 11::Int64); SELECT geohash(37.76938, -122.3889, 11::UInt8); SELECT geohash(37.76938, -122.3889, 11::UInt16); SELECT geohash(37.76938, -122.3889, 11::UInt32); SELECT geohash(37.76938, -122.3889, 11::UInt64); SELECT geohash_neighbours(37.76938, -122.3889, 11); SELECT json_encode_path(37.76938, -122.3889, 1728083375::TimestampSecond); SELECT json_encode_path(lat, lon, ts) FROM( SELECT 37.76938 AS lat, -122.3889 AS lon, 1728083375::TimestampSecond AS ts UNION ALL SELECT 37.76928 AS lat, -122.3839 AS lon, 1728083373::TimestampSecond AS ts UNION ALL SELECT 37.76930 AS lat, -122.3820 AS lon, 1728083379::TimestampSecond AS ts UNION ALL SELECT 37.77001 AS lat, -122.3888 AS lon, 1728083372::TimestampSecond AS ts );