Recent Releases of h3-pg

h3-pg -

  • More upstream copy/paste in support of Debian package (see https://github.com/zachasme/h3-pg/issues/169, thanks @df7cb)

- PLpgSQL
Published by zachasme about 1 year ago

h3-pg -

  • Copy h3Index.h from upstream in support of Debian package (see #169, thanks @df7cb)

- PLpgSQL
Published by zachasme about 1 year ago

h3-pg -

  • Bump h3 to v4.2.0
  • Add h3_polygon_to_cells_experimental (see #159, thanks @jmealo)
  • Add experimental SP-GIST operator class (see #43, thanks @BielStela)
  • Fix for MacOS in nixpkgs / NixOS (see #141, thanks @wolfgangwalther)

- PLpgSQL
Published by zachasme about 1 year ago

h3-pg -

  • Fix library extension on macOS for PostgreSQL >= 16 (see #140, thanks @bayandin)
  • Add support for binary I/O (see #160, thanks @robertozimek)

- PLpgSQL
Published by zachasme over 1 year ago

h3-pg -

  • Add geometry @ int and geography @ int operators, as shortcuts for h3_lat_lng_to_cell.
  • Explain PostGIS SRID expectations (see #131 , thanks @rustprooflabs)

- PLpgSQL
Published by zachasme over 2 years ago

h3-pg - v4.1.2

  • Actually fix h3_postgis upgrade path (see #117, thanks @mngr777)

- PLpgSQL
Published by zachasme about 3 years ago

h3-pg - v4.1.1

  • Add postgis_raster integration (see #112, thanks @mngr777)
  • Fix h3_postgis upgrade path (see #117, thanks @mngr777)

- PLpgSQL
Published by zachasme about 3 years ago

h3-pg - v4.1.0

  • Bump h3 to v4.1.0
  • Add bindings for h3_cell_to_child_pos and h3_child_pos_to_cell.
  • Use CMake for entire build (see #70)
  • Add helper to fix pass-by-value migration (see #111)
  • Allow distance operator <-> to work for cells at different resolutions (using center child).

- PLpgSQL
Published by zachasme about 3 years ago

h3-pg -

  • Add BRIN operator class (see #97, thanks @mngr777)
  • Split PostGIS multipolygons by 180th meridian (see #90, thanks @mngr777)
  • Add aggregate functions for h3_postgis (see #91, thanks @mngr777)
  • Add recursive h3_grid_path_cells (see #93, thanks @mngr777)

- PLpgSQL
Published by zachasme over 3 years ago

h3-pg -

  • Fix broken function renames (see #87, thanks @Kompza, @mngr777)

- PLpgSQL
Published by zachasme over 3 years ago

h3-pg - v4.0.1

  • Bump h3 to v4.0.1 (was locked on rc5 for the previous release)
  • Add compile flag support check (see [#78], thanks [@mngr777])
  • Split polygons by 180th meridian (see [#76], thanks [@mngr777])

- PLpgSQL
Published by zachasme over 3 years ago

h3-pg -

First production release for H3 v4 :tada:. As noted below, most function names have changed, but the H3 indexes have not, so while using v4 will require code changes it should be 100% backwards compatible with existing data. See the 4x migration guide for more information.

[4.0.0] - 2022-08-24

  • ⚠️ Update h3 core library to v4.0.0. Almost all functions have been renamed to align with h3 core v4. Please take care when updating. You can see a list of changed function names in the core library documentation.
  • ⚠️ The PostGIS functions has been extracted into a separate extension h3_postgis. Install using CREATE EXTENSION h3_postgis;.
  • Enable link time optimization (see #75, thanks @mngr777)
  • Handle non-polygons for h3_polyfill (see #55, thanks @Lokks)
  • Take advantage of the new v4 error codes (fixes #71, thanks @kalenikaliaksandr)

- PLpgSQL
Published by zachasme over 3 years ago

h3-pg - v3.7.2

  • Allow NULL in holes array for h3_polyfill (see #64, thanks @mngr777)
  • Allow >1Gb memory allocations for h3_polyfill (see #65, thanks @mngr777)

- PLpgSQL
Published by zachasme almost 4 years ago

h3-pg -

  • Update h3 core library to v3.7.1

- PLpgSQL
Published by zachasme over 4 years ago

h3-pg -

  • ⚠️ Default unit for h3_hex_area and h3_edge_length changed to kilometers
  • Update h3 core library to v3.7.0
  • Add h3_point_dist and h3_exact_edge_length bindings
  • Add distance operator <->
  • Fix h3_to_geography and h3_to_geometry refering to removed functions if extension was upgraded from pre-1.0
  • Add optional input validation in geoToH3 (see #41, thanks @trylinka)
  • Support unit as string argument in h3_hex_area and h3_edge_length (and flag previous version for deprecation)

- PLpgSQL
Published by zachasme over 5 years ago

h3-pg -

  • Add support for partitioning by hash (see #37, thanks @abelvm)
  • Fix difference in function flags between fresh install and upgrades (see #38, thanks @abelvm)

- PLpgSQL
Published by zachasme over 5 years ago

h3-pg -

  • Update h3 core library to v3.6.4

- PLpgSQL
Published by zachasme over 5 years ago

h3-pg -

  • Build h3 core using release flag for 2x/3x performance (see #23, thanks @komzpa)

- PLpgSQL
Published by zachasme almost 6 years ago

h3-pg -

  • Add parallel safety flags to PostGIS functions (see #19, thanks @komzpa)
  • Add B-Tree sort support (see #24, thanks @komzpa)
  • ⚠️ Make type h3index pass-by-value on supported systems (see #22, #26, thanks @komzpa)
  • Update h3 core library to v3.6.3

- PLpgSQL
Published by zachasme almost 6 years ago

h3-pg -

  • Add &&, @> and <@ operators for overlaps, contains and contained by respectively
  • Fix PostgreSQL 12 build (see #18, thanks @Komzpa)
  • Update h3 core library to v3.6.1

- PLpgSQL
Published by zachasme about 6 years ago

h3-pg -

  • Add support for bigint cast (see #9, thanks @kmacdough)
  • Add h3_to_center_child binding
  • Add h3_get_pentagon_indexes binding
  • Update h3 core library to v3.6.0

- PLpgSQL
Published by zachasme over 6 years ago

h3-pg -

  • Add h3_get_faces binding
  • ⚠️ Replace h3_hex_area_m2 and h3_hex_area_km2 with h3_hex_area
  • ⚠️ Replace h3_edge_length_m and h3_edge_length_km with h3_edge_length
  • ⚠️ Remove hex_range, hex_ranges and hex_range_distances
  • Remove h3 core library version check, since we know which version we are linking
  • Fix PostgreSQL 12 build (see #4, thanks @Komzpa)
  • Update h3 core library to v3.5.0

- PLpgSQL
Published by zachasme over 6 years ago

h3-pg -

  • Fix abs warning

- PLpgSQL
Published by zachasme over 6 years ago

h3-pg -

  • ⚠️ Remove degree/radian conversion helpers (in favor of built-in RADIANS/DEGREES)

- PLpgSQL
Published by zachasme over 6 years ago

h3-pg - v1.0.6

  • Update h3 core library to v3.4.4

- PLpgSQL
Published by zachasme over 6 years ago

h3-pg -

  • Fix update path

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • Fix polyfill for polygon with multiple holes

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • Fix update path

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • Remove git tag check in distribute makefile target, since it causes error on pgxn install

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • Remove usage of FALSE instead of 0 in conditional in ASSERT macro

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • Add h3_get_extension_version()
  • Add hash operator class, now WHERE IN works
  • ⚠️ Replace h3_basecells with h3_get_res_0_indexes
  • ⚠️ Rename all functions with double h3_h3_ prefix to use single h3_ prefix
  • ⚠️ Remove h3_haversine_distance function
  • ⚠️ Change Makefile such that the h3 core library is cloned, built and statically linked
  • Test that upgrade path has same result as fresh install

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • Add h3_line binding
  • Fix h3_h3_to_children_slow

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • ⚠️ Fix btree operator class indexing

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg - v0.3.1

  • Add extend flag to h3_h3_to_geo_boundary such that polygons are not wrapped at antimeridian

- PLpgSQL
Published by zachasme about 7 years ago

h3-pg -

  • Initial public release

- PLpgSQL
Published by zachasme about 7 years ago