Running bin\geopdvc_perseus.pl at Wed Jul 24 16:49:44 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4161 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4161 and rname = vnta set_expd(): rov = vnta, diveno = 4161 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 = 4161 AND RovName = 'vnta' RS->Fields(0)->Value= 6440 RS->Fields(1)->Value= 1542041914 RS->Fields(2)->Value= 1542062508 RS->Fields(3)->Value= 11/12/2018 4:58:34 PM RS->Fields(4)->Value= 11/12/2018 10:41:48 PM set_expd(): $self->{EndDDD} = 316 set_expd(): $self->{StartEsecs} = 1542040714 set_expd(): $self->{EndEsecs} = 1542063708 set_expd(): $self->{EndDtg} = 11/12/2018 10:41:48 PM _readLogr(): Reading videologr data from 2018316datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1542040714 & 1542063708 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1542063715, self->{EndEsecs} = 1542063708 _readLogr(): #LOGHOST_SYSTEM_UTC = 2298 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1542040724 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1542063705 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1542040724 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1542063705 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1542040594, Refined EndEsecs = 1542063828 _readLogr(): Reading videologr data from 2018316datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1542040594 & 1542063828 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1542063835, self->{EndEsecs} = 1542063828 _readLogr(): #LOGHOST_SYSTEM_UTC = 2322 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1542040604 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1542063825 bin\geopdvc_perseus.pl: expdid = 6440 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 316 (looping to 316) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018316vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018316vnta.txt esecs, east, north, lat, lon, head, pres 1542043152, 0, 0, 36.746805, -122.051760, 163.0, 77.23 1542043652, 0, 0, 36.746843, -122.051773, 163.7, 316.75 1542044152, 0, 0, 36.746885, -122.051422, 162.5, 550.70 1542044652, 0, 0, 36.747043, -122.051295, -98.6, 634.54 1542045152, 0, 0, 36.747065, -122.051383, -40.4, 635.34 1542045652, 0, 0, 36.747037, -122.051458, -41.3, 635.37 1542046152, 0, 0, 36.747060, -122.051387, -58.6, 635.39 1542046652, 0, 0, 36.747050, -122.051397, -55.1, 635.48 1542047153, 0, 0, 36.747043, -122.051475, -144.7, 636.60 1542047653, 0, 0, 36.747035, -122.051482, -142.2, 636.65 1542048153, 0, 0, 36.747028, -122.051482, -139.7, 636.72 1542048653, 0, 0, 36.747028, -122.051487, -100.6, 637.59 1542049153, 0, 0, 36.747097, -122.051512, -129.1, 637.83 1542049653, 0, 0, 36.747090, -122.051475, -140.2, 637.87 1542050153, 0, 0, 36.747052, -122.051470, -164.6, 632.66 1542050653, 0, 0, 36.747027, -122.051435, -126.6, 634.17 1542051153, 0, 0, 36.746963, -122.051457, -105.8, 634.06 1542051653, 0, 0, 36.746997, -122.051465, -100.4, 634.15 1542052154, 0, 0, 36.746947, -122.051490, -124.9, 633.88 1542052654, 0, 0, 36.746857, -122.051517, -121.6, 633.10 1542053154, 0, 0, 36.746785, -122.051497, -124.1, 633.03 1542053654, 0, 0, 36.746787, -122.051520, -122.7, 633.01 1542054154, 0, 0, 36.746775, -122.051580, 129.5, 633.88 1542054654, 0, 0, 36.746768, -122.051568, 109.7, 633.76 1542055154, 0, 0, 36.746750, -122.051658, -109.1, 633.90 1542055654, 0, 0, 36.746712, -122.051993, -50.5, 644.90 1542056154, 0, 0, 36.746702, -122.051995, -13.8, 644.98 1542056654, 0, 0, 36.746903, -122.051937, 81.7, 644.49 1542057154, 0, 0, 36.746902, -122.051940, 83.7, 644.47 1542057655, 0, 0, 36.746887, -122.051958, 86.0, 644.37 1542058155, 0, 0, 36.746870, -122.051723, 120.9, 637.78 1542058655, 0, 0, 36.746788, -122.051732, 91.5, 634.78 1542059155, 0, 0, 36.746817, -122.051528, 91.6, 633.35 1542059655, 0, 0, 36.746753, -122.051252, 163.3, 634.88 1542060155, 0, 0, 36.746950, -122.051242, -83.7, 636.42 1542060655, 0, 0, 36.746802, -122.051743, -79.1, 626.11 1542061155, 0, 0, 36.746800, -122.052240, -98.3, 443.15 1542061655, 0, 0, 36.746922, -122.052930, -116.6, 273.50 1542062156, 0, 0, 36.746117, -122.052935, -156.9, 109.32 rovNav(): 316: 19851 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018316vnta.txt 19851 in tList 19851 in {self->{rovT}} 19851 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1542049935 & 1542055470 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 628.496340755375 rovGDCListRefs(): dStats->sample_range = 636.701598126894 rovGDCListRefs(): returning (1st elements): 1542041914 36.744757 -122.050328 -174.5 2.58077381494637 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 316 (looping to 316) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018316vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018316vntaedited.txt esecs, east, north, lat, lon, head, pres 1542043152, 0, 0, 36.746812, -122.051740, 163.0, 77.23 1542043652, 0, 0, 36.746840, -122.051726, 163.7, 316.75 1542044152, 0, 0, 36.746889, -122.051414, 162.5, 550.70 1542044652, 0, 0, 36.747035, -122.051316, 261.4, 634.54 1542045152, 0, 0, 36.747067, -122.051371, 319.6, 635.34 1542045652, 0, 0, 36.747079, -122.051392, 318.7, 635.37 1542046152, 0, 0, 36.747063, -122.051375, 301.4, 635.39 1542046652, 0, 0, 36.747054, -122.051402, 304.9, 635.48 1542047153, 0, 0, 36.747043, -122.051483, 215.3, 636.60 1542047653, 0, 0, 36.747031, -122.051462, 217.8, 636.65 1542048153, 0, 0, 36.747015, -122.051475, 220.3, 636.72 1542048653, 0, 0, 36.747037, -122.051474, 259.4, 637.59 1542049153, 0, 0, 36.747096, -122.051506, 230.9, 637.83 1542049653, 0, 0, 36.747091, -122.051517, 219.8, 637.87 1542050153, 0, 0, 36.747052, -122.051459, 195.4, 632.66 1542050653, 0, 0, 36.747028, -122.051443, 233.4, 634.17 1542051153, 0, 0, 36.746968, -122.051451, 254.2, 634.06 1542051653, 0, 0, 36.746993, -122.051461, 259.6, 634.15 1542052154, 0, 0, 36.746948, -122.051484, 235.1, 633.88 1542052654, 0, 0, 36.746851, -122.051516, 238.4, 633.10 1542053154, 0, 0, 36.746791, -122.051499, 235.9, 633.03 1542053654, 0, 0, 36.746786, -122.051525, 237.3, 633.01 1542054154, 0, 0, 36.746768, -122.051580, 129.5, 633.88 1542054654, 0, 0, 36.746768, -122.051564, 109.7, 633.76 1542055154, 0, 0, 36.746747, -122.051655, 250.9, 633.90 1542055654, 0, 0, 36.746713, -122.051985, 309.5, 644.90 1542056154, 0, 0, 36.746705, -122.051983, 346.2, 644.98 1542056654, 0, 0, 36.746905, -122.051941, 81.7, 644.49 1542057154, 0, 0, 36.746904, -122.051939, 83.7, 644.47 1542057655, 0, 0, 36.746887, -122.051955, 86.0, 644.37 1542058155, 0, 0, 36.746874, -122.051739, 120.9, 637.78 1542058655, 0, 0, 36.746815, -122.051690, 91.5, 634.78 1542059155, 0, 0, 36.746818, -122.051522, 91.6, 633.35 1542059655, 0, 0, 36.746737, -122.051253, 163.3, 634.88 1542060155, 0, 0, 36.746938, -122.051236, 276.3, 636.42 1542060655, 0, 0, 36.746809, -122.051745, 280.9, 626.11 1542061155, 0, 0, 36.746816, -122.052318, 261.7, 443.15 1542061655, 0, 0, 36.746918, -122.052919, 243.4, 273.50 1542062156, 0, 0, 36.746135, -122.052928, 203.1, 109.32 rovNav(): 316: 19851 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018316vntaedited.txt 19851 in tList 19851 in {self->{rovT}} 19851 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1542054195 & 1542058440 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 628.496340699788 rovGDCListRefs(): dStats->sample_range = 636.701597857988 rovGDCListRefs(): returning (1st elframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/316/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/316/accesses.txt at bin\geopdvc_perseus.pl line 629. ements): 1542041914 36.746799 -122.051767 185.5 2.58077334882109 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74689000 hash{lon} = -122.05151000 latMin = 30.74689 latMax = 42.74689 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.74689 AND 42.74689 AND Longitude BETWEEN -128.05151 AND -116.05151 Dive lat = 36.74689000, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05151000 & lat = 36.74689000 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4161rov_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/vnta4161lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2322 shipNav(): $#{$self->{shipLat}}[last] = 36.756512 Position subsampling set to 16 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 19852 makeTracks(): Looping through 2322 point of ship position data... makeTracks(): posSubsample = 16 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4161tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4161mergedCtdNav.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/12/2018 4:58:34 PM' AND '11/12/2018 10:41:48 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/12/2018 4:58:34 PM' AND '11/12/2018 10:41:48 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/vnta4161... 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/12/2018 4:58:34 PM' AND '11/12/2018 10:41:48 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2018/vnta/vnta4161.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6440,'/3Dreplay/3D.asp?dives=vnta4161','vnta4161','','','',4161 Executing sql: UPDATE Dive SET DiveLatMid = 36.7469, DiveLonMid = -122.0515, DiveDepthMid = -628.5 WHERE RovName = 'vnta' AND DiveNumber = 4161