Running bin\geopdvc_perseus.pl at Fri Apr 24 03:00:02 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4280 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4280 and rname = vnta set_expd(): rov = vnta, diveno = 4280 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 = 4280 AND RovName = 'vnta' RS->Fields(0)->Value= 6895 RS->Fields(1)->Value= 1582651306 RS->Fields(2)->Value= 1582670653 RS->Fields(3)->Value= 2/25/2020 5:21:46 PM RS->Fields(4)->Value= 2/25/2020 10:44:13 PM set_expd(): $self->{EndDDD} = 056 set_expd(): $self->{StartEsecs} = 1582650106 set_expd(): $self->{EndEsecs} = 1582671853 set_expd(): $self->{EndDtg} = 2/25/2020 10:44:13 PM _readLogr(): Reading videologr data from 2020056datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1582650106 & 1582671853 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1582671861, self->{EndEsecs} = 1582671853 _readLogr(): #LOGHOST_SYSTEM_UTC = 2174 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1582650110 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1582671851 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1582650110 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1582671851 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1582649986, Refined EndEsecs = 1582671973 _readLogr(): Reading videologr data from 2020056datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1582649986 & 1582671973 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1582671981, self->{EndEsecs} = 1582671973 _readLogr(): #LOGHOST_SYSTEM_UTC = 2198 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1582649990 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1582671971 bin\geopdvc_perseus.pl: expdid = 6895 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, getRaw = 1 rovNav(): 2, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 056 (looping to 056) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020056vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020056vnta.txt esecs, east, north, lat, lon, head, pres 1582651806, 0, 0, 36.694503, -121.999795, 126.4, 142.78 1582652306, 0, 0, 36.693687, -121.998408, 168.6, 211.65 1582652806, 0, 0, 36.693422, -121.998585, 105.0, 203.75 1582653306, 0, 0, 36.693400, -121.998582, 168.3, 205.88 1582653807, 0, 0, 36.693390, -121.998627, 168.0, 205.98 1582654307, 0, 0, 36.693438, -121.998608, 168.5, 205.90 1582654807, 0, 0, 36.693523, -121.998658, 155.7, 149.83 1582655307, 0, 0, 36.693085, -121.997737, 123.0, 150.98 1582655807, 0, 0, 36.693517, -121.998518, -78.4, 150.94 1582656307, 0, 0, 36.693883, -122.000303, 130.9, 201.53 1582656807, 0, 0, 36.694110, -122.000570, -73.2, 201.57 1582657307, 0, 0, 36.694042, -122.000923, 125.6, 251.95 1582657807, 0, 0, 36.693820, -122.000298, -50.7, 251.90 1582658307, 0, 0, 36.694902, -122.003060, 115.2, 289.26 1582658807, 0, 0, 36.694383, -122.001357, -63.1, 302.47 1582659307, 0, 0, 36.695132, -122.003968, 112.4, 352.83 1582659808, 0, 0, 36.694422, -122.002062, -51.2, 354.54 1582660308, 0, 0, 36.695488, -122.004335, 124.3, 403.18 1582660808, 0, 0, 36.695137, -122.003177, -62.5, 405.26 1582661308, 0, 0, 36.695805, -122.005647, 115.8, 453.65 1582661808, 0, 0, 36.695372, -122.004245, -66.0, 453.04 1582662308, 0, 0, 36.696082, -122.006158, -78.8, 452.14 1582662808, 0, 0, 36.696235, -122.006395, 118.5, 491.90 1582663308, 0, 0, 36.695472, -122.004585, -60.7, 500.82 1582663808, 0, 0, 36.696380, -122.007097, -64.9, 504.24 1582664308, 0, 0, 36.695953, -122.005572, 110.3, 554.98 1582664809, 0, 0, 36.695923, -122.005583, -161.6, 557.61 1582665309, 0, 0, 36.696398, -122.006488, -103.9, 572.49 1582665809, 0, 0, 36.696845, -122.007283, -42.3, 554.77 1582666309, 0, 0, 36.696595, -122.007028, -146.7, 557.60 1582666809, 0, 0, 36.696603, -122.006392, 113.6, 583.48 1582667309, 0, 0, 36.696537, -122.005492, -38.6, 529.79 1582667809, 0, 0, 36.697027, -122.005753, -20.4, 476.70 1582668309, 0, 0, 36.697572, -122.005753, -40.5, 434.18 1582668809, 0, 0, 36.697785, -122.005733, -111.8, 437.80 1582669309, 0, 0, 36.698252, -122.005658, 21.6, 404.11 1582669810, 0, 0, 36.698228, -122.005462, -2.6, 228.51 1582670310, 0, 0, 36.698457, -122.004720, -66.2, 36.77 rovNav(): 056: 19342 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020056vnta.txt 19342 in tList 19342 in {self->{rovT}} 19342 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1582664535 & 1582668360 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 351.420364032667 rovGDCListRefs(): dStats->sample_range = 577.067259785956 rovGDCListRefs(): returning (1st elements): 1582651307 36.701253 -122.025077 -147.2 2.58078374322308 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 056 (looping to 056) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020056vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020056vntaedited.txt esecs, east, north, lat, lon, head, pres 1582651806, 0, 0, 36.694514, -121.999796, 126.4, 142.78 1582652306, 0, 0, 36.693692, -121.998554, 168.6, 211.65 1582652806, 0, 0, 36.693425, -121.998595, 105.0, 203.75 1582653306, 0, 0, 36.693422, -121.998588, 168.3, 205.88 1582653807, 0, 0, 36.693400, -121.998621, 168.0, 205.98 1582654307, 0, 0, 36.693432, -121.998612, 168.5, 205.90 1582654807, 0, 0, 36.693581, -121.998643, 155.7, 149.83 1582655307, 0, 0, 36.693125, -121.997774, 123.0, 150.98 1582655807, 0, 0, 36.693522, -121.998500, 281.6, 150.94 1582656307, 0, 0, 36.693885, -122.000308, 130.9, 201.53 1582656807, 0, 0, 36.694113, -122.000583, 286.8, 201.57 1582657307, 0, 0, 36.694046, -122.000902, 125.6, 251.95 1582657807, 0, 0, 36.693846, -122.000297, 309.3, 251.90 1582658307, 0, 0, 36.694912, -122.003074, 115.2, 289.26 1582658807, 0, 0, 36.694396, -122.001371, 296.9, 302.47 1582659307, 0, 0, 36.695120, -122.003942, 112.4, 352.83 1582659808, 0, 0, 36.694437, -122.002073, 308.8, 354.54 1582660308, 0, 0, 36.695462, -122.004299, 124.3, 403.18 1582660808, 0, 0, 36.695144, -122.003213, 297.5, 405.26 1582661308, 0, 0, 36.695796, -122.005612, 115.8, 453.65 1582661808, 0, 0, 36.695380, -122.004260, 294.0, 453.04 1582662308, 0, 0, 36.696081, -122.006158, 281.2, 452.14 1582662808, 0, 0, 36.696239, -122.006393, 118.5, 491.90 1582663308, 0, 0, 36.695487, -122.004634, 299.3, 500.82 1582663808, 0, 0, 36.696383, -122.007094, 295.1, 504.24 1582664308, 0, 0, 36.695953, -122.005565, 110.3, 554.98 1582664809, 0, 0, 36.695929, -122.005583, 198.4, 557.61 1582665309, 0, 0, 36.696394, -122.006495, 256.1, 572.49 1582665809, 0, 0, 36.696849, -122.007294, 317.7, 554.77 1582666309, 0, 0, 36.696597, -122.007016, 213.3, 557.60 1582666809, 0, 0, 36.696601, -122.006389, 113.6, 583.48 1582667309, 0, 0, 36.696536, -122.005483, 321.4, 529.79 1582667809, 0, 0, 36.697025, -122.005759, 339.6, 476.70 1582668309, 0, 0, 36.697566, -122.005776, 319.5, 434.18 1582668809, 0, 0, 36.697795, -122.005757, 248.2, 437.80 1582669309, 0, 0, 36.698265, -122.005649, 21.6, 404.11 1582669810, 0, 0, 36.698233, -122.005449, 357.4, 228.51 1582670310, 0, 0, 36.698465, -122.004726, 293.8, 36.77 rovNav(): 056: 19342 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020056vntaedited.txt 19342 in tList 19342 in {self->{rovT}} 19342 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1582656285 & 1582669185 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 351.420363815211 rovGDCListRefs(): dStats->sample_range = 577.067258288703 rovGDCListRefs(): returning (1st elements): 1582651307 36.694466 -122.000137 212.8 2.58078529171658 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69538700 hash{lon} = -122.00419000 latMin = 30.695387 latMax = 42.695387 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.695387 AND 42.695387 AND Longitude BETWEEN -128.00419 AND -116.00419 Dive lat = 36.69538700, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.00419000 & lat = 36.69538700 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4280rov_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 varframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/056/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/056/accesses.txt at bin\geopdvc_perseus.pl line 629. = 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/vnta4280lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2198 shipNav(): $#{$self->{shipLat}}[last] = 36.721620 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 = 19343 makeTracks(): Looping through 2198 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4280tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2020/vnta/vnta4280mergedCtdNav.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 '2/25/2020 5:21:46 PM' AND '2/25/2020 10:44:13 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/25/2020 5:21:46 PM' AND '2/25/2020 10:44:13 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/vnta4280... 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 '2/25/2020 5:21:46 PM' AND '2/25/2020 10:44:13 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2020/vnta/vnta4280.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6895,'/3Dreplay/3D.asp?dives=vnta4280','vnta4280','','','',4280 Executing sql: UPDATE Dive SET DiveLatMid = 36.6954, DiveLonMid = -122.0042, DiveDepthMid = -351.4 WHERE RovName = 'vnta' AND DiveNumber = 4280