I have shapefiles which I have loaded in postgis and now i am trying to use geometric function in postgis like ST_intersect and they fail because the data is not topological correct.
I have tried to use the function st_isvalid and others and could not correct the data. As a last resort i have loaded the data into grass which automatically builds topology and trying to export that layer into postgis fails with an error saying gid already exist.
Also, trying to export as a shapefile works but i encounter a problem when i load the shapefile back to postgis and try to do my clip as it complains that geometric column contains z column but geometry does not.
How best can i attend to these?