Running bin\geopdvc_perseus.pl at Fri Oct 9 03:00:02 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4290 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4290 and rname = vnta set_expd(): rov = vnta, diveno = 4290 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 = 4290 AND RovName = 'vnta' RS->Fields(0)->Value= 6995 RS->Fields(1)->Value= 1597165053 RS->Fields(2)->Value= 1597181338 RS->Fields(3)->Value= 8/11/2020 4:57:33 PM RS->Fields(4)->Value= 8/11/2020 9:28:58 PM set_expd(): $self->{EndDDD} = 224 set_expd(): $self->{StartEsecs} = 1597163853 set_expd(): $self->{EndEsecs} = 1597182538 set_expd(): $self->{EndDtg} = 8/11/2020 9:28:58 PM _readLogr(): Reading videologr data from 2020224datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1597163853 & 1597182538 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1597182541, self->{EndEsecs} = 1597182538 _readLogr(): #LOGHOST_SYSTEM_UTC = 1867 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1597163860 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1597182531 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1597163860 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1597182531 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1597163733, Refined EndEsecs = 1597182658 _readLogr(): Reading videologr data from 2020224datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1597163733 & 1597182658 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1597182661, self->{EndEsecs} = 1597182658 _readLogr(): #LOGHOST_SYSTEM_UTC = 1891 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1597163740 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1597182651 bin\geopdvc_perseus.pl: expdid = 6995 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 = 224 (looping to 224) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020224vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020224vnta.txt esecs, east, north, lat, lon, head, pres 1597165553, 0, 0, 36.701927, -122.034738, -15.6, 25.51 1597166053, 0, 0, 36.703620, -122.035582, 44.5, 50.74 1597166553, 0, 0, 36.706630, -122.033188, 43.5, 50.83 1597167053, 0, 0, 36.707958, -122.032657, 43.3, 101.08 1597167553, 0, 0, 36.706750, -122.028522, 43.9, 101.11 1597168053, 0, 0, 36.710607, -122.030993, -132.9, 201.62 1597168553, 0, 0, 36.709075, -122.033230, -134.9, 211.10 1597169053, 0, 0, 36.708642, -122.032240, 155.8, 302.18 1597169553, 0, 0, 36.706773, -122.030853, 153.6, 310.78 1597170053, 0, 0, 36.706432, -122.032130, -102.9, 403.46 1597170554, 0, 0, 36.705840, -122.033797, -178.6, 460.88 1597171054, 0, 0, 36.704270, -122.033588, -178.0, 504.66 1597171554, 0, 0, 36.703282, -122.033250, -101.8, 569.89 1597172054, 0, 0, 36.701960, -122.032803, 171.9, 605.81 1597172554, 0, 0, 36.700840, -122.032223, 172.4, 668.01 1597173054, 0, 0, 36.702250, -122.033977, -57.9, 706.76 1597173554, 0, 0, 36.703057, -122.035048, 132.2, 802.90 1597174054, 0, 0, 36.701560, -122.032817, 132.0, 807.67 1597174554, 0, 0, 36.701087, -122.031958, -40.5, 904.98 1597175054, 0, 0, 36.702937, -122.034000, -45.6, 908.83 1597175555, 0, 0, 36.703150, -122.034037, 137.4, 1009.76 1597176055, 0, 0, 36.701337, -122.031757, 137.1, 1009.82 1597176555, 0, 0, 36.701123, -122.031600, -139.3, 908.52 1597177055, 0, 0, 36.701488, -122.031518, -148.1, 755.98 1597177555, 0, 0, 36.701805, -122.031477, -147.4, 586.49 1597178055, 0, 0, 36.701767, -122.031453, 134.8, 421.26 1597178555, 0, 0, 36.702088, -122.032212, -94.6, 302.54 1597179055, 0, 0, 36.701400, -122.031358, -94.8, 302.50 1597179555, 0, 0, 36.701563, -122.034765, -94.5, 243.83 1597180055, 0, 0, 36.701943, -122.034570, -87.0, 79.92 1597180556, 0, 0, 36.701572, -122.032828, -87.5, 10.08 1597181056, 0, 0, 36.702992, -122.034128, -123.8, 9.95 rovNav(): 224: 16282 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020224vnta.txt 16282 in tList 16282 in {self->{rovT}} 16282 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1597176120 & 1597176045 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 399.97858883872 rovGDCListRefs(): dStats->sample_range = 997.64292635604 rovGDCListRefs(): returning (1st elements): 1597165054 36.700088 -122.034133 -19.8 2.58078400903236 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 224 (looping to 224) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020224vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020224vntaedited.txt esecs, east, north, lat, lon, head, pres 1597165553, 0, 0, 36.701943, -122.034727, 344.4, 25.51 1597166053, 0, 0, 36.703719, -122.035430, 44.5, 50.74 1597166553, 0, 0, 36.706632, -122.033201, 43.5, 50.83 1597167053, 0, 0, 36.707977, -122.032656, 43.3, 101.08 1597167553, 0, 0, 36.710578, -122.030522, 43.9, 101.11 1597168053, 0, 0, 36.710602, -122.030996, 227.1, 201.62 1597168553, 0, 0, 36.709089, -122.033243, 225.1, 211.10 1597169053, 0, 0, 36.708641, -122.032237, 155.8, 302.18 1597169553, 0, 0, 36.706779, -122.030845, 153.6, 310.78 1597170053, 0, 0, 36.706434, -122.032169, 257.1, 403.46 1597170554, 0, 0, 36.705905, -122.033818, 181.4, 460.88 1597171054, 0, 0, 36.704260, -122.033513, 182.0, 504.66 1597171554, 0, 0, 36.703295, -122.033253, 258.2, 569.89 1597172054, 0, 0, 36.701938, -122.032781, 171.9, 605.81 1597172554, 0, 0, 36.700850, -122.032212, 172.4, 668.01 1597173054, 0, 0, 36.702250, -122.033987, 302.1, 706.76 1597173554, 0, 0, 36.703102, -122.035091, 132.2, 802.90 1597174054, 0, 0, 36.701540, -122.032804, 132.0, 807.67 1597174554, 0, 0, 36.701089, -122.031948, 319.5, 904.98 1597175054, 0, 0, 36.702954, -122.034010, 314.4, 908.83 1597175555, 0, 0, 36.703138, -122.034034, 137.4, 1009.76 1597176055, 0, 0, 36.701329, -122.031755, 137.1, 1009.82 1597176555, 0, 0, 36.701115, -122.031590, 220.7, 908.52 1597177055, 0, 0, 36.701478, -122.031516, 211.9, 755.98 1597177555, 0, 0, 36.701791, -122.031466, 212.6, 586.49 1597178055, 0, 0, 36.701757, -122.031405, 134.8, 421.26 1597178555, 0, 0, 36.701576, -122.031946, 265.4, 302.54 1597179055, 0, 0, 36.701305, -122.034709, 265.2, 302.50 1597179555, 0, 0, 36.701513, -122.034807, 265.5, 243.83 1597180055, 0, 0, 36.701957, -122.034479, 273.0, 79.92 1597180556, 0, 0, 36.702526, -122.034426, 272.5, 10.08 1597181056, 0, 0, 36.702982, -122.034131, 236.2, 9.95 rovNav(): 224: 16282 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020224vntaedited.txt 16282 in tList 16282 in {self->{rovT}} 16282 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1597169310 & 1597180290 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 399.978588980168 rovGDCListRefs(): dStats->sample_range = 997.642926933213 rovGDCListReframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/224/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/224/accesses.txt at bin\geopdvc_perseus.pl line 629. fs(): returning (1st elements): 1597165054 36.700680 -122.034155 340.2 2.58078387396058 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70264900 hash{lon} = -122.03297600 latMin = 30.702649 latMax = 42.702649 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.702649 AND 42.702649 AND Longitude BETWEEN -128.032976 AND -116.032976 Dive lat = 36.70264900, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.03297600 & lat = 36.70264900 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4290rov_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 = geo2020/vnta/vnta4290lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1891 shipNav(): $#{$self->{shipLat}}[last] = 36.723146 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 = 16283 makeTracks(): Looping through 1891 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4290tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2020/vnta/vnta4290mergedCtdNav.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 '8/11/2020 4:57:33 PM' AND '8/11/2020 9:28:58 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '8/11/2020 4:57:33 PM' AND '8/11/2020 9:28:58 PM') bin\geopdvc_perseus.pl: Calling placeAnnotations with every 10 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 2 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 1 annotation... frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/vnta4290... 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 '8/11/2020 4:57:33 PM' AND '8/11/2020 9:28:58 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2020/vnta/vnta4290.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6995,'/3Dreplay/3D.asp?dives=vnta4290','vnta4290','','','',4290 Executing sql: UPDATE Dive SET DiveLatMid = 36.7026, DiveLonMid = -122.0330, DiveDepthMid = -400.0 WHERE RovName = 'vnta' AND DiveNumber = 4290