SQL Reference

The CARTO Analytics Toolbox's functions are organized in modules based on the functionality they offer. On this page you will find the full list with direct links to their definition.

Module	Function or Procedure
clustering	CREATE_CLUSTERKMEANS ST_CLUSTERKMEANS
constructors	ST_BEZIERSPLINE ST_MAKEELLIPSE ST_MAKEENVELOPE ST_TILEENVELOPE
data	DATAOBS_ENRICH_GRID DATAOBS_ENRICH_POINTS DATAOBS_ENRICH_POLYGONS ENRICH_GRID ENRICH_POINTS ENRICH_POLYGONS
http_request	HTTP_REQUEST GET_HTTP_REQUEST_QUOTA_INFO
import	IMPORT_URL
lds	GEOCODE_TABLE GEOCODE_REVERSE_TABLE CREATE_ISOLINES CREATE_ROUTES GEOCODE GEOCODE_REVERSE ISOLINE CREATE_ROUTING_MATRIX LDS_QUOTA_INFO
placekey	PLACEKEY_ASH3 PLACEKEY_FROMH3 PLACEKEY_ISVALID
processing	ST_DELAUNAYLINES ST_DELAUNAYPOLYGONS ST_POLYGONIZE ST_VORONOILINES ST_VORONOIPOLYGONS
quadbin	QUADBIN_BBOX QUADBIN_BOUNDARY QUADBIN_CENTER QUADBIN_DISTANCE QUADBIN_FROMGEOGPOINT QUADBIN_FROMLONGLAT QUADBIN_FROMQUADKEY QUADBIN_FROMZXY QUADBIN_ISVALID QUADBIN_KRING QUADBIN_KRING_DISTANCES QUADBIN_POLYFILL QUADBIN_RESOLUTION QUADBIN_SIBLING QUADBIN_TOCHILDREN QUADBIN_TOPARENT QUADBIN_TOQUADKEY QUADBIN_TOZXY
random	ST_GENERATEPOINTS
s2	S2_BOUNDARY S2_FROMGEOGPOINT S2_FROMHILBERTQUADKEY S2_FROMLONGLAT S2_FROMTOKEN S2_FROMUINT64REPR S2_POLYFILL_BBOX S2_RESOLUTION S2_TOCHILDREN S2_TOHILBERTQUADKEY S2_TOPARENT S2_TOTOKEN S2_TOUINT64REPR
statistics	GETIS_ORD_QUADBIN MORANS_I_QUADBIN P_VALUE
tiler	CREATE_SIMPLE_TILESET CREATE_POINT_AGGREGATION_TILESET CREATE_SPATIAL_INDEX_TILESET
transformations	ST_CENTERMEAN ST_CENTERMEDIAN ST_CENTEROFMASS ST_CENTROID ST_DESTINATION ST_GREATCIRCLE