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:Extras_Products
Track and store information about extras products.

Field Description Type Null Limits Size Key Default Authority Source
ID A unique record identifying integer. INT(10) unsigned auto_increment Not Null Primary Key db server
OBSERVATION_ID The id of the observation this extras product is derived from. VARCHAR(25) Pipelines
PRODUCT_ID The product ID of the PDS product that the extras product is derived from or associated with. If the extras product is not associated with any official PDS product, then the OBSERVATION_ID should be entered here. VARCHAR(28) Not Null Pipelines
VERSION The version of the product ID that this extras product is associated with. INT(4) Not Null Pipelines
FILE_TYPE The type of extras file. See the Extras_File_Types table for the allowed values. INT(2) unsigned Foreign Key which references Extras_File_Types (ID) ON DELETE SET NULL Pipelines
PATHNAME The full logical path of the extras product, including the file name. TEXT Not Null Pipelines
PRODUCT_CREATION_TIME The creation date and time of the extras product. DATETIME Pipelines
IMAGE_LINES The number of lines in the image. INT(11) Pipelines
LINE_SAMPLES The number of samples per image line. INT(11) Pipelines
BAND1_STRETCH_MINIMUM The minimum value of the stretch on band 1. For standard products, this is for the IR band, for rgb products, this is the red channel. DOUBLE(18,15) Pipelines
BAND1_STRETCH_MAXIMUM The maximum value of the stretch on band 1. For standard products, this is for the IR band, for rgb products, this is the red channel. DOUBLE(18,15) Pipelines
BAND2_STRETCH_MINIMUM The minimum value of the stretch on band 2. For standard products, this is for the RED band, for rgb products, this is the green channel. DOUBLE(18,15) Pipelines
BAND2_STRETCH_MAXIMUM The maximum value of the stretch on band 2. For standard products, this is for the RED band, for rgb products, this is the green channel. DOUBLE(18,15) Pipelines
BAND3_STRETCH_MINIMUM The minimum value of the stretch on band 3. For standard products, this is for the blue-green band, for rgb products, this is the blue channel. DOUBLE(18,15) Pipelines
BAND3_STRETCH_MAXIMUM The maximum value of the stretch on band 3. For standard products, this is for the blue-green band, for rgb products, this is the blue channel. DOUBLE(18,15) Pipelines
FILE_SIZE The size of the file in bytes. INT(11) Pipelines
LAST_UPDATE This column records the last time the record was updated. TIMESTAMP db server

Table Options:

Copyright (C) 2015 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.