Running bin\geopdvc.pl at Mon Aug 27 17:18:00 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2741 bin\geopdvc.pl: Getting Expedition object for diveno = 2741 and rname = vnta set_expd(): rov = vnta, diveno = 2741 set_expd(): $self->{EndDDD} = 293 set_expd(): $self->{StartEsecs} = 1129823175 set_expd(): $self->{EndEsecs} = 1129847085 set_expd(): $self->{EndDtg} = 10/20/2005 10:04:45 PM _readLogr(): Reading videologr data from 2005293datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1129823175 & 1129847085 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2387 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1129823184 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1129847078 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1129823184 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1129847078 refineStartAndEndEsecs(): setting StartEsecs to 1129823175 refineStartAndEndEsecs(): setting EndEsecs to 1129823654 refineStartAndEndEsecs(): numMinBack = 14.0166666666667, numMinForward = 12.2166666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1129823534, Refined EndEsecs = 1129846618 _readLogr(): Reading videologr data from 2005293datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1129823534 & 1129846618 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2305 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1129823544 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1129846618 bin\geopdvc.pl: expdid = 3316 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 293 (looping to 293) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005293vntaedited.txt esecs, east, north, lat, lon, head, pres 1129824475, 0, 0, 36.777707, -121.992404, 271.0, 66.51 1129824980, 0, 0, 36.777918, -121.991109, 70.6, 333.95 1129825485, 0, 0, 36.777846, -121.989656, 93.7, 557.94 1129826005, 0, 0, 36.777939, -121.989494, 341.5, 741.30 1129826510, 0, 0, 36.777998, -121.989084, 327.6, 738.05 1129827015, 0, 0, 36.778090, -121.988608, 47.4, 734.82 1129827520, 0, 0, 36.777823, -121.988782, 16.2, 767.14 1129828025, 0, 0, 36.777606, -121.988800, 30.4, 787.50 1129828530, 0, 0, 36.777397, -121.989208, 301.4, 821.18 1129829035, 0, 0, 36.776508, -121.988956, 352.6, 847.56 1129829540, 0, 0, 36.777106, -121.988965, 11.8, 832.82 1129830045, 0, 0, 36.777572, -121.989252, 342.1, 793.29 1129830550, 0, 0, 36.777770, -121.989305, 56.4, 755.42 1129831055, 0, 0, 36.777970, -121.989353, 308.4, 729.30 1129831560, 0, 0, 36.778141, -121.989333, 7.3, 710.39 1129832065, 0, 0, 36.778128, -121.989577, 267.4, 690.80 1129832570, 0, 0, 36.777424, -121.989953, 302.4, 767.34 1129833075, 0, 0, 36.777257, -121.990051, 349.8, 807.92 1129833580, 0, 0, 36.777530, -121.989971, 37.0, 746.36 1129834085, 0, 0, 36.777804, -121.989958, 359.1, 716.33 1129834590, 0, 0, 36.778406, -121.989941, 287.7, 642.45 1129835095, 0, 0, 36.778446, -121.990951, 290.8, 634.28 1129835600, 0, 0, 36.778973, -121.992902, 286.6, 634.19 1129836105, 0, 0, 36.779496, -121.994305, 299.0, 633.88 1129836610, 0, 0, 36.780079, -121.996603, 282.7, 634.00 1129837115, 0, 0, 36.780617, -121.999274, 279.7, 634.38 1129837620, 0, 0, 36.781275, -122.002242, 279.8, 634.51 1129838125, 0, 0, 36.782358, -122.005001, 256.4, 749.64 1129838630, 0, 0, 36.782473, -122.005990, 259.6, 934.91 1129839135, 0, 0, 36.782403, -122.006884, 294.6, 944.45 1129839640, 0, 0, 36.782938, -122.007059, 339.4, 905.50 1129840145, 0, 0, 36.783615, -122.007621, 293.7, 867.39 1129840650, 0, 0, 36.783843, -122.008011, 307.2, 850.67 1129841155, 0, 0, 36.783944, -122.008245, 298.4, 829.71 1129841660, 0, 0, 36.784445, -122.008588, 357.1, 802.82 1129842165, 0, 0, 36.784987, -122.008586, 355.4, 788.41 1129842670, 0, 0, 36.785655, -122.008401, 266.7, 755.52 1129843175, 0, 0, 36.785831, -122.008613, 263.8, 652.21 1129843680, 0, 0, 36.785880, -122.008610, 261.4, 576.02 1129844185, 0, 0, 36.785853, -122.008605, 263.0, 410.33 1129844690, 0, 0, 36.785853, -122.008609, 263.9, 329.24 1129845195, 0, 0, 36.785856, -122.008609, 264.1, 195.67 1129845700, 0, 0, 36.785864, -122.008605, 263.5, 12.00 293: 21634 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005293vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 453 starting at StartEsecs = 1129823534 rovNav(): Initial # seconds to fill at end of dive = 718 ending at EndEsecs =1129846618 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1129823544 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1129846618 rovNav(): numMinBack = 13.85, numMinForward = 12.2166666666667 rovNav(): Refined StartEsecs = 1129823534, Refined EndEsecs = 1129846618 rovNav(): Refined # seconds to fill at beginning of dive = 453 starting at StartEsecs = 1129823534 rovNav(): Refined # seconds to fill at end of dive = 718 ending at EndEsecs =1129846618 rovNav(): num tList = 21634 rovNav(): num eList = 21634 rovNav(): Adding data to begining of dive from logr indices 0 .. 44 rovNav(): Adding data to end of dive from logr indices 2234 .. 2305 rovNav(): num in tList now = 21751 rovNav(): num in eList now = 21751 21751 in tList 21751 in {self->{rovT}} 21751 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1129826490 & 1129827705 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXX........................................................................................................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 = 293 (looping to 293) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005293vnta.txt esecs, east, north, lat, lon, head, pres 1129824475, 0, 0, 36.777707, -121.992440, 271.0, 66.51 1129824980, 0, 0, 36.777933, -121.991068, 70.6, 333.95 1129825485, 0, 0, 36.777865, -121.989667, 93.7, 557.94 1129826005, 0, 0, 36.777935, -121.989492, 341.5, 741.30 1129826510, 0, 0, 36.778002, -121.989083, 327.6, 738.05 1129827015, 0, 0, 36.778102, -121.988607, 47.4, 734.82 1129827520, 0, 0, 36.777823, -121.988785, 16.2, 767.14 1129828025, 0, 0, 36.777605, -121.988787, 30.4, 787.50 1129828530, 0, 0, 36.777395, -121.989230, 301.4, 821.18 1129829035, 0, 0, 36.776482, -121.988922, 352.6, 847.56 1129829540, 0, 0, 36.777112, -121.988962, 11.8, 832.82 1129830045, 0, 0, 36.777558, -121.989255, 342.1, 793.29 1129830550, 0, 0, 36.777768, -121.989297, 56.4, 755.42 1129831055, 0, 0, 36.777968, -121.989355, 308.4, 729.30 1129831560, 0, 0, 36.778152, -121.989340, 7.3, 710.39 1129832065, 0, 0, 36.778135, -121.989577, 267.4, 690.80 1129832570, 0, 0, 36.777397, -121.989957, 302.4, 767.34 1129833075, 0, 0, 36.777262, -121.990050, 349.8, 807.92 1129833580, 0, 0, 36.777547, -121.989987, 37.0, 746.36 1129834085, 0, 0, 36.777820, -121.989960, 359.1, 716.33 1129834590, 0, 0, 36.778403, -121.989930, 287.7, 642.45 1129835095, 0, 0, 36.778812, -121.990972, 290.8, 634.28 1129835600, 0, 0, 36.778972, -121.992907, 286.6, 634.19 1129836105, 0, 0, 36.779500, -121.994315, 299.0, 633.88 1129836610, 0, 0, 36.780082, -121.996608, 282.7, 634.00 1129837115, 0, 0, 36.780650, -121.999295, 279.7, 634.38 1129837620, 0, 0, 36.781280, -122.002240, 279.8, 634.51 1129838125, 0, 0, 36.782412, -122.004995, 256.4, 749.64 1129838630, 0, 0, 36.782472, -122.005947, 259.6, 934.91 1129839135, 0, 0, 36.782372, -122.006893, 294.6, 944.45 1129839640, 0, 0, 36.782950, -122.007065, 339.4, 905.50 1129840145, 0, 0, 36.783617, -122.007610, 293.7, 867.39 1129840650, 0, 0, 36.783825, -122.008012, 307.2, 850.67 1129841155, 0, 0, 36.783942, -122.008240, 298.4, 829.71 1129841660, 0, 0, 36.784423, -122.008595, 357.1, 802.82 1129842165, 0, 0, 36.784998, -122.008597, 355.4, 788.41 1129842670, 0, 0, 36.785663, -122.008385, 266.7, 755.52 1129843175, 0, 0, 36.786007, -122.008862, 263.8, 652.21 1129843680, 0, 0, 36.785888, -122.008607, 261.4, 576.02 1129844185, 0, 0, 36.785845, -122.008602, 263.0, 410.33 1129844690, 0, 0, 36.785852, -122.008608, 263.9, 329.24 1129845195, 0, 0, 36.785855, -122.008605, 264.1, 195.67 1129845700, 0, 0, 36.785862, -122.008608, 263.5, 12.00 293: 21634 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005293vnta.txt 21634 in tList 21634 in {self->{rovT}} 21634 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1129826490 & 1129827705 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXX........................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.77894700 hash{lon} = -121.99202300 latMin = 30.778947 latMax = 42.778947 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.778947 AND 42.778947 AND Longitude BETWEEN -127.992023 AND -115.992023 Dive lat = 36.77894700, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.99202300 & lat = 36.77894700 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2741rov_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, frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/293/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 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/vnta2741lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 239 shipNav(): $#{$self->{shipLat}}[last] = 36.777327 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 = 21752 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2741tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2741mergedCtdNav.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/20/2005 4:06:15 PM' AND '10/20/2005 10:04:45 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/20/2005 4:06:15 PM' AND '10/20/2005 10:04:45 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/20/2005 4:06:15 PM' AND '10/20/2005 10:04:45 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/20/2005 4:06:15 PM' AND '10/20/2005 10:04:45 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/20/2005 4:06:15 PM' AND '10/20/2005 10:04:45 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/20/2005 4:06:15 PM' AND '10/20/2005 10:04:45 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.