GeoNotes Blog

Notes for myself and others

  • ITIS Organism Flat table from MySQL

     By John C. Zastrow

    Posted on March 17, 2011

    I need to make a table to look up common (vernacular) names for some organisms. So I imported the USGS ITIS database from text files into MySQL and created this little view. Hopefully this helps someone else. [Read More]

  • Python Tutorials

     By John C. Zastrow

    Posted on February 28, 2011

    http://www.sthurlow.com/python/ http://www.swaroopch.com/notes/Python http://young-programmers.blogspot.com/search/label/python http://en.wikibooks.org/wiki/Non-Programmer%27s_Tutorial_for_Python_2.6 [Read More]

  • Remove header from a text file

     By John C. Zastrow

    Posted on January 26, 2011

    I’m processing some Darwin-schema biodiversity text files in preparation for GISing them and I need to trim the headers from the tops of the files before importing them to the database. Of course, *NIX command line utilities have been my friend here. The following will trim the first line off... [Read More]

  • Using screen in Linux to save your bacon

     By John C. Zastrow

    Posted on February 28, 2010

    Tonight I’m being plagued by dropped ssh connections. 2 minutes of work, them bam everything goes away. I’ve seen screen used in the past, but never had to use its power until tonight. Ask any seasoned sysadmin and they’ll tell you that screen has saved their bacon many times, and... [Read More]

  • SYSSTAT: SAR/IOSTAT

     By John C. Zastrow

    Posted on February 25, 2010

    The pidstat command is used to monitor processes and threads currently being managed by the Linux kernel. It can also monitor the children of those processes and threads. [Read More]
    Tags: