Running .\bin\geopdvc.pl at Fri Sep 14 02:54:37 2007 on host scyphozoan Command line: .\bin\geopdvc.pl -rov vnta -dive 3041 .\bin\geopdvc.pl: Getting Expedition object for diveno = 3041 and rname = vnta set_expd(): rov = vnta, diveno = 3041 set_expd(): $self->{EndDDD} = 179 set_expd(): $self->{StartEsecs} = 1183040745 set_expd(): $self->{EndEsecs} = 1183045935 set_expd(): $self->{EndDtg} = 6/28/2007 3:32:15 PM _readLogr(): Reading videologr data from 2007179datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1183040745 & 1183045935 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 518 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1183040747 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1183045932 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1183040747 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1183045932 refineStartAndEndEsecs(): setting StartEsecs to 1183040745 refineStartAndEndEsecs(): setting EndEsecs to 1183040767 refineStartAndEndEsecs(): numMinBack = 21.6333333333333, numMinForward = 21.45 refineStartAndEndEsecs(): Refined StartEsecs = 1183040647, Refined EndEsecs = 1183046022 _readLogr(): Reading videologr data from 2007179datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1183040647 & 1183046022 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 536 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1183040657 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1183046022 .\bin\geopdvc.pl: expdid = 3678 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 179 (looping to 179) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007179vnta.txt esecs, east, north, lat, lon, head, pres 1183042426, 0, 0, 36.792910, -121.843650, 269.3, 144.77 1183042932, 0, 0, 36.793055, -121.844482, 180.3, 288.79 1183043438, 0, 0, 36.793013, -121.844423, 47.9, 289.39 1183043943, 0, 0, 36.793143, -121.844448, 59.2, 288.54 1183044448, 0, 0, 36.792710, -121.843727, 97.7, 112.40 179: 2946 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007179vnta.txt rovNav(): Initial # seconds to fill at beginning of dive = 1175 starting at StartEsecs = 1183040647 rovNav(): Initial # seconds to fill at end of dive = 0 ending at EndEsecs =1183046022 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1183040657 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1183046022 rovNav(): numMinBack = 21.4666666666667, numMinForward = 21.45 rovNav(): Refined StartEsecs = 1183040647, Refined EndEsecs = 1183046022 rovNav(): Refined # seconds to fill at beginning of dive = 1175 starting at StartEsecs = 1183040647 rovNav(): Refined # seconds to fill at end of dive = 0 ending at EndEsecs =1183046022 rovNav(): num tList = 2946 rovNav(): num eList = 2946 rovNav(): Adding data to begining of dive from logr indices 0 .. 116 rovNav(): Adding data to end of dive from logr indices 536 .. 536 rovNav(): num in tList now = 3064 rovNav(): num in eList now = 3064 3064 in tList 3064 in {self->{rovT}} 3064 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1183042335 & 1183043415 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 = 179 (looping to 179) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007179vnta.txt esecs, east, north, lat, lon, head, pres 1183042426, 0, 0, 36.792910, -121.843650, 269.3, 144.77 1183042932, 0, 0, 36.793055, -121.844482, 180.3, 288.79 1183043438, 0, 0, 36.793013, -121.844423, 47.9, 289.39 1183043943, 0, 0, 36.793143, -121.844448, 59.2, 288.54 1183044448, 0, 0, 36.792710, -121.843727, 97.7, 112.40 179: 2946 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007179vnta.txt 2946 in tList 2946 in {self->{rovT}} 2946 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1183042335 & 1183043415 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXX....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/179/accesses.txt at .\bin\geopdvc.pl line 2188 ...........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX .\bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79301200 hash{lon} = -121.84398800 latMin = 30.793012 latMax = 42.793012 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.793012 AND 42.793012 AND Longitude BETWEEN -127.843988 AND -115.843988 Dive lat = 36.79301200, area = cencal .\bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.84398800 & lat = 36.79301200 Using olon = -122 & olat = 36 .\bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3041rov_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/vnta3041lookup.wrl .\bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 536 shipNav(): $#{$self->{shipLat}}[last] = 36.793415 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 = 3065 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3041tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2007/vnta/vnta3041mergedCtdNav.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 '6/28/2007 2:45:45 PM' AND '6/28/2007 3:32:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '6/28/2007 2:45:45 PM' AND '6/28/2007 3:32:15 PM') _findIndex(): Looking for epoch secs 1183042776 ... Found time 1183042776 after 8 iterations. >>> p = 845: annotations(): 845, 1183042776, 06/28/07 14:59:36, V3041-01, 00:00:00:00, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_00_00_00.jpg, 284.549987792969, descend, methane, o, 20019540 _findIndex(): Looking for epoch secs 1183042785 ... Found time 1183042782 after 6 iterations. >>> p = 851: annotations(): 851, 1183042785, 06/28/07 14:59:45, V3041-01, 00:00:03:12, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_00_03_12.jpg, 284.480010986328, descend, methane, o, 20019541 _findIndex(): Looking for epoch secs 1183042786 ... Found time 1183042782 after 6 iterations. >>> p = 851: annotations(): 851, 1183042786, 06/28/07 14:59:46, V3041-01, 00:00:04:28, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_00_04_28.jpg, 284.390014648438, descend, methane, o, 20019542 _findIndex(): Looking for epoch secs 1183043127 ... Found time 1183043131 after 4 iterations. >>> p = 1196: annotations(): 1196, 1183043127, 06/28/07 15:05:27, V3041-01, 00:05:44:17, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_05_44_17.jpg, 287.010009765625, descend, methane, o, 20019543 _findIndex(): Looking for epoch secs 1183043235 ... Found time 1183043235 after 7 iterations. >>> p = 1299: annotations(): 1299, 1183043235, 06/28/07 15:07:15, V3041-01, 00:07:33:14, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_07_33_14.jpg, 287.019989013672, descend, methane, o, 20019544 _findIndex(): Looking for epoch secs 1183043257 ... Found time 1183043259 after 7 iterations. >>> p = 1322: annotations(): 1322, 1183043257, 06/28/07 15:07:37, V3041-01, 00:07:54:13, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_07_54_13.jpg, 287.019989013672, descend, methane, o, 20019545 _findIndex(): Looking for epoch secs 1183043790 ... Found time 1183043794 after 7 iterations. >>> p = 1852: annotations(): 1852, 1183043790, 06/28/07 15:16:30, V3041-01, 00:16:48:12, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_16_48_12.jpg, 287.070007324219, descend, methane, o, 20019546 _findIndex(): Looking for epoch secs 1183043820 ... Found time 1183043817 after 7 iterations. >>> p = 1875: annotations(): 1875, 1183043820, 06/28/07 15:17:00, V3041-01, 00:17:17:11, physical-object, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3041/00_17_17_11.jpg, 287.070007324219, descend, methane, o, 20019547 .\bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... inline_name = vnta3041anno10.wrl .\bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: physical-object Ancillary data = ["physical-object", "P: 285.2 db", "T: 7.692 C", "S: 34.169", "O: 1.3 ml/l", "L: 81.9 %"] placeAnnotations(): Placing annotation 4: physical-object Ancillary data = ["physical-object", "P: 287.4 db", "T: 7.683 C", "S: 34.171", "O: 1.27 ml/l", "L: 78.3 %"] placeAnnotations(): Placing annotation 6: physical-object Ancillary data = ["physical-object", "P: 287.5 db", "T: 7.684 C", "S: 34.173", "O: 1.26 ml/l", "L: 80.3 %"] placeAnnotations(): Placing annotation 8: Ancillary data = ["", "P: 287.5 db", "T: 7.69 C", "S: 34.172", "O: 1.25 ml/l", "L: 79.5 %"] inline_name = vnta3041anno02.wrl .\bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: physical-object Ancillary data = ["physical-object", "P: 285.2 db", "T: 7.69frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/179/accesses.txt at .\bin\geopdvc.pl line 554 C", "S: 34.17", "O: 1.3 ml/l", "L: 82 %"] placeAnnotations(): Placing annotation 2: physical-object Ancillary data = ["physical-object", "P: 285.2 db", "T: 7.692 C", "S: 34.169", "O: 1.3 ml/l", "L: 81.9 %"] placeAnnotations(): Placing annotation 3: physical-object Ancillary data = ["physical-object", "P: 285.2 db", "T: 7.692 C", "S: 34.169", "O: 1.3 ml/l", "L: 81.9 %"] placeAnnotations(): Placing annotation 4: physical-object Ancillary data = ["physical-object", "P: 287.4 db", "T: 7.683 C", "S: 34.171", "O: 1.27 ml/l", "L: 78.3 %"] placeAnnotations(): Placing annotation 5: physical-object Ancillary data = ["physical-object", "P: 287.4 db", "T: 7.684 C", "S: 34.172", "O: 1.26 ml/l", "L: 80.3 %"] placeAnnotations(): Placing annotation 6: physical-object Ancillary data = ["physical-object", "P: 287.5 db", "T: 7.684 C", "S: 34.173", "O: 1.26 ml/l", "L: 80.3 %"] placeAnnotations(): Placing annotation 7: physical-object Ancillary data = ["physical-object", "P: 287.5 db", "T: 7.687 C", "S: 34.172", "O: 1.25 ml/l", "L: 81.1 %"] placeAnnotations(): Placing annotation 8: Ancillary data = ["", "P: 287.5 db", "T: 7.69 C", "S: 34.172", "O: 1.25 ml/l", "L: 79.5 %"] inline_name = vnta3041anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/vnta3041... frameGrabs(): matched 00_00_00_00 in [IMG] 00_00_00_00.jpg 30-Jun-2007 22:02 29k frameGrabs(): matched 00_00_03_12 in [IMG] 00_00_03_12.jpg 30-Jun-2007 22:02 65k frameGrabs(): matched 00_00_04_28 in [IMG] 00_00_04_28.jpg 30-Jun-2007 22:03 66k frameGrabs(): matched 00_05_44_17 in [IMG] 00_05_44_17.jpg 30-Jun-2007 22:03 54k frameGrabs(): matched 00_07_33_14 in [IMG] 00_07_33_14.jpg 30-Jun-2007 22:04 72k frameGrabs(): matched 00_07_54_13 in [IMG] 00_07_54_13.jpg 30-Jun-2007 22:04 73k frameGrabs(): matched 00_16_48_12 in [IMG] 00_16_48_12.jpg 30-Jun-2007 22:05 50k frameGrabs(): matched 00_17_17_11 in [IMG] 00_17_17_11.jpg 30-Jun-2007 22:06 49k iList = 00_00_00_00.jpg 00_00_03_12.jpg 00_00_04_28.jpg 00_05_44_17.jpg 00_07_33_14.jpg 00_07_54_13.jpg 00_16_48_12.jpg 00_17_17_11.jpg _findIndex(): Looking for epoch secs 1183042776 ... Found time 1183042776 after 8 iterations. >>> p = 845: frameGrabs(): index = 845 EXPD::frameGrabs(): 845: Time=1183042770, Depth=282.9, Lat= 36.793032, Lon=-121.843927, Pres=285.2, Temp=7.69, Sal=34.17, O2=1.3, Light=82 _findIndex(): Looking for epoch secs 1183042785 ... Found time 1183042782 after 6 iterations. >>> p = 851: frameGrabs(): index = 851 EXPD::frameGrabs(): 851: Time=1183042785, Depth=282.9, Lat= 36.793032, Lon=-121.843927, Pres=285.2, Temp=7.692, Sal=34.169, O2=1.3, Light=81.9 _findIndex(): Looking for epoch secs 1183042786 ... Found time 1183042782 after 6 iterations. >>> p = 851: frameGrabs(): index = 851 EXPD::frameGrabs(): 851: Time=1183042785, Depth=282.9, Lat= 36.793032, Lon=-121.843927, Pres=285.2, Temp=7.692, Sal=34.169, O2=1.3, Light=81.9 _findIndex(): Looking for epoch secs 1183043127 ... Found time 1183043131 after 4 iterations. >>> p = 1196: frameGrabs(): index = 1196 EXPD::frameGrabs(): 1196: Time=1183043130, Depth=285.1, Lat= 36.793148, Lon=-121.844445, Pres=287.4, Temp=7.683, Sal=34.171, O2=1.27, Light=78.3 _findIndex(): Looking for epoch secs 1183043235 ... Found time 1183043235 after 7 iterations. >>> p = 1299: frameGrabs(): index = 1299 EXPD::frameGrabs(): 1299: Time=1183043235, Depth=285.1, Lat= 36.793102, Lon=-121.844447, Pres=287.4, Temp=7.684, Sal=34.172, O2=1.26, Light=80.3 _findIndex(): Looking for epoch secs 1183043257 ... Found time 1183043259 after 7 iterations. >>> p = 1322: frameGrabs(): index = 1322 EXPD::frameGrabs(): 1322: Time=1183043265, Depth=285.1, Lat= 36.793092, Lon=-121.844453, Pres=287.5, Temp=7.684, Sal=34.173, O2=1.26, Light=80.3 _findIndex(): Looking for epoch secs 1183043790 ... Found time 1183043794 after 7 iterations. >>> p = 1852: frameGrabs(): index = 1852 EXPD::frameGrabs(): 1852: Time=1183043790, Depth=285.1, Lat= 36.793123, Lon=-121.844452, Pres=287.5, Temp=7.687, Sal=34.172, O2=1.25, Light=81.1 _findIndex(): Looking for epoch secs 1183043820 ... Found time 1183043817 after 7 iterations. >>> p = 1875: frameGrabs(): index = 1875 EXPD::frameGrabs(): 1875: Time=1183043820, Depth=285.1, Lat= 36.793107, Lon=-121.844457, Pres=287.5, Temp=7.69, Sal=34.172, O2=1.25, Light=79.5 .\bin\geopdvc.pl: Calling placeImages with every 10 image... inline_name = vnta3041fg10.wrl .\bin\geopdvc.pl: Calling placeImages with every 2 image... placeImages(): Placing image 2 00_00_04_28.jpg 1183042786 fw= 0.0 cm XplaceImages(): Placing image 4 00_07_33_14.jpg 1183043235 fw= 0.0 cm XplaceImages(): Placing image 6 00_16_48_12.jpg 1183043790 fw= 0.0 cm Xinline_name = vnta3041fg02.wrl .\bin\geopdvc.pl: Calling placeImages with every 1 image... placeImages(): Placing image 1 00_00_03_12.jpg 1183042785 fw= 0.0 cm XplaceImages(): Placing image 2 00_00_04_28.jpg 1183042786 fw= 0.0 cm XplaceImages(): Placing image 3 00_05_44_17.jpg 1183043127 fw= 0.0 cm XplaceImages(): Placing image 4 00_07_33_14.jpg 1183043235 fw= 0.0 cm XplaceImages(): Placing image 5 00_07_54_13.jpg 1183043257 fw= 0.0 cm XplaceImages(): Placing image 6 00_16_48_12.jpg 1183043790 fw= 0.0 cm XplaceImages(): Placing image 7 00_17_17_11.jpg 1183043820 fw= 0.0 cm Xinline_name = vnta3041fg01.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 '6/28/2007 2:45:45 PM' AND '6/28/2007 3:32:15 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG .\bin\geopdvc.pl: World = geo2007/vnta/vnta3041.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3678,'/3Dreplay/3D.asp?dives=vnta3041','vnta3041','','','',3041 Executing sql: UPDATE Dive SET DiveLatMid = 36.7930, DiveLonMid = -121.8440, DiveDepthMid = -237.4 WHERE RovName = 'vnta' AND DiveNumber = 3041