Running bin\geopdvc.pl at Mon Aug 27 18:15:29 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2765 bin\geopdvc.pl: Getting Expedition object for diveno = 2765 and rname = vnta set_expd(): rov = vnta, diveno = 2765 set_expd(): $self->{EndDDD} = 334 set_expd(): $self->{StartEsecs} = 1133371620 set_expd(): $self->{EndEsecs} = 1133394600 set_expd(): $self->{EndDtg} = 11/30/2005 11:30:00 PM _readLogr(): Reading videologr data from 2005334datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1133371620 & 1133394600 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2295 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1133371623 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1133394597 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1133371623 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1133394597 refineStartAndEndEsecs(): setting StartEsecs to 1133371620 refineStartAndEndEsecs(): setting EndEsecs to 1133372704 refineStartAndEndEsecs(): numMinBack = 3.93333333333333, numMinForward = 14.1 refineStartAndEndEsecs(): Refined StartEsecs = 1133372584, Refined EndEsecs = 1133394246 _readLogr(): Reading videologr data from 2005334datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1133372584 & 1133394246 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2163 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1133372594 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1133394246 bin\geopdvc.pl: expdid = 3338 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 334 (looping to 334) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005334vntaedited.txt esecs, east, north, lat, lon, head, pres 1133373213, 0, 0, 36.776943, -121.952334, 190.5, 115.34 1133373718, 0, 0, 36.777289, -121.952448, 190.8, 366.85 1133374223, 0, 0, 36.777691, -121.952467, 286.4, 612.17 1133374728, 0, 0, 36.777474, -121.952653, 285.2, 606.41 1133375233, 0, 0, 36.777370, -121.952843, 286.1, 606.53 1133375738, 0, 0, 36.777185, -121.952923, 285.6, 606.59 1133376243, 0, 0, 36.777138, -121.953013, 286.2, 606.61 1133376748, 0, 0, 36.777111, -121.953167, 285.9, 606.60 1133377253, 0, 0, 36.777051, -121.953336, 286.0, 606.59 1133377759, 0, 0, 36.776965, -121.953576, 286.0, 606.59 1133378264, 0, 0, 36.776901, -121.953801, 286.3, 606.60 1133378769, 0, 0, 36.777003, -121.954025, 285.6, 606.60 1133379274, 0, 0, 36.777069, -121.954455, 285.5, 601.16 1133379779, 0, 0, 36.777044, -121.954551, 286.1, 616.07 1133380284, 0, 0, 36.777111, -121.954603, 286.2, 523.81 1133380789, 0, 0, 36.777202, -121.955300, 287.0, 358.52 1133381294, 0, 0, 36.777568, -121.956243, 286.8, 210.38 1133381799, 0, 0, 36.777193, -121.956298, 285.6, 277.18 1133382304, 0, 0, 36.777043, -121.956265, 286.2, 277.55 1133382809, 0, 0, 36.777016, -121.956036, 286.0, 277.64 1133383314, 0, 0, 36.777115, -121.955986, 285.9, 277.71 1133383819, 0, 0, 36.777137, -121.955948, 285.6, 277.73 1133384324, 0, 0, 36.777152, -121.956089, 287.4, 182.09 1133384829, 0, 0, 36.776766, -121.956019, 285.7, 176.96 1133385334, 0, 0, 36.776363, -121.955643, 285.9, 177.11 1133385839, 0, 0, 36.776189, -121.955682, 285.9, 177.15 1133386344, 0, 0, 36.775885, -121.955889, 285.7, 201.94 1133386849, 0, 0, 36.775637, -121.955984, 285.9, 202.09 1133387354, 0, 0, 36.775249, -121.955980, 285.3, 202.15 1133387859, 0, 0, 36.774911, -121.956007, 285.7, 226.10 1133388364, 0, 0, 36.775216, -121.955859, 183.2, 252.38 1133388869, 0, 0, 36.775442, -121.955817, 183.3, 252.50 1133389374, 0, 0, 36.775565, -121.955667, 184.4, 221.30 1133389879, 0, 0, 36.775362, -121.955740, 184.0, 194.03 1133390385, 0, 0, 36.775310, -121.955812, 183.1, 100.65 1133390890, 0, 0, 36.775243, -121.955350, 182.9, 100.90 1133391395, 0, 0, 36.775037, -121.955170, 183.1, 51.11 1133391900, 0, 0, 36.775057, -121.955192, 183.4, 51.38 1133392405, 0, 0, 36.775047, -121.955180, 183.1, 51.43 1133392910, 0, 0, 36.775047, -121.955180, 183.1, 51.43 1133393415, 0, 0, 36.775047, -121.955180, 183.1, 51.43 1133393920, 0, 0, 36.775047, -121.955180, 183.1, 51.43 334: 21311 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005334vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 134 starting at StartEsecs = 1133372584 rovNav(): Initial # seconds to fill at end of dive = 0 ending at EndEsecs =1133394246 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1133372594 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1133394246 rovNav(): numMinBack = 3.76666666666667, numMinForward = 14.1 rovNav(): Refined StartEsecs = 1133372584, Refined EndEsecs = 1133394246 rovNav(): Refined # seconds to fill at beginning of dive = 134 starting at StartEsecs = 1133372584 rovNav(): Refined # seconds to fill at end of dive = 0 ending at EndEsecs =1133394246 rovNav(): num tList = 21311 rovNav(): num eList = 21311 rovNav(): Adding data to begining of dive from logr indices 0 .. 12 rovNav(): Adding data to end of dive from logr indices 2163 .. 2163 rovNav(): num in tList now = 21325 rovNav(): num in eList now = 21325 21325 in tList 21325 in {self->{rovT}} 21325 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1133377275 & 1133389005 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ...................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................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 = 334 (looping to 334) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005334vnta.txt esecs, east, north, lat, lon, head, pres 1133373213, 0, 0, 36.776957, -121.952323, 190.5, 115.34 1133373718, 0, 0, 36.777288, -121.952440, 190.8, 366.85 1133374223, 0, 0, 36.777678, -121.952458, 286.4, 612.17 1133374728, 0, 0, 36.777467, -121.952642, 285.2, 606.41 1133375233, 0, 0, 36.777370, -121.952848, 286.1, 606.53 1133375738, 0, 0, 36.777182, -121.952930, 285.6, 606.59 1133376243, 0, 0, 36.777140, -121.953013, 286.2, 606.61 1133376748, 0, 0, 36.777117, -121.953165, 285.9, 606.60 1133377253, 0, 0, 36.777055, -121.953338, 286.0, 606.59 1133377759, 0, 0, 36.776968, -121.953573, 286.0, 606.59 1133378264, 0, 0, 36.776902, -121.953802, 286.3, 606.60 1133378769, 0, 0, 36.777007, -121.954015, 285.6, 606.60 1133379274, 0, 0, 36.777047, -121.954455, 285.5, 601.16 1133379779, 0, 0, 36.777042, -121.954533, 286.1, 616.07 1133380284, 0, 0, 36.777123, -121.954622, 286.2, 523.81 1133380789, 0, 0, 36.777190, -121.955263, 287.0, 358.52 1133381294, 0, 0, 36.777585, -121.956273, 286.8, 210.38 1133381799, 0, 0, 36.777195, -121.956297, 285.6, 277.18 1133382304, 0, 0, 36.776897, -121.954425, 286.2, 277.55 1133382809, 0, 0, 36.777558, -121.956893, 286.0, 277.64 1133383314, 0, 0, 36.777143, -121.955998, 285.9, 277.71 1133383819, 0, 0, 36.777137, -121.955953, 285.6, 277.73 1133384324, 0, 0, 36.777153, -121.956100, 287.4, 182.09 1133384829, 0, 0, 36.776773, -121.956037, 285.7, 176.95 1133385334, 0, 0, 36.776353, -121.955638, 285.9, 177.11 1133385839, 0, 0, 36.776197, -121.955672, 285.9, 177.15 1133386344, 0, 0, 36.775902, -121.955885, 285.7, 201.94 1133386849, 0, 0, 36.775632, -121.955988, 285.9, 202.09 1133387354, 0, 0, 36.775242, -121.955988, 285.3, 202.15 1133387859, 0, 0, 36.774905, -121.956028, 285.7, 226.10 1133388364, 0, 0, 36.775213, -121.955853, 183.2, 252.38 1133388869, 0, 0, 36.775440, -121.955810, 183.3, 252.50 1133389374, 0, 0, 36.775563, -121.955653, 184.4, 221.30 1133389879, 0, 0, 36.775380, -121.955690, 184.0, 194.03 1133390385, 0, 0, 36.775278, -121.955810, 183.1, 100.65 1133390890, 0, 0, 36.773120, -121.950388, 182.9, 100.90 1133391395, 0, 0, 36.775038, -121.955175, 183.1, 51.11 1133391900, 0, 0, 36.775060, -121.955195, 183.4, 51.38 1133392405, 0, 0, 36.775047, -121.955180, 183.1, 51.43 1133392910, 0, 0, 36.775047, -121.955180, 183.1, 51.43 1133393415, 0, 0, 36.775047, -121.955180, 183.1, 51.43 1133393920, 0, 0, 36.775047, -121.955180, 183.1, 51.43 334: 21311 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005334vnta.txt 21311 in tList 21311 in {self->{rovT}} 21311 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1133377275 & 1133389005 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/334/accesses.txt at bin\geopdvc.pl line 2169 ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.77690300 hash{lon} = -121.95518000 latMin = 30.776903 latMax = 42.776903 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.776903 AND 42.776903 AND Longitude BETWEEN -127.95518 AND -115.95518 Dive lat = 36.77690300, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.95518000 & lat = 36.77690300 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2765rov_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/vnta2765lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2163 shipNav(): $#{$self->{shipLat}}[last] = 36.776032 Position subsampling set to 17 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 21326 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2765tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2765mergedCtdNav.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 '11/30/2005 5:47:00 PM' AND '11/30/2005 11:30:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/30/2005 5:47:00 PM' AND '11/30/2005 11:30: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), RecordedD at bin\geopdvc.pl line 542 ate, 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 '11/30/2005 5:47:00 PM' AND '11/30/2005 11:30:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/30/2005 5:47:00 PM' AND '11/30/2005 11:30: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 '11/30/2005 5:47:00 PM' AND '11/30/2005 11:30:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/30/2005 5:47:00 PM' AND '11/30/2005 11:30:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.