Running bin\geopdvc.pl at Mon Aug 27 18:27:38 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2772 bin\geopdvc.pl: Getting Expedition object for diveno = 2772 and rname = vnta set_expd(): rov = vnta, diveno = 2772 set_expd(): $self->{EndDDD} = 349 set_expd(): $self->{StartEsecs} = 1134665220 set_expd(): $self->{EndEsecs} = 1134687900 set_expd(): $self->{EndDtg} = 12/15/2005 10:45:00 PM _readLogr(): Reading videologr data from 2005349datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1134665220 & 1134687900 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2265 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1134665224 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1134687897 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1134665224 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1134687897 refineStartAndEndEsecs(): setting StartEsecs to 1134665220 refineStartAndEndEsecs(): setting EndEsecs to 1134666235 refineStartAndEndEsecs(): numMinBack = 5.08333333333333, numMinForward = 9.26666666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1134666115, Refined EndEsecs = 1134687256 _readLogr(): Reading videologr data from 2005349datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1134666115 & 1134687256 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2111 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1134666125 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1134687256 bin\geopdvc.pl: expdid = 3349 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 349 (looping to 349) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005349vntaedited.txt esecs, east, north, lat, lon, head, pres 1134666753, 0, 0, 36.699861, -122.054315, 303.5, 99.15 1134667258, 0, 0, 36.700088, -122.053734, 40.4, 209.51 1134667763, 0, 0, 36.700197, -122.053277, 40.9, 298.97 1134668268, 0, 0, 36.700207, -122.052899, 51.1, 426.28 1134668773, 0, 0, 36.700387, -122.052275, 51.2, 566.59 1134669278, 0, 0, 36.700843, -122.050958, 53.0, 712.46 1134669783, 0, 0, 36.701338, -122.049937, 41.3, 801.24 1134670288, 0, 0, 36.701871, -122.049442, 30.1, 806.91 1134670793, 0, 0, 36.702117, -122.048856, 28.0, 801.01 1134671298, 0, 0, 36.702577, -122.048335, 37.0, 798.37 1134671803, 0, 0, 36.702731, -122.047983, 26.7, 795.37 1134672308, 0, 0, 36.703199, -122.047566, 12.3, 785.40 1134672813, 0, 0, 36.703571, -122.047284, 17.1, 781.99 1134673318, 0, 0, 36.703984, -122.047146, 282.1, 769.41 1134673823, 0, 0, 36.704278, -122.047031, 52.1, 767.10 1134674328, 0, 0, 36.704324, -122.046071, 86.6, 760.95 1134674833, 0, 0, 36.704318, -122.045231, 141.9, 767.75 1134675338, 0, 0, 36.704541, -122.044562, 68.3, 725.00 1134675843, 0, 0, 36.704443, -122.044088, 80.0, 685.45 1134676348, 0, 0, 36.704371, -122.043088, 84.3, 634.68 1134676853, 0, 0, 36.704317, -122.042918, 101.3, 614.40 1134677358, 0, 0, 36.704349, -122.042979, 8.0, 602.69 1134677863, 0, 0, 36.704048, -122.043166, 141.4, 532.81 1134678369, 0, 0, 36.704073, -122.043066, 257.9, 505.49 1134678874, 0, 0, 36.704001, -122.042917, 171.2, 499.17 1134679379, 0, 0, 36.703703, -122.042556, 190.8, 506.87 1134679884, 0, 0, 36.704120, -122.042634, 4.9, 487.05 1134680389, 0, 0, 36.704800, -122.042384, 321.2, 478.63 1134680894, 0, 0, 36.705309, -122.042297, 330.1, 482.78 1134681399, 0, 0, 36.705099, -122.042298, 217.1, 431.66 1134681904, 0, 0, 36.704764, -122.042249, 340.1, 379.39 1134682409, 0, 0, 36.704478, -122.041722, 171.2, 328.86 1134682914, 0, 0, 36.704236, -122.041719, 256.7, 290.46 1134683419, 0, 0, 36.703697, -122.041448, 322.7, 250.33 1134683924, 0, 0, 36.703107, -122.041558, 213.3, 232.56 1134684429, 0, 0, 36.702619, -122.041413, 209.0, 200.86 1134684934, 0, 0, 36.702110, -122.041541, 279.4, 195.32 1134685439, 0, 0, 36.701707, -122.041490, 258.9, 179.37 1134685944, 0, 0, 36.700981, -122.041564, 320.3, 186.08 1134686449, 0, 0, 36.701309, -122.041023, 261.2, 46.08 1134686954, 0, 0, 36.701717, -122.040187, 265.4, 3.20 349: 20707 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005349vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 134 starting at StartEsecs = 1134666115 rovNav(): Initial # seconds to fill at end of dive = 0 ending at EndEsecs =1134687256 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1134666125 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1134687256 rovNav(): numMinBack = 4.91666666666667, numMinForward = 9.26666666666667 rovNav(): Refined StartEsecs = 1134666115, Refined EndEsecs = 1134687256 rovNav(): Refined # seconds to fill at beginning of dive = 134 starting at StartEsecs = 1134666115 rovNav(): Refined # seconds to fill at end of dive = 0 ending at EndEsecs =1134687256 rovNav(): num tList = 20707 rovNav(): num eList = 20707 rovNav(): Adding data to begining of dive from logr indices 0 .. 12 rovNav(): Adding data to end of dive from logr indices 2111 .. 2111 rovNav(): num in tList now = 20721 rovNav(): num in eList now = 20721 20721 in tList 20721 in {self->{rovT}} 20721 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1134673080 & 1134673860 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 = 349 (looping to 349) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005349vnta.txt esecs, east, north, lat, lon, head, pres 1134666753, 0, 0, 36.699865, -122.054323, 303.5, 99.15 1134667258, 0, 0, 36.700080, -122.053723, 40.4, 209.51 1134667763, 0, 0, 36.700205, -122.053258, 40.9, 298.97 1134668268, 0, 0, 36.700200, -122.052910, 51.1, 426.28 1134668773, 0, 0, 36.700380, -122.052265, 51.2, 566.59 1134669278, 0, 0, 36.700843, -122.050940, 53.0, 712.46 1134669783, 0, 0, 36.701330, -122.049917, 41.3, 801.24 1134670288, 0, 0, 36.701867, -122.049433, 30.1, 806.91 1134670793, 0, 0, 36.702100, -122.048865, 28.0, 801.01 1134671298, 0, 0, 36.702573, -122.048338, 37.0, 798.37 1134671803, 0, 0, 36.702717, -122.047995, 26.7, 795.37 1134672308, 0, 0, 36.703195, -122.047562, 12.3, 785.40 1134672813, 0, 0, 36.703567, -122.047280, 17.1, 781.99 1134673318, 0, 0, 36.703993, -122.047140, 282.1, 769.41 1134673823, 0, 0, 36.704272, -122.047028, 52.1, 767.10 1134674328, 0, 0, 36.704322, -122.046075, 86.6, 760.95 1134674833, 0, 0, 36.704323, -122.045232, 141.9, 767.75 1134675338, 0, 0, 36.704550, -122.044545, 68.3, 725.00 1134675843, 0, 0, 36.704437, -122.044082, 80.0, 685.45 1134676348, 0, 0, 36.704365, -122.043085, 84.3, 634.68 1134676853, 0, 0, 36.704318, -122.042922, 101.3, 614.40 1134677358, 0, 0, 36.704348, -122.043003, 8.0, 602.69 1134677863, 0, 0, 36.704048, -122.043177, 141.4, 532.81 1134678369, 0, 0, 36.704073, -122.043053, 257.9, 505.49 1134678874, 0, 0, 36.704007, -122.042913, 171.2, 499.17 1134679379, 0, 0, 36.703700, -122.042557, 190.8, 506.87 1134679884, 0, 0, 36.704122, -122.042633, 4.9, 487.05 1134680389, 0, 0, 36.704793, -122.042382, 321.2, 478.63 1134680894, 0, 0, 36.705328, -122.042267, 330.1, 482.78 1134681399, 0, 0, 36.705132, -122.042293, 217.1, 431.66 1134681904, 0, 0, 36.704767, -122.042243, 340.1, 379.39 1134682409, 0, 0, 36.704465, -122.041743, 171.2, 328.86 1134682914, 0, 0, 36.704237, -122.041730, 256.7, 290.46 1134683419, 0, 0, 36.703668, -122.041427, 322.7, 250.33 1134683924, 0, 0, 36.703168, -122.041547, 213.3, 232.56 1134684429, 0, 0, 36.702535, -122.041377, 209.0, 200.86 1134684934, 0, 0, 36.702100, -122.041537, 279.4, 195.32 1134685439, 0, 0, 36.701710, -122.041488, 258.9, 179.37 1134685944, 0, 0, 36.700975, -122.041592, 320.3, 186.08 1134686449, 0, 0, 36.701348, -122.041035, 261.2, 46.08 1134686954, 0, 0, 36.701717, -122.040187, 265.4, 3.20 349: 20707 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005349vnta.txt 20707 in tList 20707 in {self->{rovT}} 20707 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1134673080 & 1134673860 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/349/accesses.txt at bin\geopdvc.pl line 2169 ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70370300 hash{lon} = -122.04311500 latMin = 30.703703 latMax = 42.703703 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.703703 AND 42.703703 AND Longitude BETWEEN -128.043115 AND -116.043115 Dive lat = 36.70370300, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04311500 & lat = 36.70370300 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2772rov_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/vnta2772lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2111 shipNav(): $#{$self->{shipLat}}[last] = 36.701133 Position subsampling set to 16 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 = 20722 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2772tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2772mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '12/15/2005 5:07:00 PM' AND '12/15/2005 10:45:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/15/2005 5:07:00 PM' AND '12/15/2005 10:45:00 PM') Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '12/15/2005 5:07:00 PM' AND '12/15/2005 10:45:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/15/2005 5:07:00 PM' AND '12/15/2005 10:45:00 PM') annotations(): Error in query: SELECT DISTINCT DateDif at bin\geopdvc.pl line 542 f(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '12/15/2005 5:07:00 PM' AND '12/15/2005 10:45:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/15/2005 5:07:00 PM' AND '12/15/2005 10:45:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.