1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
\pset tuples_only on
\set hexagon '\'880326b885fffff\'::h3index'
\set neighbor '\'880326b887fffff\'::h3index'
\set pentagon '\'831c00fffffffff\'::h3index'
\set edge '\'1180326b885fffff\'::h3index'
--
-- TEST h3_are_neighbor_cells
--
SELECT h3_are_neighbor_cells(:hexagon, :neighbor);
SELECT NOT h3_are_neighbor_cells(:hexagon, :hexagon);
--
-- TEST h3_cells_to_directed_edge
--
SELECT h3_cells_to_directed_edge(:hexagon, :neighbor) = :edge;
--
-- TEST h3_is_valid_directed_edge
--
SELECT h3_is_valid_directed_edge(:edge);
SELECT NOT h3_is_valid_directed_edge(:hexagon);
--
-- TEST h3_get_directed_edge_origin and
-- h3_get_directed_edge_destination
--
SELECT h3_get_directed_edge_origin(:edge) = :hexagon
AND h3_get_directed_edge_destination(:edge) = :neighbor;
--
-- TEST h3_directed_edge_to_cells
--
SELECT h3_directed_edge_to_cells(:edge) = (:hexagon, :neighbor);
--
-- TEST h3_origin_to_directed_edges
--
SELECT array_length(array_agg(edge), 1) = 6 FROM (
SELECT h3_origin_to_directed_edges(:hexagon) edge
) q;
SELECT array_length(array_agg(edge), 1) = 5 expected FROM (
SELECT h3_origin_to_directed_edges(:pentagon) edge
) q;
--
-- TEST h3_directed_edge_to_boundary
--
SELECT h3_directed_edge_to_boundary(:edge)
~= polygon '((89.5830164946548,64.7146398954916),(89.5790678021742,64.2872231517217))'
|
