Running bin\geopdvc.pl at Tue Aug 7 03:16:50 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4133 bin\geopdvc.pl: Getting Expedition object for diveno = 4133 and rname = vnta set_expd(): rov = vnta, diveno = 4133 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 = 4133 AND RovName = 'vnta' RS->Fields(0)->Value= 6341 RS->Fields(1)->Value= 1532456579 RS->Fields(2)->Value= 1532468943 RS->Fields(3)->Value= 7/24/2018 6:22:59 PM RS->Fields(4)->Value= 7/24/2018 9:49:03 PM set_expd(): $self->{EndDDD} = 205 set_expd(): $self->{StartEsecs} = 1532455379 set_expd(): $self->{EndEsecs} = 1532470143 set_expd(): $self->{EndDtg} = 7/24/2018 9:49:03 PM _readLogr(): Reading videologr data from 2018205datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1532455379 & 1532470143 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1532470146, self->{EndEsecs} = 1532470143 _readLogr(): #LOGHOST_SYSTEM_UTC = 1475 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1532455386 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1532470136 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1532455386 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1532470136 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1532455259, Refined EndEsecs = 1532470263 _readLogr(): Reading videologr data from 2018205datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1532455259 & 1532470263 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1532470266, self->{EndEsecs} = 1532470263 _readLogr(): #LOGHOST_SYSTEM_UTC = 1499 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1532455266 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1532470256 bin\geopdvc.pl: expdid = 6341 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 = 205 (looping to 205) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018205vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018205vnta.txt esecs, east, north, lat, lon, head, pres 1532457078, 0, 0, 36.746252, -122.051227, -38.7, 173.45 1532457579, 0, 0, 36.746947, -122.051848, -48.1, 364.29 1532458079, 0, 0, 36.746833, -122.052118, -118.5, 543.89 1532458579, 0, 0, 36.746593, -122.052247, -1.6, 644.78 1532459079, 0, 0, 36.746562, -122.052332, 78.9, 651.82 1532459579, 0, 0, 36.746923, -122.052032, 59.7, 640.08 1532460079, 0, 0, 36.746538, -122.052348, 88.6, 652.04 1532460579, 0, 0, 36.746468, -122.052298, 84.6, 652.38 1532461080, 0, 0, 36.746390, -122.052335, 84.5, 651.49 1532461580, 0, 0, 36.746338, -122.052023, -97.1, 642.25 1532462080, 0, 0, 36.746308, -122.051968, 82.9, 641.65 1532462580, 0, 0, 36.746205, -122.052215, -97.8, 652.29 1532463080, 0, 0, 36.746193, -122.051993, 83.7, 641.94 1532463580, 0, 0, 36.746228, -122.051877, 83.5, 641.53 1532464080, 0, 0, 36.746197, -122.051972, 84.7, 640.88 1532464581, 0, 0, 36.746117, -122.052303, 85.1, 652.31 1532465081, 0, 0, 36.746153, -122.051877, 83.7, 638.33 1532465581, 0, 0, 36.746058, -122.052092, 84.0, 640.09 1532466081, 0, 0, 36.747037, -122.051720, 88.5, 648.47 1532466581, 0, 0, 36.746107, -122.051687, 84.8, 638.01 1532467081, 0, 0, 36.746128, -122.052438, -75.3, 652.93 1532467581, 0, 0, 36.746023, -122.052907, -75.5, 464.82 1532468081, 0, 0, 36.745702, -122.052292, -92.7, 295.41 1532468582, 0, 0, 36.745397, -122.051208, -77.6, 132.28 rovNav(): 205: 12360 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018205vnta.txt 12360 in tList 12360 in {self->{rovT}} 12360 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1532466855 & 1532464815 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 635.621115194025 rovGDCListRefs(): dStats->sample_range = 647.507012169198 rovGDCListRefs(): returning (1st elements): 1532456579 36.789945 -121.854157 59.5 2.58076349763531 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 205 (looping to 205) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018205vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018205vntaedited.txt esecs, east, north, lat, lon, head, pres 1532457078, 0, 0, 36.746261, -122.051228, 321.3, 173.45 1532457579, 0, 0, 36.746918, -122.051863, 311.9, 364.29 1532458079, 0, 0, 36.746836, -122.052086, 241.5, 543.89 1532458579, 0, 0, 36.746748, -122.052203, 358.4, 644.78 1532459079, 0, 0, 36.746553, -122.052341, 78.9, 651.82 1532459579, 0, 0, 36.746907, -122.052030, 59.7, 640.08 1532460079, 0, 0, 36.746538, -122.052341, 88.6, 652.04 1532460579, 0, 0, 36.746366, -122.052377, 84.6, 652.38 1532461080, 0, 0, 36.746376, -122.052308, 84.5, 651.49 1532461580, 0, 0, 36.746332, -122.052037, 262.9, 642.25 1532462080, 0, 0, 36.746297, -122.051977, 82.9, 641.65 1532462580, 0, 0, 36.746220, -122.052329, 262.2, 652.29 1532463080, 0, 0, 36.746241, -122.051973, 83.7, 641.94 1532463580, 0, 0, 36.746244, -122.051939, 83.5, 641.53 1532464080, 0, 0, 36.746188, -122.051949, 84.7, 640.88 1532464581, 0, 0, 36.746123, -122.052300, 85.1, 652.31 1532465081, 0, 0, 36.746147, -122.051866, 83.7, 638.33 1532465581, 0, 0, 36.746085, -122.052080, 84.0, 640.09 1532466081, 0, 0, 36.746217, -122.052299, 88.5, 648.47 1532466581, 0, 0, 36.746063, -122.051754, 84.8, 638.01 1532467081, 0, 0, 36.746068, -122.052501, 284.7, 652.93 1532467581, 0, 0, 36.745990, -122.052941, 284.5, 464.82 1532468081, 0, 0, 36.745699, -122.052300, 267.3, 295.41 1532468582, 0, 0, 36.745399, -122.051191, 282.4, 132.28 rovNav(): 205: 12360 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018205vntaedited.txt 12360 in tList 12360 in {self->{rovT}} 12360 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1532466855 & 1532464815 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 635.621117161626 rovGDCListRefs(): dStats->sample_range = 647.507015924301 rovGDCListRefs(): returning (1st elements): 1532456579 36.746338 -122.051335 59.5 2.58077345405396 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74626100 hash{lon} = -122.05208600 latMin = 30.746261 latMax = 42.746261 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.746261 AND 42.746261 AND Longitude BETWEEN -128.052086 AND -116.052086 Dive lat = 36.74626100, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05208600 & lat = 36.74626100 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4133rov_orig.wrl Making color lookup world... var = Light, vmin = 40, vmax = 100 val = 40, color = .8 .7 0 val = 70, colorframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/205/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. = .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/vnta4133lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1499 shipNav(): $#{$self->{shipLat}}[last] = 36.753024 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 = 12361 makeTracks(): Looping through 1499 point of ship position data... makeTracks(): posSubsample = 10 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4133tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4133mergedCtdNav.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 '7/24/2018 6:22:59 PM' AND '7/24/2018 9:49:03 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/24/2018 6:22:59 PM' AND '7/24/2018 9:49:03 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 '7/24/2018 6:22:59 PM' AND '7/24/2018 9:49:03 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/24/2018 6:22:59 PM' AND '7/24/2018 9:49:03 PM')