Running bin\geopdvc.pl at Fri Dec 14 03:00:56 2007 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3104 bin\geopdvc.pl: Getting Expedition object for diveno = 3104 and rname = vnta set_expd(): rov = vnta, diveno = 3104 set_expd(): $self->{EndDDD} = 289 set_expd(): $self->{StartEsecs} = 1192557945 set_expd(): $self->{EndEsecs} = 1192564200 set_expd(): $self->{EndDtg} = 10/16/2007 7:30:00 PM _readLogr(): Reading videologr data from 2007289datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1192557945 & 1192564200 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 624 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1192557947 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1192564193 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1192557947 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1192564193 refineStartAndEndEsecs(): setting StartEsecs to 1192557945 refineStartAndEndEsecs(): setting EndEsecs to 1192557977 refineStartAndEndEsecs(): numMinBack = 21.4666666666667, numMinForward = 21.7166666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1192557857, Refined EndEsecs = 1192564303 _readLogr(): Reading videologr data from 2007289datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1192557857 & 1192564303 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 643 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1192557867 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1192564303 bin\geopdvc.pl: expdid = 3759 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 289 (looping to 289) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007289vnta.txt esecs, east, north, lat, lon, head, pres 1192558047, 0, 0, 36.795895, -121.843423, 133.9, 4.06 1192559632, 0, 0, 36.793657, -121.844305, 273.5, 216.59 1192560137, 0, 0, 36.794437, -121.844878, 71.0, 285.37 1192560642, 0, 0, 36.794440, -121.844958, 18.7, 283.33 1192561147, 0, 0, 36.794478, -121.844945, 53.8, 283.43 1192561652, 0, 0, 36.794507, -121.844943, 73.2, 283.46 1192562157, 0, 0, 36.794738, -121.845033, 65.9, 265.41 1192562662, 0, 0, 36.795487, -121.844475, 91.7, 71.26 289: 4153 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007289vnta.txt rovNav(): Initial # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1192557857 rovNav(): Initial # seconds to fill at end of dive = 0 ending at EndEsecs =1192564303 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1192557867 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1192564303 rovNav(): numMinBack = 21.3, numMinForward = 21.7166666666667 rovNav(): Refined StartEsecs = 1192557857, Refined EndEsecs = 1192564303 rovNav(): Refined # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1192557857 rovNav(): Refined # seconds to fill at end of dive = 0 ending at EndEsecs =1192564303 rovNav(): num tList = 4153 rovNav(): num eList = 4153 rovNav(): Adding data to begining of dive from logr indices 0 .. 0 rovNav(): Adding data to end of dive from logr indices 643 .. 643 rovNav(): num in tList now = 4155 rovNav(): num in eList now = 4155 4155 in tList 4155 in {self->{rovT}} 4155 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1192560225 & 1192561515 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXX 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 = 289 (looping to 289) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007289vnta.txt esecs, east, north, lat, lon, head, pres 1192558047, 0, 0, 36.795895, -121.843423, 133.9, 4.06 1192559632, 0, 0, 36.793657, -121.844305, 273.5, 216.59 1192560137, 0, 0, 36.794437, -121.844878, 71.0, 285.37 1192560642, 0, 0, 36.794440, -121.844958, 18.7, 283.33 1192561147, 0, 0, 36.794478, -121.844945, 53.8, 283.43 1192561652, 0, 0, 36.794507, -121.844943, 73.2, 283.46 1192562157, 0, 0, 36.794738, -121.845033, 65.9, 265.41 1192562662, 0, 0, 36.795487, -121.844475, 91.7, 71.26 289: 4153 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007289vnta.txt 4153 in tList 4153 in {self->{rovT}} 4153 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1192560225 & 1192561515 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXX............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/289/accesses.txt at bin\geopdvc.pl line 2188 .............................................................................................................................XXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79451000 hash{lon} = -121.84487300 latMin = 30.79451 latMax = 42.79451 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.79451 AND 42.79451 AND Longitude BETWEEN -127.844873 AND -115.844873 Dive lat = 36.79451000, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.84487300 & lat = 36.79451000 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3104rov_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/vnta3104lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 643 shipNav(): $#{$self->{shipLat}}[last] = 36.793975 Position subsampling set to 4 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 = 4156 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3104tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2007/vnta/vnta3104mergedCtdNav.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/16/2007 6:25:45 PM' AND '10/16/2007 7:30:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/16/2007 6:25:45 PM' AND '10/16/2007 7:30:00 PM') _findIndex(): Looking for epoch secs 1192559859 ... Found time 1192559854 after 4 iterations. >>> p = 908: annotations(): 908, 1192559859, 10/16/07 18:37:39, V3104-01, 02:13:19:00, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3104/02_13_19_00.jpg, 275.630004882813, descend, lonny, o, 20021777 _findIndex(): Looking for epoch secs 1192559864 ... Found time 1192559862 after 8 iterations. >>> p = 916: annotations(): 916, 1192559864, 10/16/07 18:37:44, V3104-01, 02:13:25:16, sediment, , 275.760009765625, descend, lonny, o, 2315090 _findIndex(): Looking for epoch secs 1192559872 ... Found time 1192559870 after 7 iterations. >>> p = 924: annotations(): 924, 1192559872, 10/16/07 18:37:52, V3104-01, 02:13:33:03, aurelia, , 275.679992675781, descend, lonny, o, 2315091 _findIndex(): Looking for epoch secs 1192559874 ... Found time 1192559870 after 7 iterations. >>> p = 924: annotations(): 924, 1192559874, 10/16/07 18:37:54, V3104-01, 02:13:36:10, scyliorhinidae, , 275.529998779297, descend, lonny, o, 2315094 _findIndex(): Looking for epoch secs 1192559908 ... Found time 1192559903 after 7 iterations. >>> p = 956: annotations(): 956, 1192559908, 10/16/07 18:38:28, V3104-01, 02:14:10:14, aurelia, , 274.709991455078, cruise, lonny, o, 2315101 _findIndex(): Looking for epoch secs 1192559928 ... Found time 1192559928 after 8 iterations. >>> p = 981: annotations(): 981, 1192559928, 10/16/07 18:38:48, V3104-01, 02:14:30:17, water, , 275.010009765625, cruise, lonny, o, 2315102 _findIndex(): Looking for epoch secs 1192560248 ... Found time 1192560247 after 3 iterations. >>> p = 1297: annotations(): 1297, 1192560248, 10/16/07 18:44:08, V3104-01, 02:19:47:18, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3104/02_19_47_18.jpg, 284.75, stationary, lonny, o, 20021779 _findIndex(): Looking for epoch secs 1192560512 ... Found time 1192560510 after 2 iterations. >>> p = 1557: annotations(): 1557, 1192560512, 10/16/07 18:48:32, V3104-01, 02:24:13:13, enteroctopus, , 281, stationary, lonny, o, 2315137 _findIndex(): Looking for epoch secs 1192560644 ... Found time 1192560640 after 4 iterations. >>> p = 1686: annotations(): 1686, 1192560644, 10/16/07 18:50:44, V3104-01, 02:26:25:04, mud, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3104/02_26_25_04.jpg, 281.070007324219, stationary, lonny, o, 2315147 _findIndex(): Looking for epoch secs 1192562547 ... Found time 1192562549 after 8 iterations. >>> p = 3576: annotations(): 3576, 1192562547, 10/16/07 19:22:27, V3104-01, 02:58:04:25, aurelia, , 118.349998474121, ascend, lonny, o, 2315180 _findIndex(): Looking for epoch secs 1192562569 ... Found time 1192562573 after 6 iterations. >>> p = 3600: annotations(): 3600, 1192562569, 10/16/07 19:22:49, V3104-01, 02:58:27:17, aurelia, , 108.5, ascend, lonny, o, 2315182 _findIndex(): Looking for epoch secs 1192562694 ... Found time 1192562697 after 8 iterations. >>> p = 3722: annotations(): 3722, 1192562694, 10/16/07 19:24:54, V3104-01, 03:00:31:19, aurelia, , 60.0400009155273, ascend, lonny, o, 2315188 _findIndex(): Looking for epoch secs 1192562955 ... Found time 1192562951 after 7 iterations. >>> p = 3974: annotations(): 3974, 1192562955, 10/16/07 19:29:15, V3104-01, 03:04:53:29, surface-water, , 30.8400001525879, ascend, lonny, o, 2315206 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... placeAnnotations(): Placing annotation 10: aurelia Ancillary data = ["aurelia", "P: 115.1 db", "T: 10.404 C", "S: 33.872", "O: 2.26 ml/l", "L: 78.8 %"] inline_name = vnta3104anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: aurelia Ancillary data = ["aurelia", "P: 276.6 db", "T: 8.516 C", "S: 34.103", "O: 1.21 ml/l", "L: 80 %"] placeAnnotations(): Placing annotation 4: aurelia Ancillary data = ["aurelia", "P: 276.6 db", "T: 8.516 C", "S: 34.103", "O: 1.21 ml/l", "L: 80 %"] placeAnnotations(): Placing annotation 6: vibracorer Ancillary data = ["vibracorer", "P: 275.5 db", "T: 8.541 C", "S: 34.099", "O: 1.21 ml/l", "L: 70.2 %"] placeAnnotations(): Placing annotation 8: mud Ancillary data = ["mud", "P: 281.5 db", "T: 8.548 C", "S: 34.1", "O: 1.2 ml/l", "L: 79 %"] placeAnnotations(): Placing annotation 10: aurelia Ancillary data = ["aurelia", "P: 115.1 db", "T: 10.404 C", "S: 33.872", "O: 2.26 ml/l", "L: 78.8 %"] placeAnnotations(): Placing annotation 12: surface-water Ancillary data = ["surface-water", "P: 57.2 db", "T: 11.469 C", "S: 33.689", "O: 3.53 ml/l", "L: 83.5 %"] inline_name = vnta3104anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: sediment Ancillary data = ["sediment", "P: 276.1 db", "T: 8.5 C", "S: 34.104", "O: 1.21 ml/l", "L: 79.7 %"] placeAnnotations(): Placing annotation 2: aurelia Ancillary data = ["aurelia", "P: 276.6 db", "T: 8.516 C", "S: 34.103", "O: 1.21 ml/l", "L: 80 %"] placeAnnotations(): Placing annotation 3: scyliorhinidae Ancillary data = ["scyliorhinidae", "P: 276.6 db", "T: 8.516 C", "S: 34.103", "O: 1.21 ml/l", "L: 80 %"] placeAnnotations(): Placing annotation 4: aurelia Ancillary dataframeGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/289/accesses.txt at bin\geopdvc.pl line 554 = ["aurelia", "P: 276.6 db", "T: 8.516 C", "S: 34.103", "O: 1.21 ml/l", "L: 80 %"] placeAnnotations(): Placing annotation 5: water Ancillary data = ["water", "P: 275.1 db", "T: 8.545 C", "S: 34.099", "O: 1.22 ml/l", "L: 74.8 %"] placeAnnotations(): Placing annotation 6: vibracorer Ancillary data = ["vibracorer", "P: 275.5 db", "T: 8.541 C", "S: 34.099", "O: 1.21 ml/l", "L: 70.2 %"] placeAnnotations(): Placing annotation 7: enteroctopus Ancillary data = ["enteroctopus", "P: 285.9 db", "T: 8.453 C", "S: 34.101", "O: 1.16 ml/l", "L: 74.6 %"] placeAnnotations(): Placing annotation 8: mud Ancillary data = ["mud", "P: 281.5 db", "T: 8.548 C", "S: 34.1", "O: 1.2 ml/l", "L: 79 %"] placeAnnotations(): Placing annotation 9: aurelia Ancillary data = ["aurelia", "P: 281.5 db", "T: 8.543 C", "S: 34.101", "O: 1.19 ml/l", "L: 77.3 %"] placeAnnotations(): Placing annotation 10: aurelia Ancillary data = ["aurelia", "P: 115.1 db", "T: 10.404 C", "S: 33.872", "O: 2.26 ml/l", "L: 78.8 %"] placeAnnotations(): Placing annotation 11: aurelia Ancillary data = ["aurelia", "P: 101.9 db", "T: 10.508 C", "S: 33.859", "O: 2.38 ml/l", "L: 78.6 %"] placeAnnotations(): Placing annotation 12: surface-water Ancillary data = ["surface-water", "P: 57.2 db", "T: 11.469 C", "S: 33.689", "O: 3.53 ml/l", "L: 83.5 %"] placeAnnotations(): Placing annotation 13: Ancillary data = ["", "P: 28.2 db", "T: 12.125 C", "S: 33.647", "O: 3.88 ml/l", "L: 82.4 %"] inline_name = vnta3104anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/vnta3104... frameGrabs(): matched 02_13_19_00 in [IMG] 02_13_19_00.jpg 20-Nov-2007 21:07 73k frameGrabs(): matched 02_19_47_18 in [IMG] 02_19_47_18.jpg 20-Nov-2007 21:07 55k iList = 02_13_19_00.jpg 02_19_47_18.jpg _findIndex(): Looking for epoch secs 1192559859 ... Found time 1192559854 after 4 iterations. >>> p = 908: frameGrabs(): index = 908 EXPD::frameGrabs(): 908: Time=1192559850, Depth=273.9, Lat= 36.794400, Lon=-121.844508, Pres=276.1, Temp=8.5, Sal=34.104, O2=1.21, Light=79.7 _findIndex(): Looking for epoch secs 1192560248 ... Found time 1192560247 after 3 iterations. >>> p = 1297: frameGrabs(): index = 1297 EXPD::frameGrabs(): 1297: Time=1192560240, Depth=283.6, Lat= 36.794472, Lon=-121.844992, Pres=285.9, Temp=8.453, Sal=34.101, O2=1.16, Light=74.6 bin\geopdvc.pl: Calling placeImages with every 10 image... inline_name = vnta3104fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... inline_name = vnta3104fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... placeImages(): Placing image 1 02_19_47_18.jpg 1192560248 fw= 0.0 cm Xinline_name = vnta3104fg01.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/16/2007 6:25:45 PM' AND '10/16/2007 7:30:00 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2007/vnta/vnta3104.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3759,'/3Dreplay/3D.asp?dives=vnta3104','vnta3104','','','',3104 Executing sql: UPDATE Dive SET DiveLatMid = 36.7945, DiveLonMid = -121.8449, DiveDepthMid = -276.5 WHERE RovName = 'vnta' AND DiveNumber = 3104