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​
clustering
core
​ST_CLUSTERKMEANS​
constructors
core
​ST_BEZIERSPLINE
ST_MAKEELLIPSE
ST_MAKEENVELOPE
ST_TILEENVELOPE​
cpg
advanced
​GENERATE_TRADE_AREAS
CUSTOMER_SEGMENTATION_ANALYSIS_DATA
RUN_CUSTOMER_SEGMENTATION
FIND_SIMILAR_LOCATIONS
FIND_SIMILAR_LOCATIONS_WEIGHTED​
data
advanced
​DATAOBS_ENRICH_GRID
DATAOBS_ENRICH_GRID_RAW
DATAOBS_ENRICH_POINTS
DATAOBS_ENRICH_POINTS_RAW
DATAOBS_ENRICH_POLYGONS
DATAOBS_ENRICH_POLYGONS_RAW
DATAOBS_SAMPLES
DATAOBS_SUBSCRIPTIONS
DATAOBS_SUBSCRIPTION_VARIABLES
ENRICH_GRID
ENRICH_GRID_RAW
ENRICH_POINTS
ENRICH_POINTS_RAW
ENRICH_POLYGONS
ENRICH_POLYGONS_RAW
GRIDIFY_ENRICH​
geohash
core
​GEOHASH_BOUNDARY​
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
LDS_QUOTA_INFO​
measurements
core
​ST_ANGLE
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​
raster
advanced
​RASTER_GETMETADATA
RASTER_ST_GETVALUE
RASTER_ST_GETVALUE_FROM_TABLE​
retail
advanced
​BUILD_REVENUE_MODEL_DATA
BUILD_REVENUE_MODEL
PREDICT_REVENUE_AVERAGE
FIND_WHITESPACE_AREAS
FIND_TWIN_AREAS
FIND_TWIN_AREAS_WEIGHTED
COMMERCIAL_HOTSPOTS
BUILD_CANNIBALIZATION_DATA
CANNIBALIZATION_OVERLAP​
routing
advanced
​ROUTING_MATRIX
ROUTING_ISOLINES​
s2
core
​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
advanced
​GETIS_ORD_H3
GETIS_ORD_QUADBIN
GFUN
GWR_GRID
IDW
KNN
LOCAL_MORANS_I_H3
LOCAL_MORANS_I_QUADBIN
LOF
LOF_TABLE
MORANS_I_H3
MORANS_I_QUADBIN
ORDINARY_KRIGING
ORDINARY_KRIGING_TABLE
P_VALUE
SMOOTHING_MRF_H3
SMOOTHING_MRF_QUADBIN
VARIOGRAM​
tiler
advanced
​CREATE_TILESET
CREATE_POINT_AGGREGATION_TILESET
CREATE_SPATIAL_INDEX_TILESET
CREATE_SIMPLE_TILESET​
transformations
core
​ST_BUFFER
ST_CENTERMEAN
ST_CENTERMEDIAN
ST_CENTEROFMASS
ST_CONCAVEHULL
ST_DESTINATION
ST_GREATCIRCLE
ST_LINE_INTERPOLATE_POINT​
​
This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.

Module	Type	Function or Procedure
accessors	core	ST_ENVELOPE
clustering	core	ST_CLUSTERKMEANS
constructors	core	ST_BEZIERSPLINE ST_MAKEELLIPSE ST_MAKEENVELOPE ST_TILEENVELOPE
cpg	advanced	GENERATE_TRADE_AREAS CUSTOMER_SEGMENTATION_ANALYSIS_DATA RUN_CUSTOMER_SEGMENTATION FIND_SIMILAR_LOCATIONS FIND_SIMILAR_LOCATIONS_WEIGHTED
data	advanced	DATAOBS_ENRICH_GRID DATAOBS_ENRICH_GRID_RAW DATAOBS_ENRICH_POINTS DATAOBS_ENRICH_POINTS_RAW DATAOBS_ENRICH_POLYGONS DATAOBS_ENRICH_POLYGONS_RAW DATAOBS_SAMPLES DATAOBS_SUBSCRIPTIONS DATAOBS_SUBSCRIPTION_VARIABLES ENRICH_GRID ENRICH_GRID_RAW ENRICH_POINTS ENRICH_POINTS_RAW ENRICH_POLYGONS ENRICH_POLYGONS_RAW GRIDIFY_ENRICH
geohash	core	GEOHASH_BOUNDARY
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 LDS_QUOTA_INFO
measurements	core	ST_ANGLE 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
raster	advanced	RASTER_GETMETADATA RASTER_ST_GETVALUE RASTER_ST_GETVALUE_FROM_TABLE
retail	advanced	BUILD_REVENUE_MODEL_DATA BUILD_REVENUE_MODEL PREDICT_REVENUE_AVERAGE FIND_WHITESPACE_AREAS FIND_TWIN_AREAS FIND_TWIN_AREAS_WEIGHTED COMMERCIAL_HOTSPOTS BUILD_CANNIBALIZATION_DATA CANNIBALIZATION_OVERLAP
routing	advanced	ROUTING_MATRIX ROUTING_ISOLINES
s2	core	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	advanced	GETIS_ORD_H3 GETIS_ORD_QUADBIN GFUN GWR_GRID IDW KNN LOCAL_MORANS_I_H3 LOCAL_MORANS_I_QUADBIN LOF LOF_TABLE MORANS_I_H3 MORANS_I_QUADBIN ORDINARY_KRIGING ORDINARY_KRIGING_TABLE P_VALUE SMOOTHING_MRF_H3 SMOOTHING_MRF_QUADBIN VARIOGRAM
tiler	advanced	CREATE_TILESET CREATE_POINT_AGGREGATION_TILESET CREATE_SPATIAL_INDEX_TILESET CREATE_SIMPLE_TILESET
transformations	core	ST_BUFFER ST_CENTERMEAN ST_CENTERMEDIAN ST_CENTEROFMASS ST_CONCAVEHULL ST_DESTINATION ST_GREATCIRCLE ST_LINE_INTERPOLATE_POINT

Identifying amenity hotspots in Stockholm

accessors

Last modified 1h ago