Running bin\geopdvc.pl at Mon Apr 9 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4095 bin\geopdvc.pl: Getting Expedition object for diveno = 4095 and rname = vnta set_expd(): rov = vnta, diveno = 4095 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 = 4095 AND RovName = 'vnta' RS->Fields(0)->Value= 6205 RS->Fields(1)->Value= 1518195708 RS->Fields(2)->Value= 1518214691 RS->Fields(3)->Value= 2/9/2018 5:01:48 PM RS->Fields(4)->Value= 2/9/2018 10:18:11 PM set_expd(): $self->{EndDDD} = 040 set_expd(): $self->{StartEsecs} = 1518194508 set_expd(): $self->{EndEsecs} = 1518215891 set_expd(): $self->{EndDtg} = 2/9/2018 10:18:11 PM _readLogr(): Reading videologr data from 2018040datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1518194508 & 1518215891 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1518215898, self->{EndEsecs} = 1518215891 _readLogr(): #LOGHOST_SYSTEM_UTC = 2137 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1518194514 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1518215888 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1518194514 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1518215888 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1518194388, Refined EndEsecs = 1518216011 _readLogr(): Reading videologr data from 2018040datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1518194388 & 1518216011 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1518216018, self->{EndEsecs} = 1518216011 _readLogr(): #LOGHOST_SYSTEM_UTC = 2161 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1518194394 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1518216008 bin\geopdvc.pl: expdid = 6205 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 = 040 (looping to 040) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018040vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018040vnta.txt esecs, east, north, lat, lon, head, pres 1518197191, 0, 0, 36.699725, -122.049895, 166.0, 57.92 1518197692, 0, 0, 36.699827, -122.049740, 106.9, 214.25 1518198193, 0, 0, 36.699822, -122.049755, 131.3, 407.27 1518198694, 0, 0, 36.699795, -122.049788, 149.2, 601.10 1518199195, 0, 0, 36.699542, -122.049987, 168.8, 615.36 1518199695, 0, 0, 36.699323, -122.050262, 157.2, 647.79 1518200196, 0, 0, 36.699138, -122.050245, 133.0, 688.35 1518200697, 0, 0, 36.698508, -122.050192, 143.1, 703.11 1518201198, 0, 0, 36.698018, -122.050200, 160.4, 704.05 1518201699, 0, 0, 36.697522, -122.050193, -175.9, 704.62 1518202199, 0, 0, 36.696815, -122.050318, 165.3, 696.93 1518202700, 0, 0, 36.696218, -122.050487, 171.3, 692.19 1518203201, 0, 0, 36.695508, -122.050747, 170.3, 673.55 1518203702, 0, 0, 36.694998, -122.050825, 141.0, 630.04 1518204203, 0, 0, 36.695710, -122.050802, 2.9, 605.17 1518204704, 0, 0, 36.696553, -122.050702, 46.0, 579.04 1518205205, 0, 0, 36.697527, -122.050485, 3.4, 555.09 1518205706, 0, 0, 36.697405, -122.050260, 60.2, 550.91 1518206206, 0, 0, 36.697300, -122.050167, 18.3, 559.23 1518206707, 0, 0, 36.697522, -122.049942, 1.4, 528.27 1518207208, 0, 0, 36.697525, -122.049865, 1.1, 510.56 1518207709, 0, 0, 36.697732, -122.049940, -1.4, 493.53 1518208210, 0, 0, 36.698083, -122.049868, -6.5, 465.22 1518208711, 0, 0, 36.698525, -122.049900, -7.3, 438.48 1518209212, 0, 0, 36.698300, -122.049893, -11.3, 434.22 1518209712, 0, 0, 36.698775, -122.050057, -8.1, 447.45 1518210213, 0, 0, 36.698437, -122.050672, -122.2, 445.70 1518210714, 0, 0, 36.697385, -122.051825, -126.7, 421.58 1518211215, 0, 0, 36.696382, -122.053218, -123.7, 403.36 1518211716, 0, 0, 36.696047, -122.053598, -87.1, 398.95 1518212216, 0, 0, 36.696155, -122.055183, -114.3, 360.55 1518212717, 0, 0, 36.696283, -122.055587, 35.2, 349.34 1518213218, 0, 0, 36.696465, -122.056005, -66.4, 202.21 1518213719, 0, 0, 36.697020, -122.056397, -10.3, 39.09 1518214220, 0, 0, 36.697710, -122.057958, -11.7, 21.64 rovNav(): 040: 17969 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018040vnta.txt 17969 in tList 17969 in {self->{rovT}} 17969 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1518209775 & 1518200820 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 497.35876002211 rovGDCListRefs(): dStats->sample_range = 698.273019271437 rovGDCListRefs(): returning (1st elements): 1518195711 36.802995 -121.786097 119.0 2.58076051717165 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 040 (looping to 040) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018040vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018040vntaedited.txt esecs, east, north, lat, lon, head, pres 1518197191, 0, 0, 36.699714, -122.049902, 166.0, 57.92 1518197692, 0, 0, 36.699819, -122.049746, 106.9, 214.25 1518198193, 0, 0, 36.699826, -122.049758, 131.3, 407.27 1518198694, 0, 0, 36.699786, -122.049816, 149.2, 601.10 1518199195, 0, 0, 36.699535, -122.049989, 168.8, 615.36 1518199695, 0, 0, 36.699327, -122.050261, 157.2, 647.79 1518200196, 0, 0, 36.699133, -122.050239, 133.0, 688.35 1518200697, 0, 0, 36.698503, -122.050183, 143.1, 703.11 1518201198, 0, 0, 36.698003, -122.050185, 160.4, 704.05 1518201699, 0, 0, 36.697499, -122.050206, 184.1, 704.62 1518202199, 0, 0, 36.696819, -122.050320, 165.3, 696.93 1518202700, 0, 0, 36.696204, -122.050495, 171.3, 692.19 1518203201, 0, 0, 36.695499, -122.050760, 170.3, 673.55 1518203702, 0, 0, 36.695017, -122.050822, 141.0, 630.04 1518204203, 0, 0, 36.695702, -122.050803, 2.9, 605.17 1518204704, 0, 0, 36.696543, -122.050703, 46.0, 579.04 1518205205, 0, 0, 36.697519, -122.050489, 3.4, 555.09 1518205706, 0, 0, 36.697411, -122.050274, 60.2, 550.91 1518206206, 0, 0, 36.697306, -122.050167, 18.3, 559.23 1518206707, 0, 0, 36.697523, -122.049931, 1.4, 528.27 1518207208, 0, 0, 36.697532, -122.049882, 1.1, 510.56 1518207709, 0, 0, 36.697743, -122.049946, 358.6, 493.53 1518208210, 0, 0, 36.698085, -122.049861, 353.5, 465.22 1518208711, 0, 0, 36.698523, -122.049901, 352.7, 438.48 1518209212, 0, 0, 36.698302, -122.049902, 348.7, 434.22 1518209712, 0, 0, 36.698778, -122.050064, 351.9, 447.45 1518210213, 0, 0, 36.698434, -122.050680, 237.8, 445.70 1518210714, 0, 0, 36.697393, -122.051818, 233.3, 421.58 1518211215, 0, 0, 36.696373, -122.053218, 236.3, 403.36 1518211716, 0, 0, 36.696030, -122.053597, 272.9, 398.95 1518212216, 0, 0, 36.696145, -122.055147, 245.7, 360.55 1518212717, 0, 0, 36.696269, -122.055575, 35.2, 349.34 1518213218, 0, 0, 36.696448, -122.056072, 293.6, 202.21 1518213719, 0, 0, 36.696964, -122.056457, 349.7, 39.09 1518214220, 0, 0, 36.697740, -122.057931, 348.3, 21.64 rovNav(): 040: 17969 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018040vntaedited.txt 17969 in tList 17969 in {self->{rovT}} 17969 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1518209775 & 1518200820 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 497.358760505744 rovGDCListRefs(): dStats->sample_range = 698.272995659107 rovGDCListRefs(): returning (1st elements): 1518195711 36.699560 -122.050254 119.0 2.58078412950108 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69756000 hash{lon} = -122.05025400 latMin = 30.69756 latMax = 42.69756 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/040/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. HERE Latitude BETWEEN 30.69756 AND 42.69756 AND Longitude BETWEEN -128.050254 AND -116.050254 Dive lat = 36.69756000, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05025400 & lat = 36.69756000 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4095rov_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/vnta4095lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2161 shipNav(): $#{$self->{shipLat}}[last] = 36.713384 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 = 17970 makeTracks(): Looping through 2161 point of ship position data... makeTracks(): posSubsample = 14 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4095tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4095mergedCtdNav.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 '2/9/2018 5:01:48 PM' AND '2/9/2018 10:18:11 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/9/2018 5:01:48 PM' AND '2/9/2018 10:18:11 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 '2/9/2018 5:01:48 PM' AND '2/9/2018 10:18:11 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/9/2018 5:01:48 PM' AND '2/9/2018 10:18:11 PM')