branches/gpst.postgis/poisync

   1 #!/bin/bash
   2 #=======================================================================
   3 # $Id$
   4 # For synkronisering av POI og waypoints fra uniten.
   5 #=======================================================================
   6
   7 gpst -o pgwtab ~/gps/unit/wpdata.gpx ~/gps/poi/trans/*.gpx | psql gps -a -c "TRUNCATE tmpwayp; COPY tmpwayp FROM STDIN;"
   8 psql gps -a -c "UPDATE tmpwayp SET coor = point(round(coor[0]::numeric, 6), round(coor[1]::numeric, 6));"
   9 psql gps -a -c "COPY (SELECT coor, name FROM tmpwayp WHERE type IS NULL ORDER BY coor[0] desc, coor[1]) TO '/tmp/un';"
  10 psql gps -a -c "COPY (SELECT coor, name FROM tmpwayp WHERE type IS NOT NULL ORDER BY coor[0] desc, coor[1]) TO '/tmp/p';"
  11
  12 if [ "$1" = "-d" ]; then
  13     diff -u /tmp/un /tmp/p
  14 else
  15     vimdiff /tmp/un /tmp/p
  16 fi