Running bin\geopdvc.pl at Sat Jul 8 03:00:04 2017 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4030 bin\geopdvc.pl: Getting Expedition object for diveno = 4030 and rname = vnta set_expd(): rov = vnta, diveno = 4030 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 = 4030 AND RovName = 'vnta' RS->Fields(0)->Value= 5961 RS->Fields(1)->Value= 1494436985 RS->Fields(2)->Value= 1494454213 RS->Fields(3)->Value= 5/10/2017 5:23:05 PM RS->Fields(4)->Value= 5/10/2017 10:10:13 PM set_expd(): $self->{EndDDD} = 130 set_expd(): $self->{StartEsecs} = 1494435785 set_expd(): $self->{EndEsecs} = 1494455413 set_expd(): $self->{EndDtg} = 5/10/2017 10:10:13 PM _readLogr(): Reading videologr data from 2017130datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1494435785 & 1494455413 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1494455420, self->{EndEsecs} = 1494455413 _readLogr(): #LOGHOST_SYSTEM_UTC = 1962 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1494435787 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1494455410 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1494435787 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1494455410 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1494435665, Refined EndEsecs = 1494455533 _readLogr(): Reading videologr data from 2017130datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1494435665 & 1494455533 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1494455540, self->{EndEsecs} = 1494455533 _readLogr(): #LOGHOST_SYSTEM_UTC = 1986 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1494435667 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1494455530 bin\geopdvc.pl: expdid = 5961 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 = 130 (looping to 130) Does file exist?: \\atlas\RovNavEdit\2017\vnta\nav2017130vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2017\vnta\nav2017130vnta.txt esecs, east, north, lat, lon, head, pres 1494435900, 0, 0, 36.769483, -121.965330, -174.8, 100.84 1494436401, 0, 0, 36.769852, -121.965605, 91.1, 100.77 1494436902, 0, 0, 36.770262, -121.965955, 92.1, 100.90 1494437403, 0, 0, 36.770622, -121.966185, 91.2, 100.88 1494437904, 0, 0, 36.771035, -121.966320, 91.8, 100.82 1494438404, 0, 0, 36.771315, -121.966290, -174.7, 100.91 1494438905, 0, 0, 36.771512, -121.966402, -144.0, 100.92 1494439406, 0, 0, 36.771690, -121.966325, -143.1, 100.88 1494439907, 0, 0, 36.771893, -121.966357, -141.5, 100.80 1494440408, 0, 0, 36.771690, -121.966767, -140.5, 102.11 1494440909, 0, 0, 36.771667, -121.966848, -173.0, 110.74 1494441409, 0, 0, 36.771220, -121.967300, -173.3, 146.32 1494441910, 0, 0, 36.770532, -121.967988, -173.9, 153.46 1494442411, 0, 0, 36.769817, -121.968767, -177.6, 169.20 1494442912, 0, 0, 36.769515, -121.969023, -179.9, 211.16 1494443413, 0, 0, 36.768602, -121.969153, 173.8, 222.45 1494443914, 0, 0, 36.768377, -121.969288, 172.9, 222.47 1494444414, 0, 0, 36.768448, -121.969428, 173.1, 244.18 1494444915, 0, 0, 36.767650, -121.969485, 174.4, 301.93 1494445416, 0, 0, 36.766817, -121.969597, 173.4, 360.17 1494445917, 0, 0, 36.766247, -121.969903, 171.1, 418.73 1494446418, 0, 0, 36.766338, -121.969832, 169.9, 476.45 1494446919, 0, 0, 36.766223, -121.969842, 121.4, 475.77 1494447420, 0, 0, 36.766167, -121.969773, 172.3, 490.53 1494447920, 0, 0, 36.765897, -121.969305, 165.7, 509.34 1494448421, 0, 0, 36.765725, -121.968977, 152.4, 501.47 1494448922, 0, 0, 36.765378, -121.968528, 168.9, 483.20 1494449423, 0, 0, 36.764685, -121.968630, 164.7, 458.78 1494449924, 0, 0, 36.764215, -121.969022, 158.8, 419.70 1494450425, 0, 0, 36.764365, -121.968760, 41.0, 400.85 1494450925, 0, 0, 36.764200, -121.968393, 162.8, 393.85 1494451426, 0, 0, 36.763558, -121.969403, -159.7, 377.94 1494451927, 0, 0, 36.762940, -121.970598, -161.6, 347.43 1494452428, 0, 0, 36.762198, -121.971313, -164.2, 314.68 1494452929, 0, 0, 36.761828, -121.971478, 174.4, 281.27 1494453430, 0, 0, 36.762438, -121.971535, -159.0, 166.32 1494453931, 0, 0, 36.763753, -121.971220, -157.9, 74.42 rovNav(): 130: 18517 in tList after reading from \\atlas\RovNavEdit\2017\vnta\nav2017130vnta.txt 18517 in tList 18517 in {self->{rovT}} 18517 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1494454155 & 1494440415 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 220.854888316696 rovGDCListRefs(): dStats->sample_range = 507.360061529187 rovGDCListRefs(): returning (1st elements): 1494435665 36.769275 -121.965268 -178.0 52.8297371656479 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 130 (looping to 130) Does file exist?: \\atlas\RovNavEdit\2017\vnta\nav2017130vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2017\vnta\nav2017130vntaedited.txt esecs, east, north, lat, lon, head, pres 1494435900, 0, 0, 36.769477, -121.965353, 185.2, 100.84 1494436401, 0, 0, 36.769855, -121.965610, 91.1, 100.77 1494436902, 0, 0, 36.770268, -121.965960, 92.1, 100.90 1494437403, 0, 0, 36.770628, -121.966185, 91.2, 100.88 1494437904, 0, 0, 36.771033, -121.966315, 91.8, 100.82 1494438404, 0, 0, 36.771325, -121.966288, 185.3, 100.91 1494438905, 0, 0, 36.771505, -121.966398, 216.0, 100.92 1494439406, 0, 0, 36.771687, -121.966331, 216.9, 100.88 1494439907, 0, 0, 36.771874, -121.966360, 218.5, 100.80 1494440408, 0, 0, 36.771692, -121.966764, 219.5, 102.11 1494440909, 0, 0, 36.771663, -121.966852, 187.0, 110.74 1494441409, 0, 0, 36.771211, -121.967300, 186.7, 146.32 1494441910, 0, 0, 36.770542, -121.968002, 186.1, 153.46 1494442411, 0, 0, 36.769805, -121.968756, 182.4, 169.20 1494442912, 0, 0, 36.769512, -121.969018, 180.1, 211.16 1494443413, 0, 0, 36.768593, -121.969149, 173.8, 222.45 1494443914, 0, 0, 36.768381, -121.969291, 172.9, 222.47 1494444414, 0, 0, 36.768448, -121.969424, 173.1, 244.18 1494444915, 0, 0, 36.767660, -121.969458, 174.4, 301.93 1494445416, 0, 0, 36.766830, -121.969599, 173.4, 360.17 1494445917, 0, 0, 36.766245, -121.969895, 171.1, 418.73 1494446418, 0, 0, 36.766342, -121.969825, 169.9, 476.45 1494446919, 0, 0, 36.766204, -121.969826, 121.4, 475.77 1494447420, 0, 0, 36.766159, -121.969783, 172.3, 490.53 1494447920, 0, 0, 36.765897, -121.969325, 165.7, 509.34 1494448421, 0, 0, 36.765698, -121.968951, 152.4, 501.47 1494448922, 0, 0, 36.765354, -121.968510, 168.9, 483.20 1494449423, 0, 0, 36.764686, -121.968638, 164.7, 458.78 1494449924, 0, 0, 36.764204, -121.969007, 158.8, 419.70 1494450425, 0, 0, 36.764347, -121.968748, 41.0, 400.85 1494450925, 0, 0, 36.764199, -121.968375, 162.8, 393.85 1494451426, 0, 0, 36.763655, -121.969369, 200.3, 377.94 1494451927, 0, 0, 36.762942, -121.970609, 198.4, 347.43 1494452428, 0, 0, 36.762164, -121.971291, 195.8, 314.68 1494452929, 0, 0, 36.761874, -121.971473, 174.4, 281.27 1494453430, 0, 0, 36.762454, -121.971548, 201.0, 166.32 1494453931, 0, 0, 36.763778, -121.971218, 202.1, 74.42 rovNav(): 130: 18517 in tList after reading from \\atlas\RovNavEdit\2017\vnta\nav2017130vntaedited.txt 18517 in tList 18517 in {self->{rovT}} 18517 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1494454155 & 1494440415 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 220.854888150617 rovGDCListRefs(): dStats->sample_range = 507.360062196536 rovGDCListRefs(): returning (1st elements): 1494435665 36.769242 -121.965243 182.0 52.8297373198865 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.76763450 hash{lon} = -121.96894150 latMin = 30.7676345 latMax = 42.7676345 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.7676345 AND 42.7676345 AND Longitude BETWEEN -127.9689415 AND -115.9689415 Dive lat = 36.76763450, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.96894150 & lat = 36.76763450 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4030rov_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/vnta4030lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1986 shipNav(): $#{$self->{shipLat}}[last] = 36.frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/130/accesses.txt at bin\geopdvc.pl line 2382 frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/130/accesses.txt at bin\geopdvc.pl line 625 frameGrabs(): Can't read dir http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/vnta4030: Bad file descriptor at bin\geopdvc.pl line 625 773637 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 = 18518 makeTracks(): Looping through 1986 point of ship position data... makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4030tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2017/vnta/vnta4030mergedCtdNav.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 '5/10/2017 5:23:05 PM' AND '5/10/2017 10:10:13 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '5/10/2017 5:23:05 PM' AND '5/10/2017 10:10:13 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/vnta4030... 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 '5/10/2017 5:23:05 PM' AND '5/10/2017 10:10:13 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2017/vnta/vnta4030.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',5961,'/3Dreplay/3D.asp?dives=vnta4030','vnta4030','','','',4030 Executing sql: UPDATE Dive SET DiveLatMid = 36.7676, DiveLonMid = -121.9689, DiveDepthMid = -220.8 WHERE RovName = 'vnta' AND DiveNumber = 4030