Running bin\geopdvc_perseus.pl at Wed Jul 24 16:51:07 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4164 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4164 and rname = vnta set_expd(): rov = vnta, diveno = 4164 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 = 4164 AND RovName = 'vnta' RS->Fields(0)->Value= 6461 RS->Fields(1)->Value= 1543340081 RS->Fields(2)->Value= 1543358130 RS->Fields(3)->Value= 11/27/2018 5:34:41 PM RS->Fields(4)->Value= 11/27/2018 10:35:30 PM set_expd(): $self->{EndDDD} = 331 set_expd(): $self->{StartEsecs} = 1543338881 set_expd(): $self->{EndEsecs} = 1543359330 set_expd(): $self->{EndDtg} = 11/27/2018 10:35:30 PM _readLogr(): Reading videologr data from 2018331datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1543338881 & 1543359330 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1543359340, self->{EndEsecs} = 1543359330 _readLogr(): #LOGHOST_SYSTEM_UTC = 2044 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1543338889 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1543359330 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1543338889 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1543359330 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1543338761, Refined EndEsecs = 1543359450 _readLogr(): Reading videologr data from 2018331datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1543338761 & 1543359450 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1543359460, self->{EndEsecs} = 1543359450 _readLogr(): #LOGHOST_SYSTEM_UTC = 2068 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1543338769 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1543359450 bin\geopdvc_perseus.pl: expdid = 6461 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): getRaw = 1 rovnavCTDO(): calcUTM = 0 rovNav(): 1, getRaw = 1 rovNav(): 2, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 331 (looping to 331) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018331vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018331vnta.txt esecs, east, north, lat, lon, head, pres 1543340580, 0, 0, 36.700653, -122.049140, -7.8, 193.03 1543341080, 0, 0, 36.700197, -122.049335, 54.9, 363.97 1543341581, 0, 0, 36.700148, -122.049387, 53.8, 575.35 1543342081, 0, 0, 36.700240, -122.049002, 39.2, 782.00 1543342581, 0, 0, 36.700383, -122.048933, 39.6, 965.25 1543343081, 0, 0, 36.700733, -122.048675, -42.8, 1007.90 1543343581, 0, 0, 36.701183, -122.049102, -23.3, 1009.69 1543344081, 0, 0, 36.702105, -122.049045, -18.1, 1010.59 1543344581, 0, 0, 36.702645, -122.048978, -37.3, 993.45 1543345081, 0, 0, 36.703197, -122.049678, -72.7, 970.28 1543345581, 0, 0, 36.704103, -122.049920, -32.0, 942.30 1543346082, 0, 0, 36.704583, -122.049758, -36.2, 938.30 1543346582, 0, 0, 36.705420, -122.049962, -33.4, 922.63 1543347082, 0, 0, 36.705720, -122.050093, -54.8, 896.83 1543347582, 0, 0, 36.705658, -122.049688, -21.9, 893.55 1543348082, 0, 0, 36.705878, -122.049422, -40.2, 809.56 1543348582, 0, 0, 36.706352, -122.049288, -39.4, 767.17 1543349082, 0, 0, 36.707133, -122.050143, -39.7, 773.13 1543349582, 0, 0, 36.707262, -122.050220, -89.2, 696.83 1543350082, 0, 0, 36.707318, -122.049597, -23.5, 677.08 1543350583, 0, 0, 36.707750, -122.049002, -33.1, 637.94 1543351083, 0, 0, 36.708417, -122.048902, -12.5, 628.38 1543351583, 0, 0, 36.709305, -122.049048, -28.0, 607.02 1543352083, 0, 0, 36.709812, -122.049005, -57.0, 569.24 1543352583, 0, 0, 36.709930, -122.049068, -51.4, 539.17 1543353083, 0, 0, 36.709983, -122.049385, -60.5, 537.03 1543353583, 0, 0, 36.709832, -122.049700, -67.4, 501.52 1543354083, 0, 0, 36.709730, -122.049890, -69.9, 473.63 1543354583, 0, 0, 36.709523, -122.050532, -40.2, 432.85 1543355083, 0, 0, 36.709120, -122.050822, -88.1, 406.07 1543355584, 0, 0, 36.709158, -122.051603, -89.8, 321.18 1543356084, 0, 0, 36.708997, -122.051727, -54.7, 285.10 1543356584, 0, 0, 36.708998, -122.051625, 29.4, 287.07 1543357084, 0, 0, 36.708587, -122.051378, -108.3, 132.43 1543357584, 0, 0, 36.708880, -122.050507, -108.3, 11.10 1543358084, 0, 0, 36.709208, -122.049248, -99.8, 11.25 rovNav(): 331: 18046 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018331vnta.txt 18046 in tList 18046 in {self->{rovT}} 18046 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1543357215 & 1543342410 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 627.578202243896 rovGDCListRefs(): dStats->sample_range = 1002.75026803551 rovGDCListRefs(): returning (1st elements): 1543340081 36.695978 -122.027140 5.6 2.58078494675444 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 331 (looping to 331) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018331vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018331vntaedited.txt esecs, east, north, lat, lon, head, pres 1543340580, 0, 0, 36.700648, -122.049148, 352.2, 193.03 1543341080, 0, 0, 36.700192, -122.049337, 54.9, 363.97 1543341581, 0, 0, 36.700080, -122.049324, 53.8, 575.35 1543342081, 0, 0, 36.700234, -122.049008, 39.2, 782.00 1543342581, 0, 0, 36.700378, -122.048931, 39.6, 965.25 1543343081, 0, 0, 36.700738, -122.048687, 317.2, 1007.90 1543343581, 0, 0, 36.701190, -122.049101, 336.7, 1009.69 1543344081, 0, 0, 36.702098, -122.049044, 341.9, 1010.59 1543344581, 0, 0, 36.702642, -122.048976, 322.7, 993.45 1543345081, 0, 0, 36.703196, -122.049677, 287.3, 970.28 1543345581, 0, 0, 36.704103, -122.049918, 328.0, 942.30 1543346082, 0, 0, 36.704586, -122.049765, 323.8, 938.30 1543346582, 0, 0, 36.705419, -122.049956, 326.6, 922.63 1543347082, 0, 0, 36.705725, -122.050091, 305.2, 896.83 1543347582, 0, 0, 36.705656, -122.049691, 338.1, 893.55 1543348082, 0, 0, 36.705887, -122.049418, 319.8, 809.56 1543348582, 0, 0, 36.706352, -122.049286, 320.6, 767.17 1543349082, 0, 0, 36.707149, -122.050137, 320.3, 773.13 1543349582, 0, 0, 36.707261, -122.050219, 270.8, 696.83 1543350082, 0, 0, 36.707336, -122.049596, 336.5, 677.08 1543350583, 0, 0, 36.707736, -122.049010, 326.9, 637.94 1543351083, 0, 0, 36.708392, -122.048919, 347.5, 628.38 1543351583, 0, 0, 36.709307, -122.049054, 332.0, 607.02 1543352083, 0, 0, 36.709800, -122.049013, 303.0, 569.24 1543352583, 0, 0, 36.709949, -122.049060, 308.6, 539.17 1543353083, 0, 0, 36.709985, -122.049380, 299.5, 537.03 1543353583, 0, 0, 36.709809, -122.049690, 292.6, 501.52 1543354083, 0, 0, 36.709731, -122.049895, 290.1, 473.63 1543354583, 0, 0, 36.709536, -122.050537, 319.8, 432.85 1543355083, 0, 0, 36.709120, -122.050823, 271.9, 406.07 1543355584, 0, 0, 36.709137, -122.051571, 270.2, 321.18 1543356084, 0, 0, 36.709009, -122.051747, 305.3, 285.10 1543356584, 0, 0, 36.708964, -122.051629, 29.4, 287.07 1543357084, 0, 0, 36.708615, -122.051379, 251.7, 132.43 1543357584, 0, 0, 36.708913, -122.050509, 251.7, 11.10 1543358084, 0, 0, 36.709202, -122.049242, 260.2, 11.25 rovNav(): 331: 18046 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018331vntaedited.txt 18046 in tList 18046 in {self->{rovT}} 18046 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1543340775 & 1543349685 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/331/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/331/accesses.txt at bin\geopdvc_perseus.pl line 629. ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 627.578202909696 rovGDCListRefs(): dStats->sample_range = 1002.75026803417 rovGDCListRefs(): returning (1st elements): 1543340081 36.701601 -122.048816 5.6 2.58078366382192 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70718600 hash{lon} = -122.04947900 latMin = 30.707186 latMax = 42.707186 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.707186 AND 42.707186 AND Longitude BETWEEN -128.049479 AND -116.049479 Dive lat = 36.70718600, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04947900 & lat = 36.70718600 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4164rov_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/vnta4164lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2068 shipNav(): $#{$self->{shipLat}}[last] = 36.728776 Position subsampling set to 14 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 = 18047 makeTracks(): Looping through 2068 point of ship position data... makeTracks(): posSubsample = 14 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4164tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4164mergedCtdNav.txt... bin\geopdvc_perseus.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 '11/27/2018 5:34:41 PM' AND '11/27/2018 10:35:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/27/2018 5:34:41 PM' AND '11/27/2018 10:35:30 PM') bin\geopdvc_perseus.pl: Calling placeAnnotations with every 10 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 2 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 1 annotation... frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/vnta4164... iList = bin\geopdvc_perseus.pl: Number of images returned from expd->frameGrabs(every=>1)} = 0 bin\geopdvc_perseus.pl: Calling placeImages with every 10 image... bin\geopdvc_perseus.pl: Calling placeImages with every 2 image... bin\geopdvc_perseus.pl: Calling placeImages with every 1 image... bin\geopdvc_perseus.pl: Samples: samples(): Executing sql: SELECT DateDiff(ss, '01/01/70', CollectionEventDtg) AS Esecs, CollectionVIMSConcept, FrameGrabImageURL, SampleID, CollectionRefName FROM vwCollSamplePerson WHERE (CollectionEventDTG BETWEEN '11/27/2018 5:34:41 PM' AND '11/27/2018 10:35:30 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2018/vnta/vnta4164.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6461,'/3Dreplay/3D.asp?dives=vnta4164','vnta4164','','','',4164 Executing sql: UPDATE Dive SET DiveLatMid = 36.7072, DiveLonMid = -122.0495, DiveDepthMid = -627.6 WHERE RovName = 'vnta' AND DiveNumber = 4164