glw

Postgres Cheatsheet

Some time in the future I'll have to organize this better

• postgresql install from here http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS22UbuntuPGSQL95Apt

• quick set up to allow remote connections...THIS IS FOR TESTING ONLY

• use netstat -nlt to check if port 5432 is open

glw

workon web-app
pip install ipykernel
python -m ipykernel install --user --name web-app --display-name "Webapp"
#then start jupyter, and you should see "Webapp" in the drop down for kernels

glw

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

glw

echo "file, output" > output.csv;
TIFS=$(find . -name '*.TIF');
for f in $TIFS; do
  output=$(tiffinfo.exe $f 2>&1 | grep 'Cannot read TIFF header');
  echo "$f, $output" >> output.csv;
done

glw

tar/compress

tar -zcvf archive.tar.gz directory/

untar/decompress

tar -xvzf archive.tar.gz directory/

glw

var todoList = {
  todos: [],
  addTodo: function(todoText) {
    this.todos.push({
      todoText: todoText,
      completed: false
    });
  },
  changeTodo: function(position, todoText) {
    this.todos[position].todoText = todoText;

glw

glw

glw

Installing pyexiv2 into a virtualenv

exiv2 is already installed via apt-get

download deb package

sudo aptitude download python-pyexiv2 #has libboost-python1.58.0 dependency

my best guess is that this has to be installed on the OS

glw

echo "name, altitude" > output.csv
for tif in ./path/to/images/0003/*.TIF; do 
  name=$(exiftool $tif | grep 'Original Raw File Name')
  alt=$(exiftool $tif | grep 'GPS Altitude                    :')
  echo "$name, $alt" >> output.csv
done