Running bin\geopdvc_perseus.pl at Mon Nov 2 03:00:03 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4295 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4295 and rname = vnta set_expd(): rov = vnta, diveno = 4295 set_expd(): Executing sql: SELECT ExpeditionID_FK, DateDiff(ss, '01/01/70', DiveStartDtg), DateDiff(ss, '01/01/70', DiveEndDtg), DiveStartDtg, DiveEndDtg FROM Dive WHERE DiveNumber = 4295 AND RovName = 'vnta' RS->Fields(0)->Value= 7008 RS->Fields(1)->Value= 1599234480 RS->Fields(2)->Value= 1599253655 RS->Fields(3)->Value= 9/4/2020 3:48:00 PM RS->Fields(4)->Value= 9/4/2020 9:07:35 PM set_expd(): $self->{EndDDD} = 248 set_expd(): $self->{StartEsecs} = 1599233280 set_expd(): $self->{EndEsecs} = 1599254855 set_expd(): $self->{EndDtg} = 9/4/2020 9:07:35 PM _readLogr(): Reading videologr data from 2020248datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1599233280 & 1599254855 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1599254863, self->{EndEsecs} = 1599254855 _readLogr(): #LOGHOST_SYSTEM_UTC = 2157 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1599233283 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1599254853 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1599233283 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1599254853 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1599233160, Refined EndEsecs = 1599254975 _readLogr(): Reading videologr data from 2020248datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1599233160 & 1599254975 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1599254983, self->{EndEsecs} = 1599254975 _readLogr(): #LOGHOST_SYSTEM_UTC = 2181 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1599233163 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1599254973 bin\geopdvc_perseus.pl: expdid = 7008 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 248 (looping to 248) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020248vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020248vnta.txt esecs, east, north, lat, lon, head, pres 1599235007, 0, 0, 36.746027, -122.050770, -30.2, 179.69 1599235507, 0, 0, 36.746450, -122.051483, -29.9, 353.34 1599236008, 0, 0, 36.747153, -122.051883, -30.7, 514.85 1599236508, 0, 0, 36.746878, -122.051432, -93.7, 631.03 1599237008, 0, 0, 36.746797, -122.051910, 154.4, 642.45 1599237508, 0, 0, 36.745860, -122.051308, -164.2, 637.26 1599238008, 0, 0, 36.745593, -122.050900, -146.7, 628.61 1599238508, 0, 0, 36.745612, -122.050943, -160.5, 628.68 1599239008, 0, 0, 36.745553, -122.050872, 167.2, 626.92 1599239508, 0, 0, 36.744793, -122.050240, -120.4, 630.99 1599240008, 0, 0, 36.744708, -122.050305, -47.0, 631.42 1599240508, 0, 0, 36.744805, -122.050313, -46.6, 631.54 1599241009, 0, 0, 36.744755, -122.050260, -35.5, 631.61 1599241509, 0, 0, 36.744363, -122.049772, 160.2, 635.05 1599242009, 0, 0, 36.744582, -122.049220, -27.5, 629.22 1599242509, 0, 0, 36.745540, -122.048058, 32.6, 642.12 1599243009, 0, 0, 36.745560, -122.048050, -98.3, 644.11 1599243509, 0, 0, 36.745990, -122.047537, 28.4, 676.38 1599244009, 0, 0, 36.746613, -122.047530, -51.5, 695.66 1599244509, 0, 0, 36.746705, -122.048712, -96.0, 674.73 1599245009, 0, 0, 36.746848, -122.050103, -95.7, 649.58 1599245509, 0, 0, 36.746852, -122.051362, -114.4, 635.36 1599246010, 0, 0, 36.747020, -122.051720, 145.6, 640.01 1599246510, 0, 0, 36.746875, -122.051943, -129.4, 644.68 1599247010, 0, 0, 36.746405, -122.053203, -59.7, 676.39 1599247510, 0, 0, 36.746442, -122.052583, 122.4, 663.85 1599248010, 0, 0, 36.746267, -122.051873, 98.2, 642.45 1599248510, 0, 0, 36.746157, -122.050267, -142.7, 635.61 1599249010, 0, 0, 36.746302, -122.051372, -143.4, 629.44 1599249510, 0, 0, 36.746330, -122.051323, 62.1, 631.02 1599250010, 0, 0, 36.746562, -122.051528, -34.5, 587.52 1599250511, 0, 0, 36.746635, -122.051790, -35.3, 484.12 1599251011, 0, 0, 36.746392, -122.052302, -33.9, 385.49 1599251511, 0, 0, 36.746255, -122.052417, -34.3, 297.30 1599252011, 0, 0, 36.745495, -122.051925, -33.4, 209.32 1599252511, 0, 0, 36.744345, -122.051190, -34.7, 123.72 1599253011, 0, 0, 36.743725, -122.051025, -33.9, 57.15 1599253511, 0, 0, 36.742952, -122.051063, -34.6, 8.49 rovNav(): 248: 19122 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020248vnta.txt 19122 in tList 19122 in {self->{rovT}} 19122 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1599242910 & 1599237330 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX rovGDCListRefs(): dMedian = 625.864196910147 rovGDCListRefs(): dStats->sample_range = 689.71340542113 rovGDCListRefs(): returning (1st elements): 1599234508 36.746965 -122.051435 44.8 2.77929297742553 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 248 (looping to 248) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020248vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020248vntaedited.txt esecs, east, north, lat, lon, head, pres 1599235007, 0, 0, 36.746030, -122.050782, 329.8, 179.69 1599235507, 0, 0, 36.746447, -122.051512, 330.1, 353.34 1599236008, 0, 0, 36.746834, -122.051892, 329.3, 514.85 1599236508, 0, 0, 36.746880, -122.051427, 266.3, 631.03 1599237008, 0, 0, 36.746790, -122.051895, 154.4, 642.45 1599237508, 0, 0, 36.745856, -122.051324, 195.8, 637.26 1599238008, 0, 0, 36.745590, -122.050931, 213.3, 628.61 1599238508, 0, 0, 36.745583, -122.050926, 199.5, 628.68 1599239008, 0, 0, 36.745538, -122.050889, 167.2, 626.92 1599239508, 0, 0, 36.744796, -122.050243, 239.6, 630.99 1599240008, 0, 0, 36.744748, -122.050276, 313.0, 631.42 1599240508, 0, 0, 36.744801, -122.050298, 313.4, 631.54 1599241009, 0, 0, 36.744762, -122.050272, 324.5, 631.61 1599241509, 0, 0, 36.744348, -122.049769, 160.2, 635.05 1599242009, 0, 0, 36.744571, -122.049219, 332.5, 629.22 1599242509, 0, 0, 36.745534, -122.048064, 32.6, 642.12 1599243009, 0, 0, 36.745579, -122.048044, 261.7, 644.11 1599243509, 0, 0, 36.745998, -122.047465, 28.4, 676.38 1599244009, 0, 0, 36.746591, -122.047543, 308.5, 695.66 1599244509, 0, 0, 36.746718, -122.048708, 264.0, 674.73 1599245009, 0, 0, 36.746814, -122.050160, 264.3, 649.58 1599245509, 0, 0, 36.746876, -122.051364, 245.6, 635.36 1599246010, 0, 0, 36.747008, -122.051647, 145.6, 640.01 1599246510, 0, 0, 36.746856, -122.051962, 230.6, 644.68 1599247010, 0, 0, 36.746418, -122.053162, 300.3, 676.39 1599247510, 0, 0, 36.746471, -122.052584, 122.4, 663.85 1599248010, 0, 0, 36.746261, -122.051928, 98.2, 642.45 1599248510, 0, 0, 36.746179, -122.050282, 217.3, 635.61 1599249010, 0, 0, 36.746322, -122.051377, 216.6, 629.44 1599249510, 0, 0, 36.746334, -122.051329, 62.1, 631.02 1599250010, 0, 0, 36.746560, -122.051544, 325.5, 587.52 1599250511, 0, 0, 36.746481, -122.051783, 324.7, 484.12 1599251011, 0, 0, 36.746433, -122.052165, 326.1, 385.49 1599251511, 0, 0, 36.746255, -122.052418, 325.7, 297.30 1599252011, 0, 0, 36.745488, -122.051947, 326.6, 209.32 1599252511, 0, 0, 36.744346, -122.051201, 325.3, 123.72 1599253011, 0, 0, 36.743735, -122.051012, 326.1, 57.15 1599253511, 0, 0, 36.743258, -122.051051, 325.4, 8.49 rovNav(): 248: 19122 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020248vntaedited.txt 19122 in tList 19122 in {self->{rovT}} 19122 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1599241785 & 1599250860 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX rovGDCListRefs(): dMedian = 625.864196301263 rovGDCListRefs(): dStats->sample_range = 689.713405626247 rovGDCListRefs(): returning (1st elements): 1599234508 36.746696 -122.050917 44.8 2.77929304355398 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74625400 hash{lon} = -122.05115100 latMin = 30.746254 latMax = 42.746254 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.746254 AND 42.746254 AND Longitude BETWEEN -128.051151 AND -116.051151 Dive lat = 36.74625400, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05115100 & lat = 36.74625400 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4295rov_orig.wrl Making color lookup world... var = Light, vmin = 40, vmax = 100 val = 40, color = .8 .7 0 val = 70, color = .6 .5 0 val = 85, color = .1 .1 0 val = 100, color = 1 1 1 var = O2, vmin = 0.2, vmax = 5 val = 0.2, color = 1 1 1 val = 0.3, color = 1 1 .2 val = 0.5, color = 1 1 0 val = 0.7, color = 0 1 0 val = 5, color = 0 0 1 var = Sal, vmin = 33, vmax = 35 val = 33, color = 1 1 .1 val = 33.5, color = 1 1 0 val = 34, color = 1 0 0 val = 34.5, color = .2 1 0 val = 35, color = 0 1 0 var = Temp, vmin = 4, vmax = 15 val = 4, color = 0 0 1 val = 8, color = 1 1 0 val = 10, color = 0 1 0 val = 15, color = 1 0 0 World = geo2020/vnta/vnta4295lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2181 shipNav(): $#{$self->{shipLat}}[last] = 36.75029frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/248/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/248/accesses.txt at bin\geopdvc_perseus.pl line 629. 7 Position subsampling set to 15 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 19123 makeTracks(): Looping through 2181 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4295tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2020/vnta/vnta4295mergedCtdNav.txt... bin\geopdvc_perseus.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '9/4/2020 3:48:00 PM' AND '9/4/2020 9:07:35 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/4/2020 3:48:00 PM' AND '9/4/2020 9:07:35 PM') bin\geopdvc_perseus.pl: Calling placeAnnotations with every 10 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 2 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 1 annotation... frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/vnta4295... iList = bin\geopdvc_perseus.pl: Number of images returned from expd->frameGrabs(every=>1)} = 0 bin\geopdvc_perseus.pl: Calling placeImages with every 10 image... bin\geopdvc_perseus.pl: Calling placeImages with every 2 image... bin\geopdvc_perseus.pl: Calling placeImages with every 1 image... bin\geopdvc_perseus.pl: Samples: samples(): Executing sql: SELECT DateDiff(ss, '01/01/70', CollectionEventDtg) AS Esecs, CollectionVIMSConcept, FrameGrabImageURL, SampleID, CollectionRefName FROM vwCollSamplePerson WHERE (CollectionEventDTG BETWEEN '9/4/2020 3:48:00 PM' AND '9/4/2020 9:07:35 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2020/vnta/vnta4295.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',7008,'/3Dreplay/3D.asp?dives=vnta4295','vnta4295','','','',4295 Executing sql: UPDATE Dive SET DiveLatMid = 36.7463, DiveLonMid = -122.0512, DiveDepthMid = -625.9 WHERE RovName = 'vnta' AND DiveNumber = 4295