Running bin\geopdvc.pl at Mon Dec 17 03:01:19 2007 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3116 bin\geopdvc.pl: Getting Expedition object for diveno = 3116 and rname = vnta set_expd(): rov = vnta, diveno = 3116 set_expd(): $self->{EndDDD} = 292 set_expd(): $self->{StartEsecs} = 1192824030 set_expd(): $self->{EndEsecs} = 1192829460 set_expd(): $self->{EndDtg} = 10/19/2007 9:11:00 PM _readLogr(): Reading videologr data from 2007292datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1192824030 & 1192829460 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 542 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1192824031 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1192829457 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1192824031 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1192829457 refineStartAndEndEsecs(): setting StartEsecs to 1192824030 refineStartAndEndEsecs(): setting EndEsecs to 1192825022 refineStartAndEndEsecs(): numMinBack = 5.46666666666667, numMinForward = 21.7833333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1192824902, Refined EndEsecs = 1192829567 _readLogr(): Reading videologr data from 2007292datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1192824902 & 1192829567 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 465 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1192824912 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1192829567 bin\geopdvc.pl: expdid = 3759 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 292 (looping to 292) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007292vnta.txt esecs, east, north, lat, lon, head, pres 1192825736, 0, 0, 36.800177, -121.821112, 181.0, 184.84 1192826241, 0, 0, 36.799913, -121.821132, 257.5, 190.87 1192826747, 0, 0, 36.799763, -121.821213, 255.7, 190.87 1192827252, 0, 0, 36.799767, -121.821253, 256.6, 191.01 1192827758, 0, 0, 36.800012, -121.821187, 17.3, 140.41 1192828263, 0, 0, 36.800455, -121.821232, 17.8, 8.25 292: 3168 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007292vnta.txt rovNav(): Initial # seconds to fill at beginning of dive = 331 starting at StartEsecs = 1192824902 rovNav(): Initial # seconds to fill at end of dive = 0 ending at EndEsecs =1192829567 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1192824912 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1192829567 rovNav(): numMinBack = 5.3, numMinForward = 21.7833333333333 rovNav(): Refined StartEsecs = 1192824902, Refined EndEsecs = 1192829567 rovNav(): Refined # seconds to fill at beginning of dive = 331 starting at StartEsecs = 1192824902 rovNav(): Refined # seconds to fill at end of dive = 0 ending at EndEsecs =1192829567 rovNav(): num tList = 3168 rovNav(): num eList = 3168 rovNav(): Adding data to begining of dive from logr indices 0 .. 32 rovNav(): Adding data to end of dive from logr indices 465 .. 465 rovNav(): num in tList now = 3202 rovNav(): num in eList now = 3202 3202 in tList 3202 in {self->{rovT}} 3202 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1192825260 & 1192827000 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): calcUTM = 0 rovnavCTDO(): getRaw = 1 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 292 (looping to 292) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007292vnta.txt esecs, east, north, lat, lon, head, pres 1192825736, 0, 0, 36.800177, -121.821112, 181.0, 184.84 1192826241, 0, 0, 36.799913, -121.821132, 257.5, 190.87 1192826747, 0, 0, 36.799763, -121.821213, 255.7, 190.87 1192827252, 0, 0, 36.799767, -121.821253, 256.6, 191.01 1192827758, 0, 0, 36.800012, -121.821187, 17.3, 140.41 1192828263, 0, 0, 36.800455, -121.821232, 17.8, 8.25 292: 3168 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007292vnta.txt 3168 in tList 3168 in {self->{rovT}} 3168 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1192825260 & 1192827000 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXX.........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79990300 hash{lon} = -121.82121500 latMin = 30.799903 latMax = 42.799903 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.799903 AND 42.799903 AND Longitude BETWEEN -127.821215 AND -115.821215 Dive lat = 36.79990300, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.82121500 & lat = 36.79990300 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3116rov_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 = geo2007/vnta/vnta3116lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 465 shipNav(): $#{$self->{shipLat}}[last] = 36.802607 Position subsampling set to 3 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = 0.1633 0.1507 0.0000 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 0.0000 0.1395 0.8605 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1.0000 0.7100 0.0000 setROVcolorlines(): frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/292/accesses.txt at bin\geopdvc.pl line 2188 Assigning color line for Temp... varColors = TempColors index0 = 0.3656 0.6344 0.0000 makeTracks(): n = 3203 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3116tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2007/vnta/vnta3116mergedCtdNav.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/19/2007 8:20:30 PM' AND '10/19/2007 9:11:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/19/2007 8:20:30 PM' AND '10/19/2007 9:11:00 PM') _findIndex(): Looking for epoch secs 1192825734 ... Found time 1192825733 after 4 iterations. >>> p = 495: annotations(): 495, 1192825734, 10/19/07 20:28:54, V3116-01, 03:09:40:02, nanomia, , 182.449996948242, descend, lonny, o, 2316749 _findIndex(): Looking for epoch secs 1192825766 ... Found time 1192825770 after 7 iterations. >>> p = 531: annotations(): 531, 1192825766, 10/19/07 20:29:26, V3116-01, 03:10:12:10, sediment, , 191.850006103516, descend, lonny, o, 2316750 _findIndex(): Looking for epoch secs 1192826140 ... Found time 1192826145 after 7 iterations. >>> p = 903: annotations(): 903, 1192826140, 10/19/07 20:35:40, V3116-01, 03:16:25:22, mud, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3116/03_16_25_22.jpg, 189.369995117188, cruise, lonny, o, 2316751 _findIndex(): Looking for epoch secs 1192826822 ... Found time 1192826821 after 7 iterations. >>> p = 1571: annotations(): 1571, 1192826822, 10/19/07 20:47:02, V3116-01, 03:27:46:21, serrivomer, , 189.399993896484, cruise, lonny, o, 2316752 _findIndex(): Looking for epoch secs 1192826958 ... Found time 1192826958 after 6 iterations. >>> p = 1707: annotations(): 1707, 1192826958, 10/19/07 20:49:18, V3116-01, 03:30:02:08, foersteria, , 189.380004882813, cruise, lonny, o, 2316753 _findIndex(): Looking for epoch secs 1192827047 ... Found time 1192827046 after 7 iterations. >>> p = 1794: annotations(): 1794, 1192827047, 10/19/07 20:50:47, V3116-01, 03:31:31:04, beroe, , 189.399993896484, cruise, lonny, o, 2316754 _findIndex(): Looking for epoch secs 1192827095 ... Found time 1192827096 after 7 iterations. >>> p = 1843: annotations(): 1843, 1192827095, 10/19/07 20:51:35, V3116-01, 03:32:18:10, polychaeta, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3116/03_32_18_10.jpg, 189.440002441406, cruise, lonny, o, 2316755 _findIndex(): Looking for epoch secs 1192827216 ... Found time 1192827221 after 7 iterations. >>> p = 1967: annotations(): 1967, 1192827216, 10/19/07 20:53:36, V3116-01, 03:34:18:26, foersteria, , 189.460006713867, cruise, lonny, o, 2316756 _findIndex(): Looking for epoch secs 1192827268 ... Found time 1192827271 after 7 iterations. >>> p = 2016: annotations(): 2016, 1192827268, 10/19/07 20:54:28, V3116-01, 03:35:11:18, foersteria, , 189.490005493164, cruise, lonny, o, 2316757 _findIndex(): Looking for epoch secs 1192827272 ... Found time 1192827271 after 7 iterations. >>> p = 2016: annotations(): 2016, 1192827272, 10/19/07 20:54:32, V3116-01, 03:35:15:12, nanomia, , 189.5, cruise, lonny, o, 2316758 _findIndex(): Looking for epoch secs 1192827598 ... Found time 1192827596 after 7 iterations. >>> p = 2338: annotations(): 2338, 1192827598, 10/19/07 20:59:58, V3116-01, 03:40:42:13, object, , 183.220001220703, ascend, lonny, o, 2316759 _findIndex(): Looking for epoch secs 1192827773 ... Found time 1192827771 after 7 iterations. >>> p = 2511: annotations(): 2511, 1192827773, 10/19/07 21:02:53, V3116-01, 03:43:35:22, phacellophora, , 1frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/292/accesses.txt at bin\geopdvc.pl line 554 32.429992675781, ascend, lonny, o, 2316760 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... placeAnnotations(): Placing annotation 10: object Ancillary data = ["object", "P: 189.2 db", "T: 7.849 C", "S: 34.166", "O: 1.16 ml/l", "L: 79.9 %"] inline_name = vnta3116anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: mud Ancillary data = ["mud", "P: 192.2 db", "T: 7.894 C", "S: 34.159", "O: 1.21 ml/l", "L: 79.2 %"] placeAnnotations(): Placing annotation 4: foersteria Ancillary data = ["foersteria", "P: 189.1 db", "T: 7.851 C", "S: 34.164", "O: 1.16 ml/l", "L: 78.4 %"] placeAnnotations(): Placing annotation 6: polychaeta Ancillary data = ["polychaeta", "P: 189.3 db", "T: 7.844 C", "S: 34.166", "O: 1.16 ml/l", "L: 79.3 %"] placeAnnotations(): Placing annotation 8: foersteria Ancillary data = ["foersteria", "P: 189.2 db", "T: 7.839 C", "S: 34.168", "O: 1.15 ml/l", "L: 78.7 %"] placeAnnotations(): Placing annotation 10: object Ancillary data = ["object", "P: 189.2 db", "T: 7.849 C", "S: 34.166", "O: 1.16 ml/l", "L: 79.9 %"] placeAnnotations(): Placing annotation 12: Ancillary data = ["", "P: 134.5 db", "T: 9.018 C", "S: 34.046", "O: 1.66 ml/l", "L: 77.8 %"] inline_name = vnta3116anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: sediment Ancillary data = ["sediment", "P: 185.6 db", "T: 7.937 C", "S: 34.152", "O: 1.22 ml/l", "L: 79.7 %"] placeAnnotations(): Placing annotation 2: mud Ancillary data = ["mud", "P: 192.2 db", "T: 7.894 C", "S: 34.159", "O: 1.21 ml/l", "L: 79.2 %"] placeAnnotations(): Placing annotation 3: serrivomer Ancillary data = ["serrivomer", "P: 189.3 db", "T: 7.899 C", "S: 34.159", "O: 1.18 ml/l", "L: 77 %"] placeAnnotations(): Placing annotation 4: foersteria Ancillary data = ["foersteria", "P: 189.1 db", "T: 7.851 C", "S: 34.164", "O: 1.16 ml/l", "L: 78.4 %"] placeAnnotations(): Placing annotation 5: beroe Ancillary data = ["beroe", "P: 189.2 db", "T: 7.846 C", "S: 34.166", "O: 1.16 ml/l", "L: 78.9 %"] placeAnnotations(): Placing annotation 6: polychaeta Ancillary data = ["polychaeta", "P: 189.3 db", "T: 7.844 C", "S: 34.166", "O: 1.16 ml/l", "L: 79.3 %"] placeAnnotations(): Placing annotation 7: foersteria Ancillary data = ["foersteria", "P: 189.3 db", "T: 7.851 C", "S: 34.166", "O: 1.16 ml/l", "L: 79.6 %"] placeAnnotations(): Placing annotation 8: foersteria Ancillary data = ["foersteria", "P: 189.2 db", "T: 7.839 C", "S: 34.168", "O: 1.15 ml/l", "L: 78.7 %"] placeAnnotations(): Placing annotation 9: nanomia Ancillary data = ["nanomia", "P: 189.2 db", "T: 7.849 C", "S: 34.166", "O: 1.16 ml/l", "L: 79.9 %"] placeAnnotations(): Placing annotation 10: object Ancillary data = ["object", "P: 189.2 db", "T: 7.849 C", "S: 34.166", "O: 1.16 ml/l", "L: 79.9 %"] placeAnnotations(): Placing annotation 11: phacellophora Ancillary data = ["phacellophora", "P: 182.1 db", "T: 8.234 C", "S: 34.134", "O: 1.27 ml/l", "L: 78.2 %"] placeAnnotations(): Placing annotation 12: Ancillary data = ["", "P: 134.5 db", "T: 9.018 C", "S: 34.046", "O: 1.66 ml/l", "L: 77.8 %"] inline_name = vnta3116anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/vnta3116... frameGrabs(): matched 03_16_25_22 in [IMG] 03_16_25_22.jpg 03-Dec-2007 21:09 52k frameGrabs(): matched 03_32_18_10 in [IMG] 03_32_18_10.jpg 03-Dec-2007 21:09 61k iList = 03_16_25_22.jpg 03_32_18_10.jpg _findIndex(): Looking for epoch secs 1192826140 ... Found time 1192826145 after 7 iterations. >>> p = 903: frameGrabs(): index = 903 EXPD::frameGrabs(): 903: Time=1192826145, Depth=187.8, Lat= 36.799925, Lon=-121.821117, Pres=189.3, Temp=7.899, Sal=34.159, O2=1.18, Light=77 _findIndex(): Looking for epoch secs 1192827095 ... Found time 1192827096 after 7 iterations. >>> p = 1843: frameGrabs(): index = 1843 EXPD::frameGrabs(): 1843: Time=1192827090, Depth=187.8, Lat= 36.799730, Lon=-121.821232, Pres=189.3, Temp=7.851, Sal=34.166, O2=1.16, Light=79.6 bin\geopdvc.pl: Calling placeImages with every 10 image... inline_name = vnta3116fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... inline_name = vnta3116fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... placeImages(): Placing image 1 03_32_18_10.jpg 1192827095 fw= 0.0 cm Xinline_name = vnta3116fg01.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/19/2007 8:20:30 PM' AND '10/19/2007 9:11:00 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2007/vnta/vnta3116.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3759,'/3Dreplay/3D.asp?dives=vnta3116','vnta3116','','','',3116 Executing sql: UPDATE Dive SET DiveLatMid = 36.7999, DiveLonMid = -121.8212, DiveDepthMid = -189.3 WHERE RovName = 'vnta' AND DiveNumber = 3116