Running bin\geopdvc.pl at Wed Jul 18 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4122 bin\geopdvc.pl: Getting Expedition object for diveno = 4122 and rname = vnta set_expd(): rov = vnta, diveno = 4122 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 = 4122 AND RovName = 'vnta' RS->Fields(0)->Value= 6244 RS->Fields(1)->Value= 1526831010 RS->Fields(2)->Value= 1526853675 RS->Fields(3)->Value= 5/20/2018 3:43:30 PM RS->Fields(4)->Value= 5/20/2018 10:01:15 PM set_expd(): $self->{EndDDD} = 140 set_expd(): $self->{StartEsecs} = 1526829810 set_expd(): $self->{EndEsecs} = 1526854875 set_expd(): $self->{EndDtg} = 5/20/2018 10:01:15 PM _readLogr(): Reading videologr data from 2018140datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526829810 & 1526854875 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526854878, self->{EndEsecs} = 1526854875 _readLogr(): #LOGHOST_SYSTEM_UTC = 2505 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526829817 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526854868 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1526829817 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1526854868 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1526829690, Refined EndEsecs = 1526854995 _readLogr(): Reading videologr data from 2018140datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526829690 & 1526854995 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526854998, self->{EndEsecs} = 1526854995 _readLogr(): #LOGHOST_SYSTEM_UTC = 2529 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526829697 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526854988 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 = 140 (looping to 140) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018140vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018140vnta.txt esecs, east, north, lat, lon, head, pres 1526831512, 0, 0, 33.357185, -118.141263, 65.4, 207.28 1526832012, 0, 0, 33.357342, -118.141275, 51.2, 429.43 1526832512, 0, 0, 33.357350, -118.141250, 100.9, 634.92 1526833012, 0, 0, 33.357203, -118.141122, 132.9, 772.66 1526833513, 0, 0, 33.357682, -118.141382, -87.5, 768.68 1526834013, 0, 0, 33.357623, -118.141565, -127.7, 770.45 1526834513, 0, 0, 33.357623, -118.141573, -79.3, 769.25 1526835013, 0, 0, 33.357637, -118.141878, -79.7, 754.18 1526835513, 0, 0, 33.357662, -118.142072, -90.1, 740.24 1526836013, 0, 0, 33.357643, -118.142043, -76.2, 740.47 1526836513, 0, 0, 33.357643, -118.142008, -75.7, 746.65 1526837013, 0, 0, 33.357603, -118.141598, -76.9, 769.57 1526837513, 0, 0, 33.357718, -118.142132, -78.8, 739.08 1526838013, 0, 0, 33.357655, -118.141583, -78.6, 769.43 1526838514, 0, 0, 33.357743, -118.142112, -75.7, 739.12 1526839014, 0, 0, 33.357665, -118.141628, -75.2, 769.50 1526839514, 0, 0, 33.357710, -118.141748, -71.9, 760.65 1526840014, 0, 0, 33.357818, -118.141970, -70.4, 747.29 1526840514, 0, 0, 33.357783, -118.141757, -71.8, 760.77 1526841014, 0, 0, 33.357862, -118.141990, -70.9, 746.24 1526841514, 0, 0, 33.357787, -118.141573, -72.6, 767.51 1526842014, 0, 0, 33.357947, -118.142095, -70.9, 740.26 1526842514, 0, 0, 33.357942, -118.142078, -74.0, 739.39 1526843014, 0, 0, 33.357118, -118.140222, -58.6, 745.46 1526843515, 0, 0, 33.358012, -118.142103, -59.6, 741.70 1526844015, 0, 0, 33.357017, -118.140167, -59.0, 756.40 1526844515, 0, 0, 33.357922, -118.141782, -59.5, 757.09 1526845015, 0, 0, 33.358010, -118.141893, -58.6, 750.18 1526845515, 0, 0, 33.357897, -118.141652, -60.2, 765.61 1526846015, 0, 0, 33.358158, -118.142052, -58.5, 741.47 1526846515, 0, 0, 33.357880, -118.141463, -60.3, 770.42 1526847015, 0, 0, 33.358018, -118.141887, -60.0, 752.88 1526847515, 0, 0, 33.358065, -118.141793, -59.0, 756.38 1526848016, 0, 0, 33.357987, -118.141512, -60.4, 768.41 1526848516, 0, 0, 33.358262, -118.142020, -62.2, 739.86 1526849016, 0, 0, 33.358037, -118.141647, -64.5, 762.98 1526849516, 0, 0, 33.358215, -118.142047, -63.6, 740.72 1526850016, 0, 0, 33.358193, -118.141842, -56.0, 752.20 1526850516, 0, 0, 33.358217, -118.141825, -54.4, 752.38 1526851016, 0, 0, 33.358398, -118.141922, -26.9, 739.23 1526851516, 0, 0, 33.358367, -118.142307, -71.8, 699.47 1526852016, 0, 0, 33.359652, -118.145142, -69.1, 593.28 1526852517, 0, 0, 33.359607, -118.145125, -68.7, 429.94 1526853017, 0, 0, 33.359200, -118.144228, -71.4, 244.81 1526853517, 0, 0, 33.359293, -118.144298, -69.4, 43.25 rovNav(): 140: 22649 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018140vnta.txt 22649 in tList 22649 in {self->{rovT}} 22649 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526840745 & 1526849730 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... rovGDCListRefs(): dMedian = 742.809895285919 rovGDCListRefs(): dStats->sample_range = 763.683916078184 rovGDCListRefs(): returning (1st elements): 1526831013 33.357403 -118.141357 -101.8 2.58153173492074 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 140 (looping to 140) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018140vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018140vntaedited.txt esecs, east, north, lat, lon, head, pres 1526831512, 0, 0, 33.357180, -118.141255, 65.4, 207.28 1526832012, 0, 0, 33.357332, -118.141269, 51.2, 429.43 1526832512, 0, 0, 33.357346, -118.141246, 100.9, 634.92 1526833012, 0, 0, 33.357212, -118.141110, 132.9, 772.66 1526833513, 0, 0, 33.357694, -118.141373, 272.5, 768.68 1526834013, 0, 0, 33.357628, -118.141558, 232.3, 770.45 1526834513, 0, 0, 33.357623, -118.141593, 280.7, 769.25 1526835013, 0, 0, 33.357640, -118.141875, 280.3, 754.18 1526835513, 0, 0, 33.357661, -118.142070, 269.9, 740.24 1526836013, 0, 0, 33.357642, -118.142063, 283.8, 740.47 1526836513, 0, 0, 33.357649, -118.141987, 284.3, 746.65 1526837013, 0, 0, 33.357595, -118.141587, 283.1, 769.57 1526837513, 0, 0, 33.357700, -118.142135, 281.2, 739.08 1526838013, 0, 0, 33.357645, -118.141584, 281.4, 769.43 1526838514, 0, 0, 33.357728, -118.142123, 284.3, 739.12 1526839014, 0, 0, 33.357663, -118.141625, 284.8, 769.50 1526839514, 0, 0, 33.357720, -118.141755, 288.1, 760.65 1526840014, 0, 0, 33.357814, -118.141963, 289.6, 747.29 1526840514, 0, 0, 33.357776, -118.141750, 288.2, 760.77 1526841014, 0, 0, 33.357857, -118.141992, 289.1, 746.24 1526841514, 0, 0, 33.357780, -118.141608, 287.4, 767.51 1526842014, 0, 0, 33.357946, -118.142079, 289.1, 740.26 1526842514, 0, 0, 33.357937, -118.142085, 286.0, 739.39 1526843014, 0, 0, 33.357925, -118.142115, 301.4, 745.46 1526843515, 0, 0, 33.357991, -118.142092, 300.4, 741.70 1526844015, 0, 0, 33.357924, -118.141910, 301.0, 756.40 1526844515, 0, 0, 33.357931, -118.141814, 300.5, 757.09 1526845015, 0, 0, 33.358022, -118.141926, 301.4, 750.18 1526845515, 0, 0, 33.357902, -118.141645, 299.8, 765.61 1526846015, 0, 0, 33.358134, -118.142051, 301.5, 741.47 1526846515, 0, 0, 33.357883, -118.141472, 299.7, 770.42 1526847015, 0, 0, 33.358044, -118.141867, 300.0, 752.88 1526847515, 0, 0, 33.358064, -118.141803, 301.0, 756.38 1526848016, 0, 0, 33.357979, -118.141512, 299.6, 768.41 1526848516, 0, 0, 33.358225, -118.142060, 297.8, 739.86 1526849016, 0, 0, 33.358055, -118.141640, 295.5, 762.98 1526849516, 0, 0, 33.358218, -118.142050, 296.4, 740.72 1526850016, 0, 0, 33.358188, -118.141850, 304.0, 752.20 1526850516, 0, 0, 33.358222, -118.141826, 305.6, 752.38 1526851016, 0, 0, 33.358389, -118.141915, 333.1, 739.23 1526851516, 0, 0, 33.358375, -118.142328, 288.2, 699.47 1526852016, 0, 0, 33.359645, -118.145218, 290.9, 593.28 1526852517, 0, 0, 33.359608, -118.145126, 291.3, 429.94 1526853017, 0, 0, 33.359207, -118.144218, 288.6, 244.81 1526853517, 0, 0, 33.359305, -118.144300, 290.6, 43.25 rovNav(): 140: 22649 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018140vntaedited.txt 22649 in tList 22649 in {self->{rovT}} 22649 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526840745 & 1526849730 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... rovGDCListRefs(): dMedian = 742.809895443237 rovGDCListRefs(): dStats->sample_range = 763.683916145007 rovGDCListRefs(): returning (1st elements): 1526831013 33.357388 -118.141337 258.2 2.5815317382014 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 33.35787600 hash{lon} = -118.14186800 latMin = 27.357876 latMax = 39.357876 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 27.357876 AND 39.357876 AND Longitude BETWEEN -124.141868 AND -112.141868 Dive lat = 33.35787600, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -118.14186800 & lat = 33.35787600 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 = vnta4122rov_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/vnta4122lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2529 shipNav(): $#{$self->{shipLat}}[last] = 33.391139 Position subsampling set to 18 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/140/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. 0.2392 0.2392 0.1547 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0.0000 0.2409 0.7591 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 0.8400 0.0000 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0.3226 0.6774 0.0000 makeTracks(): n = 22650 makeTracks(): Looping through 2529 point of ship position data... makeTracks(): posSubsample = 18 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4122tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4122mergedCtdNav.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/20/2018 3:43:30 PM' AND '5/20/2018 10:01:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/20/2018 3:43:30 PM' AND '5/20/2018 10:01:15 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/20/2018 3:43:30 PM' AND '5/20/2018 10:01:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/20/2018 3:43:30 PM' AND '5/20/2018 10:01:15 PM')