Running bin\geopdvc_perseus.pl at Sun Aug 4 03:00:03 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4197 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4197 and rname = vnta set_expd(): rov = vnta, diveno = 4197 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 = 4197 AND RovName = 'vnta' RS->Fields(0)->Value= 6619 RS->Fields(1)->Value= 1559836397 RS->Fields(2)->Value= 1559852357 RS->Fields(3)->Value= 6/6/2019 3:53:17 PM RS->Fields(4)->Value= 6/6/2019 8:19:17 PM set_expd(): $self->{EndDDD} = 157 set_expd(): $self->{StartEsecs} = 1559835197 set_expd(): $self->{EndEsecs} = 1559853557 set_expd(): $self->{EndDtg} = 6/6/2019 8:19:17 PM _readLogr(): Reading videologr data from 2019157datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1559835197 & 1559853557 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1559853558, self->{EndEsecs} = 1559853557 _readLogr(): #LOGHOST_SYSTEM_UTC = 1834 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1559835207 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1559853548 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1559835207 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1559853548 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1559835077, Refined EndEsecs = 1559853677 _readLogr(): Reading videologr data from 2019157datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1559835077 & 1559853677 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1559853678, self->{EndEsecs} = 1559853677 _readLogr(): #LOGHOST_SYSTEM_UTC = 1858 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1559835087 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1559853668 bin\geopdvc_perseus.pl: expdid = 6619 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 = 157 (looping to 157) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019157vntaedited.txt no. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019157vnta.txt esecs, east, north, lat, lon, head, pres 1559836897, 0, 0, 36.712713, -122.053772, 44.4, 25.41 1559837397, 0, 0, 36.710600, -122.050658, -93.8, 25.48 1559837897, 0, 0, 36.700193, -122.047973, -138.1, 50.83 1559838397, 0, 0, 36.705292, -122.042057, -150.1, 50.78 1559838897, 0, 0, 36.699610, -122.047225, 123.8, 100.52 1559839397, 0, 0, 36.705360, -122.053387, 115.1, 100.73 1559839898, 0, 0, 36.704292, -122.050220, 109.7, 201.85 1559840398, 0, 0, 36.706247, -122.044650, 97.9, 245.51 1559840898, 0, 0, 36.706838, -122.048078, 99.8, 302.62 1559841398, 0, 0, 36.706107, -122.047482, -149.9, 327.92 1559841898, 0, 0, 36.704343, -122.048552, 177.4, 327.85 1559842398, 0, 0, 36.705587, -122.048827, -3.2, 403.85 1559842898, 0, 0, 36.707383, -122.049548, 152.4, 468.77 1559843398, 0, 0, 36.705393, -122.046675, 158.4, 504.25 1559843898, 0, 0, 36.704658, -122.048013, 155.2, 504.49 1559844398, 0, 0, 36.704452, -122.047548, 154.6, 545.30 1559844898, 0, 0, 36.705910, -122.045918, 37.5, 605.55 1559845399, 0, 0, 36.706987, -122.044453, -137.2, 668.27 1559845899, 0, 0, 36.705178, -122.044192, -173.7, 706.95 1559846399, 0, 0, 36.703947, -122.044513, -172.8, 777.62 1559846899, 0, 0, 36.702500, -122.045872, -142.3, 807.73 1559847399, 0, 0, 36.701777, -122.046572, 142.2, 912.34 1559847899, 0, 0, 36.700455, -122.043543, 132.0, 908.59 1559848399, 0, 0, 36.700315, -122.043087, -51.2, 1010.63 1559848899, 0, 0, 36.702482, -122.044010, -88.0, 1010.55 1559849399, 0, 0, 36.702750, -122.044762, -64.8, 913.88 1559849900, 0, 0, 36.702908, -122.044528, -68.0, 709.97 1559850400, 0, 0, 36.703207, -122.044657, -78.5, 510.49 1559850900, 0, 0, 36.703272, -122.045223, -79.2, 297.63 1559851400, 0, 0, 36.703855, -122.045603, -90.5, 87.83 1559851900, 0, 0, 36.703653, -122.045682, -116.2, 20.28 rovNav(): 157: 15956 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019157vnta.txt 15956 in tList 15956 in {self->{rovT}} 15956 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1559845380 & 1559842140 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/157/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/157/accesses.txt at bin\geopdvc_perseus.pl line 629. ...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 400.662168026904 rovGDCListRefs(): dStats->sample_range = 1002.52267439875 rovGDCListRefs(): returning (1st elements): 1559836398 36.714863 -122.171903 20.2 2.58078063769394 geopdcv.pl(): editedNav flag = 0 Using raw Navigation. bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70478000 hash{lon} = -122.04679200 latMin = 30.70478 latMax = 42.70478 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.70478 AND 42.70478 AND Longitude BETWEEN -128.046792 AND -116.046792 Dive lat = 36.70478000, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04679200 & lat = 36.70478000 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4197rov_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/vnta4197lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1858 shipNav(): $#{$self->{shipLat}}[last] = 36.712094 Position subsampling set to 13 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 = 15957 makeTracks(): Looping through 1858 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4197tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4197mergedCtdNav.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/6/2019 3:53:17 PM' AND '6/6/2019 8:19:17 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/6/2019 3:53:17 PM' AND '6/6/2019 8:19:17 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/vnta4197... 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/6/2019 3:53:17 PM' AND '6/6/2019 8:19:17 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4197.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6619,'/3Dreplay/3D.asp?dives=vnta4197','vnta4197','','','',4197 Executing sql: UPDATE Dive SET DiveLatMid = 36.7048, DiveLonMid = -122.0468, DiveDepthMid = -400.7 WHERE RovName = 'vnta' AND DiveNumber = 4197