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	Type	Function or Procedure
accessors	core	ST_ENVELOPE_ARR
clustering	core	ST_CLUSTERKMEANS
constructors	core	ST_BEZIERSPLINE ST_MAKEELLIPSE ST_MAKEENVELOPE ST_TILEENVELOPE
data	advanced	DATAOBS_ENRICH_GRID DATAOBS_ENRICH_GRID_RAW DATAOBS_ENRICH_POINTS DATAOBS_ENRICH_POINTS_RAW DATAOBS_ENRICH_POLYGONS DATAOBS_ENRICH_POLYGONS_RAW DATAOBS_SUBSCRIPTIONS DATAOBS_SUBSCRIPTION_VARIABLES ENRICH_GRID ENRICH_GRID_RAW ENRICH_POINTS ENRICH_POINTS_RAW ENRICH_POLYGONS ENRICH_POLYGONS_RAW
h3	core	H3_BOUNDARY H3_CENTER H3_COMPACT H3_DISTANCE H3_FROMGEOGPOINT H3_FROMLONGLAT H3_HEXRING H3_INT_TOSTRING H3_ISPENTAGON H3_ISVALID H3_KRING H3_KRING_DISTANCES H3_POLYFILL H3_RESOLUTION H3_STRING_TOINT H3_TOCHILDREN H3_TOPARENT H3_UNCOMPACT
lds	advanced	GEOCODE_TABLE GEOCODE_REVERSE_TABLE CREATE_ISOLINES GEOCODE GEOCODE_REVERSE ISOLINE LDS_QUOTA_INFO
measurements	core	ST_MINKOWSKIDISTANCE
placekey	core	PLACEKEY_FROMH3 PLACEKEY_ISVALID PLACEKEY_TOH3
processing	core	ST_DELAUNAYLINES ST_DELAUNAYPOLYGONS ST_POLYGONIZE ST_VORONOILINES ST_VORONOIPOLYGONS
quadbin	core	QUADBIN_BBOX QUADBIN_BOUNDARY QUADBIN_CENTER 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	core	ST_GENERATEPOINTS
s2	core	S2_BOUNDARY S2_FROMGEOGPOINT S2_FROMHILBERTQUADKEY S2_FROMLONGLAT S2_TOHILBERTQUADKEY
statistics	advanced	P_VALUE GETIS_ORD_H3 GETIS_ORD_QUADBIN MORANS_I_H3 MORANS_I_QUADBIN
tiler	advanced	CREATE_SIMPLE_TILESET CREATE_POINT_AGGREGATION_TILESET CREATE_SPATIAL_INDEX_TILESET
transformations	core	ST_BUFFER ST_CENTERMEAN ST_CENTERMEDIAN ST_CENTEROFMASS ST_CONCAVEHULL ST_CONVEXHULL ST_DESTINATION ST_GREATCIRCLE ST_LINE_INTERPOLATE_POINT