Running bin\geopdvc.pl at Sat Apr 21 03:00:01 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4099 bin\geopdvc.pl: Getting Expedition object for diveno = 4099 and rname = vnta set_expd(): rov = vnta, diveno = 4099 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 = 4099 AND RovName = 'vnta' RS->Fields(0)->Value= 6210 RS->Fields(1)->Value= 1519229461 RS->Fields(2)->Value= 1519255130 RS->Fields(3)->Value= 2/21/2018 4:11:01 PM RS->Fields(4)->Value= 2/21/2018 11:18:50 PM set_expd(): $self->{EndDDD} = 052 set_expd(): $self->{StartEsecs} = 1519228261 set_expd(): $self->{EndEsecs} = 1519256330 set_expd(): $self->{EndDtg} = 2/21/2018 11:18:50 PM _readLogr(): Reading videologr data from 2018052datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1519228261 & 1519256330 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1519256337, self->{EndEsecs} = 1519256330 _readLogr(): #LOGHOST_SYSTEM_UTC = 2806 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1519228262 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1519256327 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1519228262 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1519256327 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1519228141, Refined EndEsecs = 1519256450 _readLogr(): Reading videologr data from 2018052datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1519228141 & 1519256450 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1519256457, self->{EndEsecs} = 1519256450 _readLogr(): #LOGHOST_SYSTEM_UTC = 2830 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1519228142 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1519256447 bin\geopdvc.pl: expdid = 6210 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 = 052 (looping to 052) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018052vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018052vnta.txt esecs, east, north, lat, lon, head, pres 1519229963, 0, 0, 36.788837, -121.875752, 155.8, 163.65 1519230463, 0, 0, 36.788965, -121.876407, -93.8, 160.11 1519230964, 0, 0, 36.789065, -121.877243, -93.4, 159.46 1519231465, 0, 0, 36.789095, -121.878337, -95.0, 161.23 1519231966, 0, 0, 36.789033, -121.879598, -94.7, 156.98 1519232467, 0, 0, 36.789155, -121.880868, -99.1, 171.24 1519232967, 0, 0, 36.789292, -121.881858, -94.5, 171.31 1519233468, 0, 0, 36.789475, -121.881707, 99.8, 171.20 1519233969, 0, 0, 36.789663, -121.881512, 114.4, 171.20 1519234470, 0, 0, 36.789632, -121.881435, 119.3, 171.24 1519234971, 0, 0, 36.789625, -121.881018, 114.1, 171.24 1519235471, 0, 0, 36.789563, -121.880513, 117.4, 171.07 1519235972, 0, 0, 36.789455, -121.879650, 109.0, 161.14 1519236473, 0, 0, 36.789383, -121.878812, 104.4, 161.93 1519236974, 0, 0, 36.789392, -121.878520, 116.1, 161.95 1519237475, 0, 0, 36.789338, -121.878277, 117.1, 171.22 1519237976, 0, 0, 36.789343, -121.878043, 108.1, 171.28 1519238477, 0, 0, 36.789287, -121.877635, 106.8, 171.16 1519238978, 0, 0, 36.789297, -121.877162, 107.3, 171.16 1519239478, 0, 0, 36.789482, -121.876693, 91.8, 161.70 1519239979, 0, 0, 36.789640, -121.876262, 109.4, 161.67 1519240480, 0, 0, 36.789712, -121.876042, 86.1, 166.17 1519240981, 0, 0, 36.789810, -121.875950, 86.0, 166.23 1519241482, 0, 0, 36.789857, -121.875840, 80.0, 166.09 1519241982, 0, 0, 36.789892, -121.875690, 96.9, 166.07 1519242483, 0, 0, 36.789783, -121.875013, 96.7, 166.18 1519242984, 0, 0, 36.789640, -121.874318, 97.2, 166.24 1519243485, 0, 0, 36.789537, -121.873585, 98.7, 166.20 1519243986, 0, 0, 36.789185, -121.873640, -138.9, 166.16 1519244487, 0, 0, 36.788885, -121.873707, -143.9, 165.97 1519244988, 0, 0, 36.788392, -121.873852, -120.3, 175.93 1519245488, 0, 0, 36.788003, -121.874093, -113.2, 178.35 1519245989, 0, 0, 36.787685, -121.874280, -123.3, 178.31 1519246490, 0, 0, 36.787428, -121.874512, -98.5, 178.37 1519246991, 0, 0, 36.787437, -121.875022, -99.7, 198.67 1519247492, 0, 0, 36.787293, -121.874642, -122.7, 218.78 1519247993, 0, 0, 36.787277, -121.873963, -113.6, 218.72 1519248494, 0, 0, 36.787137, -121.873258, -103.5, 218.79 1519248995, 0, 0, 36.786922, -121.872723, -101.6, 231.19 1519249495, 0, 0, 36.786608, -121.872320, -91.0, 220.11 1519249996, 0, 0, 36.786357, -121.872412, -97.0, 212.16 1519250497, 0, 0, 36.786397, -121.872103, -98.3, 208.59 1519250998, 0, 0, 36.786447, -121.872182, -106.7, 208.58 1519251499, 0, 0, 36.786512, -121.872830, -133.5, 215.12 1519252000, 0, 0, 36.786767, -121.872792, 158.2, 226.05 1519252501, 0, 0, 36.786522, -121.872278, -39.7, 222.23 1519253001, 0, 0, 36.786527, -121.872838, -48.9, 216.25 1519253502, 0, 0, 36.786862, -121.873397, 125.9, 226.04 1519254003, 0, 0, 36.787003, -121.873317, 116.6, 232.79 1519254504, 0, 0, 36.787220, -121.873027, -56.1, 148.13 1519255005, 0, 0, 36.787272, -121.873010, -55.8, 9.74 rovNav(): 052: 25624 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018052vnta.txt 25624 in tList 25624 in {self->{rovT}} 25624 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1519234410 & 1519237305 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 169.863516566788 rovGDCListRefs(): dStats->sample_range = 228.704416218719 rovGDCListRefs(): returning (1st elements): 1519229463 36.788613 -121.876280 -104.0 2.58076380182572 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 052 (looping to 052) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018052vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018052vntaedited.txt esecs, east, north, lat, lon, head, pres 1519229963, 0, 0, 36.788834, -121.875750, 155.8, 163.65 1519230463, 0, 0, 36.788966, -121.876403, 266.2, 160.11 1519230964, 0, 0, 36.789064, -121.877243, 266.6, 159.46 1519231465, 0, 0, 36.789093, -121.878344, 265.0, 161.23 1519231966, 0, 0, 36.789035, -121.879602, 265.3, 156.98 1519232467, 0, 0, 36.789160, -121.880876, 260.9, 171.24 1519232967, 0, 0, 36.789290, -121.881856, 265.5, 171.31 1519233468, 0, 0, 36.789476, -121.881709, 99.8, 171.20 1519233969, 0, 0, 36.789664, -121.881509, 114.4, 171.20 1519234470, 0, 0, 36.789630, -121.881440, 119.3, 171.24 1519234971, 0, 0, 36.789621, -121.881018, 114.1, 171.24 1519235471, 0, 0, 36.789562, -121.880508, 117.4, 171.07 1519235972, 0, 0, 36.789454, -121.879649, 109.0, 161.14 1519236473, 0, 0, 36.789381, -121.878809, 104.4, 161.93 1519236974, 0, 0, 36.789391, -121.878518, 116.1, 161.95 1519237475, 0, 0, 36.789338, -121.878278, 117.1, 171.22 1519237976, 0, 0, 36.789342, -121.878042, 108.1, 171.28 1519238477, 0, 0, 36.789283, -121.877635, 106.8, 171.16 1519238978, 0, 0, 36.789298, -121.877159, 107.3, 171.16 1519239478, 0, 0, 36.789482, -121.876693, 91.8, 161.70 1519239979, 0, 0, 36.789639, -121.876260, 109.4, 161.67 1519240480, 0, 0, 36.789712, -121.876045, 86.1, 166.17 1519240981, 0, 0, 36.789810, -121.875949, 86.0, 166.23 1519241482, 0, 0, 36.789856, -121.875835, 80.0, 166.09 1519241982, 0, 0, 36.789892, -121.875684, 96.9, 166.07 1519242483, 0, 0, 36.789782, -121.875009, 96.7, 166.18 1519242984, 0, 0, 36.789640, -121.874315, 97.2, 166.24 1519243485, 0, 0, 36.789537, -121.873576, 98.7, 166.20 1519243986, 0, 0, 36.789182, -121.873636, 221.1, 166.16 1519244487, 0, 0, 36.788883, -121.873711, 216.1, 165.97 1519244988, 0, 0, 36.788390, -121.873850, 239.7, 175.93 1519245488, 0, 0, 36.788003, -121.874092, 246.8, 178.35 1519245989, 0, 0, 36.787681, -121.874282, 236.7, 178.31 1519246490, 0, 0, 36.787428, -121.874512, 261.5, 178.37 1519246991, 0, 0, 36.787434, -121.875021, 260.3, 198.67 1519247492, 0, 0, 36.787295, -121.874644, 237.3, 218.78 1519247993, 0, 0, 36.787274, -121.873961, 246.4, 218.72 1519248494, 0, 0, 36.787137, -121.873254, 256.5, 218.79 1519248995, 0, 0, 36.786924, -121.872722, 258.4, 231.19 1519249495, 0, 0, 36.786610, -121.872325, 269.0, 220.11 1519249996, 0, 0, 36.786359, -121.872399, 263.0, 212.16 1519250497, 0, 0, 36.786398, -121.872104, 261.7, 208.59 1519250998, 0, 0, 36.786449, -121.872181, 253.3, 208.58 1519251499, 0, 0, 36.786513, -121.872828, 226.5, 215.12 1519252000, 0, 0, 36.786767, -121.872795, 158.2, 226.05 1519252501, 0, 0, 36.786517, -121.872274, 320.3, 222.23 1519253001, 0, 0, 36.786527, -121.872839, 311.1, 216.25 1519253502, 0, 0, 36.786865, -121.873394, 125.9, 226.04 1519254003, 0, 0, 36.787029, -121.873310, 116.6, 232.79 1519254504, 0, 0, 36.787202, -121.873028, 303.9, 148.13 1519255005, 0, 0, 36.787030, -121.872903, 304.2, 9.74 rovNav(): 052: 25624 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018052vntaedited.txt 25624 in tList 25624 in {self->{rovT}} 25624 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1519234410 & 1519237305 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/052/accesses.txt at bin\geopdvc.pl line 2382 ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 169.863516536726 rovGDCListRefs(): dStats->sample_range = 228.704416134925 rovGDCListRefs(): returning (1st elements): 1519229463 36.788963 -121.875928 256.0 2.58076372189621 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.78906400 hash{lon} = -121.87528700 latMin = 30.789064 latMax = 42.789064 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.789064 AND 42.789064 AND Longitude BETWEEN -127.875287 AND -115.875287 Dive lat = 36.78906400, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.87528700 & lat = 36.78906400 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 = vnta4099rov_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/vnta4099lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2830 shipNav(): $#{$self->{shipLat}}[last] = 36.789305 Position subsampling set to 20 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 = 25625 makeTracks(): Looping through 2830 point of ship position data... makeTracks(): posSubsample = 20 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4099tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4099mergedCtdNav.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/21/2018 4:11:01 PM' AND '2/21/2018 11:18:50 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/21/2018 4:11:01 PM' AND '2/21/2018 11:18:50 PM') Empty Return Set: RS from: Server=equinox,1433;Database=VARS;UID=everyone;PWD=guest; for:Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. 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/21/2018 4:11:01 PM' AND '2/21/2018 11:18:50 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/21/2018 4:11:01 PM' AND '2/21/2018 11:18:50 PM')