Running bin\geopdvc.pl at Thu Mar 29 03:00:02 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4090 bin\geopdvc.pl: Getting Expedition object for diveno = 4090 and rname = vnta set_expd(): rov = vnta, diveno = 4090 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 = 4090 AND RovName = 'vnta' RS->Fields(0)->Value= 6185 RS->Fields(1)->Value= 1517252922 RS->Fields(2)->Value= 1517268583 RS->Fields(3)->Value= 1/29/2018 7:08:42 PM RS->Fields(4)->Value= 1/29/2018 11:29:43 PM set_expd(): $self->{EndDDD} = 029 set_expd(): $self->{StartEsecs} = 1517251722 set_expd(): $self->{EndEsecs} = 1517269783 set_expd(): $self->{EndDtg} = 1/29/2018 11:29:43 PM _readLogr(): Reading videologr data from 2018029datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1517251722 & 1517269783 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1517269784, self->{EndEsecs} = 1517269783 _readLogr(): #LOGHOST_SYSTEM_UTC = 1804 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1517251730 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1517269774 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1517251730 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1517269774 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1517251602, Refined EndEsecs = 1517269903 _readLogr(): Reading videologr data from 2018029datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1517251602 & 1517269903 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1517269904, self->{EndEsecs} = 1517269903 _readLogr(): #LOGHOST_SYSTEM_UTC = 1828 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1517251610 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1517269894 bin\geopdvc.pl: expdid = 6185 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 = 029 (looping to 029) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018029vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018029vnta.txt esecs, east, north, lat, lon, head, pres 1517253422, 0, 0, 36.769030, -121.922495, -80.9, 142.56 1517253923, 0, 0, 36.768922, -121.923158, -105.5, 279.54 1517254424, 0, 0, 36.768910, -121.923302, -90.5, 410.05 1517254924, 0, 0, 36.768917, -121.923360, 81.4, 410.02 1517255425, 0, 0, 36.768915, -121.923310, 87.9, 409.64 1517255926, 0, 0, 36.768915, -121.923323, 86.8, 409.91 1517256427, 0, 0, 36.768907, -121.923340, 80.6, 409.85 1517256928, 0, 0, 36.768890, -121.922350, 83.6, 409.47 1517257429, 0, 0, 36.768842, -121.922415, -75.7, 409.24 1517257930, 0, 0, 36.768923, -121.923190, -73.3, 409.38 1517258431, 0, 0, 36.768905, -121.922680, 4.1, 409.67 1517258932, 0, 0, 36.768922, -121.923015, 2.5, 409.56 1517259433, 0, 0, 36.768897, -121.923340, -6.4, 409.42 1517259933, 0, 0, 36.769742, -121.923155, -4.4, 409.21 1517260434, 0, 0, 36.769142, -121.923155, 87.3, 409.37 1517260935, 0, 0, 36.768968, -121.923183, 87.0, 408.98 1517261436, 0, 0, 36.768963, -121.923165, 85.6, 408.91 1517261937, 0, 0, 36.768952, -121.923195, -0.6, 408.87 1517262438, 0, 0, 36.769158, -121.923117, 178.7, 409.29 1517262939, 0, 0, 36.769158, -121.923123, 93.3, 409.20 1517263440, 0, 0, 36.769160, -121.923345, 135.3, 408.97 1517263940, 0, 0, 36.769185, -121.923145, -3.7, 410.10 1517264441, 0, 0, 36.768958, -121.923143, 0.1, 409.93 1517264942, 0, 0, 36.768960, -121.923142, -4.4, 409.84 1517265443, 0, 0, 36.769050, -121.923148, -5.1, 409.92 1517265944, 0, 0, 36.768990, -121.923133, 177.1, 409.81 1517266445, 0, 0, 36.768958, -121.923142, -5.2, 407.85 1517266946, 0, 0, 36.769335, -121.923407, -47.0, 397.83 1517267446, 0, 0, 36.770033, -121.923972, -45.9, 222.08 1517267947, 0, 0, 36.770098, -121.924815, -44.7, 54.32 1517268448, 0, 0, 36.769877, -121.923967, -48.2, 11.15 rovNav(): 029: 15633 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018029vnta.txt 15633 in tList 15633 in {self->{rovT}} 15633 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1517254035 & 1517253165 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 405.860852411547 rovGDCListRefs(): dStats->sample_range = 404.904728026493 rovGDCListRefs(): returning (1st elements): 1517252922 36.769700 -121.919068 -32.0 2.58076812056092 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 029 (looping to 029) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018029vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018029vntaedited.txt esecs, east, north, lat, lon, head, pres 1517253422, 0, 0, 36.769031, -121.922491, 279.1, 142.56 1517253923, 0, 0, 36.768927, -121.923159, 254.5, 279.54 1517254424, 0, 0, 36.768902, -121.923305, 269.5, 410.05 1517254924, 0, 0, 36.768920, -121.923361, 81.4, 410.02 1517255425, 0, 0, 36.768912, -121.923305, 87.9, 409.64 1517255926, 0, 0, 36.768916, -121.923323, 86.8, 409.91 1517256427, 0, 0, 36.768907, -121.923335, 80.6, 409.85 1517256928, 0, 0, 36.768889, -121.922333, 83.6, 409.47 1517257429, 0, 0, 36.768843, -121.922412, 284.3, 409.24 1517257930, 0, 0, 36.768919, -121.923183, 286.7, 409.38 1517258431, 0, 0, 36.768905, -121.922677, 4.1, 409.67 1517258932, 0, 0, 36.768920, -121.923018, 2.5, 409.56 1517259433, 0, 0, 36.768899, -121.923332, 353.6, 409.42 1517259933, 0, 0, 36.769739, -121.923161, 355.6, 409.21 1517260434, 0, 0, 36.769140, -121.923161, 87.3, 409.37 1517260935, 0, 0, 36.768965, -121.923182, 87.0, 408.98 1517261436, 0, 0, 36.768968, -121.923164, 85.6, 408.91 1517261937, 0, 0, 36.768955, -121.923192, 359.4, 408.87 1517262438, 0, 0, 36.769159, -121.923128, 178.7, 409.29 1517262939, 0, 0, 36.769157, -121.923124, 93.3, 409.20 1517263440, 0, 0, 36.769141, -121.923322, 135.3, 408.97 1517263940, 0, 0, 36.769191, -121.923148, 356.3, 410.10 1517264441, 0, 0, 36.768958, -121.923149, 0.1, 409.93 1517264942, 0, 0, 36.768965, -121.923142, 355.6, 409.84 1517265443, 0, 0, 36.769057, -121.923147, 354.9, 409.92 1517265944, 0, 0, 36.768989, -121.923133, 177.1, 409.81 1517266445, 0, 0, 36.768964, -121.923154, 354.8, 407.85 1517266946, 0, 0, 36.769352, -121.923412, 313.0, 397.83 1517267446, 0, 0, 36.769919, -121.924008, 314.1, 222.08 1517267947, 0, 0, 36.769931, -121.923963, 315.3, 54.32 1517268448, 0, 0, 36.769853, -121.923986, 311.8, 11.15 rovNav(): 029: 15633 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018029vntaedited.txt 15633 in tList 15633 in {self->{rovT}} 15633 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1517254035 & 1517253165 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 405.860852483358 rovGDCListRefs(): dStats->sample_range = 404.904727086857 rovGDCListRefs(): returning (1st elements): 1517252922 36.769216 -121.922848 328.0 2.58076823107007 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.76896800 hash{lon} = -121.92316300 latMin = 30.768968 latMax = 42.768968 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.768968 AND 42.768968 AND Longitude BETWEEN -127.923163 AND -115.923163 Dive lat = 36.76896800, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.92316300 & lat = 36.76896800 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4090rov_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/vnta4090lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no matcframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/029/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. h for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1828 shipNav(): $#{$self->{shipLat}}[last] = 36.776924 Position subsampling set to 13 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 = 15634 makeTracks(): Looping through 1828 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4090tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4090mergedCtdNav.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 '1/29/2018 7:08:42 PM' AND '1/29/2018 11:29:43 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '1/29/2018 7:08:42 PM' AND '1/29/2018 11:29:43 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 '1/29/2018 7:08:42 PM' AND '1/29/2018 11:29:43 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '1/29/2018 7:08:42 PM' AND '1/29/2018 11:29:43 PM')