Running bin\geopdvc.pl at Fri Apr 6 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4094 bin\geopdvc.pl: Getting Expedition object for diveno = 4094 and rname = vnta set_expd(): rov = vnta, diveno = 4094 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 = 4094 AND RovName = 'vnta' RS->Fields(0)->Value= 6201 RS->Fields(1)->Value= 1517935949 RS->Fields(2)->Value= 1517956055 RS->Fields(3)->Value= 2/6/2018 4:52:29 PM RS->Fields(4)->Value= 2/6/2018 10:27:35 PM set_expd(): $self->{EndDDD} = 037 set_expd(): $self->{StartEsecs} = 1517934749 set_expd(): $self->{EndEsecs} = 1517957255 set_expd(): $self->{EndDtg} = 2/6/2018 10:27:35 PM _readLogr(): Reading videologr data from 2018037datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1517934749 & 1517957255 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1517957260, self->{EndEsecs} = 1517957255 _readLogr(): #LOGHOST_SYSTEM_UTC = 2249 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1517934756 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1517957250 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1517934756 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1517957250 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1517934629, Refined EndEsecs = 1517957375 _readLogr(): Reading videologr data from 2018037datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1517934629 & 1517957375 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1517957380, self->{EndEsecs} = 1517957375 _readLogr(): #LOGHOST_SYSTEM_UTC = 2273 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1517934636 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1517957370 bin\geopdvc.pl: expdid = 6201 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 = 037 (looping to 037) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018037vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018037vnta.txt esecs, east, north, lat, lon, head, pres 1517936460, 0, 0, 36.705630, -122.015623, -136.0, 133.34 1517936961, 0, 0, 36.705072, -122.016793, -117.8, 284.21 1517937462, 0, 0, 36.705067, -122.016707, -119.9, 496.80 1517937962, 0, 0, 36.705075, -122.017103, -95.1, 689.59 1517938463, 0, 0, 36.704902, -122.016785, -94.9, 898.06 1517938964, 0, 0, 36.705027, -122.016922, 1.5, 1069.98 1517939465, 0, 0, 36.704900, -122.017035, 14.6, 1243.41 1517939966, 0, 0, 36.705042, -122.017185, 12.2, 1357.48 1517940467, 0, 0, 36.705140, -122.017050, -115.1, 1475.05 1517940968, 0, 0, 36.705210, -122.017257, 120.5, 1516.21 1517941469, 0, 0, 36.705170, -122.017142, 126.8, 1516.34 1517941969, 0, 0, 36.705503, -122.017280, 142.9, 1514.83 1517942470, 0, 0, 36.705498, -122.017190, 133.0, 1516.82 1517942971, 0, 0, 36.705548, -122.017282, 1.4, 1516.63 1517943472, 0, 0, 36.705513, -122.017250, -179.9, 1516.83 1517943973, 0, 0, 36.705678, -122.017033, 89.1, 1515.72 1517944474, 0, 0, 36.705495, -122.017317, 134.9, 1516.81 1517944975, 0, 0, 36.705457, -122.017245, -14.8, 1516.73 1517945475, 0, 0, 36.705717, -122.017227, -178.1, 1516.03 1517945976, 0, 0, 36.705713, -122.017317, 83.5, 1516.20 1517946477, 0, 0, 36.705690, -122.017488, 125.0, 1516.33 1517946978, 0, 0, 36.705613, -122.017042, 136.3, 1494.27 1517947479, 0, 0, 36.704968, -122.014823, 145.5, 1427.34 1517947980, 0, 0, 36.705220, -122.014737, 110.6, 1445.76 1517948481, 0, 0, 36.705253, -122.014838, 125.1, 1455.59 1517948982, 0, 0, 36.705250, -122.014473, 121.6, 1444.10 1517949482, 0, 0, 36.705242, -122.014410, 142.2, 1437.43 1517949983, 0, 0, 36.705302, -122.014307, 141.4, 1430.35 1517950484, 0, 0, 36.705255, -122.014255, 138.5, 1417.71 1517950985, 0, 0, 36.705330, -122.014377, 136.9, 1441.37 1517951486, 0, 0, 36.705335, -122.014552, -98.5, 1432.99 1517951987, 0, 0, 36.706448, -122.016332, -91.1, 1341.90 1517952488, 0, 0, 36.706953, -122.015642, -84.5, 1134.46 1517952989, 0, 0, 36.707403, -122.015202, -62.6, 926.33 1517953490, 0, 0, 36.707848, -122.014905, -61.1, 711.69 1517953991, 0, 0, 36.707942, -122.014528, -40.1, 492.47 1517954491, 0, 0, 36.707818, -122.014352, -64.0, 263.56 1517954992, 0, 0, 36.707832, -122.014190, -40.9, 37.36 1517955493, 0, 0, 36.707653, -122.014010, -43.9, 9.94 1517955994, 0, 0, 36.707285, -122.013432, -44.3, 10.07 rovNav(): 037: 20060 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018037vnta.txt 20060 in tList 20060 in {self->{rovT}} 20060 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1517954715 & 1517939415 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 1415.85918514904 rovGDCListRefs(): dStats->sample_range = 1499.8467194584 rovGDCListRefs(): returning (1st elements): 1517935951 36.768428 -121.929397 170.8 2.68002808001852 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 037 (looping to 037) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018037vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018037vntaedited.txt esecs, east, north, lat, lon, head, pres 1517936460, 0, 0, 36.705633, -122.015609, 224.0, 133.34 1517936961, 0, 0, 36.705076, -122.016795, 242.2, 284.21 1517937462, 0, 0, 36.705062, -122.016630, 240.1, 496.80 1517937962, 0, 0, 36.705083, -122.017112, 264.9, 689.59 1517938463, 0, 0, 36.704882, -122.016814, 265.1, 898.06 1517938964, 0, 0, 36.705047, -122.016920, 1.5, 1069.98 1517939465, 0, 0, 36.704916, -122.017022, 14.6, 1243.41 1517939966, 0, 0, 36.705039, -122.017179, 12.2, 1357.48 1517940467, 0, 0, 36.705119, -122.017112, 244.9, 1475.05 1517940968, 0, 0, 36.705162, -122.017198, 120.5, 1516.21 1517941469, 0, 0, 36.705158, -122.017115, 126.8, 1516.34 1517941969, 0, 0, 36.705497, -122.017235, 142.9, 1514.83 1517942470, 0, 0, 36.705514, -122.017201, 133.0, 1516.82 1517942971, 0, 0, 36.705559, -122.017274, 1.4, 1516.63 1517943472, 0, 0, 36.705530, -122.017261, 180.1, 1516.83 1517943973, 0, 0, 36.705681, -122.017051, 89.1, 1515.72 1517944474, 0, 0, 36.705496, -122.017312, 134.9, 1516.81 1517944975, 0, 0, 36.705472, -122.017240, 345.2, 1516.73 1517945475, 0, 0, 36.705715, -122.017227, 181.9, 1516.03 1517945976, 0, 0, 36.705707, -122.017310, 83.5, 1516.20 1517946477, 0, 0, 36.705702, -122.017460, 125.0, 1516.33 1517946978, 0, 0, 36.705592, -122.017047, 136.3, 1494.27 1517947479, 0, 0, 36.704956, -122.014813, 145.5, 1427.34 1517947980, 0, 0, 36.705208, -122.014730, 110.6, 1445.76 1517948481, 0, 0, 36.705284, -122.014794, 125.1, 1455.59 1517948982, 0, 0, 36.705253, -122.014494, 121.6, 1444.10 1517949482, 0, 0, 36.705238, -122.014429, 142.2, 1437.43 1517949983, 0, 0, 36.705313, -122.014297, 141.4, 1430.35 1517950484, 0, 0, 36.705256, -122.014258, 138.5, 1417.71 1517950985, 0, 0, 36.705339, -122.014394, 136.9, 1441.37 1517951486, 0, 0, 36.705337, -122.014566, 261.5, 1432.99 1517951987, 0, 0, 36.706430, -122.016311, 268.9, 1341.90 1517952488, 0, 0, 36.706943, -122.015729, 275.5, 1134.46 1517952989, 0, 0, 36.707402, -122.015202, 297.4, 926.33 1517953490, 0, 0, 36.707845, -122.014902, 298.9, 711.69 1517953991, 0, 0, 36.707944, -122.014524, 319.9, 492.47 1517954491, 0, 0, 36.707814, -122.014355, 296.0, 263.56 1517954992, 0, 0, 36.707828, -122.014213, 319.1, 37.36 1517955493, 0, 0, 36.707657, -122.013993, 316.1, 9.94 1517955994, 0, 0, 36.707291, -122.013437, 315.7, 10.07 rovNav(): 037: 20060 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018037vntaedited.txt 20060 in tList 20060 in {self->{rovT}} 20060 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1517954715 & 1517939415 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/037/accesses.txt at bin\geopdvc.pl line 2382 ....................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 1415.85918589999 rovGDCListRefs(): dStats->sample_range = 1499.84670496226 rovGDCListRefs(): returning (1st elements): 1517935951 36.705204 -122.016436 170.8 2.68004306578367 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70546900 hash{lon} = -122.01660600 latMin = 30.705469 latMax = 42.705469 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.705469 AND 42.705469 AND Longitude BETWEEN -128.016606 AND -116.016606 Dive lat = 36.70546900, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.01660600 & lat = 36.70546900 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... makeROVorig(): Number of points greater than 20,000. Skipping every other point for .wrl file. inline_name = vnta4094rov_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/vnta4094lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2273 shipNav(): $#{$self->{shipLat}}[last] = 36.720399 Position subsampling set to 16 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = 0.2020 0.1816 0.0000 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0 0 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 1.0000 0.0108 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0.5860 0.4140 0.0000 makeTracks(): n = 20061 makeTracks(): Looping through 2273 point of ship position data... makeTracks(): posSubsample = 16 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4094tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4094mergedCtdNav.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 '2/6/2018 4:52:29 PM' AND '2/6/2018 10:27:35 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/6/2018 4:52:29 PM' AND '2/6/2018 10:27:35 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 ObsCan't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. erver, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '2/6/2018 4:52:29 PM' AND '2/6/2018 10:27:35 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/6/2018 4:52:29 PM' AND '2/6/2018 10:27:35 PM')