Running bin\geopdvc.pl at Mon Aug 27 16:48:59 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2723 bin\geopdvc.pl: Getting Expedition object for diveno = 2723 and rname = vnta set_expd(): rov = vnta, diveno = 2723 set_expd(): $self->{EndDDD} = 259 set_expd(): $self->{StartEsecs} = 1126884900 set_expd(): $self->{EndEsecs} = 1126900200 set_expd(): $self->{EndDtg} = 9/16/2005 7:30:00 PM _readLogr(): Reading videologr data from 2005259datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1126884900 & 1126900200 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 1528 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1126884902 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1126900198 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1126884902 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1126900198 refineStartAndEndEsecs(): setting StartEsecs to 1126884900 refineStartAndEndEsecs(): setting EndEsecs to 1126885253 refineStartAndEndEsecs(): numMinBack = 16.1166666666667, numMinForward = 11.2833333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1126885133, Refined EndEsecs = 1126899677 _readLogr(): Reading videologr data from 2005259datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1126885133 & 1126899677 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 1452 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1126885142 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1126899677 bin\geopdvc.pl: expdid = 3300 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 259 (looping to 259) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005259vntaedited.txt esecs, east, north, lat, lon, head, pres 1126885591, 0, 0, 36.737898, -122.017988, 213.9, 2.44 1126886379, 0, 0, 36.737660, -122.017908, 197.2, 112.53 1126886884, 0, 0, 36.738127, -122.018072, 197.6, 383.19 1126887389, 0, 0, 36.738388, -122.017995, 181.7, 631.83 1126887894, 0, 0, 36.738548, -122.018178, 150.8, 873.45 1126888399, 0, 0, 36.738364, -122.018282, 151.7, 1085.42 1126888904, 0, 0, 36.737519, -122.017078, 116.7, 1197.22 1126889409, 0, 0, 36.737228, -122.016917, 173.6, 1282.72 1126889914, 0, 0, 36.736511, -122.016482, 155.0, 1268.19 1126890419, 0, 0, 36.735747, -122.016081, 165.9, 1288.96 1126890924, 0, 0, 36.735759, -122.015905, 134.1, 1244.49 1126891429, 0, 0, 36.734911, -122.015448, 181.1, 1284.53 1126891934, 0, 0, 36.734575, -122.015589, 145.7, 1293.80 1126892439, 0, 0, 36.734803, -122.015597, 352.2, 1294.01 1126892944, 0, 0, 36.734586, -122.015070, 160.7, 1293.47 1126893449, 0, 0, 36.734516, -122.015031, 183.4, 1294.35 1126893954, 0, 0, 36.734626, -122.015549, 215.4, 1293.76 1126894459, 0, 0, 36.734473, -122.015698, 216.7, 1280.03 1126894964, 0, 0, 36.735197, -122.016423, 263.2, 1133.85 1126895469, 0, 0, 36.735905, -122.017940, 263.4, 988.44 1126895974, 0, 0, 36.736341, -122.018757, 263.0, 821.43 1126896479, 0, 0, 36.736375, -122.018253, 264.6, 638.42 1126896984, 0, 0, 36.735759, -122.017836, 264.0, 421.75 1126897489, 0, 0, 36.735452, -122.017150, 264.9, 231.69 1126897994, 0, 0, 36.734933, -122.016685, 263.2, 57.06 259: 12791 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005259vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1126885133 rovNav(): Initial # seconds to fill at end of dive = 1210 ending at EndEsecs =1126899677 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1126885142 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1126899677 rovNav(): numMinBack = 15.9666666666667, numMinForward = 11.2833333333333 rovNav(): Refined StartEsecs = 1126885133, Refined EndEsecs = 1126899677 rovNav(): Refined # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1126885133 rovNav(): Refined # seconds to fill at end of dive = 1210 ending at EndEsecs =1126899677 rovNav(): num tList = 12791 rovNav(): num eList = 12791 rovNav(): Adding data to begining of dive from logr indices 0 .. 0 rovNav(): Adding data to end of dive from logr indices 1332 .. 1452 rovNav(): num in tList now = 12913 rovNav(): num in eList now = 12913 12913 in tList 12913 in {self->{rovT}} 12913 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1126893210 & 1126888380 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................XXXXXXXX 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 = 259 (looping to 259) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005259vnta.txt esecs, east, north, lat, lon, head, pres 1126885591, 0, 0, 36.747393, -122.052168, 213.9, 2.44 1126886379, 0, 0, 36.737667, -122.017903, 197.2, 112.53 1126886884, 0, 0, 36.738127, -122.018090, 197.6, 383.19 1126887389, 0, 0, 36.738382, -122.018010, 181.7, 631.83 1126887894, 0, 0, 36.738557, -122.018178, 150.8, 873.45 1126888399, 0, 0, 36.738370, -122.018290, 151.7, 1085.42 1126888904, 0, 0, 36.737502, -122.017083, 116.7, 1197.22 1126889409, 0, 0, 36.737248, -122.016902, 173.6, 1282.72 1126889914, 0, 0, 36.736487, -122.016492, 155.0, 1268.19 1126890419, 0, 0, 36.735740, -122.016068, 165.9, 1288.96 1126890924, 0, 0, 36.735802, -122.015960, 134.1, 1244.49 1126891429, 0, 0, 36.734982, -122.015458, 181.1, 1284.53 1126891934, 0, 0, 36.734575, -122.015580, 145.7, 1293.80 1126892439, 0, 0, 36.734827, -122.015695, 352.2, 1294.01 1126892944, 0, 0, 36.734582, -122.015070, 160.7, 1293.47 1126893449, 0, 0, 36.734502, -122.015035, 183.4, 1294.35 1126893954, 0, 0, 36.734613, -122.015547, 215.4, 1293.76 1126894459, 0, 0, 36.734337, -122.015655, 216.7, 1280.03 1126894964, 0, 0, 36.735130, -122.016362, 263.2, 1133.85 1126895469, 0, 0, 36.735940, -122.017950, 263.4, 988.44 1126895974, 0, 0, 36.736343, -122.018768, 263.0, 821.43 1126896479, 0, 0, 36.736388, -122.018217, 264.6, 638.42 1126896984, 0, 0, 36.735747, -122.017837, 264.0, 421.75 1126897489, 0, 0, 36.735440, -122.017138, 264.9, 231.69 1126897994, 0, 0, 36.734903, -122.016708, 263.2, 57.06 259: 12791 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005259vnta.txt 12791 in tList 12791 in {self->{rovT}} 12791 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1126893210 & 1126888380 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.73579750 hash{lon} = -122.01691500 latMin = 30.7357975 latMax = 42.7357975 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.7357975 AND 42.7357975 AND Longitude BETWEEN -128.016915 AND -116.016915 Dive lat = 36.73579750, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.01691500 & lat = 36.73579750 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2723rov_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 = geo2005/vnta/frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/259/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 vnta2723lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 1452 shipNav(): $#{$self->{shipLat}}[last] = 36.740035 Position subsampling set to 10 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 = 12914 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2723tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2723mergedCtdNav.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, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '9/16/2005 3:55:00 PM' AND '9/16/2005 7:30:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/16/2005 3:55:00 PM' AND '9/16/2005 7:30:00 PM') Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: 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, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '9/16/2005 3:55:00 PM' AND '9/16/2005 7:30:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/16/2005 3:55:00 PM' AND '9/16/2005 7:30:00 PM') annotations(): Error in query: 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, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '9/16/2005 3:55:00 PM' AND '9/16/2005 7:30:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/16/2005 3:55:00 PM' AND '9/16/2005 7:30:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.