Tuesday, June 23, 2009

Importing ESRI GRID to ENVI

I'm not sure if ENVI documentation is lousy or just not searchable, but I could not find any good information on how to import ESRI GRID to ENVI ... and the ENVI UI is so unintuitive (hint to ITTVIS, why not just streamline the whole "external file" thing into the same "open image" command used to import geotiffs and the like?) as to make a simple task need explaining!

THIS FUNCTIONALITY IS ONLY AVAILABLE IN THE WIN 32 VERSION!

1. File > Open External File > IP Formats > ESRI GRID
2. Navigate to the hdr.adf within the folder with the same name as the vector you are trying to open and open this

Monday, June 22, 2009

"select * into" in mysql

"select * into" is not allowed in mysql. Here is an example to get around this limitation:

CREATE TABLE newtable SELECT * FROM oldtable


originally found here

Monday, June 8, 2009

find/replace text mysql

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);

from: http://www.mydigitallife.info/2007/04/23/how-to-find-and-replace-text-in-mysql-database-using-sql/