Spatial Analysis

Components to perform more advanced geospatial analytics leveraging the spatial properties and patterns in your data.

K-Nearest Neighbors

This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.

Description

This component performs a K-nearest neighbors analysis.

Inputs

  • Points table [Table]

  • Id column [Column]

  • Geo column [Column]

  • Number of nearest neighbors [Number]

  • Maximum distance: Defines the maximum distance where neighbors will be considered.

Outputs

  • Result table [Table]

External links

BigQuery reference

ST Cluster DBSCAN

Description

This component performs a DB Scan clustering on the geographical coordinates. Given an input table and a geo column, it creates a new table with the same content as the input one and an additional column named 'cluster' containing the cluster id corresponding to each geography.

Inputs

  • Source table [Table]

  • Geo column [Column]

  • Search radius (m) [Number]

  • Minimum number of geographies [Number]

Outputs

  • Result table [Table]

External links

BigQuery reference

ST Cluster K-Means

This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.

Description

This component performs a K-means clustering on the geographical coordinates. Given an input table and a geo column, it creates a new table with the same content as the input one and an additional column named 'cluster' containing the cluster id corresponding to each geography..

Inputs

  • Source table [Table]

  • Geo column [Column]

  • Number of clusters [Number]

Outputs

  • Result table [Table]

External links

BigQuery reference

ST Count Points in Polygons

Description

This component takes a points table and a polygons table. It creates a new table with the same content as the polygons table, with an additional column containing the number of points from the points table that fall within each polygon.

Inputs

  • Points table [Table]

  • Polygons table [Table]

  • Geo column in points table [Column]

  • Geo column in polygons table [Column]

  • Column with identifier in polygons table [Column]

Outputs

  • Result table [Table]

ST Delaunay Polygons

This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.

Description

This component computes a Delaunay triangulation based in a input table with points.

It creates a new table with a 'geom' column containing the triangulation geographies (lines or polygons)

Inputs

  • Source table [Table]

  • Geo column [Column]

  • Return lines [Boolean]

Outputs

  • Result table [Table]

External links

BigQuery reference

ST Voronoi

This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.

Description

This component computes a Voronoi tesellation based in a input table with points.

It creates a new table with a 'geom' column containing the triangulation geographies (lines or polygons).

The maximum number of points used to compute Voronoi diagrams is 300,000. This limit ensures efficient computation while maintaining accuracy in delineating regions based on proximity to specified points.

Inputs

  • Source table [Table]

  • Geo column [Column]

  • Return lines [Boolean]

Outputs

  • Result table [Table]

External links

BigQuery reference

Last updated