Running bin\geopdvc_perseus.pl at Wed Jul 24 16:57:50 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4180 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4180 and rname = vnta set_expd(): rov = vnta, diveno = 4180 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 = 4180 AND RovName = 'vnta' RS->Fields(0)->Value= 6539 RS->Fields(1)->Value= 1549989495 RS->Fields(2)->Value= 1550005294 RS->Fields(3)->Value= 2/12/2019 4:38:15 PM RS->Fields(4)->Value= 2/12/2019 9:01:34 PM set_expd(): $self->{EndDDD} = 043 set_expd(): $self->{StartEsecs} = 1549988295 set_expd(): $self->{EndEsecs} = 1550006494 set_expd(): $self->{EndDtg} = 2/12/2019 9:01:34 PM _readLogr(): Reading videologr data from 2019043datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1549988295 & 1550006494 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1550006500, self->{EndEsecs} = 1550006494 _readLogr(): #LOGHOST_SYSTEM_UTC = 1819 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1549988299 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1550006490 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1549988299 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1550006490 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1549988175, Refined EndEsecs = 1550006614 _readLogr(): Reading videologr data from 2019043datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1549988175 & 1550006614 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1550006620, self->{EndEsecs} = 1550006614 _readLogr(): #LOGHOST_SYSTEM_UTC = 1843 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1549988179 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1550006610 bin\geopdvc_perseus.pl: expdid = 6539 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 = 043 (looping to 043) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019043vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019043vnta.txt esecs, east, north, lat, lon, head, pres 1549989992, 0, 0, 36.730360, -122.008757, -123.9, 189.19 1549990492, 0, 0, 36.730483, -122.008393, -104.5, 424.83 1549990992, 0, 0, 36.730353, -122.008475, -56.8, 655.80 1549991492, 0, 0, 36.730577, -122.009000, -17.9, 854.55 1549991992, 0, 0, 36.730928, -122.008862, 7.7, 1021.16 1549992492, 0, 0, 36.731298, -122.008690, 100.4, 1083.48 1549992993, 0, 0, 36.731323, -122.008757, 95.2, 1082.88 1549993493, 0, 0, 36.731322, -122.008618, 89.4, 1080.62 1549993993, 0, 0, 36.731367, -122.008575, 67.9, 1080.40 1549994493, 0, 0, 36.731413, -122.008593, 72.0, 1081.70 1549994993, 0, 0, 36.731483, -122.008532, 129.6, 1079.35 1549995493, 0, 0, 36.731508, -122.008518, 123.1, 1077.09 1549995993, 0, 0, 36.731570, -122.008483, 72.4, 1076.78 1549996493, 0, 0, 36.731840, -122.008153, 56.5, 1072.13 1549996993, 0, 0, 36.732268, -122.007955, 121.7, 1076.69 1549997494, 0, 0, 36.732472, -122.008012, 1.1, 1079.56 1549997994, 0, 0, 36.732708, -122.008308, 78.0, 1079.56 1549998494, 0, 0, 36.732943, -122.008430, 9.4, 1072.31 1549998994, 0, 0, 36.733107, -122.008718, 1.9, 1079.89 1549999494, 0, 0, 36.734032, -122.009612, 21.2, 1074.51 1549999994, 0, 0, 36.734082, -122.008837, 78.9, 1075.17 1550000494, 0, 0, 36.734417, -122.009023, -33.1, 1076.30 1550000994, 0, 0, 36.734408, -122.009487, 77.9, 1078.64 1550001494, 0, 0, 36.734192, -122.009843, -2.8, 1076.02 1550001995, 0, 0, 36.734413, -122.008870, 101.3, 957.89 1550002495, 0, 0, 36.734838, -122.008755, 92.0, 791.32 1550002995, 0, 0, 36.734775, -122.008347, 90.2, 600.47 1550003495, 0, 0, 36.735032, -122.008218, 78.2, 425.96 1550003995, 0, 0, 36.736385, -122.010340, 67.7, 250.98 1550004495, 0, 0, 36.735003, -122.007733, 65.8, 113.27 1550004995, 0, 0, 36.734025, -122.008318, 60.0, 94.07 rovNav(): 043: 15798 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019043vnta.txt 15798 in tList 15798 in {self->{rovT}} 15798 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1549999455 & 1549994130 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 1062.64032841081 rovGDCListRefs(): dStats->sample_range = 1073.41029181257 rovGDCListRefs(): returning (1st elements): 1549989493 36.745260 -122.049682 -111.2 2.70981152487057 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\2019\vnta\nav2019043vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019043vntaedited.txt esecs, east, north, lat, lon, head, pres 1549989992, 0, 0, 36.730357, -122.008753, 236.1, 189.19 1549990492, 0, 0, 36.730486, -122.008392, 255.5, 424.83 1549990992, 0, 0, 36.730359, -122.008467, 303.2, 655.80 1549991492, 0, 0, 36.730301, -122.008974, 342.1, 854.55 1549991992, 0, 0, 36.730902, -122.008839, 7.7, 1021.16 1549992492, 0, 0, 36.731304, -122.008693, 100.4, 1083.48 1549992993, 0, 0, 36.731318, -122.008733, 95.2, 1082.88 1549993493, 0, 0, 36.731333, -122.008625, 89.4, 1080.62 1549993993, 0, 0, 36.731373, -122.008616, 67.9, 1080.40 1549994493, 0, 0, 36.731423, -122.008610, 72.0, 1081.70 1549994993, 0, 0, 36.731495, -122.008532, 129.6, 1079.35 1549995493, 0, 0, 36.731501, -122.008517, 123.1, 1077.09 1549995993, 0, 0, 36.731571, -122.008482, 72.4, 1076.78 1549996493, 0, 0, 36.731838, -122.008155, 56.5, 1072.13 1549996993, 0, 0, 36.732277, -122.007956, 121.7, 1076.69 1549997494, 0, 0, 36.732494, -122.008010, 1.1, 1079.56 1549997994, 0, 0, 36.732721, -122.008312, 78.0, 1079.56 1549998494, 0, 0, 36.732948, -122.008423, 9.4, 1072.31 1549998994, 0, 0, 36.733157, -122.008733, 1.9, 1079.89 1549999494, 0, 0, 36.733539, -122.008903, 21.2, 1074.51 1549999994, 0, 0, 36.734093, -122.008843, 78.9, 1075.17 1550000494, 0, 0, 36.734407, -122.009059, 326.9, 1076.30 1550000994, 0, 0, 36.734397, -122.009471, 77.9, 1078.64 1550001494, 0, 0, 36.734194, -122.009834, 357.2, 1076.02 1550001995, 0, 0, 36.734396, -122.008876, 101.3, 957.89 1550002495, 0, 0, 36.734780, -122.008773, 92.0, 791.32 1550002995, 0, 0, 36.734927, -122.008515, 90.2, 600.47 1550003495, 0, 0, 36.735048, -122.008177, 78.2, 425.96 1550003995, 0, 0, 36.735167, -122.007914, 67.7, 250.98 1550004495, 0, 0, 36.734994, -122.007720, 65.8, 113.27 1550004995, 0, 0, 36.734021, -122.008314, 60.0, 94.07 rovNav(): 043: 15798 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019043vntaedited.txt 15798 in tList 15798 in {self->{rovT}} 15798 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1550005230 & 1549994685 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 1062.64032888064 rovGDCListRefs(): dStats->sample_range = 1073.4102901063 rovGDCListRefs(): returning (1st elements): 1549989493 36.730714 -122.009306 248.8 2.70981501100976 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.73249400 hash{lon} = -122.00861400 latMin = 30.732494 latMax = 42.732494 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.732494 AND 42.732494 AND Longitude BETWEEN -128.008614 AND -116.008614 Dive lat = 36.73249400, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.00861400 & lat = 36.73249400 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4180rov_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,frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/043/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/043/accesses.txt at bin\geopdvc_perseus.pl line 629. vmax = 35 val = 33, color = 1 1 .1 val = 33.5, color = 1 1 0 val = 34, color = 1 0 0 val = 34.5, color = .2 1 0 val = 35, color = 0 1 0 var = Temp, vmin = 4, vmax = 15 val = 4, color = 0 0 1 val = 8, color = 1 1 0 val = 10, color = 0 1 0 val = 15, color = 1 0 0 World = geo2019/vnta/vnta4180lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1843 shipNav(): $#{$self->{shipLat}}[last] = 36.741562 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 = 15799 makeTracks(): Looping through 1843 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4180tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4180mergedCtdNav.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/2019 4:38:15 PM' AND '2/12/2019 9:01:34 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/12/2019 4:38:15 PM' AND '2/12/2019 9:01:34 PM') bin\geopdvc_perseus.pl: Calling placeAnnotations with every 10 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 2 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 1 annotation... frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/vnta4180... 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/2019 4:38:15 PM' AND '2/12/2019 9:01:34 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4180.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6539,'/3Dreplay/3D.asp?dives=vnta4180','vnta4180','','','',4180 Executing sql: UPDATE Dive SET DiveLatMid = 36.7325, DiveLonMid = -122.0086, DiveDepthMid = -1062.6 WHERE RovName = 'vnta' AND DiveNumber = 4180