I was wondering if there is a way to have CartoDB's torque read end dates for point files, the same way that ArcGIS desktop can. I am trying to plot the foundation of certain cities, and then remove from the map those that were subsequently abandoned. My data would look something like this (assuming the end date of the visualization was the year 1650)

PLACE        FOUNDED     ABANDONED
City_1       1585        1650
City_2       1600        1625
City_3       1615        1620
City_4       1630        1650

As it stands, I have the choice of (a) having the cities appear/disappear according to their foundation date or (b) having all of the cities accumulate on the map. Neither of these solutions work because for a given year (i.e. 1622), I will either show cities that no longer existed or hide some that continued to be there. I know that there is a similar discussion on this matter here, but the solution of adding a row for each year is not feasible in my case.

I was wondering if there is a way to have CartoDB's torque read end dates for point files, the same way that ArcGIS desktop can. I am trying to plot the foundation of certain cities, and then remove from the map those that were subsequently abandoned. My data would look something like this (assuming the end date of the visualization was the year 1650)

PLACE        FOUNDED     ABANDONED
City_1       1585        1650
City_2       1600        1625
City_3       1615        1620
City_4       1630        1650

As it stands, I have the choice of (a) having the cities appear/disappear according to their foundation date or (b) having all of the cities accumulate on the map. Neither of these solutions work because for a given year (i.e. 1622), I will either show cities that no longer existed or hide some that continued to be there. I know that there is a similar discussion on this matter here, but the solution of adding a row for each year is not feasible in my case.

I was wondering if there is a way to have CartoDB's torque read end dates for point files, the same way that ArcGIS desktop can. I am trying to plot the foundation of certain cities, and then remove from the map those that were subsequently abandoned. My data would look something like this (assuming the end date of the visualization was the year 1650)

PLACE        FOUNDED     ABANDONED
City_1       1585        1650
City_2       1600        1625
City_3       1615        1620
City_4       1630        1650

As it stands, I have the choice of (a) having the cities appear/disappear according to their foundation date or (b) having all of the cities accumulate on the map. Neither of these solutions work because for a given year (i.e. 1622), I will either show cities that no longer existed or hide some that continued to be there. I know that there is a similar discussion on this matter here, but the solution of adding a row for each year is not feasible in my case.

Thanks for the help!

I was wondering if there is a way to have CartoDB's torque read end dates for point files, the same way that ArcGIS desktop can. I am trying to plot the foundation of certain cities, and then remove from the map those that were subsequently abandoned. My data would look something like this (assuming the end date of the visualization was the year 1650)

PLACE        FOUNDED     ABANDONED
City_1       1585        1650
City_2       1600        1625
City_3       1615        1620
City_4       1630        1650

As it stands, I have the choice of (a) having the cities appear/disappear according to their foundation date or (b) having all of the cities accumulate on the map. Neither of these solutions work because for a given year (i.e. 1622), I will either show cities that no longer existed or hide some that continued to be there. I know that there is a similar discussion on this matter here, but the solution of adding a row for each year is not feasible in my case.