Running bin\geopdvc.pl at Sat May 5 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4105 bin\geopdvc.pl: Getting Expedition object for diveno = 4105 and rname = vnta set_expd(): rov = vnta, diveno = 4105 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 = 4105 AND RovName = 'vnta' RS->Fields(0)->Value= 6220 RS->Fields(1)->Value= 1520442373 RS->Fields(2)->Value= 1520462607 RS->Fields(3)->Value= 3/7/2018 5:06:13 PM RS->Fields(4)->Value= 3/7/2018 10:43:27 PM set_expd(): $self->{EndDDD} = 066 set_expd(): $self->{StartEsecs} = 1520441173 set_expd(): $self->{EndEsecs} = 1520463807 set_expd(): $self->{EndDtg} = 3/7/2018 10:43:27 PM _readLogr(): Reading videologr data from 2018066datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1520441173 & 1520463807 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1520463815, self->{EndEsecs} = 1520463807 _readLogr(): #LOGHOST_SYSTEM_UTC = 2262 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1520441181 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1520463805 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1520441181 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1520463805 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1520441053, Refined EndEsecs = 1520463927 _readLogr(): Reading videologr data from 2018066datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1520441053 & 1520463927 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1520463935, self->{EndEsecs} = 1520463927 _readLogr(): #LOGHOST_SYSTEM_UTC = 2286 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1520441061 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1520463925 bin\geopdvc.pl: expdid = 6220 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 = 066 (looping to 066) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018066vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018066vnta.txt esecs, east, north, lat, lon, head, pres 1520442874, 0, 0, 36.701198, -122.049482, 157.9, 130.55 1520443375, 0, 0, 36.700570, -122.049318, 157.2, 292.96 1520443875, 0, 0, 36.700117, -122.049040, 152.3, 412.77 1520444376, 0, 0, 36.699790, -122.048685, 134.2, 540.85 1520444877, 0, 0, 36.699707, -122.048220, 136.4, 675.66 1520445378, 0, 0, 36.700005, -122.047862, 125.5, 726.42 1520445879, 0, 0, 36.700285, -122.047693, -170.7, 746.83 1520446380, 0, 0, 36.700463, -122.047975, -32.8, 787.44 1520446880, 0, 0, 36.700723, -122.048135, -176.2, 807.07 1520447381, 0, 0, 36.700588, -122.048237, -171.8, 861.00 1520447882, 0, 0, 36.700202, -122.048372, 176.2, 917.27 1520448383, 0, 0, 36.699768, -122.048285, -171.9, 982.68 1520448884, 0, 0, 36.699733, -122.048065, 174.5, 993.70 1520449384, 0, 0, 36.699293, -122.047888, -163.2, 995.17 1520449885, 0, 0, 36.698932, -122.047683, 168.5, 1002.15 1520450386, 0, 0, 36.698648, -122.048263, -100.9, 993.33 1520450887, 0, 0, 36.698418, -122.049110, -137.1, 930.39 1520451388, 0, 0, 36.697007, -122.050007, 177.2, 847.22 1520451888, 0, 0, 36.696517, -122.050063, -8.7, 778.76 1520452389, 0, 0, 36.697920, -122.049957, -24.3, 721.36 1520452890, 0, 0, 36.698908, -122.049735, -14.3, 690.72 1520453391, 0, 0, 36.699638, -122.049655, -64.7, 650.65 1520453892, 0, 0, 36.699960, -122.050287, -76.7, 620.97 1520454393, 0, 0, 36.700162, -122.050543, -40.8, 603.42 1520454893, 0, 0, 36.700272, -122.050903, -96.3, 566.67 1520455394, 0, 0, 36.700582, -122.051620, 4.9, 545.35 1520455895, 0, 0, 36.701920, -122.050435, 44.4, 553.08 1520456396, 0, 0, 36.703233, -122.049018, 31.8, 541.03 1520456897, 0, 0, 36.703830, -122.048502, 20.3, 525.06 1520457398, 0, 0, 36.704030, -122.047523, 46.7, 499.02 1520457898, 0, 0, 36.704030, -122.047308, 12.9, 474.66 1520458399, 0, 0, 36.704227, -122.047060, 40.2, 465.53 1520458900, 0, 0, 36.704250, -122.046828, 24.9, 456.11 1520459401, 0, 0, 36.704540, -122.046420, 47.8, 439.09 1520459902, 0, 0, 36.704640, -122.047807, -102.3, 381.42 1520460402, 0, 0, 36.704577, -122.049203, -68.5, 332.93 1520460903, 0, 0, 36.704735, -122.050987, -81.2, 317.99 1520461404, 0, 0, 36.704508, -122.052038, -116.7, 302.62 1520461905, 0, 0, 36.704228, -122.052228, -109.9, 216.09 1520462406, 0, 0, 36.704665, -122.051313, -111.0, 75.06 rovNav(): 066: 20201 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018066vnta.txt 20201 in tList 20201 in {self->{rovT}} 20201 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1520452845 & 1520453640 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 583.275482325834 rovGDCListRefs(): dStats->sample_range = 1005.78257357567 rovGDCListRefs(): returning (1st elements): 1520442374 36.748593 -122.106497 147.0 2.58077293929842 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 066 (looping to 066) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018066vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018066vntaedited.txt esecs, east, north, lat, lon, head, pres 1520442874, 0, 0, 36.701193, -122.049480, 157.9, 130.55 1520443375, 0, 0, 36.700564, -122.049309, 157.2, 292.96 1520443875, 0, 0, 36.700116, -122.049037, 152.3, 412.77 1520444376, 0, 0, 36.699798, -122.048666, 134.2, 540.85 1520444877, 0, 0, 36.699690, -122.048221, 136.4, 675.66 1520445378, 0, 0, 36.700005, -122.047847, 125.5, 726.42 1520445879, 0, 0, 36.700277, -122.047692, 189.3, 746.83 1520446380, 0, 0, 36.700469, -122.047981, 327.2, 787.44 1520446880, 0, 0, 36.700724, -122.048138, 183.8, 807.07 1520447381, 0, 0, 36.700584, -122.048243, 188.2, 861.00 1520447882, 0, 0, 36.700189, -122.048373, 176.2, 917.27 1520448383, 0, 0, 36.699783, -122.048289, 188.1, 982.68 1520448884, 0, 0, 36.699727, -122.048061, 174.5, 993.70 1520449384, 0, 0, 36.699310, -122.047877, 196.8, 995.17 1520449885, 0, 0, 36.698923, -122.047681, 168.5, 1002.15 1520450386, 0, 0, 36.698645, -122.048262, 259.1, 993.33 1520450887, 0, 0, 36.698415, -122.049114, 222.9, 930.39 1520451388, 0, 0, 36.697001, -122.050020, 177.2, 847.22 1520451888, 0, 0, 36.696481, -122.050056, 351.3, 778.76 1520452389, 0, 0, 36.697936, -122.049948, 335.7, 721.36 1520452890, 0, 0, 36.698914, -122.049739, 345.7, 690.72 1520453391, 0, 0, 36.699644, -122.049668, 295.3, 650.65 1520453892, 0, 0, 36.699956, -122.050274, 283.3, 620.97 1520454393, 0, 0, 36.700146, -122.050539, 319.2, 603.42 1520454893, 0, 0, 36.700283, -122.050897, 263.7, 566.67 1520455394, 0, 0, 36.700577, -122.051622, 4.9, 545.35 1520455895, 0, 0, 36.701926, -122.050430, 44.4, 553.08 1520456396, 0, 0, 36.703236, -122.049026, 31.8, 541.03 1520456897, 0, 0, 36.703843, -122.048494, 20.3, 525.06 1520457398, 0, 0, 36.704019, -122.047512, 46.7, 499.02 1520457898, 0, 0, 36.704055, -122.047303, 12.9, 474.66 1520458399, 0, 0, 36.704219, -122.047054, 40.2, 465.53 1520458900, 0, 0, 36.704242, -122.046822, 24.9, 456.11 1520459401, 0, 0, 36.704541, -122.046422, 47.8, 439.09 1520459902, 0, 0, 36.704638, -122.047803, 257.7, 381.42 1520460402, 0, 0, 36.704576, -122.049206, 291.5, 332.93 1520460903, 0, 0, 36.704732, -122.050994, 278.8, 317.99 1520461404, 0, 0, 36.704522, -122.052041, 243.3, 302.62 1520461905, 0, 0, 36.704242, -122.052222, 250.1, 216.09 1520462406, 0, 0, 36.704668, -122.051313, 249.0, 75.06 rovNav(): 066: 20201 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018066vntaedited.txt 20201 in tList 20201 in {self->{rovT}} 20201 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1520452845 & 1520453640 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/066/accesses.txt at bin\geopdvc.pl line 2382 ..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 583.275482635205 rovGDCListRefs(): dStats->sample_range = 1005.78256130153 rovGDCListRefs(): returning (1st elements): 1520442374 36.701060 -122.049396 147.0 2.58078378725866 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70038900 hash{lon} = -122.04880300 latMin = 30.700389 latMax = 42.700389 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.700389 AND 42.700389 AND Longitude BETWEEN -128.048803 AND -116.048803 Dive lat = 36.70038900, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04880300 & lat = 36.70038900 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 = vnta4105rov_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/vnta4105lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2286 shipNav(): $#{$self->{shipLat}}[last] = 36.722556 Position subsampling set to 16 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 20202 makeTracks(): Looping through 2286 point of ship position data... makeTracks(): posSubsample = 16 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4105tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4105mergedCtdNav.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 '3/7/2018 5:06:13 PM' AND '3/7/2018 10:43:27 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '3/7/2018 5:06:13 PM' AND '3/7/2018 10:43:27 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(CCan't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. ONVERT(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 '3/7/2018 5:06:13 PM' AND '3/7/2018 10:43:27 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '3/7/2018 5:06:13 PM' AND '3/7/2018 10:43:27 PM')