Running bin\geopdvc_perseus.pl at Fri Dec 20 03:00:02 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4227 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4227 and rname = vnta set_expd(): rov = vnta, diveno = 4227 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 = 4227 AND RovName = 'vnta' RS->Fields(0)->Value= 6757 RS->Fields(1)->Value= 1571762870 RS->Fields(2)->Value= 1571777933 RS->Fields(3)->Value= 10/22/2019 4:47:50 PM RS->Fields(4)->Value= 10/22/2019 8:58:53 PM set_expd(): $self->{EndDDD} = 295 set_expd(): $self->{StartEsecs} = 1571761670 set_expd(): $self->{EndEsecs} = 1571779133 set_expd(): $self->{EndDtg} = 10/22/2019 8:58:53 PM _readLogr(): Reading videologr data from 2019295datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1571761670 & 1571779133 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1571779139, self->{EndEsecs} = 1571779133 _readLogr(): #LOGHOST_SYSTEM_UTC = 1745 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1571761678 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1571779129 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1571761678 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1571779129 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1571761550, Refined EndEsecs = 1571779253 _readLogr(): Reading videologr data from 2019295datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1571761550 & 1571779253 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1571779259, self->{EndEsecs} = 1571779253 _readLogr(): #LOGHOST_SYSTEM_UTC = 1769 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1571761558 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1571779249 bin\geopdvc_perseus.pl: expdid = 6757 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, getRaw = 1 rovNav(): 2, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 295 (looping to 295) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019295vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019295vnta.txt esecs, east, north, lat, lon, head, pres 1571763884, 0, 0, 36.747965, -122.106107, 23.2, 95.60 1571764384, 0, 0, 36.748778, -122.105953, 161.3, 181.69 1571764885, 0, 0, 36.747587, -122.105490, 160.6, 379.72 1571765385, 0, 0, 36.747312, -122.105530, -164.2, 458.37 1571765885, 0, 0, 36.747070, -122.106178, -177.2, 577.66 1571766385, 0, 0, 36.746917, -122.106835, 179.2, 648.83 1571766885, 0, 0, 36.747102, -122.107365, 170.9, 614.71 1571767385, 0, 0, 36.746837, -122.107768, 179.3, 570.64 1571767885, 0, 0, 36.746530, -122.108518, 134.3, 532.29 1571768385, 0, 0, 36.746070, -122.108430, -167.0, 499.95 1571768885, 0, 0, 36.746233, -122.109022, 13.9, 483.96 1571769385, 0, 0, 36.746120, -122.108675, -134.6, 458.27 1571769886, 0, 0, 36.745938, -122.108452, 128.4, 444.22 1571770386, 0, 0, 36.745972, -122.107597, 153.5, 430.14 1571770886, 0, 0, 36.745752, -122.106532, 135.2, 401.30 1571771386, 0, 0, 36.745205, -122.105502, 87.6, 407.91 1571771886, 0, 0, 36.745545, -122.104640, 12.1, 432.00 1571772386, 0, 0, 36.747310, -122.105778, -3.4, 453.50 1571772886, 0, 0, 36.748540, -122.106570, -23.3, 442.74 1571773386, 0, 0, 36.749798, -122.107460, 42.2, 433.62 1571773886, 0, 0, 36.749122, -122.107653, -177.1, 423.10 1571774386, 0, 0, 36.748053, -122.108133, -174.6, 407.30 1571774887, 0, 0, 36.746972, -122.108647, -174.0, 401.06 1571775387, 0, 0, 36.745740, -122.109147, -173.5, 403.72 1571775887, 0, 0, 36.744355, -122.109620, -173.5, 412.99 1571776387, 0, 0, 36.744318, -122.110647, -37.9, 369.55 1571776887, 0, 0, 36.744773, -122.110988, -37.7, 164.45 1571777387, 0, 0, 36.745053, -122.110990, -81.3, 8.66 1571777887, 0, 0, 36.745523, -122.110663, -123.2, 8.62 rovNav(): 295: 14545 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019295vnta.txt 14545 in tList 14545 in {self->{rovT}} 14545 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1571777235 & 1571774460 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 422.424514285199 rovGDCListRefs(): dStats->sample_range = 642.351655081062 rovGDCListRefs(): returning (1st elements): 1571762870 36.747913 -122.107848 -37.9 2.5807730945253 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 295 (looping to 295) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019295vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019295vntaedited.txt esecs, east, north, lat, lon, head, pres 1571763884, 0, 0, 36.747965, -122.106109, 23.2, 95.60 1571764384, 0, 0, 36.748750, -122.105921, 161.3, 181.69 1571764885, 0, 0, 36.747704, -122.105500, 160.6, 379.72 1571765385, 0, 0, 36.747317, -122.105521, 195.8, 458.37 1571765885, 0, 0, 36.747070, -122.106185, 182.8, 577.66 1571766385, 0, 0, 36.746926, -122.106835, 179.2, 648.83 1571766885, 0, 0, 36.747105, -122.107358, 170.9, 614.71 1571767385, 0, 0, 36.746813, -122.107776, 179.3, 570.64 1571767885, 0, 0, 36.746520, -122.108527, 134.3, 532.29 1571768385, 0, 0, 36.746068, -122.108443, 193.0, 499.95 1571768885, 0, 0, 36.746232, -122.109019, 13.9, 483.96 1571769385, 0, 0, 36.746128, -122.108692, 225.4, 458.27 1571769886, 0, 0, 36.745948, -122.108426, 128.4, 444.22 1571770386, 0, 0, 36.745965, -122.107599, 153.5, 430.14 1571770886, 0, 0, 36.745748, -122.106532, 135.2, 401.30 1571771386, 0, 0, 36.745202, -122.105496, 87.6, 407.91 1571771886, 0, 0, 36.745540, -122.104612, 12.1, 432.00 1571772386, 0, 0, 36.747315, -122.105778, 356.6, 453.50 1571772886, 0, 0, 36.748554, -122.106595, 336.7, 442.74 1571773386, 0, 0, 36.750039, -122.107246, 42.2, 433.62 1571773886, 0, 0, 36.749096, -122.107662, 182.9, 423.10 1571774386, 0, 0, 36.748022, -122.108167, 185.4, 407.30 1571774887, 0, 0, 36.746948, -122.108651, 186.0, 401.06 1571775387, 0, 0, 36.745740, -122.109132, 186.5, 403.72 1571775887, 0, 0, 36.744346, -122.109633, 186.5, 412.99 1571776387, 0, 0, 36.744311, -122.110654, 322.1, 369.55 1571776887, 0, 0, 36.744664, -122.111062, 322.3, 164.45 1571777387, 0, 0, 36.745060, -122.110960, 278.7, 8.66 1571777887, 0, 0, 36.745520, -122.110663, 236.8, 8.62 rovNav(): 295: 14545 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019295vntaedited.txt 14545 in tList 14545 in {self->{rovT}} 14545 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1571774010 & 1571776440 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/295/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/295/accesses.txt at bin\geopdvc_perseus.pl line 629. .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 422.424514098391 rovGDCListRefs(): dStats->sample_range = 642.351654057527 rovGDCListRefs(): returning (1st elements): 1571762870 36.747927 -122.107798 322.1 2.58077309132946 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74657400 hash{lon} = -122.10760600 latMin = 30.746574 latMax = 42.746574 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.746574 AND 42.746574 AND Longitude BETWEEN -128.107606 AND -116.107606 Dive lat = 36.74657400, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.10760600 & lat = 36.74657400 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4227rov_orig.wrl Making color lookup world... var = Light, vmin = 40, vmax = 100 val = 40, color = .8 .7 0 val = 70, color = .6 .5 0 val = 85, color = .1 .1 0 val = 100, color = 1 1 1 var = O2, vmin = 0.2, vmax = 5 val = 0.2, color = 1 1 1 val = 0.3, color = 1 1 .2 val = 0.5, color = 1 1 0 val = 0.7, color = 0 1 0 val = 5, color = 0 0 1 var = Sal, vmin = 33, vmax = 35 val = 33, color = 1 1 .1 val = 33.5, color = 1 1 0 val = 34, color = 1 0 0 val = 34.5, color = .2 1 0 val = 35, color = 0 1 0 var = Temp, vmin = 4, vmax = 15 val = 4, color = 0 0 1 val = 8, color = 1 1 0 val = 10, color = 0 1 0 val = 15, color = 1 0 0 World = geo2019/vnta/vnta4227lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1769 shipNav(): $#{$self->{shipLat}}[last] = 36.752050 Position subsampling set to 12 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 = 14546 makeTracks(): Looping through 1769 point of ship position data... makeTracks(): posSubsample = 12 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4227tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4227mergedCtdNav.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 '10/22/2019 4:47:50 PM' AND '10/22/2019 8:58:53 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/22/2019 4:47:50 PM' AND '10/22/2019 8:58:53 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/vnta4227... 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 '10/22/2019 4:47:50 PM' AND '10/22/2019 8:58:53 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4227.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6757,'/3Dreplay/3D.asp?dives=vnta4227','vnta4227','','','',4227 Executing sql: UPDATE Dive SET DiveLatMid = 36.7466, DiveLonMid = -122.1076, DiveDepthMid = -422.4 WHERE RovName = 'vnta' AND DiveNumber = 4227