Running bin\geopdvc.pl at Fri Oct 27 03:00:35 2017 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4071 bin\geopdvc.pl: Getting Expedition object for diveno = 4071 and rname = vnta set_expd(): rov = vnta, diveno = 4071 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 = 4071 AND RovName = 'vnta' RS->Fields(0)->Value= 6078 RS->Fields(1)->Value= 1504028170 RS->Fields(2)->Value= 1504044343 RS->Fields(3)->Value= 8/29/2017 5:36:10 PM RS->Fields(4)->Value= 8/29/2017 10:05:43 PM set_expd(): $self->{EndDDD} = 241 set_expd(): $self->{StartEsecs} = 1504026970 set_expd(): $self->{EndEsecs} = 1504045543 set_expd(): $self->{EndDtg} = 8/29/2017 10:05:43 PM _readLogr(): Reading videologr data from 2017241datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1504026970 & 1504045543 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1504045552, self->{EndEsecs} = 1504045543 _readLogr(): #LOGHOST_SYSTEM_UTC = 1856 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1504026979 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1504045542 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1504026979 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1504045542 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1504026850, Refined EndEsecs = 1504045663 _readLogr(): Reading videologr data from 2017241datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1504026850 & 1504045663 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1504045672, self->{EndEsecs} = 1504045663 _readLogr(): #LOGHOST_SYSTEM_UTC = 1880 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1504026859 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1504045662 bin\geopdvc.pl: expdid = 6078 bin\geopdvc.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 = 241 (looping to 241) Does file exist?: \\atlas\RovNavEdit\2017\vnta\nav2017241vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2017\vnta\nav2017241vnta.txt esecs, east, north, lat, lon, head, pres 1504028297, 0, 0, 36.780677, -121.951402, -70.4, 35.44 1504028798, 0, 0, 36.780858, -121.951613, -54.3, 112.16 1504029298, 0, 0, 36.781290, -121.951905, 71.9, 103.44 1504029799, 0, 0, 36.781302, -121.951712, -131.9, 93.97 1504030300, 0, 0, 36.784308, -121.946520, 19.0, 91.42 1504030801, 0, 0, 36.782123, -121.952338, -0.4, 101.21 1504031302, 0, 0, 36.781500, -121.952358, 179.8, 149.57 1504031803, 0, 0, 36.780722, -121.952463, 179.8, 180.30 1504032303, 0, 0, 36.780442, -121.951897, 134.7, 188.64 1504032804, 0, 0, 36.779448, -121.951203, -153.5, 160.85 1504033305, 0, 0, 36.778963, -121.951743, -153.8, 103.86 1504033806, 0, 0, 36.778718, -121.952363, -154.0, 57.91 1504034307, 0, 0, 36.778547, -121.952085, 94.3, 117.29 1504034808, 0, 0, 36.778543, -121.951868, 143.0, 126.93 1504035309, 0, 0, 36.778738, -121.951938, -152.9, 126.22 1504035810, 0, 0, 36.778772, -121.951973, -151.7, 128.29 1504036311, 0, 0, 36.778755, -121.952078, -144.8, 127.75 1504036811, 0, 0, 36.778727, -121.952145, -136.5, 123.93 1504037312, 0, 0, 36.778660, -121.952207, -153.0, 116.89 1504037813, 0, 0, 36.778775, -121.952378, -149.4, 102.77 1504038314, 0, 0, 36.778102, -121.953065, -114.9, 83.81 1504038815, 0, 0, 36.779077, -121.952927, -120.5, 70.16 1504039316, 0, 0, 36.778863, -121.952800, 114.7, 103.93 1504039816, 0, 0, 36.778395, -121.951657, 114.4, 144.23 1504040317, 0, 0, 36.777578, -121.951278, 168.9, 209.97 1504040818, 0, 0, 36.777477, -121.951277, 149.7, 239.85 1504041319, 0, 0, 36.777665, -121.951243, -119.3, 228.45 1504041820, 0, 0, 36.777920, -121.951003, -0.5, 235.66 1504042321, 0, 0, 36.778177, -121.950972, -68.2, 231.52 1504042821, 0, 0, 36.778253, -121.951073, -36.6, 228.63 1504043322, 0, 0, 36.778550, -121.951757, -76.8, 211.87 1504043823, 0, 0, 36.778632, -121.952128, -52.9, 11.23 1504044324, 0, 0, 36.778735, -121.952325, -11.9, 9.71 rovNav(): 241: 16145 in tList after reading from \\atlas\RovNavEdit\2017\vnta\nav2017241vnta.txt 16145 in tList 16145 in {self->{rovT}} 16145 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1504029990 & 1504034190 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 123.036327514744 rovGDCListRefs(): dStats->sample_range = 236.943700630967 rovGDCListRefs(): returning (1st elements): 1504028172 36.780638 -121.951593 -74.1 2.68002518479903 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 241 (looping to 241) Does file exist?: \\atlas\RovNavEdit\2017\vnta\nav2017241vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2017\vnta\nav2017241vntaedited.txt esecs, east, north, lat, lon, head, pres 1504028297, 0, 0, 36.780692, -121.951300, 289.6, 35.44 1504028798, 0, 0, 36.780915, -121.951672, 305.7, 112.16 1504029298, 0, 0, 36.781258, -121.951870, 71.9, 103.44 1504029799, 0, 0, 36.781297, -121.951756, 228.1, 93.97 1504030300, 0, 0, 36.781397, -121.951915, 19.0, 91.42 1504030801, 0, 0, 36.782097, -121.952324, 359.6, 101.21 1504031302, 0, 0, 36.781510, -121.952354, 179.8, 149.57 1504031803, 0, 0, 36.780733, -121.952461, 179.8, 180.30 1504032303, 0, 0, 36.780409, -121.951888, 134.7, 188.64 1504032804, 0, 0, 36.779427, -121.951202, 206.5, 160.85 1504033305, 0, 0, 36.778942, -121.951744, 206.2, 103.86 1504033806, 0, 0, 36.778492, -121.952424, 206.0, 57.91 1504034307, 0, 0, 36.778538, -121.952074, 94.3, 117.29 1504034808, 0, 0, 36.778549, -121.951870, 143.0, 126.93 1504035309, 0, 0, 36.778735, -121.951951, 207.1, 126.22 1504035810, 0, 0, 36.778778, -121.951973, 208.3, 128.29 1504036311, 0, 0, 36.778757, -121.952073, 215.2, 127.75 1504036811, 0, 0, 36.778730, -121.952143, 223.5, 123.93 1504037312, 0, 0, 36.778672, -121.952204, 207.0, 116.89 1504037813, 0, 0, 36.778782, -121.952369, 210.6, 102.77 1504038314, 0, 0, 36.778905, -121.952688, 245.1, 83.81 1504038815, 0, 0, 36.779032, -121.953003, 239.5, 70.16 1504039316, 0, 0, 36.778846, -121.952790, 114.7, 103.93 1504039816, 0, 0, 36.778404, -121.951644, 114.4, 144.23 1504040317, 0, 0, 36.777569, -121.951283, 168.9, 209.97 1504040818, 0, 0, 36.777474, -121.951282, 149.7, 239.85 1504041319, 0, 0, 36.777662, -121.951199, 240.7, 228.45 1504041820, 0, 0, 36.777916, -121.951016, 359.5, 235.66 1504042321, 0, 0, 36.778159, -121.951013, 291.8, 231.52 1504042821, 0, 0, 36.778252, -121.951080, 323.4, 228.63 1504043322, 0, 0, 36.778547, -121.951780, 283.2, 211.87 1504043823, 0, 0, 36.778083, -121.951869, 307.1, 11.23 1504044324, 0, 0, 36.778269, -121.951405, 348.1, 9.71 rovNav(): 241: 16145 in tList after reading from \\atlas\RovNavEdit\2017\vnta\nav2017241vntaedited.txt 16145 in tList 16145 in {self->{rovT}} 16145 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1504029990 & 1504034190 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 123.036327541959 rovGDCListRefs(): dStats->sample_range = 236.943700389755 rovGDCListRefs(): returning (1st elements): 1504028172 36.780720 -121.951027 285.9 2.68002516535407 bin\geopdvc.pl: ------------------------------------------------------frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/241/accesses.txt at bin\geopdvc.pl line 2382 frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/241/accesses.txt at bin\geopdvc.pl line 625 frameGrabs(): Can't read dir http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/vnta4071: Bad file descriptor at bin\geopdvc.pl line 625 ------------------------- hash{lat} = 36.77874600 hash{lon} = -121.95190450 latMin = 30.778746 latMax = 42.778746 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.778746 AND 42.778746 AND Longitude BETWEEN -127.9519045 AND -115.9519045 Dive lat = 36.77874600, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.95190450 & lat = 36.77874600 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4071rov_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 = geo2017/vnta/vnta4071lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1880 shipNav(): $#{$self->{shipLat}}[last] = 36.783778 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 = 16146 makeTracks(): Looping through 1880 point of ship position data... makeTracks(): posSubsample = 13 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4071tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2017/vnta/vnta4071mergedCtdNav.txt... bin\geopdvc.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 '8/29/2017 5:36:10 PM' AND '8/29/2017 10:05:43 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '8/29/2017 5:36:10 PM' AND '8/29/2017 10:05:43 PM') bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/vnta4071... iList = bin\geopdvc.pl: Number of images returned from expd->frameGrabs(every=>1)} = 0 bin\geopdvc.pl: Calling placeImages with every 10 image... bin\geopdvc.pl: Calling placeImages with every 2 image... bin\geopdvc.pl: Calling placeImages with every 1 image... bin\geopdvc.pl: Samples: samples(): Executing sql: SELECT DateDiff(ss, '01/01/70', CollectionEventDtg) AS Esecs, CollectionVIMSConcept, FrameGrabImageURL, SampleID, CollectionRefName FROM vwCollSamplePerson WHERE (CollectionEventDTG BETWEEN '8/29/2017 5:36:10 PM' AND '8/29/2017 10:05:43 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2017/vnta/vnta4071.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6078,'/3Dreplay/3D.asp?dives=vnta4071','vnta4071','','','',4071 Executing sql: UPDATE Dive SET DiveLatMid = 36.7787, DiveLonMid = -121.9519, DiveDepthMid = -123.0 WHERE RovName = 'vnta' AND DiveNumber = 4071