Mars Reconnaissance Orbiter
CRISM SPECTRAL LIBRARY
SOFTWARE INTERFACE SPECIFICATION
DRAFT
Prepared by:
___________________________________
Susan Slavney
PDS Geosciences Node
Approved by:
___________________________________
Scott Murchie
Principal Investigator, CRISM
March 10, 2006
|
Date |
Description |
Sections affected |
|
11/24/03 |
Initial Draft |
All |
|
3/10/06 |
Revised in preparation for peer review |
All |
|
Section |
Description |
|
3.1 Spectral Data Sets |
Describe data sets contributed to Spectral Library |
|
5. Schedule |
Complete dates in schedule |
DOCUMENT CHANGE LOG........................................................................................................ ii
TBD ITEMS.................................................................................................................................... ii
CONTENTS.................................................................................................................................. iii
ACRONYMS................................................................................................................................ iv
1. INTRODUCTION....................................................................................................................... 1
1.1 Purpose and Scope................................................................................................................. 1
1.2 Applicable Documents and Constraints.................................................................................... 1
1.3 Relationships with Other Interfaces........................................... Error! Bookmark not defined.
2. Overview of the Spectral Library Concept......................................................... 1
3. CRISM Spectral Library Components....................................................................... 2
3.1 Spectral Data Sets................................................................................................................... 2
3.2 Relational Data Base............................................................................................................... 2
3.3 User Interface......................................................................................................................... 3
4. roles and responsibilities............................................................................................ 3
5. Schedule................................................................................................................................. 4
APPENDIX A: Data Base Schema.......................................................................................... 1
APPENDIX B: Example PDS Label......................................................................................... 1
APPENDIX C: Data Dictionary............................................................................................ 1
APPENDIX D: Sources for Spectral Library Data Base Elements..................... 1
APPENDIX E: Specimen Classification Scheme........................................................... 1
1.
INTRODUCTION 5
1.1 Purpose 5
1.2 Scope 5
1.3 Contents 5
1.4 Applicable Documents and Constraints 5
2. ARCHIVING OVERVIEW 6
2.1 Mission Overview 6
2.2 Archiving Flow 6
3. ROLES AND RESPONSIBILITIES 7
3.1 Mars Surveyor 2003 Project Responsibilities 7
3.2 Planetary Data System Responsibilities 8
3.3 National Space Science Data Center
Responsibilities 8
4. DETAILED ARCHIVE GENERATION, VALIDATION AND
RELEASE SCHEDULES 8
FIGURES
Figure
1. Mission Timeline (TBD) 9
Figure 2. Flow of MER archive volume generation,
validation, and transfer (TBD) 10
TABLES
|
APL |
Applied Physics Laboratory |
|
CRISM |
Compact Reconnaissance Imager and Spectrometer for Mars |
|
DDR |
Derived Data Record |
|
EDR |
Experiment Data Record |
|
JPL |
Jet Propulsion Laboratory |
|
MRO |
Mars Reconnaissance Orbiter |
|
PDS |
Planetary Data System |
|
RDR |
Reduced Data Record |
|
SIS |
Software Interface Specification |
|
SOC |
Science Operations Center |
|
TBD |
To Be Determined |
The purpose of this Software Interface Specification is to describe the structure and content of the CRISM Spectral Library, including its component data sets, a data base of metadata, and a web-based user interface to the data.
This SIS is responsive to the following Mars
Surveyor 2003Mars Reconnaissance Orbiter documents:
1. Guidelines for Spectral Library Generation, Documentation, Dissemination, and Archiving, PDS Geosciences Node and CRISM Spectral Library Working Group, October 31, 2002.
2. Mars
Surveyor ProgramMars Exploration Program Data
Management Plan, R. E. Arvidson and S. Slavney, Rev. 1.112,
Nov. 2, 2000.
3. Mars Reconnaissance Orbiter Project Data Archive Generation, Validation and Transfer Plan, R. E. Arvidson, S. Noland and S. Slavney, November 11, 2003.
4. Mars Reconnaissance Orbiter (MRO) Compact Reconnaissance Imager and Spectrometer for Mars (CRISM) Experiment Operations Plan, B. E. Tossman and S. L Murchie, Rev. 1.5, September 2003.
This SIS is also consistent with the following Planetary Data System documents:
5. Planetary Data System Archive Preparation Guide, May 3, 2005.
6. Planetary Data System Data Standards Reference, Version 3.6, JPL D-7669, Part 2, August 1, 2003.
7. Planetary Science Data Dictionary Document, JPL D-7116, Rev. E, August 28, 2002.
·Mission Operations
(reference TBD)
The plan is consistent with the principles delineated
in the following National Academy of Sciences reports:
·Data Management and
Computation, Volume 1, Issues and Recommendations, 1982, National Academy
Press, 167 p.
·Issues and
Recommendations Associated with Distributed Computation and Data Management
Systems for the Space Sciences, 1986, National Academy Press, 111 p.
The plan is also consistent with the following
Planetary Data System documents:
·Planetary Data System
Data Preparation Workbook, February 1, 1995, Version 3.1, JPL D-7669, Part 1.
·Planetary Data System
Data Standards Reference, June 1, 1999, Version 3.3, JPL D-7669, Part 2.
Finally, this SIS is meant to be consistent with the contract negotiated between the Mars Reconnaissance Orbiter Project and the CRISM Principal Investigator (PI) in which reduced data records and documentation are explicitly defined as deliverable products.
A spectral library is defined to be a set of spectral observations of some set of targets or samples, together with documentation and correlative data that provide additional information of use in analyses of the primary observations. The primary observations could, for example, be acquired in transmission, reflection, or emission. The correlative data, including X-Ray fluorescence, X-Ray diffraction, Mössbauer, and petrographic data, provide added scientific benefit during analyses of spectral data.
Uses of spectral libraries range from fundamental characterization of materials to comparisons with spaceborne and telescopic observations. For example, the Mars Express OMEGA and Mars Reconnaissance Orbiter CRISM instruments are both imaging spectrometers that will operate in the VNIR spectral range (~400 to 5000 nm). One mode of data analysis is to process the spaceborne data to spectral reflectance and to then compare the observational spectra (manually or automatically) to library spectra to find matches. Good library spectral matches to spaceborne data, based on least squares or other approaches, provide a starting point for consideration of what materials are on the surface of Mars. To optimally conduct these comparisons, the normally higher-quality data in the spectral libraries would typically be degraded to match the observational data. Furthermore, the library samples must be well understood in terms of what controls their spectral properties, which implies well characterized samples (e.g., inclusion of major element analyses and Mössbauer spectra).
The CRISM Team agrees to deliver to the Planetary Data System the CRISM Spectral Library as part of its science data archive. The Spectral Library includes several spectral data sets generated by individual team members, along with a relational data base of metadata – information about the spectral data – that can be queried to select individual spectra of interest. A web-based user interface permits remote queries of the data base and allows plotting and downloading of selected spectra. The data base and user interface are designed to allow the incorporation of additional spectral data sets as they become available.
The CRISM Spectral Library will be accessible online from the PDS Geosciences Node through the user interface.
The following data have been contributed to the CRISM Spectral Library.
(Bishop tbd)
(Mustard tbd)
(Morris tbd)
(Roush tbd)
All of the above data sets are formatted as ASCII tables with attached PDS labels. The labels include keywords that identify the specimen being analyzed and describe the type(s) of analysis performed. An example label is shown in Appendix A. Definitions of the label keywords are in Appendix B. Keywords shown in gray are defined in the Mars Reconnaissance Orbiter Local Data Dictionary within PDS.
An important label keyword is SPECIMEN_CLASS_NAME, which represents the classification of the specimen being analyzed according to a classification scheme developed specifically for the CRISM Spectral Library. This classification scheme is described in Appendix C.
Information about the spectral data sets is stored in a relational data base that can be queried to select individual data files, where a file contains one or more analyses of a given specimen. The data base information is extracted from the PDS labels for the most part, and most elements in the data base correspond directly to label keywords. The data dictionary in Appendix B shows the mapping of label keywords to data base elements. A diagram of the data base schema is shown in Appendix D. The source for each data base element is listed in Appendix E.
A web-accessible user interface to the Spectral Library data base enables searching and downloading at the level of individual files. Searches are based on the classification scheme outlined in Appendix C and on other information from the data labels.
CRISM Team Members are responsible for providing spectral data sets along with the supporting information required by PDS, specifically PDS data labels and documentation files for the PDS catalog. Data labels must include the keywords specified in Appendix B, as applicable. Catalog information must be provided in the format specified in the PDS Standards Reference (Applicable Document 6). Data providers are encouraged to supply additional documentation or references to published literature as appropriate for their data sets.
The data providers are responsible for participating in the CRISM Spectral Library Working Group, which determines the Classification Scheme (Appendix C), the set of PDS label keywords used to describe spectral data, and the requirements for the user interface.
The data providers are also responsible for examining their data sets via the user interface, once they have been incorporated into the Spectral Library, to ensure that the data can be accessed as expected.
The PDS Geosciences Node is responsible for receiving spectral data sets and associated documentation and assembling them into complete archive volumes for submission to PDS. (See the PDS Standards Reference for the contents and format of archive volumes.) The Geosciences Node will validate the PDS labels and catalog information, and will work with the data providers to make any necessary changes. The Node will generate index tables and other archive components that do not require input from the data providers. When a data provider is ready to submit a data set to PDS, the Geosciences Node will arrange the required peer review and work with the PDS Central Node to get the data set accepted. The spectral data sets will be made available online as part of the Geosciences Node online data repository.
The Geosciences Node is responsible for designing, building, and maintaining the Spectral Library relational data base. The Node will populate the data base from information in the spectral data labels. It will maintain the data base as an online resource for queries from the Spectral Library user interface.
The Geosciences Node is responsible for designing, building, and maintaining the Spectral Library user interface. The interface will be made available online, at first with access restricted to CRISM team members, and later as a public resource after the spectral data sets have been released to the PDS.
|
Task |
Date of completion |
|
Spectral Library user interface requirements from Spectral Library Working Group |
|
|
Spectral Library user interface designed and working prototype built |
|
|
Spectral Library data base designed and working prototype built |
|
|
PDS labels for spectral data sets designed with input from Working Group |
|
|
Spectral data sets delivered to Geosciences Node |
October 31, 2003 |
|
Spectral Library data base populated |
November 13, 2003 |
|
Data providers test user interface |
November 17 – 25, 2003 |
|
User interface revised |
December 1 – 11, 2003 |
|
Spectral Library released internally to CRISM Team |
December 15, 2003 |
|
Spectral data sets and supporting materials assembled into PDS archives |
|
|
Spectral Library delivered by CRISM Team to PDS |
MRO orbit insertion, March 10, 2006 |
|
Peer review of spectral data sets |
|
|
Spectral Library released by PDS to public |
|
APPENDIX A: Example PDS Label
PDS_VERSION_ID = PDS3
/* File characteristics */
RECORD_TYPE = STREAM
FILE_RECORDS = 2409
LABEL_RECORDS = 119
^TABLE = 120
/* Identification keywords */
DATA_SET_ID = "MRO-M-CRISM-4-SPECLIB-V1.0"
PRODUCT_ID = "LACB41B"
PRODUCT_NAME = "CB-EAC-041-B"
PRODUCT_TYPE = "VNIR-MIR"
PRODUCT_CREATION_TIME = 2003-11-14T16:09:18
PRODUCT_VERSION_ID = "1.0"
PRODUCER_ID = "EACLOUTIS"
PRODUCER_FULL_NAME = "Edward A. Cloutis"
PRODUCER_INSTITUTION_NAME = "University of Winnipeg"
TARGET_NAME = "N/A"
MRO:SPECIMEN_NAME = "CRB401B"
MRO:SPECIMEN_DESC = "Synthetic sample from Mallinckrodt
Chemical Co."
MRO:SPECIMEN_CLASS_NAME = "Mineral, Carbonate, Ammonium Carbonate
(NH4)CO3"
MRO:SPECIMEN_MIN_PARTICLE_SIZE = 0.045 <MM>
MRO:SPECIMEN_MAX_PARTICLE_SIZE = 0.090 <MM>
MRO:SPECIMEN_COLLECT_LOCATION_DESC= "UNK"
MRO:SPECIMEN_COLLECT_LOCATION_NAME= "Synthetic"
MRO:SPECIMEN_LAST_OWNER = "Edward A. Cloutis"
CITATION_DESC = "tbd"
GROUP = ANALYSIS_1_PARAMETERS
INSTRUMENT_ID = "BDVNIR_RELAB"
INSTRUMENT_NAME = "RELAB Bidirectional Reflectance
Spectrometer"
INSTRUMENT_HOST_NAME = "RELAB"
EARTH_BASE_INSTITUTION_NAME = "BROWN UNIVERSITY"
SAMPLING_PARAMETER_NAME = "WAVELENGTH"
MINIMUM_SAMPLING_PARAMETER = 0.300 <MICROMETERS>
MAXIMUM_SAMPLING_PARAMETER = 2.4950 <MICROMETERS>
SAMPLING_PARAMETER_INTERVAL = 0.005 <MICROMETERS>
SAMPLING_DESC = 'N/A'
MRO:MEASUREMENT_MIN_RESOLUTION = 1 <NM>
MRO:MEASUREMENT_MAX_RESOLUTION = 7 <NM>
MRO:MEASUREMENT_GEOMETRY_TYPE = "BIDIRECTIONAL"
INCIDENCE_ANGLE = 30 <DEG>
EMISSION_ANGLE = 0 <DEG>
PHASE_ANGLE = 30 <DEG>
AZIMUTH = 'N/A'
MRO:MEASUREMENT_GEOMETRY_DESC = 'N/A'
MRO:MEASUREMENT_PRESSURE = 1.0 <ATM>
MRO:MEASUREMENT_TEMPERATURE = 295 <K>
MRO:MEASUREMENT_MASS = 'N/A'
MEASUREMENT_STANDARD_DESC = "Halon"
MRO:MEASUREMENT_ATM_COMPOSITION = "ambient"
MEASUREMENT_ATMOSPHERE_DESC = "ambient"
START_TIME = 2000-05-19T00:00:00
STOP_TIME = 'N/A'
NOTE = "Ratios adjusted using NBS halon
calibration table"
END_GROUP = ANALYSIS_1_PARAMETERS
GROUP = ANALYSIS_2_PARAMETERS
INSTRUMENT_ID = "NIC740_RELAB"
INSTRUMENT_NAME = "RELAB Nicolet 740 Fourier Transform
IR Spectrometer"
INSTRUMENT_HOST_NAME = "RELAB"
EARTH_BASE_INSTITUTION_NAME = "BROWN UNIVERSITY"
SAMPLING_PARAMETER_NAME = "WAVELENGTH"
MINIMUM_SAMPLING_PARAMETER = 2.500000 <MICROMETERS>
MAXIMUM_SAMPLING_PARAMETER = 25.920679 <MICROMETERS>
SAMPLING_PARAMETER_INTERVAL = 4 <CM**-1>
SAMPLING_DESC = 'N/A'
MRO:MEASUREMENT_MIN_RESOLUTION = 4 <CM**-1>
MRO:MEASUREMENT_MAX_RESOLUTION = 4 <CM**-1>
MRO:MEASUREMENT_GEOMETRY_TYPE = "BICONICAL"
INCIDENCE_ANGLE = 'N/A'
EMISSION_ANGLE = 'N/A'
PHASE_ANGLE = 'N/A'
AZIMUTH = 'N/A'
MRO:MEASUREMENT_GEOMETRY_DESC = 'N/A'
MRO:MEASUREMENT_PRESSURE = 1.0 <ATM>
MRO:MEASUREMENT_TEMPERATURE = 295 <K>
MRO:MEASUREMENT_MASS = 'N/A'
MEASUREMENT_STANDARD_DESC = "halon and diffuse gold"
MRO:MEASUREMENT_ATM_COMPOSITION = "N2, O2"
MRO:MEASUREMENT_ATMOSPHERE_DESC =
"12 hour purge with N2 and O2 scrubbed air"
START_TIME = 2000-05-19T00:00:00
STOP_TIME = 'N/A'
END_GROUP = ANALYSIS_2_PARAMETERS
REFERENCE_KEY_ID = "BISHOPETAL1995"
/* Data description */
OBJECT = TABLE
NAME = "CB-EAC-041-B"
INTERCHANGE_FORMAT = ASCII
RECORD_FORMAT = "(F9.2, F10.6)"
ROWS = 2314
ROW_BYTES = 19
COLUMNS = 2
OBJECT = COLUMN
COLUMN_NUMBER = 1
NAME = "WAVELENGTH"
DESCRIPTION = "Wavelength (X-axis)"
DATA_TYPE = "ASCII_REAL"
UNIT = "Nanometer"
MINIMUM = 300.0
MAXIMUM = 25920.68
START_BYTE = 1
BYTES = 9
FORMAT = "(F9.2)"
END_OBJECT = COLUMN
OBJECT = COLUMN
COLUMN_NUMBER = 2
NAME = "ABSOLUTE REFLECTANCE"
DESCRIPTION = "Absolute reflectance (Y-axis)"
DATA_TYPE = "ASCII_REAL"
UNIT = "DIMENSIONLESS"
START_BYTE = 10
BYTES = 10
FORMAT = "(F10.6)"
END_OBJECT = COLUMN
END_OBJECT = TABLE
END
APPENDIX B: Data Dictionary
Table B-1. Definitions of Keywords Used in PDS Labels for CRISM Spectral Library Data Sets. Keywords with a gray background are defined in the Mars Reconnaissance Orbiter Local Data Dictionary.
|
Keyword Name |
Required in PDS label? |
Already |
Definition |
Used to Populate This Data Base Element |
|
AZIMUTH |
no |
yes |
Angular distance from a fixed reference point |
Azimuth |
|
BYTES |
yes |
yes |
Number of bytes (characters) in column |
N/A |
|
CITATION_DESC |
no |
yes |
Complete reference to be used when citing this product, in AGU format |
Citation |
|
COLUMN_NUMBER |
no |
yes |
Ordinal number of the column in the file, starting with 1 |
ColumnNumber |
|
COLUMNS |
yes |
yes |
Number of columns in the table |
Columns |
|
DATA_QUALITY_DESC |
yes |
no |
Detailed explanation of data quality ID |
N/A |
|
DATA_QUALITY_ID |
yes |
no |
Data quality code explained in DATA_QUALITY_DESC |
QualityFlag |
|
DATA_SET_ID |
yes |
yes |
Unique ID for data set |
DataSetID |
|
DATA_TYPE |
yes |
yes |
Type of data in column |
N/A |
|
DESCRIPTION |
no |
yes |
Description of the column |
N/A |
|
EARTH_BASE_INSTITUTION_NAME |
no |
yes |
Name of institution where laboratory is located, e.g. "BROWN UNIVERSITY" |
InstitutionName |
|
EMISSION_ANGLE |
no |
yes |
Angle between the local vertical at the intercept point and a vector from the intercept point to the sensor. |
EmissionAngle |
|
FILE_RECORDS |
yes |
yes |
Total number of records in the file |
N/A |
|
FORMAT |
no |
yes |
FORTRAN-style format description for reading one element in the column |
N/A |
|
INCIDENCE_ANGLE |
no |
yes |
Angle between the local vertical at the intercept point and a vector from the intercept point to the light source. |
IncidenceAngle |
|
INSTRUMENT_HOST_NAME |
yes |
yes |
Name of laboratory, e.g. "RELAB" |
FacilityName |
|
INSTRUMENT_ID |
no |
yes |
Short name or acronym for instrument |
InstrumentID |
|
INSTRUMENT_NAME |
yes |
yes |
Full name of instrument |
InstrumentName |
|
INTERCHANGE_FORMAT |
yes |
yes |
Storage format |
N/A |
|
LABEL_RECORDS |
only if label is attached |
yes |
Number of label records in the file |
N/A |
|
MAXIMUM |
no |
yes |
Maximum data value in the column |
N/A |
|
MAXIMUM_SAMPLING_PARAMETER |
no |
yes |
Maximum value at which a given data item was sampled. For example, a spectrum that was measured in the 0.4 to 3.5 micrometer spectral region would have a maximum sampling parameter value of 3.5. |
SpectralRangeMax |
|
MEASUREMENT_ATM_COMPOSITION |
no |
no |
Identifies gas(es) present in measurement environment (called "environment purge gas" in data base) |
EnvironmentPurgeGas |
|
MEASUREMENT_ATMOSPHERE_DESC |
no |
yes |
Describes the atmospheric conditions through which data were taken. |
AtmosphereDescription |
|
MEASUREMENT_GEOMETRY_DESC |
no |
no |
Details of measurement geometry |
Geometry |
|
MEASUREMENT_GEOMETRY_TYPE |
no |
no |
Examples: "Directional hemispherical", "Hemispherical directional", "Bidirectional, radiance factor", "Bidirectional, radiance coefficient", etc. |
MeasurementType |
|
MEASUREMENT_MASS |
no |
no |
Mass of measurement |
MeasurementMass |
|
MEASUREMENT_MAX_RESOLUTION |
no |
no |
Maximum spectral resolution of measurement |
SpectralResolutionMax |
|
MEASUREMENT_MIN_RESOLUTION |
no |
no |
Minimum spectral resolution of measurement |
SpectralResolutionMin |
|
MEASUREMENT_PRESSURE |
no |
no |
Atmospheric pressure of measurement environment |
EnvironmentPressure |
|
MEASUREMENT_STANDARD_DESC |
no |
yes |
Identifies the standard object on which observations are performed in order to calibrate an instrument. |
WhiteReference |
|
MEASUREMENT_TEMPERATURE |
no |
no |
Temperature of measurement environment |
EnvironmentTemperature |
|
MINIMUM |
no |
yes |
Minimum data value in the column |
N/A |
|
MINIMUM_SAMPLING_PARAMETER |
no |
yes |
Minimum value at which a given data item was sampled. For example, a spectrum that was measured in the 0.4 to 3.5 micrometer spectral region would have a minimum sampling parameter value of 0.4. |
SpectralRangeMin |
|
NAME |
no |
yes |
Optional name of data table |
N/A |
|
NAME |
yes |
yes |
Name of the column |
ColumnName |
|
NOTE |
no |
yes |
Miscellaneous notes or comments |
N/A |
|
PDS_VERSION_ID |
yes |
yes |
Means label conforms to PDS Standards Reference Version 3.x |
N/A |
|
PHASE_ANGLE |
no |
yes |
Angle between the vector from the intercept point to the light source and the vector from the intercept point to the sensor. |
PhaseAngle |
|
PRODUCER_FULL_NAME |
no |
yes |
Full name of individual or group |
PersonName |
|
PRODUCER_ID |
no |
yes |
Short name or acronym of individual or group |
PersonID |
|
PRODUCER_INSTITUTION_NAME |
no |
yes |
Producer's institution |
InstitutionName |
|
PRODUCT_CREATION_TIME |
yes |
yes |
UTC time when product was created |
ProductCreationTime |
|
PRODUCT_ID |
yes |
yes |
Unique ID for data file |
AnalysisID |
|
PRODUCT_NAME |
no |
yes |
Descriptive name for product |
AnalysisName |
|
PRODUCT_TYPE |
no |
yes |
Type or category |
ProductType |
|
PRODUCT_VERSION_ID |
no |
yes |
Incremented each time product is revised |
ProductVersionID |
|
RECORD_BYTES |
only if record type is FIXED_ |
yes |
Length of one record in bytes (characters), including the required carriage-return and line-feed characters at the end of the line |
N/A |
|
RECORD_FORMAT |
no |
yes |
FORTRAN-style format description for reading one row of the table |
N/A |
|
RECORD_TYPE |
yes |
yes |
Type of records in data file. Use STREAM (variable-length text records) if file has attached label. |
N/A |
|
REFERENCE_KEY_ID |
yes |
yes |
Identifier for a reference (citation) formed according to PDS rules |
ReferenceID |
|
ROW_BYTES |
yes |
yes |
Number of bytes (characters) per row |
N/A |
|
ROWS |
yes |
yes |
Number of rows in the table |
N/A |
|
SAMPLING_DESC |
no |
yes |
Describes how instrument parameters are sampled within an instrument or a section of an instrument. Generally, this includes information on the timing of samples and how they are taken as a function of energy, frequency, wavelength, position, etc. |
SamplingDescription |
|
SAMPLING_PARAMETER_INTERVAL |
no |
yes |
The spacing of points at which data are sampled and at which a value for an instrument or dataset parameter is available. This sampling interval can be either the original (raw) sampling or the result of some resampling process. |
SpectralSamplingIntervalMin, |
|
SAMPLING_PARAMETER_NAME |
no |
yes |
Name of the parameter which determines the sampling interval of a particular instrument or dataset parameter, e.g. WAVELENGTH, FREQUENCY, TIME. |
SamplingParameterName |
|
SOFTWARE_NAME |
no |
yes |
Data processing software such as a program or a program library. |
N/A |
|
SOFTWARE_VERSION_ID |
no |
yes |
The version (development level) of a program or a program library. |
N/A |
|
SOURCE_PRODUCT_ID |
no |
yes |
ID of product(s) from which this product was made |
N/A |
|
SPECIMEN_CLASS_NAME |
no |
no |
Specimen classification name according to sample classification scheme |
MaterialType, MaterialOrigin, Classification, RockClass, RockType, RockSubtype, TexturalModifier, MineralClass, MineralGroup, MineralSpecies, OrganicType, IceType, IceFormula, UnconsolidatedClass, UnconsolidatedType, UnconsolidatedSubtype |
|
SPECIMEN_COLLECT_LOCATION_DESC |
no |
no |
Description of location where specimen was collected |
SampleCollectionLocality |
|
SPECIMEN_CURRENT_LOCATION_NAME |
no |
no |
Institution or laboratory name where specimen is currently located, or UNK |
SampleStorageLocationID |
|
SPECIMEN_DESC |
no |
no |
Specimen (sample) description |
Description |
|
SPECIMEN_LAST_OWNER_NAME |
no |
no |
Name of individual or laboratory to whom specimen belongs |
SupplierID |
|
SPECIMEN_MAX_PARTICLE_SIZE |
no |
no |
Maximum particle size of specimen |
ParticleSizeMax |
|
SPECIMEN_MIN_PARTICLE_SIZE |
no |
no |
Minimum particle size of specimen |
ParticleSizeMin |
|
SPECIMEN_NAME |
no |
no |
Unique specimen (sample) name |
SampleName, SampleID |
|
START_BYTE |
yes |
yes |
Byte number at which column starts; first byte in a row is byte 1 |
N/A |
|
START_TIME |
yes |
yes |
The date and time of the beginning of an event or observation (whether it be a spacecraft, ground-based, or system event) in UTC format. |
AnalysisDateTime |
|
STOP_TIME |
yes |
yes |
The date and time of the end of an event or observation (whether it be a spacecraft, ground-based, or system event) in UTC format, or N/A if start and stop time are the same. |
N/A |
|
^TABLE |
yes |
yes |
Pointer to the data described by this label. The carat ^ is required. |
N/A |
|
TARGET_NAME |
yes |
yes |
Observation target, e.g. planet, satellite, feature |
N/A |
|
UNIT |
No |
yes |
Unit of measurement of the column |
ColumnUnits |
APPENDIX C: Specimen Classification Scheme

Notes:
1. "From Natural" is a natural product chemically or mineralogically altered by a laboratory treatment (e.g., heating). Does not include size and magnetic separates of natural samples.
2. Volatile Poor = <2.0% LOI; Volatile Rich = >2.0% LOI (number is tentative).
3. Suprabasic <20% SiO2; Ultrabasic 20-45% SiO2; Basic 45-52% SiO2; Intermediate 52-68% SiO2; Acidic >68% SiO2. SiO2 calculated on a volatile-free basis.



APPENDIX D: Data Base Schema
The figure shows tables and their elements in the CRISM Spectral Library relational data base. Each table's primary key, the element that uniquely identifies each record, is indicated by the key symbol. Connectors between tables show relationships between records in the tables, either as one-to-one (shown with a key symbol at each endpoint) or one-to-many (shown with an infinity symbol at the "many" endpoint). Elements are mapped to PDS label keywords in Appendix D. The keywords are defined in the Data Dictionary (Appendix C).
APPENDIX E: Sources for Spectral Library Data Base Elements
|
Data Base Element |
Data type |
Tables in which element appears |
Label keyword or other source for data |
|
AnalysisDateTime |
datetime |
segments |
START_TIME |
|
AnalysisID |
char(15) |
analyses, analysis_contacts, analysis_refs, segments, spectra_files, spectra_file_columns |
PRODUCT_ID |
|
AnalysisName |
varchar(80) |
analyses |
PRODUCT_NAME |
|
AtmosphereDescription |
text |
segments |
MEASUREMENT_ATMOSPHERE_DESC |
|
Azimuth |
real |
segments |
AZIMUTH |
|
Citation |
varchar(255) |
refs |
CITATION_DESC |
|
Classification |
varchar(50) |
samples |
Third item in SPECIMEN_CLASS_NAME |
|
ColumnName |
varchar(50) |
spectra_file_columns |
NAME (in COLUMN object) |
|
ColumnNumber |
smallint |
spectra_file_columns |
COLUMN_NUMBER |
|
Columns |
smallint |
spectra_files |
COLUMNS |
|
ColumnUnits |
varchar(50) |
spectra_file_columns |
UNIT (in COLUMN object) |
|
DataFileName |
varchar(50) |
spectra_file_columns, spectra_files |
Data file name |
|
DataSetID |
varchar(40) |
analyses |
DATA_SET_ID |
|
Description |
text |
ice, minerals, organic, rocks, unconsolidated |
SPECIMEN_DESC |
|
|
varchar(50) |
people |
Email address provided by data supplier |
|
EmissionAngle |
real |
segments |
EMISSION_ANGLE |
|
EnvironmentPressure |
varchar(50) |
segments |
MEASUREMENT_PRESSURE |
|
EnvironmentPurgeGas |
varchar(50) |
segments |
MEASUREMENT_ATM_COMPOSITION |
|
EnvironmentTemperature |
varchar(50) |
segments |
MEASUREMENT_TEMPERATURE |
|
FacilityID |
varchar(50) |
analyses, facilities, instruments, people |
Short version of INSTRUMENT_HOST_NAME (INSTRUMENT_HOST_ID from inst.cat) |
|
FacilityName |
varchar(50) |
facilities |
INSTRUMENT_HOST_NAME |
|
Geometry |
varchar(50) |
segments |
MEASUREMENT_GEOMETRY_DESC |
|
IceFormula |
char(32) |
ice |
Fifth item in SPECIMEN_CLASS_NAME, if Classification = "ICE" |
|
IceType |
char(16) |
ice |
Fourth item in SPECIMEN_CLASS_NAME, if Classification = "ICE" |
|
IncidenceAngle |
real |
segments |
INCIDENCE_ANGLE |
|
InstitutionCity |
varchar(50) |
facilities |
Provided by data supplier |
|
InstitutionCountry |
varchar(50) |
facilities |
Provided by data supplier |
|
InstitutionName |
varchar(50) |
facilities |
PRODUCER_INSTITUTION_NAME, EARTH_BASE_INSTITUTION_NAME |
|
InstitutionPostalCode |
varchar(50) |
facilities |
Data supplier |
|
InstitutionState |
varchar(50) |
facilities |
Data supplier |
|
InstitutStreetAddr |
varchar(50) |
facilities |
Provided by data supplier |
|
InstrumentID |
varchar(50) |
instruments, segments |
INSTRUMENT_ID |
|
InstrumentName |
varchar(50) |
instruments |
INSTRUMENT_NAME |
|
InstrumentType |
varchar(50) |
instruments |
INSTRUMENT_TYPE from inst.cat |
|
Mailstop |
varchar(50) |
people |
Provided by data supplier |
|
MaterialOrigin |
varchar(50) |
samples |
Second item in SPECIMEN_CLASS_NAME |
|
MaterialType |
varchar(50) |
samples |
First item in SPECIMEN_CLASS_NAME |
|
MeasurementMass |
real |
segments |
MEASUREMENT_MASS |
|
MeasurementType |
varchar(50) |
segments |
MEASUREMENT_GEOMETRY_TYPE |
|
MineralClass |
char(32) |
minerals |
Fourth item in SPECIMEN_CLASS_NAME, if Classification = "MINERAL" |
|
MineralGroup |
char(32) |
minerals |
Fifth item in SPECIMEN_CLASS_NAME, if Classification = "MINERAL" |
|
MineralSpecies |
char(32) |
minerals |
Sixth item in SPECIMEN_CLASS_NAME, if Classification = "MINERAL" |
|
OrganicType |
char(32) |
organic |
Fourth item in SPECIMEN_CLASS_NAME, if Classification = "ORGANIC" |
|
ParticleSizeMax |
real |
ice, minerals, organic, rocks, unconsolidated |
SPECIMEN_MAX_PARTICLE |
|
ParticleSizeMin |
real |
ice, minerals, organic, rocks, unconsolidated |
SPECIMEN_MIN_PARTICLE |
|
PersonID |
char(30) |
analysis_contacts, people, sample_contacts |
Short version of
PRODUCER_FULL_NAME |
|
PersonName |
varchar(50) |
people |
PRODUCER_FULL_NAME, SPECIMEN_LAST_OWNER_NAME |
|
PhaseAngle |
real |
segments |
PHASE_ANGLE |
|
Phone |
varchar(50) |
people |
Provided by data supplier |
|
ProductCreationTime |
datetime |
analyses |
PRODUCT_CREATION_TIME |
|
ProductType |
varchar(50) |
analyses |
PRODUCT_TYPE |
|
ProductVersionID |
char(12) |
analyses |
PRODUCT_VERSION_ID |
|
QualityFlag |
int |
ice, minerals, organic, rocks, unconsolidated |
DATA_QUALITY_ID |
|
ReferenceID |
varchar(50) |
analysis_refs, refs, sample_refs |
REFERENCE_KEY_ID |
|
RockClass |
char(32) |
rocks |
Fourth item in SPECIMEN_CLASS_NAME, if Classification = "ROCK" |
|
RockSubtype |
char(32) |
rocks |
Sixth item in SPECIMEN_CLASS_NAME, if Classification = "ROCK" |
|
RockType |
char(32) |
rocks |
Fifth item in SPECIMEN_CLASS_NAME, if Classification = "ROCK" |
|
SampleCollectionLocality |
varchar(64) |
samples |
SPECIMEN_COLLECT_LOCATION_DESC |
|
SampleID |
char(15) |
analyses, analysis_contacts, analysis_refs, ice, minerals, organic, rocks, unconsolidated, sample_contacts, sample_refs, samples, segments, spectra_files, spectra_file_columns |
Short, unique version of SPECIMEN_NAME |
|
SampleName |
varchar(64) |
samples |
SPECIMEN_NAME |
|
SampleStorageLocationID |
varchar(50) |
samples |
SPECIMEN_CURRENT_LOCATION_NAME |
|
SamplingDescription |
text |
segments |
SAMPLING_DESC |
|
SamplingParameterName |
varchar(40) |
segments |
SAMPLING_PARAMETER_NAME |
|
SegmentID |
char(15) |
segments, spectra_files, spectra_file_columns |
Assigned 1, 2, 3, etc. |
|
SpectralRangeMax |
real |
analyses, segments |
MAXIMUM_SAMPLING_PARAMETER |
|
SpectralRangeMin |
real |
analyses, segments |
MINIMUM_SAMPLING_PARAMETER |
|
SpectralResolutionMax |
real |
segments |
MEASUREMENT_MAX_RESOLUTION |
|
SpectralResolutionMin |
real |
segments |
MEASUREMENT_MIN_RESOLUTION |
|
SpectralSamplingIntervalMax |
real |
segments |
SAMPLING_PARAMETER_INTERVAL max value |
|
SpectralSamplingIntervalMin |
real |
segments |
SAMPLING_PARAMETER_INTERVAL min value |
|
SupplierID |
char(32) |
samples |
Short version of SPECIMEN_LAST_OWNER_NAME |
|
TexturalModifier |
char(32) |
rocks |
Seventh item in SPECIMEN_CLASS_NAME, if Classification = "ROCK" |
|
UnconsolidatedClass |
char(32) |
unconsolidated |
Fourth item in SPECIMEN_CLASS_NAME, if Classification = "UNCONSOLIDATED" |
|
UnconsolidatedSubtype |
char(32) |
unconsolidated |
Sixth item in SPECIMEN_CLASS_NAME, if Classification = "UNCONSOLIDATED" |
|
UnconsolidatedType |
char(32) |
unconsolidated |
Fifth item in SPECIMEN_CLASS_NAME, if Classification = "UNCONSOLIDATED" |
|
WhiteReference |
varchar(50) |
segments |
MEASUREMENT_STANDARD_DESC |