Running bin\geopdvc.pl at Mon Aug 27 17:33:25 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2746 bin\geopdvc.pl: Getting Expedition object for diveno = 2746 and rname = vnta set_expd(): rov = vnta, diveno = 2746 set_expd(): $self->{EndDDD} = 300 set_expd(): $self->{StartEsecs} = 1130424915 set_expd(): $self->{EndEsecs} = 1130436555 set_expd(): $self->{EndDtg} = 10/27/2005 5:49:15 PM _readLogr(): Reading videologr data from 2005300datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1130424915 & 1130436555 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 1162 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1130424921 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1130436553 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1130424921 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1130436553 refineStartAndEndEsecs(): setting StartEsecs to 1130424915 refineStartAndEndEsecs(): setting EndEsecs to 1130424941 refineStartAndEndEsecs(): numMinBack = 21.5666666666667, numMinForward = 9.46666666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1130424821, Refined EndEsecs = 1130435923 _readLogr(): Reading videologr data from 2005300datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1130424821 & 1130435923 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 1108 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1130424831 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1130435923 bin\geopdvc.pl: expdid = 3330 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 300 (looping to 300) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005300vntaedited.txt esecs, east, north, lat, lon, head, pres 1130426457, 0, 0, 36.864406, -121.891278, 104.8, 46.90 1130426962, 0, 0, 36.863793, -121.889192, 87.1, 45.39 1130427467, 0, 0, 36.863483, -121.886802, 102.2, 44.02 1130427972, 0, 0, 36.863045, -121.884730, 101.4, 43.34 1130428477, 0, 0, 36.862413, -121.881896, 99.4, 42.40 1130428982, 0, 0, 36.861855, -121.879371, 99.8, 41.85 1130429487, 0, 0, 36.861163, -121.876351, 104.2, 40.26 1130429992, 0, 0, 36.860705, -121.874072, 103.1, 39.21 1130430497, 0, 0, 36.860371, -121.872751, 44.8, 38.47 1130431002, 0, 0, 36.860311, -121.872791, 104.7, 38.51 1130431507, 0, 0, 36.860000, -121.870705, 105.3, 37.21 1130432012, 0, 0, 36.859744, -121.869625, 86.3, 36.58 1130432517, 0, 0, 36.858595, -121.867433, 112.0, 34.01 1130433022, 0, 0, 36.857448, -121.865088, 116.7, 34.10 1130433527, 0, 0, 36.856293, -121.862727, 117.5, 33.64 1130434032, 0, 0, 36.855330, -121.860592, 114.8, 31.05 1130434537, 0, 0, 36.854205, -121.858529, 118.4, 30.47 1130435042, 0, 0, 36.852963, -121.856001, 105.2, 30.12 300: 9338 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005300vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 1082 starting at StartEsecs = 1130424821 rovNav(): Initial # seconds to fill at end of dive = 195 ending at EndEsecs =1130435923 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1130424831 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1130435923 rovNav(): numMinBack = 21.4, numMinForward = 9.46666666666667 rovNav(): Refined StartEsecs = 1130424821, Refined EndEsecs = 1130435923 rovNav(): Refined # seconds to fill at beginning of dive = 1082 starting at StartEsecs = 1130424821 rovNav(): Refined # seconds to fill at end of dive = 195 ending at EndEsecs =1130435923 rovNav(): num tList = 9338 rovNav(): num eList = 9338 rovNav(): Adding data to begining of dive from logr indices 0 .. 107 rovNav(): Adding data to end of dive from logr indices 1089 .. 1108 rovNav(): num in tList now = 9466 rovNav(): num in eList now = 9466 9466 in tList 9466 in {self->{rovT}} 9466 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1130430300 & 1130428485 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 = 300 (looping to 300) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005300vnta.txt esecs, east, north, lat, lon, head, pres 1130426457, 0, 0, 36.864405, -121.891277, 104.8, 46.90 1130426962, 0, 0, 36.863837, -121.889310, 87.1, 45.39 1130427467, 0, 0, 36.863512, -121.886863, 102.2, 44.02 1130427972, 0, 0, 36.863088, -121.884755, 101.4, 43.34 1130428477, 0, 0, 36.862402, -121.881872, 99.4, 42.40 1130428982, 0, 0, 36.861885, -121.879445, 99.8, 41.85 1130429487, 0, 0, 36.861172, -121.876498, 104.2, 40.26 1130429992, 0, 0, 36.859722, -121.875465, 103.1, 39.21 1130430497, 0, 0, 36.860367, -121.872720, 44.8, 38.47 1130431002, 0, 0, 36.860365, -121.872763, 104.7, 38.51 1130431507, 0, 0, 36.859992, -121.870698, 105.3, 37.21 1130432012, 0, 0, 36.859767, -121.869683, 86.3, 36.58 1130432517, 0, 0, 36.858600, -121.867497, 112.0, 34.01 1130433022, 0, 0, 36.857445, -121.865057, 116.7, 34.10 1130433527, 0, 0, 36.856255, -121.862658, 117.5, 33.64 1130434032, 0, 0, 36.855380, -121.860660, 114.8, 31.05 1130434537, 0, 0, 36.854177, -121.858492, 118.4, 30.47 1130435042, 0, 0, 36.852928, -121.855895, 105.2, 30.12 300: 9338 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005300vnta.txt 9338 in tList 9338 in {self->{rovT}} 9338 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1130430300 & 1130428485 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/300/accesses.txt at bin\geopdvc.pl line 2169 ------------------------------------------------------- hash{lat} = 36.86035300 hash{lon} = -121.87277700 latMin = 30.860353 latMax = 42.860353 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.860353 AND 42.860353 AND Longitude BETWEEN -127.872777 AND -115.872777 Dive lat = 36.86035300, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.87277700 & lat = 36.86035300 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2746rov_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/vnta2746lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 1108 shipNav(): $#{$self->{shipLat}}[last] = 36.852810 Position subsampling set to 8 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 = 9467 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2746tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2746mergedCtdNav.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/27/2005 3:15:15 PM' AND '10/27/2005 5:49:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/27/2005 3:15:15 PM' AND '10/27/2005 5:49:15 PM') Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/27/2005 3:15:15 PM' AND '10/27/2005 5:49:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/27/2005 3:15:15 PM' AND '10/27/2005 5:49:15 PM') annotations(): Error in query: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/27/2005 3:15:15 PM' AND '10/27/2005 5:49:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '1 at bin\geopdvc.pl line 542 0/27/2005 3:15:15 PM' AND '10/27/2005 5:49:15 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.