Running bin\geopdvc.pl at Mon Aug 27 18:23:29 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2771 bin\geopdvc.pl: Getting Expedition object for diveno = 2771 and rname = vnta set_expd(): rov = vnta, diveno = 2771 set_expd(): $self->{EndDDD} = 348 set_expd(): $self->{StartEsecs} = 1134578700 set_expd(): $self->{EndEsecs} = 1134601470 set_expd(): $self->{EndDtg} = 12/14/2005 10:44:30 PM _readLogr(): Reading videologr data from 2005348datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1134578700 & 1134601470 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2274 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1134578705 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1134601469 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1134578705 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1134601469 refineStartAndEndEsecs(): setting StartEsecs to 1134578700 refineStartAndEndEsecs(): setting EndEsecs to 1134579696 refineStartAndEndEsecs(): numMinBack = 5.4, numMinForward = 15.8 refineStartAndEndEsecs(): Refined StartEsecs = 1134579576, Refined EndEsecs = 1134601218 _readLogr(): Reading videologr data from 2005348datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1134579576 & 1134601218 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2161 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1134579586 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1134601218 bin\geopdvc.pl: expdid = 3344 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 348 (looping to 348) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005348vntaedited.txt esecs, east, north, lat, lon, head, pres 1134580224, 0, 0, 36.699083, -122.043475, 351.6, 77.98 1134580729, 0, 0, 36.699355, -122.042793, 82.4, 122.38 1134581234, 0, 0, 36.699595, -122.042037, 324.0, 157.34 1134581739, 0, 0, 36.699947, -122.041940, 356.3, 200.79 1134582244, 0, 0, 36.700027, -122.042080, 1.4, 349.78 1134582749, 0, 0, 36.699965, -122.041943, 305.5, 466.24 1134583254, 0, 0, 36.699708, -122.042382, 226.9, 493.87 1134583759, 0, 0, 36.699680, -122.042423, 283.1, 586.13 1134584264, 0, 0, 36.700068, -122.041718, 45.0, 685.97 1134584769, 0, 0, 36.700012, -122.041278, 44.7, 707.44 1134585274, 0, 0, 36.700037, -122.040957, 194.4, 726.64 1134585779, 0, 0, 36.700132, -122.040777, 3.7, 756.40 1134586284, 0, 0, 36.700863, -122.040453, 23.0, 761.71 1134586789, 0, 0, 36.701895, -122.039792, 19.0, 736.44 1134587295, 0, 0, 36.702742, -122.039032, 11.8, 714.03 1134587800, 0, 0, 36.703628, -122.038742, 18.0, 691.47 1134588305, 0, 0, 36.704202, -122.040278, 10.5, 644.28 1134588810, 0, 0, 36.705393, -122.037847, 38.6, 613.10 1134589315, 0, 0, 36.705732, -122.036807, 53.3, 605.72 1134589820, 0, 0, 36.706360, -122.036080, 33.7, 588.02 1134590325, 0, 0, 36.706782, -122.035260, 41.5, 582.79 1134590830, 0, 0, 36.707150, -122.034443, 48.8, 555.61 1134591335, 0, 0, 36.707197, -122.034242, 40.6, 526.57 1134591840, 0, 0, 36.707592, -122.033947, 351.9, 505.12 1134592345, 0, 0, 36.707672, -122.033740, 71.8, 495.03 1134592850, 0, 0, 36.707933, -122.033402, 28.4, 479.24 1134593355, 0, 0, 36.708618, -122.032985, 10.4, 469.92 1134593860, 0, 0, 36.709328, -122.032702, 15.6, 457.22 1134594365, 0, 0, 36.709543, -122.032557, 42.1, 438.09 1134594870, 0, 0, 36.710195, -122.031092, 45.8, 417.94 1134595375, 0, 0, 36.710928, -122.029703, 51.2, 392.09 1134595880, 0, 0, 36.711703, -122.028650, 39.4, 369.27 1134596385, 0, 0, 36.712215, -122.027742, 46.7, 331.74 1134596890, 0, 0, 36.712920, -122.026778, 45.8, 286.93 1134597395, 0, 0, 36.713392, -122.025935, 44.3, 262.62 1134597901, 0, 0, 36.713423, -122.025293, 342.8, 253.02 1134598406, 0, 0, 36.713573, -122.024365, 35.2, 220.85 1134598911, 0, 0, 36.714008, -122.023513, 26.2, 177.24 1134599416, 0, 0, 36.714875, -122.023195, 40.3, 132.89 1134599921, 0, 0, 36.714902, -122.023212, 40.2, 69.76 1134600426, 0, 0, 36.715637, -122.022342, 356.8, 2.82 348: 20729 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005348vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 141 starting at StartEsecs = 1134579576 rovNav(): Initial # seconds to fill at end of dive = 560 ending at EndEsecs =1134601218 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1134579586 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1134601218 rovNav(): numMinBack = 5.23333333333333, numMinForward = 15.8 rovNav(): Refined StartEsecs = 1134579576, Refined EndEsecs = 1134601218 rovNav(): Refined # seconds to fill at beginning of dive = 141 starting at StartEsecs = 1134579576 rovNav(): Refined # seconds to fill at end of dive = 560 ending at EndEsecs =1134601218 rovNav(): num tList = 20729 rovNav(): num eList = 20729 rovNav(): Adding data to begining of dive from logr indices 0 .. 13 rovNav(): Adding data to end of dive from logr indices 2105 .. 2161 rovNav(): num in tList now = 20800 rovNav(): num in eList now = 20800 20800 in tList 20800 in {self->{rovT}} 20800 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1134592260 & 1134593100 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 = 348 (looping to 348) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005348vnta.txt esecs, east, north, lat, lon, head, pres 1134580224, 0, 0, 36.699083, -122.043475, 351.6, 77.98 1134580729, 0, 0, 36.699355, -122.042793, 82.4, 122.38 1134581234, 0, 0, 36.699595, -122.042037, 324.0, 157.34 1134581739, 0, 0, 36.699947, -122.041940, 356.3, 200.79 1134582244, 0, 0, 36.700027, -122.042080, 1.4, 349.78 1134582749, 0, 0, 36.699965, -122.041943, 305.5, 466.24 1134583254, 0, 0, 36.699708, -122.042382, 226.9, 493.87 1134583759, 0, 0, 36.699680, -122.042423, 283.1, 586.13 1134584264, 0, 0, 36.700068, -122.041718, 45.0, 685.97 1134584769, 0, 0, 36.700012, -122.041278, 44.7, 707.44 1134585274, 0, 0, 36.700037, -122.040957, 194.4, 726.64 1134585779, 0, 0, 36.700132, -122.040777, 3.7, 756.40 1134586284, 0, 0, 36.700863, -122.040453, 23.0, 761.71 1134586789, 0, 0, 36.701895, -122.039792, 19.0, 736.44 1134587295, 0, 0, 36.702742, -122.039032, 11.8, 714.03 1134587800, 0, 0, 36.703628, -122.038742, 18.0, 691.47 1134588305, 0, 0, 36.704202, -122.040278, 10.5, 644.28 1134588810, 0, 0, 36.705393, -122.037847, 38.6, 613.10 1134589315, 0, 0, 36.705732, -122.036807, 53.3, 605.72 1134589820, 0, 0, 36.706360, -122.036080, 33.7, 588.02 1134590325, 0, 0, 36.706782, -122.035260, 41.5, 582.79 1134590830, 0, 0, 36.707150, -122.034443, 48.8, 555.61 1134591335, 0, 0, 36.707197, -122.034242, 40.6, 526.57 1134591840, 0, 0, 36.707592, -122.033947, 351.9, 505.12 1134592345, 0, 0, 36.707672, -122.033740, 71.8, 495.03 1134592850, 0, 0, 36.707933, -122.033402, 28.4, 479.24 1134593355, 0, 0, 36.708618, -122.032985, 10.4, 469.92 1134593860, 0, 0, 36.709328, -122.032702, 15.6, 457.22 1134594365, 0, 0, 36.709543, -122.032557, 42.1, 438.09 1134594870, 0, 0, 36.710195, -122.031092, 45.8, 417.94 1134595375, 0, 0, 36.710928, -122.029703, 51.2, 392.09 1134595880, 0, 0, 36.711703, -122.028650, 39.4, 369.27 1134596385, 0, 0, 36.712215, -122.027742, 46.7, 331.74 1134596890, 0, 0, 36.712920, -122.026778, 45.8, 286.93 1134597395, 0, 0, 36.713392, -122.025935, 44.3, 262.62 1134597901, 0, 0, 36.713423, -122.025293, 342.8, 253.02 1134598406, 0, 0, 36.713573, -122.024365, 35.2, 220.85 1134598911, 0, 0, 36.714008, -122.023513, 26.2, 177.24 1134599416, 0, 0, 36.714875, -122.023195, 40.3, 132.89 1134599921, 0, 0, 36.714902, -122.023212, 40.2, 69.76 1134600426, 0, 0, 36.715637, -122.022342, 356.8, 2.82 348: 20729 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005348vnta.txt 20729 in tList 20729 in {self->{rovT}} 20729 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1134592260 & 1134593100 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/348/accesses.txt at bin\geopdvc.pl line 2169 .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70700500 hash{lon} = -122.03479300 latMin = 30.707005 latMax = 42.707005 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.707005 AND 42.707005 AND Longitude BETWEEN -128.034793 AND -116.034793 Dive lat = 36.70700500, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.03479300 & lat = 36.70700500 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2771rov_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/vnta2771lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2161 shipNav(): $#{$self->{shipLat}}[last] = 36.724885 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 = 20801 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2771tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2771mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '12/14/2005 5:05:00 PM' AND '12/14/2005 10:44:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/14/2005 5:05:00 PM' AND '12/14/2005 10:44:30 PM') Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '12/14/2005 5:05:00 PM' AND '12/14/2005 10:44:30 PM') OR (RovName = 'Ventana at bin\geopdvc.pl line 542 ') AND (RecordedDate BETWEEN '12/14/2005 5:05:00 PM' AND '12/14/2005 10:44:30 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 '12/14/2005 5:05:00 PM' AND '12/14/2005 10:44:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '12/14/2005 5:05:00 PM' AND '12/14/2005 10:44:30 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.