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:EDR_Inventory

This table contains additional metadata information needed by the PDS
Profile Server to construct paths and URLs to the released data products.
There are several seemingly redundant fields in this table, they are
required by the PDS profile server.

Field

Description

Type

Null

Limits

Size

Key

Default

Authority

Source

productIdx

The product index. The values here should correspond to the
released products in the EDR_Products table.

INT(11)

Not Null

Primary Key

EDR_Products

productId

The EDR Product ID

VARCHAR(45)

EDR Products

dsIdx

The data set index. This should be a value that exists within the
dsIdx column in the EDR_Datasets table.

INT(11)

Not Null

Foreign Key which references EDR_Datasets (dsIdx) ON DELETE CASCADE

EDR_Datasets

volumeId

The PDS Volume Identifier. At this time, HiRISE is using a single
volumne.

VARCHAR(60)

Not Null

Release Tool

fileName

The PDS product file name. Excluding any system paths to file.

VARCHAR(120)

Not Null

EDR_Products

filePath

The logical system path to the product, excluding
the file name.

VARCHAR(255)

Not Null

EDR_Products

thumbnailFile

The file name of the thumbnail file.

VARCHAR(120)

Release Tool

browseFile

The file name of the browse file, excluding the path.

VARCHAR(120)

Release Tool

sourceThumbnailFile

The file name of the thumbnail image.

VARCHAR(120)

Release Tool

sourceBrowseFile

The file name of the browse file, excluding the path.

VARCHAR(120)

Release Tool

sourceDataFile

The PDS product file name, excluding the path

VARCHAR(120)

Release Tool

sourceLabelFile

The name of the PDS label file, excluding paths. For HiRISE EDR's, the
labels are attached to the PDS product, so this field should refer to
the actual PDS product.

VARCHAR(120)

Release Tool

sourceDisplayFile

The PDS product file name, excluding the path

VARCHAR(120)

Release Tool

sourceThumbPath

The path to the thumbnail file relative to the root of the PDS volume,
excluding the thumbnail file name.

VARCHAR(120)

Release Tool

sourceBrowsePath

The path to the browse file relative to the root of the PDS volume,
excluding the browse file name.

VARCHAR(120)

Release Tool

sourceDataPath

The path to the PDS product file relative to the root of the PDS volume,
excluding the product file name.

VARCHAR(120)

Release Tool

sourceLabelPath

The path to the PDS label file relative to the root of the PDS volume,
excluding the label file name. Since the labels are attached to
HiRISE EDR's this should be the path to the EDR product file.

VARCHAR(120)

Release Tool

sourceDisplayPath

Not currently in use by HiRISE.

VARCHAR(120)

Release Tool

destThumbPath

Not currently in use by HiRISE.

VARCHAR(120)

Release Tool

destBrowsePath

Not currently in use by HiRISE.

VARCHAR(120)

Release Tool

destDataPath

Not currently in use by HiRISE.

VARCHAR(120)

Release Tool

destLabelPath

Not currently in use by HiRISE.

VARCHAR(120)

Release Tool

destDisplayPath

Not currently in use by HiRISE.

VARCHAR(120)

Release Tool

errataFile

TBD

VARCHAR(120)

Release Tool

LAST_UPDATE

The last time the record was updated

TIMESTAMP

Not Null

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.