Running bin\geopdvc.pl at Tue Aug 7 03:05:41 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4129 bin\geopdvc.pl: Getting Expedition object for diveno = 4129 and rname = vnta set_expd(): rov = vnta, diveno = 4129 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 = 4129 AND RovName = 'vnta' RS->Fields(0)->Value= 6294 RS->Fields(1)->Value= 1529596201 RS->Fields(2)->Value= 1529619231 RS->Fields(3)->Value= 6/21/2018 3:50:01 PM RS->Fields(4)->Value= 6/21/2018 10:13:51 PM set_expd(): $self->{EndDDD} = 172 set_expd(): $self->{StartEsecs} = 1529595001 set_expd(): $self->{EndEsecs} = 1529620431 set_expd(): $self->{EndDtg} = 6/21/2018 10:13:51 PM _readLogr(): Reading videologr data from 2018172datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1529595001 & 1529620431 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1529620441, self->{EndEsecs} = 1529620431 _readLogr(): #LOGHOST_SYSTEM_UTC = 2542 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1529595010 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1529620431 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1529595010 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1529620431 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1529594881, Refined EndEsecs = 1529620551 _readLogr(): Reading videologr data from 2018172datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1529594881 & 1529620551 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1529620561, self->{EndEsecs} = 1529620551 _readLogr(): #LOGHOST_SYSTEM_UTC = 2566 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1529594890 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1529620551 bin\geopdvc.pl: expdid = 6294 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 = 172 (looping to 172) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018172vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018172vnta.txt esecs, east, north, lat, lon, head, pres 1529596701, 0, 0, 36.695137, -122.053270, 6.2, 105.80 1529597201, 0, 0, 36.793707, -121.876097, -50.6, 105.78 1529597701, 0, 0, 36.793773, -121.876347, -63.0, 105.76 1529598201, 0, 0, 36.793723, -121.876607, -61.5, 104.73 1529598701, 0, 0, 36.793430, -121.876913, -65.3, 105.52 1529599201, 0, 0, 36.793598, -121.876313, -63.8, 105.67 1529599701, 0, 0, 36.793377, -121.877730, -64.8, 110.86 1529600201, 0, 0, 36.793213, -121.877980, -65.8, 110.80 1529600701, 0, 0, 36.796713, -121.877515, -63.8, 115.89 1529601202, 0, 0, 36.793042, -121.878118, -66.4, 115.95 1529601702, 0, 0, 36.793180, -121.877500, 178.5, 148.38 1529602202, 0, 0, 36.793112, -121.876880, 178.0, 150.89 1529602702, 0, 0, 36.792778, -121.876387, -179.7, 150.98 1529603202, 0, 0, 36.792405, -121.876163, 178.8, 148.44 1529603702, 0, 0, 36.791922, -121.875618, 178.6, 120.70 1529604202, 0, 0, 36.791203, -121.875327, -179.1, 120.84 1529604702, 0, 0, 36.790628, -121.874908, 179.5, 120.84 1529605202, 0, 0, 36.789928, -121.874480, 174.9, 120.86 1529605703, 0, 0, 36.789278, -121.874388, 175.8, 99.50 1529606203, 0, 0, 36.788503, -121.874213, -179.5, 65.16 1529606703, 0, 0, 36.787835, -121.873828, 161.5, 65.59 1529607203, 0, 0, 36.787590, -121.873360, 121.1, 63.92 1529607703, 0, 0, 36.787417, -121.872702, 115.4, 65.65 1529608203, 0, 0, 36.787210, -121.872290, 116.4, 64.26 1529608703, 0, 0, 36.786613, -121.872077, 150.8, 55.41 1529609203, 0, 0, 36.786450, -121.871922, 162.2, 59.75 1529609703, 0, 0, 36.786115, -121.871425, 155.0, 80.63 1529610203, 0, 0, 36.785993, -121.870663, 93.3, 115.82 1529610704, 0, 0, 36.785748, -121.869975, 140.0, 148.74 1529611204, 0, 0, 36.785280, -121.869563, 123.7, 170.20 1529611704, 0, 0, 36.785305, -121.869388, 123.8, 170.96 1529612204, 0, 0, 36.785277, -121.869293, 102.7, 173.56 1529612704, 0, 0, 36.785317, -121.869342, 85.7, 173.49 1529613204, 0, 0, 36.785183, -121.868880, 146.4, 165.83 1529613704, 0, 0, 36.784770, -121.868522, 135.9, 152.49 1529614204, 0, 0, 36.784250, -121.868022, 136.1, 144.06 1529614704, 0, 0, 36.783937, -121.867282, 127.6, 137.41 1529615204, 0, 0, 36.783768, -121.866460, 78.6, 124.62 1529615705, 0, 0, 36.783702, -121.866573, -92.0, 120.42 1529616205, 0, 0, 36.778985, -121.864430, -72.4, 97.27 1529616705, 0, 0, 36.783933, -121.868467, -72.0, 90.20 1529617205, 0, 0, 36.780848, -121.862365, -71.3, 72.71 1529617705, 0, 0, 36.786017, -121.862038, -77.7, 57.19 1529618205, 0, 0, 36.783912, -121.863747, -78.5, 34.28 1529618705, 0, 0, 36.783482, -121.871147, -82.2, 21.66 rovNav(): 172: 22912 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018172vnta.txt 22912 in tList 22912 in {self->{rovT}} 22912 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1529600115 & 1529613990 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 109.911488665781 rovGDCListRefs(): dStats->sample_range = 170.863186444266 rovGDCListRefs(): returning (1st elements): 1529596202 36.695137 -122.053270 1.6 2.58078513862889 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 172 (looping to 172) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018172vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018172vntaedited.txt esecs, east, north, lat, lon, head, pres 1529596701, 0, 0, 36.695137, -122.053270, 6.2, 105.80 1529597201, 0, 0, 36.793707, -121.876097, 309.4, 105.78 1529597701, 0, 0, 36.793773, -121.876347, 297.0, 105.76 1529598201, 0, 0, 36.793723, -121.876607, 298.5, 104.73 1529598701, 0, 0, 36.793430, -121.876913, 294.7, 105.52 1529599201, 0, 0, 36.793598, -121.876313, 296.2, 105.67 1529599701, 0, 0, 36.793377, -121.877730, 295.2, 110.86 1529600201, 0, 0, 36.793213, -121.877980, 294.2, 110.80 1529600701, 0, 0, 36.796713, -121.877515, 296.2, 115.89 1529601202, 0, 0, 36.793042, -121.878118, 293.6, 115.95 1529601702, 0, 0, 36.793180, -121.877500, 178.5, 148.38 1529602202, 0, 0, 36.793112, -121.876880, 178.0, 150.89 1529602702, 0, 0, 36.792778, -121.876387, 180.3, 150.98 1529603202, 0, 0, 36.792405, -121.876163, 178.8, 148.44 1529603702, 0, 0, 36.791922, -121.875618, 178.6, 120.70 1529604202, 0, 0, 36.791203, -121.875327, 180.9, 120.84 1529604702, 0, 0, 36.790628, -121.874908, 179.5, 120.84 1529605202, 0, 0, 36.789928, -121.874480, 174.9, 120.86 1529605703, 0, 0, 36.789278, -121.874388, 175.8, 99.50 1529606203, 0, 0, 36.788503, -121.874213, 180.5, 65.16 1529606703, 0, 0, 36.787835, -121.873828, 161.5, 65.59 1529607203, 0, 0, 36.787590, -121.873360, 121.1, 63.92 1529607703, 0, 0, 36.787417, -121.872702, 115.4, 65.65 1529608203, 0, 0, 36.787210, -121.872290, 116.4, 64.26 1529608703, 0, 0, 36.786613, -121.872077, 150.8, 55.41 1529609203, 0, 0, 36.786450, -121.871922, 162.2, 59.75 1529609703, 0, 0, 36.786115, -121.871425, 155.0, 80.63 1529610203, 0, 0, 36.785993, -121.870663, 93.3, 115.82 1529610704, 0, 0, 36.785748, -121.869975, 140.0, 148.74 1529611204, 0, 0, 36.785280, -121.869563, 123.7, 170.20 1529611704, 0, 0, 36.785305, -121.869388, 123.8, 170.96 1529612204, 0, 0, 36.785277, -121.869293, 102.7, 173.56 1529612704, 0, 0, 36.785317, -121.869342, 85.7, 173.49 1529613204, 0, 0, 36.785183, -121.868880, 146.4, 165.83 1529613704, 0, 0, 36.784770, -121.868522, 135.9, 152.49 1529614204, 0, 0, 36.784250, -121.868022, 136.1, 144.06 1529614704, 0, 0, 36.783937, -121.867282, 127.6, 137.41 1529615204, 0, 0, 36.783768, -121.866460, 78.6, 124.62 1529615705, 0, 0, 36.783702, -121.866573, 268.0, 120.42 1529616205, 0, 0, 36.778985, -121.864430, 287.6, 97.27 1529616705, 0, 0, 36.783933, -121.868467, 288.0, 90.20 1529617205, 0, 0, 36.780848, -121.862365, 288.7, 72.71 1529617705, 0, 0, 36.786017, -121.862038, 282.3, 57.19 1529618205, 0, 0, 36.783912, -121.863747, 281.5, 34.28 1529618705, 0, 0, 36.783482, -121.871147, 277.8, 21.66 rovNav(): 172: 22912 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018172vntaedited.txt 22912 in tList 22912 in {self->{rovT}} 22912 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1529600115 & 1529613990 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 109.911488665781 rovGDCListRefs(): dStats->sample_range = 170.863186444266 rovGDCListRefs(): returning (1st elements): 1529596202 36.695137 -122.053270 1.6 2.58078513862889 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.78724500 hash{lon} = -121.87273700 latMin = 30.787245 latMax = 42.787245 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.787245 AND 42.787245 AND Longitude BETWEEN -127.872737 AND -115.872737 Dive lat = 36.78724500, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.87273700 & lat = 36.78724500 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... makeROVorig(): Number of points greater than 20,000. Skipping every other point for .wrl file. inline_name = vnta4129rov_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, vmaxframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/172/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. = 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/vnta4129lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2566 shipNav(): $#{$self->{shipLat}}[last] = 36.789473 Position subsampling set to 18 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 = 22913 makeTracks(): Looping through 2566 point of ship position data... makeTracks(): posSubsample = 18 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4129tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4129mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '6/21/2018 3:50:01 PM' AND '6/21/2018 10:13:51 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/21/2018 3:50:01 PM' AND '6/21/2018 10:13:51 PM') Empty Return Set: RS from: Server=equinox,1433;Database=VARS;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '6/21/2018 3:50:01 PM' AND '6/21/2018 10:13:51 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/21/2018 3:50:01 PM' AND '6/21/2018 10:13:51 PM')