Running bin\geopdvc.pl at Thu Jul 19 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4123 bin\geopdvc.pl: Getting Expedition object for diveno = 4123 and rname = vnta set_expd(): rov = vnta, diveno = 4123 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 = 4123 AND RovName = 'vnta' RS->Fields(0)->Value= 6244 RS->Fields(1)->Value= 1526916795 RS->Fields(2)->Value= 1526939520 RS->Fields(3)->Value= 5/21/2018 3:33:15 PM RS->Fields(4)->Value= 5/21/2018 9:52:00 PM set_expd(): $self->{EndDDD} = 141 set_expd(): $self->{StartEsecs} = 1526915595 set_expd(): $self->{EndEsecs} = 1526940720 set_expd(): $self->{EndDtg} = 5/21/2018 9:52:00 PM _readLogr(): Reading videologr data from 2018141datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526915595 & 1526940720 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526940730, self->{EndEsecs} = 1526940720 _readLogr(): #LOGHOST_SYSTEM_UTC = 2512 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526915599 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526940720 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1526915599 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1526940720 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1526915475, Refined EndEsecs = 1526940840 _readLogr(): Reading videologr data from 2018141datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526915475 & 1526940840 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526940850, self->{EndEsecs} = 1526940840 _readLogr(): #LOGHOST_SYSTEM_UTC = 2536 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526915479 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526940840 bin\geopdvc.pl: expdid = 6244 bin\geopdvc.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 141 (looping to 141) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018141vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018141vnta.txt esecs, east, north, lat, lon, head, pres 1526917300, 0, 0, 33.357495, -118.141082, -110.1, 189.05 1526917800, 0, 0, 33.357612, -118.141545, -41.2, 378.25 1526918300, 0, 0, 33.357585, -118.141422, -48.1, 549.43 1526918800, 0, 0, 33.357432, -118.141432, -51.1, 764.33 1526919300, 0, 0, 33.357607, -118.141557, -42.7, 770.24 1526919800, 0, 0, 33.357883, -118.141375, 31.1, 770.28 1526920300, 0, 0, 33.358063, -118.141537, -28.6, 764.28 1526920800, 0, 0, 33.358413, -118.141743, -28.4, 741.74 1526921300, 0, 0, 33.358803, -118.142117, -36.5, 715.96 1526921801, 0, 0, 33.358477, -118.141830, -30.1, 734.93 1526922301, 0, 0, 33.358130, -118.141555, -30.4, 760.42 1526922801, 0, 0, 33.358257, -118.141733, -29.3, 750.34 1526923301, 0, 0, 33.358550, -118.141970, -33.6, 726.67 1526923801, 0, 0, 33.358560, -118.141995, -33.0, 725.64 1526924301, 0, 0, 33.358230, -118.141682, -29.1, 753.86 1526924801, 0, 0, 33.358150, -118.141675, -29.3, 757.18 1526925301, 0, 0, 33.358453, -118.141900, -27.9, 734.93 1526925801, 0, 0, 33.358587, -118.142017, -34.7, 723.74 1526926301, 0, 0, 33.358910, -118.142075, -37.4, 717.39 1526926802, 0, 0, 33.358812, -118.141773, -72.4, 731.55 1526927302, 0, 0, 33.358670, -118.141285, -77.4, 767.48 1526927802, 0, 0, 33.358693, -118.141392, -69.1, 760.19 1526928302, 0, 0, 33.358788, -118.141767, -71.3, 729.18 1526928802, 0, 0, 33.358778, -118.141902, -71.4, 722.78 1526929302, 0, 0, 33.358670, -118.141400, -71.4, 758.02 1526929802, 0, 0, 33.358718, -118.141800, -71.0, 730.33 1526930302, 0, 0, 33.358810, -118.142020, -73.4, 721.12 1526930802, 0, 0, 33.358635, -118.141568, -71.5, 747.90 1526931303, 0, 0, 33.358630, -118.141618, -72.1, 744.59 1526931803, 0, 0, 33.358612, -118.141753, -70.8, 736.61 1526932303, 0, 0, 33.358513, -118.141495, -70.5, 756.53 1526932803, 0, 0, 33.358602, -118.141895, -71.3, 729.40 1526933303, 0, 0, 33.358447, -118.141368, -72.6, 766.28 1526933803, 0, 0, 33.358523, -118.141808, -70.5, 738.01 1526934303, 0, 0, 33.358430, -118.141580, -71.7, 753.47 1526934803, 0, 0, 33.358395, -118.141442, -70.0, 764.86 1526935304, 0, 0, 33.358372, -118.141605, -70.2, 754.61 1526935804, 0, 0, 33.358340, -118.141670, -69.3, 751.25 1526936304, 0, 0, 33.358275, -118.141667, -71.1, 753.27 1526936804, 0, 0, 33.358183, -118.141563, -70.9, 760.72 1526937304, 0, 0, 33.358093, -118.141562, -72.7, 764.42 1526937804, 0, 0, 33.358857, -118.140680, 9.3, 704.64 1526938304, 0, 0, 33.358928, -118.140825, 9.4, 494.58 1526938804, 0, 0, 33.358992, -118.140937, 9.0, 290.72 1526939304, 0, 0, 33.359048, -118.141402, 56.7, 83.70 rovNav(): 141: 22713 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018141vnta.txt 22713 in tList 22713 in {self->{rovT}} 22713 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526922120 & 1526924985 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX rovGDCListRefs(): dMedian = 734.93478254841 rovGDCListRefs(): dStats->sample_range = 761.952730404274 rovGDCListRefs(): returning (1st elements): 1526916800 33.357667 -118.140700 -99.2 2.68082070240009 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 141 (looping to 141) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018141vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018141vntaedited.txt esecs, east, north, lat, lon, head, pres 1526917300, 0, 0, 33.357498, -118.141088, 249.9, 189.05 1526917800, 0, 0, 33.357610, -118.141541, 318.8, 378.25 1526918300, 0, 0, 33.357582, -118.141416, 311.9, 549.43 1526918800, 0, 0, 33.357485, -118.141468, 308.9, 764.33 1526919300, 0, 0, 33.357621, -118.141555, 317.3, 770.24 1526919800, 0, 0, 33.357871, -118.141375, 31.1, 770.28 1526920300, 0, 0, 33.358079, -118.141531, 331.4, 764.28 1526920800, 0, 0, 33.358407, -118.141738, 331.6, 741.74 1526921300, 0, 0, 33.358799, -118.142116, 323.5, 715.96 1526921801, 0, 0, 33.358463, -118.141830, 329.9, 734.93 1526922301, 0, 0, 33.358129, -118.141565, 329.6, 760.42 1526922801, 0, 0, 33.358265, -118.141729, 330.7, 750.34 1526923301, 0, 0, 33.358564, -118.141963, 326.4, 726.67 1526923801, 0, 0, 33.358570, -118.141992, 327.0, 725.64 1526924301, 0, 0, 33.358232, -118.141683, 330.9, 753.86 1526924801, 0, 0, 33.358158, -118.141669, 330.7, 757.18 1526925301, 0, 0, 33.358451, -118.141910, 332.1, 734.93 1526925801, 0, 0, 33.358582, -118.142018, 325.3, 723.74 1526926301, 0, 0, 33.358880, -118.142101, 322.6, 717.39 1526926802, 0, 0, 33.358808, -118.141764, 287.6, 731.55 1526927302, 0, 0, 33.358672, -118.141282, 282.6, 767.48 1526927802, 0, 0, 33.358703, -118.141378, 290.9, 760.19 1526928302, 0, 0, 33.358788, -118.141777, 288.7, 729.18 1526928802, 0, 0, 33.358788, -118.141892, 288.6, 722.78 1526929302, 0, 0, 33.358660, -118.141406, 288.6, 758.02 1526929802, 0, 0, 33.358720, -118.141787, 289.0, 730.33 1526930302, 0, 0, 33.358800, -118.141985, 286.6, 721.12 1526930802, 0, 0, 33.358638, -118.141561, 288.5, 747.90 1526931303, 0, 0, 33.358627, -118.141624, 287.9, 744.59 1526931803, 0, 0, 33.358604, -118.141759, 289.2, 736.61 1526932303, 0, 0, 33.358520, -118.141499, 289.5, 756.53 1526932803, 0, 0, 33.358604, -118.141893, 288.7, 729.40 1526933303, 0, 0, 33.358452, -118.141377, 287.4, 766.28 1526933803, 0, 0, 33.358523, -118.141794, 289.5, 738.01 1526934303, 0, 0, 33.358443, -118.141577, 288.3, 753.47 1526934803, 0, 0, 33.358393, -118.141443, 290.0, 764.86 1526935304, 0, 0, 33.358371, -118.141592, 289.8, 754.61 1526935804, 0, 0, 33.358339, -118.141668, 290.7, 751.25 1526936304, 0, 0, 33.358290, -118.141669, 288.9, 753.27 1526936804, 0, 0, 33.358189, -118.141567, 289.1, 760.72 1526937304, 0, 0, 33.358099, -118.141576, 287.3, 764.42 1526937804, 0, 0, 33.358865, -118.140660, 9.3, 704.64 1526938304, 0, 0, 33.358930, -118.140823, 9.4, 494.58 1526938804, 0, 0, 33.358988, -118.140936, 9.0, 290.72 1526939304, 0, 0, 33.359053, -118.141398, 56.7, 83.70 rovNav(): 141: 22713 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018141vntaedited.txt 22713 in tList 22713 in {self->{rovT}} 22713 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526922120 & 1526924985 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX rovGDCListRefs(): dMedian = 734.934782143717 rovGDCListRefs(): dStats->sample_range = 761.952730353614 rovGDCListRefs(): returning (1st elements): 1526916800 33.357733 -118.140712 260.8 2.6808206874099 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 33.35849850 hash{lon} = -118.14158850 latMin = 27.3584985 latMax = 39.3584985 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 27.3584985 AND 39.3584985 AND Longitude BETWEEN -124.1415885 AND -112.1415885 Dive lat = 33.35849850, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -118.14158850 & lat = 33.35849850 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 = vnta4123rov_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/vnta4123lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2536 shipNav(): $#{$self->{shipLat}}[last] = 33.39frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/141/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. 6371 Position subsampling set to 18 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = 0.2812 0.2812 0.2013 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0.0000 0.3626 0.6374 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 0.6860 0.0000 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0.1026 0.8974 0.0000 makeTracks(): n = 22714 makeTracks(): Looping through 2536 point of ship position data... makeTracks(): posSubsample = 18 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4123tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4123mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '5/21/2018 3:33:15 PM' AND '5/21/2018 9:52:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/21/2018 3:33:15 PM' AND '5/21/2018 9:52:00 PM') Empty Return Set: RS from: Server=equinox,1433;Database=VARS;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '5/21/2018 3:33:15 PM' AND '5/21/2018 9:52:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/21/2018 3:33:15 PM' AND '5/21/2018 9:52:00 PM')