GeoNotes Blog

Notes for myself and others

  • Tables of Tables from MySQL

     By John C. Zastrow

    Posted on April 21, 2011

    From Matthew Crowley on the MySQl forums (http://forums.mysql.com/read.php?101,8004), this php script will output a DESC of all databases and tables in MySQL. It needs some formatting for the output, but it works and might be handy later. I really just need to get around to figuring out how to do... [Read More]

  • MySQL Functions

     By John C. Zastrow

    Posted on March 31, 2011

    I just want to record these for future reference. I’m actually using the first now. [Read More]

  • 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]