Running bin\geopdvc.pl at Mon Aug 27 17:13:20 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2740 bin\geopdvc.pl: Getting Expedition object for diveno = 2740 and rname = vnta set_expd(): rov = vnta, diveno = 2740 set_expd(): $self->{EndDDD} = 292 set_expd(): $self->{StartEsecs} = 1129736010 set_expd(): $self->{EndEsecs} = 1129759995 set_expd(): $self->{EndDtg} = 10/19/2005 9:53:15 PM _readLogr(): Reading videologr data from 2005292datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1129736010 & 1129759995 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2395 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1129736015 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1129759990 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1129736015 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1129759990 refineStartAndEndEsecs(): setting StartEsecs to 1129736010 refineStartAndEndEsecs(): setting EndEsecs to 1129736316 refineStartAndEndEsecs(): numMinBack = 16.9, numMinForward = 20.4166666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1129736196, Refined EndEsecs = 1129760020 _readLogr(): Reading videologr data from 2005292datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1129736196 & 1129760020 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2379 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1129736206 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1129760020 bin\geopdvc.pl: expdid = 3314 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 292 (looping to 292) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005292vntaedited.txt esecs, east, north, lat, lon, head, pres 1129737667, 0, 0, 36.746673, -122.055658, 61.1, 145.95 1129738172, 0, 0, 36.747261, -122.053959, 93.6, 315.89 1129738677, 0, 0, 36.746878, -122.052516, 93.6, 519.25 1129739182, 0, 0, 36.746640, -122.051729, 92.8, 582.13 1129739687, 0, 0, 36.746926, -122.051369, 93.6, 635.14 1129740192, 0, 0, 36.746995, -122.051042, 93.4, 638.75 1129740697, 0, 0, 36.747005, -122.051040, 93.4, 637.85 1129741202, 0, 0, 36.746985, -122.051032, 93.4, 637.95 1129741707, 0, 0, 36.746979, -122.051022, 93.2, 638.05 1129742212, 0, 0, 36.746878, -122.051040, 93.0, 636.45 1129742717, 0, 0, 36.746906, -122.051024, 93.5, 637.18 1129743222, 0, 0, 36.746946, -122.050867, 93.5, 639.85 1129743727, 0, 0, 36.746916, -122.050833, 107.8, 640.09 1129744232, 0, 0, 36.746958, -122.050841, 106.6, 640.91 1129744737, 0, 0, 36.746923, -122.050849, 107.3, 640.74 1129745242, 0, 0, 36.746890, -122.050739, 106.9, 641.38 1129745747, 0, 0, 36.746907, -122.050746, 106.9, 641.92 1129746252, 0, 0, 36.746922, -122.050803, 107.3, 641.36 1129746757, 0, 0, 36.746870, -122.050735, 106.7, 641.29 1129747262, 0, 0, 36.746870, -122.050712, 107.1, 641.74 1129747767, 0, 0, 36.746832, -122.050741, 107.2, 641.20 1129748272, 0, 0, 36.746833, -122.050737, 106.6, 641.08 1129748777, 0, 0, 36.746901, -122.050772, 107.3, 641.58 1129749282, 0, 0, 36.746639, -122.050560, 45.8, 501.12 1129749787, 0, 0, 36.746314, -122.050773, 228.6, 472.02 1129750292, 0, 0, 36.746349, -122.051042, 15.5, 467.63 1129750797, 0, 0, 36.746544, -122.051195, 82.1, 444.81 1129751302, 0, 0, 36.746563, -122.051506, 156.6, 443.35 1129751807, 0, 0, 36.746645, -122.051694, 247.3, 436.05 1129752312, 0, 0, 36.746777, -122.052027, 60.1, 423.33 1129752817, 0, 0, 36.746785, -122.052227, 56.7, 430.89 1129753322, 0, 0, 36.746818, -122.052353, 89.5, 429.08 1129753827, 0, 0, 36.746672, -122.052778, 168.8, 401.26 1129754332, 0, 0, 36.746461, -122.053067, 209.7, 372.66 1129754837, 0, 0, 36.746860, -122.052936, 32.0, 353.11 1129755342, 0, 0, 36.747213, -122.052871, 20.4, 325.09 1129755848, 0, 0, 36.747318, -122.052852, 74.7, 306.03 1129756353, 0, 0, 36.747489, -122.052771, 80.4, 264.69 1129756858, 0, 0, 36.747466, -122.052267, 89.8, 237.85 1129757363, 0, 0, 36.747846, -122.051885, 88.9, 209.27 1129757868, 0, 0, 36.747894, -122.051856, 90.5, 224.54 1129758373, 0, 0, 36.747682, -122.051920, 223.7, 168.56 292: 21433 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005292vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 912 starting at StartEsecs = 1129736196 rovNav(): Initial # seconds to fill at end of dive = 1209 ending at EndEsecs =1129760020 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1129736206 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1129760020 rovNav(): numMinBack = 16.7333333333333, numMinForward = 20.4166666666667 rovNav(): Refined StartEsecs = 1129736196, Refined EndEsecs = 1129760020 rovNav(): Refined # seconds to fill at beginning of dive = 912 starting at StartEsecs = 1129736196 rovNav(): Refined # seconds to fill at end of dive = 1209 ending at EndEsecs =1129760020 rovNav(): num tList = 21433 rovNav(): num eList = 21433 rovNav(): Adding data to begining of dive from logr indices 0 .. 90 rovNav(): Adding data to end of dive from logr indices 2259 .. 2379 rovNav(): num in tList now = 21645 rovNav(): num in eList now = 21645 21645 in tList 21645 in {self->{rovT}} 21645 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1129746540 & 1129753650 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 = 292 (looping to 292) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005292vnta.txt esecs, east, north, lat, lon, head, pres 1129737667, 0, 0, 36.746663, -122.055688, 61.1, 145.95 1129738172, 0, 0, 36.747248, -122.053952, 93.6, 315.89 1129738677, 0, 0, 36.746873, -122.052455, 93.6, 519.25 1129739182, 0, 0, 36.746653, -122.051750, 92.8, 582.13 1129739687, 0, 0, 36.746943, -122.051368, 93.6, 635.14 1129740192, 0, 0, 36.746997, -122.051045, 93.4, 638.75 1129740697, 0, 0, 36.747013, -122.051055, 93.4, 637.85 1129741202, 0, 0, 36.746992, -122.051047, 93.4, 637.95 1129741707, 0, 0, 36.746982, -122.051022, 93.2, 638.05 1129742212, 0, 0, 36.746873, -122.051042, 93.0, 636.45 1129742717, 0, 0, 36.746922, -122.051030, 93.5, 637.18 1129743222, 0, 0, 36.746935, -122.050870, 93.5, 639.85 1129743727, 0, 0, 36.746922, -122.050845, 107.8, 640.09 1129744232, 0, 0, 36.746955, -122.050840, 106.6, 640.91 1129744737, 0, 0, 36.746922, -122.050860, 107.3, 640.74 1129745242, 0, 0, 36.746893, -122.050730, 106.9, 641.38 1129745747, 0, 0, 36.746905, -122.050750, 106.9, 641.92 1129746252, 0, 0, 36.746925, -122.050800, 107.3, 641.36 1129746757, 0, 0, 36.746882, -122.050755, 106.7, 641.29 1129747262, 0, 0, 36.746878, -122.050718, 107.1, 641.74 1129747767, 0, 0, 36.746832, -122.050747, 107.2, 641.20 1129748272, 0, 0, 36.746813, -122.050717, 106.6, 641.07 1129748777, 0, 0, 36.746903, -122.050775, 107.3, 641.58 1129749282, 0, 0, 36.746747, -122.048323, 45.8, 501.12 1129749787, 0, 0, 36.746318, -122.050768, 228.6, 472.02 1129750292, 0, 0, 36.746358, -122.051052, 15.5, 467.63 1129750797, 0, 0, 36.746540, -122.051185, 82.1, 444.81 1129751302, 0, 0, 36.746568, -122.051520, 156.6, 443.35 1129751807, 0, 0, 36.746647, -122.051683, 247.3, 436.05 1129752312, 0, 0, 36.746783, -122.052027, 60.1, 423.33 1129752817, 0, 0, 36.746787, -122.052222, 56.7, 430.89 1129753322, 0, 0, 36.746815, -122.052348, 89.5, 429.08 1129753827, 0, 0, 36.746673, -122.052787, 168.8, 401.26 1129754332, 0, 0, 36.746460, -122.053067, 209.7, 372.66 1129754837, 0, 0, 36.746863, -122.052928, 32.0, 353.11 1129755342, 0, 0, 36.747207, -122.052880, 20.4, 325.09 1129755848, 0, 0, 36.747330, -122.052852, 74.7, 306.03 1129756353, 0, 0, 36.747488, -122.052765, 80.4, 264.69 1129756858, 0, 0, 36.747467, -122.052272, 89.8, 237.85 1129757363, 0, 0, 36.747843, -122.051887, 88.9, 209.27 1129757868, 0, 0, 36.747863, -122.051913, 90.5, 224.54 1129758373, 0, 0, 36.747608, -122.051862, 223.7, 168.56 292: 21433 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005292vnta.txt 21433 in tList 21433 in {self->{rovT}} 21433 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1129746540 & 1129753650 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74689700 hash{lon} = -122.05115000 latMin = 30.746897 latMax = 42.746897 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.746897 AND 42.746897 AND Longitude BETWEEN -128.05115 AND -116.05115 Dive lat = 36.74689700, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05115000 & lat = 36.74689700 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2740rov_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.3frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/292/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 , 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/vnta2740lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2379 shipNav(): $#{$self->{shipLat}}[last] = 36.755263 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 = 21646 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2740tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2740mergedCtdNav.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/19/2005 3:53:30 PM' AND '10/19/2005 9:53:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/19/2005 3:53:30 PM' AND '10/19/2005 9:53: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/19/2005 3:53:30 PM' AND '10/19/2005 9:53:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/19/2005 3:53:30 PM' AND '10/19/2005 9:53: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/19/2005 3:53:30 PM' AND '10/19/2005 9:53:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/19/2005 3:53:30 PM' AND '10/19/2005 9:53:15 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.