#!/bin/sh

echo '<gpx version="1.0" creator="poi2gpx">'

sqlite3 $1 "select * from poi;" | sed -e "s,[^|]*|\([^|]*\)|\([^|]*\)|[^|]*|[^|]*|[^|]*|\([^|]*\)|.*,<wpt lat=\"\1\" lon=\"\2\"><name>\3</name></wpt>,g" -e 's/\&//g'

echo '</gpx>'
