Running bin\geopdvc.pl at Mon Aug 27 17:09:15 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2738 bin\geopdvc.pl: Getting Expedition object for diveno = 2738 and rname = vnta set_expd(): rov = vnta, diveno = 2738 set_expd(): $self->{EndDDD} = 287 set_expd(): $self->{StartEsecs} = 1129305075 set_expd(): $self->{EndEsecs} = 1129325055 set_expd(): $self->{EndDtg} = 10/14/2005 9:04:15 PM _readLogr(): Reading videologr data from 2005287datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1129305075 & 1129325055 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 1995 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1129305078 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1129325048 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1129305078 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1129325048 refineStartAndEndEsecs(): setting StartEsecs to 1129305075 refineStartAndEndEsecs(): setting EndEsecs to 1129305479 refineStartAndEndEsecs(): numMinBack = 15.2666666666667, numMinForward = 16.3833333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1129305359, Refined EndEsecs = 1129324838 _readLogr(): Reading videologr data from 2005287datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1129305359 & 1129324838 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 1945 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1129305368 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1129324838 bin\geopdvc.pl: expdid = 3315 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 287 (looping to 287) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005287vntaedited.txt esecs, east, north, lat, lon, head, pres 1129306673, 0, 0, 36.701330, -122.048366, 349.4, 122.43 1129307178, 0, 0, 36.702505, -122.048263, 350.3, 130.57 1129307683, 0, 0, 36.703322, -122.048132, 343.7, 208.15 1129308188, 0, 0, 36.703336, -122.048073, 304.6, 297.45 1129308693, 0, 0, 36.703337, -122.048067, 4.2, 355.79 1129309198, 0, 0, 36.702457, -122.047977, 348.5, 450.71 1129309703, 0, 0, 36.703068, -122.048514, 192.2, 492.08 1129310208, 0, 0, 36.702854, -122.048711, 165.1, 558.70 1129310713, 0, 0, 36.702734, -122.048940, 181.7, 559.37 1129311218, 0, 0, 36.702864, -122.049324, 177.7, 492.66 1129311723, 0, 0, 36.702238, -122.049410, 179.7, 502.14 1129312228, 0, 0, 36.702064, -122.049654, 188.4, 494.67 1129312733, 0, 0, 36.701582, -122.049958, 177.6, 484.55 1129313238, 0, 0, 36.701340, -122.050372, 190.7, 482.35 1129313743, 0, 0, 36.700821, -122.050531, 187.8, 516.98 1129314248, 0, 0, 36.700514, -122.051075, 186.6, 589.39 1129314753, 0, 0, 36.700273, -122.051643, 188.4, 640.83 1129315258, 0, 0, 36.700421, -122.051938, 165.1, 626.97 1129315763, 0, 0, 36.699779, -122.052369, 166.2, 742.39 1129316268, 0, 0, 36.699689, -122.051879, 183.6, 779.13 1129316773, 0, 0, 36.699610, -122.051625, 118.4, 820.09 1129317278, 0, 0, 36.698935, -122.051289, 149.0, 915.98 1129317783, 0, 0, 36.698230, -122.051073, 106.9, 996.05 1129318288, 0, 0, 36.698417, -122.051543, 264.1, 982.04 1129318793, 0, 0, 36.698528, -122.052792, 250.8, 946.51 1129319298, 0, 0, 36.698288, -122.053235, 214.5, 911.14 1129319803, 0, 0, 36.697432, -122.053017, 151.5, 852.86 1129320308, 0, 0, 36.696368, -122.052863, 186.0, 817.11 1129320813, 0, 0, 36.695685, -122.053500, 191.3, 786.20 1129321318, 0, 0, 36.694545, -122.054368, 264.9, 696.28 1129321823, 0, 0, 36.694808, -122.054941, 263.8, 540.30 1129322328, 0, 0, 36.695498, -122.054246, 264.6, 416.84 1129322833, 0, 0, 36.696457, -122.053888, 264.8, 278.10 1129323338, 0, 0, 36.698012, -122.053054, 265.1, 132.17 1129323843, 0, 0, 36.699648, -122.052233, 265.8, 10.29 287: 17532 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005287vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 760 starting at StartEsecs = 1129305359 rovNav(): Initial # seconds to fill at end of dive = 962 ending at EndEsecs =1129324838 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1129305368 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1129324838 rovNav(): numMinBack = 15.1166666666667, numMinForward = 16.3833333333333 rovNav(): Refined StartEsecs = 1129305359, Refined EndEsecs = 1129324838 rovNav(): Refined # seconds to fill at beginning of dive = 760 starting at StartEsecs = 1129305359 rovNav(): Refined # seconds to fill at end of dive = 962 ending at EndEsecs =1129324838 rovNav(): num tList = 17532 rovNav(): num eList = 17532 rovNav(): Adding data to begining of dive from logr indices 0 .. 75 rovNav(): Adding data to end of dive from logr indices 1849 .. 1945 rovNav(): num in tList now = 17705 rovNav(): num in eList now = 17705 17705 in tList 17705 in {self->{rovT}} 17705 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1129312485 & 1129321170 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 = 287 (looping to 287) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005287vnta.txt esecs, east, north, lat, lon, head, pres 1129306673, 0, 0, 36.701350, -122.048378, 349.4, 122.43 1129307178, 0, 0, 36.702500, -122.048265, 350.3, 130.57 1129307683, 0, 0, 36.703328, -122.048108, 343.7, 208.15 1129308188, 0, 0, 36.701823, -122.047783, 304.6, 297.45 1129308693, 0, 0, 36.698018, -122.042348, 4.2, 355.79 1129309198, 0, 0, 36.698012, -122.042352, 348.5, 450.71 1129309703, 0, 0, 36.703088, -122.048542, 192.2, 492.08 1129310208, 0, 0, 36.702867, -122.048695, 165.1, 558.70 1129310713, 0, 0, 36.702742, -122.048918, 181.7, 559.37 1129311218, 0, 0, 36.702887, -122.049320, 177.7, 492.66 1129311723, 0, 0, 36.702238, -122.049373, 179.7, 502.14 1129312228, 0, 0, 36.702052, -122.049647, 188.4, 494.67 1129312733, 0, 0, 36.701583, -122.049958, 177.6, 484.55 1129313238, 0, 0, 36.701347, -122.050350, 190.7, 482.35 1129313743, 0, 0, 36.700798, -122.050520, 187.8, 516.98 1129314248, 0, 0, 36.700502, -122.051072, 186.6, 589.39 1129314753, 0, 0, 36.700265, -122.051660, 188.4, 640.83 1129315258, 0, 0, 36.700432, -122.051922, 165.1, 626.97 1129315763, 0, 0, 36.699768, -122.052385, 166.2, 742.39 1129316268, 0, 0, 36.699672, -122.051860, 183.6, 779.13 1129316773, 0, 0, 36.699618, -122.051617, 118.4, 820.09 1129317278, 0, 0, 36.698943, -122.051288, 149.0, 915.98 1129317783, 0, 0, 36.698230, -122.051077, 106.9, 996.05 1129318288, 0, 0, 36.698413, -122.051522, 264.1, 982.04 1129318793, 0, 0, 36.698525, -122.052775, 250.8, 946.51 1129319298, 0, 0, 36.698275, -122.053223, 214.5, 911.14 1129319803, 0, 0, 36.697437, -122.053025, 151.5, 852.86 1129320308, 0, 0, 36.696323, -122.052830, 186.0, 817.11 1129320813, 0, 0, 36.695703, -122.053502, 191.3, 786.20 1129321318, 0, 0, 36.694522, -122.054338, 264.9, 696.28 1129321823, 0, 0, 36.694803, -122.054953, 263.8, 540.30 1129322328, 0, 0, 36.695470, -122.044970, 264.6, 416.84 1129322833, 0, 0, 36.695473, -122.045000, 264.8, 278.10 1129323338, 0, 0, 36.698000, -122.053055, 265.1, 132.17 1129323843, 0, 0, 36.699657, -122.052197, 265.8, 10.29 287: 17532 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005287vnta.txt 17532 in tList 17532 in {self->{rovT}} 17532 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1129312485 & 1129321170 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69969300 hash{lon} = -122.05097500 latMin = 30.699693 latMax = 42.699693 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.699693 AND 42.699693 AND Longitude BETWEEN -128.050975 AND -116.050975 Dive lat = 36.69969300, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05097500 & lat = 36.69969300 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2738rov_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/vnta2738lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 1945 shipNav(): $#{$self->{shipLat}}[last] = 36.713808 Position subsampling set to 14 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): AssigniframeGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/287/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 ng 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 = 17706 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2738tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2738mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/14/2005 4:11:15 PM' AND '10/14/2005 9:04:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/14/2005 4:11:15 PM' AND '10/14/2005 9:04:15 PM') Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/14/2005 4:11:15 PM' AND '10/14/2005 9:04:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/14/2005 4:11:15 PM' AND '10/14/2005 9:04:15 PM') annotations(): Error in query: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/14/2005 4:11:15 PM' AND '10/14/2005 9:04:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/14/2005 4:11:15 PM' AND '10/14/2005 9:04:15 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.