HiRISE Home


Last updated:
(none)

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:Special_Target_Requests
This table holds the "want-to-have" suggestion list by cycle and user.

Field Description Type Null Limits Size Key Default Authority Source
ID A unique, numeric identifier for each request. INT unsigned auto_increment Not Null Primary Key db server
CYCLE_ID The cycle the suggestion is to be acquired in. INT(5) unsigned Foreign Key which references Cycle_map (ID) ON DELETE SET NULL Cycle_map
SUGGESTED_OBSERVATIONS_ID The suggestion ID of the target request. INT(10) unsigned Not Null Foreign Key which references Suggested_Observations (ID) ON DELETE CASCADE Suggested_Observations
PEOPLE_ID The user id of the person adding the target to the list. INT(10) unsigned Not Null Foreign Key which references People (ID) ON DELETE CASCADE People.ID
CATEGORY_ID INT unsigned Foreign Key which references Special_Target_Categories (ID) ON DELETE CASCADE
QUEUE_POSITION INT Star Tool
PRIORITY The priority of the target. INT(2) HiReport
USER_INPUT JSON Star Tool
COMMENT Additional notes or justification for the target. TEXT HiReport
JSON_DATA JSON Star Tool
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) 2005-2020 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. $Name: $

Contact

Please send comments to: HiCat@pirlmail.lpl.arizona.edu.