Running bin\geopdvc.pl at Sun Jul 15 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4119 bin\geopdvc.pl: Getting Expedition object for diveno = 4119 and rname = vnta set_expd(): rov = vnta, diveno = 4119 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 = 4119 AND RovName = 'vnta' RS->Fields(0)->Value= 6244 RS->Fields(1)->Value= 1526571540 RS->Fields(2)->Value= 1526592855 RS->Fields(3)->Value= 5/17/2018 3:39:00 PM RS->Fields(4)->Value= 5/17/2018 9:34:15 PM set_expd(): $self->{EndDDD} = 137 set_expd(): $self->{StartEsecs} = 1526570340 set_expd(): $self->{EndEsecs} = 1526594055 set_expd(): $self->{EndDtg} = 5/17/2018 9:34:15 PM _readLogr(): Reading videologr data from 2018137datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526570340 & 1526594055 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526594061, self->{EndEsecs} = 1526594055 _readLogr(): #LOGHOST_SYSTEM_UTC = 2370 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526570350 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526594051 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1526570350 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1526594051 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1526570220, Refined EndEsecs = 1526594175 _readLogr(): Reading videologr data from 2018137datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1526570220 & 1526594175 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1526594181, self->{EndEsecs} = 1526594175 _readLogr(): #LOGHOST_SYSTEM_UTC = 2394 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1526570230 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1526594171 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 = 137 (looping to 137) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018137vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018137vnta.txt esecs, east, north, lat, lon, head, pres 1526572036, 0, 0, 33.799793, -118.647698, 97.2, 192.03 1526572536, 0, 0, 33.799692, -118.646980, 87.6, 380.50 1526573037, 0, 0, 33.799877, -118.646827, 100.2, 583.51 1526573537, 0, 0, 33.799735, -118.646628, 106.4, 744.90 1526574037, 0, 0, 33.799605, -118.646777, 169.6, 804.89 1526574537, 0, 0, 33.799497, -118.646593, -164.5, 806.69 1526575037, 0, 0, 33.798942, -118.646242, 150.9, 812.65 1526575537, 0, 0, 33.798612, -118.645992, -59.2, 822.34 1526576037, 0, 0, 33.799032, -118.646860, -60.5, 805.53 1526576537, 0, 0, 33.798740, -118.646203, -61.8, 815.35 1526577037, 0, 0, 33.798895, -118.646463, -60.9, 809.46 1526577538, 0, 0, 33.798875, -118.646425, -63.5, 810.65 1526578038, 0, 0, 33.798818, -118.646152, -57.9, 815.33 1526578538, 0, 0, 33.799075, -118.646658, -59.0, 805.84 1526579038, 0, 0, 33.798810, -118.646038, -57.5, 818.58 1526579538, 0, 0, 33.799153, -118.646715, -59.7, 805.49 1526580038, 0, 0, 33.798760, -118.645975, -59.1, 820.73 1526580538, 0, 0, 33.799222, -118.646765, -58.6, 805.91 1526581038, 0, 0, 33.798892, -118.646053, -57.9, 817.32 1526581538, 0, 0, 33.799147, -118.646468, -58.3, 807.38 1526582039, 0, 0, 33.799098, -118.646295, -61.8, 810.24 1526582539, 0, 0, 33.798985, -118.646038, -58.0, 815.35 1526583039, 0, 0, 33.799303, -118.646595, -61.8, 805.68 1526583539, 0, 0, 33.798997, -118.646017, -59.7, 817.78 1526584039, 0, 0, 33.799227, -118.646398, -58.2, 809.02 1526584539, 0, 0, 33.799370, -118.646690, -61.0, 805.47 1526585039, 0, 0, 33.799097, -118.646145, -60.4, 814.41 1526585539, 0, 0, 33.799068, -118.645992, -59.4, 817.27 1526586039, 0, 0, 33.799615, -118.646583, -63.2, 804.48 1526586539, 0, 0, 33.799370, -118.646568, -58.5, 806.25 1526587040, 0, 0, 33.799118, -118.645965, -55.8, 817.13 1526587540, 0, 0, 33.799287, -118.646265, -55.4, 810.97 1526588040, 0, 0, 33.799178, -118.646048, -56.2, 815.59 1526588540, 0, 0, 33.799122, -118.645773, -55.8, 820.73 1526589040, 0, 0, 33.799090, -118.645828, -60.5, 818.58 1526589540, 0, 0, 33.799857, -118.646675, -76.8, 674.69 1526590040, 0, 0, 33.800357, -118.648135, -100.1, 552.86 1526590540, 0, 0, 33.800223, -118.650230, -108.4, 390.14 1526591040, 0, 0, 33.799938, -118.652357, -109.2, 239.53 1526591540, 0, 0, 33.799663, -118.653338, 95.3, 109.58 1526592041, 0, 0, 33.799792, -118.653455, 77.0, 12.44 1526592541, 0, 0, 33.792437, -118.657958, 73.7, 12.33 rovNav(): 137: 21318 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018137vnta.txt 21318 in tList 21318 in {self->{rovT}} 21318 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526576145 & 1526575110 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 799.944339484515 rovGDCListRefs(): dStats->sample_range = 812.424881355971 rovGDCListRefs(): returning (1st elements): 1526571537 33.801962 -118.648795 5.3 2.581434184712 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 137 (looping to 137) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018137vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018137vntaedited.txt esecs, east, north, lat, lon, head, pres 1526572036, 0, 0, 33.799815, -118.647693, 97.2, 192.03 1526572536, 0, 0, 33.799719, -118.646993, 87.6, 380.50 1526573037, 0, 0, 33.799811, -118.646814, 100.2, 583.51 1526573537, 0, 0, 33.799743, -118.646645, 106.4, 744.90 1526574037, 0, 0, 33.799609, -118.646800, 169.6, 804.89 1526574537, 0, 0, 33.799484, -118.646599, 195.5, 806.69 1526575037, 0, 0, 33.798913, -118.646173, 150.9, 812.65 1526575537, 0, 0, 33.798611, -118.646001, 300.8, 822.34 1526576037, 0, 0, 33.799032, -118.646841, 299.5, 805.53 1526576537, 0, 0, 33.798746, -118.646233, 298.2, 815.35 1526577037, 0, 0, 33.798898, -118.646467, 299.1, 809.46 1526577538, 0, 0, 33.798882, -118.646419, 296.5, 810.65 1526578038, 0, 0, 33.798822, -118.646159, 302.1, 815.33 1526578538, 0, 0, 33.799080, -118.646657, 301.0, 805.84 1526579038, 0, 0, 33.798814, -118.646042, 302.5, 818.58 1526579538, 0, 0, 33.799144, -118.646699, 300.3, 805.49 1526580038, 0, 0, 33.798808, -118.645925, 300.9, 820.73 1526580538, 0, 0, 33.799223, -118.646753, 301.4, 805.91 1526581038, 0, 0, 33.798881, -118.646043, 302.1, 817.32 1526581538, 0, 0, 33.799142, -118.646465, 301.7, 807.38 1526582039, 0, 0, 33.799093, -118.646300, 298.2, 810.24 1526582539, 0, 0, 33.798982, -118.646043, 302.0, 815.35 1526583039, 0, 0, 33.799298, -118.646604, 298.2, 805.68 1526583539, 0, 0, 33.798987, -118.645992, 300.3, 817.78 1526584039, 0, 0, 33.799239, -118.646397, 301.8, 809.02 1526584539, 0, 0, 33.799350, -118.646593, 299.0, 805.47 1526585039, 0, 0, 33.799098, -118.646111, 299.6, 814.41 1526585539, 0, 0, 33.799076, -118.645990, 300.6, 817.27 1526586039, 0, 0, 33.799492, -118.646687, 296.8, 804.48 1526586539, 0, 0, 33.799377, -118.646552, 301.5, 806.25 1526587040, 0, 0, 33.799113, -118.645973, 304.2, 817.13 1526587540, 0, 0, 33.799292, -118.646276, 304.6, 810.97 1526588040, 0, 0, 33.799197, -118.646050, 303.8, 815.59 1526588540, 0, 0, 33.799144, -118.645770, 304.2, 820.73 1526589040, 0, 0, 33.799073, -118.645826, 299.5, 818.58 1526589540, 0, 0, 33.799872, -118.646670, 283.2, 674.69 1526590040, 0, 0, 33.800347, -118.648179, 259.9, 552.86 1526590540, 0, 0, 33.800185, -118.650282, 251.6, 390.14 1526591040, 0, 0, 33.799915, -118.652326, 250.8, 239.53 1526591540, 0, 0, 33.799677, -118.653374, 95.3, 109.58 1526592041, 0, 0, 33.800032, -118.651670, 77.0, 12.44 1526592541, 0, 0, 33.800092, -118.651713, 73.7, 12.33 rovNav(): 137: 21318 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018137vntaedited.txt 21318 in tList 21318 in {self->{rovT}} 21318 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1526576145 & 1526575110 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 799.944338870629 rovGDCListRefs(): dStats->sample_range = 812.424879194129 rovGDCListRefs(): returning (1st elements): 1526571537 33.800014 -118.647204 5.3 2.58143461354423 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 33.79919100 hash{lon} = -118.64650000 latMin = 27.799191 latMax = 39.799191 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 27.799191 AND 39.799191 AND Longitude BETWEEN -124.6465 AND -112.6465 Dive lat = 33.79919100, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -118.64650000 & lat = 33.79919100 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 = vnta4119rov_orig.wrl Making color lookup world... vframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/137/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. ar = 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/vnta4119lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2394 shipNav(): $#{$self->{shipLat}}[last] = 33.789979 Position subsampling set to 17 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 = 21319 makeTracks(): Looping through 2394 point of ship position data... makeTracks(): posSubsample = 17 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4119tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4119mergedCtdNav.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/17/2018 3:39:00 PM' AND '5/17/2018 9:34:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/17/2018 3:39:00 PM' AND '5/17/2018 9:34:15 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/17/2018 3:39:00 PM' AND '5/17/2018 9:34:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/17/2018 3:39:00 PM' AND '5/17/2018 9:34:15 PM')