Running bin\geopdvc_perseus.pl at Sat Nov 16 03:00:02 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4212 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4212 and rname = vnta set_expd(): rov = vnta, diveno = 4212 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 = 4212 AND RovName = 'vnta' RS->Fields(0)->Value= 6727 RS->Fields(1)->Value= 1568823422 RS->Fields(2)->Value= 1568841776 RS->Fields(3)->Value= 9/18/2019 4:17:02 PM RS->Fields(4)->Value= 9/18/2019 9:22:56 PM set_expd(): $self->{EndDDD} = 261 set_expd(): $self->{StartEsecs} = 1568822222 set_expd(): $self->{EndEsecs} = 1568842976 set_expd(): $self->{EndDtg} = 9/18/2019 9:22:56 PM _readLogr(): Reading videologr data from 2019261datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1568822222 & 1568842976 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1568842984, self->{EndEsecs} = 1568842976 _readLogr(): #LOGHOST_SYSTEM_UTC = 2075 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1568822224 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1568842974 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1568822224 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1568842974 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1568822102, Refined EndEsecs = 1568843096 _readLogr(): Reading videologr data from 2019261datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1568822102 & 1568843096 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1568843104, self->{EndEsecs} = 1568843096 _readLogr(): #LOGHOST_SYSTEM_UTC = 2099 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1568822104 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1568843094 bin\geopdvc_perseus.pl: expdid = 6727 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 = 261 (looping to 261) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019261vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019261vnta.txt esecs, east, north, lat, lon, head, pres 1568823923, 0, 0, 36.747842, -122.108152, -147.6, 88.43 1568824423, 0, 0, 36.748002, -122.107907, 95.7, 123.22 1568824923, 0, 0, 36.748395, -122.107398, -41.4, 139.14 1568825423, 0, 0, 36.748413, -122.107218, -175.3, 200.97 1568825923, 0, 0, 36.748672, -122.106368, 175.6, 225.04 1568826423, 0, 0, 36.748422, -122.105852, 165.7, 238.92 1568826923, 0, 0, 36.748513, -122.105447, 164.6, 233.28 1568827423, 0, 0, 36.748725, -122.105050, -156.0, 231.00 1568827923, 0, 0, 36.748400, -122.104742, -166.1, 220.97 1568828424, 0, 0, 36.747842, -122.104510, -145.6, 193.18 1568828924, 0, 0, 36.747763, -122.104547, -124.3, 139.90 1568829424, 0, 0, 36.747573, -122.104647, -110.3, 120.24 1568829924, 0, 0, 36.747020, -122.104185, -138.8, 108.72 1568830424, 0, 0, 36.746917, -122.103798, 178.9, 102.31 1568830924, 0, 0, 36.746827, -122.103420, 34.6, 133.63 1568831424, 0, 0, 36.747040, -122.103470, -135.7, 129.50 1568831924, 0, 0, 36.746993, -122.103363, -115.4, 124.93 1568832424, 0, 0, 36.746430, -122.103337, -162.1, 100.53 1568832924, 0, 0, 36.746767, -122.103593, 44.6, 97.85 1568833425, 0, 0, 36.746667, -122.103682, -113.5, 95.89 1568833925, 0, 0, 36.746947, -122.103618, 29.7, 108.72 1568834425, 0, 0, 36.747297, -122.103397, -25.0, 120.64 1568834925, 0, 0, 36.747090, -122.103420, -86.0, 122.63 1568835425, 0, 0, 36.747922, -122.102642, 25.5, 128.50 1568835925, 0, 0, 36.748443, -122.101923, 96.6, 186.93 1568836425, 0, 0, 36.748535, -122.101610, -64.4, 210.68 1568836925, 0, 0, 36.748593, -122.101342, -57.4, 263.40 1568837425, 0, 0, 36.748765, -122.103177, -73.8, 341.48 1568837925, 0, 0, 36.749385, -122.104610, -78.2, 421.58 1568838426, 0, 0, 36.749462, -122.105572, -90.5, 435.99 1568838926, 0, 0, 36.749740, -122.106967, -84.7, 435.92 1568839426, 0, 0, 36.749708, -122.106630, -161.3, 431.23 1568839926, 0, 0, 36.748393, -122.107495, -176.0, 386.38 1568840426, 0, 0, 36.748082, -122.107062, 177.7, 264.30 1568840926, 0, 0, 36.747650, -122.106222, 174.4, 154.46 1568841426, 0, 0, 36.747548, -122.105888, -95.5, 49.68 rovNav(): 261: 18348 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019261vnta.txt 18348 in tList 18348 in {self->{rovT}} 18348 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1568826210 & 1568828355 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 146.050041482017 rovGDCListRefs(): dStats->sample_range = 431.521924973148 rovGDCListRefs(): returning (1st elements): 1568823424 36.749188 -122.103658 -2.6 2.68003264144437 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 261 (looping to 261) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019261vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019261vntaedited.txt esecs, east, north, lat, lon, head, pres 1568823923, 0, 0, 36.747842, -122.108160, 212.4, 88.43 1568824423, 0, 0, 36.748001, -122.107915, 95.7, 123.22 1568824923, 0, 0, 36.748284, -122.107432, 318.6, 139.14 1568825423, 0, 0, 36.748421, -122.107218, 184.7, 200.97 1568825923, 0, 0, 36.748660, -122.106375, 175.6, 225.04 1568826423, 0, 0, 36.748435, -122.105846, 165.7, 238.92 1568826923, 0, 0, 36.748518, -122.105446, 164.6, 233.28 1568827423, 0, 0, 36.748726, -122.105050, 204.0, 231.00 1568827923, 0, 0, 36.748398, -122.104740, 193.9, 220.97 1568828424, 0, 0, 36.747853, -122.104515, 214.4, 193.18 1568828924, 0, 0, 36.747727, -122.104574, 235.7, 139.90 1568829424, 0, 0, 36.747571, -122.104645, 249.7, 120.24 1568829924, 0, 0, 36.747079, -122.104199, 221.2, 108.72 1568830424, 0, 0, 36.746933, -122.103787, 178.9, 102.31 1568830924, 0, 0, 36.746842, -122.103426, 34.6, 133.63 1568831424, 0, 0, 36.747046, -122.103466, 224.3, 129.50 1568831924, 0, 0, 36.746977, -122.103365, 244.6, 124.93 1568832424, 0, 0, 36.746420, -122.103326, 197.9, 100.53 1568832924, 0, 0, 36.746777, -122.103578, 44.6, 97.85 1568833425, 0, 0, 36.746629, -122.103661, 246.5, 95.89 1568833925, 0, 0, 36.746950, -122.103604, 29.7, 108.72 1568834425, 0, 0, 36.747310, -122.103399, 335.0, 120.64 1568834925, 0, 0, 36.747100, -122.103411, 274.0, 122.63 1568835425, 0, 0, 36.747924, -122.102633, 25.5, 128.50 1568835925, 0, 0, 36.748442, -122.101917, 96.6, 186.93 1568836425, 0, 0, 36.748529, -122.101609, 295.6, 210.68 1568836925, 0, 0, 36.748594, -122.101335, 302.6, 263.40 1568837425, 0, 0, 36.748779, -122.103190, 286.2, 341.48 1568837925, 0, 0, 36.749366, -122.104606, 281.8, 421.58 1568838426, 0, 0, 36.749462, -122.105597, 269.5, 435.99 1568838926, 0, 0, 36.749807, -122.106918, 275.3, 435.92 1568839426, 0, 0, 36.749714, -122.106626, 198.7, 431.23 1568839926, 0, 0, 36.748378, -122.107495, 184.0, 386.38 1568840426, 0, 0, 36.748090, -122.107050, 177.7, 264.30 1568840926, 0, 0, 36.747646, -122.106216, 174.4, 154.46 1568841426, 0, 0, 36.747516, -122.105880, 264.5, 49.68 rovNav(): 261: 18348 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019261vntaedited.txt 18348 in tList 18348 in {self->{rovT}} 18348 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1568837235 & 1568840535 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/261/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/261/accesses.txt at bin\geopdvc_perseus.pl line 629. ...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 146.050041559525 rovGDCListRefs(): dStats->sample_range = 431.521924206333 rovGDCListRefs(): returning (1st elements): 1568823424 36.747900 -122.108390 357.4 2.68003294677156 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74795200 hash{lon} = -122.10458700 latMin = 30.747952 latMax = 42.747952 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.747952 AND 42.747952 AND Longitude BETWEEN -128.104587 AND -116.104587 Dive lat = 36.74795200, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.10458700 & lat = 36.74795200 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4212rov_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/vnta4212lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2099 shipNav(): $#{$self->{shipLat}}[last] = 36.757635 Position subsampling set to 15 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 18349 makeTracks(): Looping through 2099 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4212tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4212mergedCtdNav.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 '9/18/2019 4:17:02 PM' AND '9/18/2019 9:22:56 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/18/2019 4:17:02 PM' AND '9/18/2019 9:22:56 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/vnta4212... 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 '9/18/2019 4:17:02 PM' AND '9/18/2019 9:22:56 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4212.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6727,'/3Dreplay/3D.asp?dives=vnta4212','vnta4212','','','',4212 Executing sql: UPDATE Dive SET DiveLatMid = 36.7480, DiveLonMid = -122.1046, DiveDepthMid = -146.1 WHERE RovName = 'vnta' AND DiveNumber = 4212