Running bin\geopdvc.pl at Mon Dec 14 03:00:27 2009 on host solstice
Command line:
bin\geopdvc.pl -rov vnta -dive 3435
bin\geopdvc.pl: Getting Expedition object for diveno = 3435 and rname = vnta
set_expd(): rov = vnta, diveno = 3435
set_expd(): $self->{EndDDD} = 289
set_expd(): $self->{StartEsecs} = 1255709839
set_expd(): $self->{EndEsecs} = 1255727593
set_expd(): $self->{EndDtg} = 10/16/2009 8:53:13 PM
_readLogr(): Reading videologr data from 2009289datavislogr.dat.gz.
_readLogr(): Expedition start & stop times are 1255709839 & 1255727593
_readLogr(): Flushing variable names:
_readLogr(): esecs of file line[0] = 1255727595, self->{EndEsecs} = 1255727593
_readLogr(): #LOGHOST_SYSTEM_UTC = 1774
_readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1255709841
_readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1255727585
set_expd(): Calling _refineStartAndEndEsecs...
refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1255709841
refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1255727585
refineStartAndEndEsecs(): setting StartEsecs to 1255709839
refineStartAndEndEsecs(): setting EndEsecs to 1255709871
refineStartAndEndEsecs(): numMinBack = 21.4666666666667, numMinForward = 5.36666666666667
refineStartAndEndEsecs(): Refined StartEsecs = 1255709751, Refined EndEsecs = 1255726715
_readLogr(): Reading videologr data from 2009289datavislogr.dat.gz.
_readLogr(): Expedition start & stop times are 1255709751 & 1255726715
_readLogr(): Flushing variable names:
_readLogr(): esecs of file line[0] = 1255726725, self->{EndEsecs} = 1255726715
_readLogr(): #LOGHOST_SYSTEM_UTC = 1695
_readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1255709761
_readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1255726715
bin\geopdvc.pl: expdid = 4192
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)
Does file exist?: \\tornado\TempNav\2009\vnta\nav2009289vntaedited.txt
yes.
EXPD.pm: editNav flag =
rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009289vnta.txt
esecs, east, north, lat, lon, head, pres
1255711184, 0, 0, 36.812078, -121.972497, 304.5, 49.61
1255711685, 0, 0, 36.812322, -121.973657, 275.0, 92.66
1255712186, 0, 0, 36.812678, -121.973483, 276.0, 93.15
1255712687, 0, 0, 36.812702, -121.973727, 275.2, 93.15
1255713188, 0, 0, 36.812753, -121.973798, 275.5, 93.18
1255713689, 0, 0, 36.812787, -121.973802, 275.5, 93.29
1255714190, 0, 0, 36.812790, -121.973685, 275.0, 93.17
1255714691, 0, 0, 36.812775, -121.973772, 275.5, 93.13
1255715192, 0, 0, 36.812770, -121.973657, 275.1, 93.14
1255715693, 0, 0, 36.812778, -121.973655, 275.1, 93.01
1255716194, 0, 0, 36.812768, -121.973632, 275.5, 92.94
1255716695, 0, 0, 36.812743, -121.973818, 275.3, 92.99
1255717196, 0, 0, 36.812783, -121.973463, 275.4, 92.94
1255717697, 0, 0, 36.812792, -121.973458, 276.1, 92.76
1255718198, 0, 0, 36.812792, -121.973562, 275.5, 92.68
1255718699, 0, 0, 36.812795, -121.973543, 274.9, 92.69
1255719200, 0, 0, 36.812810, -121.973592, 275.7, 92.78
1255719701, 0, 0, 36.812845, -121.973755, 275.5, 93.01
1255720202, 0, 0, 36.812812, -121.973545, 274.6, 93.10
1255720703, 0, 0, 36.812828, -121.973663, 275.0, 93.08
1255721203, 0, 0, 36.812837, -121.973735, 275.3, 92.87
1255721704, 0, 0, 36.812878, -121.973752, 274.9, 92.89
1255722205, 0, 0, 36.812838, -121.973712, 275.7, 92.79
1255722706, 0, 0, 36.812897, -121.973773, 275.4, 92.69
1255723207, 0, 0, 36.812912, -121.973793, 276.2, 92.69
1255723708, 0, 0, 36.812922, -121.973792, 275.2, 92.68
1255724209, 0, 0, 36.812942, -121.973792, 274.2, 92.57
1255724710, 0, 0, 36.812978, -121.973810, 275.2, 92.40
1255725211, 0, 0, 36.813863, -121.974123, 275.6, 92.27
1255725712, 0, 0, 36.812772, -121.973575, 270.1, 92.23
1255726213, 0, 0, 36.812690, -121.971812, 90.0, 52.36
rovNav(): 289: 15503 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009289vnta.txt
15503 in tList
15503 in {self->{rovT}}
15503 in {self->{rovH}}
rovCTDO(): ROV CTDO start & stop times are 1255725510 & 1255713135
rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.):
..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX
rovGDCListRefs(): dMedian = 92.192164216789
rovGDCListRefs(): dStats->sample_range = 91.81424506776
rovGDCListRefs(): returning (1st elements): 1255709751 36.812367 -121.971787 92.8 22.4316504987371
geopdcv.pl(): editedNav flag = 1
Using mbnavedit edited Navigation.
rovnavCTDO(): calcUTM = 0
rovNav(): 1, calcUTM = 0
rovNav(): calcUTM = 0
rovNav(): DDD = 289 (looping to 289)
Does file exist?: \\tornado\TempNav\2009\vnta\nav2009289vntaedited.txt
yes.
EXPD.pm: editNav flag =
rovNav(): Opening ROV nav data from \\tornado\TempNav\2009\vnta\nav2009289vntaedited.txt
esecs, east, north, lat, lon, head, pres
1255711184, 0, 0, 36.812113, -121.972528, 304.5, 49.61
1255711685, 0, 0, 36.812653, -121.973457, 275.0, 92.66
1255712186, 0, 0, 36.812687, -121.973525, 276.0, 93.15
1255712687, 0, 0, 36.812702, -121.973737, 275.2, 93.15
1255713188, 0, 0, 36.812727, -121.973788, 275.5, 93.18
1255713689, 0, 0, 36.812762, -121.973775, 275.5, 93.29
1255714190, 0, 0, 36.812764, -121.973680, 275.0, 93.17
1255714691, 0, 0, 36.812771, -121.973750, 275.5, 93.13
1255715192, 0, 0, 36.812757, -121.973645, 275.1, 93.14
1255715693, 0, 0, 36.812777, -121.973645, 275.1, 93.01
1255716194, 0, 0, 36.812780, -121.973605, 275.5, 92.94
1255716695, 0, 0, 36.812766, -121.973796, 275.3, 92.99
1255717196, 0, 0, 36.812788, -121.973485, 275.4, 92.94
1255717697, 0, 0, 36.812790, -121.973484, 276.1, 92.76
1255718198, 0, 0, 36.812810, -121.973561, 275.5, 92.68
1255718699, 0, 0, 36.812801, -121.973556, 274.9, 92.69
1255719200, 0, 0, 36.812799, -121.973578, 275.7, 92.78
1255719701, 0, 0, 36.812817, -121.973776, 275.5, 93.01
1255720202, 0, 0, 36.812822, -121.973556, 274.6, 93.10
1255720703, 0, 0, 36.812825, -121.973645, 275.0, 93.08
1255721203, 0, 0, 36.812851, -121.973718, 275.3, 92.87
1255721704, 0, 0, 36.812865, -121.973741, 274.9, 92.89
1255722205, 0, 0, 36.812861, -121.973694, 275.7, 92.79
1255722706, 0, 0, 36.812886, -121.973746, 275.4, 92.69
1255723207, 0, 0, 36.812907, -121.973785, 276.2, 92.69
1255723708, 0, 0, 36.812916, -121.973769, 275.2, 92.68
1255724209, 0, 0, 36.812945, -121.973755, 274.2, 92.57
1255724710, 0, 0, 36.812962, -121.973757, 275.2, 92.40
1255725211, 0, 0, 36.812975, -121.973600, 275.6, 92.27
1255725712, 0, 0, 36.812787, -121.973554, 270.1, 92.23
1255726213, 0, 0, 36.812684, -121.971905, 90.0, 52.36
rovNav(): 289: 15503 in tList after reading from \\tornado\TempNav\2009\vnta\nav2009289vntaedited.txt
rovNav(): Initial # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1255709751
rovNav(): Initial # seconds to fill at end of dive = 178 ending at EndEsecs =1255726715
rovNav(): LOGHOST_SYSTEM_UTC[0] = 1255709761
rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1255726715
rovNav(): numMinBack = 21.3, numMinForward = 5.36666666666667
rovNav(): Refined StartEsecs = 1255709751, Refined EndEsecs = 1255726715
rovNav(): Refined # seconds to fill at beginning of dive = 0 starting at StartEsecs = 1255709751
rovNav(): Refined # seconds to fill at end of dive = 178 ending at EndEsecs =1255726715
rovNav(): num tList = 15503
rovNav(): num eList = 15503
rovNav(): Adding data to begining of dive from logr indices 0 .. 0
rovNav(): Adding data to end of dive from logr indices 1678 .. 1695
rovNav(): num in tList now = 15522
rovNav(): num in eList now = 15522
15522 in tList
15522 in {self->{rovT}}
15522 in {self->{rovH}}
rovCTDO(): ROV CTDO start & stop times are 1255725510 & 1255713135
rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX
rovGDCListRefs(): dMedian = 92.1921641555893
rovGDCListRefs(): dStats->sample_range = 98.8093728470943
rovGDCListRefs(): returning (1st elements): 1255709761 36.811922 -121.973435 93.1 -5
bin\geopdvc.pl: -------------------------------------------------------------------------------
hash{lat} = 36.81280100
hash{lon} = -121.97357700
latMin = 30.812801
latMax = 42.812801
Executing sql:
SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.812801 AND 42.812801 AND Longitude BETWEEN -127.973577 AND -115.973577
Dive lat = 36.81280100, area = cencal
bin\geopdvc.pl: Found area = cencal in GeoOrigin
For midpoint lon = -121.97357700 & lat = 36.81280100
Using olon = -122 & olat = 36
bin\geopdvc.pl: Calling makeROVorig...
inline_name = vnta3435rov_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 = geo2009/vnta/vnta3435lookup.wrl
bin\geopdvc.pl: Getting ship nav...
shipNav(): selecting for ShipName = ptlo
shipNav(): $#{$self->{shipLat}} = 1695
shipNav(): $#{$self->{shipLat}}[lastframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2009/289/accesses.txt at bin\geopdvc.pl line 2382
frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2009/289/accesses.txt at bin\geopdvc.pl line 625
] = 36.812202
Position subsampling set to 12
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 = 15523
makeTracks(): Looping through 1695 point of ship position data...
makeTracks(): posSubsample = 12
makeTracks(): Writing tracks file...
makeTracks(): INFO $sname =
inline_name = vnta3435tracks.wrl
writeCtdPosFile(): Writing merged CTD Nav data to geo2009/vnta/vnta3435mergedCtdNav.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/2009 4:37:19 PM' AND '10/16/2009 8:53:13 PM') OR
(RovName = 'Ventana') AND (RecordedDate BETWEEN '10/16/2009 4:37:19 PM' AND '10/16/2009 8:53:13 PM')
_findIndex():
Looking for epoch secs 1255712539 ...
Found time 1255712539 after 10 iterations.
>>> p = 1673: annotations(): 1673, 1255712539, 10/16/09 17:02:19, V3435-01HD, 00:00:26:12, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3435/00_00_26_12.jpg, 91.629997253418, descend, ventana, o, 20038462
_findIndex():
Looking for epoch secs 1255712544 ...
Found time 1255712547 after 9 iterations.
>>> p = 1681: annotations(): 1681, 1255712544, 10/16/09 17:02:24, V3435-01HD, 00:00:30:29, physical object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3435/00_00_30_29.jpg, 92.1100006103516, descend, ventana, o, 20038463
bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation...
inline_name = vnta3435anno10.wrl
bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation...
placeAnnotations(): Placing annotation 2:
Ancillary data = ["", "P: 94.4 db", "T: 11.965 C", "S: 33.43", "O: 4.414 ml/l", "L: 84.23 %"]
inline_name = vnta3435anno02.wrl
bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation...
placeAnnotations(): Placing annotation 1: physical object
Ancillary data = ["physical object", "P: 93.7 db", "T: 12.04 C", "S: 33.427", "O: 4.409 ml/l", "L: 84.23 %"]
placeAnnotations(): Placing annotation 2:
Ancillary data = ["", "P: 94.4 db", "T: 11.965 C", "S: 33.43", "O: 4.414 ml/l", "L: 84.23 %"]
inline_name = vnta3435anno01.wrl
frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2009/vnta3435...
frameGrabs(): matched 00_00_26_12 in
00_00_26_12.jpg 02-Nov-2009 00:16 52k
frameGrabs(): matched 00_00_30_29 in
00_00_30_29.jpg 02-Nov-2009 00:16 49k
iList = 00_00_26_12.jpg 00_00_30_29.jpg
_findIndex():
Looking for epoch secs 1255712539 ...
Found time 1255712539 after 10 iterations.
>>> p = 1673: frameGrabs(): index = 1673
EXPD::frameGrabs(): 1673: Time=1255712535, Depth=92.99, Lat= 36.812695, Lon=-121.973610, Pres=93.7, Temp=12.04, Sal=33.427, O2=4.409, Light=84.23
_findIndex():
Looking for epoch secs 1255712544 ...
Found time 1255712547 after 9 iterations.
>>> p = 1681: frameGrabs(): index = 1681
EXPD::frameGrabs(): 1681: Time=1255712550, Depth=93.68, Lat= 36.812694, Lon=-121.973612, Pres=94.4, Temp=11.965, Sal=33.43, O2=4.414, Light=84.23
bin\geopdvc.pl: Number of images returned from expd->frameGrabs(every=>1)} = 2
bin\geopdvc.pl: Calling placeImages with every 10 image...
placeImages(): Placing image 0 00_00_26_12.jpg 1255712539 fw= 0.0 cm
XplaceImages(): indx = 1673, geoPosition = 36.812695, -121.973610, -91.6266353447044, rovDepth = 91.6266353447044
inline_name = vnta3435fg10.wrl
bin\geopdvc.pl: Calling placeImages with every 2 image...
placeImages(): Placing image 0 00_00_26_12.jpg 1255712539 fw= 0.0 cm
XplaceImages(): indx = 1673, geoPosition = 36.812695, -121.973610, -91.6266353447044, rovDepth = 91.6266353447044
inline_name = vnta3435fg02.wrl
bin\geopdvc.pl: Calling placeImages with every 1 image...
placeImages(): Placing image 0 00_00_26_12.jpg 1255712539 fw= 0.0 cm
XplaceImages(): indx = 1673, geoPosition = 36.812695, -121.973610, -91.6266353447044, rovDepth = 91.6266353447044
placeImages(): Placing image 1 00_00_30_29.jpg 1255712544 fw= 0.0 cm
XplaceImages(): indx = 1681, geoPosition = 36.812694, -121.973612, -92.5691839265751, rovDepth = 92.5691839265751
inline_name = vnta3435fg01.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/2009 4:37:19 PM' AND '10/16/2009 8:53:13 PM')
AND ROVName = 'Ventana'
ORDER BY CollectionEventDTG
bin\geopdvc.pl: World = geo2009/vnta/vnta3435.wrl
Adding record to ExpeditionData table...
Executing sql:
exec insertExpeditionData '3Dreplay','','',4192,'/3Dreplay/3D.asp?dives=vnta3435','vnta3435','','','',3435
Executing sql:
UPDATE Dive
SET DiveLatMid = 36.8128,
DiveLonMid = -121.9736,
DiveDepthMid = -92.2
WHERE RovName = 'vnta' AND DiveNumber = 3435