Running bin\geopdvc.pl at Tue Aug 7 03:01:10 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4127 bin\geopdvc.pl: Getting Expedition object for diveno = 4127 and rname = vnta set_expd(): rov = vnta, diveno = 4127 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 = 4127 AND RovName = 'vnta' RS->Fields(0)->Value= 6297 RS->Fields(1)->Value= 1529426044 RS->Fields(2)->Value= 1529443558 RS->Fields(3)->Value= 6/19/2018 4:34:04 PM RS->Fields(4)->Value= 6/19/2018 9:25:58 PM set_expd(): $self->{EndDDD} = 170 set_expd(): $self->{StartEsecs} = 1529424844 set_expd(): $self->{EndEsecs} = 1529444758 set_expd(): $self->{EndDtg} = 6/19/2018 9:25:58 PM _readLogr(): Reading videologr data from 2018170datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1529424844 & 1529444758 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1529444766, self->{EndEsecs} = 1529444758 _readLogr(): #LOGHOST_SYSTEM_UTC = 1991 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1529424846 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1529444756 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1529424846 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1529444756 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1529424724, Refined EndEsecs = 1529444878 _readLogr(): Reading videologr data from 2018170datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1529424724 & 1529444878 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1529444886, self->{EndEsecs} = 1529444878 _readLogr(): #LOGHOST_SYSTEM_UTC = 2015 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1529424726 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1529444876 bin\geopdvc.pl: expdid = 6297 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 = 170 (looping to 170) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018170vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018170vnta.txt esecs, east, north, lat, lon, head, pres 1529426545, 0, 0, 36.744108, -122.102073, 48.6, 164.41 1529427045, 0, 0, 36.744295, -122.102353, -94.3, 338.04 1529427545, 0, 0, 36.744072, -122.102742, -102.6, 425.45 1529428045, 0, 0, 36.743547, -122.103718, -117.3, 423.30 1529428545, 0, 0, 36.743355, -122.103742, -103.1, 419.09 1529429045, 0, 0, 36.742795, -122.104723, -69.5, 437.57 1529429545, 0, 0, 36.742612, -122.105553, -81.3, 435.61 1529430045, 0, 0, 36.742552, -122.106300, -59.6, 450.18 1529430546, 0, 0, 36.742435, -122.106672, -78.5, 447.35 1529431046, 0, 0, 36.742425, -122.107442, -61.0, 443.79 1529431546, 0, 0, 36.742590, -122.107325, 49.9, 442.53 1529432046, 0, 0, 36.743288, -122.106030, 39.0, 449.83 1529432546, 0, 0, 36.744228, -122.104875, 47.9, 454.58 1529433046, 0, 0, 36.745140, -122.103725, 10.8, 459.97 1529433546, 0, 0, 36.745297, -122.103077, 31.7, 424.31 1529434046, 0, 0, 36.745735, -122.103018, -69.7, 444.28 1529434546, 0, 0, 36.745635, -122.103475, -37.1, 460.92 1529435046, 0, 0, 36.745952, -122.103797, -22.1, 467.29 1529435547, 0, 0, 36.746598, -122.103990, -52.5, 477.06 1529436047, 0, 0, 36.746640, -122.104560, -88.0, 505.30 1529436547, 0, 0, 36.746873, -122.105217, -46.2, 501.25 1529437047, 0, 0, 36.747093, -122.106057, -109.3, 502.95 1529437547, 0, 0, 36.746865, -122.107185, -74.9, 526.10 1529438047, 0, 0, 36.746822, -122.106840, 144.9, 519.20 1529438547, 0, 0, 36.747078, -122.106835, -37.6, 515.04 1529439047, 0, 0, 36.746895, -122.106603, -88.7, 509.57 1529439547, 0, 0, 36.748620, -122.106083, -6.1, 444.76 1529440048, 0, 0, 36.749095, -122.106230, -48.4, 438.96 1529440548, 0, 0, 36.747080, -122.107422, -147.4, 438.64 1529441048, 0, 0, 36.747098, -122.107063, -154.6, 346.74 1529441548, 0, 0, 36.746785, -122.106730, -109.3, 276.29 1529442048, 0, 0, 36.746735, -122.106710, -71.1, 208.40 1529442548, 0, 0, 36.746593, -122.106063, -72.1, 111.41 1529443048, 0, 0, 36.746322, -122.105758, -40.9, 50.99 1529443548, 0, 0, 36.744643, -122.105517, -44.2, 3.54 rovNav(): 170: 17508 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018170vnta.txt 17508 in tList 17508 in {self->{rovT}} 17508 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1529428530 & 1529435685 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 438.966347442438 rovGDCListRefs(): dStats->sample_range = 520.628038889646 rovGDCListRefs(): returning (1st elements): 1529426046 36.746105 -122.108895 66.1 2.680033372279 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 170 (looping to 170) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018170vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018170vntaedited.txt esecs, east, north, lat, lon, head, pres 1529426545, 0, 0, 36.744106, -122.102076, 48.6, 164.41 1529427045, 0, 0, 36.744296, -122.102341, 265.7, 338.04 1529427545, 0, 0, 36.744066, -122.102751, 257.4, 425.45 1529428045, 0, 0, 36.743551, -122.103706, 242.7, 423.30 1529428545, 0, 0, 36.743343, -122.103755, 256.9, 419.09 1529429045, 0, 0, 36.742797, -122.104755, 290.5, 437.57 1529429545, 0, 0, 36.742600, -122.105564, 278.7, 435.61 1529430045, 0, 0, 36.742551, -122.106316, 300.4, 450.18 1529430546, 0, 0, 36.742424, -122.106690, 281.5, 447.35 1529431046, 0, 0, 36.742436, -122.107492, 299.0, 443.79 1529431546, 0, 0, 36.742584, -122.107318, 49.9, 442.53 1529432046, 0, 0, 36.743286, -122.106036, 39.0, 449.83 1529432546, 0, 0, 36.744263, -122.104880, 47.9, 454.58 1529433046, 0, 0, 36.745129, -122.103752, 10.8, 459.97 1529433546, 0, 0, 36.745278, -122.103084, 31.7, 424.31 1529434046, 0, 0, 36.745729, -122.103034, 290.3, 444.28 1529434546, 0, 0, 36.745647, -122.103496, 322.9, 460.92 1529435046, 0, 0, 36.745958, -122.103770, 337.9, 467.29 1529435547, 0, 0, 36.746628, -122.103971, 307.5, 477.06 1529436047, 0, 0, 36.746648, -122.104615, 272.0, 505.30 1529436547, 0, 0, 36.746874, -122.105194, 313.8, 501.25 1529437047, 0, 0, 36.747149, -122.106042, 250.7, 502.95 1529437547, 0, 0, 36.746900, -122.107173, 285.1, 526.10 1529438047, 0, 0, 36.746707, -122.106972, 144.9, 519.20 1529438547, 0, 0, 36.747113, -122.106855, 322.4, 515.04 1529439047, 0, 0, 36.746876, -122.106568, 271.3, 509.57 1529439547, 0, 0, 36.748638, -122.106180, 353.9, 444.76 1529440048, 0, 0, 36.749108, -122.106281, 311.6, 438.96 1529440548, 0, 0, 36.747038, -122.107440, 212.6, 438.64 1529441048, 0, 0, 36.747288, -122.107142, 205.4, 346.74 1529441548, 0, 0, 36.746784, -122.106720, 250.7, 276.29 1529442048, 0, 0, 36.746773, -122.106660, 288.9, 208.40 1529442548, 0, 0, 36.746600, -122.106079, 287.9, 111.41 1529443048, 0, 0, 36.746183, -122.105836, 319.1, 50.99 1529443548, 0, 0, 36.744769, -122.105482, 315.8, 3.54 rovNav(): 170: 17508 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018170vntaedited.txt 17508 in tList 17508 in {self->{rovT}} 17508 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1529428530 & 1529435685 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 438.96634697656 rovGDCListRefs(): dStats->sample_range = 520.628038110107 rovGDCListRefs(): returning (1st elements): 1529426046 36.744258 -122.101831 66.1 2.68003381010489 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74573700 hash{lon} = -122.10581100 latMin = 30.745737 latMax = 42.745737 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.745737 AND 42.745737 AND Longitude BETWEEN -128.105811 AND -116.105811 Dive lat = 36.74573700, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.10581100 & lat = 36.74573700 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4127rov_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, coframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/170/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. lor = 1 1 0 val = 10, color = 0 1 0 val = 15, color = 1 0 0 World = geo2018/vnta/vnta4127lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2015 shipNav(): $#{$self->{shipLat}}[last] = 36.748027 Position subsampling set to 14 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 = 17509 makeTracks(): Looping through 2015 point of ship position data... makeTracks(): posSubsample = 14 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4127tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4127mergedCtdNav.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 '6/19/2018 4:34:04 PM' AND '6/19/2018 9:25:58 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/19/2018 4:34:04 PM' AND '6/19/2018 9:25:58 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 '6/19/2018 4:34:04 PM' AND '6/19/2018 9:25:58 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/19/2018 4:34:04 PM' AND '6/19/2018 9:25:58 PM')