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:Web_Publications
Stores information about images release on the website, including who released the image, when it was released, and the location to which the image was released.

Field Description Type Null Limits Size Key Default Authority Source
ID This is the unique ID for each publication. 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
OBSERVATION_ID Global, unique ID for every observation. Input by Co-I. VARCHAR(30) Caption Editor
VERSION Version number of this record. VARCHAR(255) Not Null
CACHE The path to the JP2_PRODUCT on the internal HiRISE filesystem. TEXT
TITLE The title of the image. VARCHAR(200) Not Null Caption Editor
TITLE_FR Title translated into French VARCHAR(200) Not Null Caption Editor
TITLE_ES Title translated into Espanol VARCHAR(200) Not Null Caption Editor
TITLE_IT Title translated into Italian VARCHAR(200) Not Null Caption Editor
TITLE_PT Title translated into Portugese VARCHAR(200) Not Null Caption Editor
TITLE_AR Title translated into Arabic VARCHAR(200) Not Null Caption Editor
TITLE_DE Title translated auf Deutsch VARCHAR(200) Not Null Caption Editor
TITLE_HB Title translated into Hebrew VARCHAR(200) Not Null Caption Editor
TITLE_GR Title translated into Greek VARCHAR(200) Not Null Caption Editor
TITLE_CN Title translated into Chinese. VARCHAR(255) Not Null Caption Editor
TITLE_NL Title translated into Dutch VARCHAR(255) Not Null Caption Editor
TITLE_IS Title translated into Icelandic. VARCHAR(255) Not Null Caption Editor
TITLE_RU Title translated into Russian. VARCHAR(255) Not Null Caption Editor
TITLE_PL Title translated into Polish. VARCHAR(255) Not Null Caption Editor
TITLE_LA Title translated into Latin VARCHAR(255) Not Null Caption Editor
TITLE_TR Title translated into Turkish VARCHAR(255) Not Null Caption Editor
TITLE_FA Title translated into Farsi VARCHAR(255) Not Null Caption Editor
TITLE_GA Title translated into Irish Gaelic VARCHAR(255) Not Null Caption Editor
TITLE_SV Title translated into Swedish VARCHAR(255) Not Null Caption Editor
TITLE_UA Title translated into Ukrainian VARCHAR(255) Not Null Caption Editor
TITLE_CA Title translated into Catalan VARCHAR(255) Not Null Caption Editor
TITLE_HU Title translated into Hungarian VARCHAR(255) Not Null Caption Editor
TITLE_CY Title translated into Welsh VARCHAR(255) Not Null Caption Editor
TITLE_RO Title translated into Romanian VARCHAR(255) Not Null Caption Editor
TITLE_NO Title translated into Norwegian VARCHAR(255) Not Null Caption Editor
TITLE_HI Title translated into Hindi VARCHAR(255) Not Null Caption Editor
TITLE_GV Title translated into Manx VARCHAR(255) Not Null Caption Editor
TITLE_KW Title translated into Cornish VARCHAR(255) Not Null Caption Editor
TITLE_FI Title translated into Finnish VARCHAR(255) Not Null Caption Editor
TITLE_EO Title translated into Esperanto VARCHAR(255) Not Null Caption Editor
SHORT_CAPTION The text of the "short" caption. TEXT Not Null Caption Editor
SHORT_CAPTION_FR The text of the "short" caption in French. TEXT Not Null Caption Editor
SHORT_CAPTION_ES The text of the "short" caption in Spanish. TEXT Not Null Caption Editor
SHORT_CAPTION_IT The text of the "short" caption in Italian. TEXT Not Null Caption Editor
SHORT_CAPTION_PT The text of the "short" caption in Portugese. TEXT Not Null Caption Editor
SHORT_CAPTION_AR The text of the "short" caption in Arabic. TEXT Not Null Caption Editor
SHORT_CAPTION_DE The text of the "short" caption in German. TEXT Not Null Caption Editor
SHORT_CAPTION_HB The text of the "short" caption in Hebrew. TEXT Not Null Caption Editor
SHORT_CAPTION_GR The text of the "short" caption in Greek. TEXT Not Null Caption Editor
SHORT_CAPTION_CN The text of the "short" caption in Chinese. TEXT Not Null Caption Editor
SHORT_CAPTION_NL The text of the "short" caption in Dutch. TEXT Not Null Caption Editor
SHORT_CAPTION_IS The text of the "short" caption in Icelandic. TEXT Not Null Caption Editor
SHORT_CAPTION_RU The text of the "short" caption in Russian. TEXT Not Null Caption Editor
SHORT_CAPTION_PL The text of the "short" caption in Polish. TEXT Not Null Caption Editor
SHORT_CAPTION_LA The text of the "short" caption in Latin. TEXT Not Null Caption Editor
SHORT_CAPTION_TR The text of the "short" caption in Turkish TEXT Not Null Caption Editor
SHORT_CAPTION_FA The text of the "short" caption in Farsi TEXT Not Null Caption Editor
SHORT_CAPTION_GA The text of the "short" caption in Irish Gaelic TEXT Not Null Caption Editor
SHORT_CAPTION_SV The text of the "short" caption in Swedish TEXT Not Null Caption Editor
SHORT_CAPTION_UA The text of the "short" caption in Ukrainian TEXT Not Null Caption Editor
SHORT_CAPTION_CA The text of the "short" caption in Catalan TEXT Not Null Caption Editor
SHORT_CAPTION_HU The text of the "short" caption in Hungarian TEXT Not Null Caption Editor
LONG_CAPTION All the gory details. TEXT Caption Editor
LONG_CAPTION_ANAGLYPH Long caption for any associated anaglyph. TEXT Caption Editor
LONG_CAPTION_DTM Long caption for any associated DTM. TEXT Caption Editor
LONG_CAPTION_FR All the gory details in French. TEXT Caption Editor
LONG_CAPTION_ES All the gory details in Espanol. TEXT Caption Editor
LONG_CAPTION_IT All the gory details in Italian. TEXT Caption Editor
LONG_CAPTION_PT All the gory details in Portugese. TEXT Caption Editor
LONG_CAPTION_AR All the gory details in Arabic. TEXT Caption Editor
LONG_CAPTION_DE All the gory details in German. TEXT Caption Editor
LONG_CAPTION_HB All the gory details in Hebrew TEXT Caption Editor
LONG_CAPTION_GR All the gory details in Greek TEXT Captioni Editor
LONG_CAPTION_CN The text of the "long" caption in Chinese. TEXT Not Null Caption Editor
LONG_CAPTION_NL The text of the "long" caption in Dutch TEXT Not Null Caption Editor
LONG_CAPTION_IS The text of the "long" caption in Icelandic TEXT Not Null Caption Editor
LONG_CAPTION_RU The text of the "long" caption in Russian TEXT Not Null Caption Editor
LONG_CAPTION_PL The text of the "long" caption in Polish TEXT Not Null Caption Editor
LONG_CAPTION_LA The text of the "long" caption in Latin TEXT Not Null Caption Editor
LONG_CAPTION_TR The text of the "long" caption in Turkish TEXT Not Null Caption Editor
LONG_CAPTION_FA The text of the "long" caption in Farsi TEXT Not Null Caption Editor
LONG_CAPTION_GA The text of the "long" caption in Irish Gaelic TEXT Not Null Caption Editor
LONG_CAPTION_SV The text of the "long" caption in Swedish TEXT Not Null Caption Editor
LONG_CAPTION_UA The text of the "long" caption in Ukrainian TEXT Not Null Caption Editor
LONG_CAPTION_CA The text of the "long" caption in Catalan TEXT Not Null Caption Editor
LONG_CAPTION_HU The text of the "long" caption in Hungarian TEXT Not Null Caption Editor
LONG_CAPTION_CY The text of the "long" caption in Welsh TEXT Not Null Caption Editor
LONG_CAPTION_RO The text of the "long" caption in Romanian TEXT Not Null Caption Editor
LONG_CAPTION_Norwegian The text of the "long" caption in Hungarian TEXT Not Null Caption Editor
LONG_CAPTION_HI The text of the "long" caption in Hindi TEXT Not Null Caption Editor
LONG_CAPTION_GV The text of the "long" caption in Manx TEXT Not Null Caption Editor
LONG_CAPTION_KW The text of the "long" caption in Cornish TEXT Not Null Caption Editor
LONG_CAPTION_FI The text of the "long" caption in Finnish TEXT Not Null Caption Editor
LONG_CAPTION_EO The text of the "long" caption in Esperanto TEXT Not Null Caption Editor
ENTRY_DATE The date this caption was first entered into the database. DATE Caption Editor
KEYWORDS A comma separated list of key words. VARCHAR(255) Not Null Caption Editor
SPOT_LIGHT A flag to determine if the release will be spotlighted on the main release page. TINYINT(4) Not Null Caption Editor
STATUS Should the image be online? ENUM('NO','YES','DRAFT','EMBARGOED') Not Null Caption Editor
WEB_SPOT_IMAGE URL to the spotlight web image. VARCHAR(255) Not Null Caption Editor
WEB_CUT_OUT_IMAGE URL to the cut out image prepared for the observation page. VARCHAR(255) Not Null Caption Editor
WEB_THUMB_IMAGE URL to the web thumbnail image. VARCHAR(255) Not Null Caption Editor
WEB_CAPTION_CUT_OUT_IMAGE URL (if provided) to the special cut out of the product identified by the caption writer. TEXT Not Null Caption Editor
IPOD_IMAGE Ipod Image VARCHAR(255) Not Null Caption Editor
TITLE_IMAGE URL to the graphic of the TITLE column VARCHAR(255) Not Null Caption Editor
KILL_DATE The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_AR The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_CA The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_CN The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_CY The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_DE The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_EO The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_ES The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_FA The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_FI The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_FR The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_GA The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_GR The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_GV The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_HB The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_HU The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_IS The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_IT The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_KW The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_LA The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_NL The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_PL The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_PT The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_NO The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_RO The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_RU The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_SV The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_TR The date the spotlight image falls off the main page. DATE Caption Editor
KILL_DATE_UA The date the spotlight image falls off the main page. DATE Caption Editor
WRITER Release author(s). Input by Co-I. VARCHAR(250) Caption Editor
RELEASE_DATE Release date. Input by Co-I. DATE Caption Editor
NEWS_DATE News date DATE Caption Editor
NOTES Notes about this release for internal use. Should contain the name of any cutout image that goes with the caption. TEXT Caption Editor
WEB_EDIT Is the caption ready for editing by the web master? TINYINT(4) Not Null Caption Editor
CUBENORM_NEEDED Does the image need to be cubenormed prior to release? ENUM('NO','YES') Caption Editor
CUBENORM_COMPLETED Has the cubenorm of the observation been completed? ENUM('NO','YES') Not Null Caption Editor
RED_GEOMETRY Has Red Geometry been completed? ENUM('NO','YES') Not Null Caption Editor
COLOR_GEOMETRY Has Color Geometry been completed? ENUM('NO','YES') Not Null Caption Editor
WEB_EDITOR_READY Is the observation ready for web editing? ENUM('NO','YES') Not Null Caption Editor
FLYER_EN Indicates if an english HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_FR Indicates if a french HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_ES Indicates if a spanish HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_PT Indicates if a portugese HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_IT Indicates if an italian HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_NL Indicates if an dutch HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_DE Indicates if a german HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_AR Indicates if an arabic HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_HB Indicates if an hebrew HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_IS Indicates if an Icelandic HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_RU Indicates if a Russian HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_PL Indicates if a Polish HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_GR Indicates if a Greek HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_LA Indicates if a Latin HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_TR Indicates if a Turkish HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_FA Indicates if a Farsi HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_GA Indicates if an Irish HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_SV Indicates if a Swedish HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_UA Indicates if a Ukrainian HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_CA Indicates if a Catalan HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_HU Indicates if a Hungarian HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_CY Indicates if a Welsh HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_RO Indicates if a Romanian HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_NO Indicates if a Norwegian HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_HI Indicates if a Hindi HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_GV Indicates if a Manx HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_KW Indicates if a Cornish HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_FI Indicates if a Finnish HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
FLYER_EO Indicates if a Esperanto HiFlyer has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_EN Indicates if an English clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_FR Indicates if a French clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_ES Indicates if a Spanish clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_PT Indicates if a Portuguese clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_NL Indicates if a Dutch clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_AR Indicates if an Arabic clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_DE Indicates if a German clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_GR Indicates if a Greek clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_IT Indicates if an Italian clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_RU Indicates if a Russian clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_PL Indicates if a Polish clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_LA Indicates if a Latin clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_FA Indicates if a Farsi clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_GA Indicates if an Irish clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_SV Indicates if a Swedish clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_UA Indicates if a Ukrainian clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_CA Indicates if a Catalan clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_HU Indicates if a Hungarian clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_CY Indicates if a Welsh clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_RO Indicates if a Romanian clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_NO Indicates if a Norwegian clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_HI Indicates if a Hindi clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_GV Indicates if a Manx clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_KW Indicates if a Cornish clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_FI Indicates if a Finnish clip has been created. ENUM('NO','YES') Not Null Caption Editor
CLIP_EO Indicates if an Esperanto clip has been created. ENUM('NO','YES') Not Null Caption Editor
HD_HICLIP_TITLE VARCHAR(200) Caption Editor
FOURK_HICLIP_TITLE VARCHAR(200) Caption Editor
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.