Running bin\geopdvc.pl at Mon Aug 27 17:58:17 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2761 bin\geopdvc.pl: Getting Expedition object for diveno = 2761 and rname = vnta set_expd(): rov = vnta, diveno = 2761 set_expd(): $self->{EndDDD} = 322 set_expd(): $self->{StartEsecs} = 1132246035 set_expd(): $self->{EndEsecs} = 1132273170 set_expd(): $self->{EndDtg} = 11/17/2005 11:59:30 PM _readLogr(): Reading videologr data from 2005321datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1132246035 & 1132273170 _readLogr(): Flushing variable names: _readLogr(): Calling _readAnotherLogr() with nextDDD = 322 _readAnotherLogr(): DDD = 322 _readAnotherLogr(): Reading logr data from 2005322datavislogr.dat.gz. _readAnotherLogr(): Expedition start & stop times are 1132246035 & 1132273170 _readLogr(): #LOGHOST_SYSTEM_UTC = 2709 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1132246045 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1132273163 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1132246045 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1132273163 refineStartAndEndEsecs(): setting StartEsecs to 1132246035 refineStartAndEndEsecs(): setting EndEsecs to 1132247026 refineStartAndEndEsecs(): numMinBack = 5.48333333333333, numMinForward = 20.7166666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1132246906, Refined EndEsecs = 1132273213 _readLogr(): Reading videologr data from 2005321datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1132246906 & 1132273213 _readLogr(): Flushing variable names: _readLogr(): Calling _readAnotherLogr() with nextDDD = 322 _readAnotherLogr(): DDD = 322 _readAnotherLogr(): Reading logr data from 2005322datavislogr.dat.gz. _readAnotherLogr(): Expedition start & stop times are 1132246906 & 1132273213 _readLogr(): #LOGHOST_SYSTEM_UTC = 2627 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1132246916 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1132273213 bin\geopdvc.pl: expdid = 3334 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 321 (looping to 322) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005321vntaedited.txt esecs, east, north, lat, lon, head, pres 1132247546, 0, 0, 36.801615, -121.803853, 239.4, 69.71 1132248051, 0, 0, 36.801673, -121.803953, 81.7, 74.88 1132248556, 0, 0, 36.801539, -121.803528, 77.6, 72.28 1132249061, 0, 0, 36.801620, -121.801981, 73.3, 58.83 1132249566, 0, 0, 36.801995, -121.799302, 76.1, 45.36 1132250071, 0, 0, 36.802401, -121.795873, 336.0, 39.39 1132250576, 0, 0, 36.802347, -121.799311, 258.5, 78.18 1132251081, 0, 0, 36.801841, -121.803526, 255.4, 97.37 1132251587, 0, 0, 36.802370, -121.801843, 76.7, 97.93 1132252092, 0, 0, 36.802921, -121.796955, 77.0, 61.58 1132252597, 0, 0, 36.803193, -121.797264, 261.6, 63.99 1132253102, 0, 0, 36.802676, -121.801726, 255.7, 95.67 1132253607, 0, 0, 36.802803, -121.803221, 79.8, 101.61 1132254112, 0, 0, 36.803422, -121.798319, 78.2, 71.90 1132254617, 0, 0, 36.803905, -121.797105, 258.8, 61.42 1132255122, 0, 0, 36.803391, -121.801496, 259.2, 91.03 1132255627, 0, 0, 36.803304, -121.804400, 37.5, 96.39 1132256132, 0, 0, 36.803358, -121.804071, 80.3, 90.18 1132256637, 0, 0, 36.804020, -121.799483, 81.6, 78.75 1132257142, 0, 0, 36.804583, -121.796668, 261.4, 50.59 1132257647, 0, 0, 36.804089, -121.800650, 262.2, 63.25 1132258152, 0, 0, 36.803868, -121.804351, 337.7, 96.32 1132258657, 0, 0, 36.804549, -121.799665, 81.9, 69.63 1132259162, 0, 0, 36.805248, -121.796596, 257.7, 50.38 1132259667, 0, 0, 36.804737, -121.800833, 261.1, 62.82 1132260172, 0, 0, 36.804600, -121.804414, 95.0, 87.68 1132260677, 0, 0, 36.805214, -121.799351, 81.5, 59.64 1132261182, 0, 0, 36.805935, -121.796311, 22.9, 27.65 1132261687, 0, 0, 36.805768, -121.797410, 263.5, 57.60 1132262192, 0, 0, 36.805256, -121.801624, 261.4, 78.87 1132262697, 0, 0, 36.805288, -121.804309, 84.6, 71.37 1132263202, 0, 0, 36.805812, -121.799051, 81.1, 60.63 1132263707, 0, 0, 36.806200, -121.798411, 264.6, 49.55 1132264212, 0, 0, 36.805875, -121.802044, 257.8, 75.63 1132264717, 0, 0, 36.805932, -121.804306, 87.4, 48.48 1132265222, 0, 0, 36.806401, -121.800112, 79.0, 59.68 1132265727, 0, 0, 36.806671, -121.797214, 27.1, 12.90 1132266232, 0, 0, 36.806798, -121.799608, 262.0, 44.39 1132266737, 0, 0, 36.806347, -121.803377, 258.9, 47.59 1132267243, 0, 0, 36.806685, -121.802846, 53.4, 48.12 1132267748, 0, 0, 36.804083, -121.801620, 173.1, 66.91 1132268253, 0, 0, 36.801482, -121.800888, 80.8, 39.13 1132268758, 0, 0, 36.803116, -121.798761, 352.9, 76.09 1132269263, 0, 0, 36.806711, -121.799365, 343.8, 45.31 1132269768, 0, 0, 36.806091, -121.797775, 107.5, 51.90 1132270273, 0, 0, 36.805874, -121.794191, 171.1, 18.67 1132270778, 0, 0, 36.804347, -121.795915, 86.0, 22.83 1132271283, 0, 0, 36.804886, -121.795616, 270.9, 26.54 1132271788, 0, 0, 36.804791, -121.797602, 267.9, 21.27 321: 24695 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005321vntaedited.txt rovNav(): DDD = 322 (looping to 322) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005322vntaedited.txt esecs, east, north, lat, lon, head, pres 322: 24695 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005322vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 138 starting at StartEsecs = 1132246906 rovNav(): Initial # seconds to fill at end of dive = 1225 ending at EndEsecs =1132273213 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1132246916 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1132273213 rovNav(): numMinBack = 5.31666666666667, numMinForward = 20.7166666666667 rovNav(): Refined StartEsecs = 1132246906, Refined EndEsecs = 1132273213 rovNav(): Refined # seconds to fill at beginning of dive = 138 starting at StartEsecs = 1132246906 rovNav(): Refined # seconds to fill at end of dive = 1225 ending at EndEsecs =1132273213 rovNav(): num tList = 24695 rovNav(): num eList = 24695 rovNav(): Adding data to begining of dive from logr indices 0 .. 12 rovNav(): Adding data to end of dive from logr indices 2505 .. 2627 rovNav(): num in tList now = 24831 rovNav(): num in eList now = 24831 24831 in tList 24831 in {self->{rovT}} 24831 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1132255005 & 1132263795 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 = 321 (looping to 322) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005321vnta.txt esecs, east, north, lat, lon, head, pres 1132247546, 0, 0, 36.801612, -121.803883, 239.4, 69.71 1132248051, 0, 0, 36.801673, -121.803945, 81.7, 74.88 1132248556, 0, 0, 36.801550, -121.803513, 77.6, 72.28 1132249061, 0, 0, 36.801603, -121.801953, 73.3, 58.83 1132249566, 0, 0, 36.801980, -121.799307, 76.1, 45.36 1132250071, 0, 0, 36.802392, -121.795795, 336.0, 39.39 1132250576, 0, 0, 36.802350, -121.799307, 258.5, 78.18 1132251081, 0, 0, 36.801828, -121.803538, 255.4, 97.37 1132251587, 0, 0, 36.802377, -121.801835, 76.7, 97.93 1132252092, 0, 0, 36.802927, -121.797017, 77.0, 61.58 1132252597, 0, 0, 36.803192, -121.797255, 261.6, 63.99 1132253102, 0, 0, 36.802688, -121.801725, 255.7, 95.67 1132253607, 0, 0, 36.802793, -121.803220, 79.8, 101.61 1132254112, 0, 0, 36.803428, -121.798315, 78.2, 71.90 1132254617, 0, 0, 36.803907, -121.797123, 258.8, 61.42 1132255122, 0, 0, 36.803402, -121.801508, 259.2, 91.03 1132255627, 0, 0, 36.803282, -121.804412, 37.5, 96.39 1132256132, 0, 0, 36.803355, -121.804175, 80.3, 90.18 1132256637, 0, 0, 36.804013, -121.799512, 81.6, 78.75 1132257142, 0, 0, 36.804643, -121.796430, 261.4, 50.59 1132257647, 0, 0, 36.804085, -121.800642, 262.2, 63.25 1132258152, 0, 0, 36.803875, -121.804502, 337.7, 96.32 1132258657, 0, 0, 36.804567, -121.799675, 81.9, 69.63 1132259162, 0, 0, 36.805337, -121.796502, 257.7, 50.38 1132259667, 0, 0, 36.804738, -121.800822, 261.1, 62.82 1132260172, 0, 0, 36.804627, -121.804570, 95.0, 87.68 1132260677, 0, 0, 36.805218, -121.799340, 81.5, 59.64 1132261182, 0, 0, 36.804995, -121.798037, 22.9, 27.65 1132261687, 0, 0, 36.805770, -121.797462, 263.5, 57.60 1132262192, 0, 0, 36.805283, -121.801658, 261.4, 78.87 1132262697, 0, 0, 36.805298, -121.804408, 84.6, 71.37 1132263202, 0, 0, 36.805858, -121.799085, 81.1, 60.63 1132263707, 0, 0, 36.806330, -121.797943, 264.6, 49.55 1132264212, 0, 0, 36.805873, -121.802057, 257.8, 75.63 1132264717, 0, 0, 36.805923, -121.804333, 87.4, 48.48 1132265222, 0, 0, 36.806388, -121.800140, 79.0, 59.68 1132265727, 0, 0, 36.806783, -121.796598, 27.1, 12.90 1132266232, 0, 0, 36.806773, -121.799742, 262.0, 44.40 1132266737, 0, 0, 36.806338, -121.803357, 258.9, 47.59 1132267243, 0, 0, 36.806633, -121.802855, 53.4, 48.12 1132267748, 0, 0, 36.804085, -121.801583, 173.1, 66.91 1132268253, 0, 0, 36.801467, -121.800933, 80.8, 39.13 1132268758, 0, 0, 36.803118, -121.798743, 352.9, 76.09 1132269263, 0, 0, 36.806735, -121.799375, 343.8, 45.31 1132269768, 0, 0, 36.806065, -121.797810, 107.5, 51.90 1132270273, 0, 0, 36.805858, -121.794188, 171.1, 18.67 1132270778, 0, 0, 36.804355, -121.795823, 86.0, 22.83 1132271283, 0, 0, 36.804743, -121.795355, 270.9, 26.54 1132271788, 0, 0, 36.804770, -121.797578, 267.9, 21.27 321: 24695 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005321vnta.txt rovNav(): DDD = 322 (looping to 322) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005322vnta.txt esecs, east, north, lat, lon, head, pres 322: 24695 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005322vnta.txt 24695 in tList 24695 in {self->{rovT}} 24695 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1132255005 & 1132263795 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.80430800 hash{lon} = -121.80016800 latMin = 30.804308 latMax = 42.804308 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.804308 AND 42.804308 AND Longitude BETWEEN -127.800168 AND -115.800168 Dive lat = 36.80430800, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.80016800 & lat = 36.80430800 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2761rov_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 frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/321/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 = 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/vnta2761lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2627 shipNav(): $#{$self->{shipLat}}[last] = 36.803647 Position subsampling set to 20 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 = 24832 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2761tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2761mergedCtdNav.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/17/2005 5:07:15 PM' AND '11/17/2005 11:59:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/17/2005 5:07:15 PM' AND '11/17/2005 11:59:30 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/17/2005 5:07:15 PM' AND '11/17/2005 11:59:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/17/2005 5:07:15 PM' AND '11/17/2005 11:59:30 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/17/2005 5:07:15 PM' AND '11/17/2005 11:59:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/17/2005 5:07:15 PM' AND '11/17/2005 11:59:30 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.