Running bin\geopdvc.pl at Fri Jul 20 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4124 bin\geopdvc.pl: Getting Expedition object for diveno = 4124 and rname = vnta set_expd(): rov = vnta, diveno = 4124 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 = 4124 AND RovName = 'vnta' RS->Fields(0)->Value= 6244 RS->Fields(1)->Value= 1527004935 RS->Fields(2)->Value= 1527025935 RS->Fields(3)->Value= 5/22/2018 4:02:15 PM RS->Fields(4)->Value= 5/22/2018 9:52:15 PM set_expd(): $self->{EndDDD} = 142 set_expd(): $self->{StartEsecs} = 1527003735 set_expd(): $self->{EndEsecs} = 1527027135 set_expd(): $self->{EndDtg} = 5/22/2018 9:52:15 PM _readLogr(): Reading videologr data from 2018142datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1527003735 & 1527027135 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1527027142, self->{EndEsecs} = 1527027135 _readLogr(): #LOGHOST_SYSTEM_UTC = 2339 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1527003742 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1527027132 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1527003742 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1527027132 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1527003615, Refined EndEsecs = 1527027255 _readLogr(): Reading videologr data from 2018142datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1527003615 & 1527027255 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1527027262, self->{EndEsecs} = 1527027255 _readLogr(): #LOGHOST_SYSTEM_UTC = 2363 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1527003622 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1527027252 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 = 142 (looping to 142) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018142vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018142vnta.txt esecs, east, north, lat, lon, head, pres 1527005431, 0, 0, 33.357612, -118.141035, -95.4, 224.59 1527005931, 0, 0, 33.357655, -118.141123, -89.4, 468.00 1527006431, 0, 0, 33.357628, -118.141015, -75.5, 687.02 1527006931, 0, 0, 33.357567, -118.141060, -158.2, 680.10 1527007431, 0, 0, 33.357547, -118.141282, -77.4, 760.89 1527007931, 0, 0, 33.357637, -118.141527, -94.6, 771.13 1527008431, 0, 0, 33.357792, -118.141495, -1.0, 770.43 1527008931, 0, 0, 33.358315, -118.141780, -32.8, 747.22 1527009432, 0, 0, 33.358823, -118.142222, -34.3, 714.41 1527009932, 0, 0, 33.358730, -118.141897, -69.7, 723.36 1527010432, 0, 0, 33.358817, -118.142212, -33.2, 714.68 1527010932, 0, 0, 33.358733, -118.142190, -34.1, 715.75 1527011432, 0, 0, 33.358402, -118.141882, -32.3, 740.80 1527011932, 0, 0, 33.358297, -118.141860, -31.9, 745.89 1527012432, 0, 0, 33.358643, -118.142190, -34.6, 718.41 1527012932, 0, 0, 33.358427, -118.142040, -32.8, 734.42 1527013432, 0, 0, 33.358492, -118.142160, -33.4, 726.59 1527013932, 0, 0, 33.358487, -118.142222, -31.9, 723.73 1527014433, 0, 0, 33.358665, -118.142328, -33.2, 714.19 1527014933, 0, 0, 33.358300, -118.142083, -32.9, 737.20 1527015433, 0, 0, 33.358458, -118.142223, -31.8, 725.21 1527015933, 0, 0, 33.358453, -118.142287, -32.9, 723.21 1527016433, 0, 0, 33.358127, -118.142012, -80.7, 744.50 1527016933, 0, 0, 33.358143, -118.142510, -80.3, 716.96 1527017433, 0, 0, 33.358163, -118.142105, -81.7, 738.72 1527017933, 0, 0, 33.358192, -118.142608, -80.4, 711.83 1527018433, 0, 0, 33.358257, -118.142012, -80.3, 742.33 1527018934, 0, 0, 33.358278, -118.142555, -81.2, 715.19 1527019434, 0, 0, 33.358288, -118.142323, -80.4, 727.34 1527019934, 0, 0, 33.358320, -118.142285, -82.0, 728.32 1527020434, 0, 0, 33.358383, -118.142498, -82.1, 715.21 1527020934, 0, 0, 33.358415, -118.142633, -82.7, 709.62 1527021434, 0, 0, 33.358483, -118.142560, -83.2, 711.05 1527021934, 0, 0, 33.358598, -118.142527, -81.8, 710.85 1527022434, 0, 0, 33.358325, -118.142185, -35.3, 734.01 1527022934, 0, 0, 33.358157, -118.142362, -81.9, 726.09 1527023435, 0, 0, 33.358138, -118.142175, -82.0, 736.38 1527023935, 0, 0, 33.358103, -118.142475, -80.6, 718.77 1527024435, 0, 0, 33.358273, -118.142562, -82.7, 541.30 1527024935, 0, 0, 33.358453, -118.142608, -82.7, 323.58 1527025435, 0, 0, 33.358662, -118.143423, -85.4, 154.93 rovNav(): 142: 20997 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018142vnta.txt 20997 in tList 20997 in {self->{rovT}} 20997 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1527020685 & 1527019380 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX rovGDCListRefs(): dMedian = 713.781380976034 rovGDCListRefs(): dStats->sample_range = 763.614026361843 rovGDCListRefs(): returning (1st elements): 1527004932 33.358070 -118.140563 -66.3 2.68082061086884 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 142 (looping to 142) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018142vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018142vntaedited.txt esecs, east, north, lat, lon, head, pres 1527005431, 0, 0, 33.357603, -118.141023, 264.6, 224.59 1527005931, 0, 0, 33.357666, -118.141119, 270.6, 468.00 1527006431, 0, 0, 33.357624, -118.141022, 284.5, 687.02 1527006931, 0, 0, 33.357580, -118.141067, 201.8, 680.10 1527007431, 0, 0, 33.357542, -118.141262, 282.6, 760.89 1527007931, 0, 0, 33.357621, -118.141535, 265.4, 771.13 1527008431, 0, 0, 33.357791, -118.141524, 359.0, 770.43 1527008931, 0, 0, 33.358323, -118.141792, 327.2, 747.22 1527009432, 0, 0, 33.358832, -118.142216, 325.7, 714.41 1527009932, 0, 0, 33.358728, -118.141907, 290.3, 723.36 1527010432, 0, 0, 33.358820, -118.142210, 326.8, 714.68 1527010932, 0, 0, 33.358739, -118.142169, 325.9, 715.75 1527011432, 0, 0, 33.358391, -118.141891, 327.7, 740.80 1527011932, 0, 0, 33.358299, -118.141868, 328.1, 745.89 1527012432, 0, 0, 33.358643, -118.142184, 325.4, 718.41 1527012932, 0, 0, 33.358423, -118.142044, 327.2, 734.42 1527013432, 0, 0, 33.358497, -118.142152, 326.6, 726.59 1527013932, 0, 0, 33.358488, -118.142216, 328.1, 723.73 1527014433, 0, 0, 33.358654, -118.142335, 326.8, 714.19 1527014933, 0, 0, 33.358309, -118.142086, 327.1, 737.20 1527015433, 0, 0, 33.358452, -118.142248, 328.2, 725.21 1527015933, 0, 0, 33.358467, -118.142286, 327.1, 723.21 1527016433, 0, 0, 33.358125, -118.142013, 279.3, 744.50 1527016933, 0, 0, 33.358152, -118.142514, 279.7, 716.96 1527017433, 0, 0, 33.358153, -118.142110, 278.3, 738.72 1527017933, 0, 0, 33.358223, -118.142598, 279.6, 711.83 1527018433, 0, 0, 33.358227, -118.142044, 279.7, 742.33 1527018934, 0, 0, 33.358295, -118.142534, 278.8, 715.19 1527019434, 0, 0, 33.358293, -118.142308, 279.6, 727.34 1527019934, 0, 0, 33.358328, -118.142281, 278.0, 728.32 1527020434, 0, 0, 33.358389, -118.142488, 277.9, 715.21 1527020934, 0, 0, 33.358436, -118.142616, 277.3, 709.62 1527021434, 0, 0, 33.358501, -118.142547, 276.8, 711.05 1527021934, 0, 0, 33.358608, -118.142503, 278.2, 710.85 1527022434, 0, 0, 33.358337, -118.142176, 324.7, 734.01 1527022934, 0, 0, 33.358145, -118.142352, 278.1, 726.09 1527023435, 0, 0, 33.358131, -118.142166, 278.0, 736.38 1527023935, 0, 0, 33.358107, -118.142482, 279.4, 718.77 1527024435, 0, 0, 33.358242, -118.142564, 277.3, 541.30 1527024935, 0, 0, 33.358474, -118.142609, 277.3, 323.58 1527025435, 0, 0, 33.358684, -118.143432, 274.6, 154.93 rovNav(): 142: 20997 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018142vntaedited.txt 20997 in tList 20997 in {self->{rovT}} 20997 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1527020685 & 1527019380 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX rovGDCListRefs(): dMedian = 713.781380613221 rovGDCListRefs(): dStats->sample_range = 763.614025582851 rovGDCListRefs(): returning (1st elements): 1527004932 33.358313 -118.140802 293.7 2.68082055567728 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 33.35831100 hash{lon} = -118.14218700 latMin = 27.358311 latMax = 39.358311 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 27.358311 AND 39.358311 AND Longitude BETWEEN -124.142187 AND -112.142187 Dive lat = 33.35831100, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -118.14218700 & lat = 33.35831100 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 = vnta4124rov_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/vnta4124lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsnframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/142/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. shipNav(): $#{$self->{shipLat}} = 2363 shipNav(): $#{$self->{shipLat}}[last] = 33.399606 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 = 20998 makeTracks(): Looping through 2363 point of ship position data... makeTracks(): posSubsample = 17 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4124tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4124mergedCtdNav.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/22/2018 4:02:15 PM' AND '5/22/2018 9:52:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/22/2018 4:02:15 PM' AND '5/22/2018 9:52: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/22/2018 4:02:15 PM' AND '5/22/2018 9:52:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/22/2018 4:02:15 PM' AND '5/22/2018 9:52:15 PM')