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:Cycle_map
This table maps cycle identifiers to various other time related ranges such as orbit ranges, dates, or LS. Note: This table is currently a stop gap measure to allow some automated procedures to gather cycle information. It is likely that the structure of this table may change in the future and some fields will probably be moved/removed. It is highly likely that the LS range will be removed.

Field Description Type Null Limits Size Key Default Authority Source
ID The cycle number. Note: Since the cycles are already identified by an integer value, the ID field is the integer value for the cycle, this is not an autoincrement field like most of the other tables in the database. INT(5) Not Null Primary Key State File
HITS The targeting specialist for this cycle. VARCHAR(25) HiTS
CIPP The Co-I of the Pay Period for this cycle. VARCHAR(25) CIPP
START_ORBIT The orbit the cycle begins executing on. INT(10) State File
END_ORBIT The orbit the cycle completes execution. INT(10) State File
STAND_DOWN_CYCLE A value of 1 in this fields indicates that the cycle in question is a "stand down cycle" where HiRISE will not be active. TINYINT(1) Not Null 0 Cycle Editing Tool
CONFIRMED A value of zero in this field indicates that the information in the record is preliminary, and subject to being updated as more cycle information becomes available. A value of 1 indicates that the information has been confirmed, most likely by a HiTS. TINYINT(1) Cycle Editing Tool
DEADLINE The WTH submission deadline for the cycle DATE STaR
NOTES Cycle related notes. TEXT STaR
LAST_UPDATE The date and time a record was last 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.