Running bin\geopdvc_perseus.pl at Sat Feb 1 03:00:02 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4242 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4242 and rname = vnta set_expd(): rov = vnta, diveno = 4242 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 = 4242 AND RovName = 'vnta' RS->Fields(0)->Value= 6807 RS->Fields(1)->Value= 1575477127 RS->Fields(2)->Value= 1575489561 RS->Fields(3)->Value= 12/4/2019 4:32:07 PM RS->Fields(4)->Value= 12/4/2019 7:59:21 PM set_expd(): $self->{EndDDD} = 338 set_expd(): $self->{StartEsecs} = 1575475927 set_expd(): $self->{EndEsecs} = 1575490761 set_expd(): $self->{EndDtg} = 12/4/2019 7:59:21 PM _readLogr(): Reading videologr data from 2019338datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1575475927 & 1575490761 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1575490765, self->{EndEsecs} = 1575490761 _readLogr(): #LOGHOST_SYSTEM_UTC = 1482 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1575475935 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1575490755 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1575475935 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1575490755 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1575475807, Refined EndEsecs = 1575490881 _readLogr(): Reading videologr data from 2019338datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1575475807 & 1575490881 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1575490885, self->{EndEsecs} = 1575490881 _readLogr(): #LOGHOST_SYSTEM_UTC = 1506 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1575475815 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1575490875 bin\geopdvc_perseus.pl: expdid = 6807 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): getRaw = 1 rovnavCTDO(): calcUTM = 0 rovNav(): 1, getRaw = 1 rovNav(): 2, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 338 (looping to 338) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019338vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019338vnta.txt esecs, east, north, lat, lon, head, pres 1575477627, 0, 0, 36.707003, -122.165298, -118.5, 139.37 1575478127, 0, 0, 36.706992, -122.165395, -147.1, 121.74 1575478628, 0, 0, 36.706073, -122.165577, -107.7, 193.25 1575479128, 0, 0, 36.706043, -122.166192, -12.1, 329.86 1575479628, 0, 0, 36.706077, -122.165952, -60.9, 490.73 1575480128, 0, 0, 36.706223, -122.165963, -61.3, 655.11 1575480628, 0, 0, 36.706228, -122.165257, -84.6, 558.63 1575481128, 0, 0, 36.706555, -122.165425, -95.2, 496.64 1575481628, 0, 0, 36.706420, -122.166638, -109.5, 534.21 1575482128, 0, 0, 36.706763, -122.165940, -138.2, 586.87 1575482628, 0, 0, 36.706810, -122.165710, -132.0, 617.51 1575483128, 0, 0, 36.706532, -122.166132, -101.9, 658.70 1575483629, 0, 0, 36.706677, -122.166095, -118.8, 744.57 1575484129, 0, 0, 36.706503, -122.166115, -130.0, 821.68 1575484629, 0, 0, 36.706683, -122.165707, -125.7, 885.11 1575485129, 0, 0, 36.707118, -122.165850, -28.7, 886.34 1575485629, 0, 0, 36.707772, -122.166185, -27.6, 882.95 1575486129, 0, 0, 36.707623, -122.165537, 150.1, 884.98 1575486629, 0, 0, 36.706865, -122.165403, -125.0, 890.27 1575487129, 0, 0, 36.706327, -122.166167, -110.4, 892.74 1575487629, 0, 0, 36.706113, -122.166095, -147.2, 813.99 1575488130, 0, 0, 36.706982, -122.165658, -147.6, 564.31 1575488630, 0, 0, 36.706672, -122.165640, -147.1, 340.38 1575489130, 0, 0, 36.707287, -122.164175, -147.1, 162.27 rovNav(): 338: 12430 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019338vnta.txt 12430 in tList 12430 in {self->{rovT}} 12430 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1575477615 & 1575487845 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 598.017504491663 rovGDCListRefs(): dStats->sample_range = 881.63264304421 rovGDCListRefs(): returning (1st elements): 1575477128 36.706445 -122.165647 -161.4 2.68004277172803 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 338 (looping to 338) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019338vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019338vntaedited.txt esecs, east, north, lat, lon, head, pres 1575477627, 0, 0, 36.707003, -122.165298, 241.5, 139.37 1575478127, 0, 0, 36.706992, -122.165395, 212.9, 121.74 1575478628, 0, 0, 36.706073, -122.165577, 252.3, 193.25 1575479128, 0, 0, 36.706043, -122.166192, 347.9, 329.86 1575479628, 0, 0, 36.706077, -122.165952, 299.1, 490.73 1575480128, 0, 0, 36.706223, -122.165963, 298.7, 655.11 1575480628, 0, 0, 36.706228, -122.165257, 275.4, 558.63 1575481128, 0, 0, 36.706555, -122.165425, 264.8, 496.64 1575481628, 0, 0, 36.706420, -122.166638, 250.5, 534.21 1575482128, 0, 0, 36.706763, -122.165940, 221.8, 586.87 1575482628, 0, 0, 36.706810, -122.165710, 228.0, 617.51 1575483128, 0, 0, 36.706532, -122.166132, 258.1, 658.70 1575483629, 0, 0, 36.706677, -122.166095, 241.2, 744.57 1575484129, 0, 0, 36.706503, -122.166115, 230.0, 821.68 1575484629, 0, 0, 36.706683, -122.165707, 234.3, 885.11 1575485129, 0, 0, 36.707118, -122.165850, 331.3, 886.34 1575485629, 0, 0, 36.707772, -122.166185, 332.4, 882.95 1575486129, 0, 0, 36.707623, -122.165537, 150.1, 884.98 1575486629, 0, 0, 36.706865, -122.165403, 235.0, 890.27 1575487129, 0, 0, 36.706327, -122.166167, 249.6, 892.74 1575487629, 0, 0, 36.706113, -122.166095, 212.8, 813.99 1575488130, 0, 0, 36.706982, -122.165658, 212.4, 564.31 1575488630, 0, 0, 36.706672, -122.165640, 212.9, 340.38 1575489130, 0, 0, 36.707287, -122.164175, 212.9, 162.27 rovNav(): 338: 12430 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019338vntaedited.txt 12430 in tList 12430 in {self->{rovT}} 12430 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1575481695 & 1575478215 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 598.017504491663 rovGDCListRefs(): dStats->sample_range = 881.63264304421 rovGDCListRefs(): returning (1st elements): 1575477128 36.706445 -122.165647 198.6 2.68004277172803 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70664300 hash{lon} = -122.16583000 latMin = 30.706643 latMax = 42.706643 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.706643 AND 42.706643 AND Longitude BETWEEN -128.16583 AND -116.16583 Dive lat = 36.70664300, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.16583000 & lat = 36.70664300 Using olon = frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/338/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/338/accesses.txt at bin\geopdvc_perseus.pl line 629. -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4242rov_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 = geo2019/vnta/vnta4242lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1506 shipNav(): $#{$self->{shipLat}}[last] = 36.712364 Position subsampling set to 10 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 = 12431 makeTracks(): Looping through 1506 point of ship position data... makeTracks(): posSubsample = 10 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4242tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4242mergedCtdNav.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 '12/4/2019 4:32:07 PM' AND '12/4/2019 7:59:21 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/4/2019 4:32:07 PM' AND '12/4/2019 7:59:21 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/2019/vnta4242... 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 '12/4/2019 4:32:07 PM' AND '12/4/2019 7:59:21 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4242.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6807,'/3Dreplay/3D.asp?dives=vnta4242','vnta4242','','','',4242 Executing sql: UPDATE Dive SET DiveLatMid = 36.7066, DiveLonMid = -122.1658, DiveDepthMid = -598.0 WHERE RovName = 'vnta' AND DiveNumber = 4242