Data Enrichment
Components to enrich your data with variables from other data sources. These components work for simple features and spatial indexes grids.
Enrich H3 Grid
Description
This component enriches a target table with data from a source. Enriching here means adding columns with aggregated data from the source that matches the target geographies.
The target, (which is the upper input connection of this component), must have a column that contains H3 indices, which will be used to join with the source.
The source (lower input connection) can be either a CARTO Data Observatory subscription or table (or result from other component) with a geography column.
For the enrichment operation the CARTO Analytics Toolbox is required, and one of the following procedures will be called:
DATAOBS_ENRICH_GRID
if the source is a Data Observatory subscriptionENRICH_GRID
otherwise
Inputs
Target geo column
: it's the column of the target that will be used to join with the source and select the rows that will be aggregated for each target row.Source geo column
: (only necessary for non-DO sources) is the column of the source that will join with the target.Variables
: this allows selecting the data from the source that will be aggregated and added to the target.For Data Observatory subscriptions, the variables can be selected from the DO variables of the subscription, identified by their variable slug;
for other sources they are the columns in the source table.
Each variable added must be assigned an aggregation method. You can add the same variable with different aggregation methods. At the moment only numeric variables are supported.
For spatially smoothed enrichments that take into account the surrounding cells, use the following input parameters:
Kring size
: size of the k-ring where the decay function will be applied. This value can be 0, in which case no k-ring will be computed and the decay function won't be applied.Decay function
: decay function to aggregate and smooth the data. Supported values areuniform
,inverse
,inverse_square
andexponential
.
Outputs
Result table [Table]
Enrich Points
Description
This component enriches a target table with data from a source. Enriching here means adding columns with aggregated data from the source that matches (intersects) the target geographies.
The target, (which is the upper input connection of this component), must have a geo column, which will be used to intersect with the source.
The source (lower input connection) can be either a CARTO Data Observatory subscription or table (or result from other component) with a geo column.
For the enrichment operation the CARTO Analytics Toolbox is required, and one of the following procedures will be called:
DATAOBS_ENRICH_POINTS if the source is a Data Observatory subscription
ENRICH_POINTS otherwise
Inputs
Target geo column
: it's the column of the target that will be used to intersect with the source and select the rows that will be aggregated for each target row.Source geo column
: (only necessary for non-DO sources) is the column of the source that will intersect with the target.Variables
: this allows selecting the data from the source that will be aggregated and added to the target.For Data Observatory subscriptions, the variables can be selected from the DO variables of the subscription, identified by their variable slug;
for other sources they are the columns in the source table.
Each variable added must be assigned an aggregation method. You can add the same variable with different aggregation methods. At the moment only numeric variables are supported.
Outputs
Result table [Table]
Enrich Polygons
Description
This component enriches a target table with data from a source. Enriching here means adding columns with aggregated data from the source that matches (intersects) the target geographies.
The target, (which is the upper input connection of this component), must have a geo column, which will be used to intersect with the source.
The source (lower input connection) can be either a CARTO Data Observatory subscription or table (or result from other component) with a geo column.
For the enrichment operation the CARTO Analytics Toolbox is required, and one of the following procedures will be called:
DATAOBS_ENRICH_POLYGONS
if the source is a Data Observatory subscriptionENRICH_POLYGONS
otherwise
Inputs
Target geo column
: it's the column of the target that will be used to intersect with the source and select the rows that will be aggregated for each target row.Source geo column
: (only necessary for non-DO sources) is the column of the source that will intersect with the target.Variables
: this allows selecting the data from the source that will be aggregated and added to the target.For Data Observatory subscriptions, the variables can be selected from the DO variables of the subscription, identified by their variable slug;
for other sources they are the columns in the source table.
Each variable added must be assigned an aggregation method. You can add the same variable with different aggregation methods. At the moment only numeric variables are supported.
Outputs
Result table [Table]
Enrich Quadbin Grid
Description
This component enriches a target table with data from a source. Enriching here means adding columns with aggregated data from the source that matches the target geographies.
The target, (which is the upper input connection of this component), must have a column that contains Quadbin indices, which will be used to join with the source.
The source (lower input connection) can be either a CARTO Data Observatory subscription or table (or result from other component) with a geography column.
For the enrichment operation the CARTO Analytics Toolbox is required, and one of the following procedures will be called:
DATAOBS_ENRICH_GRID
if the source is a Data Observatory subscriptionENRICH_GRID
otherwise
Inputs
Target geo column
: it's the column of the target that will be used to join with the source and select the rows that will be aggregated for each target row.Source geo column
: (only necessary for non-DO sources) is the column of the source that will join with the target.Variables
: this allows selecting the data from the source that will be aggregated and added to the target.For Data Observatory subscriptions, the variables can be selected from the DO variables of the subscription, identified by their variable slug;
for other sources they are the columns in the source table.
Each variable added must be assigned an aggregation method. You can add the same variable with different aggregation methods. At the moment only numeric variables are supported.
For spatially smoothed enrichments that take into account the surrounding cells, use the following input parameters:
Kring size
: size of the k-ring where the decay function will be applied. This value can be 0, in which case no k-ring will be computed and the decay function won't be applied.Decay function
: decay function to aggregate and smooth the data. Supported values areuniform
,inverse
,inverse_square
andexponential
.
Outputs
Result table [Table]
Last updated