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
accessors	ST_ENVELOPE
clustering	ST_CLUSTERKMEANS
constructors	ST_BEZIERSPLINE ST_MAKEELLIPSE ST_MAKEENVELOPE ST_TILEENVELOPE
cpg	GENERATE_TRADE_AREAS CUSTOMER_SEGMENTATION_ANALYSIS_DATA RUN_CUSTOMER_SEGMENTATION UNIVERSE_MATCHING UNIVERSE_MATCHING_REPORT CREATE_SPATIAL_SCORE CREATE_SPATIAL_PERFORMANCE_SCORE BUILD_SIMILAR_LOCATIONS_MODEL FIND_SIMILAR_LOCATIONS FIND_SIMILAR_LOCATIONS_WEIGHTED
data	DATAOBS_ENRICH_GRID DATAOBS_ENRICH_GRID_RAW DATAOBS_ENRICH_GRID_WEIGHTED DATAOBS_ENRICH_POINTS DATAOBS_ENRICH_POINTS_RAW DATAOBS_ENRICH_POLYGONS DATAOBS_ENRICH_POLYGONS_RAW DATAOBS_ENRICH_POLYGONS_WEIGHTED DATAOBS_SAMPLES DATAOBS_SUBSCRIPTIONS DATAOBS_SUBSCRIPTION_VARIABLES ENRICH_GRID ENRICH_GRID_RAW ENRICH_POINTS ENRICH_POINTS_RAW ENRICH_POLYGONS ENRICH_POLYGONS_RAW ENRICH_POLYGONS_WEIGHTED GRIDIFY_ENRICH
geohash	GEOHASH_BOUNDARY
h3	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_POLYFILL_MODE H3_POLYFILL_TABLE H3_RESOLUTION H3_STRING_TOINT H3_TOCHILDREN H3_TOPARENT H3_UNCOMPACT
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 GET_LDS_QUOTA_INFO CREATE_ROUTING_MATRIX
measurements	ST_ANGLE ST_MINKOWSKIDISTANCE
placekey	PLACEKEY_FROMH3 PLACEKEY_ISVALID PLACEKEY_TOH3
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_POLYFILL_MODE QUADBIN_POLYFILL_TABLE QUADBIN_RESOLUTION QUADBIN_SIBLING QUADBIN_TOCHILDREN QUADBIN_TOPARENT QUADBIN_TOQUADKEY QUADBIN_TOZXY
random	ST_GENERATEPOINTS
raster	RASTER_VALUES RASTER_AGG_VALUES
retail	BUILD_REVENUE_MODEL_DATA BUILD_REVENUE_MODEL PREDICT_REVENUE_AVERAGE FIND_WHITESPACE_AREAS COMMERCIAL_HOTSPOTS BUILD_CANNIBALIZATION_DATA CANNIBALIZATION_OVERLAP BUILD_TWIN_AREAS_MODEL FIND_TWIN_AREAS FIND_TWIN_AREAS_WEIGHTED
routing	ROUTING_MATRIX ROUTING_ISOLINES
s2	S2_BOUNDARY S2_CENTER S2_FROMGEOGPOINT S2_FROMHILBERTQUADKEY S2_FROMLONGLAT S2_FROMTOKEN S2_FROMUINT64REPR S2_RESOLUTION S2_TOCHILDREN S2_TOHILBERTQUADKEY S2_TOTOKEN S2_TOUINT64REPR
statistics	P_VALUE KNN_TABLE KNN LOF_TABLE LOF GFUN_TABLE GFUN CREATE_SPATIAL_COMPOSITE_SUPERVISED CREATE_SPATIAL_COMPOSITE_UNSUPERVISED CRONBACH_ALPHA_COEFFICIENT GWR_GRID GETIS_ORD_H3_TABLE GETIS_ORD_H3 GETIS_ORD_QUADBIN_TABLE GETIS_ORD_QUADBIN GETIS_ORD_SPACETIME_H3_TABLE GETIS_ORD_SPACETIME_H3 GETIS_ORD_SPACETIME_QUADBIN_TABLE GETIS_ORD_SPACETIME_QUADBIN MORANS_I_H3_TABLE MORANS_I_H3 MORANS_I_QUADBIN_TABLE MORANS_I_QUADBIN LOCAL_MORANS_I_H3_TABLE LOCAL_MORANS_I_H3 LOCAL_MORANS_I_QUADBIN_TABLE LOCAL_MORANS_I_QUADBIN VARIOGRAM ORDINARY_KRIGING_TABLE ORDINARY_KRIGING IDW SMOOTHING_MRF_H3 SMOOTHING_MRF_QUADBIN BUILD_PCAMIX_DATA BUILD_PCAMIX_MODEL PREDICT_PCAMIX_SCORES DETECT_SPATIAL_ANOMALIES DETECT_SPACETIME_ANOMALIES AREA_OF_APPLICABILITY ENV_BLOCKING KRING_SPACETIME_AGGREGATE KRING_SPACETIME_SMOOTHING KRING_SPATIAL_AGGREGATE KRING_SPATIAL_SMOOTHING SPACETIME_HOTSPOTS_CLASSIFICATION TIME_SERIES_CLUSTERING
telco	TELCO_PATH_PROFILE TELCO_PATH_PROFILE_RASTER CLOSE_IN EXTENDED_HATA
tiler	CREATE_TILESET CREATE_POINT_AGGREGATION_TILESET CREATE_SPATIAL_INDEX_TILESET CREATE_SIMPLE_TILESET
transformations	ST_BUFFER ST_CENTERMEAN ST_CENTERMEDIAN ST_CENTEROFMASS ST_CONCAVEHULL ST_DESTINATION ST_GREATCIRCLE ST_LINE_INTERPOLATE_POINT ST_POINTONSURFACE

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.