Spatial Analysis
Find clusters of customers with K-Means algorithm
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
✅ | ✅ | ✅ | ✅ | ✅ |
This example demonstrates how to use Workflows to find clusters of points using the K-Means algorithm.
Find points that lie within a set of polygons and add properties
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
✅ | ✅ | ✅ | ✅ | ✅ |
This example demonstrates how to use Workflows to perform a geospatial intersection, finding points within polygons and adding properties.
Aggregate point data into polygons
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
✅ | ✅ | ✅ | ✅ | ✅ |
This example demonstrates how to use Workflows to perform an spatial intersection between points and polygons, adding aggregated data from the points into the polygons.
Generate Voronoi polygons from a set of points
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
✅ | ✅ | ✅ | ✅ | ✅ |
This example demonstrates how to use Workflows to generate Voronoi polygons from a set of points. Voronoi polygons are often used to find service areas for market analysis.
Custom SQL Select using 2 inputs
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
✅ | ✅ | ✅ | ✅ | ✅ |
This example demonstrates how to use the "Custom SQL Select" component, using placeholders to reference two different inputs.
Last updated