Running .\bin\geopdvc.pl at Thu Sep 13 16:16:28 2007 on host scyphozoan Command line: .\bin\geopdvc.pl -rov vnta -dive 2833 .\bin\geopdvc.pl: Getting Expedition object for diveno = 2833 and rname = vnta set_expd(): rov = vnta, diveno = 2833 set_expd(): $self->{EndDDD} = 152 set_expd(): $self->{StartEsecs} = 1149187740 set_expd(): $self->{EndEsecs} = 1149191760 set_expd(): $self->{EndDtg} = 6/1/2006 7:36:00 PM _readLogr(): Reading videologr data from 2006152datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1149187740 & 1149191760 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 401 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1149187741 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1149191755 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1149187741 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1149191755 refineStartAndEndEsecs(): setting StartEsecs to 1149187740 refineStartAndEndEsecs(): setting EndEsecs to 1149188762 refineStartAndEndEsecs(): numMinBack = 4.96666666666667, numMinForward = 20.9166666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1149188642, Refined EndEsecs = 1149191815 _readLogr(): Reading videologr data from 2006152datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1149188642 & 1149191815 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 316 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1149188652 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1149191815 .\bin\geopdvc.pl: expdid = 3435 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 152 (looping to 152) rovNav(): Opening ROV nav data from \\tornado\TempNav\2006\vnta\nav2006152vntaedited.txt esecs, east, north, lat, lon, head, pres 1149189125, 0, 0, 36.797044, -121.822429, 180.5, 98.16 1149189630, 0, 0, 36.796974, -121.822877, 95.2, 199.49 1149190135, 0, 0, 36.797366, -121.822952, 16.0, 122.59 152: 1649 in tList after reading from \\tornado\TempNav\2006\vnta\nav2006152vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 292 starting at StartEsecs = 1149188642 rovNav(): Initial # seconds to fill at end of dive = 927 ending at EndEsecs =1149191815 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1149188652 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1149191815 rovNav(): numMinBack = 4.8, numMinForward = 20.9166666666667 rovNav(): Refined StartEsecs = 1149188642, Refined EndEsecs = 1149191815 rovNav(): Refined # seconds to fill at beginning of dive = 292 starting at StartEsecs = 1149188642 rovNav(): Refined # seconds to fill at end of dive = 927 ending at EndEsecs =1149191815 rovNav(): num tList = 1649 rovNav(): num eList = 1649 rovNav(): Adding data to begining of dive from logr indices 0 .. 28 rovNav(): Adding data to end of dive from logr indices 224 .. 316 rovNav(): num in tList now = 1771 rovNav(): num in eList now = 1771 1771 in tList 1771 in {self->{rovT}} 1771 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1149190425 & 1149189975 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..............................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 = 152 (looping to 152) rovNav(): Opening ROV nav data from \\tornado\TempNav\2006\vnta\nav2006152vnta.txt esecs, east, north, lat, lon, head, pres 1149189125, 0, 0, 36.796497, -121.824922, 180.5, 98.16 1149189630, 0, 0, 36.796993, -121.822882, 95.2, 199.49 1149190135, 0, 0, 36.797290, -121.822997, 16.0, 122.59 152: 1649 in tList after reading from \\tornado\TempNav\2006\vnta\nav2006152vnta.txt 1649 in tList 1649 in {self->{rovT}} 1649 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1149190425 & 1149189975 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXX...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX..............................XXXXXXXX .\bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79698000 hash{lon} = -121.82288700 latMin = 30.79698 latMax = 42.79698 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.79698 AND 42.79698 AND Longitude BETWEEN -127.822887 AND -115.822887 Dive lat = 36.79698000, area = cencal .\bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.82288700 & lat = 36.79698000 Using olon = -122 & olat = 36 .\bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2833rov_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 = frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/152/accesses.txt at .\bin\geopdvc.pl line 2188 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 = geo2006/vnta/vnta2833lookup.wrl .\bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 316 shipNav(): $#{$self->{shipLat}}[last] = 36.806885 Position subsampling set to 2 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 = 1772 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2833tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2006/vnta/vnta2833mergedCtdNav.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/1/2006 7:09:00 PM' AND '6/1/2006 7:36:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/1/2006 7:09:00 PM' AND '6/1/2006 7:36:00 PM') _findIndex(): Looking for epoch secs 1149189611 ... Found time 1149189610 after 4 iterations. >>> p = 669: annotations(): 669, 1149189611, 06/01/06 19:20:11, V2833-01, 00:32:20:17, benthos, , 197.919998168945, stationary, linda, d, 1893877 _findIndex(): Looking for epoch secs 1149189633 ... Found time 1149189636 after 5 iterations. >>> p = 695: annotations(): 695, 1149189633, 06/01/06 19:20:33, V2833-01, 00:32:41:10, mud, , 197.919998168945, stationary, linda, d, 1893878 _findIndex(): Looking for epoch secs 1149189647 ... Found time 1149189649 after 6 iterations. >>> p = 708: annotations(): 708, 1149189647, 06/01/06 19:20:47, V2833-01, 00:32:55:01, lasers, , 197.919998168945, stationary, linda, d, 1893879 _findIndex(): Looking for epoch secs 1149189657 ... Found time 1149189662 after 3 iterations. >>> p = 721: annotations(): 721, 1149189657, 06/01/06 19:20:57, V2833-01, 00:33:05:08, scyliorhinidae, , 197.919998168945, stationary, linda, d, 1893880 _findIndex(): Looking for epoch secs 1149189756 ... Found time 1149189753 after 6 iterations. >>> p = 811: annotations(): 811, 1149189756, 06/01/06 19:22:36, V2833-01, 00:34:43:04, object, , 197.110000610352, cruise, linda, d, 1893881 _findIndex(): Looking for epoch secs 1149189764 ... Found time 1149189766 after 0 iterations. >>> p = 824: annotations(): 824, 1149189764, 06/01/06 19:22:44, V2833-01, 00:34:52:28, bivalvia, , 197.240005493164, cruise, linda, d, 1893882 _findIndex(): Looking for epoch secs 1149189774 ... Found time 1149189778 after 6 iterations. >>> p = 836: annotations(): 836, 1149189774, 06/01/06 19:22:54, V2833-01, 00:35:02:20, brachyura, , 196.970001220703, cruise, linda, d, 1893883 _findIndex(): Looking for epoch secs 1149189790 ... Found time 1149189791 after 5 iterations. >>> p = 849: annotations(): 849, 1149189790, 06/01/06 19:23:10, V2833-01, 00:35:17:24, microstomus-pacificus, , 196.979995727539, cruise, linda, d, 1893884 _findIndex(): Looking for epoch secs 1149189810 ... Found time 1149189811 after 7 iterations. >>> p = 868: annotations(): 868, 1149189810, 06/01/06 19:23:30, V2833-01, 00:35:37:25, water, , 196.389999389648, cruise, linda, d, 1893885 _findIndex(): Looking for epoch secs 1149189852 ... Found time 1149189857 after 6 iterations. >>> p = 914: annotations(): 914, 1149189852, 06/01/06 19:24:12, V2833-01, 00:36:19:13, water, , 197.559997558594, cruise, linda, d, 1893886 _findIndex(): Looking for epoch secs 1149189890 ... Found time 1149189895 after 5 iterations. >>> p = 952: annotations(): 952, 1149189890, 06/01/06 19:24:50, V2833-01, 00:36:59:16, water, , 195.410003662109, cruise, linda, d, 1893887 _findIndex(): Looking for epoch secs 1149190114 ... Found time 1149190117 after 6 iterations. >>> p = 1171: annotations(): 1171, 1149190114, 06/01/06 19:28:34, V2833-01, 00:40:42:18, water, , 127.529998779297, ascend, linda, d, 1893888 _findIndex(): Looking for epoch secs 1149190254 ... Found time 1149190253 after 7 iterations. >>> p = 1306: annotations(): 1306, 1149190254, 06/01/06 19:30:54, V2833-01, 00:43:01:28, water, , 91.4499969482422, ascend, linda, d, 1893889 _findIndex(): Looking for epoch secs 1149190296 ... Found time 1149190298 after 6 iterations. >>> p = 1351: annotations(): 1351, 1149190296, 06/01/06 19:31:36, V2833-01, 00:43:43:15, marine-snow, , 73.870002746582, ascend, linda, d, 1893890 _findIndex(): Looking for epoch secs 1149190345 ... Found time 1149190344 after 7 iterations. >>> p = 1396: annotations(): 1396, 1149190345, 06/01/06 19:32:25, V2833-01, 00:44:32:12, water, , 55.0699996948242, ascend, linda, d, 1893891 _findIndex(): Looking for epoch secs 1149190425 ... Found time 1149190429 after 6 iterations. >>> p = 1480: annotations(): 1480, 1149190425, 06/01/06 19:33:45, V2833-01, 00:45:52:26, euphotic-zone, , 21.6200008392334, ascend, linda, d, 1893892 _findIndex(): Looking for epoch secs 1149190451 ... Found time 1149190455 after 6 iterations. >>> p = 1506: annotations(): 1506, 1149190451, 06/01/06 19:34:11, V2833-01, 00:46:19:18, euphotic-zone, , 9.77000045776367, ascend, linda, d, 1893893 _findIndex(): Looking for epoch secs 1149190481 ... Found time 1149190480 after 7 iterations. >>> p = 1525: annotations(): 1525, 1149190481, 06/01/06 19:34:41, V2833-01, 00:46:48:08, surface-water, , 2.00999999046326, ascend, linda, d, 1893894 .\bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... placeAnnotations(): Placing annotation 10: water Ancillary data = ["water", "P: 196.6 db", "T: 8.199 C", "S: 34.174", "O: 1.43 ml/l", "L: 67.9 %"] inline_name = vnta2833anno10.wrl .\bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: lasers Ancillary data = ["lasers", "P: 198.6 db", "T: 8.17 C", "S: 34.177", "O: 1.41 ml/l", "L: 75.3 %"] placeAnnotations(): Placing annotation 4: object Ancillary data = ["object", "P: 198.5 db", "T: 8.173 C", "S: 34.178", "O: 1.41 ml/l", "L: 74.1 %"] placeAnnotations(): Placing annotation 6: brachyura Ancillary data = ["brachyura", "P: 197.3 db", "T: 8.187 C", "S: 34.179", "O: 1.42 ml/l", "L: 76.2 %"] placeAnnotations(): Placing annotation 8: water Ancillary data = ["water", "P: 196.7 db", "T: 8.183 C", "S: 34.179", "O: 1.42 ml/l", "L: 75.7 %"] placeAnnotations(): Placing annotation 10: water Ancillary data = ["water", "P: 196.6 db", "T: 8.199 C", "S: 34.174", "O: 1.43 ml/l", "L: 67.9 %"] placeAnnotations(): Placing annotation 12: water Ancillary data = ["water", "P: 126.3 db", "T: 8.342 C", "S: 34.165", "O: 1.51 ml/l", "L: 78 %"] placeAnnotations(): Placing annotation 14: water Ancillary data = ["water", "P: 66.3 db", "T: 8.511 C", "S: 34.133", "O: 1.61 ml/l", "L: 80.7 %"] placeAnnotations(): Placing annotation 16: euphotic-zone Ancillary data = ["euphotic-zone", "P: 16.9 db", "T: 9.338 C", "S: 33.973", "O: 2.34 ml/l", "L: 87 %"] placeAnnotations(): Placing annotation 18: Ancillary data = ["", "P: 9.9 db", "T: 10.768 C", "S: 34.001", "O: 3.25 ml/l", "L: 85 %"] inline_name = vnta2833anno02.wrl .\bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: mud Ancillary data = ["mud", "P: 198.6 db", "T: 8.17 C", "S: 34.177", "O: 1.4 frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/152/accesses.txt at .\bin\geopdvc.pl line 554 frameGrabs(): Can't read dir http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/vnta2833: Bad file descriptor at .\bin\geopdvc.pl line 554 ml/l", "L: 76.2 %"] placeAnnotations(): Placing annotation 2: lasers Ancillary data = ["lasers", "P: 198.6 db", "T: 8.17 C", "S: 34.177", "O: 1.41 ml/l", "L: 75.3 %"] placeAnnotations(): Placing annotation 3: scyliorhinidae Ancillary data = ["scyliorhinidae", "P: 198.5 db", "T: 8.171 C", "S: 34.178", "O: 1.41 ml/l", "L: 75 %"] placeAnnotations(): Placing annotation 4: object Ancillary data = ["object", "P: 198.5 db", "T: 8.173 C", "S: 34.178", "O: 1.41 ml/l", "L: 74.1 %"] placeAnnotations(): Placing annotation 5: bivalvia Ancillary data = ["bivalvia", "P: 197.5 db", "T: 8.18 C", "S: 34.178", "O: 1.42 ml/l", "L: 76.1 %"] placeAnnotations(): Placing annotation 6: brachyura Ancillary data = ["brachyura", "P: 197.3 db", "T: 8.187 C", "S: 34.179", "O: 1.42 ml/l", "L: 76.2 %"] placeAnnotations(): Placing annotation 7: microstomus-pacificus Ancillary data = ["microstomus-pacificus", "P: 197.2 db", "T: 8.195 C", "S: 34.173", "O: 1.43 ml/l", "L: 75.9 %"] placeAnnotations(): Placing annotation 8: water Ancillary data = ["water", "P: 196.7 db", "T: 8.183 C", "S: 34.179", "O: 1.42 ml/l", "L: 75.7 %"] placeAnnotations(): Placing annotation 9: water Ancillary data = ["water", "P: 195.7 db", "T: 8.19 C", "S: 34.182", "O: 1.42 ml/l", "L: 76 %"] placeAnnotations(): Placing annotation 10: water Ancillary data = ["water", "P: 196.6 db", "T: 8.199 C", "S: 34.174", "O: 1.43 ml/l", "L: 67.9 %"] placeAnnotations(): Placing annotation 11: water Ancillary data = ["water", "P: 195.2 db", "T: 8.181 C", "S: 34.177", "O: 1.42 ml/l", "L: 70.7 %"] placeAnnotations(): Placing annotation 12: water Ancillary data = ["water", "P: 126.3 db", "T: 8.342 C", "S: 34.165", "O: 1.51 ml/l", "L: 78 %"] placeAnnotations(): Placing annotation 13: marine-snow Ancillary data = ["marine-snow", "P: 86.6 db", "T: 8.45 C", "S: 34.146", "O: 1.58 ml/l", "L: 80.6 %"] placeAnnotations(): Placing annotation 14: water Ancillary data = ["water", "P: 66.3 db", "T: 8.511 C", "S: 34.133", "O: 1.61 ml/l", "L: 80.7 %"] placeAnnotations(): Placing annotation 15: euphotic-zone Ancillary data = ["euphotic-zone", "P: 49.5 db", "T: 8.611 C", "S: 34.118", "O: 1.73 ml/l", "L: 83.9 %"] placeAnnotations(): Placing annotation 16: euphotic-zone Ancillary data = ["euphotic-zone", "P: 16.9 db", "T: 9.338 C", "S: 33.973", "O: 2.34 ml/l", "L: 87 %"] placeAnnotations(): Placing annotation 17: surface-water Ancillary data = ["surface-water", "P: 9.9 db", "T: 10.768 C", "S: 34.001", "O: 3.25 ml/l", "L: 85 %"] placeAnnotations(): Placing annotation 18: Ancillary data = ["", "P: 9.9 db", "T: 10.768 C", "S: 34.001", "O: 3.25 ml/l", "L: 85 %"] inline_name = vnta2833anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2006/vnta2833... iList = .\bin\geopdvc.pl: Calling placeImages with every 10 image... .\bin\geopdvc.pl: Calling placeImages with every 2 image... .\bin\geopdvc.pl: Calling placeImages with every 1 image... .\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 '6/1/2006 7:09:00 PM' AND '6/1/2006 7:36:00 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG .\bin\geopdvc.pl: World = geo2006/vnta/vnta2833.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3435,'/3Dreplay/3D.asp?dives=vnta2833','vnta2833','','','',2833 Executing sql: UPDATE Dive SET DiveLatMid = 36.7970, DiveLonMid = -121.8229, DiveDepthMid = -146.2 WHERE RovName = 'vnta' AND DiveNumber = 2833