Comment on page
Spatial Indexes
Components to operate with spatial indexes: H3 and Quadbin. Learn more about how to leverage spatial indexes in your analyses.
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This component takes a table with H3 cell indices and generates a new one with an additional column containing the boundaries of those H3 cells.
Inputs
Source table [Table]H3 column [Column]
Outputs
Result table [Table]
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This component adds a new column containing the centers of H3 cells.
Inputs
Source table [Table]H3 column [Column]
Outputs
Result table [Table]:
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This component computes the H3 grid distance between two H3 index columns, creating a new table with the same columns as the source one and adding a new 'h3_distance' column.
The H3 distance is defined as the length of the shortest path between the cells in the graph formed by connecting adjacent cells.
This function will return 'null' if the cells are too far apart to compute the distance.
Inputs
Source table [Table]First H3 index column [Column]Second H3 index column [Column]
Outputs
Result table [Table]:
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This component adds a new column containing the indices of H3 cells corresponding to points.
Inputs
Source table [Table]Points column [Column]Resolution [Number]
Outputs
Result table [Table]
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
Returns the neighboring indexes in all directions under the K distance size.
Inputs
Source table [Table]H3 index [Column]Size [Number]Include distance [Boolean]: add or not column with the value of H3 distanceInclude columns [Boolean]: copy or not source columns in the result table
Outputs
Result table [Table]:
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This generates a table with indices of all H3 cells included within a given extent for a given resolution.
The extent is specified using a table with polygons.
Inputs
Source table [Table]Geo column [Column]Resolution [Number]Keep input table columns: If checked, all the original columns of the source table will be added to the result table. Otherwise, only columns with the geometry and the H3 index will be added.
Outputs
Result table [Table]:
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
Adds a new column named h3_parent with the value of the parent h3 at a specific resolution. If required resolution is higher than h3 column, a null value will be set.
Inputs
Source table [Table]H3 index [Column]Resolution [Number]
Outputs
Result table [Table]:
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This component takes a table with Quadbin cell indices and generates a new one with an additional column containing the boundaries of those Quadbin cells.
Inputs
Source table [Table]Quadbin column [Column]
Outputs
Result table [Table]
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This component adds a new column containing the centers of Quadbin cells.
Inputs
Source table [Table]Quadbin column [Column]
Outputs
Result table [Table]
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This component adds a new column containing the indices of Quadbin cells corresponding to points.
Inputs
Source table [Table]Points column [Column]Resolution [Number]
Outputs
Result table [Table]
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
Returns all Quadbin cell indexes and their distances in a filled square k-ring of a user defined size centered at the origin in no particular order.
Inputs
Source table [Table]Quadbin index [Column]Size [Number]Include distance [Boolean]: add or not column with the value of Quadbin distanceInclude columns [Boolean]: copy or not source columns in the result table
Outputs
Result table [Table]
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
This generates a table with indices of all Quadbin cells included within a given extent for a given resolution.
The extent is specified using a table with polygons.
Inputs
Source table [Table]Geo column [Column]Resolution [Number]
Outputs
Result table [Table]
External links
This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.
Description
It adds a new column named quadbin_parent with the value of the parent quadbin at a specific resolution. If required resolution is higher than quadbin column, than an "Invalid resolution" query error will be returned.
Inputs
Source table [Table]Quadbin index [Column]Resolution [Number]
Outputs
Result table [Table]
External links
Last modified 24d ago