Running bin\geopdvc.pl at Mon Aug 27 17:29:34 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2745 bin\geopdvc.pl: Getting Expedition object for diveno = 2745 and rname = vnta set_expd(): rov = vnta, diveno = 2745 set_expd(): $self->{EndDDD} = 299 set_expd(): $self->{StartEsecs} = 1130341635 set_expd(): $self->{EndEsecs} = 1130363280 set_expd(): $self->{EndDtg} = 10/26/2005 9:28:00 PM _readLogr(): Reading videologr data from 2005299datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1130341635 & 1130363280 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2162 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1130341636 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1130363279 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1130341636 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1130363279 refineStartAndEndEsecs(): setting StartEsecs to 1130341635 refineStartAndEndEsecs(): setting EndEsecs to 1130341646 refineStartAndEndEsecs(): numMinBack = 21.8166666666667, numMinForward = 12.9666666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1130341526, Refined EndEsecs = 1130362858 _readLogr(): Reading videologr data from 2005299datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1130341526 & 1130362858 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2130 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1130341536 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1130362858 bin\geopdvc.pl: expdid = 3329 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 299 (looping to 299) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005299vntaedited.txt esecs, east, north, lat, lon, head, pres 1130343212, 0, 0, 36.837156, -122.160038, 164.1, 124.27 1130343717, 0, 0, 36.836465, -122.159849, 80.7, 193.86 1130344222, 0, 0, 36.836420, -122.159899, 63.1, 193.20 1130344727, 0, 0, 36.836009, -122.159108, 61.8, 181.88 1130345232, 0, 0, 36.836106, -122.159225, 60.8, 183.64 1130345737, 0, 0, 36.836962, -122.157633, 58.7, 156.93 1130346242, 0, 0, 36.837718, -122.156707, 35.7, 148.76 1130346747, 0, 0, 36.837756, -122.156736, 54.6, 145.34 1130347252, 0, 0, 36.837735, -122.156335, 56.9, 144.40 1130347757, 0, 0, 36.838814, -122.154512, 56.8, 136.71 1130348262, 0, 0, 36.839111, -122.153852, 58.1, 134.49 1130348767, 0, 0, 36.839541, -122.151702, 74.5, 126.44 1130349272, 0, 0, 36.840297, -122.148398, 73.8, 119.64 1130349777, 0, 0, 36.841133, -122.145265, 73.8, 115.60 1130350282, 0, 0, 36.841752, -122.143790, 59.8, 115.02 1130350787, 0, 0, 36.843010, -122.141217, 62.7, 110.56 1130351292, 0, 0, 36.844373, -122.138118, 60.7, 109.50 1130351797, 0, 0, 36.845913, -122.134761, 59.8, 107.21 1130352302, 0, 0, 36.846381, -122.133919, 59.1, 107.91 1130352807, 0, 0, 36.847231, -122.131521, 58.8, 104.72 1130353312, 0, 0, 36.848220, -122.129529, 59.4, 104.88 1130353818, 0, 0, 36.848253, -122.129460, 61.5, 104.86 1130354323, 0, 0, 36.849016, -122.128094, 61.0, 102.46 1130354828, 0, 0, 36.849968, -122.125697, 58.9, 100.99 1130355333, 0, 0, 36.850925, -122.123615, 60.2, 99.21 1130355838, 0, 0, 36.852351, -122.120425, 59.3, 98.47 1130356343, 0, 0, 36.853829, -122.117140, 55.8, 96.41 1130356848, 0, 0, 36.855148, -122.114148, 57.3, 95.28 1130357353, 0, 0, 36.856584, -122.111062, 58.5, 94.09 1130357858, 0, 0, 36.857947, -122.108073, 57.4, 92.38 1130358363, 0, 0, 36.859442, -122.104771, 57.8, 90.86 1130358868, 0, 0, 36.860742, -122.101819, 61.1, 90.81 1130359373, 0, 0, 36.861871, -122.099364, 61.2, 90.38 1130359878, 0, 0, 36.863232, -122.096438, 58.0, 90.16 1130360383, 0, 0, 36.863642, -122.095459, 62.1, 90.38 1130360888, 0, 0, 36.864752, -122.092910, 61.5, 89.51 1130361393, 0, 0, 36.865508, -122.091415, 61.9, 85.05 1130361898, 0, 0, 36.863173, -122.096199, 61.2, 19.46 299: 19261 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005299vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 1182 starting at StartEsecs = 1130341526 rovNav(): Initial # seconds to fill at end of dive = 458 ending at EndEsecs =1130362858 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1130341536 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1130362858 rovNav(): numMinBack = 21.65, numMinForward = 12.9666666666667 rovNav(): Refined StartEsecs = 1130341526, Refined EndEsecs = 1130362858 rovNav(): Refined # seconds to fill at beginning of dive = 1182 starting at StartEsecs = 1130341526 rovNav(): Refined # seconds to fill at end of dive = 458 ending at EndEsecs =1130362858 rovNav(): num tList = 19261 rovNav(): num eList = 19261 rovNav(): Adding data to begining of dive from logr indices 0 .. 117 rovNav(): Adding data to end of dive from logr indices 2085 .. 2130 rovNav(): num in tList now = 19425 rovNav(): num in eList now = 19425 19425 in tList 19425 in {self->{rovT}} 19425 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1130358540 & 1130358810 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 = 299 (looping to 299) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005299vnta.txt esecs, east, north, lat, lon, head, pres 1130343212, 0, 0, 36.837140, -122.160072, 164.1, 124.27 1130343717, 0, 0, 36.836450, -122.159848, 80.7, 193.86 1130344222, 0, 0, 36.836408, -122.159927, 63.1, 193.20 1130344727, 0, 0, 36.836007, -122.159093, 61.8, 181.88 1130345232, 0, 0, 36.836107, -122.159238, 60.8, 183.64 1130345737, 0, 0, 36.836958, -122.157648, 58.7, 156.93 1130346242, 0, 0, 36.837720, -122.156700, 35.7, 148.76 1130346747, 0, 0, 36.837798, -122.156710, 54.6, 145.34 1130347252, 0, 0, 36.837733, -122.156335, 56.9, 144.40 1130347757, 0, 0, 36.838830, -122.154485, 56.8, 136.71 1130348262, 0, 0, 36.839118, -122.153878, 58.1, 134.49 1130348767, 0, 0, 36.839538, -122.151695, 74.5, 126.44 1130349272, 0, 0, 36.840262, -122.148535, 73.8, 119.64 1130349777, 0, 0, 36.841160, -122.145178, 73.8, 115.60 1130350282, 0, 0, 36.839777, -122.143832, 59.8, 115.02 1130350787, 0, 0, 36.843013, -122.141215, 62.7, 110.56 1130351292, 0, 0, 36.844362, -122.138122, 60.7, 109.50 1130351797, 0, 0, 36.846295, -122.136062, 59.8, 107.21 1130352302, 0, 0, 36.846383, -122.133928, 59.1, 107.91 1130352807, 0, 0, 36.847228, -122.131500, 58.8, 104.72 1130353312, 0, 0, 36.848237, -122.129507, 59.4, 104.88 1130353818, 0, 0, 36.848240, -122.129475, 61.5, 104.86 1130354323, 0, 0, 36.849043, -122.128115, 61.0, 102.46 1130354828, 0, 0, 36.849992, -122.125638, 58.9, 100.99 1130355333, 0, 0, 36.850953, -122.123608, 60.2, 99.21 1130355838, 0, 0, 36.852345, -122.120453, 59.3, 98.47 1130356343, 0, 0, 36.853832, -122.117135, 55.8, 96.41 1130356848, 0, 0, 36.855148, -122.114135, 57.3, 95.28 1130357353, 0, 0, 36.856577, -122.111048, 58.5, 94.09 1130357858, 0, 0, 36.857945, -122.108095, 57.4, 92.38 1130358363, 0, 0, 36.859438, -122.104752, 57.8, 90.86 1130358868, 0, 0, 36.860753, -122.101805, 61.1, 90.81 1130359373, 0, 0, 36.861882, -122.099355, 61.2, 90.38 1130359878, 0, 0, 36.863247, -122.096390, 58.0, 90.16 1130360383, 0, 0, 36.863643, -122.095460, 62.1, 90.38 1130360888, 0, 0, 36.864750, -122.092903, 61.5, 89.51 1130361393, 0, 0, 36.865513, -122.091430, 61.9, 85.05 1130361898, 0, 0, 36.863170, -122.096192, 61.2, 19.46 299: 19261 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005299vnta.txt 19261 in tList 19261 in {self->{rovT}} 19261 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1130358540 & 1130358810 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/299/accesses.txt at bin\geopdvc.pl line 2169 .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.84645800 hash{lon} = -122.13354300 latMin = 30.846458 latMax = 42.846458 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.846458 AND 42.846458 AND Longitude BETWEEN -128.133543 AND -116.133543 Dive lat = 36.84645800, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.13354300 & lat = 36.84645800 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2745rov_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/vnta2745lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 25 shipNav(): $#{$self->{shipLat}}[last] = 36.836062 Position subsampling set to 15 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 = 19426 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2745tracks.wrl wri at bin\geopdvc.pl line 542 teCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2745mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/26/2005 4:07:15 PM' AND '10/26/2005 9:28:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/26/2005 4:07:15 PM' AND '10/26/2005 9:28: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 '10/26/2005 4:07:15 PM' AND '10/26/2005 9:28:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/26/2005 4:07:15 PM' AND '10/26/2005 9:28:00 PM') annotations(): Error in query: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/26/2005 4:07:15 PM' AND '10/26/2005 9:28:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/26/2005 4:07:15 PM' AND '10/26/2005 9:28:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.