Running bin\geopdvc_perseus.pl at Thu Jan 9 03:00:02 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4232 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4232 and rname = vnta set_expd(): rov = vnta, diveno = 4232 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 = 4232 AND RovName = 'vnta' RS->Fields(0)->Value= 6776 RS->Fields(1)->Value= 1573491924 RS->Fields(2)->Value= 1573511269 RS->Fields(3)->Value= 11/11/2019 5:05:24 PM RS->Fields(4)->Value= 11/11/2019 10:27:49 PM set_expd(): $self->{EndDDD} = 315 set_expd(): $self->{StartEsecs} = 1573490724 set_expd(): $self->{EndEsecs} = 1573512469 set_expd(): $self->{EndDtg} = 11/11/2019 10:27:49 PM _readLogr(): Reading videologr data from 2019315datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1573490724 & 1573512469 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1573512474, self->{EndEsecs} = 1573512469 _readLogr(): #LOGHOST_SYSTEM_UTC = 2173 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1573490733 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1573512464 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1573490733 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1573512464 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1573490604, Refined EndEsecs = 1573512589 _readLogr(): Reading videologr data from 2019315datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1573490604 & 1573512589 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1573512594, self->{EndEsecs} = 1573512589 _readLogr(): #LOGHOST_SYSTEM_UTC = 2197 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1573490613 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1573512584 bin\geopdvc_perseus.pl: expdid = 6776 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): getRaw = 1 rovnavCTDO(): calcUTM = 0 rovNav(): 1, getRaw = 1 rovNav(): 2, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 315 (looping to 315) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019315vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019315vnta.txt esecs, east, north, lat, lon, head, pres 1573492424, 0, 0, 36.699272, -122.052323, 115.4, 95.49 1573492924, 0, 0, 36.699470, -122.051808, 47.8, 100.98 1573493424, 0, 0, 36.700098, -122.050700, 41.4, 96.81 1573493925, 0, 0, 36.698582, -122.049610, 14.5, 94.11 1573494425, 0, 0, 36.699662, -122.050205, -111.7, 102.99 1573494925, 0, 0, 36.701162, -122.051118, 16.2, 103.67 1573495425, 0, 0, 36.700492, -122.051467, -154.4, 110.22 1573495925, 0, 0, 36.700688, -122.051700, -142.5, 125.92 1573496425, 0, 0, 36.700718, -122.051630, -142.4, 135.43 1573496925, 0, 0, 36.700483, -122.051915, -121.0, 151.10 1573497425, 0, 0, 36.700742, -122.052123, 0.6, 175.91 1573497925, 0, 0, 36.700707, -122.051795, 7.0, 177.99 1573498425, 0, 0, 36.700725, -122.051698, -17.3, 186.12 1573498926, 0, 0, 36.700798, -122.051603, -91.4, 174.50 1573499426, 0, 0, 36.700682, -122.051575, -141.3, 201.13 1573499926, 0, 0, 36.700962, -122.051437, -3.5, 212.30 1573500426, 0, 0, 36.701238, -122.051180, -1.1, 218.69 1573500926, 0, 0, 36.701178, -122.051272, -41.3, 224.56 1573501426, 0, 0, 36.701635, -122.051243, -24.5, 243.49 1573501926, 0, 0, 36.701058, -122.051848, -113.8, 303.03 1573502426, 0, 0, 36.701230, -122.051973, -69.0, 297.40 1573502926, 0, 0, 36.700937, -122.052358, -140.3, 354.54 1573503426, 0, 0, 36.700957, -122.052503, -73.2, 378.03 1573503927, 0, 0, 36.701322, -122.052497, -63.8, 387.28 1573504427, 0, 0, 36.701477, -122.052678, -40.8, 386.65 1573504927, 0, 0, 36.701113, -122.052492, -149.6, 402.39 1573505427, 0, 0, 36.700995, -122.052265, -38.2, 409.72 1573505927, 0, 0, 36.701162, -122.052030, -23.0, 410.28 1573506427, 0, 0, 36.701352, -122.051895, -13.3, 401.93 1573506927, 0, 0, 36.702032, -122.052005, -27.1, 384.22 1573507427, 0, 0, 36.702603, -122.052047, -25.0, 343.15 1573507927, 0, 0, 36.703327, -122.051805, -0.6, 285.49 1573508428, 0, 0, 36.703267, -122.052118, -146.8, 243.70 1573508928, 0, 0, 36.704193, -122.053050, -36.0, 177.62 1573509428, 0, 0, 36.704800, -122.053428, -35.9, 139.86 1573509928, 0, 0, 36.705178, -122.053545, -85.1, 103.86 1573510428, 0, 0, 36.698330, -122.046755, -85.9, 15.11 1573510928, 0, 0, 36.701772, -122.052662, -85.8, 9.85 rovNav(): 315: 19340 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019315vnta.txt 19340 in tList 19340 in {self->{rovT}} 19340 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1573492860 & 1573501155 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 187.418684437959 rovGDCListRefs(): dStats->sample_range = 409.067689892236 rovGDCListRefs(): returning (1st elements): 1573491925 36.746308 -122.103205 73.5 2.68003332415794 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 315 (looping to 315) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019315vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019315vntaedited.txt esecs, east, north, lat, lon, head, pres 1573492424, 0, 0, 36.699276, -122.052337, 115.4, 95.49 1573492924, 0, 0, 36.699470, -122.051814, 47.8, 100.98 1573493424, 0, 0, 36.700106, -122.050984, 41.4, 96.81 1573493925, 0, 0, 36.700697, -122.050855, 14.5, 94.11 1573494425, 0, 0, 36.700957, -122.050578, 248.3, 102.99 1573494925, 0, 0, 36.701150, -122.051074, 16.2, 103.67 1573495425, 0, 0, 36.700499, -122.051484, 205.6, 110.22 1573495925, 0, 0, 36.700657, -122.051669, 217.5, 125.92 1573496425, 0, 0, 36.700691, -122.051648, 217.6, 135.43 1573496925, 0, 0, 36.700473, -122.051876, 239.0, 151.10 1573497425, 0, 0, 36.700673, -122.051908, 0.6, 175.91 1573497925, 0, 0, 36.700723, -122.051771, 7.0, 177.99 1573498425, 0, 0, 36.700733, -122.051700, 342.7, 186.12 1573498926, 0, 0, 36.700810, -122.051533, 268.6, 174.50 1573499426, 0, 0, 36.700680, -122.051568, 218.7, 201.13 1573499926, 0, 0, 36.700972, -122.051421, 356.5, 212.30 1573500426, 0, 0, 36.701231, -122.051221, 358.9, 218.69 1573500926, 0, 0, 36.701220, -122.051241, 318.7, 224.56 1573501426, 0, 0, 36.701631, -122.051264, 335.5, 243.49 1573501926, 0, 0, 36.701057, -122.051846, 246.2, 303.03 1573502426, 0, 0, 36.701229, -122.051961, 291.0, 297.40 1573502926, 0, 0, 36.700962, -122.052281, 219.7, 354.54 1573503426, 0, 0, 36.700975, -122.052485, 286.8, 378.03 1573503927, 0, 0, 36.701312, -122.052772, 296.2, 387.28 1573504427, 0, 0, 36.701502, -122.052654, 319.2, 386.65 1573504927, 0, 0, 36.701124, -122.052485, 210.4, 402.39 1573505427, 0, 0, 36.701006, -122.052263, 321.8, 409.72 1573505927, 0, 0, 36.701124, -122.051987, 337.0, 410.28 1573506427, 0, 0, 36.701354, -122.051898, 346.7, 401.93 1573506927, 0, 0, 36.702013, -122.051984, 332.9, 384.22 1573507427, 0, 0, 36.702643, -122.052062, 335.0, 343.15 1573507927, 0, 0, 36.703295, -122.051854, 359.4, 285.49 1573508428, 0, 0, 36.703271, -122.052129, 213.2, 243.70 1573508928, 0, 0, 36.704208, -122.053034, 324.0, 177.62 1573509428, 0, 0, 36.704786, -122.053463, 324.1, 139.86 1573509928, 0, 0, 36.705184, -122.053488, 274.9, 103.86 1573510428, 0, 0, 36.705138, -122.053441, 274.1, 15.11 1573510928, 0, 0, 36.705138, -122.053441, 274.2, 9.85 rovNav(): 315: 19340 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019315vntaedited.txt 19340 in tList 19340 in {self->{rovT}} 19340 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1573494075 & 1573500270 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 187.418684852199 rovGDCListRefs(): dStats->sample_range = 409.067689628969 rovGDCListRefs(): returning (1st elements): 1573491925 36.699112 -122.052563 73.5 2.68004450923156 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70107400 hash{lon} = -122.05193000 latMin = 30.701074 latMax = 42.701074 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.701074 AND 42.701074 AND Longitude BETWEEN -128.05193 AND -116.05193 Dive lat = 36.70107400, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05193000 & lat = 36.70107400 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4232rov_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 frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/315/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/315/accesses.txt at bin\geopdvc_perseus.pl line 629. = .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/vnta4232lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2197 shipNav(): $#{$self->{shipLat}}[last] = 36.716190 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 = 19341 makeTracks(): Looping through 2197 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4232tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4232mergedCtdNav.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/11/2019 5:05:24 PM' AND '11/11/2019 10:27:49 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/11/2019 5:05:24 PM' AND '11/11/2019 10:27:49 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/vnta4232... 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/11/2019 5:05:24 PM' AND '11/11/2019 10:27:49 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4232.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6776,'/3Dreplay/3D.asp?dives=vnta4232','vnta4232','','','',4232 Executing sql: UPDATE Dive SET DiveLatMid = 36.7011, DiveLonMid = -122.0519, DiveDepthMid = -187.4 WHERE RovName = 'vnta' AND DiveNumber = 4232