Running bin\geopdvc.pl at Mon Aug 27 17:37:13 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2755 bin\geopdvc.pl: Getting Expedition object for diveno = 2755 and rname = vnta set_expd(): rov = vnta, diveno = 2755 set_expd(): $self->{EndDDD} = 308 set_expd(): $self->{StartEsecs} = 1131122040 set_expd(): $self->{EndEsecs} = 1131145920 set_expd(): $self->{EndDtg} = 11/4/2005 10:52:00 PM _readLogr(): Reading videologr data from 2005308datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1131122040 & 1131145920 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2385 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1131122044 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1131145918 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1131122044 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1131145918 refineStartAndEndEsecs(): setting StartEsecs to 1131122040 refineStartAndEndEsecs(): setting EndEsecs to 1131123215 refineStartAndEndEsecs(): numMinBack = 2.41666666666667, numMinForward = 6.28333333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1131123095, Refined EndEsecs = 1131145097 _readLogr(): Reading videologr data from 2005308datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1131123095 & 1131145097 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2197 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1131123105 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1131145097 bin\geopdvc.pl: expdid = 3322 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 308 (looping to 308) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005308vntaedited.txt esecs, east, north, lat, lon, head, pres 1131123594, 0, 0, 36.774268, -122.083383, 184.6, 65.98 1131124099, 0, 0, 36.774511, -122.083877, 135.4, 210.49 1131124604, 0, 0, 36.774251, -122.083869, 136.7, 396.07 1131125109, 0, 0, 36.774142, -122.083941, 136.0, 619.20 1131125615, 0, 0, 36.773745, -122.083446, 135.0, 847.23 1131126120, 0, 0, 36.773767, -122.083530, 181.0, 1009.68 1131126625, 0, 0, 36.773467, -122.083675, 180.1, 1009.94 1131127130, 0, 0, 36.773450, -122.083756, 180.6, 1010.00 1131127635, 0, 0, 36.773299, -122.083803, 180.6, 1010.24 1131128140, 0, 0, 36.773268, -122.083961, 180.9, 1010.27 1131128645, 0, 0, 36.773181, -122.083846, 181.0, 1010.25 1131129150, 0, 0, 36.773247, -122.084075, 180.2, 1010.27 1131129655, 0, 0, 36.773187, -122.084119, 180.9, 1010.27 1131130160, 0, 0, 36.772987, -122.084520, 180.5, 1010.27 1131130665, 0, 0, 36.772798, -122.084483, 179.7, 1010.24 1131131170, 0, 0, 36.772781, -122.084479, 180.1, 1010.27 1131131675, 0, 0, 36.772875, -122.084875, 180.2, 1010.26 1131132180, 0, 0, 36.772822, -122.084653, 181.0, 1010.35 1131132685, 0, 0, 36.773027, -122.085005, 180.2, 1010.23 1131133190, 0, 0, 36.772972, -122.084440, 180.1, 1010.27 1131133695, 0, 0, 36.773132, -122.084957, 180.1, 1010.32 1131134200, 0, 0, 36.773216, -122.085031, 181.7, 1010.25 1131134705, 0, 0, 36.773270, -122.084707, 180.5, 1010.28 1131135210, 0, 0, 36.773413, -122.084672, 179.8, 1010.27 1131135715, 0, 0, 36.773684, -122.084239, 156.8, 995.98 1131136220, 0, 0, 36.774411, -122.083890, 354.7, 813.34 1131136725, 0, 0, 36.774359, -122.084716, 80.4, 605.07 1131137230, 0, 0, 36.773937, -122.085962, 80.2, 504.38 1131137735, 0, 0, 36.773451, -122.087235, 79.7, 504.74 1131138240, 0, 0, 36.773025, -122.088331, 79.8, 504.84 1131138746, 0, 0, 36.772549, -122.089030, 79.6, 504.85 1131139251, 0, 0, 36.772362, -122.089529, 82.1, 500.04 1131139756, 0, 0, 36.772257, -122.089335, 83.8, 292.22 1131140261, 0, 0, 36.772408, -122.089731, 86.4, 116.49 1131140766, 0, 0, 36.772939, -122.090796, 84.7, 5.47 1131141271, 0, 0, 36.774000, -122.092121, 83.6, 5.58 1131141776, 0, 0, 36.773984, -122.092104, 82.8, 5.66 1131142281, 0, 0, 36.773993, -122.092108, 83.2, 5.65 1131142786, 0, 0, 36.773669, -122.094368, 83.9, 5.68 1131143291, 0, 0, 36.773348, -122.095537, 84.5, 5.68 1131143796, 0, 0, 36.773953, -122.100251, 82.9, 5.61 1131144301, 0, 0, 36.773920, -122.100243, 83.5, 5.71 308: 21252 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005308vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 141 starting at StartEsecs = 1131123095 rovNav(): Initial # seconds to fill at end of dive = 155 ending at EndEsecs =1131145097 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1131123105 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1131145097 rovNav(): numMinBack = 2.25, numMinForward = 6.28333333333333 rovNav(): Refined StartEsecs = 1131123095, Refined EndEsecs = 1131145097 rovNav(): Refined # seconds to fill at beginning of dive = 141 starting at StartEsecs = 1131123095 rovNav(): Refined # seconds to fill at end of dive = 155 ending at EndEsecs =1131145097 rovNav(): num tList = 21252 rovNav(): num eList = 21252 rovNav(): Adding data to begining of dive from logr indices 0 .. 13 rovNav(): Adding data to end of dive from logr indices 2182 .. 2197 rovNav(): num in tList now = 21282 rovNav(): num in eList now = 21282 21282 in tList 21282 in {self->{rovT}} 21282 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1131124935 & 1131144315 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 = 308 (looping to 308) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005308vnta.txt esecs, east, north, lat, lon, head, pres 1131123594, 0, 0, 36.774212, -122.083332, 184.6, 65.98 1131124099, 0, 0, 36.774493, -122.083883, 135.4, 210.49 1131124604, 0, 0, 36.774243, -122.083883, 136.7, 396.07 1131125109, 0, 0, 36.774148, -122.083958, 136.0, 619.20 1131125615, 0, 0, 36.773753, -122.083448, 135.0, 847.23 1131126120, 0, 0, 36.773768, -122.083545, 181.0, 1009.68 1131126625, 0, 0, 36.773430, -122.083707, 180.1, 1009.94 1131127130, 0, 0, 36.773467, -122.083740, 180.6, 1010.00 1131127635, 0, 0, 36.773300, -122.083815, 180.6, 1010.24 1131128140, 0, 0, 36.773267, -122.083995, 180.9, 1010.27 1131128645, 0, 0, 36.773168, -122.083837, 181.0, 1010.25 1131129150, 0, 0, 36.773232, -122.084082, 180.2, 1010.27 1131129655, 0, 0, 36.773172, -122.084118, 180.9, 1010.27 1131130160, 0, 0, 36.772987, -122.084532, 180.5, 1010.27 1131130665, 0, 0, 36.772795, -122.084477, 179.7, 1010.24 1131131170, 0, 0, 36.772770, -122.084457, 180.1, 1010.27 1131131675, 0, 0, 36.772853, -122.084887, 180.2, 1010.26 1131132180, 0, 0, 36.772825, -122.084623, 181.0, 1010.35 1131132685, 0, 0, 36.773065, -122.084997, 180.2, 1010.23 1131133190, 0, 0, 36.772957, -122.084437, 180.1, 1010.27 1131133695, 0, 0, 36.773113, -122.084960, 180.1, 1010.32 1131134200, 0, 0, 36.773220, -122.085058, 181.7, 1010.25 1131134705, 0, 0, 36.773262, -122.084695, 180.5, 1010.28 1131135210, 0, 0, 36.773358, -122.084675, 179.8, 1010.27 1131135715, 0, 0, 36.773700, -122.084222, 156.8, 995.98 1131136220, 0, 0, 36.774478, -122.083905, 354.7, 813.34 1131136725, 0, 0, 36.774367, -122.084725, 80.4, 605.07 1131137230, 0, 0, 36.779060, -122.093925, 80.2, 504.38 1131137735, 0, 0, 36.773450, -122.087240, 79.7, 504.74 1131138240, 0, 0, 36.773012, -122.088355, 79.8, 504.84 1131138746, 0, 0, 36.772555, -122.089040, 79.6, 504.85 1131139251, 0, 0, 36.772378, -122.089658, 82.1, 500.04 1131139756, 0, 0, 36.772253, -122.089347, 83.8, 292.22 1131140261, 0, 0, 36.772395, -122.089768, 86.4, 116.49 1131140766, 0, 0, 36.773095, -122.089325, 84.7, 5.47 1131141271, 0, 0, 36.774000, -122.092127, 83.6, 5.58 1131141776, 0, 0, 36.773982, -122.092108, 82.8, 5.66 1131142281, 0, 0, 36.773987, -122.092103, 83.2, 5.65 1131142786, 0, 0, 36.773183, -122.093503, 83.9, 5.68 1131143291, 0, 0, 36.771895, -122.094445, 84.5, 5.68 1131143796, 0, 0, 36.772207, -122.098357, 82.9, 5.61 1131144301, 0, 0, 36.773938, -122.100240, 83.5, 5.71 308: 21252 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005308vnta.txt 21252 in tList 21252 in {self->{rovT}} 21252 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1131124935 & 1131144315 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/308/accesses.txt at bin\geopdvc.pl line 2169 ...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.77325200 hash{lon} = -122.08469800 latMin = 30.773252 latMax = 42.773252 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.773252 AND 42.773252 AND Longitude BETWEEN -128.084698 AND -116.084698 Dive lat = 36.77325200, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.08469800 & lat = 36.77325200 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2755rov_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/vnta2755lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2197 shipNav(): $#{$self->{shipLat}}[last] = 36.773175 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 = 21283 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2755tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/v at bin\geopdvc.pl line 542 nta/vnta2755mergedCtdNav.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/4/2005 4:54:00 PM' AND '11/4/2005 10:52:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/4/2005 4:54:00 PM' AND '11/4/2005 10:52: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/4/2005 4:54:00 PM' AND '11/4/2005 10:52:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/4/2005 4:54:00 PM' AND '11/4/2005 10:52: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/4/2005 4:54:00 PM' AND '11/4/2005 10:52:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/4/2005 4:54:00 PM' AND '11/4/2005 10:52:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.