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:Suggested_Observations_GIS
This table stores suggestion geometry information using MySQL's geospatial datatypes. This data must be kept in a table separate from the rest of the suggestion information due to certian limitations on how these datatypes are stored in the database.

Field Description Type Null Limits Size Key Default Authority Source
SUGGESTED_OBSERVATIONS_ID The suggestion id from the Suggested_Observations table for which geometry information is being stored. INT(10) unsigned Not Null Primary Key Suggested_Observations.ID
CENTER The center of the suggestion as a "point" object. POINT Not Null Suggested_Observations.CENTER_LONGITUDE, Suggested_Observations.CENTER_LATITUDE
REGION_OF_INTEREST The region of interest of the suggestion as a polygon object. POLYGON Not Null Suggested_Observations.ROI_VERTICES
LAST_UPDATE This column records the last time that a record was updated. TIMESTAMP db server

Table Options:

Copyright (C) 2005-2022 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. HEAD

Contact

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