Running bin\geopdvc.pl at Tue Aug 7 03:03:38 2018 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4128 bin\geopdvc.pl: Getting Expedition object for diveno = 4128 and rname = vnta set_expd(): rov = vnta, diveno = 4128 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 = 4128 AND RovName = 'vnta' RS->Fields(0)->Value= 6293 RS->Fields(1)->Value= 1529511698 RS->Fields(2)->Value= 1529527358 RS->Fields(3)->Value= 6/20/2018 4:21:38 PM RS->Fields(4)->Value= 6/20/2018 8:42:38 PM set_expd(): $self->{EndDDD} = 171 set_expd(): $self->{StartEsecs} = 1529510498 set_expd(): $self->{EndEsecs} = 1529528558 set_expd(): $self->{EndDtg} = 6/20/2018 8:42:38 PM _readLogr(): Reading videologr data from 2018171datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1529510498 & 1529528558 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1529528568, self->{EndEsecs} = 1529528558 _readLogr(): #LOGHOST_SYSTEM_UTC = 1805 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1529510508 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1529528558 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1529510508 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1529528558 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1529510378, Refined EndEsecs = 1529528678 _readLogr(): Reading videologr data from 2018171datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1529510378 & 1529528678 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1529528688, self->{EndEsecs} = 1529528678 _readLogr(): #LOGHOST_SYSTEM_UTC = 1829 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1529510388 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1529528678 bin\geopdvc.pl: expdid = 6293 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 = 171 (looping to 171) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018171vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018171vnta.txt esecs, east, north, lat, lon, head, pres 1529512197, 0, 0, 36.699158, -122.050152, 21.1, 85.30 1529512697, 0, 0, 36.698695, -122.050587, 9.8, 274.35 1529513197, 0, 0, 36.698677, -122.050472, 43.8, 378.80 1529513697, 0, 0, 36.698772, -122.050175, -0.8, 436.06 1529514197, 0, 0, 36.698515, -122.049843, 177.8, 585.17 1529514697, 0, 0, 36.698203, -122.049897, 178.8, 643.60 1529515198, 0, 0, 36.697865, -122.049933, -174.5, 657.65 1529515698, 0, 0, 36.697457, -122.050357, -84.4, 653.01 1529516198, 0, 0, 36.697698, -122.051498, -63.9, 599.53 1529516698, 0, 0, 36.697602, -122.052372, -86.8, 549.29 1529517198, 0, 0, 36.697472, -122.052550, -78.7, 495.32 1529517698, 0, 0, 36.697568, -122.052455, -97.4, 456.87 1529518198, 0, 0, 36.697120, -122.053012, -59.3, 408.92 1529518698, 0, 0, 36.697965, -122.052470, -37.7, 396.72 1529519199, 0, 0, 36.698038, -122.052243, -26.0, 394.24 1529519699, 0, 0, 36.698235, -122.052603, -58.4, 336.54 1529520199, 0, 0, 36.698148, -122.052652, -41.9, 325.56 1529520699, 0, 0, 36.698547, -122.052220, -16.1, 314.30 1529521199, 0, 0, 36.698493, -122.051818, -22.3, 309.39 1529521699, 0, 0, 36.698772, -122.051652, 1.2, 291.34 1529522199, 0, 0, 36.699063, -122.051953, -29.0, 275.48 1529522699, 0, 0, 36.699378, -122.052403, -23.8, 272.78 1529523199, 0, 0, 36.700842, -122.045198, -35.9, 247.41 1529523699, 0, 0, 36.695037, -122.053953, -38.0, 226.93 1529524200, 0, 0, 36.699485, -122.053685, -44.1, 235.64 1529524700, 0, 0, 36.697377, -122.055680, -75.1, 232.79 1529525200, 0, 0, 36.694095, -122.056023, -171.4, 227.91 1529525700, 0, 0, 36.697768, -122.055162, -73.8, 205.93 1529526200, 0, 0, 36.697958, -122.055273, -74.3, 77.18 1529526700, 0, 0, 36.697125, -122.054620, -58.6, 10.98 1529527201, 0, 0, 36.695673, -122.053573, -54.1, 10.87 rovNav(): 171: 15657 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018171vnta.txt 15657 in tList 15657 in {self->{rovT}} 15657 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1529524785 & 1529518260 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 316.616613535529 rovGDCListRefs(): dStats->sample_range = 657.344749839799 rovGDCListRefs(): returning (1st elements): 1529511698 36.699612 -122.049995 38.4 2.58078411763677 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 171 (looping to 171) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018171vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018171vntaedited.txt esecs, east, north, lat, lon, head, pres 1529512197, 0, 0, 36.699151, -122.050160, 21.1, 85.30 1529512697, 0, 0, 36.698698, -122.050584, 9.8, 274.35 1529513197, 0, 0, 36.698675, -122.050454, 43.8, 378.80 1529513697, 0, 0, 36.698744, -122.050169, 359.2, 436.06 1529514197, 0, 0, 36.698507, -122.049865, 177.8, 585.17 1529514697, 0, 0, 36.698226, -122.049881, 178.8, 643.60 1529515198, 0, 0, 36.697875, -122.049922, 185.5, 657.65 1529515698, 0, 0, 36.697445, -122.050363, 275.6, 653.01 1529516198, 0, 0, 36.697646, -122.051553, 296.1, 599.53 1529516698, 0, 0, 36.697603, -122.052332, 273.2, 549.29 1529517198, 0, 0, 36.697518, -122.052535, 281.3, 495.32 1529517698, 0, 0, 36.697560, -122.052491, 262.6, 456.87 1529518198, 0, 0, 36.697846, -122.052594, 300.7, 408.92 1529518698, 0, 0, 36.697992, -122.052589, 322.3, 396.72 1529519199, 0, 0, 36.698024, -122.052245, 334.0, 394.24 1529519699, 0, 0, 36.698123, -122.052625, 301.6, 336.54 1529520199, 0, 0, 36.698195, -122.052604, 318.1, 325.56 1529520699, 0, 0, 36.698581, -122.052286, 343.9, 314.30 1529521199, 0, 0, 36.698554, -122.051746, 337.7, 309.39 1529521699, 0, 0, 36.698800, -122.051647, 1.2, 291.34 1529522199, 0, 0, 36.699051, -122.051984, 331.0, 275.48 1529522699, 0, 0, 36.699052, -122.052480, 336.2, 272.78 1529523199, 0, 0, 36.699336, -122.052830, 324.1, 247.41 1529523699, 0, 0, 36.699191, -122.052713, 322.0, 226.93 1529524200, 0, 0, 36.699390, -122.053591, 315.9, 235.64 1529524700, 0, 0, 36.699527, -122.053637, 284.9, 232.79 1529525200, 0, 0, 36.698321, -122.054445, 188.6, 227.91 1529525700, 0, 0, 36.697795, -122.055039, 286.2, 205.93 1529526200, 0, 0, 36.697974, -122.055251, 285.7, 77.18 1529526700, 0, 0, 36.697136, -122.054609, 301.4, 10.98 1529527201, 0, 0, 36.695677, -122.053580, 305.9, 10.87 rovNav(): 171: 15657 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018171vntaedited.txt 15657 in tList 15657 in {self->{rovT}} 15657 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1529524785 & 1529518260 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 316.616612206056 rovGDCListRefs(): dStats->sample_range = 657.344747456448 rovGDCListRefs(): returning (1st elements): 1529511698 36.699649 -122.049865 38.4 2.58078410919485 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69834100 hash{lon} = -122.05239700 latMin = 30.698341 latMax = 42.698341 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.698341 AND 42.698341 AND Longitude BETWEEN -128.052397 AND -116.052397 Dive lat = 36.69834100, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05239700 & lat = 36.69834100 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4128rov_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/vnta4128lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/171/accesses.txt at bin\geopdvc.pl line 2382 Can't call method "EOF" on an undefined value at bin/EXPD.pm line 2246. ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1829 shipNav(): $#{$self->{shipLat}}[last] = 36.705645 Position subsampling set to 13 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 15658 makeTracks(): Looping through 1829 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4128tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4128mergedCtdNav.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/20/2018 4:21:38 PM' AND '6/20/2018 8:42:38 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/20/2018 4:21:38 PM' AND '6/20/2018 8:42:38 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/20/2018 4:21:38 PM' AND '6/20/2018 8:42:38 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/20/2018 4:21:38 PM' AND '6/20/2018 8:42:38 PM')