Running bin\geopdvc.pl at Mon Jul 16 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4120 bin\geopdvc.pl: Getting Expedition object for diveno = 4120 and rname = vnta set_expd(): rov = vnta, diveno = 4120 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 = 4120 AND RovName = 'vnta' RS->Fields(0)->Value= 6244 RS->Fields(1)->Value= 1526658360 RS->Fields(2)->Value= 1526681850 RS->Fields(3)->Value= 5/18/2018 3:46:00 PM RS->Fields(4)->Value= 5/18/2018 10:17:30 PM set_expd(): $self->{EndDDD} = 138 set_expd(): $self->{StartEsecs} = 1526657160 set_expd(): $self->{EndEsecs} = 1526683050 set_expd(): $self->{EndDtg} = 5/18/2018 10:17:30 PM _readLogr(): Reading videologr data from 2018138datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526657160 & 1526683050 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526683053, self->{EndEsecs} = 1526683050 _readLogr(): #LOGHOST_SYSTEM_UTC = 2588 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526657163 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526683043 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1526657163 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1526683043 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1526657040, Refined EndEsecs = 1526683170 _readLogr(): Reading videologr data from 2018138datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526657040 & 1526683170 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526683173, self->{EndEsecs} = 1526683170 _readLogr(): #LOGHOST_SYSTEM_UTC = 2612 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526657043 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526683163 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 = 138 (looping to 138) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018138vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018138vnta.txt esecs, east, north, lat, lon, head, pres 1526658863, 0, 0, 33.800248, -118.647442, 98.3, 215.18 1526659363, 0, 0, 33.799932, -118.646487, 90.4, 395.58 1526659863, 0, 0, 33.799852, -118.646425, 100.8, 578.15 1526660363, 0, 0, 33.799872, -118.646387, 89.4, 754.36 1526660864, 0, 0, 33.799857, -118.646337, -119.7, 817.77 1526661364, 0, 0, 33.799585, -118.645938, -43.9, 818.05 1526661864, 0, 0, 33.800025, -118.646390, -179.4, 818.87 1526662364, 0, 0, 33.799867, -118.646377, -179.8, 817.64 1526662864, 0, 0, 33.799667, -118.646462, -144.8, 811.22 1526663364, 0, 0, 33.799403, -118.646530, -148.7, 806.87 1526663864, 0, 0, 33.799507, -118.646445, -146.7, 809.43 1526664364, 0, 0, 33.799413, -118.646470, -147.5, 808.07 1526664864, 0, 0, 33.799710, -118.646492, -147.7, 815.26 1526665365, 0, 0, 33.799685, -118.646248, -148.0, 816.04 1526665865, 0, 0, 33.799538, -118.646295, -147.1, 812.98 1526666365, 0, 0, 33.799573, -118.646293, -146.9, 813.99 1526666865, 0, 0, 33.799707, -118.646205, -147.4, 818.30 1526667365, 0, 0, 33.799352, -118.646382, -147.4, 808.38 1526667865, 0, 0, 33.799378, -118.646435, -86.5, 808.07 1526668365, 0, 0, 33.799157, -118.645958, -57.4, 817.77 1526668865, 0, 0, 33.799325, -118.646267, -61.3, 810.58 1526669365, 0, 0, 33.799337, -118.646150, -58.4, 813.97 1526669866, 0, 0, 33.799288, -118.645925, -57.9, 817.98 1526670366, 0, 0, 33.799507, -118.646315, -58.5, 811.90 1526670866, 0, 0, 33.799318, -118.645878, -57.0, 819.35 1526671366, 0, 0, 33.799430, -118.646032, -57.4, 817.68 1526671866, 0, 0, 33.799560, -118.646187, -57.2, 815.63 1526672366, 0, 0, 33.799347, -118.645797, -59.4, 820.20 1526672866, 0, 0, 33.799642, -118.646278, -57.0, 815.63 1526673366, 0, 0, 33.799840, -118.646685, -58.5, 814.27 1526673866, 0, 0, 33.800078, -118.646958, 123.5, 817.31 1526674367, 0, 0, 33.800013, -118.646952, 126.1, 816.69 1526674867, 0, 0, 33.799968, -118.646988, 126.6, 816.02 1526675367, 0, 0, 33.799945, -118.647115, 126.2, 815.54 1526675867, 0, 0, 33.799950, -118.647207, 125.1, 814.89 1526676367, 0, 0, 33.799870, -118.647253, 123.7, 814.46 1526676867, 0, 0, 33.799803, -118.647217, 125.0, 813.21 1526677367, 0, 0, 33.799760, -118.647315, 123.2, 813.17 1526677867, 0, 0, 33.799740, -118.647347, 123.9, 813.21 1526678368, 0, 0, 33.799718, -118.647390, 123.3, 813.03 1526678868, 0, 0, 33.799667, -118.647383, 124.3, 813.12 1526679368, 0, 0, 33.799600, -118.647455, 122.9, 813.21 1526679868, 0, 0, 33.800085, -118.649315, -81.6, 702.53 1526680368, 0, 0, 33.800680, -118.650965, -76.8, 534.65 1526680868, 0, 0, 33.800990, -118.651558, -80.5, 342.57 1526681368, 0, 0, 33.800647, -118.652515, -97.1, 164.03 rovNav(): 138: 23485 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018138vnta.txt 23485 in tList 23485 in {self->{rovT}} 23485 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526681775 & 1526670480 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 805.660634083274 rovGDCListRefs(): dStats->sample_range = 811.307334675734 rovGDCListRefs(): returning (1st elements): 1526658364 33.800688 -118.652892 16.3 2.5814344651714 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 138 (looping to 138) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018138vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018138vntaedited.txt esecs, east, north, lat, lon, head, pres 1526658863, 0, 0, 33.800246, -118.647430, 98.3, 215.18 1526659363, 0, 0, 33.799932, -118.646483, 90.4, 395.58 1526659863, 0, 0, 33.799848, -118.646457, 100.8, 578.15 1526660363, 0, 0, 33.799867, -118.646402, 89.4, 754.36 1526660864, 0, 0, 33.799895, -118.646340, 240.3, 817.77 1526661364, 0, 0, 33.799872, -118.646406, 316.1, 818.05 1526661864, 0, 0, 33.799970, -118.646372, 180.6, 818.87 1526662364, 0, 0, 33.799884, -118.646373, 180.2, 817.64 1526662864, 0, 0, 33.799669, -118.646476, 215.2, 811.22 1526663364, 0, 0, 33.799423, -118.646528, 211.3, 806.87 1526663864, 0, 0, 33.799499, -118.646447, 213.3, 809.43 1526664364, 0, 0, 33.799415, -118.646465, 212.5, 808.07 1526664864, 0, 0, 33.799676, -118.646348, 212.3, 815.26 1526665365, 0, 0, 33.799675, -118.646253, 212.0, 816.04 1526665865, 0, 0, 33.799532, -118.646300, 212.9, 812.98 1526666365, 0, 0, 33.799571, -118.646284, 213.1, 813.99 1526666865, 0, 0, 33.799717, -118.646190, 212.6, 818.30 1526667365, 0, 0, 33.799356, -118.646390, 212.6, 808.38 1526667865, 0, 0, 33.799370, -118.646448, 273.5, 808.07 1526668365, 0, 0, 33.799159, -118.645966, 302.6, 817.77 1526668865, 0, 0, 33.799355, -118.646273, 298.7, 810.58 1526669365, 0, 0, 33.799337, -118.646161, 301.6, 813.97 1526669866, 0, 0, 33.799269, -118.645943, 302.1, 817.98 1526670366, 0, 0, 33.799514, -118.646327, 301.5, 811.90 1526670866, 0, 0, 33.799329, -118.645859, 303.0, 819.35 1526671366, 0, 0, 33.799434, -118.646024, 302.6, 817.68 1526671866, 0, 0, 33.799554, -118.646196, 302.8, 815.63 1526672366, 0, 0, 33.799366, -118.645790, 300.6, 820.20 1526672866, 0, 0, 33.799635, -118.646276, 303.0, 815.63 1526673366, 0, 0, 33.799839, -118.646685, 301.5, 814.27 1526673866, 0, 0, 33.800083, -118.646957, 123.5, 817.31 1526674367, 0, 0, 33.800015, -118.646953, 126.1, 816.69 1526674867, 0, 0, 33.799974, -118.647011, 126.6, 816.02 1526675367, 0, 0, 33.799964, -118.647111, 126.2, 815.54 1526675867, 0, 0, 33.799941, -118.647195, 125.1, 814.89 1526676367, 0, 0, 33.799876, -118.647228, 123.7, 814.46 1526676867, 0, 0, 33.799791, -118.647227, 125.0, 813.21 1526677367, 0, 0, 33.799763, -118.647285, 123.2, 813.17 1526677867, 0, 0, 33.799735, -118.647338, 123.9, 813.21 1526678368, 0, 0, 33.799708, -118.647391, 123.3, 813.03 1526678868, 0, 0, 33.799650, -118.647387, 124.3, 813.12 1526679368, 0, 0, 33.799612, -118.647440, 122.9, 813.21 1526679868, 0, 0, 33.800092, -118.649347, 278.4, 702.53 1526680368, 0, 0, 33.800735, -118.650961, 283.2, 534.65 1526680868, 0, 0, 33.800989, -118.651546, 279.5, 342.57 1526681368, 0, 0, 33.800633, -118.652529, 262.9, 164.03 rovNav(): 138: 23485 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018138vntaedited.txt 23485 in tList 23485 in {self->{rovT}} 23485 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526681775 & 1526670480 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 805.660633636739 rovGDCListRefs(): dStats->sample_range = 811.30733368654 rovGDCLiframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/138/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. stRefs(): returning (1st elements): 1526658364 33.800608 -118.646852 16.3 2.58143448278249 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 33.79970200 hash{lon} = -118.64643300 latMin = 27.799702 latMax = 39.799702 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 27.799702 AND 39.799702 AND Longitude BETWEEN -124.646433 AND -112.646433 Dive lat = 33.79970200, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -118.64643300 & lat = 33.79970200 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 = vnta4120rov_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/vnta4120lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2612 shipNav(): $#{$self->{shipLat}}[last] = 33.783873 Position subsampling set to 19 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = 0.2344 0.2344 0.1493 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0.0000 0.3940 0.6060 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 0.6940 0.0000 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0.1286 0.8714 0.0000 makeTracks(): n = 23486 makeTracks(): Looping through 2612 point of ship position data... makeTracks(): posSubsample = 19 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4120tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4120mergedCtdNav.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/18/2018 3:46:00 PM' AND '5/18/2018 10:17:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/18/2018 3:46:00 PM' AND '5/18/2018 10:17:30 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/18/2018 3:46:00 PM' AND '5/18/2018 10:17:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/18/2018 3:46:00 PM' AND '5/18/2018 10:17:30 PM')