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_COORDDIM ST_DIMENSION ST_ENVELOPE ST_GEOMETRYN ST_ISCLOSED ST_ISCOLLECTION ST_ISEMPTY ST_ISGEOMFIELD ST_ISRING ST_ISSIMPLE ST_ISVALID ST_NUMGEOMETRIES ST_NUMPOINTS ST_POINTN ST_X ST_Y
constructors	core	ST_MAKEBBOX ST_MAKEBOX2D ST_MAKEPOINT ST_MAKEPOINTM ST_MAKEPOLYGON ST_POINT
formatters	core	ST_ASBINARY ST_ASGEOJSON ST_ASLATLONTEXT ST_ASTEXT ST_ASTWKB ST_BYTEARRAY ST_CASTTOGEOMETRY ST_CASTTOLINESTRING ST_CASTTOPOINT ST_CASTTOPOLYGON ST_GEOHASH
indexing	core	ST_CRSFROMTEXT ST_EXTENTFROMGEOM ST_EXTENTTOGEOM ST_GEOMREPROJECT ST_MAKEEXTENT
measurements	core	ST_AREA ST_DISTANCE ST_DISTANCESPHERE ST_LENGTH ST_LENGTHSPHERE
parsers	core	ST_BOX2DFROMGEOHASH ST_GEOMFROMGEOHASH ST_GEOMFROMGEOJSON ST_GEOMFROMTEXT ST_GEOMFROMTWKB ST_GEOMFROMWKB ST_GEOMFROMWKT ST_LINEFROMTEXT ST_MLINEFROMTEXT ST_MPOINTFROMTEXT ST_MPOLYFROMTEXT ST_POINTFROMGEOHASH ST_POINTFROMTEXT ST_POINTFROMWKB ST_POLYGONFROMTEXT
predicates	core	ST_CONTAINS ST_COVERS ST_CROSSES ST_DISJOINT ST_EQUALS ST_INTERSECTS ST_OVERLAPS ST_RELATE ST_RELATEBOOL ST_TOUCHES ST_WITHIN
tiler	advanced	CREATE_SPATIAL_INDEX_TILESET
transformations	core	ST_ANTIMERIDIANSAFEGEOM ST_BOUNDARY ST_BUFFERPOINT ST_CENTROID ST_CLOSESTPOINT ST_CONVEXHULL ST_DIFFERENCE ST_EXTERIORRING ST_IDLSAFEGEOM ST_INTERIORRINGN ST_INTERSECTION ST_SIMPLIFY ST_SIMPLIFYPRESERVETOPOLOGY ST_TRANSLATE