HiCat Data Dictionary

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

Field: the field name within the table.

Description: the definition for the field.

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.

Authority: the agency responsible for definition of the field.

Source: the most frequent source of data for this field.

Table Options:

type=InnoDB

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