Running bin\geopdvc.pl at Sun Aug 16 03:00:14 2009 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3385 bin\geopdvc.pl: Getting Expedition object for diveno = 3385 and rname = vnta set_expd(): rov = vnta, diveno = 3385 set_expd(): $self->{EndDDD} = 169 set_expd(): $self->{StartEsecs} = 1245339540 set_expd(): $self->{EndEsecs} = 1245356010 set_expd(): $self->{EndDtg} = 6/18/2009 7:53:30 PM _readLogr(): Reading videologr data from 2009169datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1245339540 & 1245356010 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1245356018, self->{EndEsecs} = 1245356010 _readLogr(): #LOGHOST_SYSTEM_UTC = 1646 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1245339545 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1245356008 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1245339545 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1245356008 refineStartAndEndEsecs(): setting StartEsecs to 1245339540 refineStartAndEndEsecs(): setting EndEsecs to 1245339555 refineStartAndEndEsecs(): numMinBack = 21.75, numMinForward = 5.46666666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1245339435, Refined EndEsecs = 1245355138 _readLogr(): Reading videologr data from 2009169datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1245339435 & 1245355138 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1245355148, self->{EndEsecs} = 1245355138 _readLogr(): #LOGHOST_SYSTEM_UTC = 1569 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1245339445 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1245355138 bin\geopdvc.pl: expdid = 4106 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 = 169 (looping to 169) Does file exist?: \\tornado\TempNav\2009\vnta\nav2009169vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009169vnta.txt esecs, east, north, lat, lon, head, pres 1245340787, 0, 0, 36.700048, -122.049877, 314.0, 52.73 1245341288, 0, 0, 36.701567, -122.051682, 313.3, 52.15 1245341790, 0, 0, 36.703027, -122.053308, 313.7, 100.69 1245342291, 0, 0, 36.704190, -122.054527, 137.5, 199.99 1245342792, 0, 0, 36.703713, -122.052287, 96.4, 203.00 1245343293, 0, 0, 36.703802, -122.050607, 96.7, 298.99 1245343794, 0, 0, 36.703578, -122.047680, 96.7, 301.02 1245344295, 0, 0, 36.703357, -122.048037, 269.9, 402.73 1245344796, 0, 0, 36.703287, -122.051417, 269.5, 404.19 1245345298, 0, 0, 36.702333, -122.050463, 134.7, 505.06 1245345799, 0, 0, 36.701623, -122.048260, 94.8, 544.95 1245346300, 0, 0, 36.702867, -122.049655, 323.8, 606.51 1245346801, 0, 0, 36.704085, -122.050798, 323.2, 692.01 1245347303, 0, 0, 36.703292, -122.047793, 105.2, 708.05 1245347804, 0, 0, 36.702727, -122.044735, 104.9, 712.48 1245348305, 0, 0, 36.703480, -122.046175, 316.1, 807.95 1245348807, 0, 0, 36.704845, -122.047623, 134.4, 858.73 1245349308, 0, 0, 36.703273, -122.046148, 134.9, 908.76 1245349809, 0, 0, 36.702105, -122.044978, 349.0, 1009.96 1245350310, 0, 0, 36.704980, -122.045820, 349.0, 1010.29 1245350811, 0, 0, 36.705393, -122.045947, 325.3, 903.04 1245351312, 0, 0, 36.704830, -122.045790, 325.4, 736.00 1245351813, 0, 0, 36.704412, -122.045347, 92.2, 605.40 1245352315, 0, 0, 36.704243, -122.043937, 92.5, 546.13 1245352816, 0, 0, 36.704062, -122.042837, 90.2, 472.63 1245353317, 0, 0, 36.703930, -122.041178, 81.7, 446.76 1245353818, 0, 0, 36.704290, -122.041670, 310.5, 335.24 1245354319, 0, 0, 36.704065, -122.041462, 310.5, 142.16 1245354922, 0, 0, 36.703550, -122.040780, 347.7, 2.12 rovNav(): 169: 14524 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009169vnta.txt 14524 in tList 14524 in {self->{rovT}} 14524 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1245344100 & 1245349215 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXX rovGDCListRefs(): dMedian = 500.487563625587 rovGDCListRefs(): dStats->sample_range = 1002.54531366987 rovGDCListRefs(): returning (1st elements): 1245340136 36.757935 -122.093893 178.7 3.28551406117321 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 169 (looping to 169) Does file exist?: \\tornado\TempNav\2009\vnta\nav2009169vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009169vntaedited.txt esecs, east, north, lat, lon, head, pres 1245340787, 0, 0, 36.700081, -122.049911, 314.0, 52.73 1245341288, 0, 0, 36.701745, -122.051640, 313.3, 52.15 1245341790, 0, 0, 36.703018, -122.053304, 313.7, 100.69 1245342291, 0, 0, 36.704166, -122.054513, 137.5, 199.99 1245342792, 0, 0, 36.703737, -122.051854, 96.4, 203.00 1245343293, 0, 0, 36.703726, -122.050604, 96.7, 298.99 1245343794, 0, 0, 36.703589, -122.047714, 96.7, 301.02 1245344295, 0, 0, 36.703419, -122.048318, 269.9, 402.73 1245344796, 0, 0, 36.703284, -122.051397, 269.5, 404.19 1245345298, 0, 0, 36.702352, -122.050469, 134.7, 505.06 1245345799, 0, 0, 36.701585, -122.048291, 94.8, 544.95 1245346300, 0, 0, 36.702863, -122.049652, 323.8, 606.51 1245346801, 0, 0, 36.704056, -122.050745, 323.2, 692.01 1245347303, 0, 0, 36.703264, -122.047786, 105.2, 708.05 1245347804, 0, 0, 36.702755, -122.044919, 104.9, 712.48 1245348305, 0, 0, 36.703497, -122.046179, 316.1, 807.95 1245348807, 0, 0, 36.704876, -122.047766, 134.4, 858.74 1245349308, 0, 0, 36.703238, -122.046112, 134.9, 908.76 1245349809, 0, 0, 36.702142, -122.044994, 349.0, 1009.96 1245350310, 0, 0, 36.704944, -122.045858, 349.0, 1010.29 1245350811, 0, 0, 36.705399, -122.045986, 325.3, 903.04 1245351312, 0, 0, 36.704809, -122.045817, 325.4, 736.00 1245351813, 0, 0, 36.704400, -122.045340, 92.2, 605.40 1245352315, 0, 0, 36.704223, -122.043942, 92.5, 546.13 1245352816, 0, 0, 36.704057, -122.042818, 90.2, 472.63 1245353317, 0, 0, 36.703935, -122.041142, 81.7, 446.76 1245353818, 0, 0, 36.704264, -122.041634, 310.5, 335.24 1245354319, 0, 0, 36.704088, -122.041450, 310.5, 142.16 1245354922, 0, 0, 36.705437, -122.043440, 347.7, 2.11 rovNav(): 169: 14524 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009169vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 701 starting at StartEsecs = 1245339435 rovNav(): Initial # seconds to fill at end of dive = 144 ending at EndEsecs =1245355138 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1245339445 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1245355138 rovNav(): numMinBack = 21.5833333333333, numMinForward = 5.46666666666667 rovNav(): Refined StartEsecs = 1245339435, Refined EndEsecs = 1245355138 rovNav(): Refined # seconds to fill at beginning of dive = 701 starting at StartEsecs = 1245339435 rovNav(): Refined # seconds to fill at end of dive = 144 ending at EndEsecs =1245355138 rovNav(): num tList = 14524 rovNav(): num eList = 14524 rovNav(): Adding data to begining of dive from logr indices 0 .. 69 rovNav(): Adding data to end of dive from logr indices 1555 .. 1569 rovNav(): num in tList now = 14609 rovNav(): num in eList now = 14609 14609 in tList 14609 in {self->{rovT}} 14609 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1245344100 & 1245349215 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXX rovGDCListRefs(): dMedian = 500.339059673617 rovGDCListRefs(): dStats->sample_range = 1009.54045453967 rovGDCListRefs(): returning (1st elements): 1245339445 36.700025 -122.049532 173.6 -5 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70370700 hash{lon} = -122.0475frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2009/169/accesses.txt at bin\geopdvc.pl line 2382 3500 latMin = 30.703707 latMax = 42.703707 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.703707 AND 42.703707 AND Longitude BETWEEN -128.047535 AND -116.047535 Dive lat = 36.70370700, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.04753500 & lat = 36.70370700 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3385rov_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 = geo2009/vnta/vnta3385lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = ptlo shipNav(): $#{$self->{shipLat}} = 1569 shipNav(): $#{$self->{shipLat}}[last] = 36.703582 Position subsampling set to 12 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 = 14610 makeTracks(): Looping through 1569 point of ship position data... makeTracks(): posSubsample = 12 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3385tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2009/vnta/vnta3385mergedCtdNav.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, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '6/18/2009 3:59:00 PM' AND '6/18/2009 7:53:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/18/2009 3:59:00 PM' AND '6/18/2009 7:53: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, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '6/18/2009 3:59:00 PM' AND '6/18/2009 7:53:30 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/18/2009 3:59:00 PM' AND '6/18/2009 7:53: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, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '6/18/2009 3:59:00 PM' AND '6/18/2009 7:53:30 PM') OR (RovNam at bin\geopdvc.pl line 613 e = 'Ventana') AND (RecordedDate BETWEEN '6/18/2009 3:59:00 PM' AND '6/18/2009 7:53:30 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Timeout expired