/* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION h3" to load this file. \quit -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --| # Base type -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -- declare shell type, allowing us to reference while defining functions -- before finally providing the full definition of the data type CREATE TYPE h3index; --@ internal CREATE OR REPLACE FUNCTION h3index_in(cstring) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OR REPLACE FUNCTION h3index_out(h3index) RETURNS cstring AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE h3index ( INPUT = h3index_in, OUTPUT = h3index_out, LIKE = int8 ); --@ internal CREATE OR REPLACE FUNCTION h3index_to_bigint(h3index) RETURNS bigint AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE CAST (h3index AS bigint) WITH FUNCTION h3index_to_bigint(h3index); COMMENT ON CAST (h3index AS bigint) IS 'Convert H3 index to bigint, which is useful when you need a decimal representation'; --@ internal CREATE OR REPLACE FUNCTION bigint_to_h3index(bigint) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE CAST (bigint AS h3index) WITH FUNCTION bigint_to_h3index(bigint); COMMENT ON CAST (h3index AS bigint) IS 'Convert bigint to H3 index'; /* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Indexing functions --| --| These function are used for finding the H3 index containing coordinates, --| and for finding the center and boundary of H3 indexes. --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_geo_to_h3(point, resolution integer) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_geo_to_h3(point, integer) IS 'Indexes the location at the specified resolution'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_geo(h3index) RETURNS point AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_to_geo(h3index) IS 'Finds the centroid of the index'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_geo_boundary(h3index, extend_at_meridian BOOLEAN DEFAULT FALSE) RETURNS polygon AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_to_geo_boundary(h3index, boolean) IS 'Finds the boundary of the index, second argument extends coordinates when crossing 180th meridian to help visualization';/* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Index inspection functions --| --| These functions provide metadata about an H3 index, such as its resolution --| or base cell, and provide utilities for converting into and out of the --| 64-bit representation of an H3 index. --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_get_resolution(h3index) RETURNS integer AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_resolution(h3index) IS 'Returns the resolution of the index'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_get_base_cell(h3index) RETURNS integer AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_base_cell(h3index) IS 'Returns the base cell number of the index'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_is_valid(h3index) RETURNS bool AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_is_valid(h3index) IS 'Returns true if the given H3Index is valid'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_is_res_class_iii(h3index) RETURNS bool AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_is_res_class_iii(h3index) IS 'Returns true if this index has a resolution with Class III orientation'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_is_pentagon(h3index) RETURNS bool AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_is_pentagon(h3index) IS 'Returns true if this index represents a pentagonal cell'; --@ availability: 3.5.0 CREATE OR REPLACE FUNCTION h3_get_faces(h3index) RETURNS integer[] AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_faces(h3index) IS 'Find all icosahedron faces intersected by a given H3 index'; /* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Grid traversal functions --| --| Grid traversal allows finding cells in the vicinity of an origin cell, and --| determining how to traverse the grid from one cell to another. --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_k_ring(h3index, k integer DEFAULT 1) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_k_ring(h3index, k integer) IS 'Produces indices within "k" distance of the origin index'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_k_ring_distances(h3index, k integer DEFAULT 1, OUT index h3index, OUT distance int) RETURNS SETOF record AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_k_ring_distances(h3index, k integer) IS 'Produces indices within "k" distance of the origin index paired with their distance to the origin'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_hex_ring(h3index, k integer DEFAULT 1) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_hex_ring(h3index, k integer) IS 'Returns the hollow hexagonal ring centered at origin with distance "k"'; --@ availability: 0.4.0 CREATE OR REPLACE FUNCTION h3_line(h3index, h3index) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_line(h3index, h3index) IS 'Given two H3 indexes, return the line of indexes between them (inclusive). This function may fail to find the line between two indexes, for example if they are very far apart. It may also fail when finding distances for indexes on opposite sides of a pentagon.'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_distance(h3index, h3index) RETURNS integer AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_distance(h3index, h3index) IS 'Returns the distance in grid cells between the two indices'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_experimental_h3_to_local_ij(origin h3index, index h3index) RETURNS POINT AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_experimental_h3_to_local_ij(origin h3index, index h3index) IS 'Produces local IJ coordinates for an H3 index anchored by an origin. This function is experimental, and its output is not guaranteed to be compatible across different versions of H3.'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_experimental_local_ij_to_h3(origin h3index, coord POINT) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_experimental_local_ij_to_h3(origin h3index, coord POINT) IS 'Produces an H3 index from local IJ coordinates anchored by an origin. This function is experimental, and its output is not guaranteed to be compatible across different versions of H3.'; /* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Hierarchical grid functions --| --| These functions permit moving between resolutions in the H3 grid system. --| The functions produce parent (coarser) or children (finer) cells. --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_parent(h3index, resolution integer DEFAULT -1) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_to_parent(h3index, resolution integer) IS 'Returns the parent of the given index'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_children(h3index, resolution integer DEFAULT -1) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_to_children(index h3index, resolution integer) IS 'Returns the set of children of the given index'; --@ availability: 3.6.0 CREATE OR REPLACE FUNCTION h3_to_center_child(h3index, resolution integer DEFAULT -1) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_to_parent(h3index, resolution integer) IS 'Returns the center child (finer) index contained by input index at given resolution'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_compact(h3index[]) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_compact(h3index[]) IS 'Compacts the given array as best as possible'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_uncompact(h3index[], resolution integer DEFAULT -1) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_uncompact(h3index[], resolution integer) IS 'Uncompacts the given array at the given resolution. If no resolution is given, then it is chosen as one higher than the highest resolution in the set'; -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -- Custom Funtions --@ internal CREATE OR REPLACE FUNCTION __h3_to_children_aux(index h3index, resolution integer, current INTEGER) RETURNS SETOF h3index AS $$ DECLARE retSet h3index[]; r h3index; BEGIN IF current = -1 THEN SELECT h3_get_resolution(index) into current; END IF; IF resolution = -1 THEN SELECT h3_get_resolution(index)+1 into resolution; END IF; IF current < resolution THEN SELECT ARRAY(SELECT h3_to_children(index)) into retSet; FOREACH r in ARRAY retSet LOOP RETURN QUERY SELECT __h3_to_children_aux(r, resolution, current + 1); END LOOP; ELSE RETURN NEXT index; END IF; END;$$ LANGUAGE plpgsql; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_children_slow(index h3index, resolution integer DEFAULT -1) RETURNS SETOF h3index AS $$ SELECT __h3_to_children_aux($1, $2, -1) $$ LANGUAGE SQL; COMMENT ON FUNCTION h3_to_children_slow(index h3index, resolution integer) IS 'Slower version of H3ToChildren but allocates less memory'; /* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Region functions --| --| These functions convert H3 indexes to and from polygonal areas. --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_polyfill(exterior polygon, holes polygon[], resolution integer DEFAULT 1) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE CALLED ON NULL INPUT PARALLEL SAFE; -- NOT STRICT COMMENT ON FUNCTION h3_polyfill(exterior polygon, holes polygon[], resolution integer) IS 'Takes an exterior polygon [and a set of hole polygon] and returns the set of hexagons that best fit the structure'; --@ availability: 3.5.0 CREATE OR REPLACE FUNCTION h3_set_to_multi_polygon(h3index[], OUT exterior polygon, OUT holes polygon[]) RETURNS SETOF record AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_set_to_multi_polygon(h3index[]) IS 'Create a LinkedGeoPolygon describing the outline(s) of a set of hexagons. Polygon outlines will follow GeoJSON MultiPolygon order: Each polygon will have one outer loop, which is first in the list, followed by any holes'; /* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Unidirectional edge functions --| --| Unidirectional edges allow encoding the directed edge from one cell to a --| neighboring cell. --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_indexes_are_neighbors(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_indexes_are_neighbors(h3index, h3index) IS 'Returns true if the given indices are neighbors'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_get_h3_unidirectional_edge(origin h3index, destination h3index) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_h3_unidirectional_edge(origin h3index, destination h3index) IS 'Returns a unidirectional edge H3 index based on the provided origin and destination.'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_unidirectional_edge_is_valid(edge h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_unidirectional_edge_is_valid(edge h3index) IS 'Returns true if the given edge is valid.'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_get_origin_h3_index_from_unidirectional_edge(edge h3index) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_origin_h3_index_from_unidirectional_edge(edge h3index) IS 'Returns the origin index from the given edge.'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_get_destination_h3_index_from_unidirectional_edge(edge h3index) RETURNS h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_destination_h3_index_from_unidirectional_edge(edge h3index) IS 'Returns the destination index from the given edge.'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_get_h3_indexes_from_unidirectional_edge(edge h3index, OUT origin h3index, OUT destination h3index) RETURNS record AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_h3_indexes_from_unidirectional_edge(edge h3index) IS 'Returns the pair of indices from the given edge.'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_get_h3_unidirectional_edges_from_hexagon(h3index) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_h3_unidirectional_edges_from_hexagon(h3index) IS 'Returns all unidirectional edges with the given index as origin'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_get_h3_unidirectional_edge_boundary(edge h3index) RETURNS polygon AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_h3_unidirectional_edge_boundary(edge h3index) IS 'Provides the coordinates defining the unidirectional edge.'; /* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Miscellaneous H3 functions --| --| These functions include descriptions of the H3 grid system. --@ availability: 3.7.0 CREATE OR REPLACE FUNCTION h3_point_dist(a point, b point, unit text DEFAULT 'km') RETURNS float AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_point_dist(point, point, text) IS 'The great circle distance in radians between two spherical coordinates.'; --@ availability: 3.5.0 CREATE OR REPLACE FUNCTION h3_hex_area(resolution integer, unit text DEFAULT 'km') RETURNS float AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_hex_area(integer, text) IS 'Average hexagon area in square (kilo)meters at the given resolution.'; --@ availability: 3.7.0 CREATE OR REPLACE FUNCTION h3_cell_area(cell h3index, unit text DEFAULT 'km^2') RETURNS float AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_cell_area(h3index, text) IS 'Exact area for a specific cell (hexagon or pentagon).'; --@ availability: 3.5.0 CREATE OR REPLACE FUNCTION h3_edge_length(resolution integer, unit text DEFAULT 'km') RETURNS float AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_edge_length(integer, text) IS 'Average hexagon edge length in (kilo)meters at the given resolution.'; --@ availability: 3.7.0 CREATE OR REPLACE FUNCTION h3_exact_edge_length(edge h3index, unit text DEFAULT 'km') RETURNS float AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_exact_edge_length(h3index, text) IS 'Exact length for a specific unidirectional edge.'; --@ availability: 0.2.0 CREATE OR REPLACE FUNCTION h3_num_hexagons(resolution integer) RETURNS bigint AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_num_hexagons(integer) IS 'Number of unique H3 indexes at the given resolution.'; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_get_res_0_indexes() RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_res_0_indexes() IS 'Returns all 122 resolution 0 indexes.'; --@ availability: 3.6.0 CREATE OR REPLACE FUNCTION h3_get_pentagon_indexes(resolution integer) RETURNS SETOF h3index AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_res_0_indexes() IS 'All the pentagon H3 indexes at the specified resolution.';/* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Operators -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --| ## B-tree operators --@ internal CREATE OR REPLACE FUNCTION h3index_eq(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ availability: 0.1.0 CREATE OPERATOR = ( LEFTARG = h3index, RIGHTARG = h3index, PROCEDURE = h3index_eq, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, HASHES, MERGES ); COMMENT ON OPERATOR = (h3index, h3index) IS 'Returns true if two indexes are the same'; --@ internal CREATE OR REPLACE FUNCTION h3index_ne(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ availability: 0.1.0 CREATE OPERATOR <> ( LEFTARG = h3index, RIGHTARG = h3index, PROCEDURE = h3index_ne, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel ); --@ internal CREATE OR REPLACE FUNCTION h3index_lt(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OPERATOR < ( LEFTARG = h3index, RIGHTARG = h3index, PROCEDURE = h3index_lt, COMMUTATOR = > , NEGATOR = >= , RESTRICT = scalarltsel, JOIN = scalarltjoinsel ); --@ internal CREATE OR REPLACE FUNCTION h3index_le(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OPERATOR <= ( LEFTARG = h3index, RIGHTARG = h3index, PROCEDURE = h3index_le, COMMUTATOR = >= , NEGATOR = > , RESTRICT = scalarltsel, JOIN = scalarltjoinsel ); --@ internal CREATE OR REPLACE FUNCTION h3index_gt(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OPERATOR > ( LEFTARG = h3index, RIGHTARG = h3index, PROCEDURE = h3index_gt, COMMUTATOR = < , NEGATOR = <= , RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); --@ internal CREATE OR REPLACE FUNCTION h3index_ge(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OPERATOR >= ( LEFTARG = h3index, RIGHTARG = h3index, PROCEDURE = h3index_ge, COMMUTATOR = <= , NEGATOR = < , RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --| ## R-tree Operators --@ internal CREATE OR REPLACE FUNCTION h3index_overlaps(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ availability: 3.6.1 CREATE OPERATOR && ( PROCEDURE = h3index_overlaps, LEFTARG = h3index, RIGHTARG = h3index, COMMUTATOR = &&, RESTRICT = contsel, JOIN = contjoinsel ); COMMENT ON OPERATOR && (h3index, h3index) IS 'Returns true if the two H3 indexes intersect'; --@ internal CREATE OR REPLACE FUNCTION h3index_contains(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ availability: 3.6.1 CREATE OPERATOR @> ( PROCEDURE = h3index_contains, LEFTARG = h3index, RIGHTARG = h3index, COMMUTATOR = <@, RESTRICT = contsel, JOIN = contjoinsel ); COMMENT ON OPERATOR @> (h3index, h3index) IS 'Returns true if A containts B'; --@ internal CREATE OR REPLACE FUNCTION h3index_contained_by(h3index, h3index) RETURNS boolean AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ availability: 3.6.1 CREATE OPERATOR <@ ( PROCEDURE = h3index_contained_by, LEFTARG = h3index, RIGHTARG = h3index, COMMUTATOR = @>, RESTRICT = contsel, JOIN = contjoinsel ); COMMENT ON OPERATOR <@ (h3index, h3index) IS 'Returns true if A is contained by B'; --@ availability: 3.7.0 CREATE OPERATOR <-> ( LEFTARG = h3index, RIGHTARG = h3index, PROCEDURE = h3_distance, COMMUTATOR = <-> ); COMMENT ON OPERATOR <-> (h3index, h3index) IS 'Returns the distance in grid cells between the two indices'; /* * Copyright 2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ -- B-tree operator class --@ internal CREATE OR REPLACE FUNCTION h3index_cmp(h3index, h3index) RETURNS integer AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OR REPLACE FUNCTION h3index_sortsupport(internal) RETURNS void AS 'h3', 'h3index_sortsupport' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OPERATOR CLASS btree_h3index_ops DEFAULT FOR TYPE h3index USING btree AS OPERATOR 1 < , OPERATOR 2 <= , OPERATOR 3 = , OPERATOR 4 >= , OPERATOR 5 > , FUNCTION 1 h3index_cmp(h3index, h3index), FUNCTION 2 h3index_sortsupport(internal); /* * Copyright 2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ -- Hash operator class --@ internal CREATE OR REPLACE FUNCTION h3index_hash(h3index) RETURNS integer AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OR REPLACE FUNCTION h3index_hash_extended(h3index, int8) RETURNS int8 AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; --@ internal CREATE OPERATOR CLASS hash_h3index_ops DEFAULT FOR TYPE h3index USING hash AS OPERATOR 1 = , FUNCTION 1 h3index_hash(h3index), FUNCTION 2 h3index_hash_extended(h3index, int8); /* * Copyright 2018-2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # Extension specific functions --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_get_extension_version() RETURNS text AS 'h3' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; COMMENT ON FUNCTION h3_get_extension_version() IS 'Get the currently installed version of the extension.'; /* * Copyright 2020 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --@ deprecated: 3.7.0 CREATE OR REPLACE FUNCTION h3_hex_area(resolution integer, km boolean) RETURNS float AS $$ SELECT h3_hex_area($1, CASE WHEN $2 THEN 'km' ELSE 'm' END) $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; --@ deprecated: 3.7.0 CREATE OR REPLACE FUNCTION h3_edge_length(resolution integer, km boolean) RETURNS float AS $$ SELECT h3_edge_length($1, CASE WHEN $2 THEN 'km' ELSE 'm' END) $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; /* * Copyright 2019 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ --| # PostGIS Functions --@ availability: 0.3.0 CREATE OR REPLACE FUNCTION h3_geo_to_h3(geometry, resolution integer) RETURNS h3index AS $$ SELECT h3_geo_to_h3($1::point, $2); $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; --@ availability: 0.3.0 CREATE OR REPLACE FUNCTION h3_geo_to_h3(geography, resolution integer) RETURNS h3index AS $$ SELECT h3_geo_to_h3($1::geometry, $2); $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_geometry(h3index) RETURNS geometry AS $$ SELECT ST_SetSRID(h3_to_geo($1)::geometry, 4326) $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_geography(h3index) RETURNS geography AS $$ SELECT h3_to_geometry($1)::geography $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_geo_boundary_geometry(h3index, extend BOOLEAN DEFAULT FALSE) RETURNS geometry AS $$ SELECT ST_SetSRID(h3_to_geo_boundary($1, $2)::geometry, 4326) $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; --@ availability: 1.0.0 CREATE OR REPLACE FUNCTION h3_to_geo_boundary_geography(h3index, extend BOOLEAN DEFAULT FALSE) RETURNS geography AS $$ SELECT h3_to_geo_boundary_geometry($1, $2)::geography $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; --@ availability: 0.3.0 CREATE OR REPLACE FUNCTION h3_polyfill(multi geometry, resolution integer) RETURNS SETOF h3index AS $$ SELECT h3_polyfill(exterior, holes, resolution) FROM ( SELECT -- extract exterior ring of each polygon ST_MakePolygon(ST_ExteriorRing(poly))::polygon exterior, -- extract holes of each polygon (SELECT array_agg(hole) FROM ( SELECT ST_MakePolygon(ST_InteriorRingN( poly, generate_series(1, ST_NumInteriorRings(poly)) ))::polygon AS hole ) q_hole ) holes -- extract single polygons from multipolygon FROM ( select (st_dump(multi)).geom as poly ) q_poly GROUP BY poly ) h3_polyfill; $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE CALLED ON NULL INPUT; -- NOT STRICT --@ availability: 0.3.0 CREATE OR REPLACE FUNCTION h3_polyfill(multi geography, resolution integer) RETURNS SETOF h3index AS $$ SELECT h3_polyfill($1::geometry, $2) $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE CALLED ON NULL INPUT; -- NOT STRICT -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --| ## PostGIS casts --@ availability: 0.3.0 CREATE CAST (h3index AS point) WITH FUNCTION h3_to_geo(h3index); --@ availability: 0.3.0 CREATE CAST (h3index AS geometry) WITH FUNCTION h3_to_geometry(h3index); --@ availability: 0.3.0 CREATE CAST (h3index AS geography) WITH FUNCTION h3_to_geography(h3index);