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

Field

Description

Type

Null

Limits

Size

Key

Default

Authority

Source

ID

This is the unique ID for each SPICE kernel. 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

PATHNAME

The full logical path (filename included) of this SPICE kernel file within
the HiRISE filesystem.

TEXT

ACQUISITION_TIME

The time that the kernel was acquired at HiROC.

DATETIME

KERNEL_TYPE

The type of kernel that this is.

ENUM("CK", "LSK", "SCLK", "SPK")

COMMENT

Comment about this kernel.

VARCHAR(200)

COVERAGE_RANGE_START_TIME_ET

Coverage start time in J2000 ET TDB seconds. NULL if the kernel has no
time coverage.

DOUBLE(15,5) unsigned

NULL

NAIF SPICE data distributions

NAIF SPICE Toolkit.

COVERAGE_RANGE_END_TIME_ET

Coverage end time in J2000 ET TDB seconds. NULL if the kernel has no
time coverage.

DOUBLE(15,5) unsigned

NULL

NAIF SPICE data distributions

NAIF SPICE Toolkit

COVERAGE_RANGE_START_TIME_SCLK

Coverage start time in terms of the MRO spacecraft clock value in
seconds:tics format where tics are 1/216. The time is
relative to the J2000 epoch.

VARCHAR(20)

NULL

NAIF SPICE data distributions

NAIF SPICE Toolkit

COVERAGE_RANGE_END_TIME_SCLK

Coverage end time in terms of the MRO spacecraft clock value in
seconds:tics format where tics are 1/216. The time
is relative to the J2000 epoch.

VARCHAR(20)

NULL

NAIF SPICE data distributions

NAIF SPICE Toolkit

COVERAGE_RANGE_START_TIME_UTC

Coverage start time in UTC. Note: The time will be rounded off to the
nearest second.

DATETIME

NULL

NAIF SPICE data distributions

NAIF SPICE Toolkit

COVERAGE_RANGE_END_TIME_UTC

Coverage end time in UTC. Note: The time will be rounded off to the
nearest second.

DATETIME

NULL

NAIF SPICE data distributions

NAIF SPICE Toolkit

KERNEL_STATUS

The status of this kernel.

ENUM("PREDICT", "RECONSTRUCTED", "SMITHED")

LAST_UPDATE

This column records the last time that a 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.