Running bin\geopdvc.pl at Fri Apr 27 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4101 bin\geopdvc.pl: Getting Expedition object for diveno = 4101 and rname = vnta set_expd(): rov = vnta, diveno = 4101 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 = 4101 AND RovName = 'vnta' RS->Fields(0)->Value= 6214 RS->Fields(1)->Value= 1519752189 RS->Fields(2)->Value= 1519764459 RS->Fields(3)->Value= 2/27/2018 5:23:09 PM RS->Fields(4)->Value= 2/27/2018 8:47:39 PM set_expd(): $self->{EndDDD} = 058 set_expd(): $self->{StartEsecs} = 1519750989 set_expd(): $self->{EndEsecs} = 1519765659 set_expd(): $self->{EndDtg} = 2/27/2018 8:47:39 PM _readLogr(): Reading videologr data from 2018058datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1519750989 & 1519765659 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1519765661, self->{EndEsecs} = 1519765659 _readLogr(): #LOGHOST_SYSTEM_UTC = 1465 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1519750998 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1519765651 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1519750998 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1519765651 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1519750869, Refined EndEsecs = 1519765779 _readLogr(): Reading videologr data from 2018058datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1519750869 & 1519765779 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1519765781, self->{EndEsecs} = 1519765779 _readLogr(): #LOGHOST_SYSTEM_UTC = 1489 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1519750878 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1519765771 bin\geopdvc.pl: expdid = 6214 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 = 058 (looping to 058) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018058vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018058vnta.txt esecs, east, north, lat, lon, head, pres 1519752689, 0, 0, 36.791963, -122.132072, -175.5, 152.78 1519753190, 0, 0, 36.791313, -122.132102, -175.2, 341.74 1519753691, 0, 0, 36.791195, -122.132355, 25.5, 403.01 1519754191, 0, 0, 36.791260, -122.132892, 23.4, 404.01 1519754692, 0, 0, 36.791300, -122.132653, 21.3, 406.34 1519755193, 0, 0, 36.791498, -122.133098, 13.7, 401.91 1519755694, 0, 0, 36.791872, -122.134140, -1.5, 402.72 1519756195, 0, 0, 36.792442, -122.135102, -21.5, 405.36 1519756696, 0, 0, 36.792743, -122.135877, -7.4, 402.79 1519757197, 0, 0, 36.793345, -122.136882, -42.3, 403.80 1519757697, 0, 0, 36.793530, -122.136862, -25.3, 403.94 1519758198, 0, 0, 36.793963, -122.137248, -25.9, 404.16 1519758699, 0, 0, 36.794577, -122.138070, -39.5, 402.32 1519759200, 0, 0, 36.795232, -122.139193, -36.4, 402.21 1519759701, 0, 0, 36.795880, -122.140290, -36.6, 402.63 1519760202, 0, 0, 36.796622, -122.140875, 7.7, 402.72 1519760702, 0, 0, 36.796992, -122.141122, -16.8, 401.49 1519761203, 0, 0, 36.797477, -122.141487, -29.5, 401.73 1519761704, 0, 0, 36.798047, -122.141880, -20.9, 403.09 1519762205, 0, 0, 36.798577, -122.142122, -20.9, 401.48 1519762706, 0, 0, 36.799183, -122.142410, -15.3, 402.71 1519763206, 0, 0, 36.799193, -122.142228, -2.7, 260.04 1519763707, 0, 0, 36.799190, -122.142417, -8.5, 103.08 1519764208, 0, 0, 36.799052, -122.142317, 3.9, 13.17 rovNav(): 058: 12250 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018058vnta.txt 12250 in tList 12250 in {self->{rovT}} 12250 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1519754625 & 1519764405 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 399.024535947751 rovGDCListRefs(): dStats->sample_range = 401.080068960956 rovGDCListRefs(): returning (1st elements): 1519752189 36.794743 -121.890083 29.5 2.58076240187594 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 058 (looping to 058) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018058vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018058vntaedited.txt esecs, east, north, lat, lon, head, pres 1519752689, 0, 0, 36.791966, -122.132053, 184.5, 152.78 1519753190, 0, 0, 36.791332, -122.132072, 184.8, 341.74 1519753691, 0, 0, 36.791218, -122.132339, 25.5, 403.01 1519754191, 0, 0, 36.791274, -122.132918, 23.4, 404.01 1519754692, 0, 0, 36.791242, -122.132945, 21.3, 406.34 1519755193, 0, 0, 36.791510, -122.133141, 13.7, 401.91 1519755694, 0, 0, 36.791865, -122.134144, 358.5, 402.72 1519756195, 0, 0, 36.792371, -122.135147, 338.5, 405.36 1519756696, 0, 0, 36.792782, -122.135843, 352.6, 402.79 1519757197, 0, 0, 36.793327, -122.136782, 317.7, 403.80 1519757697, 0, 0, 36.793532, -122.136837, 334.7, 403.94 1519758198, 0, 0, 36.793976, -122.137234, 334.1, 404.16 1519758699, 0, 0, 36.794588, -122.138084, 320.5, 402.32 1519759200, 0, 0, 36.795224, -122.139208, 323.6, 402.21 1519759701, 0, 0, 36.795890, -122.140259, 323.4, 402.63 1519760202, 0, 0, 36.796594, -122.140878, 7.7, 402.72 1519760702, 0, 0, 36.796994, -122.141119, 343.2, 401.49 1519761203, 0, 0, 36.797501, -122.141462, 330.5, 401.73 1519761704, 0, 0, 36.798053, -122.141872, 339.1, 403.09 1519762205, 0, 0, 36.798573, -122.142108, 339.1, 401.48 1519762706, 0, 0, 36.799163, -122.142422, 344.7, 402.71 1519763206, 0, 0, 36.799182, -122.142324, 357.3, 260.04 1519763707, 0, 0, 36.799170, -122.142388, 351.5, 103.08 1519764208, 0, 0, 36.799054, -122.142293, 3.9, 13.17 rovNav(): 058: 12250 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018058vntaedited.txt 12250 in tList 12250 in {self->{rovT}} 12250 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1519754625 & 1519764405 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 399.024535241574 rovGDCListRefs(): dStats->sample_range = 401.080068533336 rovGDCListRefs(): returning (1st elements): 1519752189 36.792245 -122.132588 29.5 2.58076297237181 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79413100 hash{lon} = -122.13739500 latMin = 30.794131 latMax = 42.794131 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.794131 AND 42.794131 AND Longitude BETWEEN -128.137395 AND -116.137395 Dive lat = 36.79413100, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.13739500 & lat = 36.79413100 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4101rov_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, vmiframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/058/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. n = 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/vnta4101lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1489 shipNav(): $#{$self->{shipLat}}[last] = 36.802113 Position subsampling set to 10 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 = 12251 makeTracks(): Looping through 1489 point of ship position data... makeTracks(): posSubsample = 10 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4101tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4101mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '2/27/2018 5:23:09 PM' AND '2/27/2018 8:47:39 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/27/2018 5:23:09 PM' AND '2/27/2018 8:47:39 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 '2/27/2018 5:23:09 PM' AND '2/27/2018 8:47:39 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/27/2018 5:23:09 PM' AND '2/27/2018 8:47:39 PM')