Running bin\geopdvc.pl at Mon Aug 27 18:10:50 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2763 bin\geopdvc.pl: Getting Expedition object for diveno = 2763 and rname = vnta set_expd(): rov = vnta, diveno = 2763 set_expd(): $self->{EndDDD} = 327 set_expd(): $self->{StartEsecs} = 1132764630 set_expd(): $self->{EndEsecs} = 1132788660 set_expd(): $self->{EndDtg} = 11/23/2005 11:11:00 PM _readLogr(): Reading videologr data from 2005327datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1132764630 & 1132788660 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2400 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1132764634 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1132788659 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1132764634 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1132788659 refineStartAndEndEsecs(): setting StartEsecs to 1132764630 refineStartAndEndEsecs(): setting EndEsecs to 1132765605 refineStartAndEndEsecs(): numMinBack = 5.75, numMinForward = 14.1333333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1132765485, Refined EndEsecs = 1132788308 _readLogr(): Reading videologr data from 2005327datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1132765485 & 1132788308 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2279 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1132765495 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1132788308 bin\geopdvc.pl: expdid = 3336 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 327 (looping to 327) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005327vntaedited.txt esecs, east, north, lat, lon, head, pres 1132766117, 0, 0, 36.777074, -122.012372, 325.9, 126.04 1132766622, 0, 0, 36.776967, -122.012633, 273.9, 353.52 1132767127, 0, 0, 36.777005, -122.012993, 52.6, 588.67 1132767632, 0, 0, 36.777245, -122.012751, 11.3, 816.63 1132768137, 0, 0, 36.777090, -122.013127, 75.7, 954.99 1132768642, 0, 0, 36.778064, -122.010953, 66.1, 984.92 1132769147, 0, 0, 36.779453, -122.009858, 24.6, 988.87 1132769652, 0, 0, 36.779290, -122.007939, 126.8, 969.22 1132770157, 0, 0, 36.778131, -122.008666, 196.9, 976.56 1132770662, 0, 0, 36.776302, -122.009589, 221.2, 971.47 1132771167, 0, 0, 36.777612, -122.009660, 104.3, 959.97 1132771672, 0, 0, 36.775578, -122.010978, 78.9, 949.64 1132772177, 0, 0, 36.776286, -122.009132, 46.9, 978.36 1132772682, 0, 0, 36.777985, -122.006352, 322.0, 938.63 1132773188, 0, 0, 36.779608, -122.008605, 310.8, 977.81 1132773693, 0, 0, 36.781286, -122.011304, 149.5, 963.65 1132774198, 0, 0, 36.779096, -122.008603, 130.0, 974.03 1132774703, 0, 0, 36.777693, -122.007186, 311.1, 962.07 1132775208, 0, 0, 36.780434, -122.010941, 310.1, 991.38 1132775713, 0, 0, 36.779422, -122.010296, 133.0, 987.90 1132776218, 0, 0, 36.777201, -122.007246, 130.6, 956.34 1132776723, 0, 0, 36.778926, -122.010221, 311.0, 988.19 1132777228, 0, 0, 36.779504, -122.011571, 132.1, 988.63 1132777733, 0, 0, 36.777109, -122.008463, 132.1, 974.31 1132778238, 0, 0, 36.777329, -122.009242, 312.7, 989.00 1132778743, 0, 0, 36.779854, -122.012393, 312.5, 994.15 1132779248, 0, 0, 36.778059, -122.010648, 133.5, 988.00 1132779753, 0, 0, 36.776085, -122.008489, 190.6, 985.48 1132780258, 0, 0, 36.778181, -122.011386, 312.1, 989.71 1132780763, 0, 0, 36.779188, -122.013266, 236.1, 990.44 1132781268, 0, 0, 36.776947, -122.010337, 130.1, 987.46 1132781773, 0, 0, 36.776038, -122.009132, 310.8, 962.98 1132782278, 0, 0, 36.777977, -122.011800, 308.5, 988.73 1132782783, 0, 0, 36.778844, -122.013479, 345.2, 990.34 1132783288, 0, 0, 36.776567, -122.010537, 132.3, 970.36 1132783793, 0, 0, 36.775792, -122.009858, 311.3, 935.50 1132784298, 0, 0, 36.777896, -122.012628, 311.2, 986.80 1132784803, 0, 0, 36.777401, -122.012468, 37.4, 986.11 1132785308, 0, 0, 36.778946, -122.010407, 323.9, 887.86 1132785813, 0, 0, 36.779572, -122.010176, 324.4, 655.77 1132786318, 0, 0, 36.779998, -122.009586, 325.1, 452.36 1132786823, 0, 0, 36.779884, -122.009586, 53.8, 239.85 1132787329, 0, 0, 36.779605, -122.009505, 53.5, 62.89 327: 21756 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005327vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 128 starting at StartEsecs = 1132765485 rovNav(): Initial # seconds to fill at end of dive = 242 ending at EndEsecs =1132788308 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1132765495 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1132788308 rovNav(): numMinBack = 5.58333333333333, numMinForward = 14.1333333333333 rovNav(): Refined StartEsecs = 1132765485, Refined EndEsecs = 1132788308 rovNav(): Refined # seconds to fill at beginning of dive = 128 starting at StartEsecs = 1132765485 rovNav(): Refined # seconds to fill at end of dive = 242 ending at EndEsecs =1132788308 rovNav(): num tList = 21756 rovNav(): num eList = 21756 rovNav(): Adding data to begining of dive from logr indices 0 .. 11 rovNav(): Adding data to end of dive from logr indices 2255 .. 2279 rovNav(): num in tList now = 21793 rovNav(): num in eList now = 21793 21793 in tList 21793 in {self->{rovT}} 21793 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1132766235 & 1132786440 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................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 = 327 (looping to 327) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005327vnta.txt esecs, east, north, lat, lon, head, pres 1132766117, 0, 0, 36.777122, -122.012383, 325.9, 126.04 1132766622, 0, 0, 36.777000, -122.012658, 273.9, 353.52 1132767127, 0, 0, 36.777047, -122.013000, 52.6, 588.66 1132767632, 0, 0, 36.777370, -122.012542, 11.3, 816.63 1132768137, 0, 0, 36.777100, -122.013115, 75.7, 954.99 1132768642, 0, 0, 36.777332, -122.012697, 66.1, 984.92 1132769147, 0, 0, 36.779455, -122.009810, 24.6, 988.87 1132769652, 0, 0, 36.779232, -122.008023, 126.8, 969.22 1132770157, 0, 0, 36.777925, -122.008605, 196.9, 976.56 1132770662, 0, 0, 36.776305, -122.009610, 221.2, 971.47 1132771167, 0, 0, 36.775875, -122.011298, 104.3, 959.97 1132771672, 0, 0, 36.775398, -122.010547, 78.9, 949.64 1132772177, 0, 0, 36.776252, -122.009163, 46.9, 978.36 1132772682, 0, 0, 36.777942, -122.006255, 322.0, 938.63 1132773188, 0, 0, 36.779598, -122.008593, 310.8, 977.81 1132773693, 0, 0, 36.781307, -122.011377, 149.5, 963.65 1132774198, 0, 0, 36.779102, -122.008608, 130.0, 974.03 1132774703, 0, 0, 36.777632, -122.007093, 311.1, 962.07 1132775208, 0, 0, 36.780452, -122.010910, 310.1, 991.38 1132775713, 0, 0, 36.779447, -122.010307, 133.0, 987.90 1132776218, 0, 0, 36.777207, -122.007220, 130.6, 956.34 1132776723, 0, 0, 36.778918, -122.010273, 311.0, 988.19 1132777228, 0, 0, 36.779508, -122.011615, 132.1, 988.63 1132777733, 0, 0, 36.777070, -122.008443, 132.1, 974.31 1132778238, 0, 0, 36.777280, -122.009212, 312.7, 989.00 1132778743, 0, 0, 36.779873, -122.012370, 312.5, 994.15 1132779248, 0, 0, 36.778112, -122.010712, 133.5, 988.00 1132779753, 0, 0, 36.776128, -122.008483, 190.6, 985.48 1132780258, 0, 0, 36.778193, -122.011400, 312.1, 989.71 1132780763, 0, 0, 36.779210, -122.013297, 236.1, 990.44 1132781268, 0, 0, 36.776903, -122.010322, 130.1, 987.46 1132781773, 0, 0, 36.776047, -122.009102, 310.8, 962.98 1132782278, 0, 0, 36.777962, -122.011800, 308.5, 988.73 1132782783, 0, 0, 36.778857, -122.013507, 345.2, 990.34 1132783288, 0, 0, 36.776548, -122.010527, 132.3, 970.36 1132783793, 0, 0, 36.775793, -122.009833, 311.3, 935.50 1132784298, 0, 0, 36.777910, -122.012650, 311.2, 986.80 1132784803, 0, 0, 36.777308, -122.012372, 37.4, 986.11 1132785308, 0, 0, 36.778957, -122.010402, 323.9, 887.86 1132785813, 0, 0, 36.779600, -122.010183, 324.4, 655.77 1132786318, 0, 0, 36.780013, -122.009585, 325.1, 452.36 1132786823, 0, 0, 36.779888, -122.009595, 53.8, 239.85 1132787329, 0, 0, 36.779580, -122.009478, 53.5, 62.89 327: 21756 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005327vnta.txt 21756 in tList 21756 in {self->{rovT}} 21756 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1132766235 & 1132786440 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.77796800 hash{lon} = -122.01032700 latMin = 30.777968 latMax = 42.777968 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.777968 AND 42.777968 AND Longitude BETWEEN -128.010327 AND -116.010327 Dive lat = 36.77796800, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.01032700 & lat = 36.77796800 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2763rov_orig.wrl Making color frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/327/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 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/vnta2763lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2279 shipNav(): $#{$self->{shipLat}}[last] = 36.778500 Position subsampling set to 17 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 = 21794 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2763tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2763mergedCtdNav.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 '11/23/2005 5:10:30 PM' AND '11/23/2005 11:11:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/23/2005 5:10:30 PM' AND '11/23/2005 11:11: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 '11/23/2005 5:10:30 PM' AND '11/23/2005 11:11:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/23/2005 5:10:30 PM' AND '11/23/2005 11:11: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 '11/23/2005 5:10:30 PM' AND '11/23/2005 11:11:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/23/2005 5:10:30 PM' AND '11/23/2005 11:11:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.