Running bin\geopdvc_perseus.pl at Fri Mar 13 03:00:21 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4256 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4256 and rname = vnta set_expd(): rov = vnta, diveno = 4256 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 = 4256 AND RovName = 'vnta' RS->Fields(0)->Value= 6831 RS->Fields(1)->Value= 1579026456 RS->Fields(2)->Value= 1579042913 RS->Fields(3)->Value= 1/14/2020 6:27:36 PM RS->Fields(4)->Value= 1/14/2020 11:01:53 PM set_expd(): $self->{EndDDD} = 014 set_expd(): $self->{StartEsecs} = 1579025256 set_expd(): $self->{EndEsecs} = 1579044113 set_expd(): $self->{EndDtg} = 1/14/2020 11:01:53 PM _readLogr(): Reading videologr data from 2020014datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1579025256 & 1579044113 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1579044116, self->{EndEsecs} = 1579044113 _readLogr(): #LOGHOST_SYSTEM_UTC = 1884 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1579025266 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1579044106 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1579025266 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1579044106 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1579025136, Refined EndEsecs = 1579044233 _readLogr(): Reading videologr data from 2020014datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1579025136 & 1579044233 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1579044236, self->{EndEsecs} = 1579044233 _readLogr(): #LOGHOST_SYSTEM_UTC = 1908 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1579025146 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1579044226 bin\geopdvc_perseus.pl: expdid = 6831 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 014 (looping to 014) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020014vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020014vnta.txt esecs, east, north, lat, lon, head, pres 1579026882, 0, 0, 36.824553, -122.170970, 94.6, 150.04 1579027382, 0, 0, 36.824287, -122.169878, 127.1, 316.06 1579027882, 0, 0, 36.824927, -122.169735, 20.9, 321.02 1579028382, 0, 0, 36.825860, -122.169347, -3.3, 317.86 1579028882, 0, 0, 36.825897, -122.171033, 112.7, 322.54 1579029383, 0, 0, 36.825237, -122.169682, 61.8, 321.05 1579029883, 0, 0, 36.825230, -122.169712, 127.1, 321.03 1579030383, 0, 0, 36.825487, -122.169553, 17.0, 319.22 1579030883, 0, 0, 36.827278, -122.168650, 18.0, 307.81 1579031383, 0, 0, 36.829190, -122.167273, 22.3, 311.30 1579031883, 0, 0, 36.831460, -122.165338, 31.1, 302.29 1579032383, 0, 0, 36.833392, -122.163138, 41.3, 274.02 1579032883, 0, 0, 36.835225, -122.160655, 44.8, 220.52 1579033384, 0, 0, 36.836278, -122.158720, 66.2, 176.44 1579033884, 0, 0, 36.836983, -122.158793, -120.5, 172.15 1579034384, 0, 0, 36.835295, -122.161573, 144.8, 236.40 1579034884, 0, 0, 36.836053, -122.159285, 53.2, 182.30 1579035384, 0, 0, 36.837120, -122.156107, 72.7, 146.11 1579035884, 0, 0, 36.837890, -122.153672, 70.9, 133.84 1579036384, 0, 0, 36.839058, -122.152375, 70.0, 127.19 1579036884, 0, 0, 36.839743, -122.150620, 68.2, 122.94 1579037384, 0, 0, 36.839917, -122.150062, -148.7, 121.85 1579037884, 0, 0, 36.838380, -122.152393, -132.9, 129.01 1579038385, 0, 0, 36.837332, -122.154388, 75.1, 139.23 1579038885, 0, 0, 36.839527, -122.150783, 63.6, 122.89 1579039385, 0, 0, 36.841062, -122.147558, 68.8, 116.83 1579039885, 0, 0, 36.841663, -122.145000, 83.7, 114.85 1579040385, 0, 0, 36.842013, -122.142778, 87.1, 113.39 1579040885, 0, 0, 36.842722, -122.140332, 77.6, 109.88 1579041385, 0, 0, 36.843763, -122.138147, 69.9, 109.12 1579041885, 0, 0, 36.845193, -122.137723, -35.4, 70.04 1579042385, 0, 0, 36.846238, -122.138917, -35.1, 13.55 1579042886, 0, 0, 36.846532, -122.139590, -36.5, 13.54 rovNav(): 014: 16453 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020014vnta.txt 16453 in tList 16453 in {self->{rovT}} 16453 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1579029555 & 1579036230 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 155.466674126931 rovGDCListRefs(): dStats->sample_range = 318.165111609035 rovGDCListRefs(): returning (1st elements): 1579026457 36.843520 -122.188450 -16.7 2.58075125921048 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 014 (looping to 014) Does file exist?: \\atlas\RovNavEdit\2020\vnta\nav2020014vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2020\vnta\nav2020014vntaedited.txt esecs, east, north, lat, lon, head, pres 1579026882, 0, 0, 36.824550, -122.170969, 94.6, 150.04 1579027382, 0, 0, 36.824274, -122.169888, 127.1, 316.06 1579027882, 0, 0, 36.824933, -122.169735, 20.9, 321.02 1579028382, 0, 0, 36.825856, -122.169356, 356.7, 317.86 1579028882, 0, 0, 36.825884, -122.170985, 112.7, 322.54 1579029383, 0, 0, 36.825223, -122.169703, 61.8, 321.05 1579029883, 0, 0, 36.825215, -122.169714, 127.1, 321.03 1579030383, 0, 0, 36.825501, -122.169554, 17.0, 319.22 1579030883, 0, 0, 36.827261, -122.168654, 18.0, 307.81 1579031383, 0, 0, 36.829203, -122.167271, 22.3, 311.30 1579031883, 0, 0, 36.831462, -122.165328, 31.1, 302.29 1579032383, 0, 0, 36.833398, -122.163156, 41.3, 274.02 1579032883, 0, 0, 36.835233, -122.160652, 44.8, 220.52 1579033384, 0, 0, 36.836278, -122.158707, 66.2, 176.44 1579033884, 0, 0, 36.836971, -122.158818, 239.5, 172.15 1579034384, 0, 0, 36.835283, -122.161504, 144.8, 236.40 1579034884, 0, 0, 36.836078, -122.159245, 53.2, 182.30 1579035384, 0, 0, 36.837121, -122.156101, 72.7, 146.11 1579035884, 0, 0, 36.837892, -122.153613, 70.9, 133.84 1579036384, 0, 0, 36.839059, -122.152363, 70.0, 127.19 1579036884, 0, 0, 36.839728, -122.150590, 68.2, 122.94 1579037384, 0, 0, 36.839899, -122.150065, 211.3, 121.85 1579037884, 0, 0, 36.838362, -122.152402, 227.1, 129.01 1579038385, 0, 0, 36.837341, -122.154378, 75.1, 139.23 1579038885, 0, 0, 36.839521, -122.150756, 63.6, 122.89 1579039385, 0, 0, 36.841074, -122.147572, 68.8, 116.83 1579039885, 0, 0, 36.841658, -122.144980, 83.7, 114.85 1579040385, 0, 0, 36.842008, -122.142772, 87.1, 113.39 1579040885, 0, 0, 36.842707, -122.140290, 77.6, 109.88 1579041385, 0, 0, 36.843759, -122.138120, 69.9, 109.12 1579041885, 0, 0, 36.845239, -122.137803, 324.6, 70.04 1579042385, 0, 0, 36.846239, -122.138936, 324.9, 13.55 1579042886, 0, 0, 36.846533, -122.139599, 323.5, 13.54 rovNav(): 014: 16453 in tList after reading from \\atlas\RovNavEdit\2020\vnta\nav2020014vntaedited.txt 16453 in tList 16453 in {self->{rovT}} 16453 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1579040175 & 1579034940 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/014/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2020/014/accesses.txt at bin\geopdvc_perseus.pl line 629. ..................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 155.466673961762 rovGDCListRefs(): dStats->sample_range = 318.165107089898 rovGDCListRefs(): returning (1st elements): 1579026457 36.824138 -122.170631 343.3 2.58075568751843 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.83664550 hash{lon} = -122.15829950 latMin = 30.8366455 latMax = 42.8366455 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.8366455 AND 42.8366455 AND Longitude BETWEEN -128.1582995 AND -116.1582995 Dive lat = 36.83664550, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.15829950 & lat = 36.83664550 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4256rov_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/vnta4256lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1908 shipNav(): $#{$self->{shipLat}}[last] = 36.840297 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 = 16454 makeTracks(): Looping through 1908 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4256tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2020/vnta/vnta4256mergedCtdNav.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 '1/14/2020 6:27:36 PM' AND '1/14/2020 11:01:53 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '1/14/2020 6:27:36 PM' AND '1/14/2020 11:01:53 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/vnta4256... 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 '1/14/2020 6:27:36 PM' AND '1/14/2020 11:01:53 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2020/vnta/vnta4256.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6831,'/3Dreplay/3D.asp?dives=vnta4256','vnta4256','','','',4256 Executing sql: UPDATE Dive SET DiveLatMid = 36.8366, DiveLonMid = -122.1583, DiveDepthMid = -155.5 WHERE RovName = 'vnta' AND DiveNumber = 4256