Salut Tony ci-joints les fichiers d'import des : - Operations - OperationMetadaValue - GearMetadaValue A+ M Tony Chemit a écrit :
On Wed, 01 Feb 2012 11:38:28 +0100 Mathieu DORAY <Mathieu.Doray@ifremer.fr> wrote:
Hello
alors finalement le format des fichiers Movies a évolué, ce qui simplifie le pb, car ça évite les doublons de noms de colonnes
ci-joint un fichier exemple au nouveau format et la procédure modifiée en conséquence.
Ok procédure bien suivi par contre le fichier est pas bon on a toujours les deux types de cellules sur la même ligne.
Peux-tu m'envoyer le bon fichier,
merci.
A toute
Mathieu
Tony Chemit a écrit :
On Wed, 25 Jan 2012 12:49:24 +0100 Tony Chemit <chemit@codelutin.com> wrote:
Salut,
Je tente de commencer ça, pas évident :(
Alerte! Impossible de faire cet import car des colonnes ont le même nom et ça je peux difficilement le gérer.
Ca concerne les données des cellules ESDU (AW->BN) et elementary (BO->CF)
D'ors et déjà, je vois un petit problème : il faut retrouve le transect où ajouter les dataAcquisition et le reste; or nous avons comme critère la Voyage et le Vessel mais cela ne suffit pas, car un voyage peut avoir plusieurs Transit et ce transit plusieurs Transect...
Donc il manque une information sur la date de début de transit,
Ce qu'on peut faire je pense c'est comme ça :
On utilise 3 listes déroulantes qui se mettent à jour en cascade :
Voyage Transit Vessel
Lorsqu'on sélectionne le voyage cela met à jour les transit connus Lorsqu'on sélectionne un transit cela met à jour les vessels connus de ce transit.
De cette manière on s'assure que l'utilisateur a bien sélectionné quelque chose de cohérent.
Cela vous convient-il ?
Mathieu, j'essaye de t'appeler en début d'AM car je voudrais quelques éclaircissements sur cet import MOVIES.
Tony.
-- Mathieu Doray, PhD Ifremer Département Ecologie et Modèles pour l'Halieutique rue de l'Ile d'Yeu B.P. 21105 44311 Nantes Cedex 03 mathieu.doray@ifremer.fr Tel./Phone: 02 40 37 41 65 / International: 332 40 37 41 65 Fax : 02.40.37.40.01 / International: 332 40 37 40 01 Thèse en ligne / PhD manuscript: http://www.ifremer.fr/docelec/doc/2006/these-1735.pdf CV / resume: http://mathieudoray.ouvaton.org/CV_Mathieu_Doray.html "vesselName";"id";"depthStratumID";"gearShootingStartTime";"midHaulLatitude";"midHaulLongitude";"gearShootingStartLatitude";"gearShootingStartLongitude";"gearShootingEndTime";"gearShootingEndLatitude";"gearShootingEndLongitude";"gearName" "Thalassa";"P0372";"SURF";"26/04/2011 16:10:16";43.6666861;-2.21578605;43.6663602;-2.1615688;"26/04/2011 17:13:04";43.667012;-2.2700033;"Chalut 76/70" "Thalassa";"P0377";"CLAS";"27/04/2011 06:31:39";43.66673165;-1.79899135;43.6667853;-1.747363;"27/04/2011 07:32:48";43.666678;-1.8506197;"Chalut 76/70" "Thalassa";"P0378";"CLAS";"27/04/2011 12:55:28";43.86680415;-1.746744;43.8672138;-1.7982492;"27/04/2011 13:55:31";43.8663945;-1.6952388;"Chalut 76/70" "Thalassa";"P0379";"CLAS";"27/04/2011 16:39:37";43.86757765;-1.9556655;43.8676428;-2.0017103;"27/04/2011 17:33:31";43.8675125;-1.9096207;"Chalut 76/70" "Thalassa";"P0383";"SURF";"28/04/2011 06:25:57";44.0666276;-2.98049865;44.0667095;-2.931594;"28/04/2011 07:21:02";44.0665457;-3.0294033;"Chalut 76/70" "Thalassa";"P0384";"CLAS";"28/04/2011 13:13:08";44.06656295;-1.89965825;44.0663187;-1.8383773;"28/04/2011 14:24:03";44.0668072;-1.9609392;"Chalut 76/70" "Thalassa";"P0385";"CLAS";"28/04/2011 18:50:26";44.06636615;-1.63466365;44.0662513;-1.5944573;"28/04/2011 19:36:31";44.066481;-1.67487;"Chalut 76/70" "Thalassa";"P0389";"CLAS";"29/04/2011 06:19:53";44.2664955;-1.52206065;44.2663643;-1.5754153;"29/04/2011 07:23:00";44.2666267;-1.468706;"Chalut 76/70" "Thalassa";"P0390";"CLAS";"29/04/2011 10:07:58";44.26622665;-1.7073195;44.2664293;-1.7738233;"29/04/2011 11:26:04";44.266024;-1.6408157;"Chalut 76/70" "Thalassa";"P0395";"SURF";"30/04/2011 08:10:51";44.26686615;-2.49632365;44.2666;-2.5487575;"30/04/2011 09:09:32";44.2671323;-2.4438898;"Chalut 76/70" "Thalassa";"P0396";"CLAS";"30/04/2011 18:30:21";44.4666152;-1.94586135;44.4666342;-1.900111;"30/04/2011 19:22:25";44.4665962;-1.9916117;"Chalut 76/70" "Thalassa";"P0399";"CLAS";"01/05/2011 10:35:59";44.6675975;-1.8841202;44.6680473;-1.8218972;"01/05/2011 11:53:04";44.6671477;-1.9463432;"Chalut 76/70" "Thalassa";"P0400";"NULL";"01/05/2011 17:10:40";44.85933125;-2.44603665;44.8685602;-2.494259;"01/05/2011 18:08:30";44.8501023;-2.3978143;"Chalut 76/70" "Thalassa";"P0404";"CLAS";"02/05/2011 10:59:50";44.6668616;-1.5903002;44.6667415;-1.6506737;"02/05/2011 12:12:36";44.6669817;-1.5299267;"Chalut 76/70" "Thalassa";"P0405";"CLAS";"02/05/2011 17:58:21";44.866915;-1.2839095;44.9039153;-1.2852048;"02/05/2011 18:56:47";44.8299147;-1.2826142;"Chalut 57/52" "Thalassa";"P0409";"CLAS";"03/05/2011 05:56:21";45.0164419;-2.2882595;45.0146373;-2.3340887;"03/05/2011 06:53:02";45.0182465;-2.2424303;"Chalut 76/70" "Thalassa";"P0410";"SURF";"03/05/2011 10:11:15";45.00061135;-2.5254289;44.9920907;-2.4510983;"03/05/2011 11:31:10";45.009132;-2.5997595;"Chalut 76/70" "Thalassa";"P0417";"CLAS";"04/05/2011 17:51:47";45.1560195;-2.3268755;45.1495478;-2.376418;"04/05/2011 18:51:40";45.1624912;-2.277333;"Chalut 76/70" "Thalassa";"P0422";"CLAS";"05/05/2011 06:49:50";45.4165605;-1.4492292;45.4029733;-1.4860902;"05/05/2011 07:42:19";45.4301477;-1.4123682;"Chalut 57/52" "Thalassa";"P0423";"CLAS";"05/05/2011 15:39:20";45.55488225;-1.64926125;45.5695578;-1.6113005;"05/05/2011 16:30:36";45.5402067;-1.687222;"Chalut 76/70" "Thalassa";"P0429";"CLAS";"06/05/2011 07:25:49";45.18947685;-2.5391907;45.1718117;-2.5809162;"06/05/2011 08:23:42";45.207142;-2.4974652;"Chalut 76/70" "Thalassa";"P0430";"CLAS";"06/05/2011 16:05:41";45.3405998;-2.743071;45.3603513;-2.6914532;"06/05/2011 17:13:24";45.3208483;-2.7946888;"Chalut 76/70" "Thalassa";"P0435";"CLAS";"07/05/2011 07:04:49";45.73097685;-1.7467553;45.717725;-1.7784178;"07/05/2011 07:47:25";45.7442287;-1.7150928;"Chalut 76/70" "Thalassa";"P0436";"CLAS";"07/05/2011 12:40:49";45.4871954;-2.37471525;45.4660413;-2.4286165;"07/05/2011 13:46:27";45.5083495;-2.320814;"Chalut 76/70" "Thalassa";"P0441";"CLAS";"08/05/2011 06:22:08";45.7596614;-2.2718805;45.778235;-2.2274387;"08/05/2011 07:21:37";45.7410878;-2.3163223;"Chalut 76/70" "Thalassa";"P0442";"SURF";"08/05/2011 16:48:56";46.04068135;-2.12840585;46.0222777;-2.1767912;"08/05/2011 17:52:01";46.059085;-2.0800205;"Chalut 76/70" "Thalassa";"P0443";"CLAS";"10/05/2011 12:43:00";46.35293225;-1.92858305;46.341076;-1.9586068;"10/05/2011 13:24:40";46.3647885;-1.8985593;"Chalut 57/52" "Thalassa";"P0444";"SURF";"10/05/2011 18:08:06";46.0928689;-2.60270885;46.0772255;-2.64295;"10/05/2011 18:59:31";46.1085123;-2.5624677;"Chalut 76/70" "Thalassa";"P0449";"SURF";"11/05/2011 07:48:46";46.4189677;-2.34978675;46.4020612;-2.3922847;"11/05/2011 08:46:02";46.4358742;-2.3072888;"Chalut 76/70" "Thalassa";"P0450";"CLAS";"11/05/2011 14:01:18";46.41944775;-2.94143515;46.4356757;-2.900766;"11/05/2011 14:53:30";46.4032198;-2.9821043;"Chalut 76/70" "Thalassa";"P0454";"CLAS";"12/05/2011 07:05:26";45.84683875;-2.61805485;45.8316423;-2.6548725;"12/05/2011 07:54:23";45.8620352;-2.5812372;"Chalut 76/70" "Thalassa";"P0455";"CLAS";"12/05/2011 11:53:52";45.6132011;-3.20445085;45.5958287;-3.2447132;"12/05/2011 12:50:31";45.6305735;-3.1641885;"Chalut 76/70" "Thalassa";"P0460";"CLAS";"13/05/2011 07:26:04";46.01328;-2.8073191;46.0284548;-2.7692625;"13/05/2011 08:17:17";45.9981052;-2.8453757;"Chalut 76/70" "Thalassa";"P0461";"CLAS";"13/05/2011 13:44:58";45.99174535;-3.4184479;45.9733252;-3.4629725;"13/05/2011 14:47:52";46.0101655;-3.3739233;"Chalut 76/70" "Thalassa";"P0463";"CLAS";"14/05/2011 07:04:19";46.09663135;-3.75210175;46.1143065;-3.707652;"14/05/2011 08:03:26";46.0789562;-3.7965515;"Chalut 76/70" "Thalassa";"P0464";"CLAS";"14/05/2011 18:17:12";46.2098473;-4.0142089;46.1924198;-4.0593755;"14/05/2011 19:15:39";46.2272748;-3.9690423;"Chalut 76/70" "Thalassa";"P0468";"CLAS";"15/05/2011 07:08:30";46.59380925;-3.0607965;46.6065298;-3.0290395;"15/05/2011 07:50:01";46.5810887;-3.0925535;"Chalut 76/70" "Thalassa";"P0473";"CLAS";"16/05/2011 07:04:19";47.09585435;-2.9685695;47.0769127;-3.0166252;"16/05/2011 08:07:44";47.114796;-2.9205138;"Chalut 76/70" "Thalassa";"P0474";"CLAS";"16/05/2011 11:46:49";46.9647855;-3.30780285;46.9476583;-3.350037;"16/05/2011 12:39:19";46.9819127;-3.2655687;"Chalut 76/70" "Thalassa";"P0479";"CLAS";"17/05/2011 07:21:17";47.14522585;-3.85982645;47.164662;-3.8230832;"17/05/2011 08:11:19";47.1257897;-3.8965697;"Chalut 76/70" "Thalassa";"P0480";"CLAS";"17/05/2011 15:24:51";47.5203479;-3.6287345;47.5009285;-3.6607855;"17/05/2011 16:14:04";47.5397673;-3.5966835;"Chalut 76/70" "Thalassa";"P0484";"CLAS";"18/05/2011 07:41:01";47.52017855;-4.06225735;47.5429438;-4.0310202;"18/05/2011 08:35:18";47.4974133;-4.0934945;"Chalut 76/70" "Thalassa";"P0485";"CLAS";"18/05/2011 18:20:32";47.2902331;-4.7932865;47.2654857;-4.8245127;"18/05/2011 19:19:08";47.3149805;-4.7620603;"Chalut 76/70" "Thalassa";"P0489";"CLAS";"19/05/2011 13:15:33";47.72496835;-4.9996085;47.698694;-5.0346557;"19/05/2011 14:08:45";47.7512427;-4.9645613;"Chalut 76/70" "Thalassa";"P0493";"CLAS";"20/05/2011 11:17:24";46.48890005;-3.8921176;46.4710443;-3.941406;"20/05/2011 12:18:42";46.5067558;-3.8428292;"Chalut 76/70" "Thalassa";"P0494";"SURF";"20/05/2011 15:29:41";46.3540454;-4.2313095;46.3366863;-4.2788225;"20/05/2011 16:23:35";46.3714045;-4.1837965;"Chalut 76/70" "Thalassa";"P0495";"CLAS";"20/05/2011 17:23:27";46.36654045;-4.19797885;46.3851312;-4.1534082;"20/05/2011 18:21:10";46.3479497;-4.2425495;"Chalut 76/70" "Thalassa";"P0500";"CLAS";"21/05/2011 11:41:44";46.54847245;-4.71870945;46.5870072;-4.7533782;"21/05/2011 13:07:19";46.5099377;-4.6840407;"Chalut 76/70" "Thalassa";"P0501";"SURF";"21/05/2011 19:00:00";46.2811965;-5.265945;46.3189872;-5.2274662;"21/05/2011 20:20:33";46.2434058;-5.3044238;"Chalut 76/70" "Thalassa";"P0505";"SURF";"22/05/2011 05:45:10";46.5396551;-4.9833545;46.5666412;-4.9372575;"22/05/2011 06:53:04";46.512669;-5.0294515;"Chalut 76/70" "Thalassa";"P0506";"NULL";"22/05/2011 12:05:37";46.89181565;-4.33279955;46.9203095;-4.2784823;"22/05/2011 13:22:21";46.8633218;-4.3871168;"Chalut 76/70" "Thalassa";"P0509";"SURF";"24/05/2011 17:23:57";46.7755839;-5.06538785;46.739707;-5.1170042;"24/05/2011 18:30:39";46.8114608;-5.0137715;"Chalut 76/70" "Thalassa";"P0510";"CLAS";"25/05/2011 07:27:42";46.9686228;-5.2053616;46.9372413;-5.2458797;"25/05/2011 08:34:33";47.0000043;-5.1648435;"Chalut 76/70" "Thalassa";"P0511";"SURF";"25/05/2011 13:04:56";47.03671115;-5.5070321;47.0667233;-5.4681422;"25/05/2011 14:07:39";47.006699;-5.545922;"Chalut 76/70" "Thalassa";"P0512";"CLAS";"25/05/2011 15:07:48";47.0821397;-5.4535365;47.0675042;-5.4723792;"25/05/2011 15:39:12";47.0967752;-5.4346938;"Chalut 76/70" "Thalassa";"P0523";"CLAS";"27/05/2011 15:30:59";45.747111;-1.70588315;45.7523865;-1.6929008;"27/05/2011 15:46:53";45.7418355;-1.7188655;"Chalut 76/70" "Thalassa";"P0535";"CLAS";"28/05/2011 16:43:48";45.67605565;-1.8722945;45.6879498;-1.8414218;"28/05/2011 17:20:31";45.6641615;-1.9031672;"Chalut 76/70" "Thalassa";"P0545";"CLAS";"30/05/2011 16:59:20";44.26752465;-1.53255675;44.2664178;-1.56542;"30/05/2011 17:39:30";44.2686315;-1.4996935;"Chalut 76/70" "Thalassa";"P0553";"CLAS";"31/05/2011 16:00:50";44.27961675;-1.58057055;44.252785;-1.5739693;"31/05/2011 16:48:07";44.3064485;-1.5871718;"Chalut 76/70" "Thalassa";"P0554";"CLAS";"31/05/2011 17:28:44";44.2998278;-1.540415;44.3192688;-1.5419232;"31/05/2011 18:03:21";44.2803868;-1.5389068;"Chalut 76/70" "Thalassa";"P0563";"CLAS";"02/06/2011 17:34:41";44.4829427;-1.44727785;44.5207862;-1.4379057;"02/06/2011 18:32:34";44.4450992;-1.45665;"Chalut 76/70" "vesselName";"id";"metadataType";"operationMetadataValue" "Thalassa";"P0372";"MeanWaterDepth";1248.4 "Thalassa";"P0377";"MeanWaterDepth";134.495 "Thalassa";"P0378";"MeanWaterDepth";114.37 "Thalassa";"P0379";"MeanWaterDepth";132.555 "Thalassa";"P0383";"MeanWaterDepth";1586.31 "Thalassa";"P0384";"MeanWaterDepth";128.31 "Thalassa";"P0385";"MeanWaterDepth";96.4 "Thalassa";"P0389";"MeanWaterDepth";69.795 "Thalassa";"P0390";"MeanWaterDepth";109.1 "Thalassa";"P0395";"MeanWaterDepth";1129.38 "Thalassa";"P0396";"MeanWaterDepth";131.385 "Thalassa";"P0399";"MeanWaterDepth";129.235 "Thalassa";"P0400";"MeanWaterDepth";2460.30005 "Thalassa";"P0404";"MeanWaterDepth";84.925 "Thalassa";"P0405";"MeanWaterDepth";26.865 "Thalassa";"P0409";"MeanWaterDepth";132.485 "Thalassa";"P0410";"MeanWaterDepth";1426.205 "Thalassa";"P0417";"MeanWaterDepth";124.06 "Thalassa";"P0422";"MeanWaterDepth";43.42 "Thalassa";"P0423";"MeanWaterDepth";55.6 "Thalassa";"P0429";"MeanWaterDepth";132.175 "Thalassa";"P0430";"MeanWaterDepth";134.69 "Thalassa";"P0435";"MeanWaterDepth";59.395 "Thalassa";"P0436";"MeanWaterDepth";109.085 "Thalassa";"P0441";"MeanWaterDepth";96.255 "Thalassa";"P0442";"MeanWaterDepth";68.665 "Thalassa";"P0443";"MeanWaterDepth";33.425 "Thalassa";"P0444";"MeanWaterDepth";105.45 "Thalassa";"P0449";"MeanWaterDepth";55.8 "Thalassa";"P0450";"MeanWaterDepth";107.73 "Thalassa";"P0454";"MeanWaterDepth";110.87 "Thalassa";"P0455";"MeanWaterDepth";140.855 "Thalassa";"P0460";"MeanWaterDepth";116.63 "Thalassa";"P0461";"MeanWaterDepth";140.48 "Thalassa";"P0463";"MeanWaterDepth";148.73 "Thalassa";"P0464";"MeanWaterDepth";151.005 "Thalassa";"P0468";"MeanWaterDepth";104.97 "Thalassa";"P0473";"MeanWaterDepth";52.495 "Thalassa";"P0474";"MeanWaterDepth";101.035 "Thalassa";"P0479";"MeanWaterDepth";113.085 "Thalassa";"P0480";"MeanWaterDepth";83.2 "Thalassa";"P0484";"MeanWaterDepth";101.315 "Thalassa";"P0485";"MeanWaterDepth";129.155 "Thalassa";"P0489";"MeanWaterDepth";121.86 "Thalassa";"P0493";"MeanWaterDepth";139.29 "Thalassa";"P0494";"MeanWaterDepth";182.52 "Thalassa";"P0495";"MeanWaterDepth";153.91 "Thalassa";"P0500";"MeanWaterDepth";202.175 "Thalassa";"P0501";"MeanWaterDepth";4020.505 "Thalassa";"P0505";"MeanWaterDepth";1171.31 "Thalassa";"P0506";"MeanWaterDepth";137.91 "Thalassa";"P0509";"MeanWaterDepth";558.225 "Thalassa";"P0510";"MeanWaterDepth";196.1 "Thalassa";"P0511";"MeanWaterDepth";564.87 "Thalassa";"P0512";"MeanWaterDepth";80.61 "Thalassa";"P0523";"MeanWaterDepth";53.365 "Thalassa";"P0535";"MeanWaterDepth";66.8 "Thalassa";"P0545";"MeanWaterDepth";80.45 "Thalassa";"P0553";"MeanWaterDepth";96.235 "Thalassa";"P0554";"MeanWaterDepth";84.11 "Thalassa";"P0563";"MeanWaterDepth";60.205 "Thalassa";"P0372";"WaterDepthShoot";945.2 "Thalassa";"P0377";"WaterDepthShoot";120.17 "Thalassa";"P0378";"WaterDepthShoot";118.33 "Thalassa";"P0379";"WaterDepthShoot";141.5 "Thalassa";"P0383";"WaterDepthShoot";1493.25 "Thalassa";"P0384";"WaterDepthShoot";120.62 "Thalassa";"P0385";"WaterDepthShoot";88.13 "Thalassa";"P0389";"WaterDepthShoot";87.24 "Thalassa";"P0390";"WaterDepthShoot";117.07 "Thalassa";"P0395";"WaterDepthShoot";1116.21 "Thalassa";"P0396";"WaterDepthShoot";125.75 "Thalassa";"P0399";"WaterDepthShoot";119.84 "Thalassa";"P0400";"WaterDepthShoot";2458.79 "Thalassa";"P0404";"WaterDepthShoot";96.17 "Thalassa";"P0405";"WaterDepthShoot";28.51 "Thalassa";"P0409";"WaterDepthShoot";143.65 "Thalassa";"P0410";"WaterDepthShoot";1015.18 "Thalassa";"P0417";"WaterDepthShoot";127.72 "Thalassa";"P0422";"WaterDepthShoot";46.23 "Thalassa";"P0423";"WaterDepthShoot";51.68 "Thalassa";"P0429";"WaterDepthShoot";134.6 "Thalassa";"P0430";"WaterDepthShoot";133.95 "Thalassa";"P0435";"WaterDepthShoot";62.62 "Thalassa";"P0436";"WaterDepthShoot";110.81 "Thalassa";"P0441";"WaterDepthShoot";90.4 "Thalassa";"P0442";"WaterDepthShoot";74.45 "Thalassa";"P0443";"WaterDepthShoot";36.43 "Thalassa";"P0444";"WaterDepthShoot";109.36 "Thalassa";"P0449";"WaterDepthShoot";59.23 "Thalassa";"P0450";"WaterDepthShoot";106.76 "Thalassa";"P0454";"WaterDepthShoot";112.48 "Thalassa";"P0455";"WaterDepthShoot";141.02 "Thalassa";"P0460";"WaterDepthShoot";114.75 "Thalassa";"P0461";"WaterDepthShoot";144.37 "Thalassa";"P0463";"WaterDepthShoot";147.7 "Thalassa";"P0464";"WaterDepthShoot";154.72 "Thalassa";"P0468";"WaterDepthShoot";103.4 "Thalassa";"P0473";"WaterDepthShoot";55.87 "Thalassa";"P0474";"WaterDepthShoot";104.24 "Thalassa";"P0479";"WaterDepthShoot";112.23 "Thalassa";"P0480";"WaterDepthShoot";86.27 "Thalassa";"P0484";"WaterDepthShoot";99.08 "Thalassa";"P0485";"WaterDepthShoot";130.26 "Thalassa";"P0489";"WaterDepthShoot";124.57 "Thalassa";"P0493";"WaterDepthShoot";143.03 "Thalassa";"P0494";"WaterDepthShoot";209.42 "Thalassa";"P0495";"WaterDepthShoot";154.69 "Thalassa";"P0500";"WaterDepthShoot";200.37 "Thalassa";"P0501";"WaterDepthShoot";3617.1799 "Thalassa";"P0505";"WaterDepthShoot";938.08 "Thalassa";"P0506";"WaterDepthShoot";134.82 "Thalassa";"P0509";"WaterDepthShoot";812.63 "Thalassa";"P0510";"WaterDepthShoot";233.61 "Thalassa";"P0511";"WaterDepthShoot";174.81 "Thalassa";"P0512";"WaterDepthShoot";79.52 "Thalassa";"P0523";"WaterDepthShoot";52.07 "Thalassa";"P0535";"WaterDepthShoot";64 "Thalassa";"P0545";"WaterDepthShoot";91.35 "Thalassa";"P0553";"WaterDepthShoot";93.85 "Thalassa";"P0554";"WaterDepthShoot";85.3 "Thalassa";"P0563";"WaterDepthShoot";57.27 "Thalassa";"P0372";"WaterDepthHaul";1551.6 "Thalassa";"P0377";"WaterDepthHaul";148.82 "Thalassa";"P0378";"WaterDepthHaul";110.41 "Thalassa";"P0379";"WaterDepthHaul";123.61 "Thalassa";"P0383";"WaterDepthHaul";1679.37 "Thalassa";"P0384";"WaterDepthHaul";136 "Thalassa";"P0385";"WaterDepthHaul";104.67 "Thalassa";"P0389";"WaterDepthHaul";52.35 "Thalassa";"P0390";"WaterDepthHaul";101.13 "Thalassa";"P0395";"WaterDepthHaul";1142.55 "Thalassa";"P0396";"WaterDepthHaul";137.02 "Thalassa";"P0399";"WaterDepthHaul";138.63 "Thalassa";"P0400";"WaterDepthHaul";2461.8101 "Thalassa";"P0404";"WaterDepthHaul";73.68 "Thalassa";"P0405";"WaterDepthHaul";25.22 "Thalassa";"P0409";"WaterDepthHaul";121.32 "Thalassa";"P0410";"WaterDepthHaul";1837.23 "Thalassa";"P0417";"WaterDepthHaul";120.4 "Thalassa";"P0422";"WaterDepthHaul";40.61 "Thalassa";"P0423";"WaterDepthHaul";59.52 "Thalassa";"P0429";"WaterDepthHaul";129.75 "Thalassa";"P0430";"WaterDepthHaul";135.43 "Thalassa";"P0435";"WaterDepthHaul";56.17 "Thalassa";"P0436";"WaterDepthHaul";107.36 "Thalassa";"P0441";"WaterDepthHaul";102.11 "Thalassa";"P0442";"WaterDepthHaul";62.88 "Thalassa";"P0443";"WaterDepthHaul";30.42 "Thalassa";"P0444";"WaterDepthHaul";101.54 "Thalassa";"P0449";"WaterDepthHaul";52.37 "Thalassa";"P0450";"WaterDepthHaul";108.7 "Thalassa";"P0454";"WaterDepthHaul";109.26 "Thalassa";"P0455";"WaterDepthHaul";140.69 "Thalassa";"P0460";"WaterDepthHaul";118.51 "Thalassa";"P0461";"WaterDepthHaul";136.59 "Thalassa";"P0463";"WaterDepthHaul";149.76 "Thalassa";"P0464";"WaterDepthHaul";147.29 "Thalassa";"P0468";"WaterDepthHaul";106.54 "Thalassa";"P0473";"WaterDepthHaul";49.12 "Thalassa";"P0474";"WaterDepthHaul";97.83 "Thalassa";"P0479";"WaterDepthHaul";113.94 "Thalassa";"P0480";"WaterDepthHaul";80.13 "Thalassa";"P0484";"WaterDepthHaul";103.55 "Thalassa";"P0485";"WaterDepthHaul";128.05 "Thalassa";"P0489";"WaterDepthHaul";119.15 "Thalassa";"P0493";"WaterDepthHaul";135.55 "Thalassa";"P0494";"WaterDepthHaul";155.62 "Thalassa";"P0495";"WaterDepthHaul";153.13 "Thalassa";"P0500";"WaterDepthHaul";203.98 "Thalassa";"P0501";"WaterDepthHaul";4423.8301 "Thalassa";"P0505";"WaterDepthHaul";1404.54 "Thalassa";"P0506";"WaterDepthHaul";141 "Thalassa";"P0509";"WaterDepthHaul";303.82 "Thalassa";"P0510";"WaterDepthHaul";158.59 "Thalassa";"P0511";"WaterDepthHaul";954.93 "Thalassa";"P0512";"WaterDepthHaul";81.7 "Thalassa";"P0523";"WaterDepthHaul";54.66 "Thalassa";"P0535";"WaterDepthHaul";69.6 "Thalassa";"P0545";"WaterDepthHaul";69.55 "Thalassa";"P0553";"WaterDepthHaul";98.62 "Thalassa";"P0554";"WaterDepthHaul";82.92 "Thalassa";"P0563";"WaterDepthHaul";63.14 "vesselName";"id";"gearID";"metadataType";"gearMetadataValue" "Thalassa";"P0372";"Chalut 76/70";"CableLength";20.8333333333333 "Thalassa";"P0377";"Chalut 76/70";"CableLength";111.833333333333 "Thalassa";"P0378";"Chalut 76/70";"CableLength";106.166666666667 "Thalassa";"P0379";"Chalut 76/70";"CableLength";106.5 "Thalassa";"P0383";"Chalut 76/70";"CableLength";26.5 "Thalassa";"P0384";"Chalut 76/70";"CableLength";106.333333333333 "Thalassa";"P0385";"Chalut 76/70";"CableLength";80 "Thalassa";"P0389";"Chalut 76/70";"CableLength";38.3333333333333 "Thalassa";"P0390";"Chalut 76/70";"CableLength";67.8333333333333 "Thalassa";"P0395";"Chalut 76/70";"CableLength";66.5 "Thalassa";"P0396";"Chalut 76/70";"CableLength";106.666666666667 "Thalassa";"P0399";"Chalut 76/70";"CableLength";110.666666666667 "Thalassa";"P0400";"Chalut 76/70";"CableLength";20.6666666666667 "Thalassa";"P0404";"Chalut 76/70";"CableLength";37.5 "Thalassa";"P0405";"Chalut 57/52";"CableLength";14.5 "Thalassa";"P0409";"Chalut 76/70";"CableLength";105.166666666667 "Thalassa";"P0410";"Chalut 76/70";"CableLength";45 "Thalassa";"P0417";"Chalut 76/70";"CableLength";109.333333333333 "Thalassa";"P0422";"Chalut 57/52";"CableLength";31.6666666666667 "Thalassa";"P0423";"Chalut 76/70";"CableLength";34.6666666666667 "Thalassa";"P0429";"Chalut 76/70";"CableLength";121.333333333333 "Thalassa";"P0430";"Chalut 76/70";"CableLength";115.5 "Thalassa";"P0435";"Chalut 76/70";"CableLength";24 "Thalassa";"P0436";"Chalut 76/70";"CableLength";100.666666666667 "Thalassa";"P0441";"Chalut 76/70";"CableLength";61.3333333333333 "Thalassa";"P0442";"Chalut 76/70";"CableLength";50.8333333333333 "Thalassa";"P0443";"Chalut 57/52";"CableLength";35.5 "Thalassa";"P0444";"Chalut 76/70";"CableLength";26 "Thalassa";"P0449";"Chalut 76/70";"CableLength";37.1666666666667 "Thalassa";"P0450";"Chalut 76/70";"CableLength";112.666666666667 "Thalassa";"P0454";"Chalut 76/70";"CableLength";68.6666666666667 "Thalassa";"P0455";"Chalut 76/70";"CableLength";121 "Thalassa";"P0460";"Chalut 76/70";"CableLength";96.8333333333333 "Thalassa";"P0461";"Chalut 76/70";"CableLength";125.5 "Thalassa";"P0463";"Chalut 76/70";"CableLength";140.166666666667 "Thalassa";"P0464";"Chalut 76/70";"CableLength";142.333333333333 "Thalassa";"P0468";"Chalut 76/70";"CableLength";49 "Thalassa";"P0473";"Chalut 76/70";"CableLength";36 "Thalassa";"P0474";"Chalut 76/70";"CableLength";57.6666666666667 "Thalassa";"P0479";"Chalut 76/70";"CableLength";66.3333333333333 "Thalassa";"P0480";"Chalut 76/70";"CableLength";43.1666666666667 "Thalassa";"P0484";"Chalut 76/70";"CableLength";75 "Thalassa";"P0485";"Chalut 76/70";"CableLength";103 "Thalassa";"P0489";"Chalut 76/70";"CableLength";88 "Thalassa";"P0493";"Chalut 76/70";"CableLength";118.666666666667 "Thalassa";"P0494";"Chalut 76/70";"CableLength";50.5 "Thalassa";"P0495";"Chalut 76/70";"CableLength";138.5 "Thalassa";"P0500";"Chalut 76/70";"CableLength";174.166666666667 "Thalassa";"P0501";"Chalut 76/70";"CableLength";109.375 "Thalassa";"P0505";"Chalut 76/70";"CableLength";78.6666666666667 "Thalassa";"P0506";"Chalut 76/70";"CableLength";116.333333333333 "Thalassa";"P0509";"Chalut 76/70";"CableLength";83.1666666666667 "Thalassa";"P0510";"Chalut 76/70";"CableLength";133.666666666667 "Thalassa";"P0511";"Chalut 76/70";"CableLength";67.5 "Thalassa";"P0512";"Chalut 76/70";"CableLength";0 "Thalassa";"P0523";"Chalut 76/70";"CableLength";28.8333333333333 "Thalassa";"P0535";"Chalut 76/70";"CableLength";40.8333333333333 "Thalassa";"P0545";"Chalut 76/70";"CableLength";53.6666666666667 "Thalassa";"P0553";"Chalut 76/70";"CableLength";58.8333333333333 "Thalassa";"P0554";"Chalut 76/70";"CableLength";25.1666666666667 "Thalassa";"P0563";"Chalut 76/70";"CableLength";34.8333333333333 "Thalassa";"P0372";"Chalut 76/70";"MinSpeed";2.97 "Thalassa";"P0377";"Chalut 76/70";"MinSpeed";2.66 "Thalassa";"P0378";"Chalut 76/70";"MinSpeed";3.02 "Thalassa";"P0379";"Chalut 76/70";"MinSpeed";2.74 "Thalassa";"P0383";"Chalut 76/70";"MinSpeed";2.94 "Thalassa";"P0384";"Chalut 76/70";"MinSpeed";3.34 "Thalassa";"P0385";"Chalut 76/70";"MinSpeed";3.48 "Thalassa";"P0389";"Chalut 76/70";"MinSpeed";3.03 "Thalassa";"P0390";"Chalut 76/70";"MinSpeed";3.21 "Thalassa";"P0395";"Chalut 76/70";"MinSpeed";3.01 "Thalassa";"P0396";"Chalut 76/70";"MinSpeed";2.82 "Thalassa";"P0399";"Chalut 76/70";"MinSpeed";3.1 "Thalassa";"P0400";"Chalut 76/70";"MinSpeed";3.04 "Thalassa";"P0404";"Chalut 76/70";"MinSpeed";3.02 "Thalassa";"P0405";"Chalut 57/52";"MinSpeed";2.03 "Thalassa";"P0409";"Chalut 76/70";"MinSpeed";2.52 "Thalassa";"P0410";"Chalut 76/70";"MinSpeed";3.13 "Thalassa";"P0417";"Chalut 76/70";"MinSpeed";2.22 "Thalassa";"P0422";"Chalut 57/52";"MinSpeed";1.57 "Thalassa";"P0423";"Chalut 76/70";"MinSpeed";3.05 "Thalassa";"P0429";"Chalut 76/70";"MinSpeed";2.54 "Thalassa";"P0430";"Chalut 76/70";"MinSpeed";2.65 "Thalassa";"P0435";"Chalut 76/70";"MinSpeed";1.58 "Thalassa";"P0436";"Chalut 76/70";"MinSpeed";2.6 "Thalassa";"P0441";"Chalut 76/70";"MinSpeed";2.59 "Thalassa";"P0442";"Chalut 76/70";"MinSpeed";2.75 "Thalassa";"P0443";"Chalut 57/52";"MinSpeed";3.06 "Thalassa";"P0444";"Chalut 76/70";"MinSpeed";2.35 "Thalassa";"P0449";"Chalut 76/70";"MinSpeed";2.62 "Thalassa";"P0450";"Chalut 76/70";"MinSpeed";3.86 "Thalassa";"P0454";"Chalut 76/70";"MinSpeed";2.53 "Thalassa";"P0455";"Chalut 76/70";"MinSpeed";2.41 "Thalassa";"P0460";"Chalut 76/70";"MinSpeed";2.75 "Thalassa";"P0461";"Chalut 76/70";"MinSpeed";1.74 "Thalassa";"P0463";"Chalut 76/70";"MinSpeed";3.31 "Thalassa";"P0464";"Chalut 76/70";"MinSpeed";3.06 "Thalassa";"P0468";"Chalut 76/70";"MinSpeed";2.83 "Thalassa";"P0473";"Chalut 76/70";"MinSpeed";3.18 "Thalassa";"P0474";"Chalut 76/70";"MinSpeed";3.41 "Thalassa";"P0479";"Chalut 76/70";"MinSpeed";3.1 "Thalassa";"P0480";"Chalut 76/70";"MinSpeed";2.64 "Thalassa";"P0484";"Chalut 76/70";"MinSpeed";3.79 "Thalassa";"P0485";"Chalut 76/70";"MinSpeed";1.11 "Thalassa";"P0489";"Chalut 76/70";"MinSpeed";2.38 "Thalassa";"P0493";"Chalut 76/70";"MinSpeed";2.87 "Thalassa";"P0494";"Chalut 76/70";"MinSpeed";3.23 "Thalassa";"P0495";"Chalut 76/70";"MinSpeed";3.52 "Thalassa";"P0500";"Chalut 76/70";"MinSpeed";2.75 "Thalassa";"P0501";"Chalut 76/70";"MinSpeed";3.18 "Thalassa";"P0505";"Chalut 76/70";"MinSpeed";3.49 "Thalassa";"P0506";"Chalut 76/70";"MinSpeed";2.55 "Thalassa";"P0509";"Chalut 76/70";"MinSpeed";3.08 "Thalassa";"P0510";"Chalut 76/70";"MinSpeed";3.57 "Thalassa";"P0511";"Chalut 76/70";"MinSpeed";2.81 "Thalassa";"P0512";"Chalut 76/70";"MinSpeed";7.32 "Thalassa";"P0523";"Chalut 76/70";"MinSpeed";2.84 "Thalassa";"P0535";"Chalut 76/70";"MinSpeed";3.04 "Thalassa";"P0545";"Chalut 76/70";"MinSpeed";3.4 "Thalassa";"P0553";"Chalut 76/70";"MinSpeed";2.65 "Thalassa";"P0554";"Chalut 76/70";"MinSpeed";2.81 "Thalassa";"P0563";"Chalut 76/70";"MinSpeed";2.71 "Thalassa";"P0372";"Chalut 76/70";"MaxSpeed";4.62 "Thalassa";"P0377";"Chalut 76/70";"MaxSpeed";7.6 "Thalassa";"P0378";"Chalut 76/70";"MaxSpeed";5 "Thalassa";"P0379";"Chalut 76/70";"MaxSpeed";9.25 "Thalassa";"P0383";"Chalut 76/70";"MaxSpeed";5.75 "Thalassa";"P0384";"Chalut 76/70";"MaxSpeed";5.09 "Thalassa";"P0385";"Chalut 76/70";"MaxSpeed";4.99 "Thalassa";"P0389";"Chalut 76/70";"MaxSpeed";6.18 "Thalassa";"P0390";"Chalut 76/70";"MaxSpeed";5.11 "Thalassa";"P0395";"Chalut 76/70";"MaxSpeed";5.13 "Thalassa";"P0396";"Chalut 76/70";"MaxSpeed";6.14 "Thalassa";"P0399";"Chalut 76/70";"MaxSpeed";8.18 "Thalassa";"P0400";"Chalut 76/70";"MaxSpeed";5.33 "Thalassa";"P0404";"Chalut 76/70";"MaxSpeed";9.51 "Thalassa";"P0405";"Chalut 57/52";"MaxSpeed";7.21 "Thalassa";"P0409";"Chalut 76/70";"MaxSpeed";5.63 "Thalassa";"P0410";"Chalut 76/70";"MaxSpeed";5.88 "Thalassa";"P0417";"Chalut 76/70";"MaxSpeed";6.79 "Thalassa";"P0422";"Chalut 57/52";"MaxSpeed";6.57 "Thalassa";"P0423";"Chalut 76/70";"MaxSpeed";4.57 "Thalassa";"P0429";"Chalut 76/70";"MaxSpeed";5.02 "Thalassa";"P0430";"Chalut 76/70";"MaxSpeed";5.95 "Thalassa";"P0435";"Chalut 76/70";"MaxSpeed";5.2 "Thalassa";"P0436";"Chalut 76/70";"MaxSpeed";7.56 "Thalassa";"P0441";"Chalut 76/70";"MaxSpeed";7.34 "Thalassa";"P0442";"Chalut 76/70";"MaxSpeed";8.25 "Thalassa";"P0443";"Chalut 57/52";"MaxSpeed";6.76 "Thalassa";"P0444";"Chalut 76/70";"MaxSpeed";8.93 "Thalassa";"P0449";"Chalut 76/70";"MaxSpeed";7.98 "Thalassa";"P0450";"Chalut 76/70";"MaxSpeed";8.67 "Thalassa";"P0454";"Chalut 76/70";"MaxSpeed";5.77 "Thalassa";"P0455";"Chalut 76/70";"MaxSpeed";5.45 "Thalassa";"P0460";"Chalut 76/70";"MaxSpeed";7.01 "Thalassa";"P0461";"Chalut 76/70";"MaxSpeed";4.47 "Thalassa";"P0463";"Chalut 76/70";"MaxSpeed";9.16 "Thalassa";"P0464";"Chalut 76/70";"MaxSpeed";4.91 "Thalassa";"P0468";"Chalut 76/70";"MaxSpeed";9.6 "Thalassa";"P0473";"Chalut 76/70";"MaxSpeed";4.62 "Thalassa";"P0474";"Chalut 76/70";"MaxSpeed";7.73 "Thalassa";"P0479";"Chalut 76/70";"MaxSpeed";9.54 "Thalassa";"P0480";"Chalut 76/70";"MaxSpeed";6.07 "Thalassa";"P0484";"Chalut 76/70";"MaxSpeed";6.82 "Thalassa";"P0485";"Chalut 76/70";"MaxSpeed";8.2 "Thalassa";"P0489";"Chalut 76/70";"MaxSpeed";9.85 "Thalassa";"P0493";"Chalut 76/70";"MaxSpeed";4.97 "Thalassa";"P0494";"Chalut 76/70";"MaxSpeed";9.19 "Thalassa";"P0495";"Chalut 76/70";"MaxSpeed";4.69 "Thalassa";"P0500";"Chalut 76/70";"MaxSpeed";4.42 "Thalassa";"P0501";"Chalut 76/70";"MaxSpeed";5.78 "Thalassa";"P0505";"Chalut 76/70";"MaxSpeed";5.28 "Thalassa";"P0506";"Chalut 76/70";"MaxSpeed";8.58 "Thalassa";"P0509";"Chalut 76/70";"MaxSpeed";7.33 "Thalassa";"P0510";"Chalut 76/70";"MaxSpeed";6.74 "Thalassa";"P0511";"Chalut 76/70";"MaxSpeed";7.48 "Thalassa";"P0512";"Chalut 76/70";"MaxSpeed";10.29 "Thalassa";"P0523";"Chalut 76/70";"MaxSpeed";7.03 "Thalassa";"P0535";"Chalut 76/70";"MaxSpeed";4.8 "Thalassa";"P0545";"Chalut 76/70";"MaxSpeed";5.88 "Thalassa";"P0553";"Chalut 76/70";"MaxSpeed";5.92 "Thalassa";"P0554";"Chalut 76/70";"MaxSpeed";5.83 "Thalassa";"P0563";"Chalut 76/70";"MaxSpeed";7.65