{"version":"1.0","type":"rich","title":"Fustion Tables CSV => Postgresql => Geom fix","description":"This example shows a workflow for repairing invalid geometry in a FEMA damage assessment dataset stored in PostgreSQL with PostGIS. It converts KML-style polygon coordinates from a Fusion Tables CSV export into valid PostGIS geometries, then updates the spatial column. The process uses SQL string functions like `replace()` to transform coordinate formatting, `ST_GeomFromText` to parse the text into geometry, and `ST_MakePolygon` with `ST_AddPoint` to close and correct the polygons. The result prepares the data for subsequent mapping or analysis in a GIS environment.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-5495331?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}