Spatial Indexes

Components to operate with spatial indexes: H3 and Quadbin. Learn more about how to leverage spatial indexes in your analyses.

H3 Boundary

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

BigQuery reference

Snowflake reference

H3 Center

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

BigQuery reference

H3 from GeoPoint

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

BigQuery reference

Snowflake reference

H3 Polyfill

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]

Outputs

• Result table [Table]:

External links

BigQuery reference

Snowflake reference

Quadbin Boundary

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

BigQuery reference

Snowflake reference

Redshift reference

PostgreSQL reference

Quadbin Center

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

BigQuery reference

Snowflake reference

Redshift reference

PostgreSQL reference

Quadbin from GeoPoint

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

BigQuery reference

Snowflake reference

Redshift reference

PostgreSQL reference

Quadbin Polyfill

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

BigQuery reference

Snowflake reference

Redshift reference

PostgreSQL reference