# 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)

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://academy.carto.com/creating-workflows/workflow-templates/spatial-analysis.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.