Running .\bin\geopdvc.pl at Fri Feb 17 21:36:13 2006 on host
Command line:
.\bin\geopdvc.pl -rov vnta -dive 1850
.\bin\geopdvc.pl: Getting Expedition object for diveno = 1850 and rname = vnta
set_expd(): rov = vnta, diveno = 1850
set_expd(): $self->{EndDDD} = 294
set_expd(): $self->{EndDtg} = 10/20/2000 8:11:30 PM
_readLogr(): Reading videologr data from 2000294datavislogr.dat.gz.
_readLogr(): Expedition start & stop times are 972063705 & 972063705
_readLogr(): #LOGHOST_SYSTEM_UTC = 897
_readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 972063707
_readLogr(): $LOGHOST_SYSTEM_UTC[end] = 972072688
.\bin\geopdvc.pl: expdid = 2059
.\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 = 294 (looping to 294)
rovNav(): Opening ROV nav data from \\tornado\TempNav\2000\vnta\nav2000294vnta.txt
esecs, east, north, lat, lon, head, pres
972064709, 586154, 4068775, 36.760833, -122.034740, 273.8, 479.06
972069716, 586616, 4068208, 36.755683, -122.029630, 160.7, 898.41
294: 897 in tList
897 in tList
897 in {self->{rovT}}
897 in {self->{rovH}}
rovCTDO(): ROV CTDO start & stop times are 972070875 & 972067005
rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.):
.............X..................XX.............................................................................................................XX............................................................................................................................................XX......................................................................................................................................................................................................................................................................................................X..................................................X........................................................................................................................................................................................................................................................................X
.\bin\geopdvc.pl: -------------------------------------------------------------------------------
hash{lat} = 36.75643400
hash{lon} = -122.02959000
latMin = 30.756434
latMax = 42.756434
Executing sql:
SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.756434 AND 42.756434 AND Longitude BETWEEN -128.02959 AND -116.02959
Dive lat = 36.75643400, area = cencal
.\bin\geopdvc.pl: Found area = cencal in GeoOrigin
For midpoint lon = -122.02959000 & lat = 36.75643400
Using olon = -122 & olat = 36
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 = geo2000/vnta/vnta1850lookup.wrl
.\bin\geopdvc.pl: Getting ship nav...
shipNav(): $#{$self->{shipLat}} = 897
shipNav(): $#{$self->{shipLat}}[last] = 36.755743
.\bin\geopdvc.pl: Calling makeROVorig...
inline_name = vnta1850rov_orig.wrl
Using mbnavedit edited Navigation.
rovnavCTDO(): calcUTM = 0
rovNav(): 1, calcUTM = 0
rovNav(): calcUTM = 0
rovNav(): DDD = 294 (looping to 294)
rovNav(): Opening ROV nav data from \\tornado\TempNav\2000\vnta\nav2000294vntaedited.txt
esecs, east, north, lat, lon, head, pres
972064709, 0, 0, 36.761324, -122.034638, 273.8, 479.06
972069716, 0, 0, 36.755806, -122.029562, 160.7, 898.41
294: 897 in tList
897 in tList
897 in {self->{rovT}}
897 in {self->{rovH}}
rovCTDO(): ROV CTDO start & stop times are 972070875 & 972067005
rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX........................................................................................XX............................................................................................................................................XX......................................................................................................................................................................................................................................................................................................X..................................................X........................................................................................................................................................................................................................................................................X
Position subsampling set to 1
setROVcolorlines(): Assigning color line for Light...
varColors = LightColors
index0 = 0.4867 0.4093 0.0000
setROVcolorlines(): Assigning color line for O2...
varColors = O2Colors
index0 = 0 0 1
setROVcolorlines(): Assigning color line for Sal...
varColors = SalColors
index0 = 1.0000 0.8400 0.0000
setROVcolorlines(): Assigning color line for Temp...
varColors = TempColors
index0 = 0.5672 0.4328 0.0000
makeTracks(): n = 898
*** Warning: Position time is 5972 seconds away from search time. ***
*** search time of 972057736 precedes start of ROV nav: 972063708 ***
EXPD::frameGrabs(): 0: Time=972072525, Depth=18.6, Lat= 36.760979, Lon=-122.033582, Pres=18.7, Temp=12.836, Sal=33.58, O2=5.46, Light=73.4
*** Warning: Position time is 5943 seconds away from search time. ***
*** search time of 972057765 precedes start of ROV nav: 972063708 ***
EXPD::frameGrabs(): 0: Time=972072525, Depth=18.6, Lat= 36.760979, Lon=-122.033582, Pres=18.7, Temp=12.836, Sal=33.58, O2=5.46, Light=73.4
*** Warning: Position time is 5792 seconds away from search time. ***
*** search time of 972057916 precedes start of ROV nav: 972063708 ***
EXPD::frameGrabs(): 0: Time=972072525, Depth=18.6, Lat= 36.760979, Lon=-122.033582, Pres=18.7, Temp=12.836, Sal=33.58, O2=5.46, Light=73.4
*** Warning: Position time is 5779 seconds away from search time. ***
*** search time of 972057929 precedes start of ROV nav: 972063708 ***
EXPD::frameGrabs(): 0: Time=972072525, Depth=18.6, Lat= 36.760979, Lon=-122.033582, Pres=18.7, Temp=12.836, Sal=33.58, O2=5.46, Light=73.4
*** Warning: Position time is 5772 seconds away from search time. ***
*** search time of 972057936 precedes start of ROV nav: 972063708 ***
EXPD::frameGrabs(): 0: Time=972072525, Depth=18.6, Lat= 36.760979, Lon=-122.033582, Pres=18.7, Temp=12.836, Sal=33.58, O2=5.46, Light=73.4
*** Warning: Position time is 5763 seconds away from search time. ***
*** search time of 972057945 precedes start of ROV nav: 972063708 ***
EXPD::frameGrabs(): 0: Time=972072525, Depth=18.6, Lat= 36.760979, Lon=-122.033582, Pres=18.7, Temp=12.836, Sal=33.58, O2=5.46, Light=73.4
*** Warning: Position time is 5648 seconds away from search time. ***
*** search time of 972058060 precedes start of ROV nav: 972063708 ***
EXPD::frameGrabs(): 0: Time=972072525, Depth=18.6, Lat= 36.760979, Lon=-122.033582, Pres=18.7, Temp=12.836, Sal=33.58, O2=5.46, Light=73.4
EXPD::frameGrabs(): 477: Time=972068490, Depth=1165.8, Lat= 36.755596, Lon=-122.029639, Pres=1177.8, Temp=3.605, Sal=34.571, O2=0.56, Light=44.6
EXPD::frameGrabs(): 481: Time=972068520, Depth=1165.9, Lat= 36.755650, Lon=-122.029288, Pres=1177.9, Temp=3.604, Sal=34.573, O2=0.56, Light=44.4
EXPD::frameGrabs(): 484: Time=972068550, Depth=1165.9, Lat= 36.755655, Lon=-122.029180, Pres=1177.9, Temp=3.6, Sal=34.573, O2=0.55, Light=45.5
EXPD::frameGrabs(): 496: Time=972068670, Depth=1165.5, Lat= 36.755612, Lon=-122.029463, Pres=1177.5, Temp=3.646, Sal=34.558, O2=0.54, Light=50.4
EXPD::frameGrabs(): 526: Time=972068970, Depth=1165.9, Lat= 36.755788, Lon=-122.028869, Pres=1177.9, Temp=3.62, Sal=34.569, O2=0.55, Light=45.9
EXPD::frameGrabs(): 566: Time=972069375, Depth=1124.6, Lat= 36.755631, Lon=-122.028739, Pres=1136.1, Temp=4.056, Sal=34.536, O2=0.41, Light=63.4
*** Warning: Position time is -4649 seconds away from search time. ***
*** search time of 972077328 exceeds end of ROV nav: 972072689 ***
EXPD::frameGrabs(): 896: Time=972072675, Depth=12.2, Lat= 36.756276, Lon=-122.027659, Pres=12.3, Temp=13.015, Sal=33.58, O2=5.9, Light=71.1
*** Warning: Position time is -4838 seconds away from search time. ***
*** search time of 972077517 exceeds end of ROV nav: 972072689 ***
EXPD::frameGrabs(): 896: Time=972072675, Depth=12.2, Lat= 36.756276, Lon=-122.027659, Pres=12.3, Temp=13.015, Sal=33.58, O2=5.9, Light=71.1
0, 12, 34, 56, 78, 910, 1112, 1314, 1516, 1718, 1920, 2122, 2324, 2526, 2728, 29
makeTracks(): Writing tracks file...
makeTracks(): INFO $sname =
inline_name = vnta1850tracks.wrl
writeCtdPosFile(): Writing merged CTD Nav data to geo2000/vnta/vnta1850mergedCtdNav.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,
FormatCode, ObservationID_FK AS ObservationID
FROM dbo.Annotations
WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '10/20/2000 5:41:45 PM' AND '10/20/2000 8:11:30 PM') OR
(RovName = 'Ventana') AND (RecordedDate BETWEEN '10/20/2000 5:41:45 PM' AND '10/20/2000 8:11:30 PM')
annotations(): 306, 972066769, 10/20/00 18:32:49, V1849-01, 00:43:04:05, benthos, , 1178.69995117188, cruise, fije, o, 826610
annotations(): 466, 972068374, 10/20/00 18:59:34, V1849-02, 01:09:30:09, benthos, , 1163.59997558594, cruise, fije, o, 826626
annotations(): 476, 972068471, 10/20/00 19:01:11, V1849-02, 01:11:06:19, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:11:06:19.jpg, 1165.80004882813, cruise, fije, o, 826612
annotations(): 471, 972068427, 10/20/00 19:00:27, V1849-02, 01:10:22:20, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:10:22:20.jpg, 1165.80004882813, cruise, fije, o, 826611
annotations(): 477, 972068483, 10/20/00 19:01:23, V1849-02, 01:11:18:19, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:11:18:19.jpg, 1165.80004882813, cruise, fije, o, 826613
annotations(): 497, 972068680, 10/20/00 19:04:40, V1849-02, 01:14:34:28, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:14:34:28.jpg, 1165.5, stationary, fije, o, 826616
annotations(): 566, 972069377, 10/20/00 19:16:17, V1849-02, 01:26:12:07, manipulator, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:26:12:07.jpg, 1124.59997558594, ascend, fije, o, 826619
annotations(): 481, 972068523, 10/20/00 19:02:03, V1849-02, 01:11:59:02, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:11:59:02.jpg, 1165.90002441406, stationary, fije, o, 826614
annotations(): 484, 972068551, 10/20/00 19:02:31, V1849-02, 01:12:27:16, mud, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:12:27:16.jpg, 1165.90002441406, stationary, fije, o, 826615
annotations(): 526, 972068978, 10/20/00 19:09:38, V1849-02, 01:19:33:19, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:19:33:19.jpg, 1165.90002441406, stationary, fije, o, 826617
annotations(): 548, 972069196, 10/20/00 19:13:16, V1849-02, 01:23:11:12, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2000/294/01:23:11:12.jpg, 1154.19995117188, ascend, fije, o, 826618
.\bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation...
placeAnnotations(): Placing annotation 10: vibracorer
Ancillary data = ["vibracorer", "P: 1177.9 db", "T: 3.62 C", "S: 34.569", "O: 0.55 ml/l", "L: 45.9 %"]
inline_name = vnta1850anno10.wrl
.\bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation...
placeAnnotations(): Placing annotation 2: vibracorer
Ancillary data = ["vibracorer", "P: 1175.6 db", "T: 3.682 C", "S: 34.564", "O: 0.53 ml/l", "L: 51.1 %"]
placeAnnotations(): Placing annotation 4: vibracorer
Ancillary data = ["vibracorer", "P: 1177.8 db", "T: 3.605 C", "S: 34.571", "O: 0.56 ml/l", "L: 44.6 %"]
placeAnnotations(): Placing annotation 6: manipulator
Ancillary data = ["manipulator", "P: 1177.5 db", "T: 3.649 C", "S: 34.561", "O: 0.54 ml/l", "L: 50 %"]
placeAnnotations(): Placing annotation 8: mud
Ancillary data = ["mud", "P: 1177.9 db", "T: 3.604 C", "S: 34.573", "O: 0.56 ml/l", "L: 44.4 %"]
placeAnnotations(): Placing annotation 10: vibracorer
Ancillary data = ["vibracorer", "P: 1177.9 db", "T: 3.62 C", "S: 34.569", "O: 0.55 ml/l", "L: 45.9 %"]
inline_name = vnta1850anno02.wrl
.\bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation...
placeAnnotations(): Placing annotation 1: benthos
Ancillary data = ["benthos", "P: 1190.9 db", "T: 3.466 C", "S: 34.595", "O: 0.59 ml/l", "L: 34.6 %"]
placeAnnotations(): Placing annotation 2: vibracorer
Ancillary data = ["vibracorer", "P: 1175.6 db", "T: 3.682 C", "S: 34.564", "O: 0.53 ml/l", "L: 51.1 %"]
placeAnnotations(): Placing annotation 3: vibracorer
Ancillary data = ["vibracorer", "P: 1177.8 db", "T: 3.605 C", "S: 34.571", "O: 0.56 ml/l", "L: 44.6 %"]
placeAnnotations(): Placing annotation 4: vibracorer
Ancillary data = ["vibracorer", "P: 1177.8 db", "T: 3.605 C", "S: 34.571", "O: 0.56 ml/l", "L: 44.6 %"]
placeAnnotations(): Placing annotation 5: vibracorer
Ancillary data = ["vibracorer", "P: 1177.8 db", "T: 3.605 C", "S: 34.571", "O: 0.56 ml/l", "L: 44.6 %"]
placeAnnotations(): Placing annotation 6: manipulator
Ancillary data = ["manipulator", "P: 1177.5 db", "T: 3.649 C", "S: 34.561", "O: 0.54 ml/l", "L: 50 %"]
placeAnnotations(): Placing annotation 7: vibracorer
Ancillary data = ["vibracorer", "P: 1136.1 db", "T: 4.056 C", "S: 34.536", "O: 0.41 ml/l", "L: 63.4 %"]
placeAnnotations(): Placing annotation 8: mud
Ancillary data = ["mud", "P: 1177.9 db", "T: 3.604 C", "S: 34.573", "O: 0.56 ml/l", "L: 44.4 %"]
placeAnnotations(): Placing annotation 9: vibracorer
Ancillary data = ["vibracorer", "P: 1177.9 db", "T: 3.6 C", "S: 34.573", "O: 0.55 ml/l", "L: 45.5 %"]
placeAnnotations(): Placing annotation 10: vibracorer
Ancillary data = ["vibracorer", "P: 1177.9 db", "T: 3.62 C", "S: 34.569", "O: 0.55 ml/l", "L: 45.9 %"]
placeAnnotations(): Placing annotation 11:
Ancillary data = ["", "P: 1166 db", "T: 3.812 C", "S: 34.55", "O: 0.46 ml/l", "L: 49.9 %"]
inline_name = vnta1850anno01.wrl
frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2000/vnta1850...
frameGrabs(): matched 01:10:22:20 in
01:10:22:20.jpg 12-Feb-2003 01:03 44k
frameGrabs(): matched 01:11:06:19 in
01:11:06:19.jpg 12-Feb-2003 01:03 43k
frameGrabs(): matched 01:11:18:19 in
01:11:18:19.jpg 12-Feb-2003 01:04 42k
frameGrabs(): matched 01:11:59:02 in
01:11:59:02.jpg 12-Feb-2003 01:04 40k
frameGrabs(): matched 01:12:27:16 in
01:12:27:16.jpg 12-Feb-2003 01:05 40k
frameGrabs(): matched 01:14:34:28 in
01:14:34:28.jpg 12-Feb-2003 01:05 42k
frameGrabs(): matched 01:19:33:19 in
01:19:33:19.jpg 12-Feb-2003 01:06 43k
frameGrabs(): matched 01:23:11:12 in
01:23:11:12.jpg 12-Feb-2003 01:06 49k
frameGrabs(): matched 01:26:12:07 in
01:26:12:07.jpg 12-Feb-2003 01:07 54k
iList = 01:10:22:20.jpg 01:11:06:19.jpg 01:11:18:19.jpg 01:11:59:02.jpg 01:12:27:16.jpg 01:14:34:28.jpg 01:19:33:19.jpg 01:23:11:12.jpg 01:26:12:07.jpgEXPD::frameGrabs(): 471: Time=972068430, Depth=1165.8, Lat=36.755660, Lon=-122.028958, Pres=1177.8, Temp=3.605, Sal=34.571, O2=0.56, Light=44.6
EXPD::frameGrabs(): 476: Time=972068475, Depth=1165.8, Lat=36.755602, Lon=-122.029504, Pres=1177.8, Temp=3.605, Sal=34.571, O2=0.56, Light=44.6
EXPD::frameGrabs(): 477: Time=972068490, Depth=1165.8, Lat=36.755596, Lon=-122.029639, Pres=1177.8, Temp=3.605, Sal=34.571, O2=0.56, Light=44.6
EXPD::frameGrabs(): 481: Time=972068520, Depth=1165.9, Lat=36.755650, Lon=-122.029288, Pres=1177.9, Temp=3.604, Sal=34.573, O2=0.56, Light=44.4
EXPD::frameGrabs(): 484: Time=972068550, Depth=1165.9, Lat=36.755655, Lon=-122.029180, Pres=1177.9, Temp=3.6, Sal=34.573, O2=0.55, Light=45.5
EXPD::frameGrabs(): 496: Time=972068670, Depth=1165.5, Lat=36.755612, Lon=-122.029463, Pres=1177.5, Temp=3.646, Sal=34.558, O2=0.54, Light=50.4
EXPD::frameGrabs(): 526: Time=972068970, Depth=1165.9, Lat=36.755788, Lon=-122.028869, Pres=1177.9, Temp=3.62, Sal=34.569, O2=0.55, Light=45.9
EXPD::frameGrabs(): 548: Time=972069195, Depth=1154.2, Lat=36.755544, Lon=-122.028953, Pres=1166, Temp=3.812, Sal=34.55, O2=0.46, Light=49.9
EXPD::frameGrabs(): 566: Time=972069375, Depth=1124.6, Lat=36.755631, Lon=-122.028739, Pres=1136.1, Temp=4.056, Sal=34.536, O2=0.41, Light=63.4
.\bin\geopdvc.pl: Calling placeImages with every 10 image...
inline_name = vnta1850fg10.wrl
.\bin\geopdvc.pl: Calling placeImages with every 2 image...
placeImages(): Placing image 2 01:11:18:19.jpg [descend] 972068483 fw= 0.0 cm
XplaceImages(): Placing image 4 01:12:27:16.jpg [descend] 972068552 fw= 0.0 cm
XplaceImages(): Placing image 6 01:19:33:19.jpg [descend] 972068979 fw= 0.0 cm
XplaceImages(): Placing image 8 01:26:12:07.jpg [descend] 972069378 fw= 0.0 cm
Xinline_name = vnta1850fg02.wrl
.\bin\geopdvc.pl: Calling placeImages with every 1 image...
placeImages(): Placing image 1 01:11:06:19.jpg [descend] 972068472 fw= 0.0 cm
XplaceImages(): Placing image 2 01:11:18:19.jpg [descend] 972068483 fw= 0.0 cm
XplaceImages(): Placing image 3 01:11:59:02.jpg [descend] 972068524 fw= 0.0 cm
XplaceImages(): Placing image 4 01:12:27:16.jpg [descend] 972068552 fw= 0.0 cm
XplaceImages(): Placing image 5 01:14:34:28.jpg [descend] 972068679 fw= 0.0 cm
XplaceImages(): Placing image 6 01:19:33:19.jpg [descend] 972068979 fw= 0.0 cm
XplaceImages(): Placing image 7 01:23:11:12.jpg [descend] 972069197 fw= 0.0 cm
XplaceImages(): Placing image 8 01:26:12:07.jpg [descend] 972069378 fw= 0.0 cm
Xinline_name = vnta1850fg01.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/20/2000 5:41:45 PM' AND '10/20/2000 8:11:30 PM')
AND ROVName = 'Ventana'
ORDER BY CollectionEventDTG
samples(): 738, 972071100, , http://mww.mbari.org/SamplesDB/queries/selectSample.asp?ID=8290
samples(): 738, 972071100, , http://mww.mbari.org/SamplesDB/queries/selectSample.asp?ID=15888
samples(): 738, 972071100, , http://mww.mbari.org/SamplesDB/queries/selectSample.asp?ID=15889
placeSamples(): Placing sample 0: V1850-VC15 - sediment
placeSamples(): Placing sample 1: V1850-VC15 - sediment
placeSamples(): Placing sample 2: V1850-VC15 - sediment
inline_name = vnta1850samp.wrl
.\bin\geopdvc.pl: World = geo2000/vnta/vnta1850.wrl
Adding record to ExpeditionData table...
Executing sql:
exec insertExpeditionData '3Dreplay','','',2059,'/3Dreplay/3D.asp?dives=vnta1850','vnta1850','','','',1850
Executing sql:
UPDATE Dive
SET DiveLatMid = 36.7564,
DiveLonMid = -122.0294,
DiveDepthMid = -799.3
WHERE RovName = 'vnta' AND DiveNumber = 1850