Running bin\geopdvc.pl at Thu Jun 7 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4113 bin\geopdvc.pl: Getting Expedition object for diveno = 4113 and rname = vnta set_expd(): rov = vnta, diveno = 4113 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 = 4113 AND RovName = 'vnta' RS->Fields(0)->Value= 6243 RS->Fields(1)->Value= 1523289645 RS->Fields(2)->Value= 1523309712 RS->Fields(3)->Value= 4/9/2018 4:00:45 PM RS->Fields(4)->Value= 4/9/2018 9:35:12 PM set_expd(): $self->{EndDDD} = 099 set_expd(): $self->{StartEsecs} = 1523288445 set_expd(): $self->{EndEsecs} = 1523310912 set_expd(): $self->{EndDtg} = 4/9/2018 9:35:12 PM _readLogr(): Reading videologr data from 2018099datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1523288445 & 1523310912 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1523310915, self->{EndEsecs} = 1523310912 _readLogr(): #LOGHOST_SYSTEM_UTC = 2245 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1523288454 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1523310905 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1523288454 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1523310905 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1523288325, Refined EndEsecs = 1523311032 _readLogr(): Reading videologr data from 2018099datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1523288325 & 1523311032 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1523311035, self->{EndEsecs} = 1523311032 _readLogr(): #LOGHOST_SYSTEM_UTC = 2269 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1523288334 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1523311025 bin\geopdvc.pl: expdid = 6243 bin\geopdvc.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 = 099 (looping to 099) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018099vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018099vnta.txt esecs, east, north, lat, lon, head, pres 1523290737, 0, 0, 36.772247, -122.088992, -15.8, 114.22 1523291237, 0, 0, 36.772008, -122.088915, -29.2, 192.20 1523291737, 0, 0, 36.771902, -122.087837, 87.2, 391.73 1523292237, 0, 0, 36.771858, -122.086933, 85.0, 480.37 1523292738, 0, 0, 36.771875, -122.086727, 75.0, 542.24 1523293238, 0, 0, 36.771828, -122.086535, 68.9, 563.07 1523293738, 0, 0, 36.771572, -122.086475, 101.4, 618.04 1523294238, 0, 0, 36.771728, -122.085807, 87.8, 714.37 1523294738, 0, 0, 36.771543, -122.086072, 71.4, 730.96 1523295238, 0, 0, 36.771565, -122.085192, 78.5, 815.88 1523295738, 0, 0, 36.771543, -122.084177, 70.3, 899.10 1523296238, 0, 0, 36.771762, -122.083730, 76.8, 983.70 1523296739, 0, 0, 36.771985, -122.083325, 142.3, 1038.21 1523297239, 0, 0, 36.771758, -122.082640, -178.0, 1023.89 1523297739, 0, 0, 36.771733, -122.082577, -120.9, 1023.42 1523298239, 0, 0, 36.771637, -122.082988, 133.1, 1030.11 1523298739, 0, 0, 36.771530, -122.082738, 36.8, 1028.62 1523299239, 0, 0, 36.771568, -122.082633, 173.5, 1018.51 1523299739, 0, 0, 36.771568, -122.082583, 96.7, 1015.07 1523300239, 0, 0, 36.771505, -122.082487, 141.0, 1009.76 1523300739, 0, 0, 36.771472, -122.082388, 121.6, 1000.34 1523301240, 0, 0, 36.771588, -122.082202, 160.7, 998.89 1523301740, 0, 0, 36.771322, -122.082155, 108.9, 983.21 1523302240, 0, 0, 36.771137, -122.082133, 125.8, 977.35 1523302740, 0, 0, 36.771110, -122.082198, 140.4, 974.86 1523303240, 0, 0, 36.771112, -122.082200, 119.8, 973.69 1523303740, 0, 0, 36.771130, -122.082102, 138.0, 968.58 1523304240, 0, 0, 36.771080, -122.082073, 127.7, 962.32 1523304740, 0, 0, 36.771068, -122.082025, 113.2, 956.42 1523305240, 0, 0, 36.771097, -122.081940, 99.8, 936.13 1523305741, 0, 0, 36.771338, -122.081433, 62.1, 928.01 1523306241, 0, 0, 36.771398, -122.081247, 76.1, 916.18 1523306741, 0, 0, 36.771418, -122.081243, 117.1, 916.00 1523307241, 0, 0, 36.771467, -122.082540, -102.6, 853.71 1523307741, 0, 0, 36.771302, -122.082903, -107.5, 673.78 1523308241, 0, 0, 36.771270, -122.083063, -16.7, 473.39 1523308741, 0, 0, 36.771112, -122.083242, -45.1, 295.87 1523309241, 0, 0, 36.770330, -122.083105, -76.7, 155.92 rovNav(): 099: 19471 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018099vnta.txt 19471 in tList 19471 in {self->{rovT}} 19471 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1523302635 & 1523308200 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 918.185209979205 rovGDCListRefs(): dStats->sample_range = 1027.34773735777 rovGDCListRefs(): returning (1st elements): 1523289647 36.719102 -122.050753 44.5 2.77929982602996 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 099 (looping to 099) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018099vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018099vntaedited.txt esecs, east, north, lat, lon, head, pres 1523290737, 0, 0, 36.772244, -122.088989, 344.2, 114.22 1523291237, 0, 0, 36.771996, -122.088889, 330.8, 192.20 1523291737, 0, 0, 36.771919, -122.087788, 87.2, 391.73 1523292237, 0, 0, 36.771840, -122.086777, 85.0, 480.37 1523292738, 0, 0, 36.771919, -122.086562, 75.0, 542.24 1523293238, 0, 0, 36.771823, -122.086538, 68.9, 563.07 1523293738, 0, 0, 36.771595, -122.086489, 101.4, 618.04 1523294238, 0, 0, 36.771727, -122.085834, 87.8, 714.37 1523294738, 0, 0, 36.771566, -122.086114, 71.4, 730.96 1523295238, 0, 0, 36.771561, -122.085189, 78.5, 815.88 1523295738, 0, 0, 36.771536, -122.084184, 70.3, 899.10 1523296238, 0, 0, 36.771663, -122.083868, 76.8, 983.70 1523296739, 0, 0, 36.771956, -122.083325, 142.3, 1038.21 1523297239, 0, 0, 36.771756, -122.082635, 182.0, 1023.89 1523297739, 0, 0, 36.771745, -122.082605, 239.1, 1023.42 1523298239, 0, 0, 36.771638, -122.082979, 133.1, 1030.11 1523298739, 0, 0, 36.771544, -122.082786, 36.8, 1028.62 1523299239, 0, 0, 36.771569, -122.082641, 173.5, 1018.51 1523299739, 0, 0, 36.771548, -122.082569, 96.7, 1015.07 1523300239, 0, 0, 36.771507, -122.082484, 141.0, 1009.76 1523300739, 0, 0, 36.771449, -122.082371, 121.6, 1000.34 1523301240, 0, 0, 36.771524, -122.082316, 160.7, 998.89 1523301740, 0, 0, 36.771327, -122.082162, 108.9, 983.21 1523302240, 0, 0, 36.771147, -122.082139, 125.8, 977.35 1523302740, 0, 0, 36.771112, -122.082185, 140.4, 974.86 1523303240, 0, 0, 36.771103, -122.082182, 119.8, 973.69 1523303740, 0, 0, 36.771127, -122.082110, 138.0, 968.58 1523304240, 0, 0, 36.771086, -122.082095, 127.7, 962.32 1523304740, 0, 0, 36.771060, -122.082032, 113.2, 956.42 1523305240, 0, 0, 36.771055, -122.081939, 99.8, 936.13 1523305741, 0, 0, 36.771304, -122.081466, 62.1, 928.01 1523306241, 0, 0, 36.771459, -122.081192, 76.1, 916.18 1523306741, 0, 0, 36.771417, -122.081222, 117.1, 916.00 1523307241, 0, 0, 36.771473, -122.082539, 257.4, 853.71 1523307741, 0, 0, 36.771288, -122.082912, 252.5, 673.78 1523308241, 0, 0, 36.771275, -122.083060, 343.3, 473.39 1523308741, 0, 0, 36.771110, -122.083243, 314.9, 295.87 1523309241, 0, 0, 36.770322, -122.083094, 283.3, 155.92 rovNav(): 099: 19471 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018099vntaedited.txt 19471 in tList 19471 in {self->{rovT}} 19471 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1523302635 & 1523308200 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 918.185219645149 rovGDCListRefs(): dStats->sample_range = 1027.34775095642 rovGDCListRefs(): returning (1st elements): 1523289647 36.772518 -122.088978 44.5 2.77928669487815 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.77152500 hash{lon} = -122.08280300 latMin = 30.771525 latMax = 42.771525 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.771525 AND 42.771525 AND Longitude BETWEEN -128.082803 AND -116.082803 Dive lat = 36.77152500, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.08280300 & lat = 36.77152500 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4113rov_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, coloframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/099/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. r = 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/vnta4113lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2269 shipNav(): $#{$self->{shipLat}}[last] = 36.768117 Position subsampling set to 15 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = 0.1570 0.1570 0.0633 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0.0000 0.5493 0.4507 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 0.3580 0.0000 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0.1510 1.0000 0.0000 makeTracks(): n = 19472 makeTracks(): Looping through 2269 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4113tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4113mergedCtdNav.txt... bin\geopdvc.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 '4/9/2018 4:00:45 PM' AND '4/9/2018 9:35:12 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '4/9/2018 4:00:45 PM' AND '4/9/2018 9:35:12 PM') Empty Return Set: RS from: Server=equinox,1433;Database=VARS;UID=everyone;PWD=guest; for: 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 '4/9/2018 4:00:45 PM' AND '4/9/2018 9:35:12 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '4/9/2018 4:00:45 PM' AND '4/9/2018 9:35:12 PM')