Running bin\geopdvc_perseus.pl at Wed Jul 24 16:52:28 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4167 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4167 and rname = vnta set_expd(): rov = vnta, diveno = 4167 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 = 4167 AND RovName = 'vnta' RS->Fields(0)->Value= 6479 RS->Fields(1)->Value= 1544548011 RS->Fields(2)->Value= 1544568134 RS->Fields(3)->Value= 12/11/2018 5:06:51 PM RS->Fields(4)->Value= 12/11/2018 10:42:14 PM set_expd(): $self->{EndDDD} = 345 set_expd(): $self->{StartEsecs} = 1544546811 set_expd(): $self->{EndEsecs} = 1544569334 set_expd(): $self->{EndDtg} = 12/11/2018 10:42:14 PM _readLogr(): Reading videologr data from 2018345datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1544546811 & 1544569334 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1544569342, self->{EndEsecs} = 1544569334 _readLogr(): #LOGHOST_SYSTEM_UTC = 2251 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1544546821 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1544569332 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1544546821 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1544569332 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1544546691, Refined EndEsecs = 1544569454 _readLogr(): Reading videologr data from 2018345datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1544546691 & 1544569454 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1544569462, self->{EndEsecs} = 1544569454 _readLogr(): #LOGHOST_SYSTEM_UTC = 2275 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1544546701 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1544569452 bin\geopdvc_perseus.pl: expdid = 6479 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 = 345 (looping to 345) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018345vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018345vnta.txt esecs, east, north, lat, lon, head, pres 1544548511, 0, 0, 36.747317, -122.052740, 129.3, 200.76 1544549011, 0, 0, 36.747203, -122.052435, 112.3, 446.29 1544549511, 0, 0, 36.747363, -122.051725, -175.1, 641.43 1544550011, 0, 0, 36.747063, -122.051703, -67.4, 640.10 1544550511, 0, 0, 36.747025, -122.051760, -52.9, 639.72 1544551011, 0, 0, 36.746970, -122.051608, 170.4, 639.10 1544551511, 0, 0, 36.746763, -122.051478, -66.4, 633.15 1544552011, 0, 0, 36.747018, -122.051125, -66.2, 633.19 1544552511, 0, 0, 36.746760, -122.051438, -66.7, 633.19 1544553011, 0, 0, 36.746747, -122.051422, -67.1, 633.22 1544553512, 0, 0, 36.746752, -122.051413, -72.2, 633.30 1544554012, 0, 0, 36.746742, -122.051443, -72.1, 633.30 1544554512, 0, 0, 36.746367, -122.051205, -160.3, 630.55 1544555012, 0, 0, 36.746305, -122.051172, 135.2, 630.82 1544555512, 0, 0, 36.746342, -122.051243, 143.6, 630.87 1544556012, 0, 0, 36.746310, -122.051213, 165.2, 630.94 1544556512, 0, 0, 36.746318, -122.051235, 165.4, 630.93 1544557012, 0, 0, 36.746380, -122.051235, -178.6, 630.53 1544557513, 0, 0, 36.746372, -122.051235, 160.5, 630.66 1544558013, 0, 0, 36.745315, -122.048848, 155.6, 630.64 1544558513, 0, 0, 36.746072, -122.051175, -137.2, 629.99 1544559013, 0, 0, 36.745610, -122.051125, -87.8, 634.19 1544559513, 0, 0, 36.745618, -122.051147, -90.2, 634.23 1544560013, 0, 0, 36.745678, -122.051150, -99.8, 634.23 1544560513, 0, 0, 36.745627, -122.051108, -108.0, 634.33 1544561013, 0, 0, 36.745612, -122.051115, -117.5, 634.28 1544561513, 0, 0, 36.745588, -122.051163, -146.5, 634.98 1544562013, 0, 0, 36.745590, -122.051205, 124.6, 636.34 1544562514, 0, 0, 36.745573, -122.051213, 141.3, 636.26 1544563014, 0, 0, 36.745582, -122.051207, 150.3, 636.26 1544563514, 0, 0, 36.745585, -122.051112, 147.4, 635.77 1544564014, 0, 0, 36.745737, -122.051185, -35.3, 571.25 1544564514, 0, 0, 36.745838, -122.050885, -35.4, 384.63 1544565014, 0, 0, 36.746180, -122.050727, -42.5, 297.33 1544565514, 0, 0, 36.746538, -122.051127, -15.7, 294.34 1544566014, 0, 0, 36.747377, -122.050687, -7.6, 262.30 1544566514, 0, 0, 36.747947, -122.049733, -22.2, 278.35 1544567015, 0, 0, 36.747603, -122.049525, -60.5, 167.32 1544567515, 0, 0, 36.746835, -122.048203, -13.4, 125.88 1544568015, 0, 0, 36.745785, -122.047593, -22.1, 46.71 rovNav(): 345: 20119 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018345vnta.txt 20119 in tList 20119 in {self->{rovT}} 20119 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1544548935 & 1544552895 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 626.725016379866 rovGDCListRefs(): dStats->sample_range = 633.851835111282 rovGDCListRefs(): returning (1st elements): 1544548011 36.801265 -121.786028 39.7 2.58076091230584 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 345 (looping to 345) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018345vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018345vntaedited.txt esecs, east, north, lat, lon, head, pres 1544548511, 0, 0, 36.747321, -122.052750, 129.3, 200.76 1544549011, 0, 0, 36.747213, -122.052441, 112.3, 446.29 1544549511, 0, 0, 36.747332, -122.051698, 184.9, 641.43 1544550011, 0, 0, 36.747051, -122.051738, 292.6, 640.10 1544550511, 0, 0, 36.747041, -122.051733, 307.1, 639.72 1544551011, 0, 0, 36.746956, -122.051651, 170.4, 639.10 1544551511, 0, 0, 36.746767, -122.051483, 293.6, 633.15 1544552011, 0, 0, 36.746790, -122.051458, 293.8, 633.19 1544552511, 0, 0, 36.746759, -122.051469, 293.3, 633.19 1544553011, 0, 0, 36.746751, -122.051447, 292.9, 633.22 1544553512, 0, 0, 36.746743, -122.051449, 287.8, 633.30 1544554012, 0, 0, 36.746749, -122.051462, 287.9, 633.30 1544554512, 0, 0, 36.746367, -122.051188, 199.7, 630.55 1544555012, 0, 0, 36.746330, -122.051213, 135.2, 630.82 1544555512, 0, 0, 36.746341, -122.051231, 143.6, 630.87 1544556012, 0, 0, 36.746335, -122.051237, 165.2, 630.94 1544556512, 0, 0, 36.746329, -122.051233, 165.4, 630.93 1544557012, 0, 0, 36.746331, -122.051216, 181.4, 630.53 1544557513, 0, 0, 36.746345, -122.051241, 160.5, 630.66 1544558013, 0, 0, 36.746367, -122.051365, 155.6, 630.64 1544558513, 0, 0, 36.746105, -122.051157, 222.8, 629.99 1544559013, 0, 0, 36.745608, -122.051150, 272.2, 634.19 1544559513, 0, 0, 36.745620, -122.051156, 269.8, 634.23 1544560013, 0, 0, 36.745632, -122.051138, 260.2, 634.23 1544560513, 0, 0, 36.745608, -122.051150, 252.0, 634.33 1544561013, 0, 0, 36.745619, -122.051127, 242.5, 634.28 1544561513, 0, 0, 36.745586, -122.051175, 213.5, 634.98 1544562013, 0, 0, 36.745575, -122.051219, 124.6, 636.34 1544562514, 0, 0, 36.745581, -122.051196, 141.3, 636.26 1544563014, 0, 0, 36.745592, -122.051183, 150.3, 636.26 1544563514, 0, 0, 36.745582, -122.051184, 147.4, 635.77 1544564014, 0, 0, 36.745761, -122.051163, 324.7, 571.25 1544564514, 0, 0, 36.745830, -122.050955, 324.6, 384.63 1544565014, 0, 0, 36.746187, -122.050737, 317.5, 297.33 1544565514, 0, 0, 36.746663, -122.050922, 344.3, 294.34 1544566014, 0, 0, 36.747432, -122.050584, 352.4, 262.30 1544566514, 0, 0, 36.748000, -122.049863, 337.8, 278.35 1544567015, 0, 0, 36.747652, -122.049411, 299.5, 167.32 1544567515, 0, 0, 36.746837, -122.048201, 346.6, 125.88 1544568015, 0, 0, 36.745674, -122.047577, 337.9, 46.71 rovNav(): 345: 20119 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018345vntaedited.txt 20119 in tList 20119 in {self->{rovT}} 20119 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1544560380 & 1544556045 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/345/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/345/accesses.txt at bin\geopdvc_perseus.pl line 629. .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 626.72501704503 rovGDCListRefs(): dStats->sample_range = 633.851826948517 rovGDCListRefs(): returning (1st elements): 1544548011 36.747143 -122.052423 39.7 2.5807732702956 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74634100 hash{lon} = -122.05121000 latMin = 30.746341 latMax = 42.746341 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.746341 AND 42.746341 AND Longitude BETWEEN -128.05121 AND -116.05121 Dive lat = 36.74634100, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05121000 & lat = 36.74634100 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 = vnta4167rov_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 = geo2018/vnta/vnta4167lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2275 shipNav(): $#{$self->{shipLat}}[last] = 36.751782 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 = 20120 makeTracks(): Looping through 2275 point of ship position data... makeTracks(): posSubsample = 16 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4167tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4167mergedCtdNav.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 '12/11/2018 5:06:51 PM' AND '12/11/2018 10:42:14 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/11/2018 5:06:51 PM' AND '12/11/2018 10:42:14 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/2018/vnta4167... 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 '12/11/2018 5:06:51 PM' AND '12/11/2018 10:42:14 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2018/vnta/vnta4167.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6479,'/3Dreplay/3D.asp?dives=vnta4167','vnta4167','','','',4167 Executing sql: UPDATE Dive SET DiveLatMid = 36.7463, DiveLonMid = -122.0512, DiveDepthMid = -626.7 WHERE RovName = 'vnta' AND DiveNumber = 4167