Handy database documenter for MySQL
By John C. Zastrow
UPDATE: see the next iteration on this project [here]
[Read More]
-
-
MySQL Functions
By John C. ZastrowI just want to record these for future reference. I’m actually using the first now. [Read More] -
Accessing versioned geodata in ArcSDE with SQL
By John C. ZastrowThis is excerpted from the following forum post: [Read More] -
ITIS Organism Flat table from MySQL
By John C. ZastrowI 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] -
Loading tab-delimited data to local MySQL
By John C. ZastrowI’m looking at some data from the Avian Knowledge Network and Microsoft Access just isn’t up to dealing with the volume of records. So I switched over to MySQL. [Read More] -
Using Rsync under Windows with Cygwin
By John C. ZastrowFrom http://www.gaztronics.net/rsync.php [Read More] -
Python Tutorials
By John C. Zastrowhttp://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. ZastrowI’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] -
Another automated FTP bash script
By John C. Zastrowfrom http://www.stratigery.com/scripting.ftp.html [Read More] -
Scheduled file copies or directory sync from local directory to FTP server
By John C. ZastrowIf you have a remote FTP server that you need to put files into, and you don’t want to deal with SCP/SFTP passkeys, lftp (http://lftp.yar.ru/) on the local client machine might be for you. It comes with most linux distros (I found it using yum simply as lftp) and one... [Read More]