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:DTM_Products
Store metadata about DTM products. Keeps track of product identification information,DTM product header data, product processing history information, product related files information. Most of the values in this table will be input/updated by DTMgen application.

Field Description Type Null Limits Size Key Default Authority Source
ID This is the unique ID for each RDTM Product. 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 db server
PRODUCT_ID This is the unique public identifier for this RDR Product. It is derived from the Product ID of the EDR products it is generated from. VARCHAR(33) Not Null DTM Producer
VERSION Version number of this record. VARCHAR(255) Not Null DTM Producer
SEQUENCE_NUMBER An integer used to distinguish between images that may be orthorectified to multiple DTMs. INT(2) DTM Producer
LEFT_OBSERVATION_ID The Observation ID of the left image used in the creation of the DTM. VARCHAR(28) DTM Producer
RIGHT_OBSERVATION_ID The Observation ID of the right image used in the creation of the DTM. VARCHAR(28) DTM Producer
SOURCE_DTM_PRODUCT_ID Orthimages are rectified using a DTM. This field records the DTM used for orthorectification. If the product is a DTM, this value should be "N/A" VARCHAR(33) DTM Producer
DATA_SET_ID_INDEX This column is a foreign key reference to the dsIdx column in the RDR_Datasets table. It indicates the correct Data_Set_ID record that the PDS Profile server should use when building a product profile. INT(10) unsigned Foreign Key which references RDR_Datasets (dsIdx) ON DELETE SET NULL
TARGET_NAME The name of the target for this Product. ENUM("MARS", "STARS", "PHOBOS", "DEIMOS", "SKY", "CAL", "LUNA", "MOON") DTM Label
RATIONALE_DESC A description of what was acquired with this Product. By default, this should probably be the RATIONALE_DESC of the left observation ID. TEXT DTM Label
LEFT_ORBIT_NUMBER The orbit number that this Product was acquired during. SMALLINT(10) unsigned DTMgen?
RIGHT_ORBIT_NUMBER The orbit number of the right image was taken from. SMALLINT(10) unsigned DTMgen?
SOFTWARE_NAME Version of the software that was used to create this product. VARCHAR(70) DTMgen
DATA_FILE_PATHNAME The full, logical path (filename included) of this RDR Product within the HiRISE filesystem. TEXT DTMgen
LABEL_FILE_PATHNAME The full, logical path (filename included) of the detached PDS label for this product. TEXT DTMgen
PRODUCT_CREATION_TIME This is the UTC time when this Product was created. DATETIME DTMgen
IMAGE_LINES The number of lines in this product. INT(11) unsigned DTMgen
LINE_SAMPLES The number of samples in each line. INT(11) unsigned DTMgen
MAP_RESOLUTION The map resolution in pixels/degree. FLOAT unsigned DTMgen
PRODUCT_TYPE The type of product, this may be the DTM or one of the orthoimages derived from the DTM and the source observations. ENUM("DTM","LEFT_ORTHOIMAGE","RIGHT_ORTHOIMAGE","ORTHOIMAGE") DTMgen?
MAP_SCALE The image resolution in meters/pixel at the center of the image. FLOAT unsigned DTMgen ?
LINE_PROJECTION_OFFSET This column provides the line offset value of the map projection origin position from the line and sample 1, 1 (line and smaple 1, 1 is considered the upper left corner of the digital array). FLOAT(10) DTMgen
SAMPLE_PROJECTION_OFFSET This column provides the sample offset value of the map projection origin position from line and sample 1,1. Positive direction is to the right and down. FLOAT DTMgen
IMAGE_CENTER_LATITUDE The center planetocentric latitude of this image. FLOAT -90 to 90 DTMgen
IMAGE_CENTER_LONGITUDE The center east longitude of this observation. FLOAT -180 to 360 DTMgen
MINIMUM_LATITUDE The maximum latitude of the projected map product. FLOAT -90 to 90 DTMgen
MAXIMUM_LATITUDE The minimum latitude of the projected map product. FLOAT -90 to 90 DTMgen
MINIMUM_LONGITUDE The minimum longitude of the projected map product. FLOAT -180 to 360 DTMgen
MAXIMUM_LONGITUDE The maximum longitude of the projected map product. FLOAT -180 to 360 DTMgen
UPPER_LEFT_LATITUDE The planetocentric latitude of the upper left corner of the image. FLOAT -90 to 90 DTMgen
UPPER_LEFT_LONGITUDE The longitude of the upper left corner of the image. FLOAT 0 to 360 DTMgen
UPPER_RIGHT_LATITUDE The planetocentric latitude of the upper right corner of the image. FLOAT -90 to 90 DTMgen
UPPER_RIGHT_LONGITUDE The longitude of the upper right corner of the image. FLOAT 0 to 360 DTMgen
LOWER_LEFT_LATITUDE The planetocentric latitude of the lower left corner of the image. FLOAT -90 to 90 DTMgen
LOWER_LEFT_LONGITUDE The longitude of the lower left corner of the image. FLOAT 0 to 360 DTMgen
LOWER_RIGHT_LATITUDE The planetocentric latitude of the lower right corner of the image. FLOAT -90 to 90 DTMgen
LOWER_RIGHT_LONGITUDE The longitude of the lower right corner of the image. FLOAT 0 to 360 DTMgen
NORTH_AZIMUTH The angle in degrees clockwise from the reference axis of the observation (a line from the center to the right edge of the observation) to the direction to the north pole of the target body. FLOAT 0 to 360 DTMgen
SUB_SOLAR_AZIMUTH The angle in degrees clockwise from the reference axis of the observation (a line from the center to the right edge of the observation) to the direction to the sub-solar point on the target body. FLOAT 0 to 360 DTMgen
MINIMUM_ELEVATION The minimum elevation of the DTM. This field is only relevant to the DTM product, the orthophotos will have a null value here. FLOAT DTMgen
MAXIMUM_ELEVATION The maximum elevation of the DTM. This field is only relevant to the DTM product, the orthophotos will have a null value here. FLOAT DTMgen
RDR_PRODUCT_TYPE The type of DTM Product this is. ENUM("RED", "COLOR", "FULL_RED", "FULL_COLOR", "BINNED_RED", "BINNED_COLOR") DTMgen?
PDS_DELIVER_DATE The date this product was delivered to the PDS. DATETIME HiArch ?
VALID_FLAG A NULL here means that this data has not gone through validation. Values mean that it has gone through the validation process. False means it has failed inspection and subsequent processing cannot proceed. True indicates that it can. TINYINT HiVali ?
VALIDATOR_USERNAME The system username of the person that has validated this Product. VARCHAR(32) HiVali ?
VALIDATOR_NOTE An optional note that may be written by the validator. TEXT HiVali ?
VALIDATE_TIME The UTC date when this Product was validated. DATETIME HiVali ?
FILE_SIZE The size of the file in bytes. INT(11) the product file
LAST_UPDATE This column records the last time that a record was updated. TIMESTAMP db server

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.