Running bin\geopdvc.pl at Fri Dec 13 03:00:06 2013 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3740 bin\geopdvc.pl: Getting Expedition object for diveno = 3740 and rname = vnta set_expd(): rov = vnta, diveno = 3740 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 = 3740 AND RovName = 'vnta' RS->Fields(0)->Value= 4878 RS->Fields(1)->Value= 1381851300 RS->Fields(2)->Value= 1381867860 RS->Fields(3)->Value= 10/15/2013 3:35:00 PM RS->Fields(4)->Value= 10/15/2013 8:11:00 PM set_expd(): $self->{EndDDD} = 288 set_expd(): $self->{StartEsecs} = 1381850100 set_expd(): $self->{EndEsecs} = 1381869060 set_expd(): $self->{EndDtg} = 10/15/2013 8:11:00 PM _readLogr(): Reading videologr data from 2013288datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1381850100 & 1381869060 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1381869065, self->{EndEsecs} = 1381869060 _readLogr(): #LOGHOST_SYSTEM_UTC = 1895 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1381850102 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1381869055 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1381850102 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1381869055 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1381849980, Refined EndEsecs = 1381869180 _readLogr(): Reading videologr data from 2013288datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1381849980 & 1381869180 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1381869185, self->{EndEsecs} = 1381869180 _readLogr(): #LOGHOST_SYSTEM_UTC = 1919 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1381849982 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1381869175 bin\geopdvc.pl: expdid = 4878 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 = 288 (looping to 288) Does file exist?: \\atlas\RovNavEdit\2013\vnta\nav2013288vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2013\vnta\nav2013288vnta.txt esecs, east, north, lat, lon, head, pres 1381851817, 0, 0, 36.696737, -122.043183, 42.0, 85.35 1381852318, 0, 0, 36.696737, -122.043183, 47.5, 88.07 1381852819, 0, 0, 36.696430, -121.941860, 351.1, 90.24 1381853320, 0, 0, 36.696210, -121.941813, 25.3, 90.61 1381853821, 0, 0, 36.696275, -121.941762, 26.0, 90.44 1381854321, 0, 0, 36.695943, -121.941782, 26.4, 90.13 1381854822, 0, 0, 36.696512, -121.941562, 25.6, 90.29 1381855323, 0, 0, 36.696525, -121.941460, 26.5, 90.26 1381855824, 0, 0, 36.696535, -121.941495, 25.4, 90.27 1381856325, 0, 0, 36.696493, -121.941702, 25.5, 90.16 1381856826, 0, 0, 36.696532, -121.941750, 26.2, 90.36 1381857326, 0, 0, 36.695940, -121.941755, 26.0, 90.16 1381857827, 0, 0, 36.696570, -121.941808, 26.7, 90.21 1381858328, 0, 0, 36.696518, -121.941683, 25.8, 90.12 1381858829, 0, 0, 36.695688, -121.941615, 354.2, 90.03 1381859330, 0, 0, 36.695937, -121.941532, 355.4, 89.88 1381859831, 0, 0, 36.696618, -121.941967, 356.7, 90.02 1381860331, 0, 0, 36.696548, -121.941915, 356.2, 91.35 1381860832, 0, 0, 36.696648, -121.941838, 356.5, 91.32 1381861333, 0, 0, 36.696543, -121.941907, 356.7, 91.30 1381861834, 0, 0, 36.695913, -121.940770, 356.4, 91.26 1381862335, 0, 0, 36.696452, -121.942107, 356.9, 91.14 1381862835, 0, 0, 36.696175, -121.941615, 356.2, 91.10 1381863336, 0, 0, 36.696398, -121.942115, 356.5, 91.08 1381863837, 0, 0, 36.696422, -121.942073, 355.4, 90.98 1381864338, 0, 0, 36.696355, -121.941380, 355.9, 91.10 1381864839, 0, 0, 36.696217, -121.942170, 355.5, 91.01 1381865339, 0, 0, 36.696607, -121.942078, 352.4, 89.80 1381865840, 0, 0, 36.696260, -121.942213, 355.8, 89.29 1381866341, 0, 0, 36.696272, -121.941918, 352.8, 89.11 1381866842, 0, 0, 36.696257, -121.942072, 353.9, 88.84 1381867343, 0, 0, 36.696392, -121.942007, 352.7, 89.11 1381867843, 0, 0, 36.696392, -121.941955, 353.3, 88.87 1381868344, 0, 0, 36.696267, -121.942035, 353.2, 88.83 1381868845, 0, 0, 36.696050, -121.942113, 353.2, 88.87 rovNav(): 288: 17834 in tList after reading from \\atlas\RovNavEdit\2013\vnta\nav2013288vnta.txt 17834 in tList 17834 in {self->{rovT}} 17834 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are & rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): rovGDCListRefs(): dMedian = 89.5837012609976 rovGDCListRefs(): dStats->sample_range = 100.412606560685 rovGDCListRefs(): returning (1st elements): 1381851317 36.696737 -122.043183 25.6 2.5609327081002 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 288 (looping to 288) Does file exist?: \\atlas\RovNavEdit\2013\vnta\nav2013288vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2013\vnta\nav2013288vntaedited.txt esecs, east, north, lat, lon, head, pres 1381851817, 0, 0, 36.696277, -121.942125, 42.0, 85.35 1381852318, 0, 0, 36.696277, -121.942125, 47.5, 88.07 1381852819, 0, 0, 36.696415, -121.941827, 351.1, 90.24 1381853320, 0, 0, 36.696400, -121.941714, 25.3, 90.61 1381853821, 0, 0, 36.696264, -121.941761, 26.0, 90.44 1381854321, 0, 0, 36.696462, -121.941723, 26.4, 90.13 1381854822, 0, 0, 36.696398, -121.941655, 25.6, 90.29 1381855323, 0, 0, 36.696404, -121.941604, 26.5, 90.26 1381855824, 0, 0, 36.696532, -121.941500, 25.4, 90.27 1381856325, 0, 0, 36.696537, -121.941712, 25.5, 90.16 1381856826, 0, 0, 36.696419, -121.941777, 26.2, 90.36 1381857326, 0, 0, 36.696293, -121.941780, 26.0, 90.16 1381857827, 0, 0, 36.696486, -121.941787, 26.7, 90.21 1381858328, 0, 0, 36.696368, -121.941689, 25.8, 90.12 1381858829, 0, 0, 36.696448, -121.941798, 354.2, 90.03 1381859330, 0, 0, 36.696647, -121.941748, 355.4, 89.88 1381859831, 0, 0, 36.696577, -121.941907, 356.7, 90.02 1381860331, 0, 0, 36.696437, -121.941808, 356.2, 91.35 1381860832, 0, 0, 36.696498, -121.941772, 356.5, 91.32 1381861333, 0, 0, 36.696419, -121.941779, 356.7, 91.30 1381861834, 0, 0, 36.696421, -121.941872, 356.4, 91.26 1381862335, 0, 0, 36.696437, -121.942027, 356.9, 91.14 1381862835, 0, 0, 36.696427, -121.941785, 356.2, 91.10 1381863336, 0, 0, 36.696357, -121.942116, 356.5, 91.08 1381863837, 0, 0, 36.696401, -121.941914, 355.4, 90.98 1381864338, 0, 0, 36.696333, -121.941996, 355.9, 91.10 1381864839, 0, 0, 36.696276, -121.942001, 355.5, 91.01 1381865339, 0, 0, 36.696596, -121.941924, 352.4, 89.80 1381865840, 0, 0, 36.696280, -121.942067, 355.8, 89.29 1381866341, 0, 0, 36.696250, -121.941817, 352.8, 89.11 1381866842, 0, 0, 36.696252, -121.942044, 353.9, 88.84 1381867343, 0, 0, 36.696336, -121.941842, 352.7, 89.11 1381867843, 0, 0, 36.696385, -121.frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2013/288/accesses.txt at bin\geopdvc.pl line 2382 frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2013/288/accesses.txt at bin\geopdvc.pl line 625 frameGrabs(): Can't read dir http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2013/vnta3740: Bad file descriptor at bin\geopdvc.pl line 625 941953, 353.3, 88.87 1381868344, 0, 0, 36.696264, -121.941874, 353.2, 88.83 1381868845, 0, 0, 36.696065, -121.942020, 353.2, 88.87 rovNav(): 288: 17834 in tList after reading from \\atlas\RovNavEdit\2013\vnta\nav2013288vntaedited.txt 17834 in tList 17834 in {self->{rovT}} 17834 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are & rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): rovGDCListRefs(): dMedian = 89.5836996216624 rovGDCListRefs(): dStats->sample_range = 100.412601820295 rovGDCListRefs(): returning (1st elements): 1381851317 36.696277 -121.942125 25.6 2.56093281224309 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69637700 hash{lon} = -121.94180400 latMin = 30.696377 latMax = 42.696377 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.696377 AND 42.696377 AND Longitude BETWEEN -127.941804 AND -115.941804 Dive lat = 36.69637700, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.94180400 & lat = 36.69637700 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3740rov_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 = geo2013/vnta/vnta3740lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 1919 shipNav(): $#{$self->{shipLat}}[last] = 36.697142 Position subsampling set to 14 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 = 17835 makeTracks(): Looping through 1919 point of ship position data... makeTracks(): posSubsample = 14 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3740tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2013/vnta/vnta3740mergedCtdNav.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 '10/15/2013 3:35:00 PM' AND '10/15/2013 8:11:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/15/2013 3:35:00 PM' AND '10/15/2013 8:11:00 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/2013/vnta3740... 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 '10/15/2013 3:35:00 PM' AND '10/15/2013 8:11:00 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2013/vnta/vnta3740.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',4878,'/3Dreplay/3D.asp?dives=vnta3740','vnta3740','','','',3740 Executing sql: UPDATE Dive SET DiveLatMid = 36.6964, DiveLonMid = -121.9418, DiveDepthMid = -89.6 WHERE RovName = 'vnta' AND DiveNumber = 3740