Running bin\geopdvc.pl at Sun Sep 17 03:00:44 2017 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 4052 bin\geopdvc.pl: Getting Expedition object for diveno = 4052 and rname = vnta set_expd(): rov = vnta, diveno = 4052 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 = 4052 AND RovName = 'vnta' RS->Fields(0)->Value= 6038 RS->Fields(1)->Value= 1500574408 RS->Fields(2)->Value= 1500588580 RS->Fields(3)->Value= 7/20/2017 6:13:28 PM RS->Fields(4)->Value= 7/20/2017 10:09:40 PM set_expd(): $self->{EndDDD} = 201 set_expd(): $self->{StartEsecs} = 1500573208 set_expd(): $self->{EndEsecs} = 1500589780 set_expd(): $self->{EndDtg} = 7/20/2017 10:09:40 PM _readLogr(): Reading videologr data from 2017201datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1500573208 & 1500589780 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1500589790, self->{EndEsecs} = 1500589780 _readLogr(): #LOGHOST_SYSTEM_UTC = 1656 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1500573217 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1500589780 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1500573217 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1500589780 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1500573088, Refined EndEsecs = 1500589900 _readLogr(): Reading videologr data from 2017201datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1500573088 & 1500589900 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1500589910, self->{EndEsecs} = 1500589900 _readLogr(): #LOGHOST_SYSTEM_UTC = 1680 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1500573097 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1500589900 bin\geopdvc.pl: expdid = 6038 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 = 201 (looping to 201) Does file exist?: \\atlas\RovNavEdit\2017\vnta\nav2017201vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2017\vnta\nav2017201vnta.txt esecs, east, north, lat, lon, head, pres 1500574873, 0, 0, 36.781388, -121.954695, 0.6, 166.54 1500575374, 0, 0, 36.781245, -121.954863, -128.9, 227.56 1500575875, 0, 0, 36.780528, -121.944723, 163.2, 251.03 1500576376, 0, 0, 36.778890, -121.944710, -92.4, 263.12 1500576877, 0, 0, 36.784190, -121.956155, -88.6, 262.91 1500577377, 0, 0, 36.779035, -121.951260, -174.9, 277.72 1500577878, 0, 0, 36.780237, -121.956522, -172.7, 298.84 1500578379, 0, 0, 36.780103, -121.957148, -139.9, 246.51 1500578880, 0, 0, 36.779757, -121.957282, -132.8, 215.09 1500579381, 0, 0, 36.779580, -121.946513, -125.8, 216.18 1500579882, 0, 0, 36.779862, -121.957403, -147.1, 209.14 1500580383, 0, 0, 36.779720, -121.958023, -149.0, 104.10 1500580884, 0, 0, 36.783993, -121.952032, -121.6, 55.89 1500581385, 0, 0, 36.777442, -121.947070, -115.2, 42.59 1500581886, 0, 0, 36.780275, -121.947040, -114.6, 123.10 1500582387, 0, 0, 36.776973, -121.952868, -113.5, 158.67 1500582887, 0, 0, 36.784740, -121.954278, 54.3, 257.17 1500583388, 0, 0, 36.784095, -121.959535, 140.1, 334.93 1500583889, 0, 0, 36.779332, -121.958645, 89.7, 340.17 1500584390, 0, 0, 36.781660, -121.953305, -99.1, 330.75 1500584891, 0, 0, 36.781430, -121.952930, 88.1, 278.73 1500585392, 0, 0, 36.778938, -121.956837, 87.6, 166.34 1500585893, 0, 0, 36.781453, -121.953367, 91.4, 78.39 1500586394, 0, 0, 36.780905, -121.955382, 92.7, 20.82 1500586895, 0, 0, 36.782100, -121.954053, -84.2, 34.72 1500587396, 0, 0, 36.777603, -121.953417, -83.2, 29.88 1500587897, 0, 0, 36.781882, -121.950237, -84.2, 24.75 1500588398, 0, 0, 36.777480, -121.953550, -81.9, 18.40 rovNav(): 201: 14071 in tList after reading from \\atlas\RovNavEdit\2017\vnta\nav2017201vnta.txt 14071 in tList 14071 in {self->{rovT}} 14071 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1500578655 & 1500580575 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... rovGDCListRefs(): dMedian = 213.110646571068 rovGDCListRefs(): dStats->sample_range = 337.233212960775 rovGDCListRefs(): returning (1st elements): 1500574409 36.780768 -121.955423 -11.5 2.58076559331326 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 201 (looping to 201) Does file exist?: \\atlas\RovNavEdit\2017\vnta\nav2017201vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2017\vnta\nav2017201vntaedited.txt esecs, east, north, lat, lon, head, pres 1500574873, 0, 0, 36.781388, -121.954695, 0.6, 166.54 1500575374, 0, 0, 36.781245, -121.954863, 231.1, 227.56 1500575875, 0, 0, 36.780528, -121.944723, 163.2, 251.03 1500576376, 0, 0, 36.778890, -121.944710, 267.6, 263.12 1500576877, 0, 0, 36.784190, -121.956155, 271.4, 262.91 1500577377, 0, 0, 36.779035, -121.951260, 185.1, 277.72 1500577878, 0, 0, 36.780237, -121.956522, 187.3, 298.84 1500578379, 0, 0, 36.780103, -121.957148, 220.1, 246.51 1500578880, 0, 0, 36.779757, -121.957282, 227.2, 215.09 1500579381, 0, 0, 36.779580, -121.946513, 234.2, 216.18 1500579882, 0, 0, 36.779862, -121.957403, 212.9, 209.14 1500580383, 0, 0, 36.779720, -121.958023, 211.0, 104.10 1500580884, 0, 0, 36.783993, -121.952032, 238.4, 55.89 1500581385, 0, 0, 36.777442, -121.947070, 244.8, 42.59 1500581886, 0, 0, 36.780275, -121.947040, 245.4, 123.10 1500582387, 0, 0, 36.776973, -121.952868, 246.5, 158.67 1500582887, 0, 0, 36.784740, -121.954278, 54.3, 257.17 1500583388, 0, 0, 36.779652, -121.952065, 140.1, 334.93 1500583889, 0, 0, 36.779410, -121.958738, 89.7, 340.17 1500584390, 0, 0, 36.781527, -121.954064, 260.9, 330.75 1500584891, 0, 0, 36.780043, -121.955841, 88.1, 278.73 1500585392, 0, 0, 36.779171, -121.954156, 87.6, 166.34 1500585893, 0, 0, 36.780553, -121.954313, 91.4, 78.39 1500586394, 0, 0, 36.780905, -121.955382, 92.7, 20.82 1500586895, 0, 0, 36.782100, -121.954053, 275.8, 34.72 1500587396, 0, 0, 36.777603, -121.953417, 276.8, 29.88 1500587897, 0, 0, 36.781882, -121.950237, 275.8, 24.75 1500588398, 0, 0, 36.777480, -121.953550, 278.1, 18.40 rovNav(): 201: 14071 in tList after reading from \\atlas\RovNavEdit\2017\vnta\nav2017201vntaedited.txt 14071 in tList 14071 in {self->{rovT}} 14071 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1500578655 & 1500580575 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... rovGDCListRefs(): dMedian = 213.110646571068 rovGDCListRefs(): dStats->sample_range = 337.23321278039 rovGDCListRefs(): returning (1st elements): 1500574409 36.780768 -121.955423 348.5 2.58076559331326 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.77979700 hash{lon} = -121.95459300 latMin = 30.779797 latMax = 42.779797 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.779797 AND 42.779797 AND Longitude BETWEEN -127.954593 AND -115.954593 Dive lat = 36.77979700, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.95459300 & lat = 36.77979700 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta4052rov_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, frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/201/accesses.txt at bin\geopdvc.pl line 2382 frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/201/accesses.txt at bin\geopdvc.pl line 625 frameGrabs(): Can't read dir http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2017/vnta4052: Bad file descriptor at bin\geopdvc.pl line 625 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/vnta4052lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1680 shipNav(): $#{$self->{shipLat}}[last] = 36.781666 Position subsampling set to 11 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 = 14072 makeTracks(): Looping through 1680 point of ship position data... makeTracks(): posSubsample = 11 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4052tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2017/vnta/vnta4052mergedCtdNav.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 '7/20/2017 6:13:28 PM' AND '7/20/2017 10:09:40 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/20/2017 6:13:28 PM' AND '7/20/2017 10:09:40 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/vnta4052... 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 '7/20/2017 6:13:28 PM' AND '7/20/2017 10:09:40 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2017/vnta/vnta4052.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6038,'/3Dreplay/3D.asp?dives=vnta4052','vnta4052','','','',4052 Executing sql: UPDATE Dive SET DiveLatMid = 36.7798, DiveLonMid = -121.9546, DiveDepthMid = -213.1 WHERE RovName = 'vnta' AND DiveNumber = 4052