Running bin\geopdvc.pl at Tue Jul 17 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4121 bin\geopdvc.pl: Getting Expedition object for diveno = 4121 and rname = vnta set_expd(): rov = vnta, diveno = 4121 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 = 4121 AND RovName = 'vnta' RS->Fields(0)->Value= 6244 RS->Fields(1)->Value= 1526744760 RS->Fields(2)->Value= 1526769600 RS->Fields(3)->Value= 5/19/2018 3:46:00 PM RS->Fields(4)->Value= 5/19/2018 10:40:00 PM set_expd(): $self->{EndDDD} = 139 set_expd(): $self->{StartEsecs} = 1526743560 set_expd(): $self->{EndEsecs} = 1526770800 set_expd(): $self->{EndDtg} = 5/19/2018 10:40:00 PM _readLogr(): Reading videologr data from 2018139datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526743560 & 1526770800 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526770806, self->{EndEsecs} = 1526770800 _readLogr(): #LOGHOST_SYSTEM_UTC = 2723 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526743565 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526770796 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1526743565 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1526770796 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1526743440, Refined EndEsecs = 1526770920 _readLogr(): Reading videologr data from 2018139datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526743440 & 1526770920 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526770926, self->{EndEsecs} = 1526770920 _readLogr(): #LOGHOST_SYSTEM_UTC = 2747 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526743445 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526770916 bin\geopdvc.pl: expdid = 6244 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 = 139 (looping to 139) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018139vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018139vnta.txt esecs, east, north, lat, lon, head, pres 1526745254, 0, 0, 33.799885, -118.648573, 20.3, 205.06 1526745754, 0, 0, 33.799653, -118.647617, 84.7, 408.23 1526746254, 0, 0, 33.799790, -118.647555, 101.6, 628.63 1526746754, 0, 0, 33.799723, -118.647555, 111.4, 813.05 1526747254, 0, 0, 33.799548, -118.647373, 124.9, 810.66 1526747754, 0, 0, 33.799493, -118.647322, 125.3, 809.73 1526748255, 0, 0, 33.799392, -118.647328, 123.8, 808.36 1526748755, 0, 0, 33.799320, -118.647322, 122.6, 807.91 1526749255, 0, 0, 33.799202, -118.647188, 123.1, 806.69 1526749755, 0, 0, 33.799315, -118.647473, 122.7, 812.63 1526750255, 0, 0, 33.799267, -118.647497, 123.8, 813.04 1526750755, 0, 0, 33.799133, -118.647360, 123.6, 809.57 1526751255, 0, 0, 33.799087, -118.647340, 123.5, 809.04 1526751755, 0, 0, 33.799032, -118.647375, 123.7, 810.31 1526752255, 0, 0, 33.799050, -118.647502, 123.8, 813.21 1526752756, 0, 0, 33.798820, -118.647248, 122.9, 812.75 1526753256, 0, 0, 33.798725, -118.647273, -142.1, 814.04 1526753756, 0, 0, 33.798728, -118.646683, 95.5, 813.23 1526754256, 0, 0, 33.798927, -118.646577, -57.1, 808.92 1526754756, 0, 0, 33.798890, -118.646642, -59.8, 809.50 1526755256, 0, 0, 33.798885, -118.646692, -60.4, 808.83 1526755756, 0, 0, 33.798802, -118.646613, -61.9, 811.18 1526756256, 0, 0, 33.798908, -118.646883, -58.5, 807.08 1526756756, 0, 0, 33.798728, -118.646528, -60.4, 813.74 1526757256, 0, 0, 33.798955, -118.647087, -57.1, 805.42 1526757757, 0, 0, 33.798608, -118.646447, -57.0, 816.92 1526758257, 0, 0, 33.798742, -118.646980, -57.4, 809.56 1526758757, 0, 0, 33.798722, -118.646860, -56.5, 814.09 1526759257, 0, 0, 33.798658, -118.646810, -56.6, 814.29 1526759757, 0, 0, 33.798800, -118.647170, -56.4, 812.17 1526760257, 0, 0, 33.798575, -118.646885, -57.5, 814.48 1526760757, 0, 0, 33.798567, -118.646890, -56.3, 814.98 1526761257, 0, 0, 33.798650, -118.647168, -56.5, 813.53 1526761757, 0, 0, 33.798723, -118.647343, 61.3, 815.44 1526762257, 0, 0, 33.798763, -118.647102, 83.6, 813.95 1526762757, 0, 0, 33.798748, -118.647098, 163.9, 813.07 1526763258, 0, 0, 33.798748, -118.647120, -105.3, 814.09 1526763758, 0, 0, 33.798755, -118.647077, -16.8, 811.80 1526764258, 0, 0, 33.798750, -118.647097, 73.8, 813.90 1526764758, 0, 0, 33.798758, -118.647107, 179.7, 812.11 1526765258, 0, 0, 33.798850, -118.647108, 0.1, 810.58 1526765758, 0, 0, 33.799587, -118.646985, 121.6, 808.03 1526766258, 0, 0, 33.799585, -118.646843, 123.2, 804.87 1526766758, 0, 0, 33.799580, -118.646677, 124.5, 805.40 1526767258, 0, 0, 33.799578, -118.646545, 125.2, 808.12 1526767759, 0, 0, 33.800053, -118.648330, -94.6, 685.93 1526768259, 0, 0, 33.800237, -118.649793, -95.5, 488.17 1526768759, 0, 0, 33.800525, -118.650628, -107.7, 261.90 1526769259, 0, 0, 33.800565, -118.651128, -89.6, 107.48 rovNav(): 139: 24843 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018139vnta.txt 24843 in tList 24843 in {self->{rovT}} 24843 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526747100 & 1526757675 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 803.296993545987 rovGDCListRefs(): dStats->sample_range = 808.528454154834 rovGDCListRefs(): returning (1st elements): 1526744755 33.799532 -118.647828 9.9 2.58143471964973 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 139 (looping to 139) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018139vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018139vntaedited.txt esecs, east, north, lat, lon, head, pres 1526745254, 0, 0, 33.799877, -118.648583, 20.3, 205.06 1526745754, 0, 0, 33.799659, -118.647608, 84.7, 408.23 1526746254, 0, 0, 33.799786, -118.647533, 101.6, 628.63 1526746754, 0, 0, 33.799705, -118.647551, 111.4, 813.05 1526747254, 0, 0, 33.799550, -118.647362, 124.9, 810.66 1526747754, 0, 0, 33.799493, -118.647349, 125.3, 809.73 1526748255, 0, 0, 33.799414, -118.647341, 123.8, 808.36 1526748755, 0, 0, 33.799338, -118.647303, 122.6, 807.91 1526749255, 0, 0, 33.799225, -118.647189, 123.1, 806.69 1526749755, 0, 0, 33.799299, -118.647465, 122.7, 812.63 1526750255, 0, 0, 33.799271, -118.647511, 123.8, 813.04 1526750755, 0, 0, 33.799157, -118.647383, 123.6, 809.57 1526751255, 0, 0, 33.799097, -118.647348, 123.5, 809.04 1526751755, 0, 0, 33.799030, -118.647371, 123.7, 810.31 1526752255, 0, 0, 33.799038, -118.647491, 123.8, 813.21 1526752756, 0, 0, 33.798819, -118.647253, 122.9, 812.75 1526753256, 0, 0, 33.798720, -118.647269, 217.9, 814.04 1526753756, 0, 0, 33.798730, -118.646659, 95.5, 813.23 1526754256, 0, 0, 33.798916, -118.646628, 302.9, 808.92 1526754756, 0, 0, 33.798883, -118.646636, 300.2, 809.50 1526755256, 0, 0, 33.798881, -118.646696, 299.6, 808.83 1526755756, 0, 0, 33.798801, -118.646617, 298.1, 811.18 1526756256, 0, 0, 33.798905, -118.646883, 301.5, 807.08 1526756756, 0, 0, 33.798723, -118.646525, 299.6, 813.74 1526757256, 0, 0, 33.798955, -118.647102, 302.9, 805.42 1526757757, 0, 0, 33.798599, -118.646461, 303.0, 816.92 1526758257, 0, 0, 33.798805, -118.647037, 302.6, 809.56 1526758757, 0, 0, 33.798714, -118.646864, 303.5, 814.09 1526759257, 0, 0, 33.798659, -118.646800, 303.4, 814.29 1526759757, 0, 0, 33.798809, -118.647181, 303.6, 812.17 1526760257, 0, 0, 33.798603, -118.646869, 302.5, 814.48 1526760757, 0, 0, 33.798571, -118.646875, 303.7, 814.98 1526761257, 0, 0, 33.798654, -118.647155, 303.5, 813.53 1526761757, 0, 0, 33.798719, -118.647336, 61.3, 815.44 1526762257, 0, 0, 33.798760, -118.647085, 83.6, 813.95 1526762757, 0, 0, 33.798740, -118.647083, 163.9, 813.07 1526763258, 0, 0, 33.798733, -118.647102, 254.7, 814.09 1526763758, 0, 0, 33.798740, -118.647112, 343.2, 811.80 1526764258, 0, 0, 33.798753, -118.647091, 73.8, 813.90 1526764758, 0, 0, 33.798748, -118.647114, 179.7, 812.11 1526765258, 0, 0, 33.798847, -118.647115, 0.1, 810.58 1526765758, 0, 0, 33.799569, -118.646966, 121.6, 808.03 1526766258, 0, 0, 33.799575, -118.646833, 123.2, 804.87 1526766758, 0, 0, 33.799589, -118.646688, 124.5, 805.40 1526767258, 0, 0, 33.799580, -118.646547, 125.2, 808.12 1526767759, 0, 0, 33.800054, -118.648319, 265.4, 685.93 1526768259, 0, 0, 33.800248, -118.649802, 264.5, 488.17 1526768759, 0, 0, 33.800530, -118.650626, 252.3, 261.90 1526769259, 0, 0, 33.800535, -118.651199, 270.4, 107.48 rovNav(): 139: 24843 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018139vntaedited.txt 24843 in tList 24843 in {self->{rovT}} 24843 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526747100 & 1526757675 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 803.296993648731 rovGDCListRefs(): dStats->sample_range = 808.528455689511 rovGDCListRefs(): returning (1st elements): 1526744755 33.800220 -118.647992 9.9 2.58143456819601 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 33.79896000 hash{lon} = -118.64711500 latMin = 27.79896 latMax = 39.79896 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 27.79896 AND 39.79896 AND Longitude BETWEEN -124.647115 AND -112.647115 Dive lat = 33.79896000, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -118.64711500 & lat = 33.79896000 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 = vnta4121rov_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 vframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/139/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. ar = 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/vnta4121lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2747 shipNav(): $#{$self->{shipLat}}[last] = 33.790653 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 = 24844 makeTracks(): Looping through 2747 point of ship position data... makeTracks(): posSubsample = 20 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4121tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4121mergedCtdNav.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 '5/19/2018 3:46:00 PM' AND '5/19/2018 10:40:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/19/2018 3:46:00 PM' AND '5/19/2018 10:40:00 PM') Empty Return Set: RS from: Server=equinox,1433;Database=VARS;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '5/19/2018 3:46:00 PM' AND '5/19/2018 10:40:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/19/2018 3:46:00 PM' AND '5/19/2018 10:40:00 PM')