Running bin\geopdvc.pl at Sat Dec 19 03:00:50 2009 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3440 bin\geopdvc.pl: Getting Expedition object for diveno = 3440 and rname = vnta set_expd(): rov = vnta, diveno = 3440 set_expd(): $self->{EndDDD} = 294 set_expd(): $self->{StartEsecs} = 1256145600 set_expd(): $self->{EndEsecs} = 1256152800 set_expd(): $self->{EndDtg} = 10/21/2009 7:00:00 PM _readLogr(): Reading videologr data from 2009294datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1256145600 & 1256152800 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1256152803, self->{EndEsecs} = 1256152800 _readLogr(): #LOGHOST_SYSTEM_UTC = 719 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1256145601 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1256152793 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1256145601 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1256152793 refineStartAndEndEsecs(): setting StartEsecs to 1256145600 refineStartAndEndEsecs(): setting EndEsecs to 1256146741 refineStartAndEndEsecs(): numMinBack = 2.98333333333333, numMinForward = 0.7 refineStartAndEndEsecs(): Refined StartEsecs = 1256146621, Refined EndEsecs = 1256151642 _readLogr(): Reading videologr data from 2009294datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1256146621 & 1256151642 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1256151652, self->{EndEsecs} = 1256151642 _readLogr(): #LOGHOST_SYSTEM_UTC = 501 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1256146631 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1256151642 bin\geopdvc.pl: expdid = 4199 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 = 294 (looping to 294) Does file exist?: \\tornado\TempNav\2009\vnta\nav2009294vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009294vnta.txt esecs, east, north, lat, lon, head, pres 1256147173, 0, 0, 36.783960, -121.960913, 224.6, 120.52 1256147674, 0, 0, 36.779257, -121.957793, 198.1, 308.19 1256148175, 0, 0, 36.778612, -121.957807, 281.8, 434.44 1256148675, 0, 0, 36.779330, -121.956683, 226.3, 412.83 1256149176, 0, 0, 36.779167, -121.956303, 249.1, 434.11 1256149677, 0, 0, 36.779652, -121.955402, 243.7, 384.48 1256150178, 0, 0, 36.779755, -121.955868, 267.3, 309.40 1256150679, 0, 0, 36.779748, -121.956585, 265.3, 210.38 1256151180, 0, 0, 36.779968, -121.957522, 266.3, 22.79 rovNav(): 294: 4320 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009294vnta.txt 4320 in tList 4320 in {self->{rovT}} 4320 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1256150505 & 1256149785 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................ rovGDCListRefs(): dMedian = 339.61577059167 rovGDCListRefs(): dStats->sample_range = 429.006061935993 rovGDCListRefs(): returning (1st elements): 1256146894 36.780138 -121.955575 48.6 2.13409708939674 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 294 (looping to 294) Does file exist?: \\tornado\TempNav\2009\vnta\nav2009294vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009294vntaedited.txt esecs, east, north, lat, lon, head, pres 1256147173, 0, 0, 36.780596, -121.958280, 224.6, 120.52 1256147674, 0, 0, 36.779257, -121.957812, 198.1, 308.19 1256148175, 0, 0, 36.778610, -121.957746, 281.8, 434.44 1256148675, 0, 0, 36.779313, -121.956671, 226.3, 412.83 1256149176, 0, 0, 36.779177, -121.956275, 249.1, 434.11 1256149677, 0, 0, 36.779670, -121.955392, 243.7, 384.48 1256150178, 0, 0, 36.779672, -121.955841, 267.3, 309.40 1256150679, 0, 0, 36.779741, -121.956621, 265.3, 210.38 1256151180, 0, 0, 36.779947, -121.957518, 266.3, 22.79 rovNav(): 294: 4320 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009294vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 273 starting at StartEsecs = 1256146621 rovNav(): Initial # seconds to fill at end of dive = 196 ending at EndEsecs =1256151642 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1256146631 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1256151642 rovNav(): numMinBack = 2.81666666666667, numMinForward = 0.7 rovNav(): Refined StartEsecs = 1256146621, Refined EndEsecs = 1256151642 rovNav(): Refined # seconds to fill at beginning of dive = 273 starting at StartEsecs = 1256146621 rovNav(): Refined # seconds to fill at end of dive = 196 ending at EndEsecs =1256151642 rovNav(): num tList = 4320 rovNav(): num eList = 4320 rovNav(): Adding data to begining of dive from logr indices 0 .. 26 rovNav(): Adding data to end of dive from logr indices 482 .. 501 rovNav(): num in tList now = 4367 rovNav(): num in eList now = 4367 4367 in tList 4367 in {self->{rovT}} 4367 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1256150505 & 1256149785 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2009/294/accesses.txt at bin\geopdvc.pl line 2382 ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... rovGDCListRefs(): dMedian = 337.891479805262 rovGDCListRefs(): dStats->sample_range = 436.060750613836 rovGDCListRefs(): returning (1st elements): 1256146631 36.779997 -121.958458 33.7 -5 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.77967050 hash{lon} = -121.95696950 latMin = 30.7796705 latMax = 42.7796705 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.7796705 AND 42.7796705 AND Longitude BETWEEN -127.9569695 AND -115.9569695 Dive lat = 36.77967050, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.95696950 & lat = 36.77967050 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3440rov_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/vnta3440lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = ptlo shipNav(): $#{$self->{shipLat}} = 501 shipNav(): $#{$self->{shipLat}}[last] = 36.780028 Position subsampling set to 4 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = 0.2567 0.2253 0.0000 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0 0 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 1.0000 0.0616 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0.9408 0.0592 0.0000 makeTracks(): n = 4368 makeTracks(): Looping throuframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2009/294/accesses.txt at bin\geopdvc.pl line 625 gh 501 point of ship position data... makeTracks(): posSubsample = 4 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3440tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2009/vnta/vnta3440mergedCtdNav.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 '10/21/2009 5:40:00 PM' AND '10/21/2009 7:00:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/21/2009 5:40:00 PM' AND '10/21/2009 7:00:00 PM') _findIndex(): Looking for epoch secs 1256147821 ... Found time 1256147823 after 4 iterations. >>> p = 954: annotations(): 954, 1256147821, 10/21/09 17:57:01, V3440-02HD, 01:03:35:09, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3440/01_03_35_09.jpg, 330.489990234375, stationary, etp3, o, 20038367 _findIndex(): Looking for epoch secs 1256148467 ... Found time 1256148472 after 6 iterations. >>> p = 1602: annotations(): 1602, 1256148467, 10/21/09 18:07:47, V3440-02HD, 01:14:20:22, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3440/01_14_20_22.jpg, 430.440002441406, stationary, etp3, o, 20038368 _findIndex(): Looking for epoch secs 1256148495 ... Found time 1256148498 after 8 iterations. >>> p = 1628: annotations(): 1628, 1256148495, 10/21/09 18:08:15, V3440-02HD, 01:14:49:06, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3440/01_14_49_06.jpg, 430.369995117188, stationary, etp3, o, 20038369 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... inline_name = vnta3440anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: physical object Ancillary data = ["physical object", "P: 436.7 db", "T: 6.707 C", "S: 34.179", "O: 0.5 ml/l", "L: 86.29 %"] inline_name = vnta3440anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: physical object Ancillary data = ["physical object", "P: 336.1 db", "T: 7.748 C", "S: 34.106", "O: 0.879 ml/l", "L: 87.04 %"] placeAnnotations(): Placing annotation 2: physical object Ancillary data = ["physical object", "P: 436.7 db", "T: 6.707 C", "S: 34.179", "O: 0.5 ml/l", "L: 86.29 %"] placeAnnotations(): Placing annotation 3: Ancillary data = ["", "P: 436.6 db", "T: 6.71 C", "S: 34.179", "O: 0.501 ml/l", "L: 86.34 %"] inline_name = vnta3440anno01.wrl frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2009/vnta3440... frameGrabs(): matched 01_03_35_09 in [IMG] 01_03_35_09.jpg 23-Oct-2009 00:08 79k frameGrabs(): matched 01_14_20_22 in [IMG] 01_14_20_22.jpg 23-Oct-2009 00:08 70k frameGrabs(): matched 01_14_49_06 in [IMG] 01_14_49_06.jpg 23-Oct-2009 00:08 75k iList = 01_03_35_09.jpg 01_14_20_22.jpg 01_14_49_06.jpg _findIndex(): Looking for epoch secs 1256147821 ... Found time 1256147823 after 4 iterations. >>> p = 954: frameGrabs(): index = 954 EXPD::frameGrabs(): 954: Time=1256147820, Depth=333.35, Lat= 36.778996, Lon=-121.957647, Pres=336.1, Temp=7.748, Sal=34.106, O2=0.879, Light=87.04 _findIndex(): Looking for epoch secs 1256148467 ... Found time 1256148472 after 6 iterations. >>> p = 1602: frameGrabs(): index = 1602 EXPD::frameGrabs(): 1602: Time=1256148465, Depth=433.02, Lat= 36.778968, Lon=-121.957172, Pres=436.7, Temp=6.707, Sal=34.179, O2=0.5, Light=86.29 _findIndex(): Looking for epoch secs 1256148495 ... Found time 1256148498 after 8 iterations. >>> p = 1628: frameGrabs(): index = 1628 EXPD::frameGrabs(): 1628: Time=1256148495, Depth=432.92, Lat=36.779005, Lon=-121.957110, Pres=436.6, Temp=6.71, Sal=34.179, O2=0.501, Light=86.34 bin\geopdvc.pl: Number of images returned from expd->frameGrabs(every=>1)} = 3 bin\geopdvc.pl: Calling placeImages with every 10 image... placeImages(): Placing image 0 01_03_35_09.jpg 1256147821 fw= 0.0 cm XplaceImages(): indx = 954, geoPosition = 36.778996, -121.957647, -330.488849756844, rovDepth = 330.488849756844 inline_name = vnta3440fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... placeImages(): Placing image 0 01_03_35_09.jpg 1256147821 fw= 0.0 cm XplaceImages(): indx = 954, geoPosition = 36.778996, -121.957647, -330.488849756844, rovDepth = 330.488849756844 placeImages(): Placing image 2 01_14_49_06.jpg 1256148495 fw= 0.0 cm XplaceImages(): indx = 1628, geoPosition = 36.779005, -121.957110, -430.347587828415, rovDepth = 430.347587828415 inline_name = vnta3440fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... placeImages(): Placing image 0 01_03_35_09.jpg 1256147821 fw= 0.0 cm XplaceImages(): indx = 954, geoPosition = 36.778996, -121.957647, -330.488849756844, rovDepth = 330.488849756844 placeImages(): Placing image 1 01_14_20_22.jpg 1256148467 fw= 0.0 cm XplaceImages(): indx = 1602, geoPosition = 36.778968, -121.957172, -430.377304811239, rovDepth = 430.377304811239 placeImages(): Placing image 2 01_14_49_06.jpg 1256148495 fw= 0.0 cm XplaceImages(): indx = 1628, geoPosition = 36.779005, -121.957110, -430.347587828415, rovDepth = 430.347587828415 inline_name = vnta3440fg01.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 '10/21/2009 5:40:00 PM' AND '10/21/2009 7:00:00 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2009/vnta/vnta3440.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',4199,'/3Dreplay/3D.asp?dives=vnta3440','vnta3440','','','',3440 Executing sql: UPDATE Dive SET DiveLatMid = 36.7797, DiveLonMid = -121.9570, DiveDepthMid = -337.9 WHERE RovName = 'vnta' AND DiveNumber = 3440