Running bin\geopdvc.pl at Sun Dec 16 03:01:22 2007 on host solstice Command line: bin\geopdvc.pl -rov vnta -dive 3111 bin\geopdvc.pl: Getting Expedition object for diveno = 3111 and rname = vnta set_expd(): rov = vnta, diveno = 3111 set_expd(): $self->{EndDDD} = 291 set_expd(): $self->{StartEsecs} = 1192736670 set_expd(): $self->{EndEsecs} = 1192741995 set_expd(): $self->{EndDtg} = 10/18/2007 8:53:15 PM _readLogr(): Reading videologr data from 2007291datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1192736670 & 1192741995 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 531 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1192736672 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1192741987 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1192736672 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1192741987 refineStartAndEndEsecs(): setting StartEsecs to 1192736670 refineStartAndEndEsecs(): setting EndEsecs to 1192737643 refineStartAndEndEsecs(): numMinBack = 5.78333333333333, numMinForward = 19.7 refineStartAndEndEsecs(): Refined StartEsecs = 1192737523, Refined EndEsecs = 1192741977 _readLogr(): Reading videologr data from 2007291datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1192737523 & 1192741977 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 444 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1192737532 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1192741977 bin\geopdvc.pl: expdid = 3759 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 291 (looping to 291) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007291vnta.txt esecs, east, north, lat, lon, head, pres 1192737797, 0, 0, 36.793688, -121.845030, 349.1, 2.44 1192738338, 0, 0, 36.793063, -121.845118, 15.4, 183.48 1192738843, 0, 0, 36.793332, -121.845367, 162.4, 294.50 1192739348, 0, 0, 36.793282, -121.845317, 108.2, 293.02 1192739853, 0, 0, 36.793268, -121.845307, 146.8, 293.08 1192740358, 0, 0, 36.792953, -121.846017, 266.9, 178.10 291: 2998 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007291vnta.txt rovNav(): Initial # seconds to fill at beginning of dive = 234 starting at StartEsecs = 1192737523 rovNav(): Initial # seconds to fill at end of dive = 1015 ending at EndEsecs =1192741977 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1192737532 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1192741977 rovNav(): numMinBack = 5.63333333333333, numMinForward = 19.7 rovNav(): Refined StartEsecs = 1192737523, Refined EndEsecs = 1192741977 rovNav(): Refined # seconds to fill at beginning of dive = 234 starting at StartEsecs = 1192737523 rovNav(): Refined # seconds to fill at end of dive = 1015 ending at EndEsecs =1192741977 rovNav(): num tList = 2998 rovNav(): num eList = 2998 rovNav(): Adding data to begining of dive from logr indices 0 .. 22 rovNav(): Adding data to end of dive from logr indices 343 .. 444 rovNav(): num in tList now = 3123 rovNav(): num in eList now = 3123 3123 in tList 3123 in {self->{rovT}} 3123 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1192739250 & 1192740045 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 = 291 (looping to 291) rovNav(): Opening ROV nav data from \\tornado\TempNav\2007\vnta\nav2007291vnta.txt esecs, east, north, lat, lon, head, pres 1192737797, 0, 0, 36.793688, -121.845030, 349.1, 2.44 1192738338, 0, 0, 36.793063, -121.845118, 15.4, 183.48 1192738843, 0, 0, 36.793332, -121.845367, 162.4, 294.50 1192739348, 0, 0, 36.793282, -121.845317, 108.2, 293.02 1192739853, 0, 0, 36.793268, -121.845307, 146.8, 293.08 1192740358, 0, 0, 36.792953, -121.846017, 266.9, 178.10 291: 2998 in tList after reading from \\tornado\TempNav\2007\vnta\nav2007291vnta.txt 2998 in tList 2998 in {self->{rovT}} 2998 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1192739250 & 1192740045 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXX........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/291/accesses.txt at bin\geopdvc.pl line 2188 .............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.79327300 hash{lon} = -121.84535700 latMin = 30.793273 latMax = 42.793273 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.793273 AND 42.793273 AND Longitude BETWEEN -127.845357 AND -115.845357 Dive lat = 36.79327300, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -121.84535700 & lat = 36.79327300 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta3111rov_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/vnta3111lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 444 shipNav(): $#{$self->{shipLat}}[last] = 36.793782 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 = 3124 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta3111tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2007/vnta/vnta3111mergedCtdNav.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/18/2007 8:04:30 PM' AND '10/18/2007 8:53:15 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/18/2007 8:04:30 PM' AND '10/18/2007 8:53:15 PM') _findIndex(): Looking for epoch secs 1192738658 ... Found time 1192738654 after 7 iterations. >>> p = 853: annotations(): 853, 1192738658, 10/18/07 20:17:38, V3111-01, 03:46:33:20, vibracorer, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3111/03_46_33_20.jpg, 291.660003662109, descend, lonny, o, 20021796 _findIndex(): Looking for epoch secs 1192738694 ... Found time 1192738690 after 5 iterations. >>> p = 889: annotations(): 889, 1192738694, 10/18/07 20:18:14, V3111-01, 03:47:10:29, merluccius-productus, , 292.619995117188, cruise, lonny, o, 2315879 _findIndex(): Looking for epoch secs 1192738723 ... Found time 1192738726 after 7 iterations. >>> p = 924: annotations(): 924, 1192738723, 10/18/07 20:18:43, V3111-01, 03:47:39:15, merluccius-productus, , 292.730010986328, cruise, lonny, o, 2315880 _findIndex(): Looking for epoch secs 1192738743 ... Found time 1192738738 after 3 iterations. >>> p = 936: annotations(): 936, 1192738743, 10/18/07 20:19:03, V3111-01, 03:47:59:12, water, , 292.790008544922, cruise, lonny, o, 2315881 _findIndex(): Looking for epoch secs 1192738799 ... Found time 1192738796 after 7 iterations. >>> p = 994: annotations(): 994, 1192738799, 10/18/07 20:19:59, V3111-01, 03:48:55:28, osteichthyes, , 292.320007324219, cruise, lonny, o, 2315882 _findIndex(): Looking for epoch secs 1192738867 ... Found time 1192738868 after 7 iterations. >>> p = 1065: annotations(): 1065, 1192738867, 10/18/07 20:21:07, V3111-01, 03:50:04:23, metridium-farcimen, , 291.570007324219, cruise, lonny, o, 2315887 _findIndex(): Looking for epoch secs 1192738883 ... Found time 1192738880 after 5 iterations. >>> p = 1077: annotations(): 1077, 1192738883, 10/18/07 20:21:23, V3111-01, 03:50:19:06, metridium-farcimen, , 291.25, cruise, lonny, o, 2315890 _findIndex(): Looking for epoch secs 1192739028 ... Found time 1192739033 after 7 iterations. >>> p = 1228: annotations(): 1228, 1192739028, 10/18/07 20:23:48, V3111-01, 03:52:44:10, nanomia, , 289.359985351563, cruise, lonny, o, 2315903 _findIndex(): Looking for epoch secs 1192739239 ... Found time 1192739235 after 6 iterations. >>> p = 1428: annotations(): 1428, 1192739239, 10/18/07 20:27:19, V3111-01, 03:56:15:10, mud, http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/images/3111/03_56_15_10.jpg, 290.690002441406, stationary, lonny, o, 2315908 _findIndex(): Looking for epoch secs 1192739858 ... Found time 1192739861 after 7 iterations. >>> p = 2048: annotations(): 2048, 1192739858, 10/18/07 20:37:38, V3111-01, 04:06:34:08, water, , 290.679992675781, stationary, lonny, o, 2315935 _findIndex(): Looking for epoch secs 1192739973 ... Found time 1192739968 after 4 iterations. >>> p = 2154: annotations(): 2154, 1192739973, 10/18/07 20:39:33, V3111-01, 04:08:29:09, apristurus-kampae, , 290.609985351563, ascend, lonny, o, 2315952 _findIndex(): Looking for epoch secs 1192740160 ... Found time 1192740157 after 4 iterations. >>> p = 2341: annotations(): 2341, 1192740160, 10/18/07 20:42:40, V3111-01, 04:11:36:09, nanomia, , 254.490005493164, ascend, lonny, o, 2315999 _findIndex(): Looking for epoch secs 1192740162 ... Found time 1192740157 after 4 iterations. >>> p = 2341: annotations(): 2341, 1192740162, 10/18/07 20:42:42, V3111-01, 04:11:37:22, mysida, , 253.539993286133, ascend, lonny, o, 2316003 _findIndex(): Looking for epoch secs 1192740431 ... Found time 1192740430 after 7 iterations. >>> p = 2611: annotations(): 2611, 1192740431, 10/18/07 20:47:11, V3111-01, 04:16:05:26, aurelia, , 148.919998168945, ascend, lonny, o, 2316032 _findIndex(): Looking for epoch secs 1192740610 ... Found time 1192740607 after 6 iterations. >>> p = 2786: annotations(): 2786, 1192740610, 10/18/07 20:50:10, V3111-01, 04:19:04:07, aurelia, , 85.8499984741211, ascend, lonny, o, 2316055 _findIndex(): Looking for epoch secs 1192740658 ... Found time 1192740654 after 6 iterations. >>> p = 2833: annotations(): 2833, 1192740658, 10/18/07 20:50:58, V3111-01, 04:19:52:12, aurelia, , 67.1900024414063, ascend, lonny, o, 2316061 _findIndex(): Looking for epoch secs 1192740735 ... Found time 1192740737 after 7 iterations. >>> p = 2915: annotations(): 2915, 1192740735, 10/18/07 20:52:15, V3111-01, 04:21:09:09, lights, , 36.439998626709, ascend, lonny, o, 2316068 _findIndex(): Looking for epoch secs 1192740759 ... Found time 1192740761 after 7 iterations. >>> p = 2939: annotations(): 2939, 1192740759, 10/18/07 20:52:39, V3111-01, 04:21:33:18, surface-water, , 26.2900009155273, ascend, lonny, o, 2316074 bin\geopdvc.pl: Calling placeAnnotations with every 10 annotation... placeAnnotations(): Placing annotation 10: apristurus-kampae Ancillary data = ["apristurus-kampae", "P: 291.3 db", "T: 8.067 C", "S: 34.151", "O: 1.24 ml/l", "L: 79.9 %"] inline_name = vnta3111anno10.wrl bin\geopdvc.pl: Calling placeAnnotations with every 2 annotation... placeAnnotations(): Placing annotation 2: merluccius-productus Ancillary data = ["merluccius-productus", "P: 293.3 db", "T: 8.046 C", "S: 34.147", "O: 1.26 ml/l", "L: 80.3 %"] placeAnnotations(): Placing annotation 4: osteichthyes Ancillary data = ["osteichthyes", "P: 293.8 db", "T: 8.024 C", "S: 34.151", "O: 1.25 ml/l", "L: 77.8 %"] placeAnnotations(): Placing annotation 6: metridium-farcimen Ancillary data = ["metridium-farcimen", "P: 291.9 db", "T: 8.054 C", "S: 34.147", "O: 1.25 ml/l", "L: 80.4 %"] placeAnnotations(): Placing annotation 8: mud Ancillary data = ["mud", "P: 291.2 db", "T: 8.049 C", "S: 34.148", "O: 1.25 ml/l", "L: 80.7 %"] placeAnnotations(): Placing annotation 10: apristurus-kampae Ancillary data = ["apristurus-kampae", "P: 291.3 db", "T: 8.067 C", "S: 34.151", "O: 1.24 ml/l", "L: 79.9 %"] placeAnnotations(): Placing annotation 12: mysida Ancillary data = ["mysida", "P: 258.2 db", "T: 8.417 C", "S: 34.121", "O: 1.37 ml/l", "L: 82.4 %"] placeAnnotations(): Placing annotation 14: aurelia Ancillary data = ["aurelia", "P: 145.8 db", "T: 9.275 C", "S: 34.016", "O: 1.8 ml/l", "L: 82.1 %"] placeAnnotations(): Placing annotation 16: lights Ancillary data = ["lights", "P: 64.4 db", "T: 10.793 C", "S: 33.81", "O: 3.19 ml/l", "L: 83.3 %"] placeAnnotations(): Placing annotation 18: Ancillary data = ["", "P: 21.9 db", "T: 12.79 C", "S: 33.477", "O: 5.46 ml/l", "L: 85.1 %"] inline_name = vnta3111anno02.wrl bin\geopdvc.pl: Calling placeAnnotations with every 1 annotation... placeAnnotations(): Placing annotation 1: merluccius-productus Ancillary data = ["merluccius-productus", "P: 292.8 db", "T: 8.028 C", "S: 34.149", "O: 1.26 ml/l", "L: 80.1 %"] placeAnnotations(): Placing annotation 2: merluccius-productus Ancillary data = ["merluccius-productus", "P: 293.3 db", "T: 8.046 C", "S: 34.147", "O: 1.26 ml/l", "L: 80.3 %"] placeAnnotations(): Placing annotation 3: water Ancillary data = ["water", "P: 293.7 db", "T: 8.029 C", "S: 34.149", "O: 1.25 ml/l", "L: 80.1 %"] placeAnnotations(): Placing annotation 4: osteichthyes Ancillary data = ["osteichthyes", "P: 293.8 db", "T: 8.024 C", "S: 34.151", "O: 1.25 ml/l", "L: 77.8 %"] placeAnnotations(): Placing annotation 5: metridium-farcimen Ancillary data = ["metridium-farcimen", "P: 293.2 db", "T: 8.048 C", "S: 34.147", "O: 1.25 ml/l", "L: 80.3 %"] placeAnnotations(): Placing annotation 6: metridium-farcimen Ancillary data frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/291/accesses.txt at bin\geopdvc.pl line 554 = ["metridium-farcimen", "P: 291.9 db", "T: 8.054 C", "S: 34.147", "O: 1.25 ml/l", "L: 80.4 %"] placeAnnotations(): Placing annotation 7: nanomia Ancillary data = ["nanomia", "P: 291.9 db", "T: 8.054 C", "S: 34.147", "O: 1.25 ml/l", "L: 80.4 %"] placeAnnotations(): Placing annotation 8: mud Ancillary data = ["mud", "P: 291.2 db", "T: 8.049 C", "S: 34.148", "O: 1.25 ml/l", "L: 80.7 %"] placeAnnotations(): Placing annotation 9: water Ancillary data = ["water", "P: 291.3 db", "T: 8.049 C", "S: 34.149", "O: 1.25 ml/l", "L: 80.9 %"] placeAnnotations(): Placing annotation 10: apristurus-kampae Ancillary data = ["apristurus-kampae", "P: 291.3 db", "T: 8.067 C", "S: 34.151", "O: 1.24 ml/l", "L: 79.9 %"] placeAnnotations(): Placing annotation 11: nanomia Ancillary data = ["nanomia", "P: 291.1 db", "T: 8.088 C", "S: 34.149", "O: 1.25 ml/l", "L: 80.3 %"] placeAnnotations(): Placing annotation 12: mysida Ancillary data = ["mysida", "P: 258.2 db", "T: 8.417 C", "S: 34.121", "O: 1.37 ml/l", "L: 82.4 %"] placeAnnotations(): Placing annotation 13: aurelia Ancillary data = ["aurelia", "P: 258.2 db", "T: 8.417 C", "S: 34.121", "O: 1.37 ml/l", "L: 82.4 %"] placeAnnotations(): Placing annotation 14: aurelia Ancillary data = ["aurelia", "P: 145.8 db", "T: 9.275 C", "S: 34.016", "O: 1.8 ml/l", "L: 82.1 %"] placeAnnotations(): Placing annotation 15: aurelia Ancillary data = ["aurelia", "P: 87.5 db", "T: 10.393 C", "S: 33.869", "O: 2.74 ml/l", "L: 80 %"] placeAnnotations(): Placing annotation 16: lights Ancillary data = ["lights", "P: 64.4 db", "T: 10.793 C", "S: 33.81", "O: 3.19 ml/l", "L: 83.3 %"] placeAnnotations(): Placing annotation 17: surface-water Ancillary data = ["surface-water", "P: 33.8 db", "T: 12.083 C", "S: 33.556", "O: 4.86 ml/l", "L: 86.1 %"] placeAnnotations(): Placing annotation 18: Ancillary data = ["", "P: 21.9 db", "T: 12.79 C", "S: 33.477", "O: 5.46 ml/l", "L: 85.1 %"] inline_name = vnta3111anno01.wrl frameGrabs(): Getting images from http://dods.mbari.org/data/frameGrabs/Ventana/stills/2007/vnta3111... frameGrabs(): matched 03_46_33_20 in [IMG] 03_46_33_20.jpg 21-Nov-2007 21:57 55k iList = 03_46_33_20.jpg _findIndex(): Looking for epoch secs 1192738658 ... Found time 1192738654 after 7 iterations. >>> p = 853: frameGrabs(): index = 853 EXPD::frameGrabs(): 853: Time=1192738650, Depth=290.4, Lat= 36.793037, Lon=-121.845738, Pres=292.8, Temp=8.028, Sal=34.149, O2=1.26, Light=80.1 bin\geopdvc.pl: Calling placeImages with every 10 image... inline_name = vnta3111fg10.wrl bin\geopdvc.pl: Calling placeImages with every 2 image... inline_name = vnta3111fg02.wrl bin\geopdvc.pl: Calling placeImages with every 1 image... inline_name = vnta3111fg01.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/18/2007 8:04:30 PM' AND '10/18/2007 8:53:15 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc.pl: World = geo2007/vnta/vnta3111.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',3759,'/3Dreplay/3D.asp?dives=vnta3111','vnta3111','','','',3111 Executing sql: UPDATE Dive SET DiveLatMid = 36.7933, DiveLonMid = -121.8454, DiveDepthMid = -270.0 WHERE RovName = 'vnta' AND DiveNumber = 3111