Running bin\geopdvc.pl at Thu May 31 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4110 bin\geopdvc.pl: Getting Expedition object for diveno = 4110 and rname = vnta set_expd(): rov = vnta, diveno = 4110 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 = 4110 AND RovName = 'vnta' RS->Fields(0)->Value= 6246 RS->Fields(1)->Value= 1522694700 RS->Fields(2)->Value= 1522705843 RS->Fields(3)->Value= 4/2/2018 6:45:00 PM RS->Fields(4)->Value= 4/2/2018 9:50:43 PM set_expd(): $self->{EndDDD} = 092 set_expd(): $self->{StartEsecs} = 1522693500 set_expd(): $self->{EndEsecs} = 1522707043 set_expd(): $self->{EndDtg} = 4/2/2018 9:50:43 PM _readLogr(): Reading videologr data from 2018092datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1522693500 & 1522707043 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1522707045, self->{EndEsecs} = 1522707043 _readLogr(): #LOGHOST_SYSTEM_UTC = 1353 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1522693505 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1522707035 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1522693505 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1522707035 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1522693380, Refined EndEsecs = 1522707163 _readLogr(): Reading videologr data from 2018092datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1522693380 & 1522707163 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1522707165, self->{EndEsecs} = 1522707163 _readLogr(): #LOGHOST_SYSTEM_UTC = 1377 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1522693385 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1522707155 bin\geopdvc.pl: expdid = 6246 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 = 092 (looping to 092) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018092vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018092vnta.txt esecs, east, north, lat, lon, head, pres 1522695200, 0, 0, 36.794247, -122.012850, -68.8, 156.74 1522695701, 0, 0, 36.793867, -122.013052, -178.5, 215.61 1522696201, 0, 0, 36.792467, -122.013400, -161.0, 198.00 1522696701, 0, 0, 36.792353, -122.013660, -168.8, 202.26 1522697201, 0, 0, 36.792268, -122.013647, -56.3, 283.40 1522697701, 0, 0, 36.792247, -122.013708, 136.1, 466.82 1522698201, 0, 0, 36.792398, -122.013153, 17.1, 674.05 1522698701, 0, 0, 36.792470, -122.012738, 89.8, 683.71 1522699201, 0, 0, 36.792838, -122.012030, 94.0, 666.19 1522699701, 0, 0, 36.792813, -122.011410, 165.7, 649.60 1522700201, 0, 0, 36.792845, -122.011323, -166.6, 650.65 1522700702, 0, 0, 36.792853, -122.011327, -169.0, 650.65 1522701202, 0, 0, 36.792825, -122.011323, -170.0, 650.69 1522701702, 0, 0, 36.792805, -122.011295, -169.4, 650.65 1522702202, 0, 0, 36.792798, -122.011188, 95.3, 643.34 1522702702, 0, 0, 36.792812, -122.010787, 179.7, 631.26 1522703202, 0, 0, 36.792727, -122.010713, -180.0, 631.33 1522703702, 0, 0, 36.792762, -122.010685, 179.5, 631.24 1522704202, 0, 0, 36.793093, -122.011075, -40.6, 508.49 1522704702, 0, 0, 36.792813, -122.010795, -39.3, 279.86 1522705202, 0, 0, 36.792568, -122.010662, -37.5, 84.02 1522705703, 0, 0, 36.791690, -122.010950, -44.2, 10.70 rovNav(): 092: 11139 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018092vnta.txt 11139 in tList 11139 in {self->{rovT}} 11139 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1522701630 & 1522695270 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 625.594352558047 rovGDCListRefs(): dStats->sample_range = 680.272218096958 rovGDCListRefs(): returning (1st elements): 1522694701 36.770005 -122.000695 -36.5 2.68002770610275 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 092 (looping to 092) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018092vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018092vntaedited.txt esecs, east, north, lat, lon, head, pres 1522695200, 0, 0, 36.794283, -122.012862, 291.2, 156.74 1522695701, 0, 0, 36.793886, -122.013079, 181.5, 215.61 1522696201, 0, 0, 36.792483, -122.013403, 199.0, 198.00 1522696701, 0, 0, 36.792366, -122.013620, 191.2, 202.26 1522697201, 0, 0, 36.792255, -122.013674, 303.7, 283.40 1522697701, 0, 0, 36.792203, -122.013588, 136.1, 466.82 1522698201, 0, 0, 36.792363, -122.013111, 17.1, 674.05 1522698701, 0, 0, 36.792482, -122.012700, 89.8, 683.71 1522699201, 0, 0, 36.792825, -122.012004, 94.0, 666.19 1522699701, 0, 0, 36.792840, -122.011363, 165.7, 649.60 1522700201, 0, 0, 36.792824, -122.011350, 193.4, 650.65 1522700702, 0, 0, 36.792829, -122.011323, 191.0, 650.65 1522701202, 0, 0, 36.792814, -122.011345, 190.0, 650.69 1522701702, 0, 0, 36.792836, -122.011307, 190.6, 650.65 1522702202, 0, 0, 36.792817, -122.011118, 95.3, 643.34 1522702702, 0, 0, 36.792769, -122.010703, 179.7, 631.26 1522703202, 0, 0, 36.792773, -122.010701, 180.0, 631.33 1522703702, 0, 0, 36.792741, -122.010688, 179.5, 631.24 1522704202, 0, 0, 36.793104, -122.011077, 319.4, 508.49 1522704702, 0, 0, 36.792771, -122.010740, 320.7, 279.86 1522705202, 0, 0, 36.792551, -122.010693, 322.5, 84.02 1522705703, 0, 0, 36.791709, -122.010914, 315.8, 10.70 rovNav(): 092: 11139 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018092vntaedited.txt 11139 in tList 11139 in {self->{rovT}} 11139 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1522701630 & 1522695270 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/092/accesses.txt at bin\geopdvc.pl line 2382 .......................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 625.594353000901 rovGDCListRefs(): dStats->sample_range = 680.272223849196 rovGDCListRefs(): returning (1st elements): 1522694701 36.794262 -122.012391 323.5 2.68002195386507 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79278600 hash{lon} = -122.01134600 latMin = 30.792786 latMax = 42.792786 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.792786 AND 42.792786 AND Longitude BETWEEN -128.011346 AND -116.011346 Dive lat = 36.79278600, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.01134600 & lat = 36.79278600 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4110rov_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/vnta4110lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1377 shipNav(): $#{$self->{shipLat}}[last] = 36.788932 Position subsampling set to 9 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = 0.3847 0.3277 0.0000 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0 0 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 1.0000 0.0116 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0.6062 0.3938 0.0000 makeTracks(): n = 11140 makeTracks(): Looping through 1377 point of ship position data... makeTracks(): posSubsample = 9 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4110tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4110mergedCtdNav.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 '4/2/2018 6:45:00 PM' AND '4/2/2018 9:50:43 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '4/2/2018 6:45:00 PM' AND '4/2/2018 9:50:43 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, ObservatCan't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. ionID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '4/2/2018 6:45:00 PM' AND '4/2/2018 9:50:43 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '4/2/2018 6:45:00 PM' AND '4/2/2018 9:50:43 PM')