Links

Release Notes

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.

Module h3

  • The H3_BOUNDARY function for invalid geographies has been fixed.

November 1, 2022

All modules

Feature
  • Create release workflows

October 24, 2022

Module processing

Fix
  • Prevent error in ST_VORONOIPOLYGONS, ST_VORONOILINES, ST_VORONOIPOLYGONS, ST_DELAUNAYLINES when points where too close together by rounding input coordinates to 5 decimal places

October 7, 2022

Module clustering

Feature
  • Move ST_CLUSTERKMEANS function to core.

Module random

Feature
  • Move ST_GENERATEPOINTS function to core.

October 4, 2022

Module lds

Improvement
  • CREATE_ISOLINES output is ordered by geometry to be compliant with Snowflake Search Optimization Service.

September 30, 2022

Module lds

Improvement
  • Rename LDS_API_URL to API_BASE_URL.

September 28, 2022

Module data

Improvement
  • Optimize DATAOBS_ENRICH_GRID, DATAOBS_ENRICH_GRID_RAW when the enrich data is a grid compatible with the input.
  • Remove support for s2, geohash in all enrich procedures.
  • Optimize performance of all enrich result tables by ordering or clusterizing them.

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 13, 2022

Module data

Feature
  • Add quadbin support to module.

July 12, 2022

Module tiler

Fix
  • Fix quoting and letter case in spatial index tiler.

July 8, 2022

Module tiler

Fix
  • Fix wrong uppercase in spatial index tiler.
Improvement
  • Use core functions to convert H3 from int to string.

July 7, 2022

Module h3

Fix
  • Correctly handle large polygons in H3_POLYFILL.
  • Fixed wrong uppercase for quadbin and h3 tile ids

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_SIBLINGS function.
  • Add QUADBIN_TOCHILDREN function.
  • Add QUADBIN_TOPARENT function.
  • Add QUADBIN_TOZXY function.

June 23, 2022

Module tiler

Improvement
  • Add CREATE_SPATIAL_INDEX_TILESET procedure.

June 15, 2022

Module data

Improvement
  • ENRICH_ procedures require all the enrich data query rows to be of the same geometry kind (points/lines/polygons) .
  • Various optimizations for performance and preventing out-of-memory errors
Improvement
  • Errors used to be reported with a procedure result message. Now they raise exceptions.

May 19, 2022

Module lds

Improvement
  • Add optional language parameter to GEOCODE_REVERSE function.

May 6, 2022

Module data

Improvement
  • Errors used to be reported with a procedure result message. Now they raise exceptions.

April 28, 2022

Module data

Feature
  • Allow using tables as input, not just queries.
  • Add in place enrichment.

April 21, 2022

Module tiler

Improvement
  • Add support for non-uppercase column names

April 20, 2022

Module tiler

Improvement
  • Errors used to be reported with a procedure result message. Now they raise exceptions.

April 7, 2022

Module transformations

Feature
  • Add ST_BUFFER function.

March 25, 2022

Module tiler

Improvement
  • Run the simple tiler in a single query.
  • Add fraction_dropped_per_zoom to the metadata.
Fix
  • Fix empty properties causing errors.
  • Fix drop_fraction_as_needed in the simple tiler.
  • Fix problems with GeometryCollections received after ST_Simplify.

March 21, 2022

Module transformations

Improvement
  • ST_CONCAVEHULL now allows arrays with one/two points as input.

February 24, 2022

Module tiler

Feature
  • Add CREATE_SIMPLE_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.

February 16, 2022

Module tiler

Feature
  • Create tiler module.
  • Add CREATE_POINT_AGGREGATION_TILESET procedure.

January 10, 2022

Module data

Feature
  • Add DATAOBS_SUBSCRIPTIONS procedure.
  • Add DATABOS_SUBSCRIPTION_VARIABLES procedure.
Improvement
  • Read spatial_catalog tables in source.

December 15, 2021

Module data

Improvement
  • Missing subscriptions are reported by name in DATAOBS_ENRICH_* procedures

December 10, 2021

Module random

Improvement
  • ST_GENERATEPOINTS now uses a spherically uniform distribution. Previously used to by uniform on projection.

December 3, 2021

Module accessors

Improvement
  • Deployment schema “carto” instead of “accessors”.
  • Rename ST_ENVELOPE function to ST_ENVELOPE_ARR.
Removed
  • Remove VERSION function.

Module constructors

Improvement
  • Deployment schema “carto” instead of “constructors”.
Removed
  • Remove VERSION function.

Module h3

Improvement
  • Deployment schema “carto” instead of “h3”.
  • Rename ST_ASH3 function to H3_FROMGEOGPOINT.
  • Rename LONGLAT_ASH3 function to H3_FROMLONGLAT.
  • Rename ST_ASH3_POLYFILL function to H3_POLYFILL.
  • Rename ST_BOUNDARY function to H3_BOUNDARY.
  • Rename ISVALID function to H3_ISVALID.
  • Rename COMPACT function to H3_COMPACT.
  • Rename UNCOMPACT function to H3_UNCOMPACT.
  • Rename TOPARENT function to H3_TOPARENT.
  • Rename TOCHILDREN function to H3_TOCHILDREN.
  • Rename ISPENTAGON function to H3_ISPENTAGON.
  • Rename DISTANCE function to H3_DISTANCE.
  • Rename KRING function to H3_KRING.
  • Rename KRING_DISTANCES function to H3_KRING_DISTANCES.
  • Rename HEXRING function to H3_HEXRING.
Removed
  • Remove VERSION function.

Module measurements

Improvement
  • Deployment schema “carto” instead of “measurements”.
Removed
  • Remove ST_ANGLE, already present in Snowflake.
  • Remove ST_AZIMUTH, already present in Snowflake.
  • 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 ID_FROMHILBERTQUADKEY function to S2_FROMHILBERTQUADKEY.
  • Rename HILBERTQUADKEY_FROMID function to S2_TOHILBERTQUADKEY.
  • Rename LONGLAT_ASID function to S2_FROMLONGLAT.
  • Rename ST_ASID function to S2_FROMGEOGPOINT.
  • Rename ST_BOUNDARY function to S2_BOUNDARY.
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 data

Improvement
  • Deployment schema “carto” instead of “data”.
Removed
  • Remove VERSION function.

Module random

Improvement
  • Deployment schema “carto” instead of “random”.
Removed
  • Remove VERSION function.

November 25, 2021

Module clustering

Improvement
  • Deployment schema “carto” instead of “clustering”.
  • Remove VERSION function.

Module data

Improvement
  • Deployment schema “carto” instead of “data”.
  • Remove VERSION function.

Module random

Improvement
  • Deployment schema “carto” instead of “random”.
  • Remove VERSION function.

November 24, 2021

Module data

Feature
  • Add DATAOBS_ENRICH_POINTS procedure.
  • Add DATAOBS_ENRICH_POINTS_RAW procedure.
  • Add DATAOBS_ENRICH_POLYGON procedure.
  • Add DATAOBS_ENRICH_POLYGON_RAW procedure.
  • Add DATAOBS_ENRICH_GRID procedure.
  • Add DATAOBS_ENRICH_GRID_RAW procedure.

November 5, 2021

Module data

Changes
  • Fields named dimension, total, intersection and input_area are now __carto_dimension, __carto_total and __carto_intersection and __carto_input_area. Also the column _carto_enrichment_ is now __carto_enrichment. This affects all the raw enrichment procedures: ENRICH_POINTS_RAW, ENRICH_POLYGONS_RAW, ENRICH_GRID_RAW.
Fix
  • User provided queries can now have columns named dimension, total, intersection, input_area, _nonglobal, which could have collided previously with internal columns. All internal columns are now prefixed with __carto_. This affects all the enrichment procedures: ENRICH_POINTS, ENRICH_POLYGONS, ENRICH_GRID, ENRICH_POINTS_RAW, ENRICH_POLYGONS_RAW, ENRICH_GRID_RAW.

November 4, 2021

Module data

Feature
  • Create data module.
  • Add VERSION function.
  • Add ENRICH_POINTS procedure.
  • Add ENRICH_POINTS_RAW procedure.
  • Add ENRICH_POLYGON procedure.
  • Add ENRICH_POLYGON_RAW procedure.
  • Add ENRICH_GRID procedure.
  • Add ENRICH_GRID_RAW procedure.

September 22, 2021

Module h3

Feature
  • Add KRING_DISTANCES function.
Improvement
  • Review HEXRING, KRING functions.

September 14, 2021

Module s2

Changes
  • Compute ST_BOUNDARY from WKT.

August 24, 2021

Module h3

Fix
  • Support GEOMETRYCOLLECTION from ST_ASH3_POLYFILL.

June 2, 2021

Module h3

Improvement
  • Reduce bundle size for every function.

May 26, 2021

Module processing

Feature
  • Create processing module.
  • Add ST_VORONOIPOLYGONS function.
  • Add ST_VORONOILINES function.
  • Add ST_DELAUNAYPOLYGONS function.
  • Add ST_DELAUNAYLINES function.
  • Add ST_POLYGONIZE function.
  • Add VERSION function.

May 24, 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.

May 21, 2021

Module accessors

Feature
  • Create accessors module.
  • Add ST_ENVELOPE function.
  • Add VERSION function.

May 20, 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.

Module measurements

Feature
  • Create measurements module.
  • Add ST_ANGLE function.
  • Add ST_AZIMUTH function.
  • Add ST_MINKOWSKIDISTANCE function.
  • Add VERSION function.

Module transformations

Feature
  • Create transformations module.
  • Add ST_CENTERMEAN function.
  • Add ST_CENTERMEDIAN function.
  • Add ST_CENTEROFMASS function.
  • Add ST_CONCAVEHULL function.
  • Add ST_DESTINATION function.
  • Add ST_GREATCIRCLE function.
  • Add ST_LINE_INTERPOLATE_POINT function.
  • Add VERSION function.

April 16, 2021

Module placekey

Feature
  • Create placekey module.
  • Add H3_ASPLACEKEY function.
  • Add PLACEKEY_ASH3 function.
  • Add ISVALID function.
  • Add VERSION function.

April 12, 2021

Module s2

Feature
  • Create s2 module.
  • Add ID_FROMHILBERTQUADKEY function.
  • Add HILBERTQUADKEY_FROMID function.
  • Add LONGLAT_ASID function.
  • Add ST_ASID function.
  • Add ST_BOUNDARY function.
  • Add VERSION function.

April 7, 2021

Module h3

Feature
  • Create h3 module.
  • Add ST_ASH3 function.
  • Add LONGLAT_ASH3 function.
  • Add ST_ASH3_POLYFILL function.
  • Add ST_BOUNDARY function.
  • Add ISVALID function.
  • Add COMPACT function.
  • Add UNCOMPACT function.
  • Add TOPARENT function.
  • Add TOCHILDREN function.
  • Add ISPENTAGON function.
  • Add DISTANCE function.
  • Add KRING function.
  • Add HEXRING function.
  • Add VERSION function.