Running bin\geopdvc.pl at Mon Aug 27 17:05:16 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2736 bin\geopdvc.pl: Getting Expedition object for diveno = 2736 and rname = vnta set_expd(): rov = vnta, diveno = 2736 set_expd(): $self->{EndDDD} = 283 set_expd(): $self->{StartEsecs} = 1128960645 set_expd(): $self->{EndEsecs} = 1128983100 set_expd(): $self->{EndDtg} = 10/10/2005 10:05:00 PM _readLogr(): Reading videologr data from 2005283datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1128960645 & 1128983100 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2242 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1128960648 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1128983091 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1128960648 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1128983091 refineStartAndEndEsecs(): setting StartEsecs to 1128960645 refineStartAndEndEsecs(): setting EndEsecs to 1128960658 refineStartAndEndEsecs(): numMinBack = 21.7833333333333, numMinForward = 7 refineStartAndEndEsecs(): Refined StartEsecs = 1128960538, Refined EndEsecs = 1128982320 _readLogr(): Reading videologr data from 2005283datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1128960538 & 1128982320 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2174 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1128960548 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1128982311 bin\geopdvc.pl: expdid = 3311 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 283 (looping to 283) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005283vntaedited.txt esecs, east, north, lat, lon, head, pres 1128961718, 0, 0, 36.700501, -122.051269, 287.4, 4.69 1128962223, 0, 0, 36.700741, -122.050405, 307.2, 50.56 1128962728, 0, 0, 36.701863, -122.049433, 9.7, 50.82 1128963233, 0, 0, 36.701339, -122.050124, 193.8, 100.73 1128963738, 0, 0, 36.701572, -122.049570, 193.1, 101.05 1128964243, 0, 0, 36.701339, -122.050124, 197.8, 191.02 1128964748, 0, 0, 36.701339, -122.050124, 199.4, 201.90 1128965253, 0, 0, 36.701857, -122.050031, 199.5, 302.49 1128965758, 0, 0, 36.700661, -122.051006, 199.1, 302.74 1128966263, 0, 0, 36.702075, -122.049416, 40.2, 302.96 1128966768, 0, 0, 36.703340, -122.047601, 55.4, 370.65 1128967274, 0, 0, 36.703802, -122.045448, 64.6, 403.30 1128967779, 0, 0, 36.703727, -122.044077, 192.6, 504.32 1128968284, 0, 0, 36.700823, -122.044248, 167.5, 504.55 1128968789, 0, 0, 36.700198, -122.044348, 349.0, 605.41 1128969294, 0, 0, 36.703114, -122.045177, 348.9, 605.62 1128969799, 0, 0, 36.704009, -122.045475, 349.0, 706.73 1128970304, 0, 0, 36.705591, -122.045745, 349.2, 706.89 1128970809, 0, 0, 36.706037, -122.046180, 355.8, 807.86 1128971314, 0, 0, 36.708747, -122.046571, 41.2, 811.51 1128971819, 0, 0, 36.708601, -122.046910, 190.8, 793.43 1128972324, 0, 0, 36.707959, -122.047290, 191.8, 909.09 1128972829, 0, 0, 36.705764, -122.048283, 190.7, 932.71 1128973334, 0, 0, 36.705020, -122.047506, 156.9, 1010.50 1128973839, 0, 0, 36.702596, -122.046072, 155.3, 1006.24 1128974344, 0, 0, 36.702497, -122.046084, 149.4, 944.08 1128974849, 0, 0, 36.702744, -122.046150, 29.2, 888.09 1128975354, 0, 0, 36.703504, -122.046289, 334.2, 877.66 1128975859, 0, 0, 36.704086, -122.046531, 328.9, 849.60 1128976364, 0, 0, 36.704354, -122.047218, 186.6, 841.57 1128976869, 0, 0, 36.704016, -122.047562, 187.3, 829.67 1128977374, 0, 0, 36.703642, -122.047442, 85.8, 787.20 1128977879, 0, 0, 36.703890, -122.046353, 47.9, 757.84 1128978384, 0, 0, 36.704106, -122.045807, 201.9, 731.39 1128978889, 0, 0, 36.703517, -122.046247, 203.3, 566.37 1128979394, 0, 0, 36.703216, -122.046654, 202.5, 367.92 1128979899, 0, 0, 36.702893, -122.046720, 203.4, 349.15 1128980404, 0, 0, 36.703522, -122.047032, 166.6, 336.15 1128980909, 0, 0, 36.704205, -122.046956, 230.1, 264.50 1128981414, 0, 0, 36.706492, -122.048218, 320.0, 169.05 283: 20250 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005283vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1128960538 rovNav(): Initial # seconds to fill at end of dive = 407 ending at EndEsecs =1128982320 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1128960548 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1128982311 rovNav(): numMinBack = 21.6166666666667, numMinForward = 6.85 rovNav(): Refined StartEsecs = 1128960538, Refined EndEsecs = 1128982320 rovNav(): Refined # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1128960538 rovNav(): Refined # seconds to fill at end of dive = 407 ending at EndEsecs =1128982320 rovNav(): num tList = 20250 rovNav(): num eList = 20250 rovNav(): Adding data to begining of dive from logr indices 0 .. 0 rovNav(): Adding data to end of dive from logr indices 2135 .. 2174 rovNav(): num in tList now = 20291 rovNav(): num in eList now = 20291 20291 in tList 20291 in {self->{rovT}} 20291 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1128976095 & 1128968445 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXX 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 = 283 (looping to 283) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005283vnta.txt esecs, east, north, lat, lon, head, pres 1128961718, 0, 0, 36.700500, -122.051295, 287.4, 4.69 1128962223, 0, 0, 36.700728, -122.050395, 307.2, 50.56 1128962728, 0, 0, 36.699985, -122.049057, 9.7, 50.82 1128963233, 0, 0, 36.703885, -122.044048, 193.8, 100.73 1128963738, 0, 0, 36.703492, -122.040130, 193.1, 101.05 1128964243, 0, 0, 36.700837, -122.042155, 197.8, 191.02 1128964748, 0, 0, 36.705865, -122.047295, 199.4, 201.90 1128965253, 0, 0, 36.704053, -122.038038, 199.5, 302.49 1128965758, 0, 0, 36.700625, -122.051012, 199.1, 302.74 1128966263, 0, 0, 36.702067, -122.049418, 40.2, 302.96 1128966768, 0, 0, 36.703375, -122.047627, 55.4, 370.65 1128967274, 0, 0, 36.703800, -122.045458, 64.6, 403.30 1128967779, 0, 0, 36.703767, -122.044062, 192.6, 504.32 1128968284, 0, 0, 36.700848, -122.044278, 167.5, 504.55 1128968789, 0, 0, 36.700167, -122.044315, 349.0, 605.41 1128969294, 0, 0, 36.700745, -122.040422, 348.9, 605.62 1128969799, 0, 0, 36.700738, -122.040408, 349.0, 706.73 1128970304, 0, 0, 36.705643, -122.045712, 349.2, 706.89 1128970809, 0, 0, 36.705982, -122.046170, 355.8, 807.86 1128971314, 0, 0, 36.708787, -122.046558, 41.2, 811.51 1128971819, 0, 0, 36.708582, -122.046917, 190.8, 793.43 1128972324, 0, 0, 36.707950, -122.047282, 191.8, 909.09 1128972829, 0, 0, 36.705755, -122.048297, 190.7, 932.71 1128973334, 0, 0, 36.705043, -122.047535, 156.9, 1010.50 1128973839, 0, 0, 36.702575, -122.046073, 155.3, 1006.24 1128974344, 0, 0, 36.702490, -122.046088, 149.4, 944.08 1128974849, 0, 0, 36.702753, -122.046160, 29.2, 888.09 1128975354, 0, 0, 36.703508, -122.046298, 334.2, 877.66 1128975859, 0, 0, 36.704083, -122.046547, 328.9, 849.60 1128976364, 0, 0, 36.704367, -122.047227, 186.6, 841.57 1128976869, 0, 0, 36.704020, -122.047555, 187.3, 829.67 1128977374, 0, 0, 36.703637, -122.047437, 85.8, 787.20 1128977879, 0, 0, 36.703888, -122.046318, 47.9, 757.84 1128978384, 0, 0, 36.704128, -122.045807, 201.9, 731.39 1128978889, 0, 0, 36.703508, -122.046243, 203.3, 566.37 1128979394, 0, 0, 36.703202, -122.046657, 202.5, 367.92 1128979899, 0, 0, 36.702912, -122.046742, 203.4, 349.15 1128980404, 0, 0, 36.703490, -122.047042, 166.6, 336.15 1128980909, 0, 0, 36.704202, -122.046938, 230.1, 264.50 1128981414, 0, 0, 36.706512, -122.048245, 320.0, 169.05 283: 20250 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005283vnta.txt 20250 in tList 20250 in {self->{rovT}} 20250 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1128976095 & 1128968445 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70361000 hash{lon} = -122.04667700 latMin = frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/283/accesses.txt at bin\geopdvc.pl line 2169 30.70361 latMax = 42.70361 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.70361 AND 42.70361 AND Longitude BETWEEN -128.046677 AND -116.046677 Dive lat = 36.70361000, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04667700 & lat = 36.70361000 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2736rov_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/vnta2736lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 92 shipNav(): $#{$self->{shipLat}}[last] = 36.700418 Position subsampling set to 16 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 = 20292 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2736tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2736mergedCtdNav.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 '10/10/2005 4:30:45 PM' AND '10/10/2005 10:05:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/10/2005 4:30:45 PM' AND '10/10/2005 10:05: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 '10/10/2005 4:30:45 PM' AND '10/10/2005 10:05:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/10/2005 4:30:45 PM' AND '10/10/2005 10:05: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 '10/10/2005 4:30:45 PM' AND '10/10/2005 10:05:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/10/2005 4:30:45 PM' AND '10/10/2005 10:05:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; at bin\geopdvc.pl line 542 Invalid column name 'FormatCode'.