Running bin\geopdvc.pl at Sat Sep 6 03:02:24 2014 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3793 bin\geopdvc.pl: Getting Expedition object for diveno = 3793 and rname = vnta set_expd(): rov = vnta, diveno = 3793 set_expd(): Executing sql: SELECT ExpeditionID_FK, DateDiff(ss, '01/01/70', DiveStartDtg), DateDiff(ss, '01/01/70', DiveEndDtg), DiveStartDtg, DiveEndDtg FROM Dive WHERE DiveNumber = 3793 AND RovName = 'vnta' RS->Fields(0)->Value= 5043 RS->Fields(1)->Value= 1404938655 RS->Fields(2)->Value= 1404941856 RS->Fields(3)->Value= 7/9/2014 8:44:15 PM RS->Fields(4)->Value= 7/9/2014 9:37:36 PM set_expd(): $self->{EndDDD} = 190 set_expd(): $self->{StartEsecs} = 1404937455 set_expd(): $self->{EndEsecs} = 1404943056 set_expd(): $self->{EndDtg} = 7/9/2014 9:37:36 PM _readLogr(): Reading videologr data from 2014190datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1404937455 & 1404943056 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1404943059, self->{EndEsecs} = 1404943056 _readLogr(): #LOGHOST_SYSTEM_UTC = 559 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1404937459 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1404943049 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1404937459 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1404943049 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1404937335, Refined EndEsecs = 1404943176 _readLogr(): Reading videologr data from 2014190datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1404937335 & 1404943176 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1404943179, self->{EndEsecs} = 1404943176 _readLogr(): #LOGHOST_SYSTEM_UTC = 583 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1404937339 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1404943169 bin\geopdvc.pl: expdid = 5043 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 = 190 (looping to 190) Does file exist?: \\atlas\RovNavEdit\2014\vnta\nav2014190vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2014\vnta\nav2014190vnta.txt esecs, east, north, lat, lon, head, pres 1404938530, 0, 0, 36.707605, -122.043273, 128.1, 3.96 1404939031, 0, 0, 36.748258, -122.100673, 329.4, 98.95 1404939532, 0, 0, 36.749432, -122.101845, 342.9, 237.68 1404940033, 0, 0, 36.750668, -122.102468, 133.1, 377.20 1404940533, 0, 0, 36.749898, -122.103365, 185.6, 316.31 1404941034, 0, 0, 36.749617, -122.103922, 193.9, 190.31 1404941535, 0, 0, 36.748730, -122.104108, 258.5, 62.75 1404942036, 0, 0, 36.748468, -122.103217, 165.5, 3.26 rovNav(): 190: 3593 in tList after reading from \\atlas\RovNavEdit\2014\vnta\nav2014190vnta.txt 3593 in tList 3593 in {self->{rovT}} 3593 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1404939570 & 1404940440 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 161.785883643597 rovGDCListRefs(): dStats->sample_range = 373.618807705608 rovGDCListRefs(): returning (1st elements): 1404938464 36.707605 -122.043273 130.1 2.59070831635906 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 190 (looping to 190) Does file exist?: \\atlas\RovNavEdit\2014\vnta\nav2014190vntaedited.txt yes. EXPD.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2014\vnta\nav2014190vntaedited.txt esecs, east, north, lat, lon, head, pres 1404938530, 0, 0, 36.717001, -122.063737, 128.1, 3.96 1404939031, 0, 0, 36.748236, -122.100729, 329.4, 98.95 1404939532, 0, 0, 36.749634, -122.101993, 342.9, 237.68 1404940033, 0, 0, 36.750665, -122.102465, 133.1, 377.20 1404940533, 0, 0, 36.749982, -122.103412, 185.6, 316.31 1404941034, 0, 0, 36.749753, -122.103932, 193.9, 190.31 1404941535, 0, 0, 36.748747, -122.104049, 258.5, 62.75 1404942036, 0, 0, 36.739350, -122.091717, 165.5, 3.26 rovNav(): 190: 3593 in tList after reading from \\atlas\RovNavEdit\2014\vnta\nav2014190vntaedited.txt 3593 in tList 3593 in {self->{rovT}} 3593 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1404939570 & 1404940440 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXX..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 161.785883307285 rovGDCListRefs(): dStats->sample_range = 373.618809701271 rovGDCListRefs(): returning (1st elements): 1404938464 36.714574 -122.060783 130.1 2.59070672000674 bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.74949450 hash{lon} = -122.10247550 latMin = 30.7494945 latMax = 42.7494945 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.7494945 AND 42.7494945 AND Longitude BETWEEN -128.1024755 AND -116.1024755 Dive lat = 36.74949450, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.10247550 & lat = 36.74949450 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3793rov_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.frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2014/190/accesses.txt at bin\geopdvc.pl line 2382 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 = geo2014/vnta/vnta3793lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 583 shipNav(): $#{$self->{shipLat}}[last] = 36.757367 Position subsampling set to 3 setROVcolorlines(): Assigning color line for Light... varColors = LightColors index0 = .8 .7 0 setROVcolorlines(): Assigning color line for O2... varColors = O2Colors index0 = 1 1 1 setROVcolorlines(): Assigning color line for Sal... varColors = SalColors index0 = 1 1 .1 setROVcolorlines(): Assigning color line for Temp... varColors = TempColors index0 = 0 0 1 makeTracks(): n = 3594 makeTracks(): Looping through 583 point of ship position data... makeTracks(): posSubsample = 3 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3793tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2014/vnta/vnta3793mergedCtdNav.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 = '') AND (RecordedDate BETWEEN '7/9/2014 8:44:15 PM' AND '7/9/2014 9:37:36 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '7/9/2014 8:44:15 PM' AND '7/9/2014 9:37:36 PM') _findIndex(): Looking for epoch secs 1404940001 ... Found time 1404940002 after 8 iterations. >>> p = 1536: annotations(): 1536, 1404940001, 07/09/14 21:06:41, V3793-01HD, 04:31:53:18, Midwater Respirometry System, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3793/04_31_53_18.jpg, 374.510009765625, stationary, robs, u, 20055757 _findIndex(): Looking for epoch secs 1404940031 ... Found time 1404940031 after 8 iterations. >>> p = 1564: annotations(): 1564, 1404940031, 07/09/14 21:07:11, V3793-01HD, 04:32:23:19, Midwater Respirometry System, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3793/04_32_23_19.jpg, 373.5, stationary, robs, u, 20055758 _findIndex(): Looking for epoch secs 1404940044 ... Found time 1404940045 after 8 iterations. >>> p = 1578: annotations(): 1578, 1404940044, 07/09/14 21:07:24, V3793-01HD, 04:32:36:04, Midwater Respirometry System, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3793/04_32_36_04.jpg, 373.980010986328, stationary, robs, u, 20055759 _findIndex(): Looking for epoch secs 1404940060 ... Found time 1404940059 after 8 iterations. >>> p = 1592: annotations(): 1592, 1404940060, 07/09/14 21:07:40, V3793-01HD, 04:32:52:03, Midwater Respirometry System, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3793/04_32_52_03.jpg, 373.559997558594, stationary, robs, u, 20055760 _findIndex(): Looking for epoch secs 1404940075 ... Found time 1404940080 after 7 iterations. >>> p = 1613: annotations(): 1613, 1404940075, 07/09/14 21:07:55, V3793-01HD, 04:33:07:05, Midwater Respirometry System, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3793/04_33_07_05.jpg, 373.609985351563, stationary, robs, u, 20055761 _findIndex(): Looking for epoch secs 1404940081 ... Found time 1404940080 after 7 iterations. >>> p = 1613: annotations(): 1613, 1404940081, 07/09/14 21:08:01, V3793-01HD, 04:33:13:20, Midwater Respirometry System, http://search.mbari.org/ARCHIVE/frameGrabs/VeframeGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2014/190/accesses.txt at bin\geopdvc.pl line 625 ntana/images/3793/04_33_13_20.jpg, 373.329986572266, stationary, robs, u, 20055762 _findIndex(): Looking for epoch secs 1404940113 ... Found time 1404940108 after 7 iterations. >>> p = 1641: annotations(): 1641, 1404940113, 07/09/14 21:08:33, V3793-01HD, 04:33:46:04, Midwater Respirometry System, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3793/04_33_46_04.jpg, 372.459991455078, stationary, robs, u, 20055763 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... inline_name = vnta3793anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 377 db", "T: 8.051 C", "S: 34.198", "O: 0.918 ml/l", "L: 87.34 %"] placeAnnotations(): Placing annotation 4: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 376.6 db", "T: 8.046 C", "S: 34.198", "O: 0.917 ml/l", "L: 87.34 %"] placeAnnotations(): Placing annotation 6: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 376.3 db", "T: 8.046 C", "S: 34.199", "O: 0.916 ml/l", "L: 87.38 %"] inline_name = vnta3793anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 377.4 db", "T: 8.046 C", "S: 34.199", "O: 0.916 ml/l", "L: 87.35 %"] placeAnnotations(): Placing annotation 2: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 377 db", "T: 8.051 C", "S: 34.198", "O: 0.918 ml/l", "L: 87.34 %"] placeAnnotations(): Placing annotation 3: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 376.2 db", "T: 8.047 C", "S: 34.2", "O: 0.915 ml/l", "L: 87.38 %"] placeAnnotations(): Placing annotation 4: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 376.6 db", "T: 8.046 C", "S: 34.198", "O: 0.917 ml/l", "L: 87.34 %"] placeAnnotations(): Placing annotation 5: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 376.3 db", "T: 8.046 C", "S: 34.199", "O: 0.916 ml/l", "L: 87.38 %"] placeAnnotations(): Placing annotation 6: Midwater Respirometry System Ancillary data = ["Midwater Respirometry System", "P: 376.3 db", "T: 8.046 C", "S: 34.199", "O: 0.916 ml/l", "L: 87.38 %"] placeAnnotations(): Placing annotation 7: Ancillary data = ["", "P: 375.5 db", "T: 8.061 C", "S: 34.16", "O: 0.93 ml/l", "L: 87.32 %"] inline_name = vnta3793anno01.wrl frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2014/vnta3793... frameGrabs(): matched 04_31_53_18 in [IMG]04_31_53_18.jpg16-Jul-2014 09:00 295K frameGrabs(): matched 04_32_23_19 in [IMG]04_32_23_19.jpg16-Jul-2014 09:00 342K frameGrabs(): matched 04_32_36_04 in [IMG]04_32_36_04.jpg16-Jul-2014 09:00 390K frameGrabs(): matched 04_32_52_03 in [IMG]04_32_52_03.jpg16-Jul-2014 09:00 379K frameGrabs(): matched 04_33_07_05 in [IMG]04_33_07_05.jpg16-Jul-2014 09:00 434K frameGrabs(): matched 04_33_13_20 in [IMG]04_33_13_20.jpg16-Jul-2014 09:00 461K frameGrabs(): matched 04_33_46_04 in [IMG]04_33_46_04.jpg16-Jul-2014 09:00 415K iList = 04_31_53_18.jpg 04_32_23_19.jpg 04_32_36_04.jpg 04_32_52_03.jpg 04_33_07_05.jpg 04_33_13_20.jpg 04_33_46_04.jpg _findIndex(): Looking for epoch secs 1404940001 ... Found time 1404940002 after 8 iterations. >>> p = 1536: frameGrabs(): index = 1536 EXPD::frameGrabs(): 1536: Time=1404940005, Depth=374.28, Lat=36.750639, Lon=-122.102494, Pres=377.4, Temp=8.046, Sal=34.199, O2=0.916, Light=87.35 _findIndex(): Looking for epoch secs 1404940031 ... Found time 1404940031 after 8 iterations. >>> p = 1564: frameGrabs(): index = 1564 EXPD::frameGrabs(): 1564: Time=1404940035, Depth=373.88, Lat= 36.750665, Lon=-122.102466, Pres=377, Temp=8.051, Sal=34.198, O2=0.918, Light=87.34 _findIndex(): Looking for epoch secs 1404940044 ... Found time 1404940045 after 8 iterations. >>> p = 1578: frameGrabs(): index = 1578 EXPD::frameGrabs(): 1578: Time=1404940050, Depth=373.09, Lat=36.750666, Lon=-122.102459, Pres=376.2, Temp=8.047, Sal=34.2, O2=0.915, Light=87.38 _findIndex(): Looking for epoch secs 1404940060 ... Found time 1404940059 after 8 iterations. >>> p = 1592: frameGrabs(): index = 1592 EXPD::frameGrabs(): 1592: Time=1404940065, Depth=373.48, Lat= 36.750667, Lon=-122.102458, Pres=376.6, Temp=8.046, Sal=34.198, O2=0.917, Light=87.34 _findIndex(): Looking for epoch secs 1404940075 ... Found time 1404940080 after 7 iterations. >>> p = 1613: frameGrabs(): index = 1613 EXPD::frameGrabs(): 1613: Time=1404940080, Depth=373.19, Lat= 36.750671, Lon=-122.102461, Pres=376.3, Temp=8.046, Sal=34.199, O2=0.916, Light=87.38 _findIndex(): Looking for epoch secs 1404940081 ... Found time 1404940080 after 7 iterations. >>> p = 1613: frameGrabs(): index = 1613 EXPD::frameGrabs(): 1613: Time=1404940080, Depth=373.19, Lat= 36.750671, Lon=-122.102461, Pres=376.3, Temp=8.046, Sal=34.199, O2=0.916, Light=87.38 _findIndex(): Looking for epoch secs 1404940113 ... Found time 1404940108 after 7 iterations. >>> p = 1641: frameGrabs(): index = 1641 EXPD::frameGrabs(): 1641: Time=1404940110, Depth=372.39, Lat=36.750664, Lon=-122.102481, Pres=375.5, Temp=8.061, Sal=34.16, O2=0.93, Light=87.32 bin\geopdvc.pl: Number of images returned from expd->frameGrabs(every=>1)} = 7 bin\geopdvc.pl: Calling placeImages with every 10 image... placeImages(): Placing image 0 04_31_53_18.jpg 1404940001 fw= 0.0 cm XplaceImages(): indx = 1536, geoPosition = 36.750639, -122.102494, -374.505360350604, rovDepth = 374.505360350604 inline_name = vnta3793fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... placeImages(): Placing image 0 04_31_53_18.jpg 1404940001 fw= 0.0 cm XplaceImages(): indx = 1536, geoPosition = 36.750639, -122.102494, -374.505360350604, rovDepth = 374.505360350604 placeImages(): Placing image 2 04_32_36_04.jpg 1404940044 fw= 0.0 cm XplaceImages(): indx = 1578, geoPosition = 36.750666, -122.102459, -373.970331397988, rovDepth = 373.970331397988 placeImages(): Placing image 4 04_33_07_05.jpg 1404940075 fw= 0.0 cm XplaceImages(): indx = 1613, geoPosition = 36.750671, -122.102461, -373.33622209617, rovDepth = 373.33622209617 placeImages(): Placing image 6 04_33_46_04.jpg 1404940113 fw= 0.0 cm XplaceImages(): indx = 1641, geoPosition = 36.750664, -122.102481, -372.929995130638, rovDepth = 372.929995130638 inline_name = vnta3793fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... placeImages(): Placing image 0 04_31_53_18.jpg 1404940001 fw= 0.0 cm XplaceImages(): indx = 1536, geoPosition = 36.750639, -122.102494, -374.505360350604, rovDepth = 374.505360350604 placeImages(): Placing image 1 04_32_23_19.jpg 1404940031 fw= 0.0 cm XplaceImages(): indx = 1564, geoPosition = 36.750665, -122.102466, -373.494749762402, rovDepth = 373.494749762402 placeImages(): Placing image 2 04_32_36_04.jpg 1404940044 fw= 0.0 cm XplaceImages(): indx = 1578, geoPosition = 36.750666, -122.102459, -373.970331397988, rovDepth = 373.970331397988 placeImages(): Placing image 3 04_32_52_03.jpg 1404940060 fw= 0.0 cm XplaceImages(): indx = 1592, geoPosition = 36.750667, -122.102458, -373.425393944134, rovDepth = 373.425393944134 placeImages(): Placing image 4 04_33_07_05.jpg 1404940075 fw= 0.0 cm XplaceImages(): indx = 1613, geoPosition = 36.750671, -122.102461, -373.33622209617, rovDepth = 373.33622209617 placeImages(): Placing image 5 04_33_13_20.jpg 1404940081 fw= 0.0 cm XplaceImages(): indx = 1613, geoPosition = 36.750671, -122.102461, -373.33622209617, rovDepth = 373.33622209617 placeImages(): Placing image 6 04_33_46_04.jpg 1404940113 fw= 0.0 cm .placeImages(): indx = 1641, geoPosition = 36.750664, -122.102481, -372.929995130638, rovDepth = 372.929995130638 inline_name = vnta3793fg01.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 '7/9/2014 8:44:15 PM' AND '7/9/2014 9:37:36 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2014/vnta/vnta3793.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',5043,'/3Dreplay/3D.asp?dives=vnta3793','vnta3793','','','',3793 Executing sql: UPDATE Dive SET DiveLatMid = 36.7495, DiveLonMid = -122.1025, DiveDepthMid = -161.8 WHERE RovName = 'vnta' AND DiveNumber = 3793