Running bin\geopdvc.pl at Mon Aug 27 18:04:42 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2762 bin\geopdvc.pl: Getting Expedition object for diveno = 2762 and rname = vnta set_expd(): rov = vnta, diveno = 2762 set_expd(): $self->{EndDDD} = 322 set_expd(): $self->{StartEsecs} = 1132330155 set_expd(): $self->{EndEsecs} = 1132357320 set_expd(): $self->{EndDtg} = 11/18/2005 11:22:00 PM _readLogr(): Reading videologr data from 2005322datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1132330155 & 1132357320 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2713 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1132330161 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1132357319 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1132330161 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1132357319 refineStartAndEndEsecs(): setting StartEsecs to 1132330155 refineStartAndEndEsecs(): setting EndEsecs to 1132331032 refineStartAndEndEsecs(): numMinBack = 7.38333333333333, numMinForward = 18.4833333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1132330912, Refined EndEsecs = 1132357229 _readLogr(): Reading videologr data from 2005322datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1132330912 & 1132357229 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2628 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1132330922 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1132357229 bin\geopdvc.pl: expdid = 3335 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 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 1132331684, 0, 0, 36.795608, -121.843541, 225.5, 127.59 1132332190, 0, 0, 36.795348, -121.844092, 203.6, 210.87 1132332695, 0, 0, 36.792685, -121.845512, 193.4, 268.25 1132333200, 0, 0, 36.792676, -121.847327, 19.1, 240.05 1132333705, 0, 0, 36.795594, -121.846051, 18.2, 226.81 1132334210, 0, 0, 36.795646, -121.848135, 195.5, 269.48 1132334715, 0, 0, 36.792685, -121.849601, 316.2, 206.45 1132335220, 0, 0, 36.792696, -121.847683, 104.4, 239.39 1132335725, 0, 0, 36.792154, -121.844959, 283.5, 255.08 1132336230, 0, 0, 36.792789, -121.846944, 294.3, 247.94 1132336735, 0, 0, 36.793482, -121.849064, 289.1, 251.62 1132337240, 0, 0, 36.793690, -121.848927, 109.7, 268.34 1132337745, 0, 0, 36.792662, -121.844056, 272.6, 265.63 1132338250, 0, 0, 36.793089, -121.845777, 307.5, 271.54 1132338755, 0, 0, 36.793741, -121.847766, 301.6, 278.00 1132339260, 0, 0, 36.794658, -121.849713, 82.3, 286.43 1132339765, 0, 0, 36.792968, -121.843912, 18.3, 263.32 1132340270, 0, 0, 36.793445, -121.844905, 292.2, 269.86 1132340775, 0, 0, 36.793869, -121.845988, 296.5, 274.02 1132341280, 0, 0, 36.794638, -121.848287, 297.0, 282.67 1132341785, 0, 0, 36.795128, -121.849657, 314.8, 287.62 1132342290, 0, 0, 36.793783, -121.844516, 110.9, 263.18 1132342795, 0, 0, 36.794151, -121.844816, 297.2, 264.69 1132343300, 0, 0, 36.794895, -121.847265, 300.9, 275.13 1132343805, 0, 0, 36.795626, -121.849197, 13.5, 280.96 1132344310, 0, 0, 36.794473, -121.844720, 96.1, 247.11 1132344815, 0, 0, 36.795049, -121.845432, 284.1, 240.88 1132345320, 0, 0, 36.795924, -121.848579, 294.5, 268.53 1132345825, 0, 0, 36.795804, -121.846685, 99.1, 226.69 1132346330, 0, 0, 36.795321, -121.843992, 303.9, 209.74 1132346835, 0, 0, 36.796184, -121.847324, 288.8, 236.59 1132347341, 0, 0, 36.796496, -121.846550, 109.1, 220.78 1132347846, 0, 0, 36.795944, -121.843252, 288.1, 189.55 1132348351, 0, 0, 36.797214, -121.847044, 281.1, 212.11 1132348856, 0, 0, 36.796857, -121.846069, 113.0, 218.12 1132349361, 0, 0, 36.795814, -121.841830, 356.1, 187.62 1132349866, 0, 0, 36.797084, -121.845210, 292.4, 213.18 1132350371, 0, 0, 36.797958, -121.848432, 287.5, 232.50 1132350876, 0, 0, 36.797530, -121.845754, 106.6, 188.50 1132351381, 0, 0, 36.796859, -121.842702, 292.0, 180.29 1132351886, 0, 0, 36.798361, -121.847161, 288.0, 216.12 1132352391, 0, 0, 36.798588, -121.846860, 111.7, 205.03 1132352896, 0, 0, 36.797439, -121.843318, 110.7, 187.74 1132353401, 0, 0, 36.798529, -121.845403, 288.1, 186.21 1132353906, 0, 0, 36.799339, -121.846865, 73.5, 182.51 1132354411, 0, 0, 36.796848, -121.847697, 194.3, 227.08 1132354916, 0, 0, 36.796648, -121.845643, 14.3, 219.78 1132355421, 0, 0, 36.797670, -121.845529, 57.0, 132.45 1132355926, 0, 0, 36.797432, -121.845700, 9.1, 36.48 322: 24703 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005322vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 255 starting at StartEsecs = 1132330912 rovNav(): Initial # seconds to fill at end of dive = 1097 ending at EndEsecs =1132357229 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1132330922 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1132357229 rovNav(): numMinBack = 7.21666666666667, numMinForward = 18.4833333333333 rovNav(): Refined StartEsecs = 1132330912, Refined EndEsecs = 1132357229 rovNav(): Refined # seconds to fill at beginning of dive = 255 starting at StartEsecs = 1132330912 rovNav(): Refined # seconds to fill at end of dive = 1097 ending at EndEsecs =1132357229 rovNav(): num tList = 24703 rovNav(): num eList = 24703 rovNav(): Adding data to begining of dive from logr indices 0 .. 24 rovNav(): Adding data to end of dive from logr indices 2519 .. 2628 rovNav(): num in tList now = 24838 rovNav(): num in eList now = 24838 24838 in tList 24838 in {self->{rovT}} 24838 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1132331595 & 1132356045 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 = 322 (looping to 322) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005322vnta.txt esecs, east, north, lat, lon, head, pres 1132331684, 0, 0, 36.795608, -121.843533, 225.5, 127.59 1132332190, 0, 0, 36.795388, -121.844095, 203.6, 210.87 1132332695, 0, 0, 36.792673, -121.845495, 193.4, 268.25 1132333200, 0, 0, 36.792685, -121.847330, 19.1, 240.05 1132333705, 0, 0, 36.795600, -121.846037, 18.2, 226.81 1132334210, 0, 0, 36.795642, -121.848145, 195.5, 269.48 1132334715, 0, 0, 36.792612, -121.849553, 316.2, 206.45 1132335220, 0, 0, 36.792688, -121.847657, 104.4, 239.39 1132335725, 0, 0, 36.792145, -121.844945, 283.5, 255.08 1132336230, 0, 0, 36.792780, -121.846933, 294.3, 247.94 1132336735, 0, 0, 36.793483, -121.849047, 289.1, 251.62 1132337240, 0, 0, 36.793662, -121.848913, 109.7, 268.34 1132337745, 0, 0, 36.792670, -121.844027, 272.6, 265.63 1132338250, 0, 0, 36.793068, -121.845780, 307.5, 271.54 1132338755, 0, 0, 36.793728, -121.847772, 301.6, 278.00 1132339260, 0, 0, 36.794753, -121.849853, 82.3, 286.43 1132339765, 0, 0, 36.792903, -121.843767, 18.3, 263.32 1132340270, 0, 0, 36.793462, -121.844932, 292.2, 269.86 1132340775, 0, 0, 36.793858, -121.845990, 296.5, 274.02 1132341280, 0, 0, 36.794647, -121.848285, 297.0, 282.67 1132341785, 0, 0, 36.795110, -121.849713, 314.8, 287.62 1132342290, 0, 0, 36.793798, -121.844683, 110.9, 263.18 1132342795, 0, 0, 36.794145, -121.844835, 297.2, 264.69 1132343300, 0, 0, 36.794888, -121.847245, 300.9, 275.13 1132343805, 0, 0, 36.795605, -121.849255, 13.5, 280.96 1132344310, 0, 0, 36.794445, -121.844680, 96.1, 247.11 1132344815, 0, 0, 36.795050, -121.845425, 284.1, 240.88 1132345320, 0, 0, 36.795918, -121.848603, 294.5, 268.53 1132345825, 0, 0, 36.795783, -121.846660, 99.1, 226.69 1132346330, 0, 0, 36.794105, -121.846195, 303.9, 209.74 1132346835, 0, 0, 36.796195, -121.847327, 288.8, 236.59 1132347341, 0, 0, 36.796540, -121.846548, 109.1, 220.78 1132347846, 0, 0, 36.795333, -121.845848, 288.1, 189.55 1132348351, 0, 0, 36.797287, -121.847157, 281.1, 212.11 1132348856, 0, 0, 36.796872, -121.846053, 113.0, 218.12 1132349361, 0, 0, 36.795752, -121.841720, 356.1, 187.62 1132349866, 0, 0, 36.797072, -121.845197, 292.4, 213.18 1132350371, 0, 0, 36.797930, -121.848465, 287.5, 232.50 1132350876, 0, 0, 36.797530, -121.845738, 106.6, 188.50 1132351381, 0, 0, 36.796887, -121.842622, 292.0, 180.29 1132351886, 0, 0, 36.798363, -121.847133, 288.0, 216.12 1132352391, 0, 0, 36.798578, -121.846848, 111.7, 205.03 1132352896, 0, 0, 36.797432, -121.843320, 110.7, 187.74 1132353401, 0, 0, 36.798527, -121.845433, 288.1, 186.21 1132353906, 0, 0, 36.799400, -121.846813, 73.5, 182.51 1132354411, 0, 0, 36.796838, -121.847700, 194.3, 227.08 1132354916, 0, 0, 36.796652, -121.845647, 14.3, 219.78 1132355421, 0, 0, 36.797675, -121.845522, 57.0, 132.45 1132355926, 0, 0, 36.797423, -121.845703, 9.1, 36.48 322: 24703 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005322vnta.txt 24703 in tList 24703 in {self->{rovT}} 24703 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1132331595 & 1132356045 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79542000 hash{lon} = -121.84616900 latMin = 30.79542 latMax = 42.79542 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.79542 AND 42.79542 AND Longitude BETWEEN -127.846169 AND -115.846169 Dive lat = 36.79542000, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.84616900 & lat = 36.79542000 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2762rov_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/vnta2762lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2628 shipNav(): $#{$self->{shipLat}}[last] = 36.798238 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 setROVcolorlineframeGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/322/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 s(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 24839 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2762tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2762mergedCtdNav.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/18/2005 4:29:15 PM' AND '11/18/2005 11:22:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/18/2005 4:29:15 PM' AND '11/18/2005 11:22: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/18/2005 4:29:15 PM' AND '11/18/2005 11:22:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/18/2005 4:29:15 PM' AND '11/18/2005 11:22: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/18/2005 4:29:15 PM' AND '11/18/2005 11:22:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/18/2005 4:29:15 PM' AND '11/18/2005 11:22:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.