offset=$( grep "^$pn" $dir/offset.txt )
offset_x=$( echo $offset | cut -d' ' -f2 )
offset_y=$( echo $offset | cut -d' ' -f3 )
+test -z "$offset_x" && offset_x=0
+test -z "$offset_y" && offset_y=0
cat $dir/template.sql | sed -e "s/2008050087/$pn/" -e "s/x_axis_angle/x_axis_angle + $offset_x/" -e "s/y_axis_angle/y_axis_angle + $offset_y/" | psql --username=dpavlin -A -F "," -t zc > /dev/shm/$pn.txt
cat $dir/template.gnuplot | sed -e "s,axes.txt,/dev/shm/$pn.txt," -e "s,^set terminal.*$,set terminal svg," -e "s,^set output.*$,set output," > /dev/shm/$pn.gnuplot