Running bin\geopdvc_perseus.pl at Wed Jul 24 17:00:30 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4187 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4187 and rname = vnta set_expd(): rov = vnta, diveno = 4187 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 = 4187 AND RovName = 'vnta' RS->Fields(0)->Value= 6583 RS->Fields(1)->Value= 1554743196 RS->Fields(2)->Value= 1554759305 RS->Fields(3)->Value= 4/8/2019 5:06:36 PM RS->Fields(4)->Value= 4/8/2019 9:35:05 PM set_expd(): $self->{EndDDD} = 098 set_expd(): $self->{StartEsecs} = 1554741996 set_expd(): $self->{EndEsecs} = 1554760505 set_expd(): $self->{EndDtg} = 4/8/2019 9:35:05 PM _readLogr(): Reading videologr data from 2019098datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1554741996 & 1554760505 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1554760510, self->{EndEsecs} = 1554760505 _readLogr(): #LOGHOST_SYSTEM_UTC = 1850 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1554742000 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1554760500 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1554742000 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1554760500 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1554741876, Refined EndEsecs = 1554760625 _readLogr(): Reading videologr data from 2019098datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1554741876 & 1554760625 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1554760631, self->{EndEsecs} = 1554760625 _readLogr(): #LOGHOST_SYSTEM_UTC = 1874 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1554741880 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1554760621 bin\geopdvc_perseus.pl: expdid = 6583 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 = 098 (looping to 098) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019098vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019098vnta.txt esecs, east, north, lat, lon, head, pres 1554743696, 0, 0, 36.698272, -122.042012, 84.8, 25.39 1554744197, 0, 0, 36.696700, -122.039997, 84.1, 25.25 1554744697, 0, 0, 36.698127, -122.039212, -6.2, 51.22 1554745197, 0, 0, 36.699813, -122.039818, 80.9, 100.97 1554745697, 0, 0, 36.699407, -122.039413, 79.0, 101.29 1554746197, 0, 0, 36.699898, -122.036160, 78.7, 101.28 1554746697, 0, 0, 36.699620, -122.037962, -91.3, 201.33 1554747197, 0, 0, 36.699502, -122.040778, -92.0, 236.58 1554747697, 0, 0, 36.697817, -122.040283, 159.1, 302.41 1554748197, 0, 0, 36.696223, -122.039733, 41.1, 387.57 1554748697, 0, 0, 36.697813, -122.038218, 36.7, 403.52 1554749197, 0, 0, 36.697962, -122.037815, -156.1, 504.64 1554749698, 0, 0, 36.695245, -122.039335, -155.9, 504.69 1554750198, 0, 0, 36.695547, -122.039042, 37.6, 605.97 1554750698, 0, 0, 36.697427, -122.037168, 32.1, 611.53 1554751198, 0, 0, 36.698333, -122.033350, -39.6, 707.03 1554751698, 0, 0, 36.699813, -122.039853, 160.6, 774.18 1554752198, 0, 0, 36.697747, -122.038977, 167.5, 808.26 1554752698, 0, 0, 36.696463, -122.038635, 32.8, 908.99 1554753198, 0, 0, 36.698715, -122.036857, 32.1, 909.01 1554753698, 0, 0, 36.698678, -122.036388, 163.2, 1009.93 1554754198, 0, 0, 36.696293, -122.035272, 161.3, 1009.79 1554754699, 0, 0, 36.696815, -122.036858, -45.8, 958.14 1554755199, 0, 0, 36.697868, -122.038427, -61.6, 873.43 1554755699, 0, 0, 36.697817, -122.039298, -47.3, 753.95 1554756199, 0, 0, 36.698143, -122.040218, -46.4, 639.74 1554756699, 0, 0, 36.698328, -122.040437, -47.0, 517.69 1554757199, 0, 0, 36.698365, -122.040470, -46.6, 388.46 1554757699, 0, 0, 36.697912, -122.040247, -46.1, 286.97 1554758199, 0, 0, 36.697453, -122.039485, -51.7, 179.57 1554758699, 0, 0, 36.697195, -122.039162, -51.7, 59.90 1554759199, 0, 0, 36.696202, -122.039055, -51.4, 9.70 rovNav(): 098: 16104 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019098vnta.txt 16104 in tList 16104 in {self->{rovT}} 16104 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1554745905 & 1554757425 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 433.827372864397 rovGDCListRefs(): dStats->sample_range = 997.791488369581 rovGDCListRefs(): returning (1st elements): 1554743197 36.803042 -121.786132 -4.9 2.58076050643669 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 098 (looping to 098) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019098vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019098vntaedited.txt esecs, east, north, lat, lon, head, pres 1554743696, 0, 0, 36.698263, -122.041972, 84.8, 25.39 1554744197, 0, 0, 36.697250, -122.039481, 84.1, 25.25 1554744697, 0, 0, 36.698056, -122.039284, 353.8, 51.22 1554745197, 0, 0, 36.699692, -122.039976, 80.9, 100.97 1554745697, 0, 0, 36.699470, -122.039351, 79.0, 101.29 1554746197, 0, 0, 36.699883, -122.036372, 78.7, 101.28 1554746697, 0, 0, 36.699621, -122.037995, 268.7, 201.33 1554747197, 0, 0, 36.699514, -122.040754, 268.0, 236.58 1554747697, 0, 0, 36.697797, -122.040258, 159.1, 302.41 1554748197, 0, 0, 36.696267, -122.039711, 41.1, 387.57 1554748697, 0, 0, 36.697818, -122.038210, 36.7, 403.52 1554749197, 0, 0, 36.697917, -122.037828, 203.9, 504.64 1554749698, 0, 0, 36.695222, -122.039327, 204.1, 504.69 1554750198, 0, 0, 36.695539, -122.039052, 37.6, 605.97 1554750698, 0, 0, 36.697442, -122.037151, 32.1, 611.53 1554751198, 0, 0, 36.698415, -122.038251, 320.4, 707.03 1554751698, 0, 0, 36.699881, -122.039733, 160.6, 774.18 1554752198, 0, 0, 36.697745, -122.038988, 167.5, 808.26 1554752698, 0, 0, 36.696533, -122.038616, 32.8, 908.99 1554753198, 0, 0, 36.698757, -122.036826, 32.1, 909.01 1554753698, 0, 0, 36.698794, -122.036272, 163.2, 1009.93 1554754198, 0, 0, 36.696262, -122.035248, 161.3, 1009.79 1554754699, 0, 0, 36.696916, -122.036786, 314.2, 958.14 1554755199, 0, 0, 36.697968, -122.038349, 298.4, 873.43 1554755699, 0, 0, 36.697880, -122.039319, 312.7, 753.95 1554756199, 0, 0, 36.698300, -122.040188, 313.6, 639.74 1554756699, 0, 0, 36.698305, -122.040518, 313.0, 517.69 1554757199, 0, 0, 36.698357, -122.040427, 313.4, 388.46 1554757699, 0, 0, 36.697886, -122.040291, 313.9, 286.97 1554758199, 0, 0, 36.697443, -122.039465, 308.3, 179.57 1554758699, 0, 0, 36.697197, -122.039107, 308.3, 59.90 1554759199, 0, 0, 36.696186, -122.039045, 308.6, 9.70 rovNav(): 098: 16104 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019098vntaedited.txt 16104 in tList 16104 in {self->{rovT}} 16104 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1554754995 & 1554758310 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 433.82737328626 rovGDCListRefs(): dStats->sample_range = 997.791467076619 rovGDCListRefs(): returning (1st elements): 1554743197 36.699308 -122.042010 355.1 2.58078418699729 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69801100 hash{lon} = -122.03919500 latMin = 30.698011 latMax = 42.698011 Executing sql: SELECT Area, Latitude, Longitude FRframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/098/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/098/accesses.txt at bin\geopdvc_perseus.pl line 629. OM GeoOrigin WHERE Latitude BETWEEN 30.698011 AND 42.698011 AND Longitude BETWEEN -128.039195 AND -116.039195 Dive lat = 36.69801100, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.03919500 & lat = 36.69801100 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4187rov_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/vnta4187lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1874 shipNav(): $#{$self->{shipLat}}[last] = 36.711473 Position subsampling set to 13 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 = 16105 makeTracks(): Looping through 1874 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4187tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4187mergedCtdNav.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 '4/8/2019 5:06:36 PM' AND '4/8/2019 9:35:05 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '4/8/2019 5:06:36 PM' AND '4/8/2019 9:35:05 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/vnta4187... 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 '4/8/2019 5:06:36 PM' AND '4/8/2019 9:35:05 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4187.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6583,'/3Dreplay/3D.asp?dives=vnta4187','vnta4187','','','',4187 Executing sql: UPDATE Dive SET DiveLatMid = 36.6980, DiveLonMid = -122.0392, DiveDepthMid = -433.8 WHERE RovName = 'vnta' AND DiveNumber = 4187