Running bin\geopdvc_perseus.pl at Fri Aug 2 03:00:02 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4196 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4196 and rname = vnta set_expd(): rov = vnta, diveno = 4196 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 = 4196 AND RovName = 'vnta' RS->Fields(0)->Value= 6636 RS->Fields(1)->Value= 1559670836 RS->Fields(2)->Value= 1559686104 RS->Fields(3)->Value= 6/4/2019 5:53:56 PM RS->Fields(4)->Value= 6/4/2019 10:08:24 PM set_expd(): $self->{EndDDD} = 155 set_expd(): $self->{StartEsecs} = 1559669636 set_expd(): $self->{EndEsecs} = 1559687304 set_expd(): $self->{EndDtg} = 6/4/2019 10:08:24 PM _readLogr(): Reading videologr data from 2019155datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1559669636 & 1559687304 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1559687314, self->{EndEsecs} = 1559687304 _readLogr(): #LOGHOST_SYSTEM_UTC = 1766 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1559669643 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1559687304 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1559669643 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1559687304 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1559669516, Refined EndEsecs = 1559687424 _readLogr(): Reading videologr data from 2019155datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1559669516 & 1559687424 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1559687434, self->{EndEsecs} = 1559687424 _readLogr(): #LOGHOST_SYSTEM_UTC = 1790 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1559669523 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1559687424 bin\geopdvc_perseus.pl: expdid = 6636 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 = 155 (looping to 155) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019155vntaedited.txt no. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019155vnta.txt esecs, east, north, lat, lon, head, pres 1559671335, 0, 0, 36.712318, -122.175688, 23.2, 24.93 1559671835, 0, 0, 36.713348, -122.175042, 23.0, 24.90 1559672335, 0, 0, 36.711465, -122.175817, -169.1, 50.44 1559672835, 0, 0, 36.710333, -122.172625, 156.7, 55.72 1559673336, 0, 0, 36.711555, -122.178047, 17.0, 75.93 1559673836, 0, 0, 36.712037, -122.174717, -163.5, 100.93 1559674336, 0, 0, 36.710875, -122.176388, -170.7, 101.06 1559674836, 0, 0, 36.710285, -122.176622, 10.2, 131.01 1559675336, 0, 0, 36.712657, -122.176150, 9.0, 130.93 1559675836, 0, 0, 36.709672, -122.176632, 174.7, 151.60 1559676336, 0, 0, 36.710492, -122.176532, 35.2, 201.61 1559676836, 0, 0, 36.712892, -122.175130, 34.1, 201.57 1559677336, 0, 0, 36.712932, -122.174658, 175.5, 251.96 1559677836, 0, 0, 36.711352, -122.174497, 169.0, 259.84 1559678337, 0, 0, 36.712167, -122.175707, -2.6, 302.92 1559678837, 0, 0, 36.715278, -122.175322, -3.7, 341.09 1559679337, 0, 0, 36.713657, -122.175142, 177.8, 403.58 1559679837, 0, 0, 36.712560, -122.175403, 4.7, 463.09 1559680337, 0, 0, 36.714897, -122.175478, 4.5, 504.59 1559680837, 0, 0, 36.716440, -122.175303, -177.8, 586.58 1559681337, 0, 0, 36.714592, -122.175073, 174.1, 605.27 1559681837, 0, 0, 36.713717, -122.175073, 130.1, 676.50 1559682337, 0, 0, 36.712777, -122.172903, 121.6, 706.53 1559682837, 0, 0, 36.712412, -122.172753, -97.8, 668.28 1559683337, 0, 0, 36.712670, -122.173295, -150.2, 517.43 1559683838, 0, 0, 36.713228, -122.173638, 168.5, 533.23 1559684338, 0, 0, 36.713885, -122.173885, -67.2, 445.17 1559684838, 0, 0, 36.714380, -122.174157, -78.2, 265.46 1559685338, 0, 0, 36.714787, -122.173652, -54.5, 70.20 1559685838, 0, 0, 36.714940, -122.172637, -72.3, 8.53 rovNav(): 155: 15266 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019155vnta.txt 15266 in tList 15266 in {self->{rovT}} 15266 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1559684160 & 1559679825 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/155/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/155/accesses.txt at bin\geopdvc_perseus.pl line 629. .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 249.985310368279 rovGDCListRefs(): dStats->sample_range = 697.965671708423 rovGDCListRefs(): returning (1st elements): 1559670836 36.712047 -122.174895 16.0 2.68004144428391 geopdcv.pl(): editedNav flag = 0 Using raw Navigation. bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.71273200 hash{lon} = -122.17502800 latMin = 30.712732 latMax = 42.712732 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.712732 AND 42.712732 AND Longitude BETWEEN -128.175028 AND -116.175028 Dive lat = 36.71273200, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.17502800 & lat = 36.71273200 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4196rov_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/vnta4196lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1790 shipNav(): $#{$self->{shipLat}}[last] = 36.721395 Position subsampling set to 12 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 = 15267 makeTracks(): Looping through 1790 point of ship position data... makeTracks(): posSubsample = 12 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4196tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4196mergedCtdNav.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 '6/4/2019 5:53:56 PM' AND '6/4/2019 10:08:24 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/4/2019 5:53:56 PM' AND '6/4/2019 10:08:24 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/vnta4196... 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 '6/4/2019 5:53:56 PM' AND '6/4/2019 10:08:24 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4196.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6636,'/3Dreplay/3D.asp?dives=vnta4196','vnta4196','','','',4196 Executing sql: UPDATE Dive SET DiveLatMid = 36.7127, DiveLonMid = -122.1750, DiveDepthMid = -250.0 WHERE RovName = 'vnta' AND DiveNumber = 4196