Running bin\geopdvc_perseus.pl at Fri Jan 17 03:00:02 2020 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4235 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4235 and rname = vnta set_expd(): rov = vnta, diveno = 4235 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 = 4235 AND RovName = 'vnta' RS->Fields(0)->Value= 6790 RS->Fields(1)->Value= 1574188178 RS->Fields(2)->Value= 1574200199 RS->Fields(3)->Value= 11/19/2019 6:29:38 PM RS->Fields(4)->Value= 11/19/2019 9:49:59 PM set_expd(): $self->{EndDDD} = 323 set_expd(): $self->{StartEsecs} = 1574186978 set_expd(): $self->{EndEsecs} = 1574201399 set_expd(): $self->{EndDtg} = 11/19/2019 9:49:59 PM _readLogr(): Reading videologr data from 2019323datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1574186978 & 1574201399 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1574201402, self->{EndEsecs} = 1574201399 _readLogr(): #LOGHOST_SYSTEM_UTC = 1441 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1574186982 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1574201392 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1574186982 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1574201392 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1574186858, Refined EndEsecs = 1574201519 _readLogr(): Reading videologr data from 2019323datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1574186858 & 1574201519 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1574201522, self->{EndEsecs} = 1574201519 _readLogr(): #LOGHOST_SYSTEM_UTC = 1465 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1574186862 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1574201512 bin\geopdvc_perseus.pl: expdid = 6790 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 = 323 (looping to 323) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019323vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019323vnta.txt esecs, east, north, lat, lon, head, pres 1574188678, 0, 0, 36.885655, -121.963185, 91.2, 36.34 1574189178, 0, 0, 36.885848, -121.961167, 89.8, 35.65 1574189678, 0, 0, 36.885553, -121.959138, 103.1, 35.14 1574190178, 0, 0, 36.885227, -121.956895, 101.7, 35.41 1574190678, 0, 0, 36.884675, -121.954590, 101.3, 35.94 1574191179, 0, 0, 36.884200, -121.951990, 103.8, 36.87 1574191679, 0, 0, 36.883527, -121.949612, 103.8, 37.31 1574192179, 0, 0, 36.883558, -121.948815, 110.6, 37.42 1574192679, 0, 0, 36.883250, -121.948407, 177.1, 38.07 1574193179, 0, 0, 36.882688, -121.948685, -80.0, 38.47 1574193679, 0, 0, 36.882812, -121.949498, -75.1, 38.72 1574194179, 0, 0, 36.883448, -121.949562, 72.6, 37.62 1574194679, 0, 0, 36.883100, -121.946380, 101.8, 37.98 1574195179, 0, 0, 36.882320, -121.944448, 106.3, 39.12 1574195680, 0, 0, 36.881838, -121.942353, 111.4, 40.02 1574196180, 0, 0, 36.880952, -121.939860, 111.8, 40.97 1574196680, 0, 0, 36.880290, -121.937677, 112.6, 41.81 1574197180, 0, 0, 36.879408, -121.935147, 105.0, 42.86 1574197680, 0, 0, 36.878630, -121.931918, 110.3, 43.47 1574198180, 0, 0, 36.877515, -121.928463, 109.4, 44.33 1574198680, 0, 0, 36.876483, -121.924918, 106.9, 44.80 1574199180, 0, 0, 36.875460, -121.921350, 109.4, 44.84 1574199680, 0, 0, 36.874867, -121.919720, 4.8, 44.67 1574200181, 0, 0, 36.875300, -121.919277, 147.4, 8.23 rovNav(): 323: 12017 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019323vnta.txt 12017 in tList 12017 in {self->{rovT}} 12017 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1574193045 & 1574193225 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 38.0923988916297 rovGDCListRefs(): dStats->sample_range = 42.5180225409855 rovGDCListRefs(): returning (1st elements): 1574188179 36.885833 -121.962772 -99.5 2.58074158869998 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 323 (looping to 323) Does file exist?: \\atlas\RovNavEdit\2019\vnta\nav2019323vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2019\vnta\nav2019323vntaedited.txt esecs, east, north, lat, lon, head, pres 1574188678, 0, 0, 36.885637, -121.963188, 91.2, 36.34 1574189178, 0, 0, 36.885850, -121.961154, 89.8, 35.65 1574189678, 0, 0, 36.885560, -121.959130, 103.1, 35.14 1574190178, 0, 0, 36.885228, -121.956867, 101.7, 35.41 1574190678, 0, 0, 36.884661, -121.954605, 101.3, 35.94 1574191179, 0, 0, 36.884200, -121.951975, 103.8, 36.87 1574191679, 0, 0, 36.883680, -121.949618, 103.8, 37.31 1574192179, 0, 0, 36.883545, -121.948786, 110.6, 37.42 1574192679, 0, 0, 36.883230, -121.948425, 177.1, 38.07 1574193179, 0, 0, 36.882699, -121.948688, 280.0, 38.47 1574193679, 0, 0, 36.882815, -121.949510, 284.9, 38.72 1574194179, 0, 0, 36.882875, -121.947645, 72.6, 37.62 1574194679, 0, 0, 36.883094, -121.946379, 101.8, 37.98 1574195179, 0, 0, 36.882327, -121.944455, 106.3, 39.12 1574195680, 0, 0, 36.881929, -121.942316, 111.4, 40.02 1574196180, 0, 0, 36.880952, -121.939855, 111.8, 40.97 1574196680, 0, 0, 36.880237, -121.937540, 112.6, 41.81 1574197180, 0, 0, 36.879481, -121.935091, 105.0, 42.86 1574197680, 0, 0, 36.878625, -121.931912, 110.3, 43.47 1574198180, 0, 0, 36.877508, -121.928439, 109.4, 44.33 1574198680, 0, 0, 36.876484, -121.924911, 106.9, 44.80 1574199180, 0, 0, 36.875444, -121.921319, 109.4, 44.84 1574199680, 0, 0, 36.874942, -121.919945, 4.8, 44.67 1574200181, 0, 0, 36.874942, -121.919945, 147.4, 8.23 rovNav(): 323: 12017 in tList after reading from \\atlas\RovNavEdit\2019\vnta\nav2019323vntaedited.txt 12017 in tList 12017 in {self->{rovT}} 12017 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1574198475 & 1574193315 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 38.0923989000647 rovGDCListRefs(): dStats->sample_range = 42.5180223353019 rovGDCListRefs(): returning (1st elements): 1574188179 36.886253 -121.963252 260.5 2.58074149268941 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.88277400 hash{lon} = -121.94763950 latMin = 30.882774 latMax = 42.882774 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.882774 AND 42.882774 AND Longitude BETWEEN -127.9476395 AND -115.9476395 Dive lat = 36.88277400, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.94763950 & lat = 36.88277400 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4235rov_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/vnta4235lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/323/accesses.txt at bin\geopdvc_perseus.pl line 2386. frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2019/323/accesses.txt at bin\geopdvc_perseus.pl line 629. ipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1465 shipNav(): $#{$self->{shipLat}}[last] = 36.852229 Position subsampling set to 10 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 = 12018 makeTracks(): Looping through 1465 point of ship position data... makeTracks(): posSubsample = 10 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4235tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2019/vnta/vnta4235mergedCtdNav.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 '11/19/2019 6:29:38 PM' AND '11/19/2019 9:49:59 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/19/2019 6:29:38 PM' AND '11/19/2019 9:49:59 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/vnta4235... 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 '11/19/2019 6:29:38 PM' AND '11/19/2019 9:49:59 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2019/vnta/vnta4235.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6790,'/3Dreplay/3D.asp?dives=vnta4235','vnta4235','','','',4235 Executing sql: UPDATE Dive SET DiveLatMid = 36.8828, DiveLonMid = -121.9476, DiveDepthMid = -38.1 WHERE RovName = 'vnta' AND DiveNumber = 4235