ICES Marine Data

DATSU


DATSU > List of operations > Specification of the format (checks)

Dataset:

Format / Checks / Species

Checks

Record:

Record Checks:

Mandatory field	error
Mandatory record	error
Missing values in mandatory field	warning

Cross checks

Check if you file is a resubmission, that NationalHaulID already exist in the database	warning
Day is out of range	error
Each file can only contain a Year, Survey, Country, Institute, Ship	error
Latitude not valid	error
Longitude is not valid	error
Only one combination of Country, Year, Ship, Institute and Survey is allowed per file	error
Point could be on land!	error
The combination of Year, Month, Day, Hour and Minute does not give a valid datetime	error
The HaulID is not unique for the File	error
This is a resubmission, the previous file will be deleted from the database	Information
This ship was detected in the database for the same date but different country or institute or survey	error

Field Checks

RecordType	start	Field	Description		Error Type
EH	1	RecordType
EH	2	Survey	Field value is invalid - prevents entry to database		error
EH	3	Country	Field value is invalid - prevents entry to database		error
EH	3	Country	Field A is not consistent with field B	Country is not consistent with Institute	error
EH	4	Institute	Field value is invalid - prevents entry to database		error
EH	5	Campaign
EH	6	SurveyPeriod	Not in the range specified	Lower:1.000000000000 Upper: 99.000000000000	warning
EH	7	Ship	Field value is invalid - prevents entry to database		error
EH	8	Gear	Field value is invalid - prevents entry to database		error
EH	9	GearDeployment	Field value is invalid - prevents entry to database		error
EH	10	MeshSize
EH	11	MeshType	Field value is invalid - prevents entry to database		error
EH	12	CodendMesh
EH	13	StationNumber
EH	14	HaulID
EH	15	ELHaulFlag	Field value is invalid - prevents entry to database		error
EH	16	NationalHaulID
EH	17	Day	Not in the range specified	Lower:1.000000000000 Upper: 31.000000000000	warning
EH	18	Month	Not in the range specified	Lower:1.000000000000 Upper: 12.000000000000	warning
EH	19	Year	Not in the range specified	Lower:1880.000000000000 Upper: 2099.000000000000	warning
EH	20	Hour	Not in the range specified	Lower:0.000000000000 Upper: 23.000000000000	warning
EH	21	Minute	Not in the range specified	Lower:0.000000000000 Upper: 59.000000000000	warning
EH	22	StartLatitude
EH	23	StartLongitude
EH	24	HaulDurationMinutes
EH	25	HaulDurationSeconds	Not in the range specified	Lower:0.000000000000 Upper: 59.000000000000	warning
EH	26	Distance	Not in the range specified	Lower:50.000000000000 Upper: 8000.000000000000	warning
EH	27	WireAngle	Not in the range specified	Lower:15.000000000000 Upper: 75.000000000000	warning
EH	28	WireLength
EH	29	Netopening
EH	30	NetopeningArea
EH	31	FlowEfficiency
EH	32	NetClogging	Field value is invalid - prevents entry to database		error
EH	33	FlowmeterType	Field value is invalid - prevents entry to database		error
EH	34	FlowmeterBrand
EH	35	FlowIntRevs
EH	36	FlowIntCalibr
EH	37	FlowExtRevs
EH	38	FlowExtCalibr
EH	39	VolumeFiltInt
EH	40	ELVolFlag	Field value is invalid - prevents entry to database		error
EH	41	DepthUpper
EH	42	DepthLower
EH	43	DepthBottom
EH	44	SurTemp
EH	45	Temp20m
EH	46	Temp50m
EH	47	Temp100m
EH	48	BotTemp
EH	49	SurSal
EH	50	Sal20m
EH	51	BotSal
EH	52	StatRec	Field value is invalid (Rel) - prevents entry to database		error
EH	53	Notes

International Council for the Exploration of the Sea (ICES) · Conseil International pour l'Exploration de la Mer (CIEM)

ICES Secretariat · H. C. Andersens Boulevard 44-46, DK 1553, Copenhagen Denmark · Tel: +45 3338 6700 · Fax: +45 3393 4215 · info@ices.dk

Disclaimer © ICES - All Rights Reserved