Running bin\geopdvc.pl at Thu Nov 22 03:00:27 2007 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3084 bin\geopdvc.pl: Getting Expedition object for diveno = 3084 and rname = vnta set_expd(): rov = vnta, diveno = 3084 set_expd(): $self->{EndDDD} = 267 set_expd(): $self->{StartEsecs} = 1190664765 set_expd(): $self->{EndEsecs} = 1190668425 set_expd(): $self->{EndDtg} = 9/24/2007 8:53:45 PM _readLogr(): Reading videologr data from 2007267datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1190664765 & 1190668425 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 365 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1190664767 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1190668421 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1190664767 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1190668421 refineStartAndEndEsecs(): setting StartEsecs to 1190664765 refineStartAndEndEsecs(): setting EndEsecs to 1190664787 refineStartAndEndEsecs(): numMinBack = 21.6333333333333, numMinForward = 9.91666666666667 refineStartAndEndEsecs(): Refined StartEsecs = 1190664667, Refined EndEsecs = 1190667820 _readLogr(): Reading videologr data from 2007267datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1190664667 & 1190667820 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 313 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1190664677 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1190667811 bin\geopdvc.pl: expdid = 3749 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 267 (looping to 267) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007267vnta.txt esecs, east, north, lat, lon, head, pres 1190664908, 0, 0, 37.361385, -122.798942, 354.0, 111.60 1190665873, 0, 0, 37.361700, -122.800158, 28.4, 2.01 1190666430, 0, 0, 37.361448, -122.799455, 316.4, 111.54 1190666935, 0, 0, 37.361493, -122.799765, 297.9, 71.26 267: 2061 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007267vnta.txt rovNav(): Initial # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1190664667 rovNav(): Initial # seconds to fill at end of dive = 438 ending at EndEsecs =1190667820 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1190664677 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1190667811 rovNav(): numMinBack = 21.4666666666667, numMinForward = 9.76666666666667 rovNav(): Refined StartEsecs = 1190664667, Refined EndEsecs = 1190667820 rovNav(): Refined # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1190664667 rovNav(): Refined # seconds to fill at end of dive = 438 ending at EndEsecs =1190667820 rovNav(): num tList = 2061 rovNav(): num eList = 2061 rovNav(): Adding data to begining of dive from logr indices 0 .. 0 rovNav(): Adding data to end of dive from logr indices 271 .. 313 rovNav(): num in tList now = 2105 rovNav(): num in eList now = 2105 2105 in tList 2105 in {self->{rovT}} 2105 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1190666745 & 1190666610 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 = 267 (looping to 267) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007267vnta.txt esecs, east, north, lat, lon, head, pres 1190664908, 0, 0, 37.361385, -122.798942, 354.0, 111.60 1190665873, 0, 0, 37.361700, -122.800158, 28.4, 2.01 1190666430, 0, 0, 37.361448, -122.799455, 316.4, 111.54 1190666935, 0, 0, 37.361493, -122.799765, 297.9, 71.26 267: 2061 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007267vnta.txt 2061 in tList 2061 in {self->{rovT}} 2061 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1190666745 & 1190666610 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXX................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 37.36148800 hash{lon} = -122.79947200 latMin = 31.361488 latMax = 43.361488 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 31.361488 AND 43.361488 AND Longitude BETWEEN -128.799472 AND -116.799472 Dive lat = 37.36148800, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.79947200 & lat = 37.36148800 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3084rov_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/vnta3084lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 313 shipNav(): $#{$self->{shipLat}}[last] = 37.363578 Position subsampling set to 2 setROVcolorlines(): frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/267/accesses.txt at bin\geopdvc.pl line 2188 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 = 2106 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3084tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2007/vnta/vnta3084mergedCtdNav.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 '9/24/2007 8:32:45 PM' AND '9/24/2007 8:53:45 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '9/24/2007 8:32:45 PM' AND '9/24/2007 8:53:45 PM') _findIndex(): Looking for epoch secs 1190666701 ... Found time 1190666706 after 5 iterations. >>> p = 1512: annotations(): 1512, 1190666701, 09/24/07 20:45:01, V3084-01, 00:01:34:12, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3083/00_01_34_12.jpg, 110.629997253418, descend, jaha, o, 20021328 _findIndex(): Looking for epoch secs 1190666720 ... Found time 1190666722 after 6 iterations. >>> p = 1528: annotations(): 1528, 1190666720, 09/24/07 20:45:20, V3084-01, 00:01:53:27, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3083/00_01_53_27.jpg, 110.690002441406, descend, jaha, o, 20021329 _findIndex(): Looking for epoch secs 1190666727 ... Found time 1190666722 after 6 iterations. >>> p = 1528: annotations(): 1528, 1190666727, 09/24/07 20:45:27, V3084-01, 00:01:59:27, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3083/00_01_59_27.jpg, 110.849998474121, descend, jaha, o, 20021330 _findIndex(): Looking for epoch secs 1190666738 ... Found time 1190666739 after 1 iterations. >>> p = 1545: annotations(): 1545, 1190666738, 09/24/07 20:45:38, V3084-01, 00:02:11:26, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3083/00_02_11_26.jpg, 110.680000305176, descend, jaha, o, 20021331 _findIndex(): Looking for epoch secs 1190666744 ... Found time 1190666739 after 1 iterations. >>> p = 1545: annotations(): 1545, 1190666744, 09/24/07 20:45:44, V3084-01, 00:02:16:26, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3083/00_02_16_26.jpg, 110.879997253418, descend, jaha, o, 20021332 _findIndex(): Looking for epoch secs 1190666762 ... Found time 1190666763 after 7 iterations. >>> p = 1569: annotations(): 1569, 1190666762, 09/24/07 20:46:02, V3084-01, 00:02:35:26, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3083/00_02_35_26.jpg, 110.610000610352, descend, jaha, o, 20021333 _findIndex(): Looking for epoch secs 1190666768 ... Found time 1190666771 after 5 iterations. >>> p = 1577: annotations(): 1577, 1190666768, 09/24/07 20:46:08, V3084-01, 00:02:41:10, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3083/00_02_41_10.jpg, 110.029998779297, descend, jaha, o, 20021334 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... inline_name = vnta3084anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: physical-object Ancillary data = ["physical-object", "P: 109.6 db", "T: 9.612 C", "S: 33.971", "O: 1.92 ml/l", "L: 86.1 %"] placeAnnotations(): Placing annotation 4: physical-object Ancillary data = ["physical-object", "P: 109.6 db", "T: 9.612 C", "SframeGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/267/accesses.txt at bin\geopdvc.pl line 554 : 33.97", "O: 1.92 ml/l", "L: 86.1 %"] placeAnnotations(): Placing annotation 6: physical-object Ancillary data = ["physical-object", "P: 109.4 db", "T: 9.612 C", "S: 33.971", "O: 1.92 ml/l", "L: 86 %"] inline_name = vnta3084anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: physical-object Ancillary data = ["physical-object", "P: 109.6 db", "T: 9.611 C", "S: 33.971", "O: 1.92 ml/l", "L: 86.2 %"] placeAnnotations(): Placing annotation 2: physical-object Ancillary data = ["physical-object", "P: 109.6 db", "T: 9.612 C", "S: 33.971", "O: 1.92 ml/l", "L: 86.1 %"] placeAnnotations(): Placing annotation 3: physical-object Ancillary data = ["physical-object", "P: 109.6 db", "T: 9.612 C", "S: 33.971", "O: 1.92 ml/l", "L: 86.1 %"] placeAnnotations(): Placing annotation 4: physical-object Ancillary data = ["physical-object", "P: 109.6 db", "T: 9.612 C", "S: 33.97", "O: 1.92 ml/l", "L: 86.1 %"] placeAnnotations(): Placing annotation 5: physical-object Ancillary data = ["physical-object", "P: 109.6 db", "T: 9.612 C", "S: 33.97", "O: 1.92 ml/l", "L: 86.1 %"] placeAnnotations(): Placing annotation 6: physical-object Ancillary data = ["physical-object", "P: 109.4 db", "T: 9.612 C", "S: 33.971", "O: 1.92 ml/l", "L: 86 %"] placeAnnotations(): Placing annotation 7: Ancillary data = ["", "P: 108.3 db", "T: 9.612 C", "S: 33.971", "O: 1.92 ml/l", "L: 86.1 %"] inline_name = vnta3084anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/vnta3084... frameGrabs(): matched 00_01_34_12 in [IMG] 00_01_34_12.jpg 03-Oct-2007 15:32 66k frameGrabs(): matched 00_01_53_27 in [IMG] 00_01_53_27.jpg 03-Oct-2007 15:34 58k frameGrabs(): matched 00_01_59_27 in [IMG] 00_01_59_27.jpg 03-Oct-2007 15:35 58k frameGrabs(): matched 00_02_11_26 in [IMG] 00_02_11_26.jpg 03-Oct-2007 15:36 64k frameGrabs(): matched 00_02_16_26 in [IMG] 00_02_16_26.jpg 03-Oct-2007 15:37 66k frameGrabs(): matched 00_02_35_26 in [IMG] 00_02_35_26.jpg 03-Oct-2007 15:38 59k frameGrabs(): matched 00_02_41_10 in [IMG] 00_02_41_10.jpg 03-Oct-2007 15:39 55k frameGrabs(): matched 00_01_34_12 in [IMG] iptc_00_01_34_12.jpg 03-Oct-2007 15:32 67k frameGrabs(): matched 00_01_53_27 in [IMG] iptc_00_01_53_27.jpg 03-Oct-2007 15:34 59k frameGrabs(): matched 00_01_59_27 in [IMG] iptc_00_01_59_27.jpg 03-Oct-2007 15:35 59k frameGrabs(): matched 00_02_11_26 in [IMG] iptc_00_02_11_26.jpg 03-Oct-2007 15:36 65k frameGrabs(): matched 00_02_16_26 in [IMG] iptc_00_02_16_26.jpg 03-Oct-2007 15:37 67k frameGrabs(): matched 00_02_35_26 in [IMG] iptc_00_02_35_26.jpg 03-Oct-2007 15:38 60k frameGrabs(): matched 00_02_41_10 in [IMG] iptc_00_02_41_10.jpg 03-Oct-2007 15:39 56k iList = 00_01_34_12.jpg 00_01_53_27.jpg 00_01_59_27.jpg 00_02_11_26.jpg 00_02_16_26.jpg 00_02_35_26.jpg 00_02_41_10.jpg 00_01_34_12.jpg 00_01_53_27.jpg 00_01_59_27.jpg 00_02_11_26.jpg 00_02_16_26.jpg 00_02_35_26.jpg 00_02_41_10.jpg _findIndex(): Looking for epoch secs 1190666701 ... Found time 1190666706 after 5 iterations. >>> p = 1512: frameGrabs(): index = 1512 EXPD::frameGrabs(): 1512: Time=1190666700, Depth=108.7, Lat= 37.361437, Lon=-122.799413, Pres=109.6, Temp=9.611, Sal=33.971, O2=1.92, Light=86.2 _findIndex(): Looking for epoch secs 1190666701 ... Found time 1190666706 after 5 iterations. >>> p = 1512: frameGrabs(): index = 1512 EXPD::frameGrabs(): 1512: Time=1190666700, Depth=108.7, Lat= 37.361437, Lon=-122.799413, Pres=109.6, Temp=9.611, Sal=33.971, O2=1.92, Light=86.2 _findIndex(): Looking for epoch secs 1190666720 ... Found time 1190666722 after 6 iterations. >>> p = 1528: frameGrabs(): index = 1528 EXPD::frameGrabs(): 1528: Time=1190666715, Depth=108.8, Lat= 37.361543, Lon=-122.799400, Pres=109.6, Temp=9.612, Sal=33.971, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666720 ... Found time 1190666722 after 6 iterations. >>> p = 1528: frameGrabs(): index = 1528 EXPD::frameGrabs(): 1528: Time=1190666715, Depth=108.8, Lat= 37.361543, Lon=-122.799400, Pres=109.6, Temp=9.612, Sal=33.971, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666727 ... Found time 1190666722 after 6 iterations. >>> p = 1528: frameGrabs(): index = 1528 EXPD::frameGrabs(): 1528: Time=1190666715, Depth=108.8, Lat= 37.361543, Lon=-122.799400, Pres=109.6, Temp=9.612, Sal=33.971, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666727 ... Found time 1190666722 after 6 iterations. >>> p = 1528: frameGrabs(): index = 1528 EXPD::frameGrabs(): 1528: Time=1190666715, Depth=108.8, Lat= 37.361543, Lon=-122.799400, Pres=109.6, Temp=9.612, Sal=33.971, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666738 ... Found time 1190666739 after 1 iterations. >>> p = 1545: frameGrabs(): index = 1545 EXPD::frameGrabs(): 1545: Time=1190666745, Depth=108.8, Lat= 37.361478, Lon=-122.799407, Pres=109.6, Temp=9.612, Sal=33.97, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666738 ... Found time 1190666739 after 1 iterations. >>> p = 1545: frameGrabs(): index = 1545 EXPD::frameGrabs(): 1545: Time=1190666745, Depth=108.8, Lat= 37.361478, Lon=-122.799407, Pres=109.6, Temp=9.612, Sal=33.97, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666744 ... Found time 1190666739 after 1 iterations. >>> p = 1545: frameGrabs(): index = 1545 EXPD::frameGrabs(): 1545: Time=1190666745, Depth=108.8, Lat= 37.361478, Lon=-122.799407, Pres=109.6, Temp=9.612, Sal=33.97, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666744 ... Found time 1190666739 after 1 iterations. >>> p = 1545: frameGrabs(): index = 1545 EXPD::frameGrabs(): 1545: Time=1190666745, Depth=108.8, Lat= 37.361478, Lon=-122.799407, Pres=109.6, Temp=9.612, Sal=33.97, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666762 ... Found time 1190666763 after 7 iterations. >>> p = 1569: frameGrabs(): index = 1569 EXPD::frameGrabs(): 1569: Time=1190666760, Depth=108.5, Lat= 37.361543, Lon=-122.799365, Pres=109.4, Temp=9.612, Sal=33.971, O2=1.92, Light=86 _findIndex(): Looking for epoch secs 1190666762 ... Found time 1190666763 after 7 iterations. >>> p = 1569: frameGrabs(): index = 1569 EXPD::frameGrabs(): 1569: Time=1190666760, Depth=108.5, Lat= 37.361543, Lon=-122.799365, Pres=109.4, Temp=9.612, Sal=33.971, O2=1.92, Light=86 _findIndex(): Looking for epoch secs 1190666768 ... Found time 1190666771 after 5 iterations. >>> p = 1577: frameGrabs(): index = 1577 EXPD::frameGrabs(): 1577: Time=1190666775, Depth=107.5, Lat= 37.361558, Lon=-122.799468, Pres=108.3, Temp=9.612, Sal=33.971, O2=1.92, Light=86.1 _findIndex(): Looking for epoch secs 1190666768 ... Found time 1190666771 after 5 iterations. >>> p = 1577: frameGrabs(): index = 1577 EXPD::frameGrabs(): 1577: Time=1190666775, Depth=107.5, Lat= 37.361558, Lon=-122.799468, Pres=108.3, Temp=9.612, Sal=33.971, O2=1.92, Light=86.1 bin\geopdvc.pl: Calling placeImages with every 10 image... placeImages(): Placing image 10 00_02_35_26.jpg 1190666762 fw= 0.0 cm Xinline_name = vnta3084fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... placeImages(): Placing image 2 00_01_53_27.jpg 1190666720 fw= 0.0 cm XplaceImages(): Placing image 4 00_01_59_27.jpg 1190666727 fw= 0.0 cm XplaceImages(): Placing image 6 00_02_11_26.jpg 1190666738 fw= 0.0 cm .placeImages(): Placing image 8 00_02_16_26.jpg 1190666744 fw= 0.0 cm .placeImages(): Placing image 10 00_02_35_26.jpg 1190666762 fw= 0.0 cm .placeImages(): Placing image 12 00_02_41_10.jpg 1190666768 fw= 0.0 cm .inline_name = vnta3084fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... placeImages(): Placing image 1 00_01_34_12.jpg 1190666701 fw= 0.0 cm .placeImages(): Placing image 2 00_01_53_27.jpg 1190666720 fw= 0.0 cm .placeImages(): Placing image 3 00_01_53_27.jpg 1190666720 fw= 0.0 cm .placeImages(): Placing image 4 00_01_59_27.jpg 1190666727 fw= 0.0 cm .placeImages(): Placing image 5 00_01_59_27.jpg 1190666727 fw= 0.0 cm .placeImages(): Placing image 6 00_02_11_26.jpg 1190666738 fw= 0.0 cm .placeImages(): Placing image 7 00_02_11_26.jpg 1190666738 fw= 0.0 cm .placeImages(): Placing image 8 00_02_16_26.jpg 1190666744 fw= 0.0 cm .placeImages(): Placing image 9 00_02_16_26.jpg 1190666744 fw= 0.0 cm .placeImages(): Placing image 10 00_02_35_26.jpg 1190666762 fw= 0.0 cm .placeImages(): Placing image 11 00_02_35_26.jpg 1190666762 fw= 0.0 cm .placeImages(): Placing image 12 00_02_41_10.jpg 1190666768 fw= 0.0 cm .placeImages(): Placing image 13 00_02_41_10.jpg 1190666768 fw= 0.0 cm .inline_name = vnta3084fg01.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 '9/24/2007 8:32:45 PM' AND '9/24/2007 8:53:45 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2007/vnta/vnta3084.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3749,'/3Dreplay/3D.asp?dives=vnta3084','vnta3084','','','',3084 Executing sql: UPDATE Dive SET DiveLatMid = 37.3615, DiveLonMid = -122.7995, DiveDepthMid = -96.9 WHERE RovName = 'vnta' AND DiveNumber = 3084