Release Notes

January 18th, 2024 (v1.3.0)

Module quadbin

New

• New QUADBIN_DISTANCE function that returns the distance (number of cells) between two quadbin cells.

Fix

• Improved precision when calculating cell indexes from latitudes close to the poles (±90º).

Module tiler

Fix

• Fixed a problem when parsing quotes inside the input query in CREATE_SIMPLE_TILESET and CREATE_POINT_AGGREGATION_TILESET procedures.

• Improved bounds calculation to get the exact value when using h3 cells in the CREATE_SPATIAL_INDEX_TILESET procedure. This applies when the Analytics Toolbox is installed with the h3 module (depends on having plv8 extenstion installed).

December 23, 2023 (v1.2.2)

Module tiler

Fix

• Fix recommended zoom in __clip_all_tiles internal function. This corrects some problems with tileset's creation.

September 8, 2023 (v1.2.1)

Module tiler

Fix

• Fixed wrong parameter formatting in CREATE_SPATIAL_INDEX_TILESET.

August 7, 2023 (v1.2.0)

Module h3

Improvement

• We have improved the performance of H3_POLYFILL.

New

• We have added to the function H3_POLYFILL different polyfill modes: center, intersects, contains.

Module quadbin

Improvement

• We have improved the performance of QUADBIN_POLYFILL.

New

• We have added to the function QUADBIN_POLYFILL different polyfill modes: center, intersects, contains.

July 14, 2023 (v1.1.2)

Module tiler

Fix

• We added some changes in order to support capitalized columns when using CREATE_SIMPLE_TILESET.

Module quadbin

Change

• We have updated the formula used in QUADBIN_FROMLONGLAT so it gets standardized. In addition a new implementation of QUADBIN_TOCHILDREN has been added in order to increase performance.

June 6, 2023 (v1.1.1)

Module tiler

Fix

• We added some missing metadata that was negatively affecting the usage of CREATE_SIMPLE_TILESET, CREATE_POINT_AGGREGATION_TILESET and CREATE_SPATIAL_INDEX_TILESET.

May 5, 2023 (v1.1.0)

Documentation

Improvement

We have improved the installation guide, allowing now to use a Python script as installer.

Module h3

New

We have released a new module in the Analytics Toolbox for PostgreSQL in order to provide native support for operating with the H3 spatial index.

This new module named “h3” includes the following functions: H3_BOUNDARY, H3_CENTER, H3_COMPACT, H3_DISTANCE, H3_FROMGEOGPOINT, H3_FROMLONGLAT, H3_HEXRING, H3_INT_TOSTRING, H3_ISPENTAGON, H3_ISVALID, H3_KRING, H3_KRING_DISTANCES, H3_POLYFILL, H3_RESOLUTION, H3_STRING_TOINT, H3_TOCHILDREN, H3_TOPARENT, H3_UNCOMPACT

March 7, 2023 (v1.0.1)

Module tiler

Fix

• We have added the creation of an index with the tile and the clustering of the tileset by that index in the CREATE_SPATIAL_INDEX_TILESET.

January 31, 2023 (v1.0.0)

Module tiler

Improvements

• Update default zoom values: geo, quadbin, h3 (12, 12, 6)

• Fix spatial index tiler with empty properties

December 22, 2022

Module quadbin

New

• Quadbin/quadkey conversion functions have been added to ease the conversion from quadbin to quadkey and from quadkey to quadbin indexes.

November 1, 2022

All modules

Fix

• Make cartofante the author and comitter of the release

Improvement

• Adapt to Semver

All modules

Feature

• Create release workflows

All modules

Feature

• Create release workflows

Improvement

• Adapt to Semver

September 19, 2022

Module tiler

Improvement

• Set version field in tilers metadata compliant with AT version.

August 11, 2022

Module tiler

Improvement

• Unify extra_metadata into metadata in tiler metadata.

July 20, 2022

Module tiler

Fix

• CREATE_SPATIAL_INDEX_TILESET Metadata center is now computed for PostgreSQL as for other providers

• Improved performance for quadbin tilesets in CREATE_SPATIAL_INDEX_TILESET.

July 15, 2022

Module tiler

Feature

• Add CREATE_SPATIAL_INDEX_TILESET option.

June 24, 2022

Module quadbin

Feature

• Add QUADBIN_BBOX function.

• Add QUADBIN_BOUNDARY function.

• Add QUADBIN_CENTER function.

• Add QUADBIN_FROMGEOGPOINT function.

• Add QUADBIN_FROMLONGLAT function.

• Add QUADBIN_FROMZXY function.

• Add QUADBIN_ISVALID function.

• Add QUADBIN_KRING function.

• Add QUADBIN_KRING_DISTANCES function.

• Add QUADBIN_POLYFILL function.

• Add QUADBIN_RESOLUTION function.

• Add QUADBIN_SIBLING function.

• Add QUADBIN_TOCHILDREN function.

• Add QUADBIN_TOPARENT function.

• Add QUADBIN_TOZXY function.

June 9, 2022

Module tiler

Fix

• Fix metadata tilestats to include only columns in properties

• Fix numeric metadata tilestats which were treated as categories

April 22, 2022

Module tiler

Feature

• Add max_tile_features option.

• Add output table existence early check.

• Add throw_error and return_null size strategy.

• Set tile_feature_order empty as default.

• Input query without parenthesis allowed.

• Use of MD5 hash for temporary tables naming.

April 7, 2022

Module tiler

Feature

• Add CREATE_POINT_AGGREGATION_TILESET procedure.

• Add CREATE_SIMPLE_TILESET procedure.