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

Inputs

  • Source table [Table]

  • Geo column [Column]

  • Return lines [Boolean]

Outputs

  • Result table [Table]

External links

BigQuery reference

Last updated

Was this helpful?