echo "select timeingpointcode, town, name, X(Transform(geo, 4326)), Y(Transform(geo, 4326)) from govi_rd" | psql -A -F ";" > /tmp/govi-wgs84-2.tsv
echo '<?xml version="1.0" encoding="UTF-8"?><kml xmlns="http://earth.google.com/kml/2.2"><Document>' > govi2.kml
cat /tmp/govi-wgs84-2.tsv | sed "s/\(.*\);\(.*\);\(.*\);\(.*\);\(.*\)/<Placemark id='\1'><name>\2, \3<\/name><Point><coordinates>\4,\5<\/coordinates><\/Point><\/Placemark>/g" >> govi2.kml
echo '</Document>' >> govi2.kml