Running bin\geopdvc.pl at Sun Jun 3 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4112 bin\geopdvc.pl: Getting Expedition object for diveno = 4112 and rname = vnta set_expd(): rov = vnta, diveno = 4112 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 = 4112 AND RovName = 'vnta' RS->Fields(0)->Value= 6250 RS->Fields(1)->Value= 1522944206 RS->Fields(2)->Value= 1522964599 RS->Fields(3)->Value= 4/5/2018 4:03:26 PM RS->Fields(4)->Value= 4/5/2018 9:43:19 PM set_expd(): $self->{EndDDD} = 095 set_expd(): $self->{StartEsecs} = 1522943006 set_expd(): $self->{EndEsecs} = 1522965799 set_expd(): $self->{EndDtg} = 4/5/2018 9:43:19 PM _readLogr(): Reading videologr data from 2018095datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1522943006 & 1522965799 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1522965806, self->{EndEsecs} = 1522965799 _readLogr(): #LOGHOST_SYSTEM_UTC = 2278 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1522943015 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1522965796 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1522943015 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1522965796 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1522942886, Refined EndEsecs = 1522965919 _readLogr(): Reading videologr data from 2018095datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1522942886 & 1522965919 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1522965926, self->{EndEsecs} = 1522965919 _readLogr(): #LOGHOST_SYSTEM_UTC = 2302 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1522942895 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1522965916 bin\geopdvc.pl: expdid = 6250 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 = 095 (looping to 095) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018095vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018095vnta.txt esecs, east, north, lat, lon, head, pres 1522944670, 0, 0, 36.698652, -122.048922, -25.6, 125.60 1522945171, 0, 0, 36.698700, -122.048660, -22.3, 202.20 1522945671, 0, 0, 36.699190, -122.048740, -24.3, 243.30 1522946171, 0, 0, 36.699732, -122.049103, -42.8, 307.80 1522946671, 0, 0, 36.700102, -122.049517, -52.4, 344.80 1522947171, 0, 0, 36.700347, -122.049677, -4.5, 401.90 1522947671, 0, 0, 36.701522, -122.049727, 0.3, 445.90 1522948171, 0, 0, 36.702222, -122.049608, -2.6, 488.00 1522948671, 0, 0, 36.702800, -122.049348, 0.2, 487.90 1522949171, 0, 0, 36.702952, -122.049068, -46.3, 521.50 1522949672, 0, 0, 36.703303, -122.048665, -26.8, 566.70 1522950172, 0, 0, 36.704237, -122.048842, -1.4, 618.20 1522950672, 0, 0, 36.705655, -122.048497, 1.5, 684.20 1522951172, 0, 0, 36.706002, -122.048175, 4.4, 712.50 1522951672, 0, 0, 36.706710, -122.047987, 2.2, 744.80 1522952172, 0, 0, 36.707253, -122.047810, 3.6, 801.80 1522952672, 0, 0, 36.707662, -122.047633, -34.0, 771.10 1522953172, 0, 0, 36.708540, -122.047593, -16.0, 744.90 1522953673, 0, 0, 36.709097, -122.047690, -26.4, 737.60 1522954173, 0, 0, 36.709737, -122.048003, -30.4, 721.10 1522954673, 0, 0, 36.710467, -122.048585, -42.1, 689.40 1522955173, 0, 0, 36.711345, -122.049162, -45.9, 653.90 1522955673, 0, 0, 36.712445, -122.050277, -46.6, 603.70 1522956173, 0, 0, 36.713197, -122.050580, -44.7, 579.10 1522956673, 0, 0, 36.713937, -122.050695, -23.7, 548.50 1522957173, 0, 0, 36.715003, -122.050508, -13.5, 508.90 1522957673, 0, 0, 36.716162, -122.050635, -22.4, 472.90 1522958173, 0, 0, 36.716950, -122.050978, -17.2, 452.30 1522958674, 0, 0, 36.717090, -122.051087, -16.9, 452.20 1522959174, 0, 0, 36.717922, -122.051578, -29.8, 473.80 1522959674, 0, 0, 36.718513, -122.051792, -15.6, 503.50 1522960174, 0, 0, 36.718618, -122.051502, 32.2, 510.10 1522960674, 0, 0, 36.719477, -122.051630, 4.2, 519.10 1522961174, 0, 0, 36.719895, -122.052158, -41.8, 540.00 1522961674, 0, 0, 36.719802, -122.052610, -58.5, 558.60 1522962174, 0, 0, 36.720332, -122.054067, -39.5, 545.60 1522962674, 0, 0, 36.720612, -122.054380, -4.1, 495.20 1522963175, 0, 0, 36.720302, -122.054272, -51.3, 353.90 1522963675, 0, 0, 36.719867, -122.053517, -65.3, 237.60 1522964175, 0, 0, 36.719787, -122.051935, -75.4, 97.10 rovNav(): 095: 20388 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018095vnta.txt 20388 in tList 20388 in {self->{rovT}} 20388 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1522963470 & 1522944765 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 512.339002910211 rovGDCListRefs(): dStats->sample_range = 800.057642924531 rovGDCListRefs(): returning (1st elements): 1522944207 36.737323 -122.098445 -31.4 2.77929534761037 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 095 (looping to 095) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018095vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018095vntaedited.txt esecs, east, north, lat, lon, head, pres 1522944670, 0, 0, 36.698656, -122.048915, 334.4, 125.60 1522945171, 0, 0, 36.698712, -122.048682, 337.7, 202.20 1522945671, 0, 0, 36.699422, -122.048706, 335.7, 243.30 1522946171, 0, 0, 36.699739, -122.049110, 317.2, 307.80 1522946671, 0, 0, 36.700076, -122.049496, 307.6, 344.80 1522947171, 0, 0, 36.700356, -122.049661, 355.5, 401.90 1522947671, 0, 0, 36.701487, -122.049732, 0.3, 445.90 1522948171, 0, 0, 36.702219, -122.049600, 357.4, 488.00 1522948671, 0, 0, 36.702798, -122.049348, 0.2, 487.90 1522949171, 0, 0, 36.702950, -122.049072, 313.7, 521.50 1522949672, 0, 0, 36.703308, -122.048668, 333.2, 566.70 1522950172, 0, 0, 36.704251, -122.048834, 358.6, 618.20 1522950672, 0, 0, 36.705654, -122.048504, 1.5, 684.20 1522951172, 0, 0, 36.705999, -122.048167, 4.4, 712.50 1522951672, 0, 0, 36.706707, -122.047976, 2.2, 744.80 1522952172, 0, 0, 36.707253, -122.047813, 3.6, 801.80 1522952672, 0, 0, 36.707664, -122.047636, 326.0, 771.10 1522953172, 0, 0, 36.708550, -122.047592, 344.0, 744.90 1522953673, 0, 0, 36.709093, -122.047679, 333.6, 737.60 1522954173, 0, 0, 36.709738, -122.048004, 329.6, 721.10 1522954673, 0, 0, 36.710475, -122.048573, 317.9, 689.40 1522955173, 0, 0, 36.711357, -122.049152, 314.1, 653.90 1522955673, 0, 0, 36.712417, -122.050271, 313.4, 603.70 1522956173, 0, 0, 36.713190, -122.050569, 315.3, 579.10 1522956673, 0, 0, 36.713924, -122.050686, 336.3, 548.50 1522957173, 0, 0, 36.715013, -122.050499, 346.5, 508.90 1522957673, 0, 0, 36.716168, -122.050625, 337.6, 472.90 1522958173, 0, 0, 36.716919, -122.051102, 342.8, 452.30 1522958674, 0, 0, 36.717089, -122.051084, 343.1, 452.20 1522959174, 0, 0, 36.717921, -122.051591, 330.2, 473.80 1522959674, 0, 0, 36.718520, -122.051798, 344.4, 503.50 1522960174, 0, 0, 36.718628, -122.051493, 32.2, 510.10 1522960674, 0, 0, 36.719464, -122.051627, 4.2, 519.10 1522961174, 0, 0, 36.719901, -122.052165, 318.2, 540.00 1522961674, 0, 0, 36.719793, -122.052619, 301.5, 558.60 1522962174, 0, 0, 36.720331, -122.054077, 320.5, 545.60 1522962674, 0, 0, 36.720556, -122.054389, 355.9, 495.20 1522963175, 0, 0, 36.720298, -122.054283, 308.7, 353.90 1522963675, 0, 0, 36.719869, -122.053496, 294.7, 237.60 1522964175, 0, 0, 36.719784, -122.051926, 284.6, 97.10 rovNav(): 095: 20388 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018095vntaedited.txt 20388 in tList 20388 in {self->{rovT}} 20388 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1522963470 & 1522944765 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/095/accesses.txt at bin\geopdvc.pl line 2382 .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 512.339002729006 rovGDCListRefs(): dStats->sample_range = 800.05763873493 rovGDCListRefs(): returning (1st elements): 1522944207 36.698990 -122.049532 328.6 2.77930476824513 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.71009400 hash{lon} = -122.04962600 latMin = 30.710094 latMax = 42.710094 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.710094 AND 42.710094 AND Longitude BETWEEN -128.049626 AND -116.049626 Dive lat = 36.71009400, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04962600 & lat = 36.71009400 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... makeROVorig(): Number of points greater than 20,000. Skipping every other point for .wrl file. inline_name = vnta4112rov_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/vnta4112lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2302 shipNav(): $#{$self->{shipLat}}[last] = 36.724966 Position subsampling set to 16 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 = 20389 makeTracks(): Looping through 2302 point of ship position data... makeTracks(): posSubsample = 16 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4112tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4112mergedCtdNav.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/Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. 5/2018 4:03:26 PM' AND '4/5/2018 9:43:19 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '4/5/2018 4:03:26 PM' AND '4/5/2018 9:43:19 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 '4/5/2018 4:03:26 PM' AND '4/5/2018 9:43:19 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '4/5/2018 4:03:26 PM' AND '4/5/2018 9:43:19 PM')