Running bin\geopdvc.pl at Sun Apr 15 03:00:03 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4098 bin\geopdvc.pl: Getting Expedition object for diveno = 4098 and rname = vnta set_expd(): rov = vnta, diveno = 4098 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 = 4098 AND RovName = 'vnta' RS->Fields(0)->Value= 6187 RS->Fields(1)->Value= 1518714322 RS->Fields(2)->Value= 1518734409 RS->Fields(3)->Value= 2/15/2018 5:05:22 PM RS->Fields(4)->Value= 2/15/2018 10:40:09 PM set_expd(): $self->{EndDDD} = 046 set_expd(): $self->{StartEsecs} = 1518713122 set_expd(): $self->{EndEsecs} = 1518735609 set_expd(): $self->{EndDtg} = 2/15/2018 10:40:09 PM _readLogr(): Reading videologr data from 2018046datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1518713122 & 1518735609 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1518735612, self->{EndEsecs} = 1518735609 _readLogr(): #LOGHOST_SYSTEM_UTC = 2247 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1518713127 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1518735602 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1518713127 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1518735602 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1518713002, Refined EndEsecs = 1518735729 _readLogr(): Reading videologr data from 2018046datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1518713002 & 1518735729 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1518735732, self->{EndEsecs} = 1518735729 _readLogr(): #LOGHOST_SYSTEM_UTC = 2271 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1518713007 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1518735722 bin\geopdvc.pl: expdid = 6187 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 = 046 (looping to 046) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018046vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018046vnta.txt esecs, east, north, lat, lon, head, pres 1518714822, 0, 0, 36.699835, -122.048875, 102.6, 119.61 1518715323, 0, 0, 36.699622, -122.048505, -19.5, 162.43 1518715824, 0, 0, 36.698343, -122.046952, -16.6, 276.88 1518716325, 0, 0, 36.699448, -122.048437, -43.0, 362.55 1518716826, 0, 0, 36.699308, -122.048450, -63.3, 460.10 1518717327, 0, 0, 36.699127, -122.048365, -65.9, 556.08 1518717828, 0, 0, 36.698862, -122.048257, -67.5, 666.08 1518718328, 0, 0, 36.698735, -122.047952, 165.7, 773.08 1518718829, 0, 0, 36.698757, -122.047747, -35.7, 819.25 1518719330, 0, 0, 36.698917, -122.047572, -60.2, 817.03 1518719831, 0, 0, 36.698802, -122.047385, -8.6, 876.01 1518720332, 0, 0, 36.698585, -122.047233, -114.4, 926.49 1518720833, 0, 0, 36.698373, -122.047323, -151.1, 947.15 1518721334, 0, 0, 36.698400, -122.047222, -68.1, 1000.74 1518721834, 0, 0, 36.698495, -122.046372, 90.6, 1010.12 1518722335, 0, 0, 36.698638, -122.045485, 84.4, 1008.12 1518722836, 0, 0, 36.698588, -122.044623, 87.0, 989.84 1518723337, 0, 0, 36.698582, -122.043685, 91.1, 927.81 1518723838, 0, 0, 36.698338, -122.042680, 87.1, 859.57 1518724338, 0, 0, 36.698220, -122.041407, 90.2, 857.41 1518724839, 0, 0, 36.698143, -122.041022, 83.7, 840.30 1518725340, 0, 0, 36.698168, -122.040843, 79.4, 813.78 1518725841, 0, 0, 36.698192, -122.040360, 89.8, 794.71 1518726342, 0, 0, 36.698130, -122.039688, 86.5, 766.14 1518726843, 0, 0, 36.698038, -122.039130, 84.5, 737.06 1518727344, 0, 0, 36.697952, -122.038787, 119.1, 699.83 1518727845, 0, 0, 36.697933, -122.038582, 87.3, 675.44 1518728346, 0, 0, 36.697882, -122.038233, 90.7, 637.75 1518728846, 0, 0, 36.697988, -122.036892, 89.8, 635.68 1518729347, 0, 0, 36.698150, -122.035712, 42.9, 619.94 1518729848, 0, 0, 36.698890, -122.034818, 37.2, 572.27 1518730349, 0, 0, 36.699325, -122.033755, 122.0, 511.07 1518730850, 0, 0, 36.699225, -122.033620, 130.6, 478.37 1518731351, 0, 0, 36.698965, -122.033073, 102.7, 475.01 1518731852, 0, 0, 36.698782, -122.032652, 102.2, 448.76 1518732353, 0, 0, 36.698402, -122.031857, 130.5, 409.23 1518732854, 0, 0, 36.697783, -122.030665, 135.7, 343.73 1518733354, 0, 0, 36.697838, -122.030180, 34.8, 267.14 1518733855, 0, 0, 36.697492, -122.030202, 10.5, 77.83 1518734356, 0, 0, 36.696947, -122.030163, 62.9, 10.00 rovNav(): 046: 20052 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018046vnta.txt 20052 in tList 20052 in {self->{rovT}} 20052 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1518729630 & 1518719505 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 668.503554630929 rovGDCListRefs(): dStats->sample_range = 998.108022205096 rovGDCListRefs(): returning (1st elements): 1518714322 36.743008 -122.107123 9.5 2.68003410640897 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 046 (looping to 046) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018046vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018046vntaedited.txt esecs, east, north, lat, lon, head, pres 1518714822, 0, 0, 36.699823, -122.048902, 102.6, 119.61 1518715323, 0, 0, 36.699590, -122.048481, 340.5, 162.43 1518715824, 0, 0, 36.699476, -122.048207, 343.4, 276.88 1518716325, 0, 0, 36.699455, -122.048432, 317.0, 362.55 1518716826, 0, 0, 36.699342, -122.048478, 296.7, 460.10 1518717327, 0, 0, 36.699153, -122.048354, 294.1, 556.08 1518717828, 0, 0, 36.698884, -122.048236, 292.5, 666.08 1518718328, 0, 0, 36.698733, -122.047952, 165.7, 773.08 1518718829, 0, 0, 36.698734, -122.047708, 324.3, 819.25 1518719330, 0, 0, 36.698912, -122.047574, 299.8, 817.03 1518719831, 0, 0, 36.698811, -122.047375, 351.4, 876.01 1518720332, 0, 0, 36.698589, -122.047238, 245.6, 926.49 1518720833, 0, 0, 36.698369, -122.047297, 208.9, 947.15 1518721334, 0, 0, 36.698400, -122.047235, 291.9, 1000.74 1518721834, 0, 0, 36.698494, -122.046366, 90.6, 1010.12 1518722335, 0, 0, 36.698583, -122.045576, 84.4, 1008.12 1518722836, 0, 0, 36.698591, -122.044614, 87.0, 989.84 1518723337, 0, 0, 36.698606, -122.043658, 91.1, 927.81 1518723838, 0, 0, 36.698346, -122.042669, 87.1, 859.57 1518724338, 0, 0, 36.698237, -122.041416, 90.2, 857.41 1518724839, 0, 0, 36.698169, -122.040989, 83.7, 840.30 1518725340, 0, 0, 36.698180, -122.040856, 79.4, 813.78 1518725841, 0, 0, 36.698167, -122.040332, 89.8, 794.71 1518726342, 0, 0, 36.698099, -122.039717, 86.5, 766.14 1518726843, 0, 0, 36.698024, -122.039128, 84.5, 737.06 1518727344, 0, 0, 36.697959, -122.038768, 119.1, 699.83 1518727845, 0, 0, 36.697922, -122.038602, 87.3, 675.44 1518728346, 0, 0, 36.697862, -122.038204, 90.7, 637.75 1518728846, 0, 0, 36.697992, -122.036887, 89.8, 635.68 1518729347, 0, 0, 36.698139, -122.035753, 42.9, 619.94 1518729848, 0, 0, 36.698890, -122.034840, 37.2, 572.27 1518730349, 0, 0, 36.699369, -122.033827, 122.0, 511.07 1518730850, 0, 0, 36.699230, -122.033619, 130.6, 478.37 1518731351, 0, 0, 36.698963, -122.033068, 102.7, 475.01 1518731852, 0, 0, 36.698781, -122.032675, 102.2, 448.76 1518732353, 0, 0, 36.698391, -122.031850, 130.5, 409.23 1518732854, 0, 0, 36.697788, -122.030666, 135.7, 343.73 1518733354, 0, 0, 36.697827, -122.030178, 34.8, 267.14 1518733855, 0, 0, 36.697542, -122.030183, 10.5, 77.83 1518734356, 0, 0, 36.696955, -122.030147, 62.9, 10.00 rovNav(): 046: 20052 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018046vntaedited.txt 20052 in tList 20052 in {self->{rovT}} 20052 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1518729630 & 1518719505 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/046/accesses.txt at bin\geopdvc.pl line 2382 ............................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 668.503553980877 rovGDCListRefs(): dStats->sample_range = 998.108012480323 rovGDCListRefs(): returning (1st elements): 1518714322 36.699842 -122.049367 9.5 2.68004433626905 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69853600 hash{lon} = -122.04138700 latMin = 30.698536 latMax = 42.698536 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.698536 AND 42.698536 AND Longitude BETWEEN -128.041387 AND -116.041387 Dive lat = 36.69853600, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04138700 & lat = 36.69853600 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 = vnta4098rov_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/vnta4098lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2271 shipNav(): $#{$self->{shipLat}}[last] = 36.711393 Position subsampling set to 16 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 = 20053 makeTracks(): Looping through 2271 point of ship position data... makeTracks(): posSubsample = 16 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4098tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4098mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '2/15/2018 5:05:22 PM' AND '2/15/2018 10:40:09 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/15/2018 5:05:22 PM' AND '2/15/2018 10:40:09 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.AnnotaCan't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. tions WHERE (ShipName = '') AND (RecordedDate BETWEEN '2/15/2018 5:05:22 PM' AND '2/15/2018 10:40:09 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/15/2018 5:05:22 PM' AND '2/15/2018 10:40:09 PM')