Running bin\geopdvc_perseus.pl at Wed Jul 24 16:44:15 2019 on host draco Command line: bin\geopdvc_perseus.pl -rov vnta -dive 4147 bin\geopdvc_perseus.pl: Getting Expedition object for diveno = 4147 and rname = vnta set_expd(): rov = vnta, diveno = 4147 set_expd(): Executing sql: SELECT ExpeditionID_FK, DateDiff(ss, '01/01/70', DiveStartDtg), DateDiff(ss, '01/01/70', DiveEndDtg), DiveStartDtg, DiveEndDtg FROM Dive WHERE DiveNumber = 4147 AND RovName = 'vnta' RS->Fields(0)->Value= 6419 RS->Fields(1)->Value= 1538496426 RS->Fields(2)->Value= 1538515378 RS->Fields(3)->Value= 10/2/2018 4:07:06 PM RS->Fields(4)->Value= 10/2/2018 9:22:58 PM set_expd(): $self->{EndDDD} = 275 set_expd(): $self->{StartEsecs} = 1538495226 set_expd(): $self->{EndEsecs} = 1538516578 set_expd(): $self->{EndDtg} = 10/2/2018 9:22:58 PM _readLogr(): Reading videologr data from 2018275datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1538495226 & 1538516578 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1538516580, self->{EndEsecs} = 1538516578 _readLogr(): #LOGHOST_SYSTEM_UTC = 2134 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1538495230 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1538516570 set_expd(): Calling _refineStartAndEndEsecs... refineStartAndEndEsecs(): LOGHOST_SYSTEM_UTC[0] = 1538495230 refineStartAndEndEsecs(): $LOGHOST_SYSTEM_UTC[end] = 1538516570 refineStartAndEndEsecs(): numMinBack = 22, numMinForward = 22 refineStartAndEndEsecs(): Refined StartEsecs = 1538495106, Refined EndEsecs = 1538516698 _readLogr(): Reading videologr data from 2018275datavislogr.dat.gz. _readLogr(): Expedition start & stop times are 1538495106 & 1538516698 _readLogr(): Flushing variable names: _readLogr(): esecs of file line[0] = 1538516700, self->{EndEsecs} = 1538516698 _readLogr(): #LOGHOST_SYSTEM_UTC = 2158 _readLogr(): $LOGHOST_SYSTEM_UTC[beg] = 1538495110 _readLogr(): $LOGHOST_SYSTEM_UTC[end] = 1538516690 bin\geopdvc_perseus.pl: expdid = 6419 bin\geopdvc_perseus.pl: Calling rovNavCTDO to get raw nav data... rovnavCTDO(): getRaw = 1 rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): 2, getRaw = 1 rovNav(): calcUTM = 0 rovNav(): DDD = 275 (looping to 275) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018275vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018275vnta.txt esecs, east, north, lat, lon, head, pres 1538496927, 0, 0, 36.703235, -122.048712, -19.0, 172.91 1538497427, 0, 0, 36.703453, -122.048647, -29.3, 392.18 1538497927, 0, 0, 36.703490, -122.048558, -173.8, 515.24 1538498427, 0, 0, 36.703243, -122.048527, -153.5, 526.10 1538498927, 0, 0, 36.703172, -122.048385, -153.3, 521.58 1538499427, 0, 0, 36.703138, -122.047890, -169.7, 513.91 1538499927, 0, 0, 36.702948, -122.047567, -176.4, 516.38 1538500427, 0, 0, 36.703010, -122.047263, 166.3, 520.27 1538500927, 0, 0, 36.703018, -122.048052, -115.3, 528.60 1538501428, 0, 0, 36.702457, -122.048960, -157.1, 531.63 1538501928, 0, 0, 36.701963, -122.049443, -174.9, 525.12 1538502428, 0, 0, 36.701010, -122.049447, -179.2, 477.53 1538502928, 0, 0, 36.700805, -122.049638, -120.3, 470.42 1538503428, 0, 0, 36.700720, -122.049890, -152.6, 465.39 1538503928, 0, 0, 36.700770, -122.050437, -149.9, 447.86 1538504428, 0, 0, 36.700743, -122.050847, -113.1, 440.21 1538504928, 0, 0, 36.700508, -122.051702, -140.7, 469.90 1538505429, 0, 0, 36.700443, -122.052077, -138.0, 481.45 1538505929, 0, 0, 36.700502, -122.052085, -151.9, 474.88 1538506429, 0, 0, 36.700342, -122.053028, -109.2, 474.52 1538506929, 0, 0, 36.700317, -122.053257, -136.8, 455.34 1538507429, 0, 0, 36.700198, -122.053405, -137.7, 435.40 1538507929, 0, 0, 36.699977, -122.053758, -160.1, 429.81 1538508429, 0, 0, 36.699840, -122.054133, -178.4, 420.53 1538508929, 0, 0, 36.699710, -122.054168, -172.0, 408.72 1538509429, 0, 0, 36.699405, -122.054605, -143.8, 375.46 1538509930, 0, 0, 36.699218, -122.055097, -141.7, 341.79 1538510430, 0, 0, 36.699328, -122.055362, -157.0, 336.88 1538510930, 0, 0, 36.699310, -122.055620, -153.2, 314.77 1538511430, 0, 0, 36.699128, -122.056273, -123.6, 325.70 1538511930, 0, 0, 36.698875, -122.057357, -127.0, 281.65 1538512430, 0, 0, 36.698973, -122.058863, -74.2, 283.52 1538512930, 0, 0, 36.699902, -122.059873, -128.9, 276.89 1538513430, 0, 0, 36.700333, -122.060562, -136.7, 271.10 1538513930, 0, 0, 36.700707, -122.060968, -118.7, 244.41 1538514430, 0, 0, 36.701137, -122.061000, -124.3, 87.94 1538514931, 0, 0, 36.701858, -122.059792, -90.3, 25.15 rovNav(): 275: 18947 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018275vnta.txt 18947 in tList 18947 in {self->{rovT}} 18947 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1538506005 & 1538509590 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): ......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 437.190047061307 rovGDCListRefs(): dStats->sample_range = 529.728972600596 rovGDCListRefs(): returning (1st elements): 1538496427 36.398835 -122.301908 -20.4 2.680115542905 geopdcv.pl(): editedNav flag = 1 Using mbnavedit edited Navigation. rovnavCTDO(): calcUTM = 0 rovNav(): 1, calcUTM = 0 rovNav(): calcUTM = 0 rovNav(): DDD = 275 (looping to 275) Does file exist?: \\atlas\RovNavEdit\2018\vnta\nav2018275vntaedited.txt yes. EXPD_perseus.pm: editNav flag = rovNav(): Opening ROV nav data from \\atlas\RovNavEdit\2018\vnta\nav2018275vntaedited.txt esecs, east, north, lat, lon, head, pres 1538496927, 0, 0, 36.703248, -122.048724, 341.0, 172.91 1538497427, 0, 0, 36.703447, -122.048630, 330.7, 392.18 1538497927, 0, 0, 36.703490, -122.048571, 186.2, 515.24 1538498427, 0, 0, 36.703239, -122.048541, 206.5, 526.10 1538498927, 0, 0, 36.703171, -122.048402, 206.7, 521.58 1538499427, 0, 0, 36.703133, -122.047886, 190.3, 513.91 1538499927, 0, 0, 36.702951, -122.047548, 183.6, 516.38 1538500427, 0, 0, 36.703012, -122.047257, 166.3, 520.27 1538500927, 0, 0, 36.702993, -122.048103, 244.7, 528.60 1538501428, 0, 0, 36.702466, -122.048961, 202.9, 531.63 1538501928, 0, 0, 36.701975, -122.049462, 185.1, 525.12 1538502428, 0, 0, 36.701021, -122.049426, 180.8, 477.53 1538502928, 0, 0, 36.700794, -122.049627, 239.7, 470.42 1538503428, 0, 0, 36.700746, -122.049869, 207.4, 465.39 1538503928, 0, 0, 36.700765, -122.050435, 210.1, 447.86 1538504428, 0, 0, 36.700742, -122.050828, 246.9, 440.21 1538504928, 0, 0, 36.700502, -122.051697, 219.3, 469.90 1538505429, 0, 0, 36.700437, -122.052070, 222.0, 481.45 1538505929, 0, 0, 36.700502, -122.052072, 208.1, 474.88 1538506429, 0, 0, 36.700362, -122.052972, 250.8, 474.52 1538506929, 0, 0, 36.700319, -122.053252, 223.2, 455.34 1538507429, 0, 0, 36.700188, -122.053387, 222.3, 435.40 1538507929, 0, 0, 36.699931, -122.053720, 199.9, 429.81 1538508429, 0, 0, 36.699829, -122.054104, 181.6, 420.53 1538508929, 0, 0, 36.699707, -122.054164, 188.0, 408.72 1538509429, 0, 0, 36.699376, -122.054598, 216.2, 375.46 1538509930, 0, 0, 36.699215, -122.055088, 218.3, 341.79 1538510430, 0, 0, 36.699335, -122.055395, 203.0, 336.88 1538510930, 0, 0, 36.699316, -122.055598, 206.8, 314.77 1538511430, 0, 0, 36.699129, -122.056292, 236.4, 325.70 1538511930, 0, 0, 36.698826, -122.057206, 233.0, 281.65 1538512430, 0, 0, 36.698972, -122.058813, 285.8, 283.52 1538512930, 0, 0, 36.699860, -122.059910, 231.1, 276.89 1538513430, 0, 0, 36.700260, -122.060579, 223.3, 271.10 1538513930, 0, 0, 36.700690, -122.060965, 241.3, 244.41 1538514430, 0, 0, 36.701116, -122.060960, 235.7, 87.94 1538514931, 0, 0, 36.701884, -122.059795, 269.7, 25.15 rovNav(): 275: 18947 in tList after reading from \\atlas\RovNavEdit\2018\vnta\nav2018275vntaedited.txt 18947 in tList 18947 in {self->{rovT}} 18947 in {self->{rovH}} rovCTDO(): ROV CTDO start & stop times are 1538507265 & 1538508135 rovNavCTDO(): Looking up ROVCTDO data ('.'found, 'X' exceeds max iter.): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/275/accesses.txt at bin\geopdvc_perseus.pl line 2386. .....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................XXXXXXXX rovGDCListRefs(): dMedian = 437.190046887384 rovGDCListRefs(): dStats->sample_range = 529.729041395887 rovGDCListRefs(): returning (1st elements): 1538496427 36.702474 -122.048932 339.6 2.68004371264537 bin\geopdvc_perseus.pl: ------------------------------------------------------------------------------- hash{lat} = 36.70071800 hash{lon} = -122.05210200 latMin = 30.700718 latMax = 42.700718 Executing sql: SELECT Area, Latitude, Longitude FROM GeoOrigin WHERE Latitude BETWEEN 30.700718 AND 42.700718 AND Longitude BETWEEN -128.052102 AND -116.052102 Dive lat = 36.70071800, area = cencal bin\geopdvc_perseus.pl: Found area = cencal in GeoOrigin For midpoint lon = -122.05210200 & lat = 36.70071800 Using olon = -122 & olat = 36 bin\geopdvc_perseus.pl: Calling makeROVorig... inline_name = vnta4147rov_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 = geo2018/vnta/vnta4147lookup.wrl bin\geopdvc_perseus.pl: Getting ship nav... shipNav(): selecting for ShipName = rcsn shipNav(): WARNING: no match for ShipName = rcsn shipNav(): $#{$self->{shipLat}} = 2158 shipNav(): $#{$self->{shipLat}}[last] = 36.725049 Position subsampling set to 15 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 = 18948 makeTracks(): Looping through 2158 point of ship position data.frameGrabs(): Can't get http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/275/accesses.txt at bin\geopdvc_perseus.pl line 629. .. makeTracks(): posSubsample = 15 makeTracks(): Writing tracks file... makeTracks(): INFO $sname = inline_name = vnta4147tracks.wrl writeCtdPosFile(): Writing merged CTD Nav data to geo2018/vnta/vnta4147mergedCtdNav.txt... bin\geopdvc_perseus.pl: Annotations: annotations(): Executing sql: SELECT DISTINCT DateDiff(ss, '01/01/70', RecordedDate) AS Esecs, CONVERT(CHAR(8), RecordedDate, 1) + ' ' + SUBSTRING(CONVERT(CHAR(19), RecordedDate, 120), 12, 8) AS DateTime, VideoArchiveName AS TapeNum, TapeTimeCode, ConceptName, Image AS StillImageURL, Depth, Latitude, Longitude, CameraDirection AS Direction, ISNULL(Observer, '') AS Observer, AnnotationMode, ObservationID_FK AS ObservationID FROM dbo.Annotations WHERE (ShipName = '') AND (RecordedDate BETWEEN '10/2/2018 4:07:06 PM' AND '10/2/2018 9:22:58 PM') OR (RovName = 'Ventana') AND (RecordedDate BETWEEN '10/2/2018 4:07:06 PM' AND '10/2/2018 9:22:58 PM') bin\geopdvc_perseus.pl: Calling placeAnnotations with every 10 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 2 annotation... bin\geopdvc_perseus.pl: Calling placeAnnotations with every 1 annotation... frameGrabs(): Getting images from http://search.mbari.org/ARCHIVE/frameGrabs/Ventana/stills/2018/vnta4147... iList = bin\geopdvc_perseus.pl: Number of images returned from expd->frameGrabs(every=>1)} = 0 bin\geopdvc_perseus.pl: Calling placeImages with every 10 image... bin\geopdvc_perseus.pl: Calling placeImages with every 2 image... bin\geopdvc_perseus.pl: Calling placeImages with every 1 image... bin\geopdvc_perseus.pl: Samples: samples(): Executing sql: SELECT DateDiff(ss, '01/01/70', CollectionEventDtg) AS Esecs, CollectionVIMSConcept, FrameGrabImageURL, SampleID, CollectionRefName FROM vwCollSamplePerson WHERE (CollectionEventDTG BETWEEN '10/2/2018 4:07:06 PM' AND '10/2/2018 9:22:58 PM') AND ROVName = 'Ventana' ORDER BY CollectionEventDTG bin\geopdvc_perseus.pl: World = geo2018/vnta/vnta4147.wrl Adding record to ExpeditionData table... Executing sql: exec insertExpeditionData '3Dreplay','','',6419,'/3Dreplay/3D.asp?dives=vnta4147','vnta4147','','','',4147 Executing sql: UPDATE Dive SET DiveLatMid = 36.7007, DiveLonMid = -122.0521, DiveDepthMid = -437.2 WHERE RovName = 'vnta' AND DiveNumber = 4147