Running .\bin\geopdvc.pl at Thu Sep 13 17:11:57 2007 on host scyphozoan Command line: .\bin\geopdvc.pl -rov vnta -dive 2860 .\bin\geopdvc.pl: Getting Expedition object for diveno = 2860 and rname = vnta set_expd(): rov = vnta, diveno = 2860 set_expd(): $self->{EndDDD} = 208 set_expd(): $self->{StartEsecs} = 1154027595 set_expd(): $self->{EndEsecs} = 1154036670 set_expd(): $self->{EndDtg} = 7/27/2006 9:24:30 PM _readLogr(): Reading videologr data from 2006208datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1154027595 & 1154036670 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 906 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1154027597 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1154036667 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1154027597 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1154036667 refineStartAndEndEsecs(): setting StartEsecs to 1154027595 refineStartAndEndEsecs(): setting EndEsecs to 1154027617 refineStartAndEndEsecs(): numMinBack = 21.6333333333333, numMinForward = 6.93333333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1154027497, Refined EndEsecs = 1154035886 _readLogr(): Reading videologr data from 2006208datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1154027497 & 1154035886 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 837 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1154027507 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1154035886 .\bin\geopdvc.pl: expdid = 3485 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 208 (looping to 208) rovNav(): Opening ROV nav data from \\tornado\TempNav\2006\vnta\nav2006208vntaedited.txt esecs, east, north, lat, lon, head, pres 1154027605, 0, 0, 36.862443, -122.149389, 318.1, 29.56 1154029094, 0, 0, 36.862522, -122.148756, 8.3, 81.06 1154029599, 0, 0, 36.862495, -122.148727, 347.0, 104.50 1154030104, 0, 0, 36.862593, -122.148665, 287.7, 103.81 1154030609, 0, 0, 36.862414, -122.148648, 10.9, 102.49 1154031114, 0, 0, 36.862395, -122.148371, 358.2, 104.55 1154031619, 0, 0, 36.862360, -122.148336, 314.8, 103.34 1154032124, 0, 0, 36.862477, -122.148273, 325.7, 102.56 1154032629, 0, 0, 36.862437, -122.148300, 301.7, 102.58 1154033134, 0, 0, 36.862397, -122.148296, 30.5, 102.51 1154033639, 0, 0, 36.862395, -122.148311, 346.1, 102.22 1154034144, 0, 0, 36.862350, -122.148396, 306.1, 103.95 1154034649, 0, 0, 36.862422, -122.148537, 223.1, 104.45 1154035154, 0, 0, 36.862422, -122.148561, 323.9, 16.07 208: 6813 in tList after reading from \\tornado\TempNav\2006\vnta\nav2006208vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1154027497 rovNav(): Initial # seconds to fill at end of dive = 183 ending at EndEsecs =1154035886 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1154027507 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1154035886 rovNav(): numMinBack = 21.4666666666667, numMinForward = 6.93333333333333 rovNav(): Refined StartEsecs = 1154027497, Refined EndEsecs = 1154035886 rovNav(): Refined # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1154027497 rovNav(): Refined # seconds to fill at end of dive = 183 ending at EndEsecs =1154035886 rovNav(): num tList = 6813 rovNav(): num eList = 6813 rovNav(): Adding data to begining of dive from logr indices 0 .. 0 rovNav(): Adding data to end of dive from logr indices 819 .. 837 rovNav(): num in tList now = 6833 rovNav(): num in eList now = 6833 6833 in tList 6833 in {self->{rovT}} 6833 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1154033925 & 1154034765 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................XXXXXXX .\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 = 208 (looping to 208) rovNav(): Opening ROV nav data from \\tornado\TempNav\2006\vnta\nav2006208vnta.txt esecs, east, north, lat, lon, head, pres 1154027605, 0, 0, 36.862410, -122.149385, 318.1, 29.56 1154029094, 0, 0, 36.862507, -122.148775, 8.3, 81.06 1154029599, 0, 0, 36.862602, -122.148735, 347.0, 104.50 1154030104, 0, 0, 36.862575, -122.148663, 287.7, 103.81 1154030609, 0, 0, 36.862418, -122.148665, 10.9, 102.49 1154031114, 0, 0, 36.862380, -122.148357, 358.2, 104.55 1154031619, 0, 0, 36.862365, -122.148362, 314.8, 103.34 1154032124, 0, 0, 36.862477, -122.148270, 325.7, 102.56 1154032629, 0, 0, 36.862447, -122.148323, 301.7, 102.58 1154033134, 0, 0, 36.862408, -122.148305, 30.5, 102.51 1154033639, 0, 0, 36.862375, -122.148298, 346.1, 102.22 1154034144, 0, 0, 36.862333, -122.148415, 306.1, 103.95 1154034649, 0, 0, 36.862413, -122.148540, 223.1, 104.45 1154035154, 0, 0, 36.862433, -122.148580, 323.9, 16.07 208: 6813 in tList after reading from \\tornado\TempNav\2006\vnta\nav2006208vnta.txt 6813 in tList 6813 in {self->{rovT}} 6813 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1154033925 & 1154034765 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/208/accesses.txt at .\bin\geopdvc.pl line 2188 .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................XXXXXXX .\bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.86241700 hash{lon} = -122.14848300 latMin = 30.862417 latMax = 42.862417 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.862417 AND 42.862417 AND Longitude BETWEEN -128.148483 AND -116.148483 Dive lat = 36.86241700, area = cencal .\bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.14848300 & lat = 36.86241700 Using olon = -122 & olat = 36 .\bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2860rov_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 = geo2006/vnta/vnta2860lookup.wrl .\bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 837 shipNav(): $#{$self->{shipLat}}[last] = 36.861707 Position subsampling set to 6 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 = 6834 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2860tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2006/vnta/vnta2860mergedCtdNav.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 = 'Point Lobos') AND (RecordedDate BETWEEN '7/27/2006 7:33:15 PM' AND '7/27/2006 9:24:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/27/2006 7:33:15 PM' AND '7/27/2006 9:24:30 PM') _findIndex(): Looking for epoch secs 1154029497 ... Found time 1154029501 after 6 iterations. >>> p = 1010: annotations(): 1010, 1154029497, 07/27/06 19:44:57, V2859-03, 02:06:28:09, equipment, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/2859/02_06_28_09.jpg, , cruise, lonny, o, 2130881 _findIndex(): Looking for epoch secs 1154030438 ... Found time 1154030442 after 7 iterations. >>> p = 1941: annotations(): 1941, 1154030438, 07/27/06 20:00:38, V2859-03, 02:22:07:23, equipment, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/2859/02_22_07_23.jpg, , cruise, lonny, o, 2131078 _findIndex(): Looking for epoch secs 1154032123 ... Found time 1154032121 after 8 iterations. >>> p = 3604: annotations(): 3604, 1154032123, 07/27/06 20:28:43, V2859-03, 02:50:11:20, equipment, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/2859/02_50_11_20.jpg, , cruise, lonny, o, 2131103 _findIndex(): Looking for epoch secs 1154033427 ... Found time 1154033426 after 4 iterations. >>> p = 4896: annotations(): 4896, 1154033427, 07/27/06 20:50:27, V2859-04, 03:11:32:21, equipment, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/2859/03_11_32_21.jpg, , cruise, lonny, o, 2131358 _findIndex(): Looking for epoch secs 1154034454 ... Found time 1154034453 after 9 iterations. >>> p = 5913: annotations(): 5913, 1154034454, 07/27/06 21:07:34, V2859-04, 03:28:40:16, object, , , ascend, lonny, o, 2131385 _findIndex(): Looking for epoch secs 1154034460 ... Found time 1154034460 after 8 iterations. >>> p = 5920: annotations(): 5920, 1154034460, 07/27/06 21:07:40, V2859-04, 03:28:44:10, video-mosaic, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/2859/03_28_44_10.jpg, , ascend, lonny, o, 2131386 .\bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... inline_name = vnta2860anno10.wrl .\bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: equipment Ancillary data = ["equipment", "P: 100.3 db", "T: 10.406 C", "S: 33.932", "O: 3.02 ml/l", "L: 82.6 %"] placeAnnotations(): Placing annotation 4: object Ancillary data = ["object", "P: 100 db", "T: 10.378 C", "S: 33.934", "O: 2.99 ml/l", "L: 82.3 %"] placeAnnotations(): Placing annotation 6: Ancillary data = ["", "P: 98.9 db", "T: 10.292 C", "S: 33.941", "O: 2.87 ml/l", "L: 83.1 %"] inline_name = vnta2860anno02.wrl .\bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: equipment Ancillary data = ["equipment", "P: 102 db", "T: 10.412 C", "S: 33.929", "O: 3.03 ml/l", "L: 82.7 %"] placeAnnotations(): Placing annotation 2: equipment Ancillary data = ["equipment", "P: 100.3 db", "T: 10.406 C", "S: 33.932", "O: 3.02 ml/l", "L: 82.6 %"] placeAnnotations(): Placing annotation 3: equipment Ancillary data = ["equipment", "P: 100.1 db", "T: 10.388 C", "S: 33.932", "O: 3 ml/l", "L: 82 %"] placeAnnotations(): Placing annotation 4: object Ancillary data = ["object", "P: 100 db", "T: 10.378 C", "S: 33.934", "O: 2.99 ml/l", "L: 82.3 %"] placeAnnotations(): Placing annotation 5: video-mosaic Ancillary data = ["video-mosaic", "P: 98.frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/208/accesses.txt at .\bin\geopdvc.pl line 554 frameGrabs(): Can't read dir http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/vnta2860: Bad file descriptor at .\bin\geopdvc.pl line 554 6 db", "T: 10.293 C", "S: 33.942", "O: 2.87 ml/l", "L: 83.2 %"] placeAnnotations(): Placing annotation 6: Ancillary data = ["", "P: 98.9 db", "T: 10.292 C", "S: 33.941", "O: 2.87 ml/l", "L: 83.1 %"] inline_name = vnta2860anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/vnta2860... iList = .\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/27/2006 7:33:15 PM' AND '7/27/2006 9:24:30 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG .\bin\geopdvc.pl: World = geo2006/vnta/vnta2860.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3485,'/3Dreplay/3D.asp?dives=vnta2860','vnta2860','','','',2860 Executing sql: UPDATE Dive SET DiveLatMid = 36.8624, DiveLonMid = -122.1485, DiveDepthMid = -102.0 WHERE RovName = 'vnta' AND DiveNumber = 2860