Running bin\geopdvc_perseus.pl at Sat Apr 11 03:00:03 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4274 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4274 and rname = vnta set_expd(): rov = vnta, diveno = 4274 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 = 4274 AND RovName = 'vnta' RS->Fields(0)->Value= 6859 RS->Fields(1)->Value= 1581526568 RS->Fields(2)->Value= 1581546576 RS->Fields(3)->Value= 2/12/2020 4:56:08 PM RS->Fields(4)->Value= 2/12/2020 10:29:36 PM set_expd(): $self->{EndDDD} = 043 set_expd(): $self->{StartEsecs} = 1581525368 set_expd(): $self->{EndEsecs} = 1581547776 set_expd(): $self->{EndDtg} = 2/12/2020 10:29:36 PM _readLogr(): Reading videologr data from 2020043datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1581525368 & 1581547776 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1581547782, self->{EndEsecs} = 1581547776 _readLogr(): #LOGHOST_SYSTEM_UTC = 2240 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1581525372 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1581547772 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1581525372 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1581547772 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1581525248, Refined EndEsecs = 1581547896 _readLogr(): Reading videologr data from 2020043datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1581525248 & 1581547896 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1581547902, self->{EndEsecs} = 1581547896 _readLogr(): #LOGHOST_SYSTEM_UTC = 2264 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1581525252 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1581547892 bin\geopdvc_perseus.pl: expdid = 6859 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 = 043 (looping to 043) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020043vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020043vnta.txt esecs, east, north, lat, lon, head, pres 1581527067, 0, 0, 36.700440, -122.049442, 20.1, 100.89 1581527567, 0, 0, 36.700962, -122.048618, 40.8, 102.22 1581528067, 0, 0, 36.701052, -122.047702, 27.7, 126.03 1581528567, 0, 0, 36.701288, -122.046765, 29.1, 127.72 1581529067, 0, 0, 36.701492, -122.045692, 34.2, 127.68 1581529567, 0, 0, 36.701637, -122.044827, -8.6, 152.65 1581530068, 0, 0, 36.702552, -122.044522, 2.8, 157.88 1581530568, 0, 0, 36.703385, -122.043930, 36.0, 177.32 1581531068, 0, 0, 36.704295, -122.043568, -3.9, 199.91 1581531568, 0, 0, 36.705027, -122.043055, 43.0, 202.53 1581532068, 0, 0, 36.705440, -122.042665, 21.2, 206.65 1581532568, 0, 0, 36.705780, -122.042808, 19.2, 233.59 1581533068, 0, 0, 36.705552, -122.043148, 132.6, 258.66 1581533568, 0, 0, 36.704747, -122.043120, 129.0, 257.29 1581534068, 0, 0, 36.704193, -122.042897, 109.7, 282.53 1581534568, 0, 0, 36.704038, -122.042777, 81.7, 302.23 1581535069, 0, 0, 36.703900, -122.042793, 35.4, 308.14 1581535569, 0, 0, 36.703308, -122.043252, 163.4, 327.80 1581536069, 0, 0, 36.702383, -122.043365, 121.8, 349.15 1581536569, 0, 0, 36.701800, -122.043238, 176.1, 369.33 1581537069, 0, 0, 36.700577, -122.043332, 176.4, 389.58 1581537569, 0, 0, 36.699782, -122.043350, 174.9, 403.95 1581538069, 0, 0, 36.698948, -122.043617, -168.6, 403.25 1581538569, 0, 0, 36.697905, -122.043785, -171.7, 437.89 1581539070, 0, 0, 36.697158, -122.043780, -179.6, 453.64 1581539570, 0, 0, 36.696655, -122.043930, -164.5, 471.51 1581540070, 0, 0, 36.696123, -122.043867, 176.1, 490.64 1581540570, 0, 0, 36.695512, -122.043862, 179.7, 506.10 1581541070, 0, 0, 36.694690, -122.043837, -177.1, 513.30 1581541570, 0, 0, 36.693902, -122.044132, -172.0, 533.98 1581542070, 0, 0, 36.693308, -122.044592, -124.3, 527.63 1581542570, 0, 0, 36.691957, -122.045268, -178.4, 524.99 1581543070, 0, 0, 36.690940, -122.045447, 178.1, 474.25 1581543570, 0, 0, 36.690478, -122.045610, -171.4, 462.63 1581544071, 0, 0, 36.689857, -122.045437, 167.2, 444.57 1581544571, 0, 0, 36.689450, -122.045363, 179.8, 432.69 1581545071, 0, 0, 36.688947, -122.046538, -90.6, 352.37 1581545571, 0, 0, 36.688783, -122.046527, -89.6, 242.23 1581546071, 0, 0, 36.688633, -122.045890, -108.0, 128.04 1581546571, 0, 0, 36.688575, -122.045297, -53.1, 4.43 rovNav(): 043: 20005 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020043vnta.txt 20005 in tList 20005 in {self->{rovT}} 20005 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1581530370 & 1581544890 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 307.012707394548 rovGDCListRefs(): dStats->sample_range = 527.482201855027 rovGDCListRefs(): returning (1st elements): 1581526568 36.699855 -122.050828 -0.8 2.73960047251708 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 043 (looping to 043) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020043vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020043vntaedited.txt esecs, east, north, lat, lon, head, pres 1581527067, 0, 0, 36.700439, -122.049477, 20.1, 100.89 1581527567, 0, 0, 36.700949, -122.048602, 40.8, 102.22 1581528067, 0, 0, 36.701046, -122.047708, 27.7, 126.03 1581528567, 0, 0, 36.701229, -122.046714, 29.1, 127.72 1581529067, 0, 0, 36.701483, -122.045706, 34.2, 127.68 1581529567, 0, 0, 36.701632, -122.044829, 351.4, 152.65 1581530068, 0, 0, 36.702562, -122.044507, 2.8, 157.88 1581530568, 0, 0, 36.703380, -122.043938, 36.0, 177.32 1581531068, 0, 0, 36.704299, -122.043573, 356.1, 199.91 1581531568, 0, 0, 36.705023, -122.043036, 43.0, 202.53 1581532068, 0, 0, 36.705473, -122.042631, 21.2, 206.65 1581532568, 0, 0, 36.705836, -122.042753, 19.2, 233.59 1581533068, 0, 0, 36.705534, -122.043115, 132.6, 258.66 1581533568, 0, 0, 36.704743, -122.043152, 129.0, 257.29 1581534068, 0, 0, 36.704181, -122.042851, 109.7, 282.53 1581534568, 0, 0, 36.704018, -122.042758, 81.7, 302.23 1581535069, 0, 0, 36.703906, -122.042809, 35.4, 308.14 1581535569, 0, 0, 36.703267, -122.043218, 163.4, 327.80 1581536069, 0, 0, 36.702391, -122.043354, 121.8, 349.15 1581536569, 0, 0, 36.701816, -122.043133, 176.1, 369.33 1581537069, 0, 0, 36.700557, -122.043305, 176.4, 389.58 1581537569, 0, 0, 36.699747, -122.043356, 174.9, 403.95 1581538069, 0, 0, 36.698943, -122.043618, 191.4, 403.25 1581538569, 0, 0, 36.697889, -122.043794, 188.3, 437.89 1581539070, 0, 0, 36.697135, -122.043758, 180.4, 453.64 1581539570, 0, 0, 36.696639, -122.043893, 195.5, 471.51 1581540070, 0, 0, 36.696117, -122.043871, 176.1, 490.64 1581540570, 0, 0, 36.695512, -122.043865, 179.7, 506.10 1581541070, 0, 0, 36.694685, -122.043833, 182.9, 513.30 1581541570, 0, 0, 36.693894, -122.044137, 188.0, 533.98 1581542070, 0, 0, 36.693312, -122.044573, 235.7, 527.63 1581542570, 0, 0, 36.691944, -122.045268, 181.6, 524.99 1581543070, 0, 0, 36.690933, -122.045432, 178.1, 474.25 1581543570, 0, 0, 36.690470, -122.045607, 188.6, 462.63 1581544071, 0, 0, 36.689892, -122.045435, 167.2, 444.57 1581544571, 0, 0, 36.689435, -122.045370, 179.8, 432.69 1581545071, 0, 0, 36.688952, -122.046547, 269.4, 352.37 1581545571, 0, 0, 36.688785, -122.046522, 270.4, 242.23 1581546071, 0, 0, 36.688639, -122.045875, 252.0, 128.04 1581546571, 0, 0, 36.688571, -122.045302, 306.9, 4.43 rovNav(): 043: 20005 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020043vntaedited.txt 20005 in tList 20005 in {self->{rovT}} 20005 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1581546105 & 1581538290 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/043/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/043/accesses.txt at bin\geopdvc_perseus.pl line 629. .................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 307.012708140965 rovGDCListRefs(): dStats->sample_range = 527.48220049468 rovGDCListRefs(): returning (1st elements): 1581526568 36.700194 -122.050120 359.2 2.73960039041076 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70052150 hash{lon} = -122.04387800 latMin = 30.7005215 latMax = 42.7005215 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.7005215 AND 42.7005215 AND Longitude BETWEEN -128.043878 AND -116.043878 Dive lat = 36.70052150, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04387800 & lat = 36.70052150 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... makeROVorig(): Number of points greater than 20,000. Skipping every other point for .wrl file. inline_name = vnta4274rov_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/vnta4274lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2264 shipNav(): $#{$self->{shipLat}}[last] = 36.707651 Position subsampling set to 16 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 = 20006 makeTracks(): Looping through 2264 point of ship position data... makeTracks(): posSubsample = 16 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4274tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2020/vnta/vnta4274mergedCtdNav.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 '2/12/2020 4:56:08 PM' AND '2/12/2020 10:29:36 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/12/2020 4:56:08 PM' AND '2/12/2020 10:29:36 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/vnta4274... 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 '2/12/2020 4:56:08 PM' AND '2/12/2020 10:29:36 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2020/vnta/vnta4274.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6859,'/3Dreplay/3D.asp?dives=vnta4274','vnta4274','','','',4274 Executing sql: UPDATE Dive SET DiveLatMid = 36.7005, DiveLonMid = -122.0439, DiveDepthMid = -307.0 WHERE RovName = 'vnta' AND DiveNumber = 4274