TIDE File Location Table

The TIDE File Location Table is a simple mysql database table that keeps track of the location of all the TIDE level-zero, orbit, attitude, and summary plot files that are kept on the TIDE data archives at the NSSTC and GSFC. It is used by the web software to get the names of the input files need by Custom Plots, Data Dumps, Data Download, and Find Files. During the mission, it was also used to create the file used by View Summary Plots and Display Thumbnails.

TIDE file location table (tide_rdaf_file_loc) content:

Field	Type	Null	Key	Default	Extra
start_date_time	datetime	YES	Multiple	NULL
start_remaining_msec	smallint(3)	YES		NULL
stop_date_time	datetime	YES		NULL
stop_remaining_msec	smallint(3)	YES		NULL
file_type	smallint(4)			0
file_name	varchar(40)		Multiple
volume_id	varchar(60)
file_id	int(10) unsigned		Primary	NULL	auto_increment
proc_stat	smallint(3)	YES		NULL

Fields of importance are the file_type, file_name, volume_id, start_date_time, and stop_date_time. The file_types are listed in /archive/tide_docs/Misc/FileLocTableFileTypes.txt. The file_name is the name of the file and the volume_id is the full path to the file storage location on the archive. The start_date_time and stop_date_time contain the data/time range of the data in the file. These are the fields that are used in all of the searches to determine which files are needed for a requested time period.

TIDE Home Page | Documentation Menu | Archive Menu

Last Updated: September 2008

NASA Web Privacy Policy