CARTO VL

This is a DEPRECATED VERSION of CARTO VL. You can find more information about the support and the availability of the different CARTO VL versions.

CARTO VL is a JavaScript library to create custom Location Intelligence applications over vector rendering.

This library is still under support but it will not be further developed. We don’t recommend starting new projects with it as it will eventually become deprecated. Instead, learn more about our current CARTO for deck.gl library here

carto

The CARTO VL functionality is exposed through the carto namespace including:

Current version:

Setup:

CARTO Basemaps:

Source:

Layer:

Viz:

Expressions:

Interactivity:

version

The version of CARTO VL in use as specified in package.json and the GitHub release.

off ( eventName , layerList , callback )

Remove an event handler for the given event name, layer list and callback.

Parameters
Name Description
eventName String

event

layerList carto.Layer

List of layers

callback function

Handler function to unregister

on ( eventName , layerList , callback )

Register an event handler for the given event name and for the given list of layers. Valid names are: loaded , updated .

The 'loaded' event will be fired when all the layers are loaded (and their 'loaded' events are fired).

The 'updated' event will be fired whenever one of the layers fired an 'updated' event, but throttled by requestAnimationFrame to return a maximum of one event per frame.

Parameters
Name Description
eventName String

Supported event names are 'loaded' and 'updated'

layerList carto.Layer Array

List of layers

callback

setDefaultAuth ( auth )

Set default authentication parameters: [user or username] and apiKey.

Parameters
Name Description
auth
Name Description
auth.username String

Name of the user. For backwards compatibility also auth.user is allowed

auth.apiKey String

API key used to authenticate against CARTO

setDefaultConfig ( config )

Set default configuration parameters

Parameters
Name Description
config
Name Description
config.serverURL String

Template URL of the CARTO Maps API server: https://{user}.carto.com

carto.basemaps

Use CARTO basemaps for your map visualization. Here you have more information about our basemaps .

darkmatter

Dark-Matter vector basemap

Example Use Dark-Matter vector basemap.
1
2
3
4
const map = new mapboxgl.Map({
  container: 'map',
  style: carto.basemaps.darkmatter
})
CLICK TO COPY
Example Use Dark-Matter vector basemap.
1
2
3
4
const map = new mapboxgl.Map({
  container: 'map',
  style: carto.basemaps.darkmatter
})
CLICK TO COPY

positron

Positron vector basemap

Example Use Positron vector basemap.
1
2
3
4
const map = new mapboxgl.Map({
  container: 'map',
  style: carto.basemaps.positron
})
CLICK TO COPY
Example Use Positron vector basemap.
1
2
3
4
const map = new mapboxgl.Map({
  container: 'map',
  style: carto.basemaps.positron
})
CLICK TO COPY

voyager

Voyager vector basemap

Example Use Voyager vector basemap.
1
2
3
4
const map = new mapboxgl.Map({
  container: 'map',
  style: carto.basemaps.voyager
})
CLICK TO COPY
Example Use Voyager vector basemap.
1
2
3
4
const map = new mapboxgl.Map({
  container: 'map',
  style: carto.basemaps.voyager
})
CLICK TO COPY

carto.expressions

Expressions are used to define visualizations, a visualization (viz) is a set named properties and variables and its corresponding values: expressions. A viz has the following properties:

  • color : fill color of points and polygons and color of lines

  • strokeColor : stroke/border color of points and polygons, not applicable to lines

  • width : fill diameter of points, thickness of lines, not applicable to polygons

  • strokeWidth : stroke width of points and polygons, not applicable to lines

  • filter : filter features by removing from rendering and interactivity all the features that don't pass the test.

  • symbol - show an image instead in the place of points

  • symbolPlacement - when using symbol , offset to apply to the image

  • order : - rendering order of the features, only applicable to points. See carto.expressions.asc , carto.expressions.desc and carto.expressions.noOrder

  • resolution : - resolution of the property-aggregation functions, only applicable to points. Default resolution is 1. Custom values must be greater than 0 and lower than 256. A resolution of N means points are aggregated to grid cells NxN pixels. Unlinke Torque resolution , the aggregated points are placed in the centroid of the cluster, not in the center of the grid cell.

For example the point diameter could be using the add expression:

				const viz = new carto.Viz({
  width: carto.expressions.add(5, 5)  // Equivalent to `width: 10`
});
		

You can use dataset properties inside expressions. Imagine we are representing cities in a map, we can make the point width proportional to the population using the property / prop expression.

				const viz = new carto.Viz({
  width: carto.expressions.prop('population')
});
		

Multiple expressions can be combined to form more powerful ones, for example lets divide the population between a number using the div expression to make points smaller:

				const s = carto.expressions; // We use this alias along documentation.
const viz = new carto.Viz({
  width: s.div(
    s.prop('population'),
    10000
 )
});
		

All these expressions can be used also in a String API form. This API is a more compact way to create and use expressions. It has shortcut notation to access your feature properties using the $ symbol. It also allows inline comments using the JavaScript syntax.

				const viz = new carto.Viz(`
  width: $population / 10000  // Size proportional to the population for each feature
`);
		

Although the combination of expressions is very powerful, you must be aware of the different types to produce valid combinations. For example, the previous example is valid since we assumed that 'population' is a numeric property, it won't be valid if it was a categorical property. Each expression defines some restrictions regarding their parameters, particularly, the type of their parameters.

The most important types are:

  • Number expression. Expressions that contains numbers, both integers and floating point numbers. Boolean types are emulated by this type, being 0 false, and 1 true.

  • Category expression. Expressions that contains categories. Categories can have a limited set of values, like the country or the region of a feature.

  • Color expression. Expressions that contains colors. An alpha or transparency channel is included in this type.

palettes

Color palettes.

Palettes are constants that allow to use CARTOColors and ColorBrewer palettes easily. Use them with a ramp .

The following palettes are available in the namespace carto.expressions .

				BURG, BURGYL, REDOR, ORYEL, PEACH, PINKYL, MINT, BLUGRN, DARKMINT, EMRLD, AG_GRNYL, BLUYL, TEAL, TEALGRN,
PURP, PURPOR, SUNSET, MAGENTA, SUNSETDARK, AG_SUNSET, BRWNYL, ARMYROSE, FALL, GEYSER, TEMPS, TEALROSE, TROPIC,
EARTH, ANTIQUE, BOLD, PASTEL, PRISM, SAFE, VIVID, CB_YLGN, CB_YLGNBU, CB_GNBU, CB_BUGN, CB_PUBUGN, CB_PUBU,
CB_BUPU, CB_RDPU, CB_PURD, CB_ORRD, CB_YLORRD, CB_YLORBR, CB_PURPLES, CB_BLUES, CB_GREENS, CB_ORANGES, CB_REDS,
CB_GREYS, CB_PUOR, CB_BRBG, CB_PRGN, CB_PIYG, CB_RDBU, CB_RDGY, CB_RDYLBU, CB_SPECTRAL, CB_RDYLGN, CB_ACCENT,
CB_DARK2, CB_PAIRED, CB_PASTEL1, CB_PASTEL2, CB_SET1, CB_SET2, CB_SET3
		
Example Using a color scheme.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.prop('type'), s.palettes.PRISM);
});
CLICK TO COPY
Example Using a color scheme.
1
2
3
const viz = new carto.Viz(`
  color: ramp($type, PRISM)
`);
CLICK TO COPY

ClusterTime ( property , units , timezone )

Use discretised property as aggregate dimension. This operation disables the access to the property except within clusterTime expressions with the same parameters.

Note: clusterTime can only be created with a carto.expressions.prop , as the first parameter, not other expressions.

When the units of resolution are cyclic periods such as 'dayOfWeek' (day of the week) or 'monthOfYear' (month of the year), the resulting expression takes a numeric value to represent the period, e.g. 1 for Monday or January.

When the units are not cyclic (e.g. 'week' or 'month'), the resulting expression is a TimeRange that encompass each individual calendar period, for example week 2018-W03 (third week of 2018 from 2018-01-15 to 2018-01-21) or 2018-03 (March 2018, from 2018-03-01 to 2018-04-01).

Accepted values for cyclic resolution periods are:

  • semesterOfYear (6-month term) takes values from 1 to 2

  • trimesterOfYear (4-month term) takes values from 1 to 3

  • quarterOfYear (3-month term) takes values from 1 to 4

  • monthOfYear takes values from 1 (January) to 12 (December)

  • weekOfYear follows ISO 8601 numbering taking values from 1 up to 53

  • dayOfWeek (as per ISO 8601, 1 = Monday, to 7 = Sunday

  • dayOfMonth takes values from 1 to 31

  • dayOfYear takes values from 1 to 366

  • hourOfDay takes values from 0 to 23

  • minuteOfHour takes values from 0 to 59

Accepted values for serial resolution units are:

  • year , e.g. '2017'

  • month , e.g. '2017-03'

  • day , e.g. '2017-03-01'

  • hour , e.g. '2017-03-01T13'

  • minute , e.g. '2017-03-01T13:22'

  • second , e.g. '2017-03-01T13:22:31'

  • week represented as '2018-W03' (third week of 2018:, 2018-01-15 to 2018-01-21)

  • quarter as '2018-Q2' (second quarter of 2018, i.e. 2018-04 to 2018-06)

  • semester as '2018S2' (second semester of 2018, i.e. 2018-07 to 2018-12)

  • trimester as '2018t2' (second trimester of 2018, i.e. 2018-05 to 2018-08)

  • decade as 'D201' (decade 201, i.e. 2010 to 2019)

  • century as 'C21' (21st century, ie. 2001 to 2100)

  • millennium as 'M3' (3rd millennium: 2001 to 3000)

The time zone is optional. By default UTC time will be used. It admits a fixed offset from UTC as a signed number of seconds, or IANA timezone names such as America/New_York or Europe/Madrid , which not only define a time offset, but also rules for DST (daylight savings time).

Parameters
Name Description
property Date

Column of the table to be discretised as dimension

units String

Units of resolution for the discretization

timezone String

Time zone in which the dates are discretised. UTC by default.

Returns

Dimension column; takes time range values (intervals) for serial units of resolutions and numbers for recurrent units.

TimeRange | Number
Example Use months as a dimension of the cluster aggregations as `month`.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  month: s.clusterTime(s.prop('date', 'month', 'America/New_York'))
});
CLICK TO COPY
Example Use months as a dimension of the cluster aggregations as `month`.
1
2
3
const viz = new carto.Viz(`
  month: clusterTime($date, 'month', 'America/New_York')
`);
CLICK TO COPY

TimeRangeExpr ( value )

Define a time range: an interval between two time points.

ISO-formatted strings (based on ISO 8601) are used to define ranges. Since timeRange doesn't support arbitrary intervals, but only intervals based on single units of time (e.g. a month, an hour), we don't use the general ISO interval format, but simply an abbreviated form of the date point format, so that '2018-03' represents the month of March, 2018 (i.e. the interval 2018-03-01T00:00:00/2018-04-01T00:00:00).

Parameters
Name Description
value String

abbreviated ISO-formatted interval

Returns

It retuns a TimeRange object.

TimeRange

abs ( x )

Compute the absolute value of a number x.

Parameters
Name Description
x Number

Numeric expression to compute the absolute value

Returns
Number
Example Abs.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.abs(-100)  // 100
});
CLICK TO COPY
Example Abs.
1
2
3
const viz = new carto.Viz(`
  width: abs(-100) // 100
`);
CLICK TO COPY

add ( x , y )

Add two numeric expressions.

Parameters
Name Description
x Number | Color

First value to add

y Number | Color

Second value to add

Returns

Result of the addition

Number | Color
Example Number addition.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.add(10, 2)  // 12
});
CLICK TO COPY
Example Number addition.
1
2
3
const viz = new carto.Viz(`
  width: 10 + 2  // Equivalent to add(10, 2)
`);
CLICK TO COPY

alphaNormalize ( input , normalizer )

Override the opacity (alpha channel) of a color to normalize the input color by a normalizer property.

This is implemented as `opacity(input, normalizer/globalMax(normalizer))

Parameters
Name Description
input Color

input color to normalize

normalizer Number

numeric property that will be used to normalize the input color

Returns
Color
Example Normalize an input property ($winner_party) by a second property ($voters).
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.alphaNormalize(
             s.ramp(s.prop('winner_party'), [red, blue]),
             s.prop('voters')
         )
});
CLICK TO COPY
Example Normalize an input property ($winner_party) by a second property ($voters).
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  color: alphaNormalize(
             ramp($winner_party, [red, blue]),
             $voters
         )
});
CLICK TO COPY

and ( x , y )

Perform a binary AND between two numeric expressions. If the numbers are different from 0 or 1 this performs a fuzzy and operation . This fuzzy behavior will allow transitions to work in a continuos, non-discrete, fashion.

This returns a number expression where 0 means false and 1 means true .

Parameters
Name Description
x Number

First value of the expression

y Number

Second value of the expression

Returns

Result of the expression

Number
Example Show only elements with price < 30 AND category === 'fruit'.
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.and(
    s.lt(s.prop('price'), 30),
    s.eq(s.prop('category'), 'fruit')
  )
});
CLICK TO COPY
Example Show only elements with price < 30 AND category === 'fruit'.
1
2
3
const viz = new carto.Viz(`
  filter: $price < 30 and $category === 'fruit'  // Equivalent to and(lt($price, 30), eq($category, 'fruit'))
`);
CLICK TO COPY

animation ( input , duration , fade )

Create an animated temporal filter (animation). Read more about the Animation Class

Parameters
Name Description
input Number

input to base the temporal filter, if input is a property, the beginning and end of the animation will be determined by the minimum and maximum timestamps of the property on the dataset, this can be problematic if outliers are present. Otherwise input must be a number expression in which 0 means beginning of the animation and 1 means end. If input is NULL or NaN the filter won't be passed at any moment of the animation.

It can be combined with linear and time expressions.

duration Number

duration of the animation in seconds, optional, defaults to 10 seconds

fade Fade

fadeIn/fadeOut configuration, optional, defaults to 0.15 seconds of fadeIn and 0.15 seconds of fadeOut

Returns
Number
Example Temporal map by $day (of numeric type), with a duration of 40 seconds, fadeIn of 0.1 seconds and fadeOut of 0.3 seconds.
1
2
3
4
5
6
const s = carto.expressions;
const viz = new carto.Viz({
  width: 2,
  color: s.ramp(s.linear(s.clusterAvg(s.prop('temp'), 0, 30)), s.palettes.TEALROSE),
  filter: s.animation(s.prop('day'), 40, s.fade(0.1, 0.3))
});
CLICK TO COPY
Example Temporal map by $day (of numeric type), with a duration of 40 seconds, fadeIn of 0.1 seconds and fadeOut of 0.3 seconds.
1
2
3
4
5
const viz = new carto.Viz(`
  width: 2
  color: ramp(linear(clusterAvg($temp), 0,30), tealrose)
  filter: animation($day, 40, fade(0.1, 0.3))
`);
CLICK TO COPY
Example Temporal map by $date (of date type), with a duration of 40 seconds, fadeIn of 0.1 seconds and fadeOut of 0.3 seconds.
1
2
3
4
5
const viz = new carto.Viz({
  width: 2,
  color: s.ramp(s.linear(s.clusterAvg(s.prop('temp'), 0, 30)), s.palettes.TEALROSE),
  filter: s.animation(s.linear(s.prop('date'), s.time('2022-03-09T00:00:00Z'), s.time('2033-08-12T00:00:00Z')), 40, s.fade(0.1, 0.3))
});
CLICK TO COPY
Example Temporal map by $date (of date type), with a duration of 40 seconds, fadeIn of 0.1 seconds and fadeOut of 0.3 seconds.
1
2
3
4
5
6
7
8
const viz = new carto.Viz(`
  width: 2
  color: ramp(linear(clusterAvg($temp), 0,30), tealrose)
  filter: animation(linear($date, time('2022-03-09T00:00:00Z'), time('2033-08-12T00:00:00Z')), 40, fade(0.1, 0.3))
`);
Animation class

This class is instanced automatically by using the `animation` function. It is documented for its methods.
CLICK TO COPY

asc ( by )

Order ascending by a provided expression. NOTE: only works with width() .

Note: ordering expressions won't assure a perfect ordering. Features will be distributed in different buckets with the original order, and those buckets will be ordered. This guarantees a maximum error, but not a perfect order. For most operations this is imperceptible, but usage of order in combination with animation or multi-scale expressions ( zoomrange and scaled ) may result in artifacts.

Parameters
Name Description
by carto.expressions.Width

must be width()

Returns
Order
Example Ascending order based on width.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  order: s.asc(s.width())
});
CLICK TO COPY
Example Ascending order based on width.
1
2
3
const viz = new carto.Viz(`
  order: asc(width())
`);
CLICK TO COPY

between ( input , lowerLimit , upperLimit )

Check if a given value is contained within an inclusive range (including the limits).

This returns a numeric expression where 0 means false and 1 means true .

Parameters
Name Description
input Number

Numeric expression that is going to be tested against the [lowerLimit, upperLimit] range

lowerLimit Number

Numeric expression with the lower limit of the range

upperLimit Number

Numeric expression with the upper limit of the range

Returns

Numeric expression with the result of the check

Number
Example Display only cities where the population density is within the [50,100] range.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.between(s.prop('dn'), 50, 100);
});
CLICK TO COPY
Example Display only cities where the population density is within the [50,100] range.
1
2
3
const viz = new carto.Viz(`
  filter: between($dn, 50, 100)
`);
CLICK TO COPY

blend ( a , b , mix )

Linearly interpolate from a to b based on mix .

Parameters
Name Description
a Number | Color

Numeric or color expression, a type must match b type

b Number | Color

Numeric or color expression, b type must match a type

mix Number

Numeric expression with the interpolation parameter in the [0,1] range

Returns

Numeric or color expression with the same type as a and b

Number | Color
Example Blend based on the zoom level to display a bubble map at high zoom levels and display fixed-sized points at low zoom levels.
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.blend(3,
                 s.prop('dn'),
                 s.linear(s.zoom(), 10, 14))
          );
});
CLICK TO COPY
Example Blend based on the zoom level to display a bubble map at high zoom levels and display fixed-sized points at low zoom levels.
1
2
3
4
5
6
const viz = new carto.Viz(`
  width: blend(3,
               $dn,
               linear(zoom(), 10, 14)
         )
`);
CLICK TO COPY

buckets ( property , breakpoints )

Given a property create "sub-groups" based on the given breakpoints.

This returns a number or category expression depending on the input values.

Parameters
Name Description
property Number | Category

The property to be evaluated and interpolated

breakpoints Number Array | Category Array

Expression containing the different breakpoints.

Returns
Number | Category
Example Display a traffic dataset in 4 colors depending on the numeric speed.
1
2
3
4
5
6
7
8
9
10
11
12
13
// Using the buckets `expression` we divide the dataset into 4 buckets according to the speed
// - From -inf to 29
// - From 30 to 79
// - From 80 to 119
// - From 120 to +inf
// Values lower than 0 will be in the first bucket and values higher than 120 will be in the last one.
const s = carto.expressions;
const viz = new carto.Viz({
   color: s.ramp(
     s.buckets(s.prop('speed'), [30, 80, 120]),
     s.palettes.PRISM
   )
});
CLICK TO COPY
Example Display a traffic dataset in 4 colors depending on the numeric speed.
1
2
3
4
5
6
7
8
9
// Using the buckets `expression` we divide the dataset into 4 buckets according to the speed
// - From -inf to 29
// - From 30 to 79
// - From 80 to 119
// - From 120 to +inf
// Values lower than 0 will be in the first bucket and values higher than 120 will be in the last one.
const viz = new carto.Viz(`
   color: ramp(buckets($speed, [30, 80, 120]), PRISM)
`);
CLICK TO COPY
Example Display a traffic dataset is 3 colors depending on the category procesedSpeed.
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(
    s.buckets(s.prop('procesedSpeed'), ['slow', 'medium', 'high']),
    s.palettes.PRISM)
  )
});
CLICK TO COPY
Example Display a traffic dataset is 3 colors depending on the category procesedSpeed.
1
2
3
const viz = new carto.Viz(`
   color: ramp(buckets($procesedSpeed, ['slow', 'medium', 'high']), PRISM)
`);
CLICK TO COPY

categoryIndex ( property )

Transform a categorical property into a per-property category index. The evaluated result returns a value between 0 and 1. The dataset must contain less than 65536 (256 * 256) different categories.

Parameters
Name Description
property Category

The property to be evaluated, must be categorical

Returns
Category
Example Color by $city using the CARTOColor Prism by assigning different color in Prism to each category.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.categoryIndex(s.prop('city')), s.palettes.PRISM)
});
CLICK TO COPY
Example Color by $city using the CARTOColor Prism by assigning different color in Prism to each category.
1
2
3
const viz = new carto.Viz(`
  color: ramp(categoryIndex($city), PRISM)
`);
CLICK TO COPY

ceil ( x )

Compute the ceil of the given expression. Find the nearest integer that is greater than or equal to the expression value.

  • When x is equal to 0.8 ceil(x) will be evaluated to 1

  • When x is equal to 1.3 ceil(x) will be evaluated to 2

Parameters
Name Description
x Number

Number to compute the ceil value

Returns
Number
Example Ceil.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.ceil(5.1);  // 6
});
CLICK TO COPY
Example Ceil.
1
2
3
const viz = new carto.Viz(`
  width: ceil(5.1)
`);
CLICK TO COPY

cielab ( l , a , b )

Evaluates to a CIELab color.

Parameters
Name Description
l Number

The lightness of the color

a Number

The green–red color component

b Number

The blue–yellow color component

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.cielab(32.3, 79.2, -107.86)
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: cielab(32.3, 79.2, -107.86)
`);
CLICK TO COPY

clusterAvg ( property )

Aggregate using the average. This operation disables the access to the property except within other cluster aggregate functions.

Note: clusterAvg can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number

Column of the table to be aggregated

Returns

Aggregated column

Number
Example Use cluster average of the population as width.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.clusterAvg(s.prop('population'))
});
CLICK TO COPY
Example Use cluster average of the population as width.
1
2
3
const viz = new carto.Viz(`
  width: clusterAvg($population)
`);
CLICK TO COPY

clusterCount

Count of features per cluster.

Note: clusterCount has no input parameters and if data is not aggregated, it always returns 1

Returns

Cluster feature count

Number
Example Use cluster count for width.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.clusterCount() / 50
});
CLICK TO COPY
Example Use cluster count for width.
1
2
3
const viz = new carto.Viz(`
  width: clusterCount() / 50
`);
CLICK TO COPY

clusterMax ( property )

Aggregate using the maximum. This operation disables the access to the property except within other cluster aggregate functions.

Note: clusterMax can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number

Column of the table to be aggregated

Returns

Aggregated column

Number
Example Use cluster maximum of the population as width.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.clusterMax(s.prop('population'))
});
CLICK TO COPY
Example Use cluster maximum of the population as width.
1
2
3
const viz = new carto.Viz(`
  width: clusterMax($population)
`);
CLICK TO COPY

clusterMin ( property )

Aggregate using the minimum. This operation disables the access to the property except within other cluster aggregate functions.

Note: clusterMin can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number

Column of the table to be aggregated

Returns

Aggregated column

Number
Example Use cluster minimum of the population as width.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.clusterMin(s.prop('population'))
});
CLICK TO COPY
Example Use cluster minimum of the population as width.
1
2
3
const viz = new carto.Viz(`
  width: clusterMin($population)
`);
CLICK TO COPY

clusterMode ( property )

Aggregate using the mode. This operation disables the access to the property except within other cluster aggregate functions.

Note: clusterMode can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Category

Column of the table to be aggregated

Returns

Aggregated column

Category
Example Use cluster mode of the population in a color ramp.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.clusterMode(s.prop('category')), s.palettes.PRISM)
});
CLICK TO COPY
Example Use cluster mode of the population in a color ramp.
1
2
3
const viz = new carto.Viz(`
  color: ramp(clusterMode($category), PRISM)
`);
CLICK TO COPY

clusterSum ( property )

Aggregate using the sum. This operation disables the access to the property except within other cluster aggregate functions.

Note: clusterSum can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number

Column of the table to be aggregated

Returns

Aggregated column

Number
Example Use cluster sum of the population as width.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.clusterSum(s.prop('population'))
});
CLICK TO COPY
Example Use cluster sum of the population as width.
1
2
3
const viz = new carto.Viz(`
  width: clusterSum($population)
`);
CLICK TO COPY

constant ( x )

Wraps a constant number. Implies a GPU optimization vs number expression .

Parameters
Name Description
x number

A number to be warped in a constant numeric expression

Returns

Numeric expression

Number
Example Creating a constant number expression.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.constant(15)
});
CLICK TO COPY
Example Creating a constant number expression.
1
2
3
const viz = new carto.Viz(`
  width: constant(15)
`);
CLICK TO COPY

cos ( x )

Compute the cosine of a number x.

Parameters
Name Description
x Number

Numeric expression to compute the cosine in radians

Returns
Number
Example Cos.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.cos(0)  // 1
});
CLICK TO COPY
Example Cos.
1
2
3
const viz = new carto.Viz(`
  width: cos(0)
`);
CLICK TO COPY

desc ( by )

Order descending by a provided expression. NOTE: only works with width() .

Note: ordering expressions won't assure a perfect ordering. Features will be distributed in different buckets with the original order, and those buckets will be ordered. This guarantees a maximum error, but not a perfect order. For most operations this is imperceptible, but usage of order in combination with animation or multi-scale expressions ( zoomrange and scaled ) may result in artifacts.

Parameters
Name Description
by carto.expressions.Width

must be width()

Returns
Order
Example Descending order based on width.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  order: s.desc(s.width())
});
CLICK TO COPY
Example Descending order based on width.
1
2
3
const viz = new carto.Viz(`
  order: desc(width())
`);
CLICK TO COPY

div ( numerator , denominator )

Divide two numeric expressions.

Parameters
Name Description
numerator Number | Color

Numerator of the division

denominator Number | Color

Denominator of the division

Returns

Result of the division

Number | Color
Example Number division.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.div(10, 2)  // 5
});
CLICK TO COPY
Example Number division.
1
2
3
const viz = new carto.Viz(`
  width: 10 / 2  // Equivalent to div(10, 2)
`);
CLICK TO COPY

eq ( x , y )

Compare if x is equal to a y.

This returns a numeric expression where 0 means false and 1 means true .

Parameters
Name Description
x Number | Category

Firt value of the comparison

y Number | Category

Second value of the comparison

Returns

Result of the comparison: 0 or 1

Number
Example Compare two numbers to show only elements with price equal to 30.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.eq(s.prop('price'), 30)
});
CLICK TO COPY
Example Compare two numbers to show only elements with price equal to 30.
1
2
3
const viz = new carto.Viz(`
  filter: $price == 30  // Equivalent to eq($price, 30)
`);
CLICK TO COPY

fade ( param1 , param2 )

Create a FadeIn/FadeOut configuration. See animation for more details.

Parameters
Name Description
param1 Number

Expression of type number or Number

param2 Number

Expression of type number or Number

Returns
Fade
Example Fade in of 0.1 seconds, fade out of 0.3 seconds.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.animation(s.prop('day'), 40, s.fade(0.1, 0.3))
});
CLICK TO COPY
Example Fade in of 0.1 seconds, fade out of 0.3 seconds.
1
2
3
const viz = new carto.Viz(`
  filter: animation($day, 40, fade(0.1, 0.3))
`);
CLICK TO COPY
Example Fade in and fade out of 0.5 seconds.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.animation(s.prop('day'), 40, s.fade(0.5))
});
CLICK TO COPY
Example Fade in and fade out of 0.5 seconds.
1
2
3
const viz = new carto.Viz(`
  filter: animation($day, 40, fade(0.5))
`);
CLICK TO COPY
Example Fade in of 0.3 seconds without fading out.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.animation(s.prop('day'), 40, s.fade(0.1, s.HOLD))
});
CLICK TO COPY
Example Fade in of 0.3 seconds without fading out.
1
2
3
const viz = new carto.Viz(`
  filter: animation($day, 40, fade(0.3, HOLD))
`);
CLICK TO COPY

floor ( x )

Compute the floor of the given expression. Find the nearest integer less than or equal to the expression value.

  • When x is equal to 0.8 floor(x) will be evaluated to 0

  • When x is equal to 1.3 floor(x) will be evaluated to 1

Parameters
Name Description
x Number

Number to compute the floor value

Returns
Number
Example Floor.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.floor(5.9)  // 5
});
CLICK TO COPY
Example Floor.
1
2
3
const viz = new carto.Viz(`
  width: floor(5.9)
`);
CLICK TO COPY

globalAvg ( property )

Return the average of the feature property for the entire source data.

Note: globalAvg can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number

property expression of number type

Returns

Result of the aggregation

Number
Example Assign the global average of the `amount` property to a variable.
1
2
3
4
5
6
const s = carto.expressions;
const viz = new carto.Viz({
  variables: {
     g_avg: s.globalAvg(s.prop('amount'))
  }
});
CLICK TO COPY
Example Assign the global average of the `amount` property to a variable.
1
2
3
const viz = new carto.Viz(`
  @g_avg: globalAvg($amount)
`);
CLICK TO COPY

globalCount

Return the feature count for the entire source data.

Returns

feature count

Number
Example Assign the global count of features to a variable.
1
2
3
4
5
6
const s = carto.expressions;
const viz = new carto.Viz({
  variables: {
     g_count: s.globalCount()
  }
});
CLICK TO COPY
No String example available
Example Assign the global count of features.
1
2
3
const viz = new carto.Viz(`
  @g_count: globalCount()
`);
CLICK TO COPY

globalEqIntervals ( input , n )

Classify input by using the equal intervals method with n buckets.

It will classify the input based on the entire dataset without filtering by viewport or by filter .

Parameters
Name Description
input Number

The input expression to classify

n number

Number of buckets

Returns
Category
Example Use global equal intervals to define a color ramp.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.globalEqIntervals(s.prop('density'), 5), s.palettes.PRISM)
});
CLICK TO COPY
Example Use global equal intervals to define a color ramp.
1
2
3
const viz = new carto.Viz(`
  color: ramp(globalEqIntervals($density, 5), PRISM)
`);
CLICK TO COPY

globalMax ( property )

Return the maximum of the feature property for the entire source data.

Note: globalMax can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number | Date

property expression of date or number type

Returns

Result of the aggregation

Number | Date
Example Assign the global maximum of the `amount` property to a variable.
1
2
3
4
5
6
const s = carto.expressions;
const viz = new carto.Viz({
  variables: {
     g_max: s.globalMax(s.prop('amount'))
  }
});
CLICK TO COPY
Example Assign the global maximum of the `amount` property to a variable.
1
2
3
const viz = new carto.Viz(`
  @g_max: globalMax($amount)
`);
CLICK TO COPY

globalMin ( property )

Return the minimum of the feature property for the entire source data.

Note: globalMin can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number | Date

property expression of date or number type

Returns

Result of the aggregation

Number | Date
Example Assign the global minimum of the `amount` property to a variable.
1
2
3
4
5
6
const s = carto.expressions;
const viz = new carto.Viz({
  variables: {
     g_min: s.globalMin(s.prop('amount'))
  }
});
CLICK TO COPY
Example Assign the global minimum of the `amount` property to a variable.
1
2
3
const viz = new carto.Viz(`
  @g_min: globalMin($amount)
`);
CLICK TO COPY

globalPercentile ( property , percentile )

Return the Nth percentile of an numeric property for the entire source data.

Parameters
Name Description
property Number

numeric property

percentile Number

Numeric expression in the [0, 100] range, must be feature independent

Returns

Result of the aggregation

Number
Example Assign the 90th percentile of the `amount` property for the entire dataset to a variable.
1
2
3
4
5
6
const s = carto.expressions;
const viz = new carto.Viz({
  variables: {
     v_percentile: s.globalPercentile(s.prop('amount'), 90)
  }
});
CLICK TO COPY
Example Assign the 90th percentile of the `amount` property for the entire dataset to a variable.
1
2
3
const viz = new carto.Viz(`
  @v_percentile: globalPercentile($amount, 90)
`);
CLICK TO COPY

globalQuantiles ( input , n )

Classify input by using the quantiles method with n buckets.

It will classify the input based on the entire dataset without filtering by viewport or by filter .

Parameters
Name Description
input Number

The input expression used in the quantiles

n number

Number of buckets to be returned

Returns
Category
Example Use global quantiles to define a color ramp.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.globalQuantiles(s.prop('density'), 5), s.palettes.CB_REDS)
});
CLICK TO COPY
Example Use global quantiles to define a color ramp.
1
2
3
const viz = new carto.Viz(`
  color: ramp(globalQuantiles($density, 5), CB_REDS)
`);
CLICK TO COPY

globalStandardDev ( input , n , classSize )

Classify input by using the Mean-Standard Deviation method with n buckets.

It will classify the input based on the entire dataset without filtering by viewport or by filter .

It uses average and standard deviation (population formula) to classify the dataset. When using an odd number of buckets, the central class has a double size (classSize * 2), to honour the number of required buckets

This method is suitable if data are normally (or near normal) distributed, and it is specially appropiated for diverging datasets, which can be well displayed using a diverging color scheme like TEALROSE

Parameters
Name Description
input Number

The input expression to classify

n number

Number of buckets

classSize

Optional. The class size, defaults to 1.0 standard deviation (usual values are also 0.5 or 0.25)

Returns
Category
Example Use global mean-standard deviation to define a color ramp.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.globalStandardDev(s.prop('density'), 5), s.palettes.TEALROSE)
});
CLICK TO COPY
Example Use global mean-standard deviation to define a color ramp.
1
2
3
const viz = new carto.Viz(`
  color: ramp(globalStandardDev($density, 5), TEALROSE)
`);
CLICK TO COPY
Example Use global custom mean-standard deviation to define a color ramp.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.globalStandardDev(s.prop('density'), 7, 0.5), s.palettes.TEALROSE)
});
CLICK TO COPY
Example Use global custom mean-standard deviation to define a color ramp.
1
2
3
const viz = new carto.Viz(`
  color: ramp(globalStandardDev($density, 7, 0.5), TEALROSE)
`);
CLICK TO COPY

globalSum ( property )

Return the sum of the feature property for the entire source data.

Note: globalSum can only be created by carto.expressions.prop , not other expressions.

Parameters
Name Description
property Number

property expression of number type

Returns

Result of the aggregation

Number
Example Assign the global sum of the `amount` property to a variable.
1
2
3
4
5
6
const s = carto.expressions;
const viz = new carto.Viz({
  variables: {
     g_sum: s.globalSum(s.prop('amount'))
  }
});
CLICK TO COPY
Example Assign the global sum of the `amount` property to a variable.
1
2
3
const viz = new carto.Viz(`
  @g_sum: globalSum($amount)
`);
CLICK TO COPY

gt ( x , y )

Compare if x is greater than y.

This returns a numeric expression where 0 means false and 1 means true .

Parameters
Name Description
x Number

Firt value of the comparison

y Number

Firt value of the comparison

Returns

Result of the comparison: 0 or 1

Number
Example Compare two numbers to show only elements with price greater than 30.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.gt(s.prop('price'), 30)
});
CLICK TO COPY
Example Compare two numbers to show only elements with price greater than 30.
1
2
3
const viz = new carto.Viz(`
  filter: $price > 30  // Equivalent to gt($price, 30)
`);
CLICK TO COPY

gte ( x , y )

Compare if x is greater than or equal to y.

This returns a numeric expression where 0 means false and 1 means true .

Parameters
Name Description
x Number

Firt value of the comparison

y Number

Second value of the comparison

Returns

Result of the comparison: 0 or 1

Number
Example Compare two numbers to show only elements with price greater than or equal to 30.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.gte(s.prop('price'), 30)
});
CLICK TO COPY
Example Compare two numbers to show only elements with price greater than or equal to 30.
1
2
3
const viz = new carto.Viz(`
  filter: $price >= 30  // Equivalent to gte($price, 30)
`);
CLICK TO COPY

hex ( hexadecimalColor )

Create a color from its hexadecimal description.

Parameters
Name Description
hexadecimalColor String

Color in the #RGB, #RGBA, #RRGGBB or #RRGGBBAA format

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.hex('#00F');  // Equivalent to `color: '#00F'`
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: #00F  // Equivalent to hex('#00F')
`);
CLICK TO COPY

hsl ( h , s , l )

Evaluates to a hsl color.

Parameters
Name Description
h Number

hue of the color in the [0, 1] range

s Number

saturation of the color in the [0, 1] range

l Number

lightness of the color in the [0, 1] range

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.hsl(0.67, 1.0, 0.5)
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: hsl(0.67, 1.0, 0.5)
`);
CLICK TO COPY

hsla ( h , s , l , a )

Evaluates to a hsla color.

Parameters
Name Description
h Number

hue of the color in the [0, 1] range

s Number

saturation of the color in the [0, 1] range

l Number

lightness of the color in the [0, 1] range

a Number

alpha value of the color in the [0, 1] range

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.hsla(0.67, 1.0, 0.5, 1.0)
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: hsla(0.67, 1.0, 0.5, 1.0)
`);
CLICK TO COPY

hsv ( h , s , v )

Evaluates to a hsv color.

Parameters
Name Description
h Number

hue of the color in the [0, 1] range

s Number

saturation of the color in the [0, 1] range

v Number

value (brightness) of the color in the [0, 1] range

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.hsv(0.67, 1.0, 1.0)
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: hsv(0.67, 1.0, 1.0)
`);
CLICK TO COPY

hsva ( h , s , v , a )

Evaluates to a hsva color.

Parameters
Name Description
h Number

hue of the color in the [0, 1] range

s Number

saturation of the color in the [0, 1] range

v Number

value (brightness) of the color in the [0, 1] range

a Number

alpha value of the color in the [0, 1] range

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.hsva(0.67, 1.0, 1.0, 1.0)
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: hsva(0.67, 1.0, 1.0, 1.0)
`);
CLICK TO COPY

image ( url )

Image. Load an image and use it as a symbol.

Note: image RGB color will be overridden if the viz color property is set.

Parameters
Name Description
url String

Image path

Example Load a svg image.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  symbol: s.image('./marker.svg')
});
CLICK TO COPY
Example Load a svg image.
1
2
3
const viz = new carto.Viz(`
   symbol: image('./marker.svg')
`);
CLICK TO COPY

in ( input , list )

Check if a categorical value belongs to a list of categories.

Parameters
Name Description
input Category

Categorical expression to be tested against the whitelist

list Category Array

Multiple expression parameters that will form the whitelist

Returns

Numeric expression with the result of the check

Number
Example Display only cities where $type is 'metropolis' or 'capital'.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.in(s.prop('type'), ['metropolis', 'capital'])
});
CLICK TO COPY
Example Display only cities where $type is 'metropolis' or 'capital'.
1
2
3
const viz = new carto.Viz(`
  filter: $type in ['metropolis', 'capital']
`);
CLICK TO COPY

isNull ( x )

Check if a numerical or categorical property is missing (NULL value).

This returns a numeric expression where 0 means false and 1 means true .

Parameters
Name Description
x Number

Numeric expression to check

Returns
Number
Example Filter NULL values of the `numeric` property.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.not(s.isNull(s.prop('numeric')))
});
CLICK TO COPY
Example Filter NULL values of the `numeric` property.
1
2
3
const viz = new carto.Viz(`
  filter: not(isNull($numeric))
`);
CLICK TO COPY

linear ( input , min , max )

Linearly interpolates the value of a given input between a minimum and a maximum. If min and max are not defined they will default to globalMin(input) and globalMax(input) .

Parameters
Name Description
input Number | Date

The input to be evaluated and interpolated, can be a numeric property or a date property

min Number | Date

Numeric or date expression pointing to the lower limit

max Number | Date

Numeric or date expression pointing to the higher limit

Returns
Number | Date
Example Color by $speed using the CARTOColor Prism by assigning the first color in Prism to features with speeds of 10 or less, the last color in Prism to features with speeds of 100 or more and a interpolated value for the speeds in between.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.linear(s.prop('speed'), 10, 100), s.palettes.PRISM)
});
CLICK TO COPY
Example Color by $speed using the CARTOColor Prism by assigning the first color in Prism to features with speeds of 10 or less, the last color in Prism to features with speeds of 100 or more and a interpolated value for the speeds in between.
1
2
3
const viz = new carto.Viz(`
  color: ramp(linear($speed, 10, 100), PRISM)
`);
CLICK TO COPY

list ( elements )

Wrapper around arrays. Explicit usage is unnecessary since CARTO VL will wrap implicitly all arrays using this function.

When used with Transformation expressions, the returned value will be a Transformation that will chain each single transformation one after another.

Parameters
Name Description
elements Number Array | Category Array | Color Array | Date Array | Image Array | Transform Array
Returns
List | Transform
Example Rotate then translate.
1
2
3
4
5
const s = carto.expressions;
const viz = new carto.Viz({
  symbol: s.CROSS
  transform: [s.rotate(90), s.translate(10, 20)]
});
CLICK TO COPY
Example Rotate then translate.
1
2
3
4
const viz = new carto.Viz(`
  symbol: cross
  transform: [rotate(90), translate(10, 20)]
`);
CLICK TO COPY

log ( x )

Compute the natural logarithm (base e) of a number x.

Parameters
Name Description
x Number

Numeric expression to compute the natural logarithm

Returns
Number
Example Natural Logarithm.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.log(10)  // 2.302585092994046
});
CLICK TO COPY
Example Natural Logarithm.
1
2
3
const viz = new carto.Viz(`
  width: log(10)
`);
CLICK TO COPY

lt ( x , y )

Compare if x is lower than y.

This returns a numeric expression where 0 means false and 1 means true .

Parameters
Name Description
x Number

Firt value of the comparison

y Number

Second value of the comparison

Returns

Result of the comparison: 0 or 1

Number
Example Compare two numbers to show only elements with price less than 30.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.lt(s.prop('price'), 30)
});
CLICK TO COPY
Example Compare two numbers to show only elements with price less than 30.
1
2
3
const viz = new carto.Viz(`
  filter: $price < 30  // Equivalent to lt($price, 30)
`);
CLICK TO COPY

lte ( x , y )

Compare if x is lower than or equal to y.

This returns a numeric expression where 0 means false and 1 means true .

Parameters
Name Description
x Number

Firt value of the comparison

y Number

Second value of the comparison

Returns

Result of the comparison: 0 or 1

Number
Example Compare two numbers to show only elements with price less than or equal to 30.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.lte(s.prop('price'), 30)
});
CLICK TO COPY
Example Compare two numbers to show only elements with price less than or equal to 30.
1
2
3
const viz = new carto.Viz(`
  filter: $price <= 30  // Equivalent to lte($price, 30)
`);
CLICK TO COPY

mod ( x , y )

Modulus of two numeric expressions, mod returns a numeric expression with the value of x modulo y. This is computed as x - y * floor(x/y).

Parameters
Name Description
x Number

First value of the modulus

y Number

Second value of the modulus

Returns

Result of the modulus

Number
Example Number modulus.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.mod(10, 6)  // 4
});
CLICK TO COPY
Example Number modulus.
1
2
3
const viz = new carto.Viz(`
  width: 10 % 6  // Equivalent to mod(10, 6)
`);
CLICK TO COPY

mul ( x , y )

Multiply two numeric expressions.

Parameters
Name Description
x Number | Color

First value to multiply

y Number | Color

Second value to multiply

Returns

Result of the multiplication

Number | Color
Example Number multiplication.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.mul(5, 5)  // 25
});
CLICK TO COPY
Example Number multiplication.
1
2
3
const viz = new carto.Viz(`
  width: 5 * 5  // Equivalent to mul(5, 5)
`);
CLICK TO COPY

namedColor ( name )

Create a color from its name.

Parameters
Name Description
name String

The name of the color

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.namedColor('blue')  // Equivalent to `color: 'blue'`
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: blue  // Equivalent to namedColor('blue')
`);
CLICK TO COPY

neq ( x , y )

Compare if x is different than y.

This returns a number expression where 0 means false and 1 means true .

Parameters
Name Description
x Number | Category

Firt value of the comparison

y Number | Category

Second value of the comparison

Returns

Result of the comparison: 0 or 1

Number
Example Compare two numbers to show only elements with price not equal to 30.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.neq(s.prop('price'), 30);
});
CLICK TO COPY
Example Compare two numbers to show only elements with price not equal to 30.
1
2
3
const viz = new carto.Viz(`
  filter: $price != 30  // Equivalent to neq($price, 30)
`);
CLICK TO COPY

nin ( input , list )

Check if value does not belong to the list of elements.

Parameters
Name Description
input Category

Categorical expression to be tested against the blacklist

list Category Array

Multiple expression parameters that will form the blacklist

Returns

Numeric expression with the result of the check

Number
Example Display only cities where $type is not 'metropolis' or 'capital'.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.nin(s.prop('type'), ['metropolis', 'capital'])
});
CLICK TO COPY
Example Display only cities where $type is not 'metropolis' or 'capital'.
1
2
3
const viz = new carto.Viz(`
  filter: $type nin ['metropolis', 'capital']
`);
CLICK TO COPY

noOrder

No order expression.

Returns
Order
Example No order.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  order: s.noOrder()
});
CLICK TO COPY
Example No order.
1
2
3
const viz = new carto.Viz(`
  order: noOrder()
`);
CLICK TO COPY

not ( x )

Compute the logical negation of the given expression. This is internally computed as 1 - x preserving boolean behavior and allowing fuzzy logic.

  • When x is equal to 1 not(x) will be evaluated to 0

  • When x is equal to 0 not(x) will be evaluated to 1

Parameters
Name Description
x Number

Number to compute the not value

Returns
Number
Example Not.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.not(0)  // 1
});
CLICK TO COPY
Example Not.
1
2
3
const viz = new carto.Viz(`
  width: not(0)
`);
CLICK TO COPY

now

Get the current timestamp. This is an advanced form of animation, animation expression is preferred.

Returns
Number
Example Update width during the time.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.mod(s.now(), 10)
});
CLICK TO COPY
Example Update width during the time.
1
2
3
const viz = new carto.Viz(`
  width: now() % 10
`);
CLICK TO COPY

opacity ( color , alpha )

Override the input opacity.

Parameters
Name Description
color Color | Image

Color or image expression to apply the opacity

alpha Number

Number expression with the alpha (transparency) value

Returns
Color | Image
Example Display blue points with 50% opacity.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.opacity(s.rgb(0,0,255), 0.5)  // Equivalent to `s.rgba(0,0,255,0.5)`
});
CLICK TO COPY
Example Display blue points with 50% opacity.
1
2
3
const viz = new carto.Viz(`
  color: opacity(rgb(0,0,255), 0.5) // Equivalent to `rgba(0,0,255,0.5)`
`);
CLICK TO COPY

or ( x , y )

Perform a binary OR between two numeric expressions. If the numbers are different from 0 or 1 this performs a fuzzy or operation . This fuzzy behavior will allow transitions to work in a continuos, non-discrete, fashion.

This returns a number expression where 0 means false and 1 means true .

Parameters
Name Description
x Number

First value of the expression

y Number

Second value of the expression

Returns

Result of the expression

Number
Example Show only elements with price < 30 OR price > 1000.
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.or(
    s.lt(s.prop('price'), 30),
    s.gt(s.prop('price'), 1000)
  )
});
CLICK TO COPY
Example Show only elements with price < 30 OR price > 1000.
1
2
3
const viz = new carto.Viz(`
  filter: $price < 30 or $price > 1000  // Equivalent to or(lt($price, 30), gt($price, 1000))
`);
CLICK TO COPY

placement ( x , y )

Placement. Define an image offset relative to its size. Where:

  • symbolPlacement: placement(1,1) means to align the bottom left corner of the image with the point center.

  • symbolPlacement: placement(0,0) means to align the center of the image with the point center.

  • symbolPlacement: placement(-1,-1) means to align the top right corner of the image with the point center.

				          |1
          |
          |
-1 -------+------- 1
          |
          |
        -1|
		

You can also use align_center and align_bottom to set the simbol placement as follows:

  • symbolPlacement: align_bottom is equivalent to symbolPlacement: placement(0, 1)

  • symbolPlacement: align_center is equivalent to symbolPlacement: placement(0, 0)

Parameters
Name Description
x number

first numeric expression that indicates the image offset in the X direction.

y number

second numeric expression that indicates the image offset in the Y direction.

Returns

Numeric expression

Placement
Example Setting the aligment to the top corner of the image.
1
2
3
4
5
const s = carto.expressions;
const viz = new carto.Viz({
  symbol: s.image('./marker.svg').
  symbolPlacement: s.placement(1, 0)
});
CLICK TO COPY
Example Setting the aligment to the top corner of the image.
1
2
3
4
const viz = new carto.Viz(`
  symbol: image('./marker.svg')
  symbolPlacement: placement(1, 0)
`);
CLICK TO COPY

pow ( base , exponent )

Compute the base to the exponent power, return a numeric expression with the value of the first parameter raised to the power of the second. The result is undefined if x<0 or if x=0 and y≤0.

Parameters
Name Description
base Number

Base of the power

exponent Number

Exponent of the power

Returns

Result of the power

Number
Example Number power.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.pow(2, 3)  // 8
});
CLICK TO COPY
Example Number power.
1
2
3
const viz = new carto.Viz(`
  width: 2 ^ 3  // Equivalent to pow(2, 3)
`);
CLICK TO COPY

prop ( name )

Evaluates the value of a column for every row in the dataset.

For example think about a dataset containing 3 cities: Barcelona, Paris and London. The prop('name') will return the name of the current city for every point in the dataset.

Parameters
Name Description
name String

The property in the dataset that is going to be evaluated

Returns
Number | Category | Date
Example Display only cities with name different from "London".
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
 filter: s.neq(s.prop('name'), 'london')
});
CLICK TO COPY
Example Display only cities with name different from "London".
1
2
3
4
5
6
7
const viz = new carto.Viz(`
  filter: neq(prop('name'), 'london')
`);

const viz = new carto.Viz(`
  filter: $name != 'london'
`);
CLICK TO COPY

ramp ( input , palette , others )

Create a ramp: a mapping between an input (numeric or categorical) and an output (number, colors and/or images)

When the input has the same number of categories (without taking the "others" category into account). Then, each input category will have a one to one match with an output value.

Some case examples: ramp(buckets($product, ['A, 'B', 'C']), [house, car, bus]) ramp(buckets($price, [20, 50, 120]), [1, 10, 4, 12]) ramp(top($product, 3), [blue, yellow, green]) ramp(globalQuantiles($price, 3), [red, yellow, green])

When the input has different number of categories or the input is a linear expression. Then it will interpolate the output values (Note: this is not supported if output values are images)

Some case examples: ramp(linear($price, 1, 10) [green, yellow, red]) `ramp(buckets($product, ['A, 'B', 'C'], [red, blue]))

  • When the input is a categorical property, we wrap it automatically in a CategoryIndex expression

ramp($product, Prism) (equivalent to ramp($categoryIndex($product)), Prism)

  • When the input is a numeric property, we wrap it automatically in a Linear expression.

ramp($price, Prism) (equivalent to ramp($linear($price)), Prism)

The "others" value is setted by default, depending on the output type:

  • If it is "Number", the "others" value is 1.

  • If it is "Color" from a color array (i.e: [red, yellow, green]), the "others" value is the gray color.

  • If it is "Color" from a cartocolor palette (i.e: Prism), the "others" value is the last color of the palette.

  • If it is "Image", the "others" value is a circle.

If we add a third parameter, the "others" default value will be overridden by this one

Parameters
Name Description
input Number | Category

The input expression to give a color

palette Palette | Color Array | Number Array

The color palette that is going to be used

others

(Optional)

Value that overrides the default value for "others"

Returns
Number | Color | Image
Example Mapping categories to numbers, colors and images.
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.ramp(s.buckets(s.prop('product'), ['A, 'B', 'C']), [1, 2, 3])
  color: s.ramp(s.buckets(s.prop('product'), ['A, 'B', 'C']), s.palettes.PRISM)
  strokeColor: s.ramp(s.buckets(s.prop('product'), ['A, 'B', 'C']), [s.namedColor('red'), s.namedColor('yellow'), s.namedColor('green')])
  symbol: s.ramp(s.buckets(s.prop('product'), ['A, 'B', 'C']), [s.HOUSE, s.CAR, s.BUS])
});
CLICK TO COPY
Example Mapping categories to numbers, colors and images.
1
2
3
4
5
6
const viz = new carto.Viz(`
  width: ramp(buckets($product), ['A, 'B', 'C']), [1, 2, 3])
  color: ramp(buckets($product), ['A, 'B', 'C']), Prism)
  strokeColor: ramp(buckets($product), ['A, 'B', 'C']), [red, yellow, green])
  symbol: ramp(buckets($product), ['A, 'B', 'C']), [house, car, bus])
`);
CLICK TO COPY
Example Mapping classified numeric properties to numbers, colors and images.
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.ramp(s.buckets(s.prop('price'), [40, 100]), [1, 2, 3])
  color: s.ramp(s.buckets(s.prop('price'), [40, 100]), s.palettes.PRISM)
  strokeColor: s.ramp(s.buckets(s.prop('price'), [40, 100]), [s.namedColor('red'), s.namedColor('yellow'), s.namedColor(green)])
  symbol: s.ramp(s.buckets(s.prop('price'), [40, 100]), [s.HOUSE), s.CAR, s.BUS])
});
CLICK TO COPY
Example Mapping classified numeric properties to numbers, colors and images.
1
2
3
4
5
6
const viz = new carto.Viz(`
  width: ramp(buckets($price, [40, 100]), [1, 2, 3])
  color: ramp(buckets($price, [40, 100]), Prism)
  strokeColor: ramp(buckets($price, [40, 100]), [red, yellow, green])
  symbol: ramp(buckets($price, [40, 100]), [house, car, bus])
`);
CLICK TO COPY
Example Override default values.
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.ramp(s.top(s.prop('price'), 3), [1, 2, 3], 0)
  strokeColor: s.ramp(s.top(s.prop('price'), 3), Prism, s.namedColor('red'))
  color: s.ramp(s.top(s.prop('price'), 3), [s.namedColor('blue'), s.namedColor('red'), s.namedColor('yellow')], s.namedColor(black))
  symbol: s.ramp(s.top(s.prop('price'), 3), [s.HOUSE, s.CAR, s.BUS], s.CROSS)
});
CLICK TO COPY
Example Override default values.
1
2
3
4
5
6
const viz = new carto.Viz(`
  width: ramp(top($price, 3), [1, 2, 3], 0)
  strokeColor: ramp(top($price, 3), Prism, red)
  color: ramp(top($price, 3), [blue, red, yellow], black)
  symbol: ramp(top($price, 3), [house, car, bus], cross)
`);
CLICK TO COPY

reverse ( input )

Reverse the provided item.

Parameters
Name Description
input Palette | List

item to be reversed

Returns
Palette | List
Example Invert a Palette.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.prop('type'), s.reverse(s.palettes.PRISM));
});
CLICK TO COPY
No String example available
Example Invert a Palette .
1
2
3
const viz = new carto.Viz(`
  color: ramp($type, reverse(PRISM))
`);
CLICK TO COPY
Example Invert a List.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.prop('count'), s.reverse([s.namedColor('red'), s.namedColor('blue')]));
});
CLICK TO COPY
No String example available
Example Invert a List .
1
2
3
const viz = new carto.Viz(`
  color: ramp($count, reverse([red, blue]))
`);
CLICK TO COPY

rgb ( r , g , b )

Evaluates to a rgb color.

Parameters
Name Description
r Number

The amount of red in the color in the [0, 255] range. Numeric expression.

g Number

The amount of green in the color in the [0, 255] range. Numeric expression.

b Number

The amount of blue in the color in the [0, 255] range. Numeric expression.

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.rgb(0, 0, 255)
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: rgb(0, 0, 255)
`);
CLICK TO COPY

rgba ( r , g , b , a )

Evaluates to a rgba color.

Parameters
Name Description
r Number

The amount of red in the color in the [0, 255] range. Numeric expression.

g Number

The amount of green in the color in the [0, 255] range. Numeric expression.

b Number

The amount of blue in the color in the [0, 255] range. Numeric expression.

a Number

The alpha value of the color in the [0, 1] range. Numeric expression.

Returns
Color
Example Display blue points.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.rgba(0, 0, 255, 1)
});
CLICK TO COPY
Example Display blue points.
1
2
3
const viz = new carto.Viz(`
  color: rgba(0, 0, 255, 1)
`);
CLICK TO COPY

rotate ( angle )

Rotate. Define a rotation in degrees.

Limitation: only supported in combination with symbol: .

Parameters
Name Description
angle Number

angle to rotate in degrees in clockwise direction

Returns
Transform
Example Rotate 30 degrees in clockwise direction.
1
2
3
4
5
const s = carto.expressions;
const viz = new carto.Viz({
  symbol: s.CROSS
  transform: s.rotate(30)
});
CLICK TO COPY
Example Rotate 30 degrees in clockwise direction.
1
2
3
4
const viz = new carto.Viz(`
  symbol: cross
  transform: rotate(30)
`);
CLICK TO COPY
Example Rotate 30 degrees in counter-clockwise direction.
1
2
3
4
5
const s = carto.expressions;
const viz = new carto.Viz({
  symbol: s.CROSS
  transform: s.rotate(-30)
});
CLICK TO COPY
Example Rotate 30 degrees in counter-clockwise direction.
1
2
3
4
const viz = new carto.Viz(`
  symbol: cross
  transform: rotate(-30)
`);
CLICK TO COPY

scaled ( width , zoomlevel )

Scale a width value to keep feature width constant in real space (meters). This will change the width in pixels at different zoom levels to enforce the previous condition.

Parameters
Name Description
width Number

pixel width at zoom level zoomlevel

zoomlevel Number

zoomlevel at which width is relative to

Returns
Number
Example Keep feature width in meters constant with 25 pixels at zoom level 7.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.scaled(25, 7)
});
CLICK TO COPY
Example Keep feature width in meters constant with 25 pixels at zoom level 7.
1
2
3
const viz = new carto.Viz(`
  width: s.scaled(25, 7)
`);
CLICK TO COPY

sign ( x )

Compute the sign of a number x, indicating whether the number is positive, negative or zero This means this function will return 1 if the number is positive, -1 if the number is negative 0 if the number is 0 and -0 if the number is -0.

Parameters
Name Description
x Number

Numeric expression to compute the sign

Returns
Number
Example Sign.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.sign(100)  // 1
});
CLICK TO COPY
Example Sign.
1
2
3
const viz = new carto.Viz(`
  width: sign(100)
`);
CLICK TO COPY

sin ( x )

Compute the sine of a number x.

Parameters
Name Description
x Number

Numeric expression to compute the sine in radians

Returns
Number
Example Sin.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.sin(Math.PI/2)  // 1
});
CLICK TO COPY
Example Sin.
1
2
3
const viz = new carto.Viz(`
  width: sin(PI/2)
`);
CLICK TO COPY

sqrt ( x )

Compute the square root of a number x.

Parameters
Name Description
x Number

Numeric expression to compute the square root

Returns
Number
Example Square root.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.sqrt(4)  // 2
});
CLICK TO COPY
Example Square root.
1
2
3
const viz = new carto.Viz(`
  width: sqrt(4)
`);
CLICK TO COPY

sub ( minuend , subtrahend )

Substract two numeric expressions.

Parameters
Name Description
minuend Number | Color

The minuend of the subtraction

subtrahend Number | Color

The subtrahend of the subtraction

Returns

Result of the substraction

Number | Color
Example Number subtraction.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.sub(10, 2)  // 8
});
CLICK TO COPY
Example Number subtraction.
1
2
3
const viz = new carto.Viz(`
  width: 10 - 2  // Equivalent to sub(10, 2)
`);
CLICK TO COPY

tan ( x )

Compute the tangent of a number x.

Parameters
Name Description
x Number

Numeric expression to compute the tangent in radians

Returns
Number
Example Tan.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  width: s.tan(0)  // 0
});
CLICK TO COPY
Example Tan.
1
2
3
const viz = new carto.Viz(`
  width: tan(0)
`);
CLICK TO COPY

time ( date )

Time constant expression

Parameters
Name Description
date Date | string | number

The date from a JavaScript Date() object or a date encoded as a string or the number of milliseconds since Epoch.

Returns
Date
Example Filter by a date between dates.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  filter: s.between(s.prop('date'), s.time('2022-03-09T00:00:00Z'), s.time('2033-08-12T00:00:00Z')
});
CLICK TO COPY
Example Filter by a date between dates.
1
2
3
const viz = new carto.Viz(`
  filter: time('2022-03-09T00:00:00Z') < $date < time('2033-08-12T00:00:00Z')
`);
CLICK TO COPY

top ( property , n )

Get the top n properties, aggregating the rest into an "others" bucket category.

Parameters
Name Description
property Category

Column of the table

n number

Number of top properties to be returned, the maximum value is 16, values higher than that will result in an error

Returns
Category
Example Use top 3 categories to define a color ramp.
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  color: s.ramp(s.top(s.prop('category'), 3), s.palettes.VIVID)
});
CLICK TO COPY
Example Use top 3 categories to define a color ramp.
1
2
3
const viz = new carto.Viz(`
  color: ramp(top($category, 3), VIVID)
`);
CLICK TO COPY

transition ( duration )

Transition returns a number from zero to one based on the elapsed number of milliseconds since the viz was instantiated. The animation is not cyclic. It will stick to one once the elapsed number of milliseconds reach the animation's duration.

Parameters
Name Description
duration number

Animation duration in milliseconds

Returns
Number

translate ( x , y )

Translate. Define a translation:

Parameters
Name Description
x number

first numeric expression that indicates the translation in the X direction.

y number

second numeric expression that indicates the translation in the Y direction.

Returns

Numeric expression

Translate
Example Apply an x, y translation
1
2
3
4
const s = carto.expressions;
const viz = new carto.Viz({
  transform: s.translate(10, 20)
});
CLICK TO COPY
No String example available
Example Apply an x, y translation.
1
2
3
const viz = new carto.Viz(`
  transform: translate(10, 20)
`);
CLICK TO COPY

var ( name )

Alias to a named variable defined in the Viz.

Parameters
Name Description
name String

The variable name that is going to be evaluated

Returns
Number | Category | Color | Date
Example
1
2
3
4
5
6
7
const s = carto.expressions;
const viz = new carto.Viz({
  variables: {
    sum_price: s.clusterSum(s.prop('price'))
  }
 filter: s.neq(s.var('sum_price'), 'london')
});
CLICK TO COPY
Example
1
2
3
4
const viz = new carto.Viz(`
  @sum_price: clusterSum($price)
  filter: $price == 30  // Equivalent to eq($price, 30)
`);