Help with animated heat map

[alex.r...@climateoutreach.org]

Hi folks, 

So here is my problem. 

I want to create a map that shows a bunch of points changing over time. So the animated heat map seems perfect. To explain why it isn't working I'll need to tell you a bit about the data I'm mapping. 

I'm mapping the places people blog about when they blog about climate change. I used a geo-extractor to identify thousands of locations in thousands of blog posts. So for example I can tell you that Paris was mentioned so many hundred times in blogs about climate change during 2015, but hardly at all in 2013. (And all kinds of other interesting things). The time data is in years. I've got 12 years worth of data. 

Now the problem. If I set the animated heat map "steps" number to 16 then some years fall entirely within one "step" while other years are spread over two. This means that when the map is animated it doesn't really show you the year to year progression. What I need is for each year to be one step in the animation. And to make sure all my 2014 data points light up only in 2014 and all my 2015 data points like up only in 2015. 

Having played around with the various options I can't work out how to do this. But it seems like something well within the capabilities of the Torque heat map. Can anyone tell me how to do this? 

Thanks, 

Alex 

[Margie Roswell]

I don't know the answer, but I think your project is really interesting, and hope you find success. I'm a CartoDB user, but haven't played much with these torque heat maps, except in the random CartoDB tutorials. So, with that interest and ignorance claimed: why did you make 16 steps if you have 12 years worth of data? Did you set the time column to the year? 

BTW, a note for cartodb staff who may be on this list: there's a typo in the torque heatmap tutorial

http://docs.cartodb.com/tutorials/heatmap/

Near the bottom: 

"by turning on the “Cumulated” menu option."

Should be:

"by turning on the “Cumulative” menu option."

--

http://FarmBillPrimer.org

http://www.BaltimoreUrbanAg.org (Please send events; This site is hungry.)
http://www.ExcellentNutrition.org
http://www.packtpub.com/drupal-5-views-recipes/book

 COIN is a charitable company, limited by guarantee, founded in 2004 to increase public understanding and awareness of climate change. Charity registration number 1123315, company number is 06459313, registered in England and Wales.

--

---
You received this message because you are subscribed to the Google Groups "cartodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cartodb+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jorge Sanz]

Torque accepts numeric fields so you can try to assign all your points to an integer say 2010 = 1, 2011 = 2, etc and then set the same number of steps of the domain of that integer both on the number of frames and the duration, the latestthat can be a multiply of the number of frames if you don't want them to be of one second. You can use the extract function[1] to get that integer.

Best regards

[1] http://www.postgresql.org/docs/9.1/static/functions-datetime.html

 

--

Jorge Sanz
Solutions Engineer
CartoDB · Map Your World's Data