# Spatial Analysis ### Find clusters of customers with K-Means algorithm

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to find clusters of points using the K-Means algorithm. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/kmeans.sql)

### Find points that lie within a set of polygons and add properties

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to perform a geospatial intersection, finding points within polygons and adding properties. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/point_in_polygon.sql)

### Aggregate point data into polygons

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

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**](https://storage.googleapis.com/carto-workflows-examples/files/point_in_polygon_agg.sql)

### Generate Voronoi polygons from a set of points

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

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**](https://storage.googleapis.com/carto-workflows-examples/files/voronoi.sql)

### Custom SQL Select using 2 inputs

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use the "Custom SQL Select" component, using placeholders to reference two different inputs. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/custom_sql.sql)