HiRISE: HiCat Data Dictionary HiRISE.SPICE

HiCat Data Dictionary

Catalog: HiRISE: The main HiRISE catalog contains all the information used in operating the HiRISE camera after it is attached to the MRO spacecraft. The information is divided into those related to suggesting, planning, commanding, retrieving, processing, validating, and distributing the observations. The tag that follows an observation through all these catalogs (and from Earth to Mars and back) is the unique Observation_ID. This ID is available in both a 32-bit binary code and a user-friendly text representation. This text representation also forms the core of the product names. The HiRISE catalog also contains ancillary information needed in various uplink and downlink activities, such as the people making image suggestions, MRO project uplink files, SPICE and engineering data, and public image releases.
Table:SPICE

Field	Description	Type	Null	Key
ID	This is the unique ID for each SPICE kernel. The values here should not be assigned by external programs. Instead it can either be ignored, or NULL can be inserted, and the database will automatically assign the next ID.	INT(10) unsigned auto_increment	Not Null	Primary Key
KERNAL_NAME	The name for this kernel.	VARCHAR(50)
PATHNAME	The full logical path (filename included) of this SPICE kernel file within the HiRISE filesystem.	VARCHAR(128)
VERSION	The kernel's version.	VARCHAR(20)
CURRENT_VERSION_CREATE_TIME	The date that the current version was created.	DATETIME
PREVIOUS_VERSION_CREATE_TIME	The date that the previous version was created.	DATETIME
ACQUISITION_TIME	The time that the kernel was acquired?? Laz: I'm confused... I guess its the time we got it at HiROC.	DATETIME
KERNAL_TYPE	The type of kernel that this is.	ENUM("BSP", "TLS", "TSC", "SPKS", "CKS", "FK", "IK", "PCK")
KERNAL_DESCRIPTION	?? Laz: There are C-kernels, I kernels, frame kernels, and lots of other kernels... Eric knows this well, Brad has taken training...	VARCHAR(200)
COVERAGE_RANGE_START_TIME	The earliest time this kernel covers.	DATETIME
COVERAGE_RANGE_STOP_TIME	The latest time this kernel covers.	DATETIME
NUMBER_DATA_GAPS	The number of gaps in the kernel.	SMALLINT(6)
KERNAL_NAME_IN_DERIVATION_KERNAL	?? Laz: no bleeping clue... seems like Fei misunderstanding Brad. Brad might know what he meant originally?	VARCHAR(50)
KERNAL_STATUS	The status of this kernel.	ENUM("PREDICT", "RECONSTRUCTED", "DEJITTERED")
LAST_UPDATE	This column records the last time that a record was updated.	TIMESTAMP

Field: the field name inside table.
Type: the data type of the field.
Null: whether the field is allowed to be null.
Limits: the acceptable data range for the field.
Size: the upper limit data storage size for the field.
Default: the default value for the field.
Description: the definition for the field.
Authority: the agency responsible for definition of the field.
The fields with yellow color background is primary key or keys frequently used to link tables together.

Table Options:

type=InnoDB

This page was generated from the XML HiCat Data Dictionary. $Name: $

Contact

Please send comments to: HiCat@pirlmail.lpl.arizona.edu .