Fustion Tables CSV => Postgresql => Geom fix

gistfile1.txt

with f as (SELECT cartodb_id, ST_GeomFromText(replace(replace(replace(replace(replace(geometry, '<Polygon><outerBoundaryIs><LinearRing><coordinates>', 'Linestring('), '</coordinates></LinearRing></outerBoundaryIs></Polygon>', ')'), ',', '$'), ' ', ','), '$', ' '),4326) geom  FROM damage_assesment_by_fema_grants_with_shpe_files where geometry != '' order by geometry desc)

update damage_assesment_by_fema_grants_with_shpe_files d 
set the_geom = (
    SELECT ST_MakePolygon(ST_AddPoint(f.geom, ST_StartPoint(f.geom))) from f WHERE cartodb_id = d.cartodb_id LIMIT 1
)

swap out, damage_assesment_by_fema_grants_with_shpe_files with your own table name