I want to export my layer from QGIS as a CSV to import it into google fusion tables. The problem is the qgis export for the geography column is in the wrong format for what google wants.
QGIS exports the column like this:
POLYGON ((-89.286886718442915 43.036071759682343 0,-89.286884882780711 43.03590714097303 0 [...etc...] ))
But the format Google Fusion Table wants is:
<Polygon><outerBoundaryIs><LinearRing><coordinates>-89.29512225140348,43.03848368749686,0 -89.29421212623849,43.03849391491957,0 [...etc.] </coordinates></LinearRing></outerBoundaryIs></Polygon>
Is there a way to build a custom CRS to export the data in that format? Alternatively, maybe I need some REGEX to swap out the beginning/ending text and also replace the "," and " " for each line?
Not sure what the best way forward is.