I'm trying to alter my data on
cartodb map to get maritime emissions over about 20 years- by country. Hence trying get a torque map for polygons, and by changing polygons to points based on a previous suggestion:
SELECT ST_Centroid(the_geom) the_geom, carto_date FROM maritime_emissions_my_data_trial_copy
But I keep getting a
syntax error at SELECT....
the_geom appears to be properly valued - all rows state "Polygon".
My data is here: http://bit.ly/1M77NjG
I'm quite a novice.