Running bin\geopdvc_perseus.pl at Thu Jan 16 03:00:02 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4234 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4234 and rname = vnta set_expd(): rov = vnta, diveno = 4234 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 = 4234 AND RovName = 'vnta' RS->Fields(0)->Value= 6795 RS->Fields(1)->Value= 1574098626 RS->Fields(2)->Value= 1574116949 RS->Fields(3)->Value= 11/18/2019 5:37:06 PM RS->Fields(4)->Value= 11/18/2019 10:42:29 PM set_expd(): $self->{EndDDD} = 322 set_expd(): $self->{StartEsecs} = 1574097426 set_expd(): $self->{EndEsecs} = 1574118149 set_expd(): $self->{EndDtg} = 11/18/2019 10:42:29 PM _readLogr(): Reading videologr data from 2019322datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1574097426 & 1574118149 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1574118150, self->{EndEsecs} = 1574118149 _readLogr(): #LOGHOST_SYSTEM_UTC = 2071 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1574097429 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1574118140 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1574097429 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1574118140 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1574097306, Refined EndEsecs = 1574118269 _readLogr(): Reading videologr data from 2019322datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1574097306 & 1574118269 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1574118270, self->{EndEsecs} = 1574118269 _readLogr(): #LOGHOST_SYSTEM_UTC = 2095 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1574097309 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1574118260 bin\geopdvc_perseus.pl: expdid = 6795 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): getRaw = 1 rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 322 (looping to 322) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019322vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019322vnta.txt esecs, east, north, lat, lon, head, pres 1574099125, 0, 0, 36.759210, -122.050862, 165.7, 208.75 1574099625, 0, 0, 36.758827, -122.050807, 166.8, 430.86 1574100125, 0, 0, 36.758512, -122.050100, 153.8, 642.49 1574100625, 0, 0, 36.758565, -122.050327, -49.1, 662.52 1574101125, 0, 0, 36.758552, -122.050285, -57.2, 663.13 1574101625, 0, 0, 36.758773, -122.050645, -14.2, 650.20 1574102126, 0, 0, 36.758933, -122.050820, -73.4, 642.77 1574102626, 0, 0, 36.758577, -122.050318, -121.9, 662.41 1574103126, 0, 0, 36.758640, -122.050812, -100.6, 649.63 1574103626, 0, 0, 36.758617, -122.050897, -85.6, 647.72 1574104126, 0, 0, 36.758503, -122.051240, -93.9, 640.69 1574104626, 0, 0, 36.759022, -122.051290, -73.3, 630.13 1574105126, 0, 0, 36.758620, -122.050495, 122.9, 657.68 1574105626, 0, 0, 36.758957, -122.050990, -61.7, 637.76 1574106126, 0, 0, 36.758607, -122.050357, 122.0, 659.55 1574106626, 0, 0, 36.758757, -122.050607, 134.0, 652.37 1574107127, 0, 0, 36.758887, -122.050760, -54.5, 645.62 1574107627, 0, 0, 36.759357, -122.051572, -87.7, 617.94 1574108127, 0, 0, 36.758700, -122.051680, -31.3, 623.40 1574108627, 0, 0, 36.758645, -122.051707, 126.2, 621.49 1574109127, 0, 0, 36.758552, -122.050363, 88.4, 662.09 1574109627, 0, 0, 36.758758, -122.050983, -58.0, 639.54 1574110127, 0, 0, 36.759100, -122.051347, -44.0, 626.86 1574110627, 0, 0, 36.758560, -122.050405, 76.3, 659.61 1574111127, 0, 0, 36.758753, -122.050690, 126.3, 650.40 1574111628, 0, 0, 36.758563, -122.050350, 79.0, 662.02 1574112128, 0, 0, 36.758430, -122.050430, -156.1, 660.52 1574112628, 0, 0, 36.756293, -122.050650, -161.9, 656.87 1574113128, 0, 0, 36.754890, -122.051495, -135.5, 622.12 1574113628, 0, 0, 36.753958, -122.052515, -125.7, 582.52 1574114128, 0, 0, 36.752967, -122.053560, -127.3, 556.03 1574114628, 0, 0, 36.752417, -122.055155, -46.6, 543.84 1574115128, 0, 0, 36.752393, -122.055227, -60.0, 410.60 1574115628, 0, 0, 36.752450, -122.055015, -88.8, 365.99 1574116128, 0, 0, 36.752475, -122.055053, -155.4, 262.19 1574116629, 0, 0, 36.752585, -122.054450, -163.4, 96.09 rovNav(): 322: 18320 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019322vnta.txt 18320 in tList 18320 in {self->{rovT}} 18320 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1574100345 & 1574107185 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 631.6523712864 rovGDCListRefs(): dStats->sample_range = 661.031915178796 rovGDCListRefs(): returning (1st elements): 1574098626 36.759020 -122.051067 -132.4 2.58077055894061 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 322 (looping to 322) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019322vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019322vntaedited.txt esecs, east, north, lat, lon, head, pres 1574099125, 0, 0, 36.759211, -122.050858, 165.7, 208.75 1574099625, 0, 0, 36.758828, -122.050806, 166.8, 430.86 1574100125, 0, 0, 36.758526, -122.050099, 153.8, 642.49 1574100625, 0, 0, 36.758567, -122.050329, 310.9, 662.52 1574101125, 0, 0, 36.758549, -122.050284, 302.8, 663.13 1574101625, 0, 0, 36.758785, -122.050636, 345.8, 650.20 1574102126, 0, 0, 36.758931, -122.050830, 286.6, 642.77 1574102626, 0, 0, 36.758579, -122.050321, 238.1, 662.41 1574103126, 0, 0, 36.758642, -122.050810, 259.4, 649.63 1574103626, 0, 0, 36.758616, -122.050900, 274.4, 647.72 1574104126, 0, 0, 36.758503, -122.051244, 266.1, 640.69 1574104626, 0, 0, 36.759030, -122.051289, 286.7, 630.13 1574105126, 0, 0, 36.758629, -122.050487, 122.9, 657.68 1574105626, 0, 0, 36.758971, -122.051002, 298.3, 637.76 1574106126, 0, 0, 36.758608, -122.050394, 122.0, 659.55 1574106626, 0, 0, 36.758742, -122.050606, 134.0, 652.37 1574107127, 0, 0, 36.758883, -122.050763, 305.5, 645.62 1574107627, 0, 0, 36.759342, -122.051581, 272.3, 617.94 1574108127, 0, 0, 36.758702, -122.051673, 328.7, 623.40 1574108627, 0, 0, 36.758644, -122.051723, 126.2, 621.49 1574109127, 0, 0, 36.758540, -122.050373, 88.4, 662.09 1574109627, 0, 0, 36.758775, -122.050994, 302.0, 639.54 1574110127, 0, 0, 36.759094, -122.051359, 316.0, 626.86 1574110627, 0, 0, 36.758568, -122.050407, 76.3, 659.61 1574111127, 0, 0, 36.758759, -122.050686, 126.3, 650.40 1574111628, 0, 0, 36.758568, -122.050360, 79.0, 662.02 1574112128, 0, 0, 36.758411, -122.050434, 203.9, 660.52 1574112628, 0, 0, 36.756290, -122.050662, 198.1, 656.87 1574113128, 0, 0, 36.754886, -122.051502, 224.5, 622.12 1574113628, 0, 0, 36.753963, -122.052530, 234.3, 582.52 1574114128, 0, 0, 36.752954, -122.053564, 232.7, 556.03 1574114628, 0, 0, 36.752420, -122.055150, 313.4, 543.84 1574115128, 0, 0, 36.752420, -122.055217, 300.0, 410.60 1574115628, 0, 0, 36.752326, -122.055394, 271.2, 365.99 1574116128, 0, 0, 36.752415, -122.054936, 204.6, 262.19 1574116629, 0, 0, 36.752572, -122.054486, 196.6, 96.09 rovNav(): 322: 18320 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019322vntaedited.txt 18320 in tList 18320 in {self->{rovT}} 18320 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1574108940 & 1574110980 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/322/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/322/accesses.txt at bin\geopdvc_perseus.pl line 629. ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 631.652372068625 rovGDCListRefs(): dStats->sample_range = 661.031915472272 rovGDCListRefs(): returning (1st elements): 1574098626 36.759091 -122.050979 227.6 2.58077054273129 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.75859500 hash{lon} = -122.05090700 latMin = 30.758595 latMax = 42.758595 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.758595 AND 42.758595 AND Longitude BETWEEN -128.050907 AND -116.050907 Dive lat = 36.75859500, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05090700 & lat = 36.75859500 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4234rov_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 = geo2019/vnta/vnta4234lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2095 shipNav(): $#{$self->{shipLat}}[last] = 36.760887 Position subsampling set to 15 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 = 18321 makeTracks(): Looping through 2095 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4234tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4234mergedCtdNav.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/18/2019 5:37:06 PM' AND '11/18/2019 10:42:29 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/18/2019 5:37:06 PM' AND '11/18/2019 10:42:29 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/2019/vnta4234... 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/18/2019 5:37:06 PM' AND '11/18/2019 10:42:29 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4234.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6795,'/3Dreplay/3D.asp?dives=vnta4234','vnta4234','','','',4234 Executing sql: UPDATE Dive SET DiveLatMid = 36.7586, DiveLonMid = -122.0509, DiveDepthMid = -631.6 WHERE RovName = 'vnta' AND DiveNumber = 4234