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
Please send comments to: HiCat@pirlmail.lpl.arizona.edu.