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 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:Planned_CCD_Parameters
Stores information about planned parameters per CCD, generated by HiPlan and edited by a Co-I.

Field Description Type Null Limits Size Key Default Authority Source
PLANNED_OBSERVATIONS_ID This field should hold a value from the ID column of the Planned_Observations table. The combination of this field, and the CCD_NAME field are unique. INT(10) unsigned Not Null Foreign Key which references Planned_Observations (ID) ON DELETE CASCADE db server
CCD_NAME This is the CCD name for this planned CCD parameter. VARCHAR(4) Not Null HiPlan
VERSION Version number of this record. If needed by HiPlan. VARCHAR(255) Not Null HiPlan
BINNING The binning for this CCD for this Planned Observation. Allowable values are 1, 2, 3, 4, 8, and 16. TINYINT(2) unsigned Not Null 1, 2, 3, 4, 8, or 16 HiPlan
TDI The Time Delay and Integration mode for this CCD for this Planned Observation. Allowable values are 8, 32, 64, and 128. TINYINT(3) unsigned Not Null 8, 32, 64, or 128 HiPlan
IMAGE_LINES The number of image lines that this CCD will produce for this Planned Observation. INT(11) Not Null HiPlan
TRIM_LINES The number of trim lines that this CCD will have for this Planned Observation. INT(11) Not Null HiPlan
LOOKUP_TABLE_TYPE The lookup table that will be applied to the data coming from this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. ENUM("N/A", "LINEAR", "SQUARE ROOT", "STORED") Not Null HiPlan
LOOKUP_TABLE_MINIMUM The minimum value that will be returned from the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. INT(11) HiPlan
LOOKUP_TABLE_MAXIMUM The maximum value that will be returned from the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. INT(11) HiPlan
LOOKUP_TABLE_MEDIAN The median value of the the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. INT(11) HiPlan
LOOKUP_TABLE_K_VALUE The k value, or spread, of the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. INT(11) HiPlan
LOOKUP_TABLE_NUMBER This is the number of the stored lookup table that will be used when LOOKUP_TABLE_TYPE is set to "STORED". It is meaningless otherwise. There are 28 stored lookup tables, numbered zero through 27 SMALLINT(2) 0 to 27 HiPlan
RAW_DATA_VOLUME_BYTES The expected file size in bytes, that this CCD will produce for this Planned Observation. This volume does not include FELICS compression. INT(10) unsigned Not Null HiPlan
IMAGE_MEAN The estimated image mean for the CCD. FLOAT HIPHOP
PLANNED_SNR This is the expected signal-to-noise-ratio for this CCD for this Planned Observation. FLOAT HiPlan
LAST_UPDATE This column records the last time that a record was updated. TIMESTAMP db server

Other creation definitions:

Table Options:

Copyright (C) 2005-2022 Arizona Board of Regents on behalf of the Planetary Image Research Laboratory, Lunar and Planetary Laboratory at the University of Arizona.

This page was generated from the XML HiCat Data Dictionary. HEAD

Contact

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