Running bin\geopdvc_perseus.pl at Fri Sep 6 03:00:02 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4203 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4203 and rname = vnta set_expd(): rov = vnta, diveno = 4203 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 = 4203 AND RovName = 'vnta' RS->Fields(0)->Value= 6662 RS->Fields(1)->Value= 1562689826 RS->Fields(2)->Value= 1562708271 RS->Fields(3)->Value= 7/9/2019 4:30:26 PM RS->Fields(4)->Value= 7/9/2019 9:37:51 PM set_expd(): $self->{EndDDD} = 190 set_expd(): $self->{StartEsecs} = 1562688626 set_expd(): $self->{EndEsecs} = 1562709471 set_expd(): $self->{EndDtg} = 7/9/2019 9:37:51 PM _readLogr(): Reading videologr data from 2019190datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1562688626 & 1562709471 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1562709479, self->{EndEsecs} = 1562709471 _readLogr(): #LOGHOST_SYSTEM_UTC = 2084 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1562688629 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1562709469 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1562688629 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1562709469 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1562688506, Refined EndEsecs = 1562709591 _readLogr(): Reading videologr data from 2019190datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1562688506 & 1562709591 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1562709599, self->{EndEsecs} = 1562709591 _readLogr(): #LOGHOST_SYSTEM_UTC = 2108 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1562688509 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1562709589 bin\geopdvc_perseus.pl: expdid = 6662 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 = 190 (looping to 190) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019190vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019190vnta.txt esecs, east, north, lat, lon, head, pres 1562690326, 0, 0, 36.700555, -122.038230, 53.6, 103.30 1562690826, 0, 0, 36.701005, -122.039047, -54.5, 157.85 1562691326, 0, 0, 36.698485, -122.031413, -44.8, 190.53 1562691826, 0, 0, 36.701342, -122.038472, -93.0, 217.98 1562692327, 0, 0, 36.701232, -122.038472, -133.0, 264.14 1562692827, 0, 0, 36.701297, -122.038560, 11.2, 314.38 1562693327, 0, 0, 36.701943, -122.038212, 126.7, 353.67 1562693827, 0, 0, 36.702445, -122.038192, -68.9, 395.57 1562694327, 0, 0, 36.702883, -122.038227, 98.4, 430.26 1562694827, 0, 0, 36.703303, -122.037947, 39.0, 509.18 1562695327, 0, 0, 36.703777, -122.037187, 34.4, 575.13 1562695827, 0, 0, 36.703952, -122.036790, 87.7, 617.43 1562696327, 0, 0, 36.704018, -122.035715, 92.5, 682.37 1562696827, 0, 0, 36.704020, -122.034975, 92.3, 743.94 1562697327, 0, 0, 36.704138, -122.034123, 103.7, 794.30 1562697828, 0, 0, 36.704087, -122.033868, 88.9, 802.98 1562698328, 0, 0, 36.704182, -122.033417, -149.9, 787.02 1562698828, 0, 0, 36.704237, -122.032712, 93.3, 772.43 1562699328, 0, 0, 36.704435, -122.031250, 90.2, 738.02 1562699828, 0, 0, 36.704398, -122.030367, 90.9, 689.21 1562700328, 0, 0, 36.704502, -122.029217, 112.9, 654.42 1562700828, 0, 0, 36.704512, -122.027758, 86.8, 612.34 1562701328, 0, 0, 36.704697, -122.026185, 89.1, 565.85 1562701828, 0, 0, 36.704772, -122.024815, 90.0, 537.27 1562702328, 0, 0, 36.704923, -122.024495, 81.6, 521.20 1562702828, 0, 0, 36.704930, -122.023298, 88.9, 493.24 1562703329, 0, 0, 36.704823, -122.022700, 113.1, 474.18 1562703829, 0, 0, 36.704848, -122.022128, 93.4, 483.23 1562704329, 0, 0, 36.704797, -122.020620, 94.4, 517.19 1562704829, 0, 0, 36.704863, -122.019730, 95.1, 513.98 1562705329, 0, 0, 36.704685, -122.018843, 111.8, 482.84 1562705829, 0, 0, 36.704693, -122.017245, 104.8, 440.97 1562706329, 0, 0, 36.704500, -122.015862, 97.2, 378.20 1562706829, 0, 0, 36.704382, -122.015845, -92.9, 313.30 1562707329, 0, 0, 36.704217, -122.016307, -165.7, 252.36 1562707829, 0, 0, 36.704078, -122.016378, 172.7, 142.28 rovNav(): 190: 18441 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019190vnta.txt 18441 in tList 18441 in {self->{rovT}} 18441 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1562700135 & 1562702055 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 491.006234320322 rovGDCListRefs(): dStats->sample_range = 795.48076343911 rovGDCListRefs(): returning (1st elements): 1562689827 36.702767 -122.029385 -12.4 2.5807833977803 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 190 (looping to 190) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019190vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019190vntaedited.txt esecs, east, north, lat, lon, head, pres 1562690326, 0, 0, 36.700557, -122.038266, 53.6, 103.30 1562690826, 0, 0, 36.701003, -122.039024, 305.5, 157.85 1562691326, 0, 0, 36.701461, -122.038668, 315.2, 190.53 1562691826, 0, 0, 36.701326, -122.038471, 267.0, 217.98 1562692327, 0, 0, 36.701230, -122.038469, 227.0, 264.14 1562692827, 0, 0, 36.701325, -122.038598, 11.2, 314.38 1562693327, 0, 0, 36.701937, -122.038206, 126.7, 353.67 1562693827, 0, 0, 36.702412, -122.038135, 291.1, 395.57 1562694327, 0, 0, 36.702857, -122.038232, 98.4, 430.26 1562694827, 0, 0, 36.703290, -122.037939, 39.0, 509.18 1562695327, 0, 0, 36.703796, -122.037216, 34.4, 575.13 1562695827, 0, 0, 36.703949, -122.036788, 87.7, 617.43 1562696327, 0, 0, 36.704016, -122.035692, 92.5, 682.37 1562696827, 0, 0, 36.704030, -122.034992, 92.3, 743.94 1562697327, 0, 0, 36.704099, -122.034130, 103.7, 794.30 1562697828, 0, 0, 36.704098, -122.033875, 88.9, 802.98 1562698328, 0, 0, 36.704174, -122.033418, 210.1, 787.02 1562698828, 0, 0, 36.704241, -122.032696, 93.3, 772.43 1562699328, 0, 0, 36.704433, -122.031234, 90.2, 738.02 1562699828, 0, 0, 36.704396, -122.030361, 90.9, 689.21 1562700328, 0, 0, 36.704485, -122.029240, 112.9, 654.42 1562700828, 0, 0, 36.704512, -122.027755, 86.8, 612.34 1562701328, 0, 0, 36.704692, -122.026183, 89.1, 565.85 1562701828, 0, 0, 36.704782, -122.024818, 90.0, 537.27 1562702328, 0, 0, 36.704915, -122.024481, 81.6, 521.20 1562702828, 0, 0, 36.704921, -122.023286, 88.9, 493.24 1562703329, 0, 0, 36.704823, -122.022698, 113.1, 474.18 1562703829, 0, 0, 36.704857, -122.022119, 93.4, 483.23 1562704329, 0, 0, 36.704813, -122.020639, 94.4, 517.19 1562704829, 0, 0, 36.704845, -122.019717, 95.1, 513.98 1562705329, 0, 0, 36.704705, -122.018855, 111.8, 482.84 1562705829, 0, 0, 36.704691, -122.017242, 104.8, 440.97 1562706329, 0, 0, 36.704506, -122.015859, 97.2, 378.20 1562706829, 0, 0, 36.704360, -122.015817, 267.1, 313.30 1562707329, 0, 0, 36.704294, -122.016163, 194.3, 252.36 1562707829, 0, 0, 36.704094, -122.016397, 172.7, 142.28 rovNav(): 190: 18441 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019190vntaedited.txt 18441 in tList 18441 in {self->{rovT}} 18441 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1562698785 & 1562690025 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/190/accesses.txt at bin\geopdvc_perseus.pl line 2386. .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 491.006234255211 rovGDCListRefs(): dStats->sample_range = 795.480763153045 rovGDCListRefs(): returning (1st elements): 1562689827 36.700164 -122.038267 347.6 2.58078399169211 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70422400 hash{lon} = -122.03203350 latMin = 30.704224 latMax = 42.704224 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.704224 AND 42.704224 AND Longitude BETWEEN -128.0320335 AND -116.0320335 Dive lat = 36.70422400, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.03203350 & lat = 36.70422400 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4203rov_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/vnta4203lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2108 shipNav(): $#{$self->{shipLat}}[last] = 36.723283 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 = 18442 makeTracks(): Looping through 2108 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4203tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4203mergedCtdNav.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 '7/9/2019 4:30:26 PM' AND '7/9/2019 9:37:51 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/9/2019 4:30:26 PM' AND '7/9/2019 9:37:51 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 everyframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/190/accesses.txt at bin\geopdvc_perseus.pl line 629. 1 annotation... frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/vnta4203... 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 '7/9/2019 4:30:26 PM' AND '7/9/2019 9:37:51 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4203.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6662,'/3Dreplay/3D.asp?dives=vnta4203','vnta4203','','','',4203 Executing sql: UPDATE Dive SET DiveLatMid = 36.7042, DiveLonMid = -122.0320, DiveDepthMid = -491.0 WHERE RovName = 'vnta' AND DiveNumber = 4203