Release Notes
March 21st, 2024 (v1.6.0)
Module lds
New
All external functions (including those used by the procedures in the lds module) now use a single, unified endpoint. This also simplifies the manual installation of the Analytics Toolbox.
GEOCODE_TABLE now uses async batch geocoding with TomTom, boosting the geocoding speed considerably. Also matching by rows is applied ensuring that the address that reaches the TomTom endpoints is as similar as possible as the table value.
February 16th, 2024 (v1.5.1)
Module lds
Fix
CREATE_ISOLINES fixed a problem with using input credentials for all requests.
Fixed support for waypoints in CREATE_ROUTES.
January 18th, 2024 (v1.5.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 constructors
Fix
Fixed a problem with the output of ST_BEZIERSPLINE and ST_MAKEELLIPSE functions, they now return a GEOMETRY type column instead of a VARCHAR.
Fixed a problem with the output of ST_MAKEENVELOPE function, it now returns a GEOMETRY with SRID 4326.
Module transformations
Fix
Fixed a problem with the output of ST_CENTERMEAN, ST_CENTERMEDIAN, ST_CENTROID, ST_DESTINATION and ST_GREATCIRCLE functions, they now return a GEOMETRY with SRID 4326.
Module tiler
Fix
Fixed a problem with CREATE_SIMPLE_TILESET procedure, that was crashing when the value for the “max_tile_size_strategy” property was "drop_fraction_as_needed" in points tables.
Improved tile precision when creating tilesets from geometries containing points with latitudes close to the poles (±90º) using CREATE_SIMPLE_TILESET or CREATE_POINT_AGGREGATION_TILESET.
Improved bounds calculation to get an approximate value when using h3 cells in the CREATE_SPATIAL_INDEX_TILESET procedure.
Module data
Fix
Fixed an issue when using AVG aggregation, that was not correctly computed when “data_query” contained NULL values.
Module lds
Fix
GEOCODE_TABLE malfunctioning for multi-line addresses with multiple rows with scape line and indentations.
December 23, 2023 (v1.4.1)
Module lds
Fix
Accept one or more AWS roles for the SETUP function
Module tiler
Fix
Tiler support for non-integer numeric properties. We have corrected a problem that was causing problems when using numeric properties with decimal values.
November 13, 2023 (v1.4.0)
Module lds
New
Add SETUP procedure. This procedure allows configuring credentials and endpoints of an Analytics Toolbox installation. Find more information about this topic in this documentation.
Replace LDS_QUOTA_INFO by GET_LDS_QUOTA_INFO function. This new function allows checking your currently consumed quota with a single query, without the need to store the result as a table.
October 13, 2023 (v1.3.1)
Module tiler
Improvement
Performance optimizations for the produres that generate tilesets:
Module lds
Improvement
New batch service for CREATE_ISOLINES. Used automatically by the procedure. No changes required.
September 8, 2023 (v1.3.0)
Module lds
New
Add optional parameters:
api_base_url,lds_tokento every function/procedure.
August 7, 2023 (v1.2.1)
Module lds
Fix
We have made the GEOCODE_TABLE procedure more robust for special characters contained in the address data.
July 14, 2023 (v1.2.0)
Module lds
New
We are now allowing users to send any of the parameter options supported by the isolines service provider in CREATE_ISOLINES.
We have improved our logging of results in GEOCODE_TABLE so more information about processed and geocoded rows is provided to the user. Also the new option “carto_force_geocode” allows the re-geocoding of already geocoded rows.
Fix
We have applied some fixes to the CREATE_ROUTES function so the metadata column can be successfully created and informed.
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.0)
Module lds
New
We have created a new procedure named CREATE_ROUTES, which calculates the routes (returned as linestrings) between a set of given origins and destinations (points) in a query. It supports different transport modes and advanced options as the other functions of the lds module.
April 4, 2023 (v1.0.2)
Module lds
Change
We have updated the LDS module to be aligned with the new usage quota model, working as an annual budget and combining consumption across all supported LDS services.
March 7, 2023 (v1.0.1)
Module lds
Fix
Returning geometries with proper srid (4326) in GEOCODE_TABLE, CREATE_ISOLINES, GEOCODE and ISOLINE.
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 lds
Improvement
We have added the possibility to configure more options as parameters when executing the functions to CREATE_ISOLINES. These new options, which depend on the LDS service provider, allow the user to configure more transportation modes such as truck or bike, the possibility of specifying departure or arrival times allowing the creation of reverse isolines, and other options like different routing modes.
Added new confidence/relevance metadata to the results of the geocoding function GEOCODE_TABLE.
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
Feature
Create release workflows
Improvement
Adapt to Semver
October 25, 2022
Module data
Fix
Fix enrichment procedures not working with VARCHAR variables for aggregation types
MIN,MAXandCOUNT.
October 18, 2022
Module data
Fix
Fix enrichment procedures returning inconsistent results for input queries containing
LIMIT.Fix ST_AREA returning NULL by using ST_SIMPLIFY.
Fix inconsistent values resturned because of ST_ENVELOPE.
October 10, 2022
Module data
Feature
Add DATAOBS_ENRICH_POINTS procedure.
Add DATAOBS_ENRICH_POLYGONS procedure.
Add DATAOBS_ENRICH_GRID procedure.
Add ENRICH_GRID procedure.
October 7, 2022
Module clustering
Feature
Move ST_CLUSTERKMEANS function to core.
Move CREATE_CLUSTERKMEANS procedure to core.
Module random
Feature
Move ST_GENERATEPOINTS function to core.
October 1, 2022
Module lds
Improvement
Module lds
Improvement
Rename
LDS_API_URLtoAPI_BASE_URL.
September 21, 2022
Module tiler
Fix
Fix CREATE_SPATIAL_INDEX_TILESET returning nested UDFs error when detecting the index type.
September 19, 2022
Module statistics
Improvement
Add p-values in the output of GETIS_ORD_QUADBIN function.
Module tiler
Improvement
Set
versionfield in tilers metadata compliant with AT version.
September 7, 2022
Module data
Feature
Add ENRICH_POLYGONS procedure.
September 2, 2022
Module data
Feature
Add ENRICH_POINTS procedure.
August 26, 2022
Module statistics
Feature
Add GETIS_ORD_QUADBIN function.
August 19, 2022
Module s2
Fix
Fix S2_BOUNDARY inverted coordinates.
August 11, 2022
Module tiler
Improvement
Unify
extra_metadataintometadatain tiler metadata.
August 9, 2022
Module statistics
Feature
Add P_VALUE function.
July 22, 2022
Module lds
Feature
Add GEOCODE_REVERSE_TABLE procedure.
Module statistics
Feature
Create statistics module.
Add MORANS_I_QUADBIN function.
July 20, 2022
Module clustering
Feature
Add CREATE_CLUSTERKMEANS procedure.
July 14, 2022
Module quadbin
Improvement
Update functions volatility.
QUADBIN_FROMZXY accepting BIGINTs as params instead of INTs.
July 12, 2022
Module tiler
Improvement
Improve speed of CREATE_SPATIAL_INDEX_TILESET.
July 8, 2022
Module quadbin
Improvement
Release SQL version of QUADBIN_TOZXY.
July 1, 2022
Module tiler
Improvement
Support h3int from CREATE_SPATIAL_INDEX_TILESET.
June 27, 2022
Module tiler
Improvement
Support quadbin from CREATE_SPATIAL_INDEX_TILESET instead of quadint.
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 20, 2022
Module tiler
Feature
Add CREATE_SPATIAL_INDEX_TILESET procedure.
June 7, 2022
Module lds
Fix
Fix chunks in CREATE_ISOLINES.
June 6, 2022
Module lds
Improvement
Check if the user has enough credits to execute CREATE_ISOLINES.
June 2, 2022
Module lds
Feature
Add CREATE_ISOLINES procedure.
May 19, 2022
Module lds
Improvement
Add optional
languageparameter to GEOCODE_REVERSE function.
May 13, 2022
Module tiler
Feature
Add max_simplification_zoom and coordinates_precision parameters.
April 21, 2022
Module tiler
Feature
Add max_tile_size_strategy support for CREATE_SIMPLE_TILESET.
Fix
Fix tile_feature_order not being taken into account for CREATE_POINT_AGGREGATION_TILESET and CREATE_POINT_AGGREGATION_TILESET.
March 30, 2022
Module tiler
Fix
Escape special characters in generated properties.
March 25, 2022
Module tiler
Improvement
Raise improper qualified tables errors.
Limit GeoJSON precision to 6 to comply Redshift VARCHAR size limitations.
Add ST_Simplify to the tiler.
March 10, 2022
Module tiler
Feature
Add CREATE_SIMPLE_TILESET procedure.
February 25, 2022
Module tiler
Feature
Create tiler module.
Add CREATE_POINT_AGGREGATION_TILESET procedure.
February 18, 2022
Module lds
Feature
Add GEOCODE_TABLE procedure.
Add GEOCODE function.
Add GEOCODE_REVERSE function.
Add ISOLINE function.
Add LDS_QUOTA_INFO function.
December 16, 2021
Module transformations
Fix
Refactor of internal __ST_GEOMFROMGEOJSON function to avoid UDFs nestig Redshift limitations
December 10, 2021
Module constructors
Improvement
Deployment schema “carto” instead of “constructors”.
Removed
Remove VERSION function.
Module placekey
Improvement
Deployment schema “carto” instead of “placekey”.
Rename H3_ASPLACEKEY function to PLACEKEY_FROMH3.
Rename PLACEKEY_ASH3 function to PLACEKEY_TOH3.
Rename ISVALID function to PLACEKEY_ISVALID.
Removed
Remove VERSION function.
Module processing
Improvement
Deployment schema “carto” instead of “processing”.
Removed
Remove VERSION function.
Module s2
Improvement
Deployment schema “carto” instead of “s2”.
Rename HILBERTQUADKEY_FROMID function to S2_TOHILBERTQUADKEY.
Rename ID_FROMHILBERTQUADKEY function to S2_FROMHILBERTQUADKEY.
Rename ID_FROMTOKEN function to S2_FROMTOKEN.
Rename ID_FROMUINT64REPR function to S2_FROMUINT64REPR.
Rename LONGLAT_ASID function to S2_FROMLONGLAT.
Rename RESOLUTION function to S2_RESOLUTION.
Rename ST_ASID function to S2_FROMGEOGPOINT.
Rename ST_ASID_POLYFILL_BBOX function to S2_POLYFILL_BBOX.
Rename ST_BOUNDARY function to S2_BOUNDARY.
Rename TOCHILDREN function to S2_TOCHILDREN.
Rename TOKEN_FROMID function to S2_TOTOKEN.
Rename TOPARENT function to S2_TOPARENT.
Rename UINT64REPR_FROMID function to S2_TOUINT64REPR.
Removed
Remove VERSION function.
Module transformations
Improvement
Deployment schema “carto” instead of “transformations”.
Removed
Remove VERSION function.
Module clustering
Improvement
Deployment schema “carto” instead of “clustering”.
Removed
Remove VERSION function.
Module random
Improvement
Deployment schema “carto” instead of “random”.
ST_GENERATEPOINTS now uses a spherically uniform distribution. Previously used to by uniform on projection.
Removed
Remove VERSION function.
October 21, 2021
Module clustering
Improvement
ST_CLUSTERKMEANS returning an Array.
October 6, 2021
Module processing
Feature
Create processing module.
Add VERSION function.
Add ST_POLYGONIZE function.
Add ST_DELAUNAYLINES function.
Add ST_DELAUNAYPOLYGONS function.
Add ST_VORONOILINES function.
Add ST_VORONOIPOLYGONS function.
Module transformations
Feature
Create transformations module.
Add VERSION function.
Add ST_CENTERMEAN function.
Add ST_CENTROID function.
Add ST_CENTEROFMASS function
Add ST_CENTERMEDIAN function
Add ST_GREATCIRCLE function
Add ST_DESTINATION function
October 5, 2021
Module clustering
Feature
Create clustering module.
Add VERSION function.
Add ST_CLUSTERKMEANS function.
Module random
Feature
Create random module.
Add ST_GENERATEPOINTS function.
Add VERSION function.
September 23, 2021
Module s2
Feature
Create s2 module.
Add HILBERTQUADKEY_FROMID function.
Add ID_FROMHILBERTQUADKEY function.
Add ID_FROMTOKEN function.
Add ID_FROMUINT64REPR function.
Add LONGLAT_ASID function.
Add RESOLUTION function.
Add ST_ASID function.
Add ST_ASID_POLYFILL_BBOX function.
Add ST_BOUNDARY function.
Add TOCHILDREN function.
Add TOKEN_FROMID function.
Add TOPARENT function.
Add UINT64REPR_FROMID function.
Add VERSION function.
September 17, 2021
Module constructors
Feature
Create constructors module.
Add ST_BEZIERSPLINE function.
Add ST_MAKEELLIPSE function.
Add ST_MAKEENVELOPE function.
Add ST_TILEENVELOPE function.
Add VERSION function.
September 7, 2021
Module placekey
Feature
Create placekey module.
Add H3_ASPLACEKEY function.
Add PLACEKEY_ASH3 function.
Add ISVALID function.
Add VERSION function.
Last updated