Running bin\geopdvc.pl at Mon Aug 27 18:19:41 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2770 bin\geopdvc.pl: Getting Expedition object for diveno = 2770 and rname = vnta set_expd(): rov = vnta, diveno = 2770 set_expd(): $self->{EndDDD} = 347 set_expd(): $self->{StartEsecs} = 1134492255 set_expd(): $self->{EndEsecs} = 1134515820 set_expd(): $self->{EndDtg} = 12/13/2005 10:57:00 PM _readLogr(): Reading videologr data from 2005347datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1134492255 & 1134515820 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2353 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1134492257 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1134515811 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1134492257 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1134515811 refineStartAndEndEsecs(): setting StartEsecs to 1134492255 refineStartAndEndEsecs(): setting EndEsecs to 1134493108 refineStartAndEndEsecs(): numMinBack = 7.78333333333333, numMinForward = 21.6833333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1134492988, Refined EndEsecs = 1134515921 _readLogr(): Reading videologr data from 2005347datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1134492988 & 1134515921 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2290 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1134492998 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1134515921 bin\geopdvc.pl: expdid = 3343 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 347 (looping to 347) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005347vntaedited.txt esecs, east, north, lat, lon, head, pres 1134493770, 0, 0, 36.700255, -122.045383, 218.6, 22.92 1134494421, 0, 0, 36.700404, -122.045517, 171.8, 3.32 1134494926, 0, 0, 36.702183, -122.046790, 185.2, 48.76 1134495431, 0, 0, 36.700958, -122.047047, 185.2, 51.10 1134495936, 0, 0, 36.700007, -122.045890, 139.4, 101.21 1134496441, 0, 0, 36.698515, -122.043190, 139.4, 101.20 1134496946, 0, 0, 36.699560, -122.043502, 307.2, 202.18 1134497451, 0, 0, 36.701325, -122.045503, 307.9, 234.57 1134497956, 0, 0, 36.700978, -122.045018, 123.5, 303.10 1134498461, 0, 0, 36.698847, -122.042695, 140.5, 303.44 1134498966, 0, 0, 36.697953, -122.041833, 317.2, 403.93 1134499471, 0, 0, 36.699887, -122.044343, 317.0, 404.25 1134499976, 0, 0, 36.700193, -122.044615, 6.8, 487.18 1134500481, 0, 0, 36.701073, -122.046513, 302.2, 505.39 1134500986, 0, 0, 36.701795, -122.048307, 158.1, 576.43 1134501491, 0, 0, 36.700730, -122.047602, 138.3, 606.34 1134501996, 0, 0, 36.698887, -122.045863, 137.8, 638.50 1134502501, 0, 0, 36.698541, -122.045592, 135.0, 706.78 1134503006, 0, 0, 36.697058, -122.043250, 134.8, 706.71 1134503511, 0, 0, 36.696670, -122.042745, 315.3, 807.52 1134504016, 0, 0, 36.698483, -122.044782, 315.5, 807.93 1134504521, 0, 0, 36.699185, -122.045650, 304.5, 909.29 1134505026, 0, 0, 36.700628, -122.048117, 307.4, 909.71 1134505531, 0, 0, 36.700473, -122.048183, 323.6, 993.61 1134506037, 0, 0, 36.702617, -122.048668, 342.5, 1010.26 1134506542, 0, 0, 36.704088, -122.049275, 345.7, 990.57 1134507047, 0, 0, 36.703927, -122.049283, 351.0, 989.18 1134507552, 0, 0, 36.704090, -122.049393, 338.6, 967.17 1134508057, 0, 0, 36.704235, -122.049375, 351.4, 930.37 1134508562, 0, 0, 36.704467, -122.049315, 344.5, 818.34 1134509067, 0, 0, 36.704807, -122.049467, 351.5, 804.09 1134509572, 0, 0, 36.705462, -122.049387, 351.3, 682.12 1134510077, 0, 0, 36.705862, -122.049453, 352.5, 639.20 1134510582, 0, 0, 36.705910, -122.049757, 356.4, 609.68 1134511087, 0, 0, 36.706735, -122.049517, 343.0, 557.86 1134511592, 0, 0, 36.707338, -122.049475, 344.8, 521.45 1134512097, 0, 0, 36.707757, -122.048632, 353.0, 452.91 1134512602, 0, 0, 36.708148, -122.048198, 348.0, 343.38 1134513107, 0, 0, 36.707595, -122.048397, 348.2, 185.61 1134513612, 0, 0, 36.706985, -122.048008, 350.5, 168.75 1134514117, 0, 0, 36.706278, -122.047758, 349.9, 127.78 1134514622, 0, 0, 36.706273, -122.047395, 351.5, 6.04 347: 21009 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005347vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 269 starting at StartEsecs = 1134492988 rovNav(): Initial # seconds to fill at end of dive = 1289 ending at EndEsecs =1134515921 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1134492998 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1134515921 rovNav(): numMinBack = 7.61666666666667, numMinForward = 21.6833333333333 rovNav(): Refined StartEsecs = 1134492988, Refined EndEsecs = 1134515921 rovNav(): Refined # seconds to fill at beginning of dive = 269 starting at StartEsecs = 1134492988 rovNav(): Refined # seconds to fill at end of dive = 1289 ending at EndEsecs =1134515921 rovNav(): num tList = 21009 rovNav(): num eList = 21009 rovNav(): Adding data to begining of dive from logr indices 0 .. 25 rovNav(): Adding data to end of dive from logr indices 2162 .. 2290 rovNav(): num in tList now = 21164 rovNav(): num in eList now = 21164 21164 in tList 21164 in {self->{rovT}} 21164 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1134494805 & 1134497610 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ............................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................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 = 347 (looping to 347) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005347vnta.txt esecs, east, north, lat, lon, head, pres 1134493770, 0, 0, 36.774775, -122.084970, 218.6, 22.92 1134494421, 0, 0, 36.774775, -122.084970, 171.8, 3.32 1134494926, 0, 0, 36.702183, -122.046790, 185.2, 48.76 1134495431, 0, 0, 36.700958, -122.047047, 185.2, 51.10 1134495936, 0, 0, 36.700007, -122.045890, 139.4, 101.21 1134496441, 0, 0, 36.698515, -122.043190, 139.4, 101.20 1134496946, 0, 0, 36.699560, -122.043502, 307.2, 202.18 1134497451, 0, 0, 36.701325, -122.045503, 307.9, 234.57 1134497956, 0, 0, 36.700978, -122.045018, 123.5, 303.10 1134498461, 0, 0, 36.698847, -122.042695, 140.5, 303.44 1134498966, 0, 0, 36.697953, -122.041833, 317.2, 403.93 1134499471, 0, 0, 36.699887, -122.044343, 317.0, 404.25 1134499976, 0, 0, 36.700193, -122.044615, 6.8, 487.18 1134500481, 0, 0, 36.701073, -122.046513, 302.2, 505.39 1134500986, 0, 0, 36.701795, -122.048307, 158.1, 576.43 1134501491, 0, 0, 36.700730, -122.047602, 138.3, 606.34 1134501996, 0, 0, 36.698887, -122.045863, 137.8, 638.50 1134502501, 0, 0, 36.699250, -122.046100, 135.0, 706.78 1134503006, 0, 0, 36.697058, -122.043250, 134.8, 706.71 1134503511, 0, 0, 36.696670, -122.042745, 315.3, 807.52 1134504016, 0, 0, 36.698483, -122.044782, 315.5, 807.93 1134504521, 0, 0, 36.699185, -122.045650, 304.5, 909.29 1134505026, 0, 0, 36.700628, -122.048117, 307.4, 909.71 1134505531, 0, 0, 36.700473, -122.048183, 323.6, 993.61 1134506037, 0, 0, 36.702617, -122.048668, 342.5, 1010.26 1134506542, 0, 0, 36.704088, -122.049275, 345.7, 990.57 1134507047, 0, 0, 36.703927, -122.049283, 351.0, 989.18 1134507552, 0, 0, 36.704090, -122.049393, 338.6, 967.17 1134508057, 0, 0, 36.704235, -122.049375, 351.4, 930.37 1134508562, 0, 0, 36.704467, -122.049315, 344.5, 818.34 1134509067, 0, 0, 36.704807, -122.049467, 351.5, 804.09 1134509572, 0, 0, 36.705462, -122.049387, 351.3, 682.12 1134510077, 0, 0, 36.705862, -122.049453, 352.5, 639.20 1134510582, 0, 0, 36.705910, -122.049757, 356.4, 609.68 1134511087, 0, 0, 36.706735, -122.049517, 343.0, 557.86 1134511592, 0, 0, 36.707338, -122.049475, 344.8, 521.45 1134512097, 0, 0, 36.707757, -122.048632, 353.0, 452.91 1134512602, 0, 0, 36.708148, -122.048198, 348.0, 343.38 1134513107, 0, 0, 36.707595, -122.048397, 348.2, 185.61 1134513612, 0, 0, 36.706985, -122.048008, 350.5, 168.75 1134514117, 0, 0, 36.706278, -122.047758, 349.9, 127.78 1134514622, 0, 0, 36.706273, -122.047395, 351.5, 6.04 347: 21009 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005347vnta.txt 21009 in tList 21009 in {self->{rovT}} 21009 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1134494805 & 1134497610 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.....................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/347/accesses.txt at bin\geopdvc.pl line 2169 ..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70181800 hash{lon} = -122.04793300 latMin = 30.701818 latMax = 42.701818 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.701818 AND 42.701818 AND Longitude BETWEEN -128.047933 AND -116.047933 Dive lat = 36.70181800, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04793300 & lat = 36.70181800 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2770rov_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/vnta2770lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2290 shipNav(): $#{$self->{shipLat}}[last] = 36.727280 Position subsampling set to 17 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 21165 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2770tracks.wrl writ at bin\geopdvc.pl line 542 eCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2770mergedCtdNav.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 '12/13/2005 5:04:15 PM' AND '12/13/2005 10:57:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/13/2005 5:04:15 PM' AND '12/13/2005 10:57: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 '12/13/2005 5:04:15 PM' AND '12/13/2005 10:57:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/13/2005 5:04:15 PM' AND '12/13/2005 10:57: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 '12/13/2005 5:04:15 PM' AND '12/13/2005 10:57:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/13/2005 5:04:15 PM' AND '12/13/2005 10:57:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.