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_copyBut 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 but would be grateful for any help!
أكثر...
SELECT ST_Centroid(the_geom) the_geom, carto_date FROM maritime_emissions_my_data_trial_copyBut 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 but would be grateful for any help!
أكثر...