Author: tchemit Date: 2013-07-15 15:07:35 +0200 (Mon, 15 Jul 2013) New Revision: 823 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/823 Log: fixes #2250: Param?\195?\168tres manquants dans la doc d'import de donn?\195?\169es Modified: trunk/src/site/en/rst/importData.rst trunk/src/site/rst/importData.rst Modified: trunk/src/site/en/rst/importData.rst =================================================================== --- trunk/src/site/en/rst/importData.rst 2013-07-15 08:32:35 UTC (rev 822) +++ trunk/src/site/en/rst/importData.rst 2013-07-15 13:07:35 UTC (rev 823) @@ -29,26 +29,39 @@ Abstract ======== + Ce document donne la définition de tous les imports de données. -*TODO Translate me* - Format des colonnes ~~~~~~~~~~~~~~~~~~~ -- FK(XXX#yyy) désigne une clef étrangère requise (XXX sur la propriété yyy). -- (int) un entier (pas du nullité possible) -- (float) un décimal (pas de nullité possible) -- (Integer) un entier avec nullité possible -- (Integer-NA) un entier avec nullité possible (et nullité si NA) -- Float un décimale avec nullité possible -- (Float-NA) un décimale avec nullité possible (et nullité si NA) -- (date) unique format de date : *yyyy-MM-dd HH:mm:ss.SSSS* -- (esdu cell) nom de cellule esdu - elementary : esduName[_elementaryCellName] - avec esdu name au format yyyy-MM-dd HH:mm:ss.SSSS ++---------------+--------------------------------------------------------------+ +| Notation | Type | ++===============+==============================================================+ +| text |une chaine de caractères | ++---------------+--------------------------------------------------------------+ +| FK(XXX#yyy) |désigne une clef étrangère requise (XXX sur la propriété yyy).| ++---------------+--------------------------------------------------------------+ +| (int) |un entier (pas du nullité possible) | ++---------------+--------------------------------------------------------------+ +| (float) |un décimal (pas de nullité possible) | ++---------------+--------------------------------------------------------------+ +| (Integer) |un entier avec nullité possible | ++---------------+--------------------------------------------------------------+ +| (Integer-NA) |un entier avec nullité possible (et nullité si NA) | ++---------------+--------------------------------------------------------------+ +| Float |un décimale avec nullité possible | ++---------------+--------------------------------------------------------------+ +| (Float-NA) |un décimale avec nullité possible (et nullité si NA) | ++---------------+--------------------------------------------------------------+ +| (date) |unique format de date : *yyyy-MM-dd HH:mm:ss.SSSS* | ++---------------+--------------------------------------------------------------+ +| (esdu cell) |nom de cellule esdu elementary : esduName[_elementaryCellName]| +| | avec esdu name au format yyyy-MM-dd HH:mm:ss.SSSS | ++---------------+--------------------------------------------------------------+ -Note importantes -~~~~~~~~~~~~~~~~ +Notes importantes +~~~~~~~~~~~~~~~~~ - Le nom des colonnes est sensible à la casse, il faut donc bien respecter les noms donnés dans cette page. @@ -73,11 +86,19 @@ Format des colonnes ------------------- -- name -- startDate (date) -- endDate (date) -- startPort -- endPort ++------------+------+ +| Colonne | Type | ++============+======+ +| name |text | ++------------+------+ +| startDate |(date)| ++------------+------+ +| endDate |(date)| ++------------+------+ +| startPort |text | ++------------+------+ +| endPort |text | ++------------+------+ Exemple ------- @@ -100,12 +121,21 @@ Format des colonnes ------------------- -- voyage FK(voyage#name) -- description -- startTime (date) -- endTime (date) -- startLocality -- endLocality ++----------------+---------------+ +| Colonne | Type | ++================+===============+ +| voyage |FK(voyage#name)| ++----------------+---------------+ +| description |text | ++----------------+---------------+ +| startTime |(date) | ++----------------+---------------+ +| endTime |(date) | ++----------------+---------------+ +| startLocality |text | ++----------------+---------------+ +| endLocality |text | ++----------------+---------------+ Exemple ------- @@ -128,22 +158,41 @@ Format des colonnes ------------------- -- voyage FK(voyage#name) -- vesselName FK(Vessel#name) -- title -- transectAbstract -- stratum -- comment -- dateCreated (date) -- timeCoverageStart (date) -- timeCoverageEnd (date) -- geospatialLonMin (float) -- geospatialLonMax (float) -- geospatialLatMin (float) -- geospatialLatMax (float) -- geospatialVerticalMin (float) -- geospatialVerticalMax (float) -- linestring ++------------------------+---------------+ +| Colonne | Type | ++========================+===============+ +| voyage |FK(voyage#name)| ++------------------------+---------------+ +| vesselName |FK(Vessel#name)| ++------------------------+---------------+ +| title |text | ++------------------------+---------------+ +| transectAbstract |text | ++------------------------+---------------+ +| stratum |text | ++------------------------+---------------+ +| comment |text | ++------------------------+---------------+ +| dateCreated |(date) | ++------------------------+---------------+ +| timeCoverageStart |(date) | ++------------------------+---------------+ +| timeCoverageEnd |(date) | ++------------------------+---------------+ +| geospatialLonMin |(float) | ++------------------------+---------------+ +| geospatialLonMax |(float) | ++------------------------+---------------+ +| geospatialLatMin |(float) | ++------------------------+---------------+ +| geospatialLatMax |(float) | ++------------------------+---------------+ +| geospatialVerticalMin |(float) | ++------------------------+---------------+ +| geospatialVerticalMax |(float) | ++------------------------+---------------+ +| linestring |text | ++------------------------+---------------+ Exemple ------- @@ -169,18 +218,33 @@ Format des colonnes ------------------- -- vesselName FK(Vessel#name) -- gearCode FK(Gear#casinoGearName) -- depthStratumId FK(DepthStratum#id) -- operationId -- midHaulLatitude (float) -- midHaulLongitude (float) -- gearShootingStartTime (date) -- gearShootingEndTime (date) -- gearShootingStartLatitude (float) -- gearShootingEndLatitude (float) -- gearShootingStartLongitude (float) -- gearShootingEndLongitude (float) ++-----------------------------+-----------------------+ +| Colonne | 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) | ++-----------------------------+-----------------------+ +| gearShootingEndLatitude |(float) | ++-----------------------------+-----------------------+ +| gearShootingStartLongitude |(float) | ++-----------------------------+-----------------------+ +| gearShootingEndLongitude |(float) | ++-----------------------------+-----------------------+ Exemple ------- @@ -203,10 +267,17 @@ Format des colonnes ------------------- -- vesselName FK(Vessel#name) -- operationId FK(Operation#id) -- metadataType FK(OperationMetadata#name) -- operationMetadataValue ++-------------------------+--------------------------+ +| Colonne | Type | ++=========================+==========================+ +| vesselName |FK(Vessel#name) | ++-------------------------+--------------------------+ +| operationId |FK(Operation#id) | ++-------------------------+--------------------------+ +| metadataType |FK(OperationMetadata#name)| ++-------------------------+--------------------------+ +| operationMetadataValue |text | ++-------------------------+--------------------------+ Exemple ------- @@ -229,11 +300,19 @@ Format des colonnes ------------------- -- vesselName FK(Vessel#name) -- operationId FK(Operation#id) -- metadataType FK(GearMetadata#name) -- gearCode FK(Gear#casinoGearName) -- gearMetadataValue ++---------------------+-----------------------+ +| Colonne | Type | ++=====================+=======================+ +| vesselName |FK(Vessel#name) | ++---------------------+-----------------------+ +| operationId |FK(Operation#id) | ++---------------------+-----------------------+ +| metadataType |FK(GearMetadata#name) | ++---------------------+-----------------------+ +| gearCode |FK(Gear#casinoGearName)| ++---------------------+-----------------------+ +| gearMetadataValue |text | ++---------------------+-----------------------+ Exemple ------- @@ -259,15 +338,27 @@ Format des colonnes ------------------- -- 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) ++-----------------+-------------------------+ +| Colonne | 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) | ++-----------------+-------------------------+ Exemple ------- @@ -290,15 +381,27 @@ Format des colonnes ------------------- -- 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 ++------------------+-------------------------+ +| Colonne | 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 | ++------------------+-------------------------+ (colonnes ignorées) subHaul units round @@ -323,12 +426,21 @@ Format des colonnes ------------------- -- operationId FK(Operation#id) -- baracoudaCode FK(Species#baracoudaCode) -- numFish (int) -- name FK(SampleDataType#name) -- dataLabel -- dataValue (Float-NA) ++----------------+--------------------------+ +| Colonne | Type | ++================+==========================+ +| operationId |FK(Operation#id) | ++----------------+--------------------------+ +| baracoudaCode |FK(Species#baracoudaCode) | ++----------------+--------------------------+ +| numFish |(int) | ++----------------+--------------------------+ +| name |FK(SampleDataType#name) | ++----------------+--------------------------+ +| dataLabel |text | ++----------------+--------------------------+ +| dataValue |(Float-NA) | ++----------------+--------------------------+ Exemple ------- @@ -350,9 +462,160 @@ Format des colonnes ------------------- ++---------------------------------------------------------+-----------------------------------------+ +| Colonne | Type | ++=========================================================+=========================================+ +| MOVIES_EILayer |text //A| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset |(colonne ignorée) //B| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\sndname |(colonne ignorée) //C| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\sndident |(colonne ignorée) //D| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\softChannelId |FK(AcousticInstrument#id) //E| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\channelName |(colonne ignorée) //F| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\dataType |(colonne ignorée) //G| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamType |(colonne ignorée) //H| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\acousticFrequency |(colonne ignorée) //I| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\startSample |(colonne ignorée) //J| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\mainBeamAlongSteeringAngle |(colonne ignorée) //K| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\mainBeamAthwartSteeringAngle |(colonne ignorée) //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 |(colonne ignorée) //Q| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beam3dBWidthAthwart |(colonne ignorée) //R| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamEquTwoWayAngle |(Float) //S| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamGain |(Float) //T| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamSACorrection |(Float) //U| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bottomDetectionMinDepth |(colonne ignorée) //V| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bottomDetectionMaxDepth |(colonne ignorée) //W| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bottomDetectionMinLevel |(colonne ignorée) //X| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\AlongTXRXWeightId |(colonne ignorée) //Y| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\AthwartTXRXWeightId |(colonne ignorée) //Z| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\SplitBeamAlongTXRXWeightId |(colonne ignorée) //AA| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\SplitBeamAthwartTXRXWeightId |(colonne ignorée) //AB| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bandWidth |(colonne ignorée) //AC| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\tvgminrange |(colonne ignorée) //AD| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\tvgmaxrange |(colonne ignorée) //AE| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\pulseduration |(Float) //AF| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav |(colonne ignorée) //AG| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\lat |(colonne ignorée) //AH| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\long |(colonne ignorée) //AI| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\alt |(colonne ignorée) //AJ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\gndspeed |(colonne ignorée) //AK| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\gndcourse |(colonne ignorée) //AL| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\surfspeed |(colonne ignorée) //AM| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\surfcourse |(colonne ignorée) //AN| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\driftspeed |(colonne ignorée) //AO| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\driftcourse |(colonne ignorée) //AP| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\heading |(colonne ignorée) //AQ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\roll |(colonne ignorée) //AR| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\pitch |(colonne ignorée) //AS| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\heave |(colonne ignorée) //AT| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\depth |text //AU| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\draught |(colonne ignorée) //AV| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset |(colonne ignorée) //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 |(colonne ignorée) //BB| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\indexend |(colonne ignorée) //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 |(colonne ignorée) //BJ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\distend |(colonne ignorée) //BK| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\thresholdup |(int) //BL| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\thresholdlow |(int) //BM| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer |(colonne ignorée) //BN| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\sa |(Float-NA) //BO| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\sv |(colonne ignorée) //BP| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\ni |(Integer-NA) //BQ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\nt |(Integer-NA) //BR| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\boterr |(colonne ignorée) //BR| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\boterr\\sa |(colonne ignorée) //BT| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\boterr\\ni |(colonne ignorée) //BU| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\soundcelerity |text //BV| ++---------------------------------------------------------+-----------------------------------------+ +| dataQuality |FK(DataQuality#qualityDataFlagValues) //E| ++---------------------------------------------------------+-----------------------------------------+ -A faire... - Exemple ------- @@ -377,11 +640,19 @@ Format des colonnes ------------------- -- echotypeName -- meaning -- voyage FK(Voyage#name) -- depthStratumId FK(DepthStratum#id) -- baracoudaCode FK(Species#baracoudaCode) ++-----------------+-------------------------+ +| Colonne | Type | ++=================+=========================+ +| echotypeName |text | ++-----------------+-------------------------+ +| meaning |text | ++-----------------+-------------------------+ +| voyage |FK(Voyage#name) | ++-----------------+-------------------------+ +| depthStratumId |FK(DepthStratum#id) | ++-----------------+-------------------------+ +| baracoudaCode |FK(Species#baracoudaCode)| ++-----------------+-------------------------+ Exemple ------- @@ -404,12 +675,21 @@ Format des colonnes ------------------- -- aParameter (float) -- bParameter (float) -- voyage FK(Voyage#name) -- sizeCategory FK(SizeCategory#name) -- baracoudaCode FK(Species#baracoudaCode) -- strata FK(Strata#name) ++----------------+-------------------------+ +| Colonne | Type | ++================+=========================+ +| aParameter |(float) | ++----------------+-------------------------+ +| bParameter |(float) | ++----------------+-------------------------+ +| voyage |FK(Voyage#name) | ++----------------+-------------------------+ +| sizeCategory |FK(SizeCategory#name) | ++----------------+-------------------------+ +| baracoudaCode |FK(Species#baracoudaCode)| ++----------------+-------------------------+ +| strata |FK(Strata#name) | ++----------------+-------------------------+ Exemple ------- @@ -432,13 +712,23 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- age (int) -- length (float) -- percentAtAge (float) -- metadata -- strata FK(Strata#name) -- baracoudaCode FK(Species#baracoudaCode) ++----------------+-------------------------+ +| Colonne | Type | ++================+=========================+ +| voyage |FK(Voyage#name) | ++----------------+-------------------------+ +| age |(int) | ++----------------+-------------------------+ +| length |(float) | ++----------------+-------------------------+ +| percentAtAge |(float) | ++----------------+-------------------------+ +| metadata |text | ++----------------+-------------------------+ +| strata |FK(Strata#name) | ++----------------+-------------------------+ +| baracoudaCode |FK(Species#baracoudaCode)| ++----------------+-------------------------+ Exemple ------- @@ -464,11 +754,19 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- 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) ++----------------+-------------------------------------------------------------+ +| Colonne | Type | ++================+=============================================================+ +| voyage |FK(Voyage#name) | ++----------------+-------------------------------------------------------------+ +| 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) | ++----------------+-------------------------------------------------------------+ Exemple ------- @@ -491,13 +789,23 @@ Format des colonnes ------------------- -- 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) (une colonne par méta à importer) ++----------------+-------------------------------------------------------------+ +| Colonne | 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) (une colonne par méta à importer) | ++----------------+-------------------------------------------------------------+ Exemple ------- @@ -520,13 +828,23 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- name FK(esdu cell) -- baracoudaCode FK(Species#baracoudaCode) -- ageCategory -- ageCategoryMeaning -- dataQuality FK(DataQuality#qualityDataFlagValues) -- méta-données FK(DataMetadata#name) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | 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) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple ------- @@ -549,13 +867,23 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- name FK(esdu cell) -- baracoudaCode FK(Species#baracoudaCode) -- sizeCategory -- sizeCategoryMeaning -- dataQuality FK(DataQuality#qualityDataFlagValues) -- méta-données FK(DataMetadata#name) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | Type | ++======================+=======================================================+ +| voyage |FK(Voyage#name) | ++----------------------+-------------------------------------------------------+ +| name |FK(esdu cell) | ++----------------------+-------------------------------------------------------+ +| baracoudaCode |FK(Species#baracoudaCode) | ++----------------------+-------------------------------------------------------+ +| sizeCategory |text | ++----------------------+-------------------------------------------------------+ +| sizeCategoryMeaning |text | ++----------------------+-------------------------------------------------------+ +| dataQuality |FK(DataQuality#qualityDataFlagValues) | ++----------------------+-------------------------------------------------------+ +| méta-données |FK(DataMetadata#name) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple ------- @@ -581,12 +909,21 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- cellType FK(CellType) -- dataQuality FK(DataQuality#qualityDataFlagValues) -- name -- regionEnvCoordinates -- surface (float) ++-----------------------+------------------------------------------------------+ +| Colonne | Type | ++=======================+======================================================+ +| voyage |FK(Voyage#name) | ++-----------------------+------------------------------------------------------+ +| cellType |FK(CellType) | ++-----------------------+------------------------------------------------------+ +| dataQuality |FK(DataQuality#qualityDataFlagValues) | ++-----------------------+------------------------------------------------------+ +| name |text | ++-----------------------+------------------------------------------------------+ +| regionEnvCoordinates |text | ++-----------------------+------------------------------------------------------+ +| surface |(float) | ++-----------------------+------------------------------------------------------+ Exemple ------- @@ -609,9 +946,15 @@ Format des colonnes ------------------- -- voyage FK(Voyage) -- regionName FK(Cell#name) -- esduName FK(Cell#name) ++-----------------------+------------------------------------------------------+ +| Colonne | Type | ++=======================+======================================================+ +| voyage |FK(Voyage) | ++-----------------------+------------------------------------------------------+ +| regionName |FK(Cell#name) | ++-----------------------+------------------------------------------------------+ +| esduName |FK(Cell#name) | ++-----------------------+------------------------------------------------------+ Exemple ------- @@ -634,13 +977,23 @@ Format des colonnes ------------------- -- 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) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | 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) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple ------- @@ -666,19 +1019,35 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- name -- 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) -- méta-données FK(DataMetadata#name) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | 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) | ++----------------------+-------------------------------------------------------+ +| méta-données |FK(DataMetadata#name) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple ------- Modified: trunk/src/site/rst/importData.rst =================================================================== --- trunk/src/site/rst/importData.rst 2013-07-15 08:32:35 UTC (rev 822) +++ trunk/src/site/rst/importData.rst 2013-07-15 13:07:35 UTC (rev 823) @@ -5,7 +5,7 @@ .. * $Id$ .. * $HeadURL$ .. * %% -.. * Copyright (C) 2011 - 2012 Ifremer, Codelutin +.. * Copyright (C) 2011 | 2012 |Ifremer, Codelutin| .. * %% .. * This program is free software: you can redistribute it and/or modify .. * it under the terms of the GNU Affero General Public License as published by @@ -34,19 +34,33 @@ Format des colonnes ~~~~~~~~~~~~~~~~~~~ -- FK(XXX#yyy) désigne une clef étrangère requise (XXX sur la propriété yyy). -- (int) un entier (pas du nullité possible) -- (float) un décimal (pas de nullité possible) -- (Integer) un entier avec nullité possible -- (Integer-NA) un entier avec nullité possible (et nullité si NA) -- Float un décimale avec nullité possible -- (Float-NA) un décimale avec nullité possible (et nullité si NA) -- (date) unique format de date : *yyyy-MM-dd HH:mm:ss.SSSS* -- (esdu cell) nom de cellule esdu - elementary : esduName[_elementaryCellName] - avec esdu name au format yyyy-MM-dd HH:mm:ss.SSSS ++---------------+--------------------------------------------------------------+ +| Notation | Type | ++===============+==============================================================+ +| text |une chaine de caractères | ++---------------+--------------------------------------------------------------+ +| FK(XXX#yyy) |désigne une clef étrangère requise (XXX sur la propriété yyy).| ++---------------+--------------------------------------------------------------+ +| (int) |un entier (pas du nullité possible) | ++---------------+--------------------------------------------------------------+ +| (float) |un décimal (pas de nullité possible) | ++---------------+--------------------------------------------------------------+ +| (Integer) |un entier avec nullité possible | ++---------------+--------------------------------------------------------------+ +| (Integer-NA) |un entier avec nullité possible (et nullité si NA) | ++---------------+--------------------------------------------------------------+ +| Float |un décimale avec nullité possible | ++---------------+--------------------------------------------------------------+ +| (Float-NA) |un décimale avec nullité possible (et nullité si NA) | ++---------------+--------------------------------------------------------------+ +| (date) |unique format de date : *yyyy-MM-dd HH:mm:ss.SSSS* | ++---------------+--------------------------------------------------------------+ +| (esdu cell) |nom de cellule esdu elementary : esduName[_elementaryCellName]| +| | avec esdu name au format yyyy-MM-dd HH:mm:ss.SSSS | ++---------------+--------------------------------------------------------------+ -Note importantes -~~~~~~~~~~~~~~~~ +Notes importantes +~~~~~~~~~~~~~~~~~ - Le nom des colonnes est sensible à la casse, il faut donc bien respecter les noms donnés dans cette page. @@ -71,11 +85,19 @@ Format des colonnes ------------------- -- name -- startDate (date) -- endDate (date) -- startPort -- endPort ++------------+------+ +| Colonne | Type | ++============+======+ +| name |text | ++------------+------+ +| startDate |(date)| ++------------+------+ +| endDate |(date)| ++------------+------+ +| startPort |text | ++------------+------+ +| endPort |text | ++------------+------+ Exemple ------- @@ -98,12 +120,21 @@ Format des colonnes ------------------- -- voyage FK(voyage#name) -- description -- startTime (date) -- endTime (date) -- startLocality -- endLocality ++----------------+---------------+ +| Colonne | Type | ++================+===============+ +| voyage |FK(voyage#name)| ++----------------+---------------+ +| description |text | ++----------------+---------------+ +| startTime |(date) | ++----------------+---------------+ +| endTime |(date) | ++----------------+---------------+ +| startLocality |text | ++----------------+---------------+ +| endLocality |text | ++----------------+---------------+ Exemple ------- @@ -126,22 +157,41 @@ Format des colonnes ------------------- -- voyage FK(voyage#name) -- vesselName FK(Vessel#name) -- title -- transectAbstract -- stratum -- comment -- dateCreated (date) -- timeCoverageStart (date) -- timeCoverageEnd (date) -- geospatialLonMin (float) -- geospatialLonMax (float) -- geospatialLatMin (float) -- geospatialLatMax (float) -- geospatialVerticalMin (float) -- geospatialVerticalMax (float) -- linestring ++------------------------+---------------+ +| Colonne | Type | ++========================+===============+ +| voyage |FK(voyage#name)| ++------------------------+---------------+ +| vesselName |FK(Vessel#name)| ++------------------------+---------------+ +| title |text | ++------------------------+---------------+ +| transectAbstract |text | ++------------------------+---------------+ +| stratum |text | ++------------------------+---------------+ +| comment |text | ++------------------------+---------------+ +| dateCreated |(date) | ++------------------------+---------------+ +| timeCoverageStart |(date) | ++------------------------+---------------+ +| timeCoverageEnd |(date) | ++------------------------+---------------+ +| geospatialLonMin |(float) | ++------------------------+---------------+ +| geospatialLonMax |(float) | ++------------------------+---------------+ +| geospatialLatMin |(float) | ++------------------------+---------------+ +| geospatialLatMax |(float) | ++------------------------+---------------+ +| geospatialVerticalMin |(float) | ++------------------------+---------------+ +| geospatialVerticalMax |(float) | ++------------------------+---------------+ +| linestring |text | ++------------------------+---------------+ Exemple ------- @@ -167,18 +217,33 @@ Format des colonnes ------------------- -- vesselName FK(Vessel#name) -- gearCode FK(Gear#casinoGearName) -- depthStratumId FK(DepthStratum#id) -- operationId -- midHaulLatitude (float) -- midHaulLongitude (float) -- gearShootingStartTime (date) -- gearShootingEndTime (date) -- gearShootingStartLatitude (float) -- gearShootingEndLatitude (float) -- gearShootingStartLongitude (float) -- gearShootingEndLongitude (float) ++-----------------------------+-----------------------+ +| Colonne | 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) | ++-----------------------------+-----------------------+ +| gearShootingEndLatitude |(float) | ++-----------------------------+-----------------------+ +| gearShootingStartLongitude |(float) | ++-----------------------------+-----------------------+ +| gearShootingEndLongitude |(float) | ++-----------------------------+-----------------------+ Exemple ------- @@ -201,10 +266,17 @@ Format des colonnes ------------------- -- vesselName FK(Vessel#name) -- operationId FK(Operation#id) -- metadataType FK(OperationMetadata#name) -- operationMetadataValue ++-------------------------+--------------------------+ +| Colonne | Type | ++=========================+==========================+ +| vesselName |FK(Vessel#name) | ++-------------------------+--------------------------+ +| operationId |FK(Operation#id) | ++-------------------------+--------------------------+ +| metadataType |FK(OperationMetadata#name)| ++-------------------------+--------------------------+ +| operationMetadataValue |text | ++-------------------------+--------------------------+ Exemple ------- @@ -227,11 +299,19 @@ Format des colonnes ------------------- -- vesselName FK(Vessel#name) -- operationId FK(Operation#id) -- metadataType FK(GearMetadata#name) -- gearCode FK(Gear#casinoGearName) -- gearMetadataValue ++---------------------+-----------------------+ +| Colonne | Type | ++=====================+=======================+ +| vesselName |FK(Vessel#name) | ++---------------------+-----------------------+ +| operationId |FK(Operation#id) | ++---------------------+-----------------------+ +| metadataType |FK(GearMetadata#name) | ++---------------------+-----------------------+ +| gearCode |FK(Gear#casinoGearName)| ++---------------------+-----------------------+ +| gearMetadataValue |text | ++---------------------+-----------------------+ Exemple ------- @@ -257,15 +337,27 @@ Format des colonnes ------------------- -- 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) ++-----------------+-------------------------+ +| Colonne | 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) | ++-----------------+-------------------------+ Exemple ------- @@ -288,15 +380,27 @@ Format des colonnes ------------------- -- 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 ++------------------+-------------------------+ +| Colonne | 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 | ++------------------+-------------------------+ (colonnes ignorées) subHaul units round @@ -321,12 +425,21 @@ Format des colonnes ------------------- -- operationId FK(Operation#id) -- baracoudaCode FK(Species#baracoudaCode) -- numFish (int) -- name FK(SampleDataType#name) -- dataLabel -- dataValue (Float-NA) ++----------------+--------------------------+ +| Colonne | Type | ++================+==========================+ +| operationId |FK(Operation#id) | ++----------------+--------------------------+ +| baracoudaCode |FK(Species#baracoudaCode) | ++----------------+--------------------------+ +| numFish |(int) | ++----------------+--------------------------+ +| name |FK(SampleDataType#name) | ++----------------+--------------------------+ +| dataLabel |text | ++----------------+--------------------------+ +| dataValue |(Float-NA) | ++----------------+--------------------------+ Exemple ------- @@ -348,83 +461,160 @@ Format des colonnes ------------------- ++---------------------------------------------------------+-----------------------------------------+ +| Colonne | Type | ++=========================================================+=========================================+ +| MOVIES_EILayer |text //A| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset |(colonne ignorée) //B| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\sndname |(colonne ignorée) //C| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\sndident |(colonne ignorée) //D| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\softChannelId |FK(AcousticInstrument#id) //E| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\channelName |(colonne ignorée) //F| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\dataType |(colonne ignorée) //G| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamType |(colonne ignorée) //H| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\acousticFrequency |(colonne ignorée) //I| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\startSample |(colonne ignorée) //J| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\mainBeamAlongSteeringAngle |(colonne ignorée) //K| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\mainBeamAthwartSteeringAngle |(colonne ignorée) //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 |(colonne ignorée) //Q| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beam3dBWidthAthwart |(colonne ignorée) //R| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamEquTwoWayAngle |(Float) //S| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamGain |(Float) //T| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\beamSACorrection |(Float) //U| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bottomDetectionMinDepth |(colonne ignorée) //V| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bottomDetectionMaxDepth |(colonne ignorée) //W| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bottomDetectionMinLevel |(colonne ignorée) //X| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\AlongTXRXWeightId |(colonne ignorée) //Y| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\AthwartTXRXWeightId |(colonne ignorée) //Z| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\SplitBeamAlongTXRXWeightId |(colonne ignorée) //AA| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\SplitBeamAthwartTXRXWeightId |(colonne ignorée) //AB| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\bandWidth |(colonne ignorée) //AC| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\tvgminrange |(colonne ignorée) //AD| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\tvgmaxrange |(colonne ignorée) //AE| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\pulseduration |(Float) //AF| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav |(colonne ignorée) //AG| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\lat |(colonne ignorée) //AH| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\long |(colonne ignorée) //AI| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\alt |(colonne ignorée) //AJ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\gndspeed |(colonne ignorée) //AK| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\gndcourse |(colonne ignorée) //AL| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\surfspeed |(colonne ignorée) //AM| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\surfcourse |(colonne ignorée) //AN| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\driftspeed |(colonne ignorée) //AO| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\driftcourse |(colonne ignorée) //AP| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\heading |(colonne ignorée) //AQ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\roll |(colonne ignorée) //AR| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\pitch |(colonne ignorée) //AS| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\heave |(colonne ignorée) //AT| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\depth |text //AU| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\shipnav\\draught |(colonne ignorée) //AV| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset |(colonne ignorée) //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 |(colonne ignorée) //BB| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\indexend |(colonne ignorée) //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 |(colonne ignorée) //BJ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\distend |(colonne ignorée) //BK| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\thresholdup |(int) //BL| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\cellset\\thresholdlow |(int) //BM| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer |(colonne ignorée) //BN| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\sa |(Float-NA) //BO| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\sv |(colonne ignorée) //BP| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\ni |(Integer-NA) //BQ| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\eilayer\\nt |(Integer-NA) //BR| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\boterr |(colonne ignorée) //BR| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\boterr\\sa |(colonne ignorée) //BT| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\boterr\\ni |(colonne ignorée) //BU| ++---------------------------------------------------------+-----------------------------------------+ +| MOVIES_EILayer\\sndset\\soundcelerity |text //BV| ++---------------------------------------------------------+-----------------------------------------+ +| dataQuality |FK(DataQuality#qualityDataFlagValues) //E| ++---------------------------------------------------------+-----------------------------------------+ -- *MOVIES_EILayer* //A -- *MOVIES_EILayer\\sndset* (colonne ignorée) //B -- *MOVIES_EILayer\\sndset\\sndname* (colonne ignorée) //C -- *MOVIES_EILayer\\sndset\\sndident* (colonne ignorée) //D -- *MOVIES_EILayer\\sndset\\softChannelId* FK(AcousticInstrument#id) //E -- *MOVIES_EILayer\\sndset\\channelName* (colonne ignorée) //F -- *MOVIES_EILayer\\sndset\\dataType* (colonne ignorée) //G -- *MOVIES_EILayer\\sndset\\beamType* (colonne ignorée) //H -- *MOVIES_EILayer\\sndset\\acousticFrequency* (colonne ignorée) //I -- *MOVIES_EILayer\\sndset\\startSample* (colonne ignorée) //J -- *MOVIES_EILayer\\sndset\\mainBeamAlongSteeringAngle* (colonne ignorée) //K -- *MOVIES_EILayer\\sndset\\mainBeamAthwartSteeringAngle* (colonne ignorée) //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* (colonne ignorée) //Q -- *MOVIES_EILayer\\sndset\\beam3dBWidthAthwart* (colonne ignorée) //R -- *MOVIES_EILayer\\sndset\\beamEquTwoWayAngle* (Float) //S -- *MOVIES_EILayer\\sndset\\beamGain* (Float) //T -- *MOVIES_EILayer\\sndset\\beamSACorrection* (Float) //U -- *MOVIES_EILayer\\sndset\\bottomDetectionMinDepth* (colonne ignorée) //V -- *MOVIES_EILayer\\sndset\\bottomDetectionMaxDepth* (colonne ignorée) //W -- *MOVIES_EILayer\\sndset\\bottomDetectionMinLevel* (colonne ignorée) //X -- *MOVIES_EILayer\\sndset\\AlongTXRXWeightId* (colonne ignorée) //Y -- *MOVIES_EILayer\\sndset\\AthwartTXRXWeightId* (colonne ignorée) //Z -- *MOVIES_EILayer\\sndset\\SplitBeamAlongTXRXWeightId* (colonne ignorée) //AA -- *MOVIES_EILayer\\sndset\\SplitBeamAthwartTXRXWeightId* (colonne ignorée) //AB -- *MOVIES_EILayer\\sndset\\bandWidth* (colonne ignorée) //AC -- *MOVIES_EILayer\\sndset\\tvgminrange* (colonne ignorée) //AD -- *MOVIES_EILayer\\sndset\\tvgmaxrange* (colonne ignorée) //AE -- *MOVIES_EILayer\\sndset\\pulseduration* (Float) //AF -- *MOVIES_EILayer\\shipnav* (colonne ignorée) //AG -- *MOVIES_EILayer\\shipnav\\lat* (colonne ignorée) //AH -- *MOVIES_EILayer\\shipnav\\long* (colonne ignorée) //AI -- *MOVIES_EILayer\\shipnav\\alt* (colonne ignorée) //AJ -- *MOVIES_EILayer\\shipnav\\gndspeed* (colonne ignorée) //AK -- *MOVIES_EILayer\\shipnav\\gndcourse* (colonne ignorée) //AL -- *MOVIES_EILayer\\shipnav\\surfspeed* (colonne ignorée) //AM -- *MOVIES_EILayer\\shipnav\\surfcourse* (colonne ignorée) //AN -- *MOVIES_EILayer\\shipnav\\driftspeed* (colonne ignorée) //AO -- *MOVIES_EILayer\\shipnav\\driftcourse* (colonne ignorée) //AP -- *MOVIES_EILayer\\shipnav\\heading* (colonne ignorée) //AQ -- *MOVIES_EILayer\\shipnav\\roll* (colonne ignorée) //AR -- *MOVIES_EILayer\\shipnav\\pitch* (colonne ignorée) //AS -- *MOVIES_EILayer\\shipnav\\heave* (colonne ignorée) //AT -- *MOVIES_EILayer\\shipnav\\depth* //AU -- *MOVIES_EILayer\\shipnav\\draught* (colonne ignorée) //AV -- *MOVIES_EILayer\\cellset* (colonne ignorée) //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* (colonne ignorée) //BB -- *MOVIES_EILayer\\cellset\\indexend* (colonne ignorée) //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* (colonne ignorée) //BJ -- *MOVIES_EILayer\\cellset\\distend* (colonne ignorée) //BK -- *MOVIES_EILayer\\cellset\\thresholdup* (int) //BL -- *MOVIES_EILayer\\cellset\\thresholdlow* (int) //BM -- *MOVIES_EILayer\\eilayer* (colonne ignorée) //BN -- *MOVIES_EILayer\\eilayer\\sa* (Float-NA)//BO -- *MOVIES_EILayer\\eilayer\\sv* (colonne ignorée) //BP -- *MOVIES_EILayer\\eilayer\\ni* (Integer-NA) //BQ -- *MOVIES_EILayer\\eilayer\\nt* (Integer-NA)//BR -- *MOVIES_EILayer\\boterr* (colonne ignorée) //BR -- *MOVIES_EILayer\\boterr\\sa* (colonne ignorée) //BT -- *MOVIES_EILayer\\boterr\\ni* (colonne ignorée) //BU -- *MOVIES_EILayer\\sndset\\soundcelerity*//BV -- *dataQuality* FK(DataQuality#qualityDataFlagValues) //E - Exemple ------- @@ -449,11 +639,19 @@ Format des colonnes ------------------- -- echotypeName -- meaning -- voyage FK(Voyage#name) -- depthStratumId FK(DepthStratum#id) -- baracoudaCode FK(Species#baracoudaCode) ++-----------------+-------------------------+ +| Colonne | Type | ++=================+=========================+ +| echotypeName |text | ++-----------------+-------------------------+ +| meaning |text | ++-----------------+-------------------------+ +| voyage |FK(Voyage#name) | ++-----------------+-------------------------+ +| depthStratumId |FK(DepthStratum#id) | ++-----------------+-------------------------+ +| baracoudaCode |FK(Species#baracoudaCode)| ++-----------------+-------------------------+ Exemple ------- @@ -476,12 +674,21 @@ Format des colonnes ------------------- -- aParameter (float) -- bParameter (float) -- voyage FK(Voyage#name) -- sizeCategory FK(SizeCategory#name) -- baracoudaCode FK(Species#baracoudaCode) -- strata FK(Strata#name) ++----------------+-------------------------+ +| Colonne | Type | ++================+=========================+ +| aParameter |(float) | ++----------------+-------------------------+ +| bParameter |(float) | ++----------------+-------------------------+ +| voyage |FK(Voyage#name) | ++----------------+-------------------------+ +| sizeCategory |FK(SizeCategory#name) | ++----------------+-------------------------+ +| baracoudaCode |FK(Species#baracoudaCode)| ++----------------+-------------------------+ +| strata |FK(Strata#name) | ++----------------+-------------------------+ Exemple ------- @@ -504,13 +711,23 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- age (int) -- length (float) -- percentAtAge (float) -- metadata -- strata FK(Strata#name) -- baracoudaCode FK(Species#baracoudaCode) ++----------------+-------------------------+ +| Colonne | Type | ++================+=========================+ +| voyage |FK(Voyage#name) | ++----------------+-------------------------+ +| age |(int) | ++----------------+-------------------------+ +| length |(float) | ++----------------+-------------------------+ +| percentAtAge |(float) | ++----------------+-------------------------+ +| metadata |text | ++----------------+-------------------------+ +| strata |FK(Strata#name) | ++----------------+-------------------------+ +| baracoudaCode |FK(Species#baracoudaCode)| ++----------------+-------------------------+ Exemple ------- @@ -536,11 +753,19 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- 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) ++----------------+-------------------------------------------------------------+ +| Colonne | Type | ++================+=============================================================+ +| voyage |FK(Voyage#name) | ++----------------+-------------------------------------------------------------+ +| 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) | ++----------------+-------------------------------------------------------------+ Exemple ------- @@ -563,13 +788,23 @@ Format des colonnes ------------------- -- 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) (une colonne par méta à importer) ++----------------+-------------------------------------------------------------+ +| Colonne | 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) (une colonne par méta à importer) | ++----------------+-------------------------------------------------------------+ Exemple ------- @@ -592,13 +827,23 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- name FK(esdu cell) -- baracoudaCode FK(Species#baracoudaCode) -- ageCategory -- ageCategoryMeaning -- dataQuality FK(DataQuality#qualityDataFlagValues) -- méta-données FK(DataMetadata#name) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | 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) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple ------- @@ -621,13 +866,23 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- name FK(esdu cell) -- baracoudaCode FK(Species#baracoudaCode) -- sizeCategory -- sizeCategoryMeaning -- dataQuality FK(DataQuality#qualityDataFlagValues) -- méta-données FK(DataMetadata#name) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | Type | ++======================+=======================================================+ +| voyage |FK(Voyage#name) | ++----------------------+-------------------------------------------------------+ +| name |FK(esdu cell) | ++----------------------+-------------------------------------------------------+ +| baracoudaCode |FK(Species#baracoudaCode) | ++----------------------+-------------------------------------------------------+ +| sizeCategory |text | ++----------------------+-------------------------------------------------------+ +| sizeCategoryMeaning |text | ++----------------------+-------------------------------------------------------+ +| dataQuality |FK(DataQuality#qualityDataFlagValues) | ++----------------------+-------------------------------------------------------+ +| méta-données |FK(DataMetadata#name) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple ------- @@ -653,12 +908,21 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- cellType FK(CellType) -- dataQuality FK(DataQuality#qualityDataFlagValues) -- name -- regionEnvCoordinates -- surface (float) ++-----------------------+------------------------------------------------------+ +| Colonne | Type | ++=======================+======================================================+ +| voyage |FK(Voyage#name) | ++-----------------------+------------------------------------------------------+ +| cellType |FK(CellType) | ++-----------------------+------------------------------------------------------+ +| dataQuality |FK(DataQuality#qualityDataFlagValues) | ++-----------------------+------------------------------------------------------+ +| name |text | ++-----------------------+------------------------------------------------------+ +| regionEnvCoordinates |text | ++-----------------------+------------------------------------------------------+ +| surface |(float) | ++-----------------------+------------------------------------------------------+ Exemple ------- @@ -681,9 +945,15 @@ Format des colonnes ------------------- -- voyage FK(Voyage) -- regionName FK(Cell#name) -- esduName FK(Cell#name) ++-----------------------+------------------------------------------------------+ +| Colonne | Type | ++=======================+======================================================+ +| voyage |FK(Voyage) | ++-----------------------+------------------------------------------------------+ +| regionName |FK(Cell#name) | ++-----------------------+------------------------------------------------------+ +| esduName |FK(Cell#name) | ++-----------------------+------------------------------------------------------+ Exemple ------- @@ -706,13 +976,23 @@ Format des colonnes ------------------- -- 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) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | 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) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple ------- @@ -738,19 +1018,35 @@ Format des colonnes ------------------- -- voyage FK(Voyage#name) -- name -- 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) -- méta-données FK(DataMetadata#name) (une colonne par méta à importer) ++----------------------+-------------------------------------------------------+ +| Colonne | 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) | ++----------------------+-------------------------------------------------------+ +| méta-données |FK(DataMetadata#name) (une colonne par méta à importer)| ++----------------------+-------------------------------------------------------+ Exemple -------