Running bin\geopdvc.pl at Thu Dec 20 03:01:20 2007 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3120 bin\geopdvc.pl: Getting Expedition object for diveno = 3120 and rname = vnta set_expd(): rov = vnta, diveno = 3120 set_expd(): $self->{EndDDD} = 295 set_expd(): $self->{StartEsecs} = 1193078370 set_expd(): $self->{EndEsecs} = 1193083425 set_expd(): $self->{EndDtg} = 10/22/2007 7:43:45 PM _readLogr(): Reading videologr data from 2007295datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1193078370 & 1193083425 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 504 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1193078373 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1193083418 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1193078373 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1193083418 refineStartAndEndEsecs(): setting StartEsecs to 1193078370 refineStartAndEndEsecs(): setting EndEsecs to 1193078533 refineStartAndEndEsecs(): numMinBack = 19.2833333333333, numMinForward = 21.55 refineStartAndEndEsecs(): Refined StartEsecs = 1193078413, Refined EndEsecs = 1193083518 _readLogr(): Reading videologr data from 2007295datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1193078413 & 1193083518 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 509 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1193078423 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1193083518 bin\geopdvc.pl: expdid = 3759 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 295 (looping to 295) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007295vnta.txt esecs, east, north, lat, lon, head, pres 1193079796, 0, 0, 36.802328, -121.802735, 3.1, 88.60 1193080301, 0, 0, 36.802653, -121.803058, 92.2, 120.43 1193080807, 0, 0, 36.802613, -121.802942, 33.8, 120.45 1193081312, 0, 0, 36.802615, -121.802942, 30.5, 120.42 1193081817, 0, 0, 36.802683, -121.802647, 106.0, 59.79 1193082335, 0, 0, 36.802125, -121.802870, 117.7, 2.33 295: 2925 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007295vnta.txt rovNav(): Initial # seconds to fill at beginning of dive = 1012 starting at StartEsecs = 1193078413 rovNav(): Initial # seconds to fill at end of dive = 0 ending at EndEsecs =1193083518 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1193078423 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1193083518 rovNav(): numMinBack = 19.1166666666667, numMinForward = 21.55 rovNav(): Refined StartEsecs = 1193078413, Refined EndEsecs = 1193083518 rovNav(): Refined # seconds to fill at beginning of dive = 1012 starting at StartEsecs = 1193078413 rovNav(): Refined # seconds to fill at end of dive = 0 ending at EndEsecs =1193083518 rovNav(): num tList = 2925 rovNav(): num eList = 2925 rovNav(): Adding data to begining of dive from logr indices 0 .. 100 rovNav(): Adding data to end of dive from logr indices 509 .. 509 rovNav(): num in tList now = 3027 rovNav(): num in eList now = 3027 3027 in tList 3027 in {self->{rovT}} 3027 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1193082060 & 1193079570 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 = 295 (looping to 295) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007295vnta.txt esecs, east, north, lat, lon, head, pres 1193079796, 0, 0, 36.802328, -121.802735, 3.1, 88.60 1193080301, 0, 0, 36.802653, -121.803058, 92.2, 120.43 1193080807, 0, 0, 36.802613, -121.802942, 33.8, 120.45 1193081312, 0, 0, 36.802615, -121.802942, 30.5, 120.42 1193081817, 0, 0, 36.802683, -121.802647, 106.0, 59.79 1193082335, 0, 0, 36.802125, -121.802870, 117.7, 2.33 295: 2925 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007295vnta.txt 2925 in tList 2925 in {self->{rovT}} 2925 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1193082060 & 1193079570 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXX......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/295/accesses.txt at bin\geopdvc.pl line 2188 ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.80257200 hash{lon} = -121.80293200 latMin = 30.802572 latMax = 42.802572 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.802572 AND 42.802572 AND Longitude BETWEEN -127.802932 AND -115.802932 Dive lat = 36.80257200, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.80293200 & lat = 36.80257200 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3120rov_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/vnta3120lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 509 shipNav(): $#{$self->{shipLat}}[last] = 36.801938 Position subsampling set to 3 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 = 3028 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3120tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2007/vnta/vnta3120mergedCtdNav.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/22/2007 6:59:30 PM' AND '10/22/2007 7:43:45 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/22/2007 6:59:30 PM' AND '10/22/2007 7:43:45 PM') _findIndex(): Looking for epoch secs 1193079601 ... Found time 1193079605 after 5 iterations. >>> p = 45: annotations(): 45, 1193079601, 10/22/07 19:00:01, V3120-01, 03:56:28:01, chrysaora-fuscescens, , 15.7200002670288, descend, lonny, o, 2317756 _findIndex(): Looking for epoch secs 1193079937 ... Found time 1193079939 after 7 iterations. >>> p = 376: annotations(): 376, 1193079937, 10/22/07 19:05:37, V3120-01, 04:02:02:27, sediment, , 115.370002746582, descend, lonny, o, 2317757 _findIndex(): Looking for epoch secs 1193080021 ... Found time 1193080020 after 4 iterations. >>> p = 456: annotations(): 456, 1193080021, 10/22/07 19:07:01, V3120-01, 04:03:26:29, sardinops-sagax, , 119.349998474121, cruise, lonny, o, 2317758 _findIndex(): Looking for epoch secs 1193080051 ... Found time 1193080055 after 7 iterations. >>> p = 490: annotations(): 490, 1193080051, 10/22/07 19:07:31, V3120-01, 04:03:58:08, sardinops-sagax, , 112.459999084473, cruise, lonny, o, 2317759 _findIndex(): Looking for epoch secs 1193080212 ... Found time 1193080216 after 7 iterations. >>> p = 650: annotations(): 650, 1193080212, 10/22/07 19:10:12, V3120-01, 04:06:38:04, sardinops-sagax, , 119.51000213623, cruise, lonny, o, 2317760 _findIndex(): Looking for epoch secs 1193080284 ... Found time 1193080286 after 7 iterations. >>> p = 719: annotations(): 719, 1193080284, 10/22/07 19:11:24, V3120-01, 04:07:51:06, sardinops-sagax, , 119.519996643066, cruise, lonny, o, 2317761 _findIndex(): Looking for epoch secs 1193080369 ... Found time 1193080367 after 6 iterations. >>> p = 799: annotations(): 799, 1193080369, 10/22/07 19:12:49, V3120-01, 04:09:15:19, mud, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3120/04_09_15_19.jpg, 119.550003051758, stationary, lonny, o, 2317762 _findIndex(): Looking for epoch secs 1193080536 ... Found time 1193080539 after 7 iterations. >>> p = 969: annotations(): 969, 1193080536, 10/22/07 19:15:36, V3120-01, 04:12:01:11, sardinops-sagax, , 119.550003051758, stationary, lonny, o, 2317763 _findIndex(): Looking for epoch secs 1193080628 ... Found time 1193080632 after 7 iterations. >>> p = 1061: annotations(): 1061, 1193080628, 10/22/07 19:17:08, V3120-01, 04:13:34:10, sardinops-sagax, , 119.550003051758, stationary, lonny, o, 2317764 _findIndex(): Looking for epoch secs 1193080636 ... Found time 1193080632 after 7 iterations. >>> p = 1061: annotations(): 1061, 1193080636, 10/22/07 19:17:16, V3120-01, 04:13:43:17, sardinops-sagax, , 119.559997558594, stationary, lonny, o, 2317765 _findIndex(): Looking for epoch secs 1193080958 ... Found time 1193080955 after 7 iterations. >>> p = 1381: annotations(): 1381, 1193080958, 10/22/07 19:22:38, V3120-01, 04:19:03:09, sardinops-sagax, , 119.540000915527, stationary, lonny, o, 2317766 _findIndex(): Looking for epoch secs 1193081358 ... Found time 1193081359 after 5 iterations. >>> p = 1781: annotations(): 1781, 1193081358, 10/22/07 19:29:18, V3120-01, 04:25:43:07, sardinops-sagax, , 119.48999786377, stationary, lonny, o, 2317767 _findIndex(): Looking for epoch secs 1193081484 ... Found time 1193081485 after 7 iterations. >>> p = 1906: annotations(): 1906, 1193081484, 10/22/07 19:31:24, V3120-01, 04:27:49:07, water, , 119.480003356934, stationary, lonny, o, 2317768 _findIndex(): Looking for epoch secs 1193081587 ... Found time 1193081591 after 3 iterations. >>> p = 2010: annotations(): 2010, 1193081587, 10/22/07 19:33:07, V3120-01, 04:29:33:07, sardinops-sagax, , 119.48999786377, stationary, lonny, o, 2317769 _findIndex(): Looking for epoch secs 1193081637 ... Found time 1193081636 after 5 iterations. >>> p = 2055: annotations(): 2055, 1193081637, 10/22/07 19:33:57, V3120-01, 04:30:22:12, vibracorer, , 117.220001220703, ascend, lonny, o, 2317770 _findIndex(): Looking for epoch secs 1193081905 ... Found time 1193081902 after 7 iterations. >>> p = 2318: annotations(): 2318, 1193081905, 10/22/07 19:38:25, V3120-01, 04:34:49:22, lights, , 31.3799991607666, ascend, lonny, o, 2317771 _findIndex(): Looking for epoch secs 1193081945 ... Found time 1193081948 after 7 iterations. >>> p = 2364: annotations(): 2364, 1193081945, 10/22/07 19:39:05, V3120-01, 04:35:29:04, surface-water, , 19.0699996948242, ascend, lonny, o, 2317772 _findIndex(): Looking for epoch secs 1193082212 ... Found time 1193082214 after 6 iterations. >>> p = 2627: annotations(): 2627, 1193082212, 10/22/07 19:43:32, V3120-01, 04:39:57:12, back-deck, , 10.210000038147, ascend, lonny, o, 2317773 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... placeAnnotations(): Placing annotation 10: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.908 C", "S: 34.058", "O: 1.5 ml/l", "L: 71.1 %"] inline_name = vnta3120anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 116 db", "T: 8.907 C", "S: 34.058", "O: 1.54 ml/l", "L: 71.2 %"] placeAnnotations(): Placing annotation 4: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 112 db", "T: 8.986 C", "S: 34.051", "O: 1.55 ml/l", "L: 71.9 %"] placeAnnotations(): Placing annotation 6: mud Ancillary data = ["mud", "P: 118.8 db", "T: 8.882 C", "S: 34.063", "O: 1.49 ml/l", "L: 61.8 %"] placeAnnotations(): Placing annotation 8: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.9 C", "S: 34.061", "O: 1.5 ml/l", "L: 70.8 %"] placeAnnotations(): Placing annotation 10: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.908 C", "S: 34.058", "O: 1.5 ml/l", "L: 71.1 %"] placeAnnotations(): Placing annotation 12: water Ancillary data = ["water", "P: 118.6 db", "T: 8.871 C", "S: 34.066", "O: 1.47 ml/l", "L: 69.2 %"] placeAnnotations(): Placing annotation 14: vibracorer Ancillary data = ["vibracorer", "P: 118.6 db", "T: 8.877 C", "S: 34.066", "O: 1.48 ml/l", "L: 71.1 %"] placeAnnotations(): Placing annotation 16: surface-water Ancillary data = ["surface-water", "P: 32.9 db", "T: 9.841 C", "S: 33.936", "O: 2.21 ml/l", "L: 76.1 %"] placeAnnotations(): Placing annotation 18: Ancillary data = ["", "P: 8.7 db", "T: 13.039 C", "S: 33.551", "O: 5.31 ml/l", "L: 68.3 %"] inline_name = vnta3120anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: sediment Ancillary data = ["sediment", "P: 15.2 db", "T: 12.07 C", "S: 33.64", "O: 4.59 ml/l", "L: 75.4 %"] placeAnnotations(): Placing annotation 2: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 116 db", "T: 8.907 C", "S: 34.058", "O: 1.54 ml/l", "L: 71.2 %"] placeAnnotations(): Placing annotation 3: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.6 db", "T: 8.879 C", "S: 34.063", "O: 1.5 ml/l", "L: 67.7 %"] placeAnnotations(): Placing annotation 4: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 112 db", "T: 8.986 C", "S: 34.051", "O: 1.55 ml/l", "L: 71.9 %"] placeAnnotations(): Placing annotation 5: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.882 C", "S: 34.063", "O: 1.5 ml/l", "L: 66.4 %"] placeAnnotations(): Placing annotation 6: mud Ancillary data = ["mud", "P: 118.8 db", "T: 8.882 C", "S: 34.063", "O: 1.49 ml/l", "L: 61.8 %"] placeAnnotations(): Placing annotation 7: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.89 C", "S: 34.062", "O: 1.49 ml/l", "L: 69.3 %"] placeAnnotations(): Placing annotation 8: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.9 C", "S: 34.061", "O: 1.5 ml/l", "L: 70.8 %"] placeAnnotations(): Placing annotation 9: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.908 C", "S: 34.058", "O: 1.5 ml/l", "L: 71.1 %"] placeAnnotations()frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/295/accesses.txt at bin\geopdvc.pl line 554 : Placing annotation 10: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.8 db", "T: 8.908 C", "S: 34.058", "O: 1.5 ml/l", "L: 71.1 %"] placeAnnotations(): Placing annotation 11: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.7 db", "T: 8.883 C", "S: 34.066", "O: 1.49 ml/l", "L: 65.7 %"] placeAnnotations(): Placing annotation 12: water Ancillary data = ["water", "P: 118.6 db", "T: 8.871 C", "S: 34.066", "O: 1.47 ml/l", "L: 69.2 %"] placeAnnotations(): Placing annotation 13: sardinops-sagax Ancillary data = ["sardinops-sagax", "P: 118.6 db", "T: 8.866 C", "S: 34.069", "O: 1.47 ml/l", "L: 70.9 %"] placeAnnotations(): Placing annotation 14: vibracorer Ancillary data = ["vibracorer", "P: 118.6 db", "T: 8.877 C", "S: 34.066", "O: 1.48 ml/l", "L: 71.1 %"] placeAnnotations(): Placing annotation 15: lights Ancillary data = ["lights", "P: 115.8 db", "T: 8.887 C", "S: 34.068", "O: 1.49 ml/l", "L: 71.4 %"] placeAnnotations(): Placing annotation 16: surface-water Ancillary data = ["surface-water", "P: 32.9 db", "T: 9.841 C", "S: 33.936", "O: 2.21 ml/l", "L: 76.1 %"] placeAnnotations(): Placing annotation 17: back-deck Ancillary data = ["back-deck", "P: 14.8 db", "T: 11.249 C", "S: 33.715", "O: 3.46 ml/l", "L: 77.9 %"] placeAnnotations(): Placing annotation 18: Ancillary data = ["", "P: 8.7 db", "T: 13.039 C", "S: 33.551", "O: 5.31 ml/l", "L: 68.3 %"] inline_name = vnta3120anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/vnta3120... frameGrabs(): matched 04_09_15_19 in [IMG] 04_09_15_19.jpg 03-Dec-2007 21:09 49k iList = 04_09_15_19.jpg _findIndex(): Looking for epoch secs 1193080369 ... Found time 1193080367 after 6 iterations. >>> p = 799: frameGrabs(): index = 799 EXPD::frameGrabs(): 799: Time=1193080365, Depth=117.8, Lat= 36.802653, Lon=-121.802992, Pres=118.8, Temp=8.89, Sal=34.062, O2=1.49, Light=69.3 bin\geopdvc.pl: Calling placeImages with every 10 image... inline_name = vnta3120fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... inline_name = vnta3120fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... inline_name = vnta3120fg01.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/22/2007 6:59:30 PM' AND '10/22/2007 7:43:45 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2007/vnta/vnta3120.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3759,'/3Dreplay/3D.asp?dives=vnta3120','vnta3120','','','',3120 Executing sql: UPDATE Dive SET DiveLatMid = 36.8026, DiveLonMid = -121.8029, DiveDepthMid = -119.5 WHERE RovName = 'vnta' AND DiveNumber = 3120