From OCG Test Wiki

This document describes the format of the file containing the HAB in situ measurements which are uploaded to the password protected ftp server ocgmod1.marine.usf.edu.

The files are read by a computer program which will probably fail if the data is not in the format described here.

[edit] Filename

The filename has the following format:

HAB_forecast_<4 digit year>-<2 digit month>-<2 digit day>.txt

The date corresponds to the moment when file was created. For example, HAB_forecast_2007-09-05.txt would be a valid filename but not HAB_forecast_2007-9-5.txt.

[edit] Content

The file is a ASCII file structured in columns separated by tabs (\t) and rows separated by line breaks (\n). Character strings are surrounded by quotes. The first line of the file contains the headers of the columns (also separated by tabs):

"SAMPLE_TBL_ID"	"SAMPLE_DATE"	"LOCATION"	"LATITUDE"	"LONGITUDE"	"DEPTH"	"HAB_ID"	"Range"

column SAMPLE_TBL_ID

an integer number (not currently used)

column SAMPLE_DATE

date in the format MM/DD/YYYY hh:mm:ss (leading zeros in month and day are optional)

column LOCATION

character string describing the location (not currently used)

column LATITUDE

signed latitude in degrees North (no N or S)

column LONGITUDE

signed longitude in degrees West (no E or W)

column DEPTH

a positive floating number representing the depth

column HAB_ID

identifier for the HAB (not currently used and may be empty)

column Range

one of the following: "PRESENT", "VERY LOW", "LOW", "HIGH", "VERY HIGH"

For example, the first lines of a file might be:

"SAMPLE_TBL_ID"	"SAMPLE_DATE"	"LOCATION"	"LATITUDE"	"LONGITUDE"	"DEPTH"	"HAB_ID"	"Range"
83287	8/23/2007 0:00:00	"Mote Marine Lab, Bay Dock"	27.33	-82.57	0.50		"VERY LOW"
83288	8/23/2007 0:00:00	"Mote Marine Lab, New Pass Dock"	27.33	-82.57	0.50		"VERY LOW"
83289	8/23/2007 0:00:00	"Sand Key Beach, Clearwater"	27.96	-82.83	0.50	"HABW070823-011"	"VERY LOW"
83290	8/23/2007 0:00:00	"Redington Pier"	27.82	-82.83	0.50	"HABW070823-012"	"VERY LOW"
83291	8/23/2007 0:00:00	"Mullet Key, gulf Pier"	27.61	-82.73	0.50	"HABW070823-013"	"VERY LOW"