Running bin\geopdvc.pl at Mon Aug 27 17:45:54 2007 on host scyphozoan Command line: bin\geopdvc.pl -rov vnta -dive 2758 bin\geopdvc.pl: Getting Expedition object for diveno = 2758 and rname = vnta set_expd(): rov = vnta, diveno = 2758 set_expd(): $self->{EndDDD} = 315 set_expd(): $self->{StartEsecs} = 1131727275 set_expd(): $self->{EndEsecs} = 1131751080 set_expd(): $self->{EndDtg} = 11/11/2005 10:58:00 PM _readLogr(): Reading videologr data from 2005315datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1131727275 & 1131751080 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2377 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1131727285 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1131751079 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1131727285 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1131751079 refineStartAndEndEsecs(): setting StartEsecs to 1131727275 refineStartAndEndEsecs(): setting EndEsecs to 1131727706 refineStartAndEndEsecs(): numMinBack = 14.8166666666667, numMinForward = 11.9833333333333 refineStartAndEndEsecs(): Refined StartEsecs = 1131727586, Refined EndEsecs = 1131750599 _readLogr(): Reading videologr data from 2005315datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1131727586 & 1131750599 _readLogr(): Flushing variable names: _readLogr(): #LOGHOST_SYSTEM_UTC = 2298 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1131727595 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1131750599 bin\geopdvc.pl: expdid = 3326 Using raw Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 315 (looping to 315) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005315vntaedited.txt esecs, east, north, lat, lon, head, pres 1131728844, 0, 0, 36.700413, -122.049537, 37.1, 102.50 1131729349, 0, 0, 36.702052, -122.049874, 129.7, 91.49 1131729854, 0, 0, 36.703030, -122.050232, 227.5, 172.10 1131730359, 0, 0, 36.703523, -122.050659, 160.9, 190.59 1131730864, 0, 0, 36.703502, -122.050611, 224.4, 209.50 1131731369, 0, 0, 36.703690, -122.050522, 180.5, 222.09 1131731874, 0, 0, 36.703408, -122.050843, 214.5, 253.06 1131732379, 0, 0, 36.703168, -122.051190, 188.8, 261.39 1131732884, 0, 0, 36.703389, -122.050940, 334.2, 240.63 1131733389, 0, 0, 36.702941, -122.051865, 183.4, 231.71 1131733894, 0, 0, 36.702579, -122.052029, 194.3, 212.15 1131734399, 0, 0, 36.702443, -122.052535, 200.7, 147.65 1131734905, 0, 0, 36.701979, -122.052817, 186.4, 77.17 1131735410, 0, 0, 36.702040, -122.053176, 204.8, 153.28 1131735915, 0, 0, 36.702638, -122.053177, 174.7, 198.27 1131736420, 0, 0, 36.702538, -122.052962, 175.1, 260.61 1131736925, 0, 0, 36.701069, -122.052546, 182.0, 390.01 1131737430, 0, 0, 36.700175, -122.052511, 192.5, 476.68 1131737935, 0, 0, 36.699811, -122.052530, 195.4, 508.41 1131738440, 0, 0, 36.699921, -122.052500, 114.5, 503.40 1131738945, 0, 0, 36.700089, -122.052394, 198.9, 496.64 1131739450, 0, 0, 36.700314, -122.052191, 182.5, 488.24 1131739955, 0, 0, 36.699432, -122.052707, 219.4, 565.50 1131740460, 0, 0, 36.698337, -122.053085, 186.0, 628.89 1131740965, 0, 0, 36.697799, -122.053263, 185.9, 704.07 1131741470, 0, 0, 36.697482, -122.053444, 180.3, 722.68 1131741975, 0, 0, 36.696815, -122.053646, 189.5, 765.13 1131742480, 0, 0, 36.695970, -122.053894, 191.9, 810.30 1131742985, 0, 0, 36.694925, -122.053927, 194.9, 807.46 1131743490, 0, 0, 36.694502, -122.053918, 176.2, 806.23 1131743995, 0, 0, 36.693848, -122.053225, 107.9, 790.14 1131744500, 0, 0, 36.693724, -122.051142, 99.9, 686.42 1131745005, 0, 0, 36.693400, -122.049427, 109.4, 620.11 1131745510, 0, 0, 36.692987, -122.047793, 123.3, 601.47 1131746015, 0, 0, 36.692934, -122.047354, 114.1, 574.60 1131746520, 0, 0, 36.692783, -122.044696, 97.7, 509.19 1131747025, 0, 0, 36.692639, -122.043489, 114.2, 477.43 1131747530, 0, 0, 36.692288, -122.042082, 111.2, 419.68 1131748035, 0, 0, 36.692737, -122.041178, 20.4, 348.63 1131748540, 0, 0, 36.693920, -122.041023, 20.1, 256.85 1131749045, 0, 0, 36.694919, -122.040649, 21.0, 152.72 1131749550, 0, 0, 36.696511, -122.040531, 21.6, 17.81 315: 21346 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005315vntaedited.txt rovNav(): Initial # seconds to fill at beginning of dive = 748 starting at StartEsecs = 1131727586 rovNav(): Initial # seconds to fill at end of dive = 525 ending at EndEsecs =1131750599 rovNav(): LOGHOST_SYSTEM_UTC[0] = 1131727595 rovNav(): $LOGHOST_SYSTEM_UTC[end] = 1131750599 rovNav(): numMinBack = 14.6666666666667, numMinForward = 11.9833333333333 rovNav(): Refined StartEsecs = 1131727586, Refined EndEsecs = 1131750599 rovNav(): Refined # seconds to fill at beginning of dive = 748 starting at StartEsecs = 1131727586 rovNav(): Refined # seconds to fill at end of dive = 525 ending at EndEsecs =1131750599 rovNav(): num tList = 21346 rovNav(): num eList = 21346 rovNav(): Adding data to begining of dive from logr indices 0 .. 73 rovNav(): Adding data to end of dive from logr indices 2246 .. 2298 rovNav(): num in tList now = 21473 rovNav(): num in eList now = 21473 21473 in tList 21473 in {self->{rovT}} 21473 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1131736620 & 1131744450 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 = 315 (looping to 315) rovNav(): Opening ROV nav data from \\tornado\TempNav\2005\vnta\nav2005315vnta.txt esecs, east, north, lat, lon, head, pres 1131728844, 0, 0, 36.700405, -122.049530, 37.1, 102.50 1131729349, 0, 0, 36.702053, -122.049880, 129.7, 91.49 1131729854, 0, 0, 36.703073, -122.050245, 227.5, 172.10 1131730359, 0, 0, 36.703585, -122.050665, 160.9, 190.59 1131730864, 0, 0, 36.697227, -122.042975, 224.4, 209.50 1131731369, 0, 0, 36.703680, -122.050515, 180.5, 222.09 1131731874, 0, 0, 36.703392, -122.050883, 214.5, 253.06 1131732379, 0, 0, 36.703190, -122.051205, 188.8, 261.39 1131732884, 0, 0, 36.703408, -122.050930, 334.2, 240.63 1131733389, 0, 0, 36.702923, -122.051868, 183.4, 231.71 1131733894, 0, 0, 36.702550, -122.052033, 194.3, 212.15 1131734399, 0, 0, 36.702442, -122.052550, 200.7, 147.65 1131734905, 0, 0, 36.701983, -122.052800, 186.4, 77.17 1131735410, 0, 0, 36.702033, -122.053157, 204.8, 153.28 1131735915, 0, 0, 36.702623, -122.053175, 174.7, 198.27 1131736420, 0, 0, 36.702553, -122.052968, 175.1, 260.61 1131736925, 0, 0, 36.701048, -122.052577, 182.0, 390.01 1131737430, 0, 0, 36.700177, -122.052497, 192.5, 476.68 1131737935, 0, 0, 36.699810, -122.052513, 195.4, 508.41 1131738440, 0, 0, 36.699913, -122.052500, 114.5, 503.40 1131738945, 0, 0, 36.700092, -122.052388, 198.9, 496.64 1131739450, 0, 0, 36.700325, -122.052197, 182.5, 488.24 1131739955, 0, 0, 36.699420, -122.052705, 219.4, 565.50 1131740460, 0, 0, 36.698320, -122.053073, 186.0, 628.89 1131740965, 0, 0, 36.697790, -122.053248, 185.9, 704.07 1131741470, 0, 0, 36.697477, -122.053488, 180.3, 722.68 1131741975, 0, 0, 36.696817, -122.053633, 189.5, 765.13 1131742480, 0, 0, 36.695968, -122.053952, 191.9, 810.30 1131742985, 0, 0, 36.694907, -122.053917, 194.9, 807.46 1131743490, 0, 0, 36.694508, -122.053933, 176.2, 806.23 1131743995, 0, 0, 36.693848, -122.053233, 107.9, 790.14 1131744500, 0, 0, 36.693735, -122.051163, 99.9, 686.42 1131745005, 0, 0, 36.693398, -122.049407, 109.4, 620.11 1131745510, 0, 0, 36.692985, -122.047788, 123.3, 601.47 1131746015, 0, 0, 36.692930, -122.047383, 114.1, 574.60 1131746520, 0, 0, 36.692775, -122.044680, 97.7, 509.19 1131747025, 0, 0, 36.692645, -122.043487, 114.2, 477.43 1131747530, 0, 0, 36.692287, -122.042080, 111.2, 419.68 1131748035, 0, 0, 36.692717, -122.041173, 20.4, 348.63 1131748540, 0, 0, 36.693905, -122.041030, 20.1, 256.85 1131749045, 0, 0, 36.694922, -122.040643, 21.0, 152.72 1131749550, 0, 0, 36.696525, -122.040522, 21.6, 17.81 315: 21346 in tList after reading from \\tornado\TempNav\2005\vnta\nav2005315vnta.txt 21346 in tList 21346 in {self->{rovT}} 21346 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1131736620 & 1131744450 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX bin\geopdvc.pl: ------------------------------------------------------------------------------- hash{lat} = 36.69982700 hash{lon} = -122.05190300 latMin = 30.699827 latMax = 42.699827 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.699827 AND 42.699827 AND Longitude BETWEEN -128.051903 AND -116.051903 Dive lat = 36.69982700, area = cencal bin\geopdvc.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05190300 & lat = 36.69982700 Using olon = -122 & olat = 36 bin\geopdvc.pl: Calling makeROVorig... inline_name = vnta2758rov_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 = frameGrabs(): Can't get http://dods.mbari.org/data/frameGrabs/Ventana/stills/2005/315/accesses.txt at bin\geopdvc.pl line 2169 at bin\geopdvc.pl line 542 10, color = 0 1 0 val = 15, color = 1 0 0 World = geo2005/vnta/vnta2758lookup.wrl bin\geopdvc.pl: Getting ship nav... shipNav(): $#{$self->{shipLat}} = 2298 shipNav(): $#{$self->{shipLat}}[last] = 36.705160 Position subsampling set to 17 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 = 21474 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta2758tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2005/vnta/vnta2758mergedCtdNav.txt... bin\geopdvc.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '11/11/2005 5:01:15 PM' AND '11/11/2005 10:58:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/11/2005 5:01:15 PM' AND '11/11/2005 10:58:00 PM') Empty Return Set: RS from: Server=solstice;Database=expd;UID=everyone;PWD=guest; for: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '11/11/2005 5:01:15 PM' AND '11/11/2005 10:58:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/11/2005 5:01:15 PM' AND '11/11/2005 10:58:00 PM') annotations(): Error in query: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, FormatCode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = 'Point Lobos') AND (RecordedDate BETWEEN '11/11/2005 5:01:15 PM' AND '11/11/2005 10:58:00 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '11/11/2005 5:01:15 PM' AND '11/11/2005 10:58:00 PM') from Server=solstice;Database=VARS;UID=everyone;PWD=guest; Invalid column name 'FormatCode'.