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.

Download example

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.

Download example

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.

Download example

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.

Download example

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.

Download example