PDF manual - Ocean Drilling Program
Contents
1. Field Star Length Notes Examples t Leg 2 3 Only 3 digit legs are used currently The upload parser will handle 1 and 2 digit legs also Value is right justified in the field width Format NNN Site 6 4 Format NNNN Hole 11 1 Format A uppercase the parser can handle lower or upper case data Core 13 3 Value right justified and leading blanks used if value shorter than 3 digits Format NN Core Type 17 1 Format A uppercase the parser can handle lower or upper case data Section 19 2 2 digit section numbers are supported by this format Shorter values are right justified and padded with spaces Format NN Top Interval 24 5 Values are expressed in centimeters precise to the millime ter right justified and padded with leading blanks if needed Format NNN N Bottom Inter 30 5 Values are expressed in centimeters precise to the millime val ter right justified and padded with leading blanks as needed Figure 27 Natural Sample Identifier table Ocean Drilling Program RSC Color Reflectance User s Manual Other Columns 25 Field Star Lengt Notes Examples t h Depth 36 7 This column is left blank by the data acquisition program For the parser to properly upload a file this column should be left blank L 44 6 Value right justified and blan2. 10 Select Upload qr Hohn etch ades 11 Select Upload Selected 11 Multiple individual files gc se bee Bee ek ees 11 Access editing functions with these 13 Displayed samples that correspond to the selected information 13 Detailed view of samples fora single 14 A section and it s associated run 14 Warning for deleting 15 Warning Tor deleting 15 Selected samples to be deleted 16 Warning for deleting 1 16 The Reassign Run window 17 The Create Shortcut dialog box 19 Enter the Shortcut name here 19 The RSC Properties dialog box 20 The Change Icon dialog 20 Natural Sample Identifier table 24 Other Col mns Table esiste M eR Se rb mde 26 RSC R n Table 4521249 Ag AW RES 30 RSC Section EET EE ENS 30 RSC Control Tables uod us SED Ex pun e 3l RSC Run Data
3. Ocean Drilling Program RSC Color Reflectance User s Manual ments are taken 33 The system ID field is presently not used nor is it required by the database At some future point the ODP number will possibly be placed This will occur when multiple pieces of mea suring equipment come on line at the various sampling locations The comment field is not required either Table Field Format Notes Comments rsc calib date time date PK The date and time this calibration was recorded comment varchar2 80 Any general notes recorded by the observer This field is not required illumination condit varchar2 3 CIE standard illuminants e g A C D50 D65 For further ion detail on how these illumination standards apply to the resulting measurements refer to the CM 2002 spectro photometer manuals rsc num meas number 2 Sometimes multiple measurements are taken at each sample point and averaged to obtain the recorded val ues This field records how many values were averaged to obtain the values recorded for this calibration rsc observer angle number 2 Current equipment supports measurements taken at 2 or 10 based on CIE standard observer specifications rsc reflectance corr number 2 1 Correction factor used to calculate SCI data from SCE measurements The current equipment supports pro grammable settings in the range 0 0 9 9 Usually this factor is set to 0 0 See the s
4. 4 Once you have selected the files and set the upload to the proper setting click the Start Upload button 5 As the program uploads the files information regarding the files is displayed in the Upload Log You can save this information by clicking on the Save Log button See Appendix B Troubleshooting p 22 6 All successful uploads should now be in the central database You can inspect the suc cessfully uploaded data from the color reflectance web browser reports at this address http janusaxp tamu edu predef_queries physprops colordat htm Ocean Drilling Program RSC Color Reflectance User s Manual 13 Editing Uploaded Data Purpose The RSC program contains several editing functions These are used to edit samples so as to correct for common data oversights errors The editing functions are displayed as buttons on the main RSC window See Figure 14 Delete Delete Delete Reassign Section Run Sample Run Figure 14 Access editing functions with these buttons Section and Run Identification Before editing you must first identify and select the proper section and run A list of corre sponding samples is then displayed 1 Select the leg site hole core section and run from the columns on the Color Reflec tance window See Figure 15 Each run consists of a series of color reflectance mea surements taken on a section at selected intervals Hole Core Section Run Top
5. COLOR REFLECTANCE USER S MANUAL Table of Contents Starting RSC eL RU EE EUREN Ra Ro E E a Login Procedure vex koe e E Chas ERE ar ne EX RE VE RSC Color Reflectance Window 4 lupa Wr ARES ALG BES es MR ERR RIES 4 Window Layout and Navigation Info 5 RSC Uploader Window 7 Purpose 3 055 255 RR bae x A A REP CP Ead 7 Contigunng Files wi cei EROR ERE CURT Le DES 8 Source Upload Folder o br eebac Wie b e Eb NEU SEES 9 Source Queue vnb rA eer pue Se T ohne S 9 Elle List e RE epe de E RR e UM e npa xe 10 Upload Eog EI ELSE REGERE DEUS ER IA TE Er End 10 Uploading ede e e Pa eie 11 Editing Uploaded Data 13 Purpose ee be eae sae loa HER UE DAE E 13 Section and Run Identification 13 Detailed Sample VIEW En E Epor es cr e Re Ree ca 14 Delete Seton ebbe US 14 Delete Run ice Re pr E BPO C RES EY 15 Delete Sample ecce e eee Sy e EE ce bp rei e eR ERI der ets 15 Reassign Run grex EE AS Ee quete aeu ord deo lods 16 Appe
6. Table ie UR pee SR 32 RSC Calibration Table 6o veu eub 39 Physical Properties Standard Table 34 Section Tabler lt lt ener hod us 35 RSC Color Reflectance User s Manual 1 Introduction Color Reflectance is a program designed to upload reflectance spectroscopy data files to the central database It also contains a browser edit window Selected data is displayed on this window for browsing or editing or to correct for common data oversights errors For brevity the program is referred to as RSC for Reflectance Spectroscopy and Colorimetry Document Layout This document is broken into several sections The first two describe starting the program and the login The next two describe each window and their functions The fifth section describes the editing functions of RSC Finally the appendix includes technical details on the program installation and architectural notes The appendix is designed for use by programmers and Marine Computer Specialists MCS Ocean Drilling Program RSC Color Reflectance User s Manual 2 Starting RSC RSC can be started in one of two ways From the Program Manager open the Color Reflectance group Double click on the Color Reflectance icon OR 2 From the File Manager open the program from the directory c odp rsc_upld Double click on the executable program RSC UPLD N
7. Bot Depth le l Munsell v 2 ai zz540 4047 fan 233 ferrage 61 27860 4148 81 171 52 4001 81 27880 4072 682 1024 87 3914 Hol 3811 578 36 7 33 68544 B8YR3540 141 27940 3935 782 1217 70 38027 6 1 7960 4043 806 233 jesvea3sz 181 7980 3982 837 1304 69vR38 723 201 28000 4084 778 192 68YyR39 721 f H 22 1 7 0YR 3 3 2 2 zi Figure 15 Displayed samples that correspond to the selected information Ocean Drilling Program RSC Color Reflectance User s Manual 14 2 The spreadsheet does not display the raw spectral data It only displays RSC data to provide visual verification that the data has uploaded See Figure 15 3 If the data you need is not in the displayed list check with the Lab Technician Curator or Database Administrator to ensure that the data has been entered into the database Detailed Sample View The spreadsheet shown in Figure 16 is a detailed display of samples for a single run The table provides a view of the L a b color coordinates and the Munsell Hue Value Chroma color coordinates Top Bot Cepth L Munsell m 4 B7YR39 22 A jJzvR4o2 1 8 7 3918 10 A Jo p5vR37168 12 ae 14 m 16 A 18 181 I 20 40 89 681392171 22 Figure 16 Detailed view of samples f
8. Drilling Program RSC Color Reflectance User s Manual 7 RSC Uploader Window Purpose This window uploads selected files to the database Open this window from the main win dow by clicking on the Upload Data button You can upload all files listed or select only specific ones Once files are uploaded to the central database the data becomes available for selection on the Color Reflectance window Section 3 iE Uploader Press Control H to display on line help To put it away press Control H again File List GIL DAT 1016C1 1017E2 1017E3 1034 10 1034211 103422 103403 1034C4 1034C5 1034C6 1034 7 1034C8 103403 103401 1034011 103402 103403 103404 103405 103406 113477 103408 103409 1034 1 1034 10 1O34E2 1034E3 1034E4 1034E5 1034 1034 7 Start Upload Configure File Processing Queues Refresh File List Source Upload All Queue Figure 6 The Uploader window of the RSC program Upload Log yi develop rsc_upld data upload Close Ocean Drilling Program RSC Color Reflectance User s Manual 8 Configuring Files Before uploading files set the directories that are used to sort and track processed files Click on Configure File Processing Queues to open the set directories windows See Figure 7 The very first time this window opens all directories default to the location of the RSC pro gram install Use the Change b
9. FK retrieve the core The core type is only reported in data subsequent to leg 113 Figure 35 Section Table Ocean Drilling Program
10. et bet o E RUE e EN AE DEOR dU 30 RSC Control Table 5 EE eae ee RUD dha a pae Lebe Ds 30 RSC R n Data Fabler tuses eaen Ere EROR USA ROE REOR 31 RSC Calibration Table 5 soci RR b EUER SPESE S be 32 Physical Properties Standard Table 34 Section Table E LORI PUE eeu det E du EE ATE 34 Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Figure 33 Figure 34 Figure 35 Table of Figures The RSC Logm wIndOW 25222556 ae eR RI CEU PER REX 2 Warning for an incorrect login 3 The Color Reflectance window of the RSC program 4 Samples that correspond to selected column information 5 Buttons of the Color Reflectance window 5 The Uploader window of the RSC program 7 Configure directories used by uploader at this window 8 Locate the Upload Folder from this window 9 The Source Queue in the Uploader window 9 Files ready to upload
11. run consists of point measurements made on a single core section or against a physical standard Each run is assigned a natural counting number starting with one for the first section standard processed Multiple data runs can be collected for the same section This may occur if previous data col lection integrity is in question and being corrected Multiple runs against a physical standard i e a calibration run are made to ensure the mea surement equipment is operating as expected Every run number is unique within a given leg A laboratory journal is maintained at the color reflectance station for researcher s comments if any on the current calibration or data run RSC Run Table This table records current run information some of which relates to current equipment set tings A new record is added for each data or calibration run Table Field Format Notes Comments leg number 5 Number identifying the cruise for which data was entered PK into the database rsc run num number 4 Run number under review PK rsc num meas number 2 The spectrophotometer allows multiple readings to be i taken at each sample point Data collected in this mode represents the average of this many readings taken at one sample point Ocean Drilling Program RSC Color Reflectance User s Manual 30 Rsc run date time date Contains the date and time at which run data was uploaded to the central database Rsc ca
12. s File Manager Drag the RSC folder from the original distribu tion media into the Yodp folder on the deployment system 2 RSC distribution consists of the following files RSC UPLD The main executable RSC ICO An icon that can be used for the Windows desktop SETUP DAT This file is created at run time and is not part of the distribution It holds program default configuration information See Appendix B Troubleshooting 22 3 When a new installation is complete be sure to run the program and configure the upload transfer and logging directories Recommended settings are provided in the User s Guide Updates Delete the existing RSC folder and follow the instructions above Program Manager Setup Set up the following property settings so the RSC program can be accessed from the Windows Program Manager Right click the mouse on the desktop This opens a selection list 2 Select New gt Shortcut This brings up the Create Shortcut dialog box See Figure 23 Ocean Drilling Program RSC Color Reflectance User s Manual 19 Create Shortcut Type the location and name of the item y ou want to create a shortcut to Or search for the item by clicking Browse Command line a Browse io Jes Figure 23 The Create Shortcut dialog box 3 Type c odp rsc_upld rsc_upld exe into the Command line or click on Browse to retrieve this file Click Next to continue 4 Select a title for the prog
13. 49 0 723 6 91 7 2122 17 4 2709 7497 8 02 59 17 843k 6 42 Ssh 8 67 29 71 9 69 8 70 8 71 8 08 8 07 8 66 8 61 6 45 8 36 8 44 6 53 9 72 8 84 0 00 5 09 8 496 5077 172 1062 D 8 H CC 6 0 6 50 01 0 21 Sede 7 9 4 8 7 0 8 13 99 14 32 14 59 14 94 15 30 15 63 16 00 16 35 15 66 16 99 17 24 17 46 17 58 17 85 18 06 18 35 18 65 18 99 18 97 19 00 18 94 18 78 18 58 18 41 18 24 17 99 17 76 17 56 17 34 17 16 16 97 0 00 20 28 18 43 5 70 0 00 18 43 0 46 0 41 172 1062 D 8 H CC 8 0 8 49 43 0 25 5 92 FISY 4 8 0 8 13 19 13 55 13 89 14 25 14 61 14 96 15 34 15 73 16 06 16 40 16 68 16 93 17 15 17 31 17 57 17 84 18 18 18 44 18 52 18 55 18 54 18 31 18 10 17 94 17 73 17 50 17 27 17 05 16 82 16 04 16 43 0 00 19 76 17 94 5 47 0 00 17 94 0 46 0 42 Ocean Drilling Program RSC Color Reflectance User s Manual App D File Format Specifications Leg 179 Present Ocean Drilling Program 28 RSC Color Reflectance User s Manual 29 Appendix E RSC Database Schema This appendix describes on a table by table basis the structure of the color reflectance data model Detailed comments and usage notes are provided for the various schema fields Sum mary discussions provide review of table inter relationships Unless specifically noted otherwise all fields discussed below are required fields in database terminology non nullable Abbreviations used in the tables include PK Primary Key FK Foreign Key Run Numbers A color reflectance data
14. 806 1233 6 921 T 181 27980 3982 837 1304 3 823 201 28000 4089 778 1192 921 0YR 3 9 2 2 Figure 3 The Color Reflectance window of the RSC program Ocean Drilling Program RSC Color Reflectance User s Manual 5 Window Layout and Navigation Info 1 Notice that the top half has columns for leg site hole core section and run These columns display information that is already stored in the Janus database Each column displays information based on the highlighted choice from the previous column For example in Figure 3 Site displays all the sites available for leg 172 etc To select specific data use the mouse key to highlight your choice in each column Use the scrollbar or the arrow keys to move up or down a column Leg In addition to the other highlighting methods you can also type in the leg dig its The program displays the first item in the list that starts with those digits Section Only sections with color reflectance data are shown If the column displays no section numbers make sure the previous column selections are correct e Run If this column is empty either no data has been uploaded to the central database for that section or no data was collected 2 The lower half of the window is a spreadsheet displaying samples that correspond to the selected column information See Figure 4 Top Bot Depth E b Munsel
15. The current icon should now be visible on the desktop System Requirements The minimum recommended system requirements are Pentium 90 or better Wintel machine 2 32 megabytes of RAM 3 Windows NT 4 0 Windows 95 or Windows 98 Note For simplicity it is assumed that the Windows operat ing system and Oracle s SQL Net are already properly installed and configured Ocean Drilling Program RSC Color Reflectance User s Manual 22 Appendix B Troubleshooting Login 1 For shipboard and shore use the proper RSC login is the Physical Properties account username phys111 and password phys111 2 If RSC will not continue past login verify the following Check that the Host name is correct Contact an MCS if you are not sure what the Host name should be Verify that the web server on the database server is running and accessible Check that the SETUP DAT configuration file is read writeable Data Editing The RSC data editing functions should be used with caution A sample or run of sam ples can be erroneously deleted They can only be recovered by re uploading the file contain ing those data points Note The current RSC version does not provide any means to view or edit calibration data Upload File Format The source data files should be in the format specified in Appendix D for the Upload Data Files option Sample files of the expected format are included with the original distribution of this progra
16. cking on the Save Log button It is important to save when the program has had problems uploading files Successfully uploaded files are moved to the Transferred Folder while problem files transfer to the Logging Folder Note The upload log is cleared for each new batch of files submitted for processing Ocean Drilling Program RSC Color Reflectance User s Manual 11 Uploading Select the files you want to upload from the File List on the Uploader window 2 You can select all files displayed by clicking on the Start Upload button and making sure the upload is set to all See Figure 11 Start Upload Refresh File List Figure 11 Select Upload 3 You can select individual files in several ways Select only one file by clicking on it This will highlight the file Make sure the upload is set to selected See Figure 12 Start Upload Refresh File List Upload Selected Figure 12 Select Upload Selected Select more than one individual file See Figure 13 by holding down the Shift key while clicking on the individual files Make sure the upload is set to selected See Fig ure 12 GIL DAT 103473 1034C4 Figure 13 Multiple individual files Select a block of files by holding down the Shift key while dragging the mouse over the group of files Make sure upload is set to selected See Figure 12 Ocean Drilling Program RSC Color Reflectance User s Manual 12
17. es files that were not successfully uploaded All files are stored unchanged To save the error messages shown on the screen click Save Log The messages are saved to the Log folder with the current system time stamp For ship board use it is recommended that a log folder be created on the local hard drive of the upload station e g c odp rsc logs Ocean Drilling Program RSC Color Reflectance User s Manual 9 Source Upload Folder There are two methods for changing the configuration of the Source Upload Folder If you already know the directory you can type it directly into the entry box See Figure 7 Other wise use the following procedure 1 Click the Change button next to the Upload Folder entry box This opens the following dialog box Locate Source Folder for Upload Files Save in Upload 1034c3 11119 1017e2 1033c3 103404 1 179 1017e3 10334 1034c5 I RSC Calibration 1017e3co 1034c10 a 1034c6 L Standard 1033a1 1034c11 3 1034c7 10161 1033c1 1034c2 1034c8 2 Save as type Files Cancel Select Cur Dir Figure 8 Locate the Upload Folder from this window 2 Select the folder that contains the color reflectance upload data It does not allow you to select individual files 3 Click the Select Cur Dir button This re opens the Uploader window with the Source Upload path fi
18. for a group or set of related physical proper 5 ties standards date time commissio date The date on which a physical properties standard went ned into use date time decommiss date The date on which usage of a physical properties stan ioned dard was discontinued lot serial number varchar2 20 Information concerning the lot and or serial number asso i ciated with a physical properties standard comments varchar2 80 General notes comments regarding the specific standard described by this record igure 34 Physical Properties Standard Table Section Table This table records the leg site hole core core type and section number for each piece of core against which laboratory measurements are taken The table is included here as a reference Any live runs of data entered into the system must tie back to this table Following are non required fields but must be filled to ensure the usefulness of the data sec tion type curated length liner length core catcher stored in and section comments Ocean Drilling Program RSC Color Reflectance User s Manual 35 Table Field Format Notes Comments section id number 7 Unique number generated by system to identify a sec PK tion section number number 2 Section number If n regular sections then core catcher is PK section 1 section type varchar2 2 Used to differentiate sections of core S from core catch ers C Prev
19. ick OK to proceed with the deletion or Cancel to stop Reassign Run This button allows you to re assign a run to a different section For example at the end of a run you might notice that the section on the track doesn t match up with the section indicated on the data acquisition screen Thus the run is assigned to the wrong section This can be fixed after the upload by using the Reassign Run function 1 Select the problem run from the column by clicking on it 2 Click the Reassign Run button The following window is displayed Ocean Drilling Program RSC Color Reflectance User s Manual 17 rsc reassign run vi Reassign run 8986 from section 172 1063D 18 H CC to the section selected below Site Hole Core Section Figure 22 The Reassign Run window Continue Cancel 3 Select the correct section for the run by clicking on it 4 Click the Continue button to proceed or Cancel to stop This function only allows you to select a section within the same leg Runs cannot be re assigned across legs Ocean Drilling Program RSC Color Reflectance User s Manual 18 Appendix A Installing RSC This appendix describes how to install configure and troubleshoot possible problems with the RSC program Executable and Program Files New Installs RSC program files should be installed in the directory odp rsc off the root of the deployment system s hard drive 1 Open the file Window
20. iles but with a log extension e g 1033al log 1017e3 log Data Acquisition Format Specification The upload files were originally written from the Macintosh platform The files are human readable ASCII text Each column of information is a fixed width with runs of spaces delimit ing the columns The end of line indicator for the Macintosh is the carriage return character CR Each line contains the following information Natural sample identifier leg site hole core core type section number or core catcher CC top interval and bottom interval 2 A blank column for inserting depth information 3 Color coordinates based on the CIE L a b color description standard 4 Color coordinates based on the Munsell Hue Value Chroma HVC color description system 5 Spectral reflectance values for each wavelength from 400 700 nanometers nm at inter vals of 10nm 31 values Ocean Drilling Program RSC Color Reflectance User s Manual Natural Sample Identifier The Natural Sample Identifier consists of a leg site hole core type section number or core catcher top interval and bottom interval The layout is as follows 24 Columns not specified are filled with blanks Values shorter than a column are padded to the column width with spaces Format specifiers and A are used below to represent decimal digits 0 to 9 or sign decimal point shown explicitly and alphabetical characters A to Z
21. iously core catchers were stored as section number CC but in Janus core catchers are given the next sequential number from the last section recovered curated length number 6 2 The length of the nth core section in cm sent to the repository This may be different than the liner length for the same section Hard rock cores will often have spac ers added to prevent rock pieces from damaging each other liner length number 6 2 The length in cm to which the liner of the nth core section is cut core catcher stored i varchar2 2 Sometimes the core catcher is stored in a D tube with a n section This field contains the section number of the D tube that holds the core catcher for the current core section comments varchar2 45 Observer or technician comments regarding the current section number 5 FK Number identifying the cruise for which data was entered leg into the database site number 6 FK Number identifying the site from which the core was retrieved A site is the position of a beacon around which holes are drilled hole varchar2 1 Letter identifying the hole at a site from which a core was FK retrieved or data was collected core number 5 FK Sequential numbers identifying the cores retrieved froma particular hole Cores are generally 9 5 meters in length and are numbered serially from the top of the hole down ward core_type varchar2 1 A letter code identifying the drill bit coring method used to
22. k padded Format NNN NN a 51 6 Value right justified and blank padded Format NNN NN b 58 6 Value right justified and blank padded Format NNN NN Munsell 65 6 Format NN NAA or the text NEUTRA For example Hue 23 2YG or 1 6B The exception records neutral hue values allowed by the Munsell system Value 72 9 Format NN N NN N Chroma Spectral 82 5 Format NN NN There should be 31 columns of spectral Reflectance reflectance values total This first column is the percentage at 400nm reflectance at 400 nanometers nm Subsequent columns record reflectances at wavelengths up to 700 nm at 10 nm intervals 410nm 88 5 Value right justified and blank padded Format NN NN 420nm 94 5 Value right justified and blank padded Format NN NN 430nm 100 5 Value right justified and blank padded Format NN NN 440nm 106 5 Value right justified and blank padded Format NN NN 450nm 112 5 Value right justified and blank padded Format NN NN 460nm 118 5 Value right justified and blank padded Format NN NN 470nm 124 5 Value right justified and blank padded Format NN NN 480nm 130 5 Value right justified and blank padded Format NN NN 490nm 136 5 Value right justified and blank padded Format NN NN 500nm 142 5 Value right justified and blank padded Format NN NN 510nm 148 5 Value right justified and blank padded Format NN NN 520nm 154 5 Value right justified and blank padded Fo
23. l X 2 a 4 4047 811 i233 j ezvR3922 B 4148 811 i171 je2vmaO 21 8 4072 1682 1024 je amp zvmn3sn8 10 3811 578 93 peEvn37318 12 3817 3835 34 Bgva35n0 14 3935 782 24 zovna3sg 3 16 4043 1233 68839821 d 18 3382 n37 304 E9vn3823 Figure 4 Samples that correspond to selected column information Note These samples are for browsing selection and minor editing functions only See Editing Uploaded Data p 13 3 There are several buttons at the bottom of the window See Figure 5 Upload Data Delete Delete Delete Reassign Quit Section Run Sample Run Figure 5 Buttons of the Color Reflectance window Ocean Drilling Program RSC Color Reflectance User s Manual 6 Upload Data Opens the RSC Uploader window Data is uploaded to the central database from this window See Uploading p 11 Delete Section Deletes all runs linked to the currently selected section See Editing Uploaded Data p 13 Delete Run Deletes the color reflectance data associated with the selected run See Editing Uploaded Data p 13 Delete Sample Deletes the color reflectance samples selected in the table See Edit ing Uploaded Data p 13 e Reassign Run Re assigns a selected color reflectance run to a different section See Editing Uploaded Data p 13 Quit Exits the RSC program completely Ocean
24. lib date time date FK This field links the current run to the last available cali n bration run Equipment settings associated with this cali bration record apply to the data collected Foreign key reference to the calibration table Figure 29 RSC Run Tabte RSC Section Table This table identifies color reflectance data runs A sample record is tied to a particular leg site hole core section through a link to the Janus section table Select a compound natural key to distinguish run data from calibration data The compound key also allows the record ing of multiple data runs for the same section Section Table records are children of the RSC Run Table Section information must already be logged into the database for data to be logged Every section with color reflectance data has one or more entries in this table If this table contains an entry with no child records review the entry and either remove it or add appropriate child data Table Field Format Notes Comments section id number 7 PK Unique number generated by system to identify section i This is done because of the physical subsection O section problems In adding new sections deleting sections or changing sections don t want to have to ripple updates throughout the database leg number 5 PK Number identifying the cruise for which data was entered into the database Derives from the database Leg and Defaults tables Rsc
25. lled out and a list of files displayed Note Set the transferred and logging folder configurations in a similar fashion e g use the Change button select a folder from the dialog box press the Select Cur Dir button etc Source Queue Source develop rsc upld datasupload Queue Figure 9 The Source Queue in the Uploader window The source queue is displayed under the Configure File Processing Queues button This win Ocean Drilling Program RSC Color Reflectance User s Manual 10 dow displays the Upload Folder or Source Directory Check this window to make sure you are uploading files from the correct directory File List Notice that the left side of the window is a list of files See Figure 10 These are all the files in the Source Queue upload folder that have not been saved to the database yet File List 1016C1 1017E2 1017E3 1034C10 1034C11 1034C2 Figure 10 Files ready to upload If the list is empty or if you have made any changes in configuration click on the Refresh File List button Changes made in the configurations are not automatically reflected in the list The refresh function is the only method to update this list Upload Log The upload log displays information regarding the progress and success failure during the upload process See Appendix B Troubleshooting p 22 When the upload is complete you have the option to save the information by cli
26. m Configuration File Notes The SETUP DAT file records the following configuration information Upload log and transfer file defaults Username password and host for database login Next available run number for the upload processing Note This file is not human readable Don t bother trying to edit it Error Validation Log Specifications Ocean Drilling Program RSC Color Reflectance User s Manual 23 Appendix C File Format Specification Leg 178 This appendix contains a cumulative record of the RSC upload formats required by various versions of the program The program versions and format specifications are labeled by the leg in which they were used Also any additional notes about specification development are included Format Specification Leg 178 The first release of RSC sailed on Leg 174B It was a prototype of the color reflectance acqui sition upload and editing under the LabVIEW instrument interface The same upload format was used for several legs prior How far back has not been determined File Naming Conventions Each upload file contains reflectance samples for a specific site hole and core The upload files are named accordingly with no type extension e g 1033 1 1017e3 For the Leg 175 RSC version a log file is recorded for each uploaded file The log records the success or failure of sample uploading in the associated upload file The log files are named the same as upload f
27. message will be displayed You are about to delete the selected run All sample points associated with the selected color reflectance run will be deleted Are you sure you want to do this Cancel Figure 19 Warning for deleting runs 3 Click OK to proceed with the deletion or Cancel to stop the deletion Delete Sample It is possible that an interval may be missed or incorrectly specified during sampling By not ing the bad sample point and using the Delete Sample option the operator can still upload the data and then delete the bad sample point or points 1 Select a sample row or block of rows from the spreadsheet Highlight one by clicking on it It is not necessary to highlight the whole row highlighting one cell in the sample row is sufficient Highlight more than one sample by clicking and dragging with the mouse See Figure 20 Ocean Drilling Program RSC Color Reflectance User s Manual 16 Top Bot Depth L b Munsell X Y Z H 1 Mas pise Bas 50 47 03 61 63610 5036 L139 M51 18GY 43 07 181 5 26 30 47 04 27 18474808 1 83911 fasa 59 414 fazvasos 81 163930 4844 112 544 jJ03Gv47 08 201 163 950 4961 159 Je 12Gv4809 You are about to delete the selected color reflectance sample points from the central database Are you sure you want to do this Camel Figure 21 Warning for deleting samples 3 Cl
28. ndix A Installing RSC 18 Executable and Program Files 18 UR ee e ace ec Ge een 18 Updates ie e Pee os e esce e e ER Cn e ed dus 18 Program Manager Setup 2 2 2 18 System Requirements cle NE rp ERR E Ep 21 Appendix B Troubleshooting 22 LOSI 4 ebeseneregUeedhel eb ues aser be ped de epi adus 22 Data IEEE eee nate neq YARD RW p Edad pas sedes ce 22 Upload Fle Format 2 dc eet a wt ORC DEUS AE VS 22 Configuration File Notes 22 Error Validation Log Specifications 22 Format Specification Leg 222 178 23 File Naming Conventions ven ERS ARE BS a SRS 23 Data Acquisition Format Specification 23 App D File Format Specifications Leg 179 Present 28 Appendix RSC Database Schema 29 Rum Numbers cere o dto RE uU ERA SIRO US 29 RSG Table ter PIPER PSU UE Ue REPE EE QS 29 RSC Section Table
29. on efforts do not include these data Table Field Format Notes Comments leg number 5 Number identifying the cruise for which data was entered PK into the database rec run num number 4 Number assigned to the current run PK top interval number 6 3 Value expressed in meters Upload files express this in PK centimeters Distance from the top of the section to the top of the sample Although 150 cm is generally the length of the sections an additional 50 cm is allowed to account for core expansion or dividers used with hard rock samples bottom interval number 6 3 Value expressed in meters Distance from the top of the section to the bottom of the sample This field is not required Neither top or bottom interval are meaningful for calibration runs or control runs Ocean Drilling Program RSC Color Reflectance User s Manual 32 rsc cielab star number 6 2 CIELAB system color notation Method based on C E m COLORIMETERY Second edition Publication 15 2 1986 L is the lightness variable rsc cielab a star number 6 2 a is a chromaticity coordinate rsc cielab b star number 6 2 b is a chromaticity coordinate rsc height number 4 2 Distance in millimeters from the surface of the material to the spectrophotometer lens rsc_height_assumed_f number 1 For legacy data the height is assumed to be 1mm This lag field is set to 1 if
30. or a single run The X Y and Z color coordinates are not collected as of this writing When X Y and Z data is collected it will appear in the columns shown The individual cells of a row are NOT editable However single rows or blocks of rows can be selected by either clicking the row or clicking and dragging respectively Delete Section This button allows you to delete ALL data runs associated with the currently selected section For example in Figure 17 Run 7732 would be deleted from Section 7 Section Run 4 1 Figure 17 A section and it s associated run The following message is displayed before the function will continue Click OK to proceed or Cancel to stop the deletion Ocean Drilling Program RSC Color Reflectance User s Manual 15 You are about to delete all color reflectance runs and sample data associated with the currently selected section Are you sure you want to do this Cancel Figure 18 Warning for deleting sections Delete Run This button allows you to remove undesirable data runs from the database For example sometimes a second data run will be made on a core to verify spectrophotometer function If subsequent measurements indicate some kind of equipment or operator failure it is generally desirable to eliminate the one or more bad data runs identified 1 Highlight the run you want to eliminate 2 Click the Delete Run button The following
31. ote This program has a built in Help window To access this window click lt Ctrl H gt Place the cursor where you need help A Help window will open that displays infor mation for the troubled area Remove the help window by clicking lt Ctrl H gt again Login Procedure Figure 1 displays the Login window curjanus Password Host shore Remember Password Figure 1 The RSC Login window Navigate through the Login window with the mouse or the Tab key Tab moves the cursor forward to the next entry box and Shift Tab moves the cursor back to the previous entry box 2 Enter a USER PASSWORD and HOST into the appropriate boxes These restrict access to the central database and help to preserve data consistency and integrity 3 When RSC is started for the first time the USER and PASSWORD fields will be empty Consult the appendix on duty lab technician or MCS for valid logins Ocean Drilling Program RSC Color Reflectance User s Manual 3 4 Multiple databases are setup for production testing and development efforts Select the Test or Production database via the HOST selection box Note Be sure that HOST is in production mode during a live run 5 For subsequent logins RSC recalls the USER and HOST settings Check the Remem ber Password box if you also want the password recalled 6 If you enter an invalid USER or PASSWORD the program display
32. pectrophotometer manu als for more detail rsc specular status varcha2 3 SCI specular component included or SCE specular component excluded These are camera settings for the CM 2002 camera rsc_zero_calib_flag number 1 0 not done 1 zero calibrated Refer to the spectro photometer manuals for further details relating to zero calibration of the equipment against a standard system_id number 7 Non natural ID number for a particular laboratory system Identifies the camera and or track system used to take reflectance readings This field is not required igure 33 RSC Calibration Table Ocean Drilling Program RSC Color Reflectance User s Manual 34 Physical Properties Standard Table This table provides a central repository for information about the physical standards in use by ODP at present only for the shipboard laboratories The color reflectance database should reference only color reflectance standards The following fields are not required for entry by the database system standard name stan dard set name date time decommissioned lot serial number and comments Table Field Format Notes Comments standard id number 7 Non natural database ID used to uniquely identify a par B PK ticular standard within the database standard name varchar2 20 The name of a specific physical properties standard standard set name varchar2 20 The name
33. ram Type in RSC for the title name See Figure 24 Click the Finish button Select a Title for the Progam Select name for the shortcut Rst 5 5 2 n lt Back Cancel Figure 24 Enter the Shortcut name here 5 An RSC icon will appear on the desktop This icon should be changed to match the pro Ocean Drilling Program RSC Color Reflectance User s Manual 20 gram Click on the icon once then press lt Alt Enter gt or press Alt while double clicking on the icon 6 The RSC Properties dialog box will appear Select the Shortcut pane See Figure 25 RSC Properties i2 x General Shortcut Security RSC Target type Application Target location rsc upld Target C ODP rsc_u Start in C odp rsc_upld Shortcut Key None Run Normal window Find Target Change Icon Cancel Figure 25 The RSC Properties dialog box 7 Click on the Change Icon button This opens the Change Icon dialog box See Fig ure 26 Change Icon l2 1 xJ File Name C oDPws c upld rsc ico Current icon Cancel Browse Figure 26 The Change Icon dialog box Ocean Drilling Program RSC Color Reflectance User s Manual 21 8 Change the File Name to c odp rsc_upld rsc ico Click OK The dialog box displays the current icon Click OK again Then click OK on the RSC Properties dialog box 9
34. rmat NN NN 530nm 160 5 Value right justified and blank padded Format NN NN Ocean Drilling Program RSC Color Reflectance User s Manual 26 540nm 166 5 Value right justified and blank padded Format NN NN 550nm 172 5 Value right justified and blank padded Format NN NN 560nm 178 5 Value right justified and blank padded Format NN NN 570nm 184 5 Value right justified and blank padded Format NN NN 580nm 190 5 Value right justified and blank padded Format NN NN 590nm 196 5 Value right justified and blank padded Format NN NN 600nm 202 5 Value right justified and blank padded Format NN NN 610nm 208 5 Value right justified and blank padded Format NN NN 620nm 214 5 Value right justified and blank padded Format NN NN 630nm 220 5 Value right justified and blank padded Format NN NN 640nm 226 5 Value right justified and blank padded Format NN NN 650nm 232 5 Value right justified and blank padded Format NN NN 660nm 238 5 Value right justified and blank padded Format NN NN 670nm 244 5 Value right justified and blank padded Format NN NN 680nm 250 5 Value right justified and blank padded Format NN NN 690nm 256 5 Value right justified and blank padded Format NN NN 700nm 262 5 Value right justified and blank padded Format NN NN Figure 28 Other Columns table Some data files
35. run num number 4 PK Number assigned to the run under review igure 30 RSC Section Table RSC Control Table This table identifies color reflectance calibration runs The calibrations are run against one of the physical standards The standards are documented in the Janus physical properties stan dard table Control Table records are children of the RSC Run Table Ocean Drilling Program RSC Color Reflectance User s Manual 31 Table Field Format Notes Comments standard id number 7 PK Unique number used to link associated calibration data back to the physical standard against which the data was recorded leg number 5 PK Number identifying the cruise for which data was entered into the database rec run num number 4 PK Number assigned to the run under review igure 31 RSC Control Table RSC Run Data Table This table records the sample point data values for a section run Theoretically color reflec tance measurements are recorded for a given point In practice sample point top and bottom intervals are recorded as a Imm distance This is the minimum sample resolution allowed by the current database definition It is presently used to ensure the uniqueness of a sampling point Millimeter precision although used here is not indicative of depth measurement preci sion The tristimulus x y and z color coordinate fields are not required Present data collecti
36. s the following mes sage Unable to login Invalid user name and password or no available connection the database Figure 2 Warning for an incorrect login 7 Click OK to return to the Login window Verify the USER and PASSWORD If the login continues to fail contact an MCS or the helpdesk They will ensure that the pro gram is installed and configured properly and that the central database is available 8 Click OK or the Enter key to complete the login process Click Quit or the Esc button to exit the login procedure Ocean Drilling Program RSC Color Reflectance User s Manual 4 RSC Color Reflectance Window Purpose This window displays color reflectance data which is stored in the central database for the currently selected leg site hole core section and run It is intended for data browsing and selection and for minimal editing functions SE Color Reflectance Data Upload Edit Browse Utility Press Control H to open the Help window Point at RSC U p load er any screen object for more information Press Control H again to put away Help Leg Site Run Top Bot L Muns ell 7 40 40477 811 1233 3922 61 2780 4148 81 1171 81 27880 4072 682 1024 398 01 790 3811 58 9 3 fasyR37i6 121 2790 36 17 335 1634 B8YR35 L0 41 27940 3935 782 1217 70 38021 181 27980 4043
37. the height is assumed otherwise this field is set to 0 rsc munsell hvc varchar2 15 Munsell HVC hue value chroma Color notation ASTM D 1525 1980 Standard Method of Specifying Color By The Munsell System rsc tristimulus x number 6 2 The value measured by the camera in the x direction of the color sphere coordinates rsc tristimulus y number 6 2 The value measured by the camera in the y direction of the color sphere coordinate rsc tristimulus z number 6 2 The value measured by the camera in the z direction of the color sphere coordinate rsc first channel number 4 The first channel or wavelength measured for a color reflectance measurement in nanometers rsc_last_channel number 4 The last channel or wavelength measured for a color reflectance measurement in nanometers rsc channel incremen Number 4 The increment between measured wavelengths for a t color reflectance measurement in nanometers rsc spectra varchar2 200 Space comma delimited list of reflectance values for 0 each channel in the range specified Present upload pro grams expect space delimited values Figure 32 RSC Run Data Tabte RSC Calibration Table This table records spectrophotometer setting information at the time of a calibration run Current uploads assume that the calibration settings apply to all subsequent data runs until a new calibration is made Each calibration record is associated with only ONE standard against which measure
38. uttons to pick alternate folder defaults these are then recalled rsc config vi File Upload Default Folders Press Control H to display on line help Press Control H again to dismiss the help window Close U pload Folder 4vc develop rsc_upld data upload Transferred Folder amp vdevelopusc uplhDATANTRNFRD Change Logging Folder 9 2 Changen Figure 7 Configure directories used by uploader at this window The RSC program has three directories used to sort and track processed files After setting the configurations press the Refresh File List button on the Uploader window Note Changes in configuration are not automatically made in the list Use the Refresh File List button to do this The Upload Folder is also known as the Source Directory or Source Queue This directory stores files that are ready for upload to the database For shipboard use it is recommended that a color reflectance folder be setup on the primary data collection vol ume along with other upload files e g datal leg janus_q rsc 2 The Transferred Folder is the directory for files that have been successfully uploaded Any log messages that are generated will also move to this location For ship board use it is recommended that a transferred folder be setup on the primary data col lection volume e g datal leg trnfrd rsc 3 The Logging Folder stor
39. will have additional columns of information At one point ODP Lab Officers planned to extend the above format specifications to capture additional data about color reflec tance runs In other files these values may be artifacts of researchers editing files during a leg The specification upload parser treats the values as reflectance values uploading them into the database as such Future programs will truncate these values Ocean Drilling Program RSC Color Reflectance User s Manual 27 Example Sample Data Below are sample data lines from several color reflectance files the lines are wrapped due to margin settings on this document 169 1033 A bH T 2 9 2 1 86 31 ll 59 128 QISP 8 5 2 2 17 06 38 02 64 04 19 10 82 97 I9 79 75 04 73 48 71 91 70 50 69 87 69 13 09 30 67 89 67 62 607 56 67 46 07 57 87 73 67 81 68 00 68 33 68 45 68 65 68 77 68 94 69 11 69 20 69 33 69 57 69 74 169 1033 A tdpPp bo ELIO 11 22 04 cl 22 12578 893 3 24 2 0 26T 2116 2 93 5 23 3568 4 21 3170 5172 2 45 85 92 6 15 6 42 6 75 7 09 7 28 77 44 CL 9B T4698 2175 28 02 72255 PRP uU TJE Pere 3 27 0 223 Pa Se 28 807 167 1017 E 2H 6 149 0 149 1 32 3 0 42 5 02 8 37 3 214 08 10 12 26 53 5 52 Sats D 5 99 O19 G 41 5 01 5 76 5 06 6 94 09 I l8 1 29 7 39 3 82 7 83 7 48 Gas O PAI 245 2 2432 Tek 75425 7 48 36 7 455 7785 0 00 6 92 T 22 4 95 167 1017 E 2H 7 2 0 34 92 0 57 5 41 8 6 3 4 0 9 11 81 7 64 6 46 6 38 6
Download Pdf Manuals
Related Search