Running bin\geopdvc.pl at Sat Jul 21 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4125 bin\geopdvc.pl: Getting Expedition object for diveno = 4125 and rname = vnta set_expd(): rov = vnta, diveno = 4125 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 = 4125 AND RovName = 'vnta' RS->Fields(0)->Value= 6244 RS->Fields(1)->Value= 1527089397 RS->Fields(2)->Value= 1527111134 RS->Fields(3)->Value= 5/23/2018 3:29:57 PM RS->Fields(4)->Value= 5/23/2018 9:32:14 PM set_expd(): $self->{EndDDD} = 143 set_expd(): $self->{StartEsecs} = 1527088197 set_expd(): $self->{EndEsecs} = 1527112334 set_expd(): $self->{EndDtg} = 5/23/2018 9:32:14 PM _readLogr(): Reading videologr data from 2018143datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1527088197 & 1527112334 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1527112344, self->{EndEsecs} = 1527112334 _readLogr(): #LOGHOST_SYSTEM_UTC = 2413 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1527088204 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1527112334 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1527088204 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1527112334 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1527088077, Refined EndEsecs = 1527112454 _readLogr(): Reading videologr data from 2018143datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1527088077 & 1527112454 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1527112464, self->{EndEsecs} = 1527112454 _readLogr(): #LOGHOST_SYSTEM_UTC = 2437 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1527088084 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1527112454 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 = 143 (looping to 143) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018143vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018143vnta.txt esecs, east, north, lat, lon, head, pres 1527089897, 0, 0, 33.357653, -118.140492, -105.1, 234.50 1527090397, 0, 0, 33.357665, -118.140930, -117.6, 478.56 1527090897, 0, 0, 33.357642, -118.141200, -110.2, 702.95 1527091397, 0, 0, 33.357617, -118.141540, -97.9, 771.72 1527091897, 0, 0, 33.357657, -118.141553, -115.4, 771.64 1527092397, 0, 0, 33.357635, -118.141577, -1.4, 770.88 1527092898, 0, 0, 33.357878, -118.141755, -66.7, 761.22 1527093398, 0, 0, 33.358148, -118.142022, -33.0, 744.16 1527093898, 0, 0, 33.358167, -118.142592, -81.1, 711.99 1527094398, 0, 0, 33.358077, -118.142150, -81.1, 734.95 1527094898, 0, 0, 33.358113, -118.142647, -80.6, 709.30 1527095398, 0, 0, 33.358012, -118.142082, -80.5, 741.21 1527095898, 0, 0, 33.358060, -118.142593, -83.2, 711.26 1527096398, 0, 0, 33.357947, -118.142150, -80.4, 736.77 1527096898, 0, 0, 33.357990, -118.142607, -82.1, 712.84 1527097398, 0, 0, 33.357897, -118.142163, -80.6, 736.17 1527097899, 0, 0, 33.357895, -118.142668, -82.5, 710.12 1527098399, 0, 0, 33.357873, -118.142068, -81.1, 742.60 1527098899, 0, 0, 33.357878, -118.142568, -80.4, 714.80 1527099399, 0, 0, 33.357853, -118.142480, -81.2, 720.98 1527099899, 0, 0, 33.357783, -118.141930, -81.8, 752.53 1527100399, 0, 0, 33.357820, -118.142550, -80.8, 717.23 1527100899, 0, 0, 33.357795, -118.142352, -82.5, 725.70 1527101399, 0, 0, 33.357728, -118.141567, -82.8, 769.72 1527101899, 0, 0, 33.357760, -118.142170, -82.0, 735.31 1527102399, 0, 0, 33.357740, -118.142602, -82.0, 713.26 1527102900, 0, 0, 33.357670, -118.141897, -82.1, 752.60 1527103400, 0, 0, 33.357675, -118.141487, -0.8, 771.61 1527103900, 0, 0, 33.358183, -118.141818, -45.9, 753.16 1527104400, 0, 0, 33.358640, -118.142435, -46.9, 712.19 1527104900, 0, 0, 33.358820, -118.142138, -120.0, 715.61 1527105400, 0, 0, 33.358908, -118.142100, -120.3, 716.59 1527105900, 0, 0, 33.358917, -118.142170, -119.8, 715.34 1527106400, 0, 0, 33.358902, -118.142315, -120.5, 712.75 1527106900, 0, 0, 33.358883, -118.142463, -120.8, 710.55 1527107400, 0, 0, 33.358902, -118.142582, -121.4, 708.87 1527107901, 0, 0, 33.358923, -118.142653, -118.6, 708.35 1527108401, 0, 0, 33.358952, -118.142678, -120.3, 707.92 1527108901, 0, 0, 33.359022, -118.142637, -120.1, 709.51 1527109401, 0, 0, 33.359627, -118.141753, 50.5, 694.53 1527109901, 0, 0, 33.359482, -118.141917, 52.6, 483.86 1527110401, 0, 0, 33.359537, -118.142062, 34.3, 286.65 1527110901, 0, 0, 33.359428, -118.142368, 7.3, 79.26 rovNav(): 143: 21732 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018143vnta.txt 21732 in tList 21732 in {self->{rovT}} 21732 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1527093990 & 1527093960 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 710.179739181895 rovGDCListRefs(): dStats->sample_range = 763.79270336634 rovGDCListRefs(): returning (1st elements): 1527089398 33.357502 -118.140490 -153.8 2.6808207398755 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 143 (looping to 143) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018143vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018143vntaedited.txt esecs, east, north, lat, lon, head, pres 1527089897, 0, 0, 33.357656, -118.140493, 254.9, 234.50 1527090397, 0, 0, 33.357677, -118.140940, 242.4, 478.56 1527090897, 0, 0, 33.357644, -118.141198, 249.8, 702.95 1527091397, 0, 0, 33.357636, -118.141542, 262.1, 771.72 1527091897, 0, 0, 33.357662, -118.141547, 244.6, 771.64 1527092397, 0, 0, 33.357624, -118.141553, 358.6, 770.88 1527092898, 0, 0, 33.357880, -118.141760, 293.3, 761.22 1527093398, 0, 0, 33.358139, -118.142016, 327.0, 744.16 1527093898, 0, 0, 33.358154, -118.142587, 278.9, 711.99 1527094398, 0, 0, 33.358099, -118.142162, 278.9, 734.95 1527094898, 0, 0, 33.358120, -118.142641, 279.4, 709.30 1527095398, 0, 0, 33.358014, -118.142075, 279.5, 741.21 1527095898, 0, 0, 33.358056, -118.142608, 276.8, 711.26 1527096398, 0, 0, 33.357944, -118.142163, 279.6, 736.77 1527096898, 0, 0, 33.357981, -118.142597, 277.9, 712.84 1527097398, 0, 0, 33.357907, -118.142169, 279.4, 736.17 1527097899, 0, 0, 33.357914, -118.142666, 277.5, 710.12 1527098399, 0, 0, 33.357869, -118.142072, 278.9, 742.60 1527098899, 0, 0, 33.357887, -118.142564, 279.6, 714.80 1527099399, 0, 0, 33.357857, -118.142466, 278.8, 720.98 1527099899, 0, 0, 33.357781, -118.141931, 278.2, 752.53 1527100399, 0, 0, 33.357816, -118.142554, 279.2, 717.23 1527100899, 0, 0, 33.357812, -118.142342, 277.5, 725.70 1527101399, 0, 0, 33.357722, -118.141575, 277.2, 769.72 1527101899, 0, 0, 33.357759, -118.142175, 278.0, 735.31 1527102399, 0, 0, 33.357745, -118.142605, 278.0, 713.26 1527102900, 0, 0, 33.357686, -118.141899, 277.9, 752.60 1527103400, 0, 0, 33.357677, -118.141503, 359.2, 771.61 1527103900, 0, 0, 33.358190, -118.141821, 314.1, 753.16 1527104400, 0, 0, 33.358626, -118.142438, 313.1, 712.19 1527104900, 0, 0, 33.358828, -118.142143, 240.0, 715.61 1527105400, 0, 0, 33.358900, -118.142111, 239.7, 716.59 1527105900, 0, 0, 33.358924, -118.142170, 240.2, 715.34 1527106400, 0, 0, 33.358912, -118.142305, 239.5, 712.75 1527106900, 0, 0, 33.358889, -118.142462, 239.2, 710.55 1527107400, 0, 0, 33.358903, -118.142573, 238.6, 708.87 1527107901, 0, 0, 33.358920, -118.142636, 241.4, 708.35 1527108401, 0, 0, 33.358955, -118.142679, 239.7, 707.92 1527108901, 0, 0, 33.359023, -118.142656, 239.9, 709.51 1527109401, 0, 0, 33.359625, -118.141757, 50.5, 694.53 1527109901, 0, 0, 33.359477, -118.141929, 52.6, 483.86 1527110401, 0, 0, 33.359535, -118.142063, 34.3, 286.65 1527110901, 0, 0, 33.359426, -118.142396, 7.3, 79.26 rovNav(): 143: 21732 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018143vntaedited.txt 21732 in tList 21732 in {self->{rovT}} 21732 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1527093990 & 1527093960 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/143/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. ................XXXXXXXX rovGDCListRefs(): dMedian = 710.179738760747 rovGDCListRefs(): dStats->sample_range = 763.792704668084 rovGDCListRefs(): returning (1st elements): 1527089398 33.357540 -118.140447 206.2 2.68082073124481 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 33.35798200 hash{lon} = -118.14222200 latMin = 27.357982 latMax = 39.357982 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 27.357982 AND 39.357982 AND Longitude BETWEEN -124.142222 AND -112.142222 Dive lat = 33.35798200, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -118.14222200 & lat = 33.35798200 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 = vnta4125rov_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/vnta4125lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2437 shipNav(): $#{$self->{shipLat}}[last] = 33.372231 Position subsampling set to 17 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 = 21733 makeTracks(): Looping through 2437 point of ship position data... makeTracks(): posSubsample = 17 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4125tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4125mergedCtdNav.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/23/2018 3:29:57 PM' AND '5/23/2018 9:32:14 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/23/2018 3:29:57 PM' AND '5/23/2018 9:32:14 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/23/2018 3:29:57 PM' AND '5/23/2018 9:32:14 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/23/2018 3:29:57 PM' AND '5/23/2018 9:32:14 PM')