Running bin\geopdvc_perseus.pl at Wed Jul 24 16:54:45 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4173 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4173 and rname = vnta set_expd(): rov = vnta, diveno = 4173 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 = 4173 AND RovName = 'vnta' RS->Fields(0)->Value= 6507 RS->Fields(1)->Value= 1548782629 RS->Fields(2)->Value= 1548798582 RS->Fields(3)->Value= 1/29/2019 5:23:49 PM RS->Fields(4)->Value= 1/29/2019 9:49:42 PM set_expd(): $self->{EndDDD} = 029 set_expd(): $self->{StartEsecs} = 1548781429 set_expd(): $self->{EndEsecs} = 1548799782 set_expd(): $self->{EndDtg} = 1/29/2019 9:49:42 PM _readLogr(): Reading videologr data from 2019029datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1548781429 & 1548799782 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1548799787, self->{EndEsecs} = 1548799782 _readLogr(): #LOGHOST_SYSTEM_UTC = 1834 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1548781437 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1548799777 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1548781437 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1548799777 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1548781309, Refined EndEsecs = 1548799902 _readLogr(): Reading videologr data from 2019029datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1548781309 & 1548799902 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1548799907, self->{EndEsecs} = 1548799902 _readLogr(): #LOGHOST_SYSTEM_UTC = 1858 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1548781317 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1548799897 bin\geopdvc_perseus.pl: expdid = 6507 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 = 029 (looping to 029) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019029vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019029vnta.txt esecs, east, north, lat, lon, head, pres 1548783130, 0, 0, 36.712585, -122.188673, 99.7, 161.63 1548783630, 0, 0, 36.712915, -122.189558, 106.2, 341.77 1548784130, 0, 0, 36.712788, -122.189285, 106.1, 522.28 1548784630, 0, 0, 36.712907, -122.189162, 100.5, 683.56 1548785130, 0, 0, 36.712838, -122.189270, 101.3, 780.16 1548785630, 0, 0, 36.712755, -122.189555, 88.0, 882.01 1548786130, 0, 0, 36.712607, -122.187217, 101.9, 885.05 1548786630, 0, 0, 36.712420, -122.186993, 39.9, 878.12 1548787131, 0, 0, 36.712485, -122.186743, -92.1, 886.47 1548787631, 0, 0, 36.712448, -122.186720, -90.8, 886.47 1548788131, 0, 0, 36.712468, -122.186733, -91.4, 886.50 1548788631, 0, 0, 36.712457, -122.186723, -94.1, 886.38 1548789131, 0, 0, 36.712448, -122.186723, -90.2, 885.47 1548789631, 0, 0, 36.712478, -122.186452, -90.1, 878.04 1548790131, 0, 0, 36.712403, -122.186267, -95.5, 885.47 1548790631, 0, 0, 36.712343, -122.186420, -142.5, 870.67 1548791131, 0, 0, 36.712273, -122.188588, -103.0, 840.33 1548791631, 0, 0, 36.711595, -122.188660, 171.9, 613.82 1548792132, 0, 0, 36.709807, -122.188853, 163.8, 502.62 1548792632, 0, 0, 36.707998, -122.187957, 171.1, 503.48 1548793132, 0, 0, 36.707902, -122.188967, 173.4, 403.70 1548793632, 0, 0, 36.705680, -122.189888, 177.4, 403.06 1548794132, 0, 0, 36.704513, -122.191243, -177.7, 302.67 1548794632, 0, 0, 36.702870, -122.192425, 96.0, 259.80 1548795132, 0, 0, 36.703723, -122.190460, 78.4, 232.27 1548795632, 0, 0, 36.704242, -122.190403, 136.6, 181.22 1548796133, 0, 0, 36.703800, -122.191577, 136.2, 101.16 1548796633, 0, 0, 36.702360, -122.191188, 135.4, 99.97 1548797133, 0, 0, 36.702808, -122.192630, 136.9, 73.09 1548797633, 0, 0, 36.703570, -122.193490, 137.0, 24.84 1548798133, 0, 0, 36.703640, -122.193377, 93.6, 13.11 rovNav(): 029: 15947 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019029vnta.txt 15947 in tList 15947 in {self->{rovT}} 15947 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1548797190 & 1548783930 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 501.774438483326 rovGDCListRefs(): dStats->sample_range = 876.928291426334 rovGDCListRefs(): returning (1st elements): 1548782631 36.801707 -121.785278 -1.1 2.58076081135315 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 029 (looping to 029) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019029vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019029vntaedited.txt esecs, east, north, lat, lon, head, pres 1548783130, 0, 0, 36.712598, -122.188674, 99.7, 161.63 1548783630, 0, 0, 36.712929, -122.189549, 106.2, 341.77 1548784130, 0, 0, 36.712793, -122.189274, 106.1, 522.28 1548784630, 0, 0, 36.712922, -122.189144, 100.5, 683.56 1548785130, 0, 0, 36.712837, -122.189277, 101.3, 780.16 1548785630, 0, 0, 36.712744, -122.189540, 88.0, 882.01 1548786130, 0, 0, 36.712604, -122.187227, 101.9, 885.05 1548786630, 0, 0, 36.712424, -122.186880, 39.9, 878.12 1548787131, 0, 0, 36.712484, -122.186750, 267.9, 886.47 1548787631, 0, 0, 36.712454, -122.186712, 269.2, 886.47 1548788131, 0, 0, 36.712461, -122.186731, 268.6, 886.50 1548788631, 0, 0, 36.712460, -122.186721, 265.9, 886.38 1548789131, 0, 0, 36.712451, -122.186733, 269.8, 885.47 1548789631, 0, 0, 36.712483, -122.186442, 269.9, 878.04 1548790131, 0, 0, 36.712404, -122.186272, 264.5, 885.47 1548790631, 0, 0, 36.712340, -122.186415, 217.5, 870.67 1548791131, 0, 0, 36.712272, -122.188588, 257.0, 840.33 1548791631, 0, 0, 36.711568, -122.188659, 171.9, 613.82 1548792132, 0, 0, 36.709809, -122.188849, 163.8, 502.62 1548792632, 0, 0, 36.707991, -122.187961, 171.1, 503.48 1548793132, 0, 0, 36.707908, -122.188966, 173.4, 403.70 1548793632, 0, 0, 36.705678, -122.189889, 177.4, 403.06 1548794132, 0, 0, 36.704499, -122.191294, 182.3, 302.67 1548794632, 0, 0, 36.702887, -122.192445, 96.0, 259.80 1548795132, 0, 0, 36.703728, -122.190445, 78.4, 232.27 1548795632, 0, 0, 36.704251, -122.190441, 136.6, 181.22 1548796133, 0, 0, 36.703808, -122.191574, 136.2, 101.16 1548796633, 0, 0, 36.702344, -122.191206, 135.4, 99.97 1548797133, 0, 0, 36.702850, -122.192642, 136.9, 73.09 1548797633, 0, 0, 36.703411, -122.193208, 137.0, 24.84 1548798133, 0, 0, 36.703653, -122.193380, 93.6, 13.11 rovNav(): 029: 15947 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019029vntaedited.txt 15947 in tList 15947 in {self->{rovT}} 15947 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1548787215 & 1548782805 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 501.774439525873 rovGDCListRefs(): dStats->sample_range = 876.928272458826 rovGDCListRefs(): returning (1st elements): 1548782631 36.712125 -122.187505 358.9 2.58078126248585 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.71234500 hash{lon} = -122.18892600 latMin = 30.712345 latMax = 42.712345 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.712345 AND 42.712345 AND Longitude BETWEEN -128.188926 AND -116.188926 Dive lat = 36.71234500, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.18892600 & lat = 36.71234500 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4173rov_orig.wrl Making color lookup world... var = Light, vmin = 40, vmax = 100 val = 40, color = .frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/029/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/029/accesses.txt at bin\geopdvc_perseus.pl line 629. 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/vnta4173lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1858 shipNav(): $#{$self->{shipLat}}[last] = 36.714607 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 = 15948 makeTracks(): Looping through 1858 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4173tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4173mergedCtdNav.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/29/2019 5:23:49 PM' AND '1/29/2019 9:49:42 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '1/29/2019 5:23:49 PM' AND '1/29/2019 9:49:42 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/vnta4173... 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/29/2019 5:23:49 PM' AND '1/29/2019 9:49:42 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4173.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6507,'/3Dreplay/3D.asp?dives=vnta4173','vnta4173','','','',4173 Executing sql: UPDATE Dive SET DiveLatMid = 36.7123, DiveLonMid = -122.1889, DiveDepthMid = -501.8 WHERE RovName = 'vnta' AND DiveNumber = 4173