! 08/24/05 carolyn /infobank/m/m505nc/samp/m-5-05-nc.onoff.grabs.grab ! time/lat/long style, multi-record, in caps, without tabs ! (Year, Day, Hour, Min, Sec, Tenths, Lat, Long, ActivityID, EquipmentType, Depth, DepthUnits, SampleID, Comments) ! (i4.4, i3.3, 3i2.2, i1.1, t16, f9.5, t26, f10.5, t37, a, t45, a24, t70, f6.1, t78, a1, t80, a9, t90, a) ! (%4.4i%3.3i3%2.2i%1.1i %9.5f %10.5f %7s %24s %6.1f%1s %9s %s) ! temporal domain ! reformatted using unix command: awk '{ printf\ ! ("200513%s0%s00000 %9.5f %10.5f M505NC GRAB %7.1f M %s RECOVERED TRANSECT %s STATION %s DATE %s\n", \ ! substr($3,2,1),substr($2,1,1),$5,$6,$4,$2,$1,$2,$3)}' measuredLatLong2.prn >! m-5-05-nc.onoff.grabs.grab ! Note - times are fake; records have been resorted by date, time. ! !*08/24/05 clint measuredLatLong2.xls(corrected) ! (Corrected version, 8/11/05) ! NOAA California Canyons 2005 ! Ship: McArthur II ! Foraminiferal and grain size sediment samples obtained by a grab sampler ! M-5-05-NC ! Transect Station Date Depth(m) Lat.DD LongDD ! ! 08/11/05 Ian Hartwell m505nc.forams.xls ! I finally got around to plotting the field data and ! have found a variety of discrepancies and transcription errors in the lat/long data. ! I have attached a corrected version. Please discard the original. thanks, Ian H. ! ! 1 2 3 4 5 6 7 8 9 10 11 12 13 1 ! 34567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789 20051290140000 37.99928 -123.15216 M505NC GRAB 87.0 M 1D RECOVERED TRANSECT 5BC STATION 1D DATE 9-MAY-05 20051290240000 38.03508 -123.27711 M505NC GRAB 116.0 M 2D RECOVERED TRANSECT 5BC STATION 2D DATE 9-MAY-05 20051290340000 38.08097 -123.33956 M505NC GRAB 154.0 M 3D RECOVERED TRANSECT 5BC STATION 3D DATE 9-MAY-05 20051290420000 38.12842 -123.40170 M505NC GRAB 252.0 M 4C RECOVERED TRANSECT 5BC STATION 4C DATE 9-MAY-05 20051290520000 38.21721 -123.44067 M505NC GRAB 466.0 M 5C RECOVERED TRANSECT 5BC STATION 5C DATE 9-MAY-05 20051300440000 38.18510 -123.46030 M505NC GRAB 270.0 M 4D RECOVERED TRANSECT 5BC STATION 4D DATE 10-MAY-05 20051300540000 38.21590 -123.50410 M505NC GRAB 479.0 M 5D RECOVERED TRANSECT 5BC STATION 5D DATE 10-MAY-05 20051300620000 38.22211 -123.50690 M505NC GRAB 709.0 M 6C RECOVERED TRANSECT 5BC STATION 6C DATE 10-MAY-05 20051300640000 38.21050 -123.56440 M505NC GRAB 666.0 M 6D RECOVERED TRANSECT 5BC STATION 6D DATE 10-MAY-05 20051300720000 38.22480 -123.57700 M505NC GRAB 955.0 M 7C RECOVERED TRANSECT 5BC STATION 7C DATE 10-MAY-05 20051300740000 38.21438 -123.59760 M505NC GRAB 935.0 M 7D RECOVERED TRANSECT 5BC STATION 7D DATE 10-MAY-05 20051300820000 38.22578 -123.59886 M505NC GRAB 1109.0 M 8C RECOVERED TRANSECT 5BC STATION 8C DATE 10-MAY-05 20051300840000 38.20731 -123.62484 M505NC GRAB 1140.0 M 8D RECOVERED TRANSECT 5BC STATION 8D DATE 10-MAY-05 20051310200000 37.05027 -122.39884 M505NC GRAB 94.0 M 2 RECOVERED TRANSECT 5AC STATION 2 DATE 11-MAY-05 20051310210000 37.44350 -122.83470 M505NC GRAB 98.0 M 2 RECOVERED TRANSECT 5PC STATION 2 DATE 11-MAY-05 20051310300000 37.03112 -122.40804 M505NC GRAB 128.0 M 3 RECOVERED TRANSECT 5AC STATION 3 DATE 11-MAY-05 20051310310000 37.43510 -122.85190 M505NC GRAB 126.0 M 3 RECOVERED TRANSECT 5PC STATION 3 DATE 11-MAY-05 20051310400000 37.01710 -122.40890 M505NC GRAB 232.0 M 4 RECOVERED TRANSECT 5AC STATION 4 DATE 11-MAY-05 20051310410000 37.42510 -122.87070 M505NC GRAB 230.0 M 4 RECOVERED TRANSECT 5PC STATION 4 DATE 11-MAY-05 20051310500000 37.39610 -122.90780 M505NC GRAB 421.0 M 5 RECOVERED TRANSECT 5PC STATION 5 DATE 11-MAY-05 20051310600000 37.36360 -122.95430 M505NC GRAB 679.0 M 6 RECOVERED TRANSECT 5PC STATION 6 DATE 11-MAY-05 20051310720000 37.36918 -123.00736 M505NC GRAB 932.0 M 7C RECOVERED TRANSECT 5PC STATION 7C DATE 11-MAY-05 20051310740000 37.32393 -123.09167 M505NC GRAB 943.0 M 7D RECOVERED TRANSECT 5PC STATION 7D DATE 11-MAY-05 20051320200000 37.00310 -122.34680 M505NC GRAB 99.0 M 2 RECOVERED TRANSECT 5AN STATION 2 DATE 12-MAY-05 20051320300000 36.85670 -121.96491 M505NC GRAB 126.0 M 3 RECOVERED TRANSECT 5SO STATION 3 DATE 12-MAY-05 20051320440000 36.96531 -122.42009 M505NC GRAB 240.0 M 4D RECOVERED TRANSECT 5AC STATION 4D DATE 12-MAY-05 20051320500000 36.82074 -121.98665 M505NC GRAB 442.0 M 5 RECOVERED TRANSECT 5SO STATION 5 DATE 12-MAY-05 20051320510000 36.99580 -122.41470 M505NC GRAB 450.0 M 5 RECOVERED TRANSECT 5AC STATION 5 DATE 12-MAY-05 20051320540000 36.93890 -122.43270 M505NC GRAB 435.0 M 5D RECOVERED TRANSECT 5AC STATION 5D DATE 12-MAY-05 20051320600000 36.97390 -122.43280 M505NC GRAB 688.0 M 6 RECOVERED TRANSECT 5AC STATION 6 DATE 12-MAY-05 20051320700000 36.94540 -122.44890 M505NC GRAB 909.0 M 7 RECOVERED TRANSECT 5AC STATION 7 DATE 12-MAY-05 20051320740000 36.78310 -122.02250 M505NC GRAB 1005.0 M 7D RECOVERED TRANSECT 5MC STATION 7D DATE 12-MAY-05 20051330200000 36.80221 -121.81350 M505NC GRAB 90.0 M 2 RECOVERED TRANSECT 5MC STATION 2 DATE 13-MAY-05 20051330300000 36.79854 -121.81716 M505NC GRAB 162.0 M 3 RECOVERED TRANSECT 5MC STATION 3 DATE 13-MAY-05 20051330340000 36.84500 -121.95990 M505NC GRAB 132.0 M 3D RECOVERED TRANSECT 5SO STATION 3D DATE 13-MAY-05 20051330400000 36.79269 -121.84195 M505NC GRAB 276.0 M 4 RECOVERED TRANSECT 5MC STATION 4 DATE 13-MAY-05 20051330410000 36.84600 -121.96440 M505NC GRAB 133.0 M 4 RECOVERED TRANSECT 5SO STATION 4 DATE 13-MAY-05 20051330440000 36.81380 -122.00740 M505NC GRAB 213.0 M 4D RECOVERED TRANSECT 5SO STATION 4D DATE 13-MAY-05 20051330540000 36.80473 -122.00365 M505NC GRAB 473.0 M 5D RECOVERED TRANSECT 5SO STATION 5D DATE 13-MAY-05 20051340300000 36.53034 -121.93939 M505NC GRAB 160.0 M 3 RECOVERED TRANSECT 5CC STATION 3 DATE 14-MAY-05 20051340340000 36.53549 -121.94489 M505NC GRAB 150.0 M 3D RECOVERED TRANSECT 5CC STATION 3D DATE 14-MAY-05 20051340400000 36.53315 -121.94510 M505NC GRAB 303.0 M 4 RECOVERED TRANSECT 5CC STATION 4 DATE 14-MAY-05 20051340440000 36.52113 -122.00390 M505NC GRAB 240.0 M 4D RECOVERED TRANSECT 5CC STATION 4D DATE 14-MAY-05 20051340450000 36.78270 -121.88710 M505NC GRAB 214.0 M 4D RECOVERED TRANSECT 5MC STATION 4D DATE 14-MAY-05 20051340500000 36.53371 -121.96769 M505NC GRAB 437.0 M 5 RECOVERED TRANSECT 5CC STATION 5 DATE 14-MAY-05 20051340520000 36.79696 -121.89683 M505NC GRAB 453.0 M 5C RECOVERED TRANSECT 5MC STATION 5C DATE 14-MAY-05 20051340540000 36.78423 -121.90930 M505NC GRAB 424.0 M 5D RECOVERED TRANSECT 5MC STATION 5D DATE 14-MAY-05 20051340620000 36.78040 -121.94040 M505NC GRAB 730.0 M 6C RECOVERED TRANSECT 5MC STATION 6C DATE 14-MAY-05 20051340640000 36.76770 -121.97530 M505NC GRAB 668.0 M 6D RECOVERED TRANSECT 5MC STATION 6D DATE 14-MAY-05 20051340720000 36.77500 -122.00470 M505NC GRAB 972.0 M 7C RECOVERED TRANSECT 5MC STATION 7C DATE 14-MAY-05 20051350100000 35.98246 -121.51951 M505NC GRAB 71.0 M 1 RECOVERED TRANSECT 5LC STATION 1 DATE 15-MAY-05 20051350200000 35.97792 -121.52188 M505NC GRAB 107.0 M 2 RECOVERED TRANSECT 5LC STATION 2 DATE 15-MAY-05 20051350240000 35.97180 -121.53820 M505NC GRAB 104.0 M 2D RECOVERED TRANSECT 5LC STATION 2D DATE 15-MAY-05 20051350300000 35.96420 -121.52660 M505NC GRAB 245.0 M 3 RECOVERED TRANSECT 5LC STATION 3 DATE 15-MAY-05 20051350340000 35.96000 -121.53790 M505NC GRAB 233.0 M 3D RECOVERED TRANSECT 5LC STATION 3D DATE 15-MAY-05 20051350400000 35.95030 -121.53170 M505NC GRAB 345.0 M 4 RECOVERED TRANSECT 5LC STATION 4 DATE 15-MAY-05 20051350440000 35.96270 -121.56660 M505NC GRAB 335.0 M 4D RECOVERED TRANSECT 5LC STATION 4D DATE 15-MAY-05 20051350500000 35.95080 -121.57520 M505NC GRAB 510.0 M 5 RECOVERED TRANSECT 5LC STATION 5 DATE 15-MAY-05 20051350540000 35.94830 -121.60450 M505NC GRAB 543.0 M 5D RECOVERED TRANSECT 5LC STATION 5D DATE 15-MAY-05 20051350600000 35.97270 -121.67480 M505NC GRAB 730.0 M 6 RECOVERED TRANSECT 5LC STATION 6 DATE 15-MAY-05 20051350640000 36.00040 -121.69140 M505NC GRAB 791.0 M 6D RECOVERED TRANSECT 5LC STATION 6D DATE 15-MAY-05 20051350700000 35.99390 -121.70200 M505NC GRAB 958.0 M 7 RECOVERED TRANSECT 5LC STATION 7 DATE 15-MAY-05 20051350710000 36.05122 -121.80542 M505NC GRAB 948.0 M 7 RECOVERED TRANSECT 5S5 STATION 7 DATE 15-MAY-05 20051350740000 35.95491 -121.72852 M505NC GRAB 929.0 M 7D RECOVERED TRANSECT 5LC STATION 7D DATE 15-MAY-05 20051360100000 36.20170 -121.78000 M505NC GRAB 81.0 M 1 RECOVERED TRANSECT 5S5 STATION 1 DATE 16-MAY-05 20051360200000 36.19660 -121.78270 M505NC GRAB 114.0 M 2 RECOVERED TRANSECT 5S5 STATION 2 DATE 16-MAY-05 20051360300000 36.19800 -121.79360 M505NC GRAB 185.0 M 3 RECOVERED TRANSECT 5S5 STATION 3 DATE 16-MAY-05 20051360400000 36.15430 -121.71170 M505NC GRAB 270.0 M 4 RECOVERED TRANSECT 5S5 STATION 4 DATE 16-MAY-05 20051360500000 36.15330 -121.76970 M505NC GRAB 492.0 M 5 RECOVERED TRANSECT 5S5 STATION 5 DATE 16-MAY-05 20051360540000 36.53844 -122.03109 M505NC GRAB 450.0 M 5D RECOVERED TRANSECT 5CC STATION 5D DATE 16-MAY-05 20051360600000 36.13180 -121.84570 M505NC GRAB 713.0 M 6 RECOVERED TRANSECT 5S5 STATION 6 DATE 16-MAY-05 20051360610000 36.54397 -122.00034 M505NC GRAB 720.0 M 6 RECOVERED TRANSECT 5CC STATION 6 DATE 16-MAY-05 20051360640000 36.56286 -122.05249 M505NC GRAB 713.0 M 6D RECOVERED TRANSECT 5CC STATION 6D DATE 16-MAY-05 20051360700000 36.56545 -122.04140 M505NC GRAB 891.0 M 7 RECOVERED TRANSECT 5CC STATION 7 DATE 16-MAY-05 20051370200000 36.86450 -121.95840 M505NC GRAB 86.0 M 2 RECOVERED TRANSECT 5SO STATION 2 DATE 17-MAY-05 20051370300000 36.98047 -122.36036 M505NC GRAB 174.0 M 3 RECOVERED TRANSECT 5AN STATION 3 DATE 17-MAY-05 20051370400000 36.97576 -122.36280 M505NC GRAB 257.0 M 4 RECOVERED TRANSECT 5AN STATION 4 DATE 17-MAY-05 20051370500000 36.96258 -122.36705 M505NC GRAB 455.0 M 5 RECOVERED TRANSECT 5AN STATION 5 DATE 17-MAY-05 20051370600000 36.79480 -121.99710 M505NC GRAB 675.0 M 6 RECOVERED TRANSECT 5SO STATION 6 DATE 17-MAY-05 20051370610000 36.95034 -122.37900 M505NC GRAB 697.0 M 6 RECOVERED TRANSECT 5AN STATION 6 DATE 17-MAY-05 20051370700000 36.92929 -122.39657 M505NC GRAB 931.0 M 7 RECOVERED TRANSECT 5AN STATION 7 DATE 17-MAY-05 20051370740000 36.59425 -122.07317 M505NC GRAB 975.0 M 7D RECOVERED TRANSECT 5CC STATION 7D DATE 17-MAY-05 20051380100000 37.33040 -122.58992 M505NC GRAB 77.0 M 1 RECOVERED TRANSECT 5S1 STATION 1 DATE 18-MAY-05 20051390110000 37.70380 -122.57334 M505NC GRAB 19.0 M 1 RECOVERED TRANSECT 5SWOO STATION 1 DATE 19-MAY-05 20051390200000 37.27570 -122.73340 M505NC GRAB 106.0 M 2 RECOVERED TRANSECT 5S1 STATION 2 DATE 19-MAY-05 20051390210000 37.68989 -122.57115 M505NC GRAB 21.0 M 2 RECOVERED TRANSECT 5SWOO STATION 2 DATE 19-MAY-05 20051390300000 37.24360 -122.77140 M505NC GRAB 161.0 M 3 RECOVERED TRANSECT 5S1 STATION 3 DATE 19-MAY-05 20051390310000 37.71829 -122.57142 M505NC GRAB 12.0 M 3 RECOVERED TRANSECT 5SWOO STATION 3 DATE 19-MAY-05 20051390400000 37.21290 -122.80600 M505NC GRAB 248.0 M 4 RECOVERED TRANSECT 5S1 STATION 4 DATE 19-MAY-05 20051390500000 37.15000 -122.86800 M505NC GRAB 460.0 M 5 RECOVERED TRANSECT 5S1 STATION 5 DATE 19-MAY-05 20051390600000 37.10570 -122.96710 M505NC GRAB 698.0 M 6 RECOVERED TRANSECT 5S1 STATION 6 DATE 19-MAY-05 20051390700000 37.07890 -122.98350 M505NC GRAB 890.0 M 7 RECOVERED TRANSECT 5S1 STATION 7 DATE 19-MAY-05