Hot answers tagged

4 votes

CartoDB Torque viz: make bubbles grow to show intensity/frequency?

You can use the new category Torque to change the marker-size and color if you have a limited amount of different categories (in this case, the number of letters). You just need a column with this ...
user avatar
  • 4,772
3 votes
Accepted

Can we hide/show a Torque layer and/or set SQL?

You can apply the torqueLayer.hide() and torqueLayer.show() methods to control the display of your Torque layer. There is also the torqueLayer.setSQL('...') option. With all of these, you need to make ...
user avatar
3 votes
Accepted

Style Torque Heatmap CartoDB CSS

You could use a query like: WITH aux AS ( SELECT max(pntcnt) AS m FROM table_name ) SELECT t.*, (100.0*pntcnt)/aux.m AS norm_pntcnt FROM table_name t, aux to have a norm_pntcnt ...
user avatar
2 votes

Mapping datapoints over several floors of a building

CartoDB doesn't know about a "z dimension", but you will be able to build something similar by playing with the zoom levels. Directly in the editor: Built a Torque Category map by a column which ...
user avatar
  • 4,772
2 votes
Accepted

CartoDB, Torque map sending events to JS when a market is rendered

You don't need a javascript query, you only need to know the number of bubbles per time and then get the change:time signal in torque layer. layer.on('change:time', function(datetime) { // update ...
user avatar
  • 1,642
2 votes
Accepted

Carto DB: Scalable points over time using Torque in Carto DB

You need to use the [value] value directly in the marker-width instead of using it in the constraints. Try this one: /** torque visualization */ Map { -torque-frame-count:16; -torque-animation-...
user avatar
  • 4,772
2 votes

Marker-file for torque CartoDB

torque does not support marker-file and marker-fill at the same time, in other words, you can not color a sprite using marker fill. The workaround is to have an sprite per color.
user avatar
  • 1,642
2 votes

How to change timeslider step in CartoDB/torque?

All you should have to do is go to the time slider options. Change the Time Step interval to 1.0 and change it to Days. Time window should also be 1.0 days as well.
user avatar
2 votes
Accepted

Moving layer in Cartodb

That map uses the Leaflet extension L.terminator. This means that you need to build a map using the Leaflet and CartoDB.js library. Learning resources on CartoDB.js are in CartoDB's Map Academy. You ...
user avatar
2 votes
Accepted

CartoDB: Torque animation timeslider

The Torque formatter is not editable via the CartoDB Editor at this moment. In order to edit it to show a different date format you'd need to use Javascript and the CartoDB.js library. You can check ...
user avatar
  • 4,772
2 votes

CartoDB Torque: show severity by size of marker?

You can build your own torque-aggregation-function by playing a bit with maths. Let's say that your column is named floods. Then you could do: -torque-aggregation-function:"round(avg(floods))"; ...
user avatar
  • 4,772
2 votes

Can a CartoDB-Torque map be used for polygon instead of a point data?

What @John Barça says in the comment above is true. No, Torque does not work with polygons. The Torque wizard is only available for points. Alternatively, there are other options that you could use ...
user avatar
  • 4,772
2 votes
Accepted

How to display multiple points in a torque map with CartoDB

You can see the source data of the visualization you're showing as an example (flights over Queens) here, as the dataset is public. What they are using is a ton of points for each different position ...
user avatar
  • 4,772
2 votes

Style Torque Heatmap CartoDB CSS

The Torque value variable range is limited from 0 to 255 at the moment, and your data seem to contain values much higher than this threshold. You might want to normalize the data in the aggregation ...
user avatar
  • 4,772
2 votes
Accepted

vary bubble size and color in CartoDB Torque Cat

You could create new categories based upon two-variable conditions. Apply a query like this one: SELECT cartodb_id, time_column, the_geom_webmercator, numbers, categories CASE WHEN ...
user avatar
2 votes

What kind of file formats supports the torque marker-file?

The CartoCSS property marker-file only accepts image format files like png ,jpg or svg. In this section of the CARTO documentation you can find detailed information about the marker-file property. On ...
user avatar
  • 1,011
2 votes

Animate points and/or polygons on leaflet map

You could try using d3js. This example seems to match what you want : http://stat4701-edav-d3.github.io/viz/cities/cities.html
user avatar
1 vote
Accepted

CartoDB Torque not showing year in slider

According to your viz.json, it seems that your map is set up with -torque-time-attribute:"year". There's a known issue/behaviour in Torque: by using a numeric column as your year column, it will ...
user avatar
  • 4,772
1 vote

CartoDB Torque dynamic timeout

Torque is only aware of when an event "happens": a point will appear in the date that it occurred, but there isn't any function or attribute to say Torque "hey! keep this point appearing until X date"....
user avatar
  • 4,772
1 vote

CartoDB Torque animation running longer than 'duration' value in CartoDB editor

This seems an actual issue in CartoDB side. I have reported it in the Torque repo: https://github.com/CartoDB/torque/issues/214
user avatar
  • 4,772
1 vote
Accepted

Changing slider format using CartoDB?

From 3.12 this has been changed, try with the following code instead: vis.timeSlider.formatter(function(d) return d.getUTCMonth()+"-"+ d.getUTCDay() + " "+ d.getUTCHours() + ":"+ d.getUTCMinutes(...
user avatar
  • 4,772
1 vote

Different color points with Torque

You can't directly use column names in Torque's CartoCSS like you can with other types of maps. Instead, you need to let the torque-aggregation-function do the work for you. This function outputs a ...
user avatar
1 vote

Must I use "date" data type to animate data by year?

You can convert your number column to a date column by first creating a new column (button in the lower right corner), selecting 'date' as the data type, and then running the following SQL command to ...
user avatar
1 vote

Torque map: dates by year; year in slider text

We did some changes on the intervals of Torque. Yesterday we did a fix for this: if the data range is bigger than one year, then it'll show as always. I think this fix will solve your issue, as I'm ...
user avatar
  • 4,772
1 vote

Stopping Torque from looping in CartoDB editor

This is not directly possible from the Editor at the moment, you need to use CartoDB.js for that. Check this example by @javisantana here. It's detecting the last torque step and pausing the ...
user avatar
  • 4,772
1 vote

Differentiating between children and adults depending on AGE using Cartodb Torque wizard?

I think you could do something with torque cat that they recently added. Create a column that contains the information about the group of ages that you want. Attribute each group age to one color ...
user avatar
1 vote

CartoDB Torque Time Stamp

You can create an empty column of type date and then populate it by using a SQL query. With the Postgres function to_timestamp you'll be able to add the pattern in which your dates are written so that ...
user avatar
  • 4,772
1 vote

Data structure in ordert to use torque

First of all: the Torque option is not available because at the moment Torque only works on points. You can create a point table from your polygon table by using the following query in the SQL tab: ...
user avatar
  • 4,772
1 vote

Shapefiles do not store times so how do I create time intervals for use in Torque?

Ok so I found a cheat! I created a string field in my feature class (in the .gdb) and copied the values from my date field into the new string field (Ex: 17/02/2015 13:30:45). Then I altered the ...
user avatar
1 vote
Accepted

carto db torque slider change color, font

In order to change the slider you have two options: create a custom one based on the default: https://github.com/CartoDB/cartodb.js/blob/develop/src/geo/ui/time_slider.js change current one styles ...
user avatar
  • 1,642

Only top scored, non community-wiki answers of a minimum length are eligible