carto-hotspot-analysis
Installation
SKILL.md
Hotspot Analysis with Getis-Ord Gi*
Builds CARTO Workflows that identify statistically significant spatial clusters (hotspots and coldspots) using the Getis-Ord Gi* statistic.
Prerequisites: Load carto-create-workflow for the development process, JSON structure, and validation commands.
Instructions
A hotspot workflow always follows this pipeline:
Source Data → (Filter) → Spatial Indexing → Aggregation → Getis-Ord Gi* → (Filter Significant) → Save
Step 1: Load Source Data
Use native.gettablebyname. The input table typically contains point geometries.