Importing data in EchoBase
Abstract
Data can be imported in Echobase as text files. This document provides details on the formats to be used to import text files in Echobase.
Columns format
|
Format name |
Description |
|---|---|
|
text |
character string |
|
FK(XXX#yyy) |
required foreign key (XXX on yyy property) |
|
(int) |
a non-null integer |
|
(float) |
a non-null float |
|
(Integer) |
a potentially null integer |
|
(Integer-NA) |
a potentially null integer (set to null if NA) |
|
Float |
a potentially null float |
|
(Float-NA) |
a potentially null float (set to null if NA) |
|
(date) |
ISO date format: yyyy-MM-dd HH:mm:ss.SSSS |
|
(esdu cell) |
|
Important
- Column names are case sensitive, one must strictly use the column names given in this page
- The cell contents (as well as the column names) can be encapsulated between ".
Data check
- The data imported into EchoBase are checked at the end of the import, to ensure that they are identical to the data in the input text file.
- Si les données dans le fichier texte et dans la base ne sont pas identiques, un message d'erreur est affiché. Ceci peut provenir de problèmes de format ou de consistence des données d'entrée.
- Afin de détecter ces problèmes, les fichiers texte d'entrée pour chaque import et le fichier "check" correspondant au contenu dans EchoBase sont disponibles dans le dossier "/var/local/echobase/data" du serveur où EchoBase est installé. Fichier d'import = "nomFichierImport-processed.csv" ; Fichier check = "nomFichierImport-checked.csv"
Voyage / Transit / Transect
Voyage
Required columns
name;startDate;endDate;startPort;endPort
Columns formats
|
Column |
Type |
|---|---|
|
name |
text |
|
startDate |
(date) |
|
endDate |
(date) |
|
startPort |
FK(Port#code) |
|
endPort |
FK(Port#code) |
Example
name;startDate;endDate;startPort;endPort PELGAS2011;2011-04-26 08:00:00.0000;2011-06-04 17:00:01.0000;BSH189;BSH4265
Transit
Required columns
voyage;description;startTime;endTime;startLocality;endLocality
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(voyage#name) |
|
description |
text |
|
startTime |
(date) |
|
endTime |
(date) |
|
startLocality |
text |
|
endLocality |
text |
Example
voyage;description;startTime;endTime;startLocality;endLocality PELGAS2011;PELGAS11CAMP1;2011-04-26 08:00:01.0000;2011-05-08 20:00:00.0000;Santander;La Rochelle
Transect
Required columns
title;transectAbstract;stratum;comments;voyage;vesselName;dateCreated;timeCoverageStart;timeCoverageEnd;geospatialLonMin;geospatialLatMin;geospatialVerticalMin;geospatialLonMax;geospatialLatMax;geospatialVerticalMax;linestring
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(voyage#name) |
|
vesselName |
FK(Vessel#name) |
|
title |
text |
|
transectAbstract |
text |
|
stratum |
text |
|
comments |
text |
|
dateCreated |
(date) |
|
timeCoverageStart |
(date) |
|
timeCoverageEnd |
(date) |
|
geospatialLonMin |
(float) |
|
geospatialLonMax |
(float) |
|
geospatialLatMin |
(float) |
|
geospatialLatMax |
(float) |
|
geospatialVerticalMin |
(float) |
|
geospatialVerticalMax |
(float) |
|
linestring |
text |
Example
title;transectAbstract;stratum;comments;voyage;vesselName;dateCreated;timeCoverageStart;timeCoverageEnd;geospatialLonMin;geospatialLatMin;geospatialVerticalMin;geospatialLonMax;geospatialLatMax;geospatialVerticalMax;linestring Arlequin2 / la colombine942OBS01 SUR;942OBS;SUR;942OBS,P5001,SUR;PELGAS2011;Arlequin2 / la colombine;2011-04-27 09:10:00.0000;2011-04-27 09:10:00.0000;2011-04-27 10:39:00.0000;-1.5896666667;43.7055;110;-1.541;43.7606666667;110;-176453.0000037 4851310.5,-171051 4857434.0000037
Ancillary instrumentation
Required columns
voyage;vessel;ancillaryInstrumentation
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
vessel |
FK(Vessel#name) |
|
ancillaryInstrumentation |
FK(AncillaryInstrumentation#name) |
Example
voyage;vessel;ancillaryInstrumentation PELGAS2011;Arlequin2 / la colombine;Inst1
Operation / OperationMetadataValue / GearMetadataValue
Operation
Required columns
vesselName;operationId;depthStratumId;gearShootingStartTime;midHaulLatitude;midHaulLongitude;gearShootingStartLatitude;gearShootingStartLongitude;gearShootingEndTime;gearHaulingEndLatitude;gearHaulingEndLongitude;gearCode
Columns formats
|
Column |
Type |
|---|---|
|
vesselName |
FK(Vessel#name) |
|
gearCode |
FK(Gear#casinoGearName) |
|
depthStratumId |
FK(DepthStratum#id) |
|
operationId |
text |
|
midHaulLatitude |
(float) |
|
midHaulLongitude |
(float) |
|
gearShootingStartTime |
(date) |
|
gearShootingEndTime |
(date) |
|
gearShootingStartLatitude |
(float) |
|
gearHaulingEndLatitude |
(float) |
|
gearShootingStartLongitude |
(float) |
|
gearHaulingEndLongitude |
(float) |
Example
vesselName;operationId;depthStratumId;gearShootingStartTime;midHaulLatitude;midHaulLongitude;gearShootingStartLatitude;gearShootingStartLongitude;gearShootingEndTime;gearHaulingEndLatitude;gearHaulingEndLongitude;gearCode THALASSA II;P0422;CLAS;2011-05-05 06:49:50.0000;45.4165605;-1.4492292;45.4029733;-1.4860902;2011-05-05 07:42:19.0000;45.4301477;-1.4123682;57x52
OperationMetadataValue
Required columns
vesselName;operationId;metadataType;operationMetadataValue
Columns formats
|
Column |
Type |
|---|---|
|
vesselName |
FK(Vessel#name) |
|
operationId |
FK(Operation#id) |
|
metadataType |
FK(OperationMetadata#name) |
|
operationMetadataValue |
text |
Example
vesselName;operationId;metadataType;operationMetadataValue THALASSA II;P0422;MeanWaterDepth;43.42
GearMetadataValue
Required columns
vesselName;operationId;gearCode;metadataType;gearMetadataValue
Columns formats
|
Column |
Type |
|---|---|
|
vesselName |
FK(Vessel#name) |
|
operationId |
FK(Operation#id) |
|
metadataType |
FK(GearMetadata#name) |
|
gearCode |
FK(Gear#casinoGearName) |
|
gearMetadataValue |
text |
Example
vesselName;operationId;gearCode;metadataType;gearMetadataValue THALASSA II;P0422;57x52;CableLength;31.6666666666667
GearCharacteristicValues
Required columns
gear;characteristic;dataValue
Columns formats
|
Colonne |
Type |
|---|---|
|
gear |
FK(Gear#casinoGearName) |
|
characteristic |
FK(GearCharacteristic#name) |
|
dataValue |
text |
Example
gear;characteristic;dataValue casinoName;characteristicName;33
TotalSample / SubSample / BiometrySample
TotalSample
Required columns
operationId;baracoudaCode;sizeCategory;sampleWeight;numberSampled;meanLength;meanWeight;noPerKg;sortedWeight
Columns formats
|
Column |
Type |
|---|---|
|
operationId |
FK(Operation#id) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
sizeCategory |
FK(SizeCategory#name) |
|
sampleWeight |
(float) |
|
numberSampled |
(Integer-NA) |
|
meanLength |
(Float-NA) |
|
meanWeight |
(Float-NA) |
|
noPerKg |
(Float-NA) |
|
sortedWeight |
(float) |
Example
operationId;baracoudaCode;sizeCategory;sampleWeight;numberSampled;meanLength;meanWeight;noPerKg;sortedWeight P0435;ALLO-TEZ;0;0.21;36;6.4;6;166.66;0.03
SubSample
Required columns
operationId;baracoudaCode;sizeCategory;sexCategory;sampleWeight;numberSampled;lengthClass;numberAtLength;weightAtLength;round
Columns formats
|
Column |
Type |
|---|---|
|
operationId |
FK(Operation#id) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
sizeCategory |
FK(SizeCategory#name) |
|
sexCategory |
FK(SexCategory#name) |
|
sampleWeight |
(float) |
|
numberSampled |
(int) |
|
numberAtLength |
(float) |
|
weightAtLength |
(Float-NA) |
|
lengthClass |
text |
(ignored columns) subHaul round
Example
operationId;baracoudaCode;sizeCategory;sexCategory;sampleWeight;numberSampled;lengthClass;numberAtLength;weightAtLength;units;round P0372;ENGR-ENC;0;N;3.37;198;12;7;0.08;0;5
BiometrySample
Required columns
operationId;baracoudaCode;numFish;dataLabel;dataValue;name;sizeCategory
Columns formats
|
Column |
Type |
|---|---|
|
operationId |
FK(Operation#id) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
numFish |
(int) |
|
name |
FK(SampleDataType#name) |
|
dataLabel |
text |
|
dataValue |
(Float-NA) |
|
sizeCategory |
FK(SizeCategory#name) |
Example
operationId;baracoudaCode;numFish;dataLabel;dataValue;name;sizeCategory P5002;ENGR-ENC;9394;NA;-1;Age;0
Acoustic (voyage or mooring)
Acoustic
Required columns
MOVIES_EILayer;MOVIES_EILayer\sndset;MOVIES_EILayer\sndset\sndname;MOVIES_EILayer\sndset\sndident;MOVIES_EILayer\sndset\softChannelId;MOVIES_EILayer\sndset\channelName;MOVIES_EILayer\sndset\dataType;MOVIES_EILayer\sndset\beamType;MOVIES_EILayer\sndset\acousticFrequency;MOVIES_EILayer\sndset\startSample;MOVIES_EILayer\sndset\mainBeamAlongSteeringAngle;MOVIES_EILayer\sndset\mainBeamAthwartSteeringAngle;MOVIES_EILayer\sndset\absorptionCoef;MOVIES_EILayer\sndset\transmissionPower;MOVIES_EILayer\sndset\beamAlongAngleSensitivity;MOVIES_EILayer\sndset\beamAthwartAngleSensitivity;MOVIES_EILayer\sndset\beam3dBWidthAlong;MOVIES_EILayer\sndset\beam3dBWidthAthwart;MOVIES_EILayer\sndset\beamEquTwoWayAngle;MOVIES_EILayer\sndset\beamGain;MOVIES_EILayer\sndset\beamSACorrection;MOVIES_EILayer\sndset\bottomDetectionMinDepth;MOVIES_EILayer\sndset\bottomDetectionMaxDepth;MOVIES_EILayer\sndset\bottomDetectionMinLevel;MOVIES_EILayer\sndset\AlongTXRXWeightId;MOVIES_EILayer\sndset\AthwartTXRXWeightId;MOVIES_EILayer\sndset\SplitBeamAlongTXRXWeightId;MOVIES_EILayer\sndset\SplitBeamAthwartTXRXWeightId;MOVIES_EILayer\sndset\bandWidth;MOVIES_EILayer\sndset\tvgminrange;MOVIES_EILayer\sndset\tvgmaxrange;MOVIES_EILayer\sndset\pulseduration;MOVIES_EILayer\shipnav;MOVIES_EILayer\shipnav\lat;MOVIES_EILayer\shipnav\long;MOVIES_EILayer\shipnav\alt;MOVIES_EILayer\shipnav\gndspeed;MOVIES_EILayer\shipnav\gndcourse;MOVIES_EILayer\shipnav\surfspeed;MOVIES_EILayer\shipnav\surfcourse;MOVIES_EILayer\shipnav\driftspeed;MOVIES_EILayer\shipnav\driftcourse;MOVIES_EILayer\shipnav\heading;MOVIES_EILayer\shipnav\roll;MOVIES_EILayer\shipnav\pitch;MOVIES_EILayer\shipnav\heave;MOVIES_EILayer\shipnav\depth;MOVIES_EILayer\shipnav\draught;MOVIES_EILayer\cellset;MOVIES_EILayer\cellset\cellnum;MOVIES_EILayer\cellset\celltype;MOVIES_EILayer\cellset\depthstart;MOVIES_EILayer\cellset\depthend;MOVIES_EILayer\cellset\indexstart;MOVIES_EILayer\cellset\indexend;MOVIES_EILayer\cellset\datestart;MOVIES_EILayer\cellset\dateend;MOVIES_EILayer\cellset\lat;MOVIES_EILayer\cellset\long;MOVIES_EILayer\cellset\volume;MOVIES_EILayer\cellset\area;MOVIES_EILayer\cellset\diststart;MOVIES_EILayer\cellset\distend;MOVIES_EILayer\cellset\thresholdup;MOVIES_EILayer\cellset\thresholdlow;MOVIES_EILayer\eilayer;MOVIES_EILayer\eilayer\sa;MOVIES_EILayer\eilayer\sv;MOVIES_EILayer\eilayer\ni;MOVIES_EILayer\eilayer\nt;MOVIES_EILayer\boterr;MOVIES_EILayer\boterr\sa;MOVIES_EILayer\boterr\ni;MOVIES_EILayer\sndset\soundcelerity;dataQuality;label
Columns formats
|
Column |
Type |
|---|---|
|
MOVIES_EILayer |
text //A |
|
MOVIES_EILayer\sndset |
(unused) //B |
|
MOVIES_EILayer\sndset\sndname |
(unused) //C |
|
MOVIES_EILayer\sndset\sndident |
(unused) //D |
|
MOVIES_EILayer\sndset\softChannelId |
FK(AcousticInstrument#id) //E |
|
MOVIES_EILayer\sndset\channelName |
(unused) //F |
|
MOVIES_EILayer\sndset\dataType |
(unused) //G |
|
MOVIES_EILayer\sndset\beamType |
(unused) //H |
|
MOVIES_EILayer\sndset\acousticFrequency |
(unused) //I |
|
MOVIES_EILayer\sndset\startSample |
(unused) //J |
|
MOVIES_EILayer\sndset\mainBeamAlongSteeringAngle |
(unused) //K |
|
MOVIES_EILayer\sndset\mainBeamAthwartSteeringAngle |
(unused) //L |
|
MOVIES_EILayer\sndset\absorptionCoef |
(Float-NA) //M |
|
MOVIES_EILayer\sndset\transmissionPower |
(int) //N |
|
MOVIES_EILayer\sndset\beamAlongAngleSensitivity |
(Float) //O |
|
MOVIES_EILayer\sndset\beamAthwartAngleSensitivity |
(Float) //P |
|
MOVIES_EILayer\sndset\beam3dBWidthAlong |
(unused) //Q |
|
MOVIES_EILayer\sndset\beam3dBWidthAthwart |
(unused) //R |
|
MOVIES_EILayer\sndset\beamEquTwoWayAngle |
(Float) //S |
|
MOVIES_EILayer\sndset\beamGain |
(Float) //T |
|
MOVIES_EILayer\sndset\beamSACorrection |
(Float) //U |
|
MOVIES_EILayer\sndset\bottomDetectionMinDepth |
(unused) //V |
|
MOVIES_EILayer\sndset\bottomDetectionMaxDepth |
(unused) //W |
|
MOVIES_EILayer\sndset\bottomDetectionMinLevel |
(unused) //X |
|
MOVIES_EILayer\sndset\AlongTXRXWeightId |
(unused) //Y |
|
MOVIES_EILayer\sndset\AthwartTXRXWeightId |
(unused) //Z |
|
MOVIES_EILayer\sndset\SplitBeamAlongTXRXWeightId |
(unused) //AA |
|
MOVIES_EILayer\sndset\SplitBeamAthwartTXRXWeightId |
(unused) //AB |
|
MOVIES_EILayer\sndset\bandWidth |
(unused) //AC |
|
MOVIES_EILayer\sndset\tvgminrange |
(unused) //AD |
|
MOVIES_EILayer\sndset\tvgmaxrange |
(unused) //AE |
|
MOVIES_EILayer\sndset\pulseduration |
(Float) //AF |
|
MOVIES_EILayer\shipnav |
(unused) //AG |
|
MOVIES_EILayer\shipnav\lat |
(unused) //AH |
|
MOVIES_EILayer\shipnav\long |
(unused) //AI |
|
MOVIES_EILayer\shipnav\alt |
(unused) //AJ |
|
MOVIES_EILayer\shipnav\gndspeed |
(unused) //AK |
|
MOVIES_EILayer\shipnav\gndcourse |
(unused) //AL |
|
MOVIES_EILayer\shipnav\surfspeed |
(unused) //AM |
|
MOVIES_EILayer\shipnav\surfcourse |
(unused) //AN |
|
MOVIES_EILayer\shipnav\driftspeed |
(unused) //AO |
|
MOVIES_EILayer\shipnav\driftcourse |
(unused) //AP |
|
MOVIES_EILayer\shipnav\heading |
(unused) //AQ |
|
MOVIES_EILayer\shipnav\roll |
(unused) //AR |
|
MOVIES_EILayer\shipnav\pitch |
(unused) //AS |
|
MOVIES_EILayer\shipnav\heave |
(unused) //AT |
|
MOVIES_EILayer\shipnav\depth |
text //AU |
|
MOVIES_EILayer\shipnav\draught |
(unused) //AV |
|
MOVIES_EILayer\cellset |
(unused) //AW |
|
MOVIES_EILayer\cellset\cellnum |
(int) //AX |
|
MOVIES_EILayer\cellset\celltype |
(int) //AY |
|
MOVIES_EILayer\cellset\depthstart |
(float) //AZ |
|
MOVIES_EILayer\cellset\depthend |
(float) //BA |
|
MOVIES_EILayer\cellset\indexstart |
(unused) //BB |
|
MOVIES_EILayer\cellset\indexend |
(unused) //BC |
|
MOVIES_EILayer\cellset\datestart |
(date) //BD |
|
MOVIES_EILayer\cellset\dateend |
(date) //BE |
|
MOVIES_EILayer\cellset\lat |
(Float) //BF |
|
MOVIES_EILayer\cellset\long |
(Float) //BG |
|
MOVIES_EILayer\cellset\volume |
(Integer-NA) //BH |
|
MOVIES_EILayer\cellset\area |
(int) //BI |
|
MOVIES_EILayer\cellset\diststart |
(unused) //BJ |
|
MOVIES_EILayer\cellset\distend |
(unused) //BK |
|
MOVIES_EILayer\cellset\thresholdup |
(int) //BL |
|
MOVIES_EILayer\cellset\thresholdlow |
(int) //BM |
|
MOVIES_EILayer\eilayer |
(unused) //BN |
|
MOVIES_EILayer\eilayer\sa |
(Float-NA) //BO |
|
MOVIES_EILayer\eilayer\sv |
(unused) //BP |
|
MOVIES_EILayer\eilayer\ni |
(Integer-NA) //BQ |
|
MOVIES_EILayer\eilayer\nt |
(Integer-NA) //BR |
|
MOVIES_EILayer\boterr |
(unused) //BR |
|
MOVIES_EILayer\boterr\sa |
(unused) //BT |
|
MOVIES_EILayer\boterr\ni |
(unused) //BU |
|
MOVIES_EILayer\sndset\soundcelerity |
text //BV |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) //E |
|
label |
text //BW |
Important
- You have to sort the line on the date (MOVIES_EILayer) and on the cell number (MOVIES_EILayer\cellset\cellnum).
Example
MOVIES_EILayer;MOVIES_EILayer\sndset;MOVIES_EILayer\sndset\sndname;MOVIES_EILayer\sndset\sndident;MOVIES_EILayer\sndset\softChannelId;MOVIES_EILayer\sndset\channelName;MOVIES_EILayer\sndset\dataType;MOVIES_EILayer\sndset\beamType;MOVIES_EILayer\sndset\acousticFrequency;MOVIES_EILayer\sndset\startSample;MOVIES_EILayer\sndset\mainBeamAlongSteeringAngle;MOVIES_EILayer\sndset\mainBeamAthwartSteeringAngle;MOVIES_EILayer\sndset\absorptionCoef;MOVIES_EILayer\sndset\transmissionPower;MOVIES_EILayer\sndset\beamAlongAngleSensitivity;MOVIES_EILayer\sndset\beamAthwartAngleSensitivity;MOVIES_EILayer\sndset\beam3dBWidthAlong;MOVIES_EILayer\sndset\beam3dBWidthAthwart;MOVIES_EILayer\sndset\beamEquTwoWayAngle;MOVIES_EILayer\sndset\beamGain;MOVIES_EILayer\sndset\beamSACorrection;MOVIES_EILayer\sndset\bottomDetectionMinDepth;MOVIES_EILayer\sndset\bottomDetectionMaxDepth;MOVIES_EILayer\sndset\bottomDetectionMinLevel;MOVIES_EILayer\sndset\AlongTXRXWeightId;MOVIES_EILayer\sndset\AthwartTXRXWeightId;MOVIES_EILayer\sndset\SplitBeamAlongTXRXWeightId;MOVIES_EILayer\sndset\SplitBeamAthwartTXRXWeightId;MOVIES_EILayer\sndset\bandWidth;MOVIES_EILayer\sndset\tvgminrange;MOVIES_EILayer\sndset\tvgmaxrange;MOVIES_EILayer\sndset\pulseduration;MOVIES_EILayer\shipnav;MOVIES_EILayer\shipnav\lat;MOVIES_EILayer\shipnav\long;MOVIES_EILayer\shipnav\alt;MOVIES_EILayer\shipnav\gndspeed;MOVIES_EILayer\shipnav\gndcourse;MOVIES_EILayer\shipnav\surfspeed;MOVIES_EILayer\shipnav\surfcourse;MOVIES_EILayer\shipnav\driftspeed;MOVIES_EILayer\shipnav\driftcourse;MOVIES_EILayer\shipnav\heading;MOVIES_EILayer\shipnav\roll;MOVIES_EILayer\shipnav\pitch;MOVIES_EILayer\shipnav\heave;MOVIES_EILayer\shipnav\depth;MOVIES_EILayer\shipnav\draught;MOVIES_EILayer\cellset;MOVIES_EILayer\cellset\cellnum;MOVIES_EILayer\cellset\celltype;MOVIES_EILayer\cellset\depthstart;MOVIES_EILayer\cellset\depthend;MOVIES_EILayer\cellset\indexstart;MOVIES_EILayer\cellset\indexend;MOVIES_EILayer\cellset\datestart;MOVIES_EILayer\cellset\dateend;MOVIES_EILayer\cellset\lat;MOVIES_EILayer\cellset\long;MOVIES_EILayer\cellset\volume;MOVIES_EILayer\cellset\area;MOVIES_EILayer\cellset\diststart;MOVIES_EILayer\cellset\distend;MOVIES_EILayer\cellset\thresholdup;MOVIES_EILayer\cellset\thresholdlow;MOVIES_EILayer\eilayer;MOVIES_EILayer\eilayer\sa;MOVIES_EILayer\eilayer\sv;MOVIES_EILayer\eilayer\ni;MOVIES_EILayer\eilayer\nt;MOVIES_EILayer\boterr;MOVIES_EILayer\boterr\sa;MOVIES_EILayer\boterr\ni;MOVIES_EILayer\sndset\soundcelerity;dataQuality;label 2011/06/23 10:09:00.0000;NA;NA;NA;47;38000;NA;NA;NA;NA;NA;NA;8.47;2000;21.8;21.8;NA;NA;-20.6;25.27;-0.529999;NA;NA;NA;NA;NA;NA;NA;NA;NA;NA;1.024;NA;NA;NA;NA;NA;NA;NA;NA;NA;NA;NA;NA;NA;NA;199.9;NA;NA;0;0;10;20;NA;NA;2011-04-26 08:24:02.0000;2011-04-26 08:30:02.0000;43.666505;-3.48812666666667;NA;1;NA;NA;0;-60;NA;1.444008;NA;71;43424;NA;NA;NA;variable;1;0
Calibration
Required columns
topiaId;accuracyEstimate;aquisitionMethod;comments;date;processingMethod;report;acousticInstrument
Columns format
|
Column |
Type |
|---|---|
|
topiaId |
(ignored column) //A |
|
accuracyEstimate |
text //B |
|
aquisitionMethod |
text //C |
|
comments |
text //D |
|
date |
(date) //E |
|
processingMethod |
text //F |
|
report |
text //G |
|
acousticinstrument |
FK(AcousticInstrument#id) //H |
Notes importantes
- For the calibration to match a trip, the date must be within the trip start-end date period.
Example
accuracyEstimate;aquisitionMethod;comments;date;processingMethod;report;acousticInstrument ;0.26;ER60;Mission PELGAS2015 - 30 avril 2015;2015-04-30 07:00:00;ER60;http://madida/madida/documents/etalonnage/TL_EK60_etalonnage_avril2015__v1.html;47
Results per voyage
Echotype
Required columns
voyage;echotypeName;depthStratumId;meaning;baracoudaCode;id
Columns formats
|
Column |
Type |
|---|---|
|
echotypeName |
text |
|
meaning |
text |
|
voyage |
FK(Voyage#name) |
|
depthStratumId |
FK(DepthStratum#id) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
id |
integer (species category code |
Example
voyage;echotypeName;depthStratumId;meaning;baracoudaCode;id PELGAS2011;D1;CLAS;Maquereaux, Chinchards et gadidés présents dans les couches à proximité du fond;COMP-LEM;1
LengthWeightKey
Required columns
voyage;sizeCategory;aParameter;bParameter;baracoudaCode;strata
Columns formats
|
Column |
Type |
|---|---|
|
aParameter |
(float) |
|
bParameter |
(float) |
|
voyage |
FK(Voyage#name) |
|
sizeCategory |
FK(SizeCategory#name) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
strata |
FK(Strata#name) |
Example
voyage;sizeCategory;aParameter;bParameter;baracoudaCode;strata PELGAS2011;0;2.48253468289872;3.37866337729714;ENGR-ENC;Golfe de Gascogne
LengthAgeKey
Required columns
voyage;baracoudaCode;age;length;percentAtAge;metadata;strata
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
age |
(int) |
|
length |
(float) |
|
percentAtAge |
(float) |
|
metadata |
text |
|
strata |
FK(Strata#name) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
Example
voyage;baracoudaCode;age;length;percentAtAge;metadata;strata PELGAS2011;ENGR-ENC;1;7.5;1;Ifremer reading;Golfe de Gascogne
Results per ESDU for voyage
Esdu / Echotype
Required columns
voyage;name;echotype;NASC;ReferenceStationCatch;dataQuality
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
name |
FK(esdu cell) |
|
echotype |
FK(Echotype#name) |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
méta-données |
FK(DataMetadata#name) (one column per metadata) |
Example
voyage;name;echotype;NASC;ReferenceStationCatch;dataQuality PELGAS2011;2011-04-26 13:29:12.0000_16;D1;0;P0379;1
Esdu / Echotype / Species Category
Required columns
voyage;name;echotype;baracoudaCode;sizeCategory;ReferenceStationCatch;Biomass;MeanLength;MeanWeight;Abundance;SigmaSp;NASC;pondBiomass;pondAbundance;dataQuality
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
name |
FK(esdu cell) |
|
echotype |
FK(Echotype#name) |
|
sizeCategory |
FK(SizeCategory#name) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
méta-données |
FK(DataMetadata#name) (one column per metadata) |
Example
voyage;name;echotype;baracoudaCode;sizeCategory;ReferenceStationCatch;Biomass;MeanLength;MeanWeight;Abundance;SigmaSp;NASC;pondBiomass;pondAbundance;dataQuality PELGAS2011;2011-04-26 13:29:12.0000_16;D1;COMP-LEM;0;4;0;20;0.05;0;0.00100292822891053;0;0;0;1
Esdu / Echotype / Species Category / Length
Required columns
name;echotype;baracoudaCode;lengthClass;sizeCategory;Biomass;Abundance;lengthClassMeaning;dataQuality;voyage
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
name |
FK(esdu cell) |
|
echotype |
FK(Echotype#name) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
lengthClass |
(float) |
|
sizeCategory |
text |
|
lengthClassMeaning |
text |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
méta-données |
FK(DataMetadata#name) (one column per metadata) |
Example
name;echotype;baracoudaCode;lengthClass;sizeCategory;Biomass;Abundance;lengthClassMeaning;dataQuality;voyage 2011-04-26 13:35:19.0000_16;D1;COMP-LEM;10.5;4;5190.7652880528;1297691.3220132;mid point of 1 cm size bin;1;PELGAS2011
Esdu / Species / Age Category
Required columns
name;baracoudaCode;ageCategory;Abundance;ageCategoryMeaning;dataQuality;voyage
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
name |
FK(esdu cell) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
ageCategory |
text |
|
ageCategoryMeaning |
text |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
méta-données |
FK(DataMetadata#name) (one column per metadata) |
Example
name;baracoudaCode;ageCategory;Abundance;ageCategoryMeaning;dataQuality;voyage 2011-04-26 13:35:19.0000_16;ENGR-ENC;3;3377.00492644042;fish age-group (years);1;PELGAS2011
Region
Required columns
voyage;name;cellType;regionEnvCoordinates;surface;dataQuality
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
cellType |
FK(CellType) |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
name |
text |
|
regionEnvCoordinates |
text |
|
surface |
(float) |
Example
voyage;name;cellType;regionEnvCoordinates;surface;dataQuality PELGAS2011;1;RegionCLAS;-1.40644893137726 43.8651260867463 50;1224.75678263326;1
Region Association
Required columns
voyage;regionName;esduName
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage) |
|
regionName |
FK(Cell#name) |
|
esduName |
FK(Cell#name) |
Important
- You have to sort the line on the regionName.
Example
voyage;regionName;esduName PELGAS2011;1;2011-05-02 09:36:54.0000_16
Results per regions
Required columns
voyage;name;baracoudaCode;sizeCategory;echotype;VarianceXe;VarianceNASC;MeanXe;MeanNASC;NASCWeightedMeanXe;Nesdu;Nhauls;MeanNASCWeightedBiomassDensity;NASCWeightedEstimationVariance;NASCWeightedEstimationCV;MeanBiomassDensity;EstimationVariance;EstimationCV;TotalEstimationVariance;TotalNASCWeightedEstimationVariance;ProportionOfTotalEstimationVariance;ProportionOfNASCWeightedTotalEstimationVariance;Biomass;NASCWeightedBiomass;dataQuality
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
name |
FK(Cell#name) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
echotype |
FK(Echotype#name) |
|
sizeCategory |
FK(SizeCategory#name) |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
méta-données |
FK(DataMetadata#name) (one column per metadata) |
Example
voyage;name;baracoudaCode;sizeCategory;echotype;VarianceXe;VarianceNASC;MeanXe;MeanNASC;NASCWeightedMeanXe;Nesdu;Nhauls;MeanNASCWeightedBiomassDensity;NASCWeightedEstimationVariance;NASCWeightedEstimationCV;MeanBiomassDensity;EstimationVariance;EstimationCV;TotalEstimationVariance;TotalNASCWeightedEstimationVariance;ProportionOfTotalEstimationVariance;ProportionOfNASCWeightedTotalEstimationVariance;Biomass;NASCWeightedBiomass;dataQuality PELGAS2011;6;CLUP-HAR;0;D2;NA;8963.28501789053;0.127534943481966;19.0945142790179;0.127534943481966;448;1;2.43521779939014;NA;NA;2.43521779939014;NA;NA;0;0;NA;NA;14380.2052341515;14380.2052341515;1
Map
Required columns
voyage;name;baracoudaCode;sizeCategory;ageCategory;gridCellLongitude;gridCellLatitude;gridCellDepth;gridLongitudeLag;gridLatitudeLag;gridDepthLag;KrigedXe;dataQuality
Columns formats
|
Column |
Type |
|---|---|
|
voyage |
FK(Voyage#name) |
|
name |
text |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
sizeCategory |
FK(SizeCategory#name) |
|
ageCategory |
FK(AgeCategory#name) |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
gridCellLongitude |
(float) |
|
gridCellLatitude |
(float) |
|
gridCellDepth |
(float) |
|
gridLongitudeLag |
(float) |
|
gridLatitudeLag |
(float) |
|
gridDepthLag |
(float) |
|
metadata |
FK(DataMetadata#name) (one column per metadata) |
Important
- You have to sort the line on the name.
Example
voyage;name;baracoudaCode;sizeCategory;ageCategory;gridCellLongitude;gridCellLatitude;gridCellDepth;gridLongitudeLag;gridLatitudeLag;gridDepthLag;KrigedXe;dataQuality PELGAS2011;-6 43.5 0;ENGR-ENC;0;;-6;43.5;0;0.25;0.25;0;0;1
Mooring
Required columns
mission;code;description;depth;northLimit;eastLimit;southLimit;upLimit;downLimit;units;zunits;projection;deploymentDate;retrievalDate;siteName;operator;comments
Columns formats
|
Colonne |
Type |
|---|---|
|
mission |
FK(Mission#name) |
|
code |
text |
|
description |
text |
|
depth |
(float) |
|
northLimit |
(float) |
|
eastLimit |
(float) |
|
southLimit |
(float) |
|
upLimit |
(float) |
|
downLimit |
(float) |
|
units |
text |
|
zunits |
text |
|
projection |
text |
|
deploymentDate |
(date) |
|
retrievalDate |
(date) |
|
siteName |
text |
|
operator |
text |
|
comments |
text |
Example
mission;code;description;depth;northLimit;eastLimit;southLimit;upLimit;downLimit;units;zunits;projection;deploymentDate;retrievalDate;siteName;operator;comments PELGAS;MOORING1;Mooring 1;1;1.1;1.2;1.3;1.4;1.5;m;m;None;26-04-2011 08:00:00.0000;04-06-2011 08:00:00.0000;CodeLutin;Moi;RAS
Ancillary instrumentation
Required columns
mooring;ancillaryInstrumentation
Columns formats
|
Column |
Type |
|---|---|
|
mooring |
FK(Mooring#code) |
|
ancillaryInstrumentation |
FK(AncillaryInstrumentation#name) |
Example
mooring;ancillaryInstrumentation MOORING1;Inst1
Results per mooring
Echotype
Required columns
mooring;echotypeName;depthStratumId;meaning;baracoudaCode
Columns formats
|
Column |
Type |
|---|---|
|
echotypeName |
text |
|
meaning |
text |
|
mooring |
FK(Mooring#code) |
|
depthStratumId |
FK(DepthStratum#id) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
Example
mooring;echotypeName;depthStratumId;meaning;baracoudaCode MOORING1;D1;CLAS;Maquereaux, Chinchards et gadidés présents dans les couches à proximité du fond;COMP-LEM
Results per ESDU for mooring
Esdu / Echotype
Required columns
mooring;name;echotype;NASC;ReferenceStationCatch;dataQuality
Columns formats
|
Column |
Type |
|---|---|
|
mooring |
FK(Mooring#code) |
|
name |
FK(esdu cell) |
|
echotype |
FK(Echotype#name) |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
méta-données |
FK(DataMetadata#name) (une colonne par méta à importer) |
Example
mooring;name;echotype;NASC;ReferenceStationCatch;dataQuality MOORING1;2011-04-26 13:29:12.0000_16;D1;0;P0379;1
Esdu / Echotype / Species Category
Required columns
mooring;name;echotype;baracoudaCode;sizeCategory;ReferenceStationCatch;Biomass;MeanLength;MeanWeight;Abundance;SigmaSp;NASC;pondBiomass;pondAbundance;dataQuality
Columns formats
|
Column |
Type |
|---|---|
|
mooring |
FK(Mooring#code) |
|
name |
FK(esdu cell) |
|
echotype |
FK(Echotype#name) |
|
sizeCategory |
FK(SizeCategory#name) |
|
baracoudaCode |
FK(Species#baracoudaCode) |
|
dataQuality |
FK(DataQuality#qualityDataFlagValues) |
|
méta-données |
FK(DataMetadata#name) (une colonne par méta à importer) |
Example
voyage;name;echotype;baracoudaCode;sizeCategory;ReferenceStationCatch;Biomass;MeanLength;MeanWeight;Abundance;SigmaSp;NASC;pondBiomass;pondAbundance;dataQuality MOORING1;2011-04-26 13:29:12.0000_16;D1;COMP-LEM;0;4;0;20;0.05;0;0.00100292822891053;0;0;0;1