Running bin\geopdvc.pl at Sun Apr 19 03:01:01 2009 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3340 bin\geopdvc.pl: Getting Expedition object for diveno = 3340 and rname = vnta set_expd(): rov = vnta, diveno = 3340 set_expd(): $self->{EndDDD} = 050 set_expd(): $self->{StartEsecs} = 1235075580 set_expd(): $self->{EndEsecs} = 1235084475 set_expd(): $self->{EndDtg} = 2/19/2009 10:41:15 PM _readLogr(): Reading videologr data from 2009050datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1235075580 & 1235084475 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 888 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1235075584 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1235084466 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1235075584 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1235084466 refineStartAndEndEsecs(): setting StartEsecs to 1235075580 refineStartAndEndEsecs(): setting EndEsecs to 1235076564 refineStartAndEndEsecs(): numMinBack = 5.6, numMinForward = 14.1833333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1235076444, Refined EndEsecs = 1235084126 _readLogr(): Reading videologr data from 2009050datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1235076444 & 1235084126 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 767 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1235076454 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1235084126 bin\geopdvc.pl: expdid = 4015 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 = 050 (looping to 050) Does file exist?: \\tornado\TempNav\2009\vnta\nav2009050vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009050vnta.txt esecs, east, north, lat, lon, head, pres 1235076592, 0, 0, 36.769767, -121.892278, 270.0, 3.05 1235077093, 0, 0, 36.786723, -122.030202, 325.4, 132.37 1235077594, 0, 0, 36.787663, -122.030615, 332.3, 354.23 1235078095, 0, 0, 36.787202, -122.030448, 320.7, 608.35 1235078595, 0, 0, 36.786880, -122.030507, 326.5, 730.80 1235079096, 0, 0, 36.786865, -122.030715, 325.8, 728.89 1235079597, 0, 0, 36.786840, -122.031065, 25.4, 726.42 1235080098, 0, 0, 36.786875, -122.031107, 25.9, 725.54 1235080599, 0, 0, 36.786880, -122.031048, 10.2, 723.19 1235081100, 0, 0, 36.787005, -122.030903, 320.6, 719.48 1235081601, 0, 0, 36.787182, -122.030602, 256.4, 714.22 1235082102, 0, 0, 36.787083, -122.030495, 87.9, 526.20 1235082603, 0, 0, 36.787008, -122.030810, 87.8, 297.13 1235083104, 0, 0, 36.786690, -122.030848, 329.7, 73.42 rovNav(): 050: 6766 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009050vnta.txt 6766 in tList 6766 in {self->{rovT}} 6766 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1235078925 & 1235077755 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 702.816821994622 rovGDCListRefs(): dStats->sample_range = 723.166723202084 rovGDCListRefs(): returning (1st elements): 1235076572 36.769767 -121.892278 276.7 2.15395102659066 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 050 (looping to 050) Does file exist?: \\tornado\TempNav\2009\vnta\nav2009050vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009050vntaedited.txt esecs, east, north, lat, lon, head, pres 1235076592, 0, 0, 36.786839, -122.030255, 270.0, 3.05 1235077093, 0, 0, 36.786786, -122.030246, 325.4, 132.37 1235077594, 0, 0, 36.787638, -122.030635, 332.3, 354.23 1235078095, 0, 0, 36.787200, -122.030460, 320.7, 608.35 1235078595, 0, 0, 36.786881, -122.030522, 326.5, 730.80 1235079096, 0, 0, 36.786849, -122.030721, 325.8, 728.89 1235079597, 0, 0, 36.786843, -122.031031, 25.4, 726.42 1235080098, 0, 0, 36.786884, -122.031086, 25.9, 725.54 1235080599, 0, 0, 36.786883, -122.031059, 10.2, 723.19 1235081100, 0, 0, 36.786996, -122.030905, 320.6, 719.48 1235081601, 0, 0, 36.787150, -122.030548, 256.4, 714.22 1235082102, 0, 0, 36.787105, -122.030468, 87.9, 526.20 1235082603, 0, 0, 36.787006, -122.030800, 87.8, 297.13 1235083104, 0, 0, 36.787015, -122.030784, 329.7, 73.42 rovNav(): 050: 6766 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009050vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 128 starting at StartEsecs = 1235076444 rovNav(): Initial # seconds to fill at end of dive = 655 ending at EndEsecs =1235084126 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1235076454 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1235084126 rovNav(): numMinBack = 5.43333333333333, numMinForward = 14.1833333333333 rovNav(): Refined StartEsecs = 1235076444, Refined EndEsecs = 1235084126 rovNav(): Refined # seconds to fill at beginning of dive = 128 starting at StartEsecs = 1235076444 rovNav(): Refined # seconds to fill at end of dive = 655 ending at EndEsecs =1235084126 rovNav(): num tList = 6766 rovNav(): num eList = 6766 rovNav(): Adding data to begining of dive from logr indices 0 .. 11 rovNav(): Adding data to end of dive from logr indices 702 .. 767 rovNav(): num in tList now = 6844 rovNav(): num in eList now = 6844 6844 in tList 6844 in {self->{rovT}} 6844 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1235078925 & 1235077755 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 697.138688901676 rovGDCListRefs(): dStats->sample_range = 730.161854344315 rovGDCListRefs(): returning (1st elements): 1235076454 36.786852 -122.029913 169.3 -5 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.78696600 hash{lon} = -122.03065800 latMin = 30.786966 latMax = 42.786966 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.786966 AND 42.786966 AND Longitude BETWEEN -128.030658 AND -116.030658 Dive lat = 36.78696600, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.03065800 & lat = 36.78696600 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3340rov_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,frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2009/050/accesses.txt at bin\geopdvc.pl line 2382 color = 1 1 0 val = 10, color = 0 1 0 val = 15, color = 1 0 0 World = geo2009/vnta/vnta3340lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 767 shipNav(): $#{$self->{shipLat}}[last] = 36.787683 Position subsampling set to 6 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 = 6845 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3340tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2009/vnta/vnta3340mergedCtdNav.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 '2/19/2009 8:53:00 PM' AND '2/19/2009 10:41:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '2/19/2009 8:53:00 PM' AND '2/19/2009 10:41:15 PM') _findIndex(): Looking for epoch secs 1235080701 ... Found time 1235080697 after 8 iterations. >>> p = 4129: annotations(): 4129, 1235080701, 02/19/09 21:58:21, V3340-01, 02:49:10:08, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3340/02_49_10_08.jpg, 716.719970703125, descend, whpa, o, 20032358 _findIndex(): Looking for epoch secs 1235080710 ... Found time 1235080711 after 7 iterations. >>> p = 4143: annotations(): 4143, 1235080710, 02/19/09 21:58:30, V3340-01, 02:49:18:23, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3340/02_49_18_23.jpg, 717.309997558594, descend, whpa, o, 20032360 _findIndex(): Looking for epoch secs 1235080703 ... Found time 1235080704 after 9 iterations. >>> p = 4136: annotations(): 4136, 1235080703, 02/19/09 21:58:23, V3340-01, 02:49:12:08, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3340/02_49_12_08.jpg, 716.650024414063, descend, whpa, o, 20032359 _findIndex(): Looking for epoch secs 1235080719 ... Found time 1235080724 after 8 iterations. >>> p = 4156: annotations(): 4156, 1235080719, 02/19/09 21:58:39, V3340-01, 02:49:27:25, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3340/02_49_27_25.jpg, 717.97998046875, descend, whpa, o, 20032361 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... inline_name = vnta3340anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: physical object Ancillary data = ["physical object", "P: 720.8 db", "T: 4.937 C", "S: 34.337", "O: 0.31 ml/l", "L: 80.24 %"] placeAnnotations(): Placing annotation 4: Ancillary data = ["", "P: 721.2 db", "T: 4.931 C", "S: 34.338", "O: 0.31 ml/l", "L: 77.97 %"] inline_name = vnta3340anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: physical object Ancillary data = ["physical object", "P: 720.2 db", "T: 4.944 C", "S: 34.337", "O: 0.31 ml/l", "L: 73.5 %"] placeAnnotations(): Placing annotation 2: physical object Ancillary data = ["physical object", "P: 720.8 db", "T: 4.937 C", "S: 34.337", "O: 0.31 ml/l", "L: 80.24 %"] placeAnnotations(): Placing annotation 3: physical object Ancillary data = ["physical object", "P: 720.8 db", "T: 4.937 C", "S: 34.337", "O: 0.31 ml/l", "L: 80.24 %"] placeAnnotations(): Placing annotation 4: Ancillary data = ["", "P: 721.2 db", "T: 4.93frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2009/050/accesses.txt at bin\geopdvc.pl line 626 1 C", "S: 34.338", "O: 0.31 ml/l", "L: 77.97 %"] inline_name = vnta3340anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2009/vnta3340... frameGrabs(): matched 02_49_10_08 in [IMG] 02_49_10_08.jpg 02-Mar-2009 15:43 53k frameGrabs(): matched 02_49_12_08 in [IMG] 02_49_12_08.jpg 02-Mar-2009 15:43 55k frameGrabs(): matched 02_49_18_23 in [IMG] 02_49_18_23.jpg 02-Mar-2009 15:43 54k frameGrabs(): matched 02_49_27_25 in [IMG] 02_49_27_25.jpg 02-Mar-2009 15:43 54k iList = 02_49_10_08.jpg 02_49_12_08.jpg 02_49_18_23.jpg 02_49_27_25.jpg _findIndex(): Looking for epoch secs 1235080701 ... Found time 1235080697 after 8 iterations. >>> p = 4129: frameGrabs(): index = 4129 EXPD::frameGrabs(): 4129: Time=1235080695, Depth=713.65, Lat= 36.786861, Lon=-122.031084, Pres=720.2, Temp=4.944, Sal=34.337, O2=0.31, Light=73.5 _findIndex(): Looking for epoch secs 1235080703 ... Found time 1235080704 after 9 iterations. >>> p = 4136: frameGrabs(): index = 4136 EXPD::frameGrabs(): 4136: Time=1235080710, Depth=714.24, Lat= 36.786861, Lon=-122.031084, Pres=720.8, Temp=4.937, Sal=34.337, O2=0.31, Light=80.24 _findIndex(): Looking for epoch secs 1235080710 ... Found time 1235080711 after 7 iterations. >>> p = 4143: frameGrabs(): index = 4143 EXPD::frameGrabs(): 4143: Time=1235080710, Depth=714.24, Lat= 36.786862, Lon=-122.031085, Pres=720.8, Temp=4.937, Sal=34.337, O2=0.31, Light=80.24 _findIndex(): Looking for epoch secs 1235080719 ... Found time 1235080724 after 8 iterations. >>> p = 4156: frameGrabs(): index = 4156 EXPD::frameGrabs(): 4156: Time=1235080725, Depth=714.64, Lat= 36.786865, Lon=-122.031084, Pres=721.2, Temp=4.931, Sal=34.338, O2=0.31, Light=77.97 bin\geopdvc.pl: Calling placeImages with every 10 image... placeImages(): Placing image 0 02_49_10_08.jpg 1235080701 fw= 0.0 cm XplaceImages(): indx = 4129, geoPosition = 36.786861, -122.031084, -716.823560530263, rovDepth = 716.823560530263 inline_name = vnta3340fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... placeImages(): Placing image 0 02_49_10_08.jpg 1235080701 fw= 0.0 cm XplaceImages(): indx = 4129, geoPosition = 36.786861, -122.031084, -716.823560530263, rovDepth = 716.823560530263 inline_name = vnta3340fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... placeImages(): Placing image 0 02_49_10_08.jpg 1235080701 fw= 0.0 cm XplaceImages(): indx = 4129, geoPosition = 36.786861, -122.031084, -716.823560530263, rovDepth = 716.823560530263 placeImages(): Placing image 1 02_49_12_08.jpg 1235080703 fw= 0.0 cm XplaceImages(): indx = 4136, geoPosition = 36.786861, -122.031084, -716.635623586866, rovDepth = 716.635623586866 placeImages(): Placing image 2 02_49_18_23.jpg 1235080710 fw= 0.0 cm XplaceImages(): indx = 4143, geoPosition = 36.786862, -122.031085, -717.43682719806, rovDepth = 717.43682719806 placeImages(): Placing image 3 02_49_27_25.jpg 1235080719 fw= 0.0 cm XplaceImages(): indx = 4156, geoPosition = 36.786865, -122.031084, -717.891830179991, rovDepth = 717.891830179991 inline_name = vnta3340fg01.wrl bin\geopdvc.pl: Samples: samples(): Executing sql: SELECT DateDiff(ss, '01/01/70', CollectionEventDtg) AS Esecs, CollectionVIMSConcept, FrameGrabImageURL, SampleID, CollectionRefName FROM vwCollSamplePerson WHERE (CollectionEventDTG BETWEEN '2/19/2009 8:53:00 PM' AND '2/19/2009 10:41:15 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2009/vnta/vnta3340.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',4015,'/3Dreplay/3D.asp?dives=vnta3340','vnta3340','','','',3340 Executing sql: UPDATE Dive SET DiveLatMid = 36.7870, DiveLonMid = -122.0307, DiveDepthMid = -697.1 WHERE RovName = 'vnta' AND DiveNumber = 3340