Running bin\geopdvc.pl at Tue Aug 7 03:18:08 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4134 bin\geopdvc.pl: Getting Expedition object for diveno = 4134 and rname = vnta set_expd(): rov = vnta, diveno = 4134 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 = 4134 AND RovName = 'vnta' RS->Fields(0)->Value= 6345 RS->Fields(1)->Value= 1532537664 RS->Fields(2)->Value= 1532547892 RS->Fields(3)->Value= 7/25/2018 4:54:24 PM RS->Fields(4)->Value= 7/25/2018 7:44:52 PM set_expd(): $self->{EndDDD} = 206 set_expd(): $self->{StartEsecs} = 1532536464 set_expd(): $self->{EndEsecs} = 1532549092 set_expd(): $self->{EndDtg} = 7/25/2018 7:44:52 PM _readLogr(): Reading videologr data from 2018206datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1532536464 & 1532549092 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1532549098, self->{EndEsecs} = 1532549092 _readLogr(): #LOGHOST_SYSTEM_UTC = 1262 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1532536468 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1532549088 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1532536468 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1532549088 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1532536344, Refined EndEsecs = 1532549212 _readLogr(): Reading videologr data from 2018206datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1532536344 & 1532549212 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1532549218, self->{EndEsecs} = 1532549212 _readLogr(): #LOGHOST_SYSTEM_UTC = 1286 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1532536348 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1532549208 bin\geopdvc.pl: expdid = 6345 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 = 206 (looping to 206) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018206vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018206vnta.txt esecs, east, north, lat, lon, head, pres 1532538164, 0, 0, 36.752947, -122.047173, -44.5, 189.89 1532538664, 0, 0, 36.753190, -122.047698, -16.7, 414.10 1532539164, 0, 0, 36.753792, -122.048028, -10.3, 628.24 1532539664, 0, 0, 36.753468, -122.048110, -66.1, 716.69 1532540164, 0, 0, 36.753803, -122.048243, -82.0, 721.97 1532540664, 0, 0, 36.753878, -122.048245, -88.2, 721.45 1532541164, 0, 0, 36.753605, -122.048198, -89.6, 719.37 1532541664, 0, 0, 36.753743, -122.048272, -72.7, 721.85 1532542165, 0, 0, 36.753608, -122.048165, -88.0, 713.64 1532542665, 0, 0, 36.753688, -122.048995, -89.1, 693.01 1532543165, 0, 0, 36.752635, -122.048557, -55.5, 715.18 1532543665, 0, 0, 36.752517, -122.048642, -53.7, 715.50 1532544165, 0, 0, 36.752562, -122.048437, -76.2, 718.86 1532544665, 0, 0, 36.752542, -122.048457, -76.2, 717.95 1532545165, 0, 0, 36.752532, -122.048523, -74.5, 719.24 1532545665, 0, 0, 36.752680, -122.048673, -90.1, 662.10 1532546165, 0, 0, 36.752437, -122.048437, -93.2, 441.76 1532546666, 0, 0, 36.752502, -122.048495, -93.9, 249.84 1532547166, 0, 0, 36.752148, -122.047320, -40.7, 87.02 1532547666, 0, 0, 36.751342, -122.046498, -41.3, 10.05 rovNav(): 206: 10225 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018206vnta.txt 10225 in tList 10225 in {self->{rovT}} 10225 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1532544120 & 1532542230 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 706.27125934013 rovGDCListRefs(): dStats->sample_range = 723.146828247675 rovGDCListRefs(): returning (1st elements): 1532537665 36.752827 -122.048632 -47.3 2.68003177877833 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 206 (looping to 206) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018206vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018206vntaedited.txt esecs, east, north, lat, lon, head, pres 1532538164, 0, 0, 36.752948, -122.047173, 315.5, 189.89 1532538664, 0, 0, 36.753186, -122.047732, 343.3, 414.10 1532539164, 0, 0, 36.753712, -122.047931, 349.7, 628.24 1532539664, 0, 0, 36.753591, -122.048094, 293.9, 716.69 1532540164, 0, 0, 36.753786, -122.048285, 278.0, 721.97 1532540664, 0, 0, 36.753810, -122.048246, 271.8, 721.45 1532541164, 0, 0, 36.753752, -122.048292, 270.4, 719.37 1532541664, 0, 0, 36.753799, -122.048310, 287.3, 721.85 1532542165, 0, 0, 36.753688, -122.048308, 272.0, 713.64 1532542665, 0, 0, 36.753720, -122.048994, 270.9, 693.01 1532543165, 0, 0, 36.752619, -122.048561, 304.5, 715.18 1532543665, 0, 0, 36.752541, -122.048609, 306.3, 715.50 1532544165, 0, 0, 36.752568, -122.048412, 283.8, 718.86 1532544665, 0, 0, 36.752573, -122.048452, 283.8, 717.95 1532545165, 0, 0, 36.752543, -122.048502, 285.5, 719.24 1532545665, 0, 0, 36.752553, -122.048752, 269.9, 662.10 1532546165, 0, 0, 36.752403, -122.048463, 266.8, 441.76 1532546666, 0, 0, 36.752473, -122.048522, 266.1, 249.84 1532547166, 0, 0, 36.752179, -122.047300, 319.3, 87.02 1532547666, 0, 0, 36.751292, -122.046484, 318.7, 10.05 rovNav(): 206: 10225 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018206vntaedited.txt 10225 in tList 10225 in {self->{rovT}} 10225 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1532544120 & 1532542230 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 706.271257059999 rovGDCListRefs(): dStats->sample_range = 723.14700227033 rovGDCListRefs(): returning (1st elements): 1532537665 36.752225 -122.049020 312.7 2.68003192149146 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.75288400 hash{lon} = -122.04831600 latMin = 30.752884 latMax = 42.752884 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.752884 AND 42.752884 AND Longitude BETWEEN -128.048316 AND -116.048316 Dive lat = 36.75288400, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04831600 & lat = 36.75288400 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4134rov_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/vnta4134lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1286 shipNav(): $#{$self->{shipLframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/206/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. at}}[last] = 36.784372 Position subsampling set to 8 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 = 10226 makeTracks(): Looping through 1286 point of ship position data... makeTracks(): posSubsample = 8 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4134tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4134mergedCtdNav.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 '7/25/2018 4:54:24 PM' AND '7/25/2018 7:44:52 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/25/2018 4:54:24 PM' AND '7/25/2018 7:44:52 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 '7/25/2018 4:54:24 PM' AND '7/25/2018 7:44:52 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/25/2018 4:54:24 PM' AND '7/25/2018 7:44:52 PM')