MDUC DATA REPORT: CTD CORE DATA
	Report prepared by Reiko Michisaki
	Monday, September 29, 2003 10:18:35
	Cruises taken this month
	Project	Cruise	Date	PI	Description
	PTLO	26003	9/17/200	Francisco Chavez	900204: Biogeochemical Responses to
	 Climate Variability: Time series: 
	Stations C1, M1, M2
	AOSN	AOSN	9/3/2003	Francisco Chavez	704270: Integration and 
	Demonstration of Observation and 
	Modeling
	Cruises loaded this month*
	Project	Cruise	# Stations	Date	Description
	PTLO	23803	6	8/26/2003	900204: Biogeochemical Responses to 
	Climate Variability: Time series: Stations 
	C1, M1, M2
	PTLO	26003	3	9/17/2003	900204: Biogeochemical Responses to 
	Climate Variability: Time series: Stations 
	C1, M1, M2
	*Data loaded pertains only to the core data, may not contain biological or chemical data.
	Loading details
	Record counts
	Cruise	BCTD	PCTD
	23803	0	1828
	26003	36	1210
	Problems 
	1. Testing of new SQL Server Solstice.
	2. Cruise 23803 had no bottle data.  As such there was a problem updating the 
	EXPEDITION table.  Need modification to stored procedure to data load.
	Modifications
	2. SQL Server switched from Godzilla to Solstice
	3. Created a new stored procedure to extract data >from the PCTD to load into the 
	EXPEDITION table.  New procedure is UpdateExpdfromPCTD.
	MBARI Confidential Information	Page 1 of 1