Running bin\geopdvc.pl at Mon Aug 27 16:44:06 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2722 bin\geopdvc.pl: Getting Expedition object for diveno = 2722 and rname = vnta set_expd(): rov = vnta, diveno = 2722 set_expd(): $self->{EndDDD} = 258 set_expd(): $self->{StartEsecs} = 1126799520 set_expd(): $self->{EndEsecs} = 1126822470 set_expd(): $self->{EndDtg} = 9/15/2005 9:54:30 PM _readLogr(): Reading videologr data from 2005258datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1126799520 & 1126822470 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2292 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1126799525 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1126822469 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1126799525 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1126822469 refineStartAndEndEsecs(): setting StartEsecs to 1126799520 refineStartAndEndEsecs(): setting EndEsecs to 1126799545 refineStartAndEndEsecs(): numMinBack = 21.5833333333333, numMinForward = 10.4666666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1126799425, Refined EndEsecs = 1126821898 _readLogr(): Reading videologr data from 2005258datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1126799425 & 1126821898 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2244 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1126799435 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1126821898 bin\geopdvc.pl: expdid = 3292 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 258 (looping to 258) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005258vntaedited.txt esecs, east, north, lat, lon, head, pres 1126801002, 0, 0, 36.745192, -122.052841, 323.1, 67.13 1126801507, 0, 0, 36.744537, -122.052688, 324.1, 199.72 1126802012, 0, 0, 36.744919, -122.052717, 323.2, 390.28 1126802517, 0, 0, 36.744919, -122.052717, 323.4, 580.18 1126803022, 0, 0, 36.744668, -122.052430, 41.2, 652.56 1126803527, 0, 0, 36.745897, -122.052004, 53.4, 654.64 1126804032, 0, 0, 36.745765, -122.052195, 47.1, 642.95 1126804537, 0, 0, 36.745858, -122.052262, 48.8, 653.07 1126805042, 0, 0, 36.745970, -122.052155, 47.6, 659.97 1126805547, 0, 0, 36.746781, -122.052119, 47.8, 657.92 1126806052, 0, 0, 36.744586, -122.052322, 47.1, 657.97 1126806557, 0, 0, 36.744714, -122.052469, 75.7, 658.85 1126807062, 0, 0, 36.744693, -122.052263, 69.8, 658.47 1126807567, 0, 0, 36.744854, -122.052533, 86.4, 657.87 1126808072, 0, 0, 36.744929, -122.052405, 58.3, 655.62 1126808577, 0, 0, 36.745535, -122.053033, 203.4, 598.36 1126809082, 0, 0, 36.745797, -122.054028, 68.8, 692.42 1126809587, 0, 0, 36.746676, -122.053441, 48.7, 677.65 1126810092, 0, 0, 36.746789, -122.053238, 42.0, 675.80 1126810597, 0, 0, 36.746802, -122.053242, 51.7, 676.00 1126811102, 0, 0, 36.746733, -122.053157, 51.5, 675.36 1126811607, 0, 0, 36.746753, -122.053116, 52.0, 674.85 1126812113, 0, 0, 36.746762, -122.052616, 57.3, 664.09 1126812618, 0, 0, 36.746763, -122.052528, 57.2, 663.52 1126813123, 0, 0, 36.746617, -122.052547, 57.7, 662.98 1126813628, 0, 0, 36.746651, -122.052356, 56.9, 656.96 1126814133, 0, 0, 36.746638, -122.052746, 57.4, 668.65 1126814638, 0, 0, 36.746870, -122.053200, 320.1, 582.63 1126815143, 0, 0, 36.748050, -122.054392, 333.9, 527.01 1126815674, 0, 0, 36.748419, -122.054994, 300.0, 531.24 1126816179, 0, 0, 36.748757, -122.055636, 312.4, 531.75 1126816684, 0, 0, 36.749156, -122.056384, 295.1, 469.22 1126817189, 0, 0, 36.748974, -122.057335, 310.4, 400.98 1126817694, 0, 0, 36.749017, -122.057105, 47.9, 418.84 1126818199, 0, 0, 36.749135, -122.056434, 337.9, 371.67 1126818704, 0, 0, 36.749138, -122.056423, 266.8, 369.24 1126819236, 0, 0, 36.749717, -122.056377, 40.9, 383.83 1126819741, 0, 0, 36.749717, -122.056377, 267.1, 403.24 1126820246, 0, 0, 36.749717, -122.056377, 311.0, 355.26 1126820751, 0, 0, 36.749649, -122.056264, 310.6, 184.01 1126821256, 0, 0, 36.747393, -122.052168, 353.7, 18.13 1126821761, 0, 0, 36.747393, -122.052168, 223.9, 2.68 258: 21121 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005258vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 10 starting at StartEsecs = 1126799425 rovNav(): Initial # seconds to fill at end of dive = 0 ending at EndEsecs =1126821898 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1126799435 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1126821898 rovNav(): numMinBack = 21.4166666666667, numMinForward = 10.4666666666667 rovNav(): Refined StartEsecs = 1126799425, Refined EndEsecs = 1126821898 rovNav(): Refined # seconds to fill at beginning of dive = 10 starting at StartEsecs = 1126799425 rovNav(): Refined # seconds to fill at end of dive = 0 ending at EndEsecs =1126821898 rovNav(): num tList = 21121 rovNav(): num eList = 21121 rovNav(): Adding data to begining of dive from logr indices 0 .. 0 rovNav(): Adding data to end of dive from logr indices 2244 .. 2244 rovNav(): num in tList now = 21123 rovNav(): num in eList now = 21123 21123 in tList 21123 in {self->{rovT}} 21123 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1126815525 & 1126818810 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXX......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................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 = 258 (looping to 258) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005258vnta.txt esecs, east, north, lat, lon, head, pres 1126801002, 0, 0, 36.746143, -122.053098, 323.1, 67.13 1126801507, 0, 0, 36.745075, -122.052317, 324.1, 199.72 1126802012, 0, 0, 36.743258, -122.042525, 323.2, 390.28 1126802517, 0, 0, 36.744918, -122.052195, 323.4, 580.18 1126803022, 0, 0, 36.744420, -122.052477, 41.2, 652.56 1126803527, 0, 0, 36.745907, -122.052045, 53.4, 654.64 1126804032, 0, 0, 36.744788, -122.051742, 47.1, 642.95 1126804537, 0, 0, 36.744963, -122.052255, 48.8, 653.07 1126805042, 0, 0, 36.743625, -122.051660, 47.6, 659.97 1126805547, 0, 0, 36.747005, -122.051987, 47.8, 657.92 1126806052, 0, 0, 36.744548, -122.052330, 47.1, 657.97 1126806557, 0, 0, 36.747108, -122.052053, 75.7, 658.85 1126807062, 0, 0, 36.744707, -122.052273, 69.8, 658.47 1126807567, 0, 0, 36.747640, -122.050735, 86.4, 657.87 1126808072, 0, 0, 36.744472, -122.052160, 58.3, 655.62 1126808577, 0, 0, 36.745565, -122.052988, 203.4, 598.36 1126809082, 0, 0, 36.745750, -122.054017, 68.8, 692.42 1126809587, 0, 0, 36.745423, -122.050228, 48.7, 677.65 1126810092, 0, 0, 36.746800, -122.053245, 42.0, 675.80 1126810597, 0, 0, 36.746812, -122.053253, 51.7, 676.00 1126811102, 0, 0, 36.746730, -122.053150, 51.5, 675.36 1126811607, 0, 0, 36.746745, -122.053122, 52.0, 674.85 1126812113, 0, 0, 36.746755, -122.052623, 57.3, 664.09 1126812618, 0, 0, 36.746753, -122.052520, 57.2, 663.52 1126813123, 0, 0, 36.746615, -122.052553, 57.7, 662.98 1126813628, 0, 0, 36.746653, -122.052332, 56.9, 656.96 1126814133, 0, 0, 36.746638, -122.052762, 57.4, 668.65 1126814638, 0, 0, 36.746832, -122.053157, 320.1, 582.63 1126815143, 0, 0, 36.748050, -122.054390, 333.9, 527.01 1126815674, 0, 0, 36.748423, -122.054987, 300.0, 531.24 1126816179, 0, 0, 36.748755, -122.055645, 312.4, 531.75 1126816684, 0, 0, 36.749168, -122.056400, 295.1, 469.22 1126817189, 0, 0, 36.748988, -122.057307, 310.4, 400.98 1126817694, 0, 0, 36.750585, -122.057930, 47.9, 418.84 1126818199, 0, 0, 36.749138, -122.056423, 337.9, 371.67 1126818704, 0, 0, 36.749138, -122.056423, 266.8, 369.24 1126819236, 0, 0, 36.749717, -122.056377, 40.9, 383.83 1126819741, 0, 0, 36.749717, -122.056377, 267.1, 403.24 1126820246, 0, 0, 36.749717, -122.056377, 311.0, 355.26 1126820751, 0, 0, 36.749727, -122.056380, 310.6, 184.01 1126821256, 0, 0, 36.748317, -122.054047, 353.7, 18.13 1126821761, 0, 0, 36.747393, -122.052168, 223.9, 2.68 258: 21121 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005258vnta.txt 21121 in tList 21121 in {self->{rovT}} 21121 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1126815525 & 1126818810 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXX......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXX................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/258/accesses.txt at bin\geopdvc.pl line 2169 .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74673500 hash{lon} = -122.05283750 latMin = 30.746735 latMax = 42.746735 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.746735 AND 42.746735 AND Longitude BETWEEN -128.0528375 AND -116.0528375 Dive lat = 36.74673500, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05283750 & lat = 36.74673500 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2722rov_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/vnta2722lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 1591 shipNav(): $#{$self->{shipLat}}[last] = 36.744112 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 = 21124 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2722tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2722mergedCtdNav.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 '9/15/2005 4:12:00 PM' AND '9/15/2005 9:54:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/15/2005 4:12:00 PM' AND '9/15/2005 9:54:30 PM') Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, at bin\geopdvc.pl line 542 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 '9/15/2005 4:12:00 PM' AND '9/15/2005 9:54:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/15/2005 4:12:00 PM' AND '9/15/2005 9:54:30 PM') annotations(): Error in query: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '9/15/2005 4:12:00 PM' AND '9/15/2005 9:54:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/15/2005 4:12:00 PM' AND '9/15/2005 9:54:30 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.