Running bin\geopdvc_perseus.pl at Wed Jul 24 16:55:27 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4175 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4175 and rname = vnta set_expd(): rov = vnta, diveno = 4175 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 = 4175 AND RovName = 'vnta' RS->Fields(0)->Value= 6528 RS->Fields(1)->Value= 1548953558 RS->Fields(2)->Value= 1548968095 RS->Fields(3)->Value= 1/31/2019 4:52:38 PM RS->Fields(4)->Value= 1/31/2019 8:54:55 PM set_expd(): $self->{EndDDD} = 031 set_expd(): $self->{StartEsecs} = 1548952358 set_expd(): $self->{EndEsecs} = 1548969295 set_expd(): $self->{EndDtg} = 1/31/2019 8:54:55 PM _readLogr(): Reading videologr data from 2019031datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1548952358 & 1548969295 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1548969302, self->{EndEsecs} = 1548969295 _readLogr(): #LOGHOST_SYSTEM_UTC = 1693 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1548952361 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1548969292 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1548952361 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1548969292 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1548952238, Refined EndEsecs = 1548969415 _readLogr(): Reading videologr data from 2019031datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1548952238 & 1548969415 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1548969422, self->{EndEsecs} = 1548969415 _readLogr(): #LOGHOST_SYSTEM_UTC = 1717 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1548952241 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1548969412 bin\geopdvc_perseus.pl: expdid = 6528 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 = 031 (looping to 031) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019031vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019031vnta.txt esecs, east, north, lat, lon, head, pres 1548954057, 0, 0, 36.711793, -122.188345, 71.9, 148.84 1548954557, 0, 0, 36.712813, -122.188863, 89.5, 336.28 1548955057, 0, 0, 36.713112, -122.188832, 115.9, 519.80 1548955557, 0, 0, 36.713168, -122.188413, 113.9, 687.57 1548956057, 0, 0, 36.712877, -122.188585, 117.1, 818.08 1548956557, 0, 0, 36.712482, -122.188237, 93.1, 884.02 1548957057, 0, 0, 36.712510, -122.187037, 93.6, 885.31 1548957558, 0, 0, 36.712465, -122.186787, 91.9, 886.79 1548958058, 0, 0, 36.712468, -122.186775, 70.5, 887.38 1548958558, 0, 0, 36.712623, -122.187797, 79.3, 872.92 1548959058, 0, 0, 36.712473, -122.186798, 58.2, 887.31 1548959558, 0, 0, 36.712462, -122.186822, 103.3, 887.19 1548960058, 0, 0, 36.712508, -122.186758, 83.2, 887.12 1548960558, 0, 0, 36.712453, -122.186833, 97.9, 887.09 1548961058, 0, 0, 36.712518, -122.187460, 91.4, 881.99 1548961559, 0, 0, 36.712423, -122.186800, 113.2, 886.70 1548962059, 0, 0, 36.712438, -122.186317, 104.2, 883.74 1548962559, 0, 0, 36.712462, -122.186425, -81.7, 884.02 1548963059, 0, 0, 36.712103, -122.187042, 7.1, 888.63 1548963559, 0, 0, 36.712377, -122.186820, 67.8, 884.46 1548964059, 0, 0, 36.712132, -122.187022, 78.9, 888.38 1548964559, 0, 0, 36.712505, -122.187328, -73.4, 886.51 1548965060, 0, 0, 36.712485, -122.186747, -83.9, 878.17 1548965560, 0, 0, 36.713770, -122.188643, -56.9, 728.93 1548966060, 0, 0, 36.714248, -122.190527, -14.9, 541.57 1548966560, 0, 0, 36.714450, -122.191517, -21.2, 259.25 1548967060, 0, 0, 36.717023, -122.193472, -36.1, 86.46 1548967560, 0, 0, 36.717440, -122.195735, 7.7, 10.74 1548968060, 0, 0, 36.717265, -122.198068, 9.5, 10.76 rovNav(): 031: 14534 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019031vnta.txt 14534 in tList 14534 in {self->{rovT}} 14534 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1548966930 & 1548967965 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 875.219212966461 rovGDCListRefs(): dStats->sample_range = 877.758561828488 rovGDCListRefs(): returning (1st elements): 1548953558 36.753415 -122.213823 -26.7 2.68003163938325 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 031 (looping to 031) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019031vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019031vntaedited.txt esecs, east, north, lat, lon, head, pres 1548954057, 0, 0, 36.711816, -122.188345, 71.9, 148.84 1548954557, 0, 0, 36.712805, -122.188878, 89.5, 336.28 1548955057, 0, 0, 36.713123, -122.188820, 115.9, 519.80 1548955557, 0, 0, 36.713138, -122.188465, 113.9, 687.57 1548956057, 0, 0, 36.712871, -122.188588, 117.1, 818.08 1548956557, 0, 0, 36.712478, -122.188232, 93.1, 884.02 1548957057, 0, 0, 36.712514, -122.187042, 93.6, 885.31 1548957558, 0, 0, 36.712466, -122.186789, 91.9, 886.79 1548958058, 0, 0, 36.712476, -122.186772, 70.5, 887.38 1548958558, 0, 0, 36.712609, -122.187773, 79.3, 872.92 1548959058, 0, 0, 36.712468, -122.186805, 58.2, 887.31 1548959558, 0, 0, 36.712470, -122.186811, 103.3, 887.19 1548960058, 0, 0, 36.712502, -122.186812, 83.2, 887.12 1548960558, 0, 0, 36.712450, -122.186772, 97.9, 887.09 1548961058, 0, 0, 36.712521, -122.187447, 91.4, 881.99 1548961559, 0, 0, 36.712450, -122.186804, 113.2, 886.70 1548962059, 0, 0, 36.712430, -122.186346, 104.2, 883.74 1548962559, 0, 0, 36.712472, -122.186437, 278.3, 884.02 1548963059, 0, 0, 36.712091, -122.187032, 7.1, 888.63 1548963559, 0, 0, 36.712389, -122.186804, 67.8, 884.46 1548964059, 0, 0, 36.712120, -122.187021, 78.9, 888.38 1548964559, 0, 0, 36.712505, -122.187356, 286.6, 886.51 1548965060, 0, 0, 36.712499, -122.186758, 276.1, 878.17 1548965560, 0, 0, 36.713749, -122.188690, 303.1, 728.93 1548966060, 0, 0, 36.714270, -122.190460, 345.1, 541.57 1548966560, 0, 0, 36.714468, -122.191460, 338.8, 259.25 1548967060, 0, 0, 36.717027, -122.193518, 323.9, 86.46 1548967560, 0, 0, 36.717419, -122.195732, 7.7, 10.74 1548968060, 0, 0, 36.717255, -122.198109, 9.5, 10.76 rovNav(): 031: 14534 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019031vntaedited.txt 14534 in tList 14534 in {self->{rovT}} 14534 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1548960765 & 1548960180 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/031/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/031/accesses.txt at bin\geopdvc_perseus.pl line 629. .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 875.21921257957 rovGDCListRefs(): dStats->sample_range = 877.758553607351 rovGDCListRefs(): returning (1st elements): 1548953558 36.711843 -122.187496 333.3 2.68004149262489 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.71248700 hash{lon} = -122.18730100 latMin = 30.712487 latMax = 42.712487 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.712487 AND 42.712487 AND Longitude BETWEEN -128.187301 AND -116.187301 Dive lat = 36.71248700, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.18730100 & lat = 36.71248700 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4175rov_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/vnta4175lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1717 shipNav(): $#{$self->{shipLat}}[last] = 36.712635 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 = 14535 makeTracks(): Looping through 1717 point of ship position data... makeTracks(): posSubsample = 12 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4175tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4175mergedCtdNav.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 '1/31/2019 4:52:38 PM' AND '1/31/2019 8:54:55 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '1/31/2019 4:52:38 PM' AND '1/31/2019 8:54:55 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/vnta4175... 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 '1/31/2019 4:52:38 PM' AND '1/31/2019 8:54:55 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4175.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6528,'/3Dreplay/3D.asp?dives=vnta4175','vnta4175','','','',4175 Executing sql: UPDATE Dive SET DiveLatMid = 36.7125, DiveLonMid = -122.1873, DiveDepthMid = -875.2 WHERE RovName = 'vnta' AND DiveNumber = 4175