Field |
Description |
Type |
Null |
Limits |
Size |
Key |
Default |
Authority |
Source |
ID |
This is the unique ID for each Suggested Observation. 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 |
VERSION |
Version number of this record. If needed by HiWeb.
|
VARCHAR(255) |
Not Null |
|
|
|
|
|
HiWeb |
CENTER_LATITUDE |
This is the center planetocentric latitude of the suggested observation.
|
FLOAT |
|
-90 to 90 |
|
|
|
|
HiWeb |
CENTER_LONGITUDE |
This is the center east longitude of the suggested observation.
|
FLOAT |
|
0 to 360 |
|
|
|
|
HiWeb |
MAX_LATITUDE |
This is the maximum bound of planetocentric latitude covered
by this suggestion.
|
FLOAT |
|
-90 to 90 |
|
|
|
|
HiWeb |
MIN_LATITUDE |
This is the minimum bound of planetocentric latitude covered
by this suggestion.
|
FLOAT |
|
-90 to 90 |
|
|
|
|
HiWeb |
MAX_LONGITUDE |
This is the maximum bound of east longitude covered by this suggestion.
|
FLOAT |
|
0 to 360 |
|
|
|
|
HiWeb |
MIN_LONGITUDE |
This is the minimum bound of east longitude covered by this suggestion.
|
FLOAT |
|
0 to 360 |
|
|
|
|
HiWeb |
ROI_VERTICES |
A list of up to 16 longitude and latitude pairs which are the vertices
of a polygon specifying a region of interest.
|
TEXT |
|
|
|
|
|
|
HiWeb |
EXACT_AREA_REQUESTED |
Does the entire region of interest specified in the ROI_VERTICES field
need to be imaged?
|
TINYINT(1) |
|
false, or true |
|
|
|
|
HiWeb |
NEED_STEREO |
This indicates whether this suggestion requires stereo to achieve its
goals.
|
TINYINT |
|
false, or true |
|
|
|
|
HiWeb |
PRIORITY_STEREO |
Priority of a stereo observation request made by the suggestor.
A value of 5, is the highest priority.
|
TINYINT |
|
1 to 5 |
|
|
|
|
HiWeb |
NEED_COLOR |
This indicates whether this suggestion requires color to achieve its
goals.
|
TINYINT |
|
false, or true |
|
|
|
|
HiWeb |
PRIORITY_COLOR |
Priority of a color request made by the suggestor.
A value of 5, is the highest priority.
|
TINYINT |
|
1 to 5 |
|
|
|
|
HiWeb |
PRIORITY_HIGHRES |
Priority of a high-resolution request made by the suggestor.
A value of 5, is the highest priority.
|
TINYINT |
|
1 to 5 |
|
|
|
|
HiWeb |
CRISM_COORDINATION |
Does this observation need coordination with CRISM?
|
ENUM("NO","YES") |
Not Null |
|
|
|
NO |
|
HiWeb |
MAX_BINNING |
The maximum binning allowable for this suggestion. The binning value
may be less than this value (i.e. not binned as much), but won't be
more. Allowable values are 1, 2, 3, 4, 8, and 16.
|
TINYINT(2) unsigned |
|
1, 2, 3, 4, 8, or 16 |
|
|
4 |
|
HiWeb |
MAX_LSUBS |
The maximum allowable LS value for this suggestion.
|
FLOAT |
Not Null |
0 to 360 |
|
|
360 |
|
HiWeb |
MIN_LSUBS |
The minimum allowable LS value for this suggestion.
|
FLOAT |
Not Null |
0 to 360 |
|
|
0 |
|
HiWeb |
MAX_PHASE_ANGLE |
The maximum allowable phase angle for this suggestion in degrees.
|
FLOAT |
Not Null |
0 to 180 |
|
|
180 |
|
HiWeb |
MIN_PHASE_ANGLE |
The minimum allowable phase angle for this suggestion in degrees.
|
FLOAT |
Not Null |
0 to 180 |
|
|
0 |
|
HiWeb |
MAX_INCIDENCE_ANGLE |
The maximum allowable incidence angle for this suggestion in degrees.
|
FLOAT |
Not Null |
0 to 90 |
|
|
75 |
|
HiWeb |
MIN_INCIDENCE_ANGLE |
The minimum allowable incidence angle for this suggestion in degrees.
|
FLOAT |
Not Null |
0 to 90 |
|
|
0 |
|
HiWeb |
MAX_EMISSION_ANGLE |
The maximum allowable emission angle for this suggestion in degrees.
|
FLOAT |
Not Null |
0 to 90 |
|
|
40 |
|
HiWeb |
MIN_EMISSION_ANGLE |
The minimum allowable emission angle for this suggestion in degrees.
|
FLOAT |
Not Null |
0 to 90 |
|
|
0 |
|
HiWeb |
PRIORITY_OVERALL |
Overall priority given to the image suggestion by the suggestor.
A value of 5, is the highest priority.
|
TINYINT |
|
1 to 5 |
|
|
|
|
HiWeb |
PRIORITY |
The priority given to this suggestion by the HiRISE team.
Individual Co-I's will use values of 0-10 for prioritizing
image suggestions. Zero is the lowest priority, and a ten
is a suggestion of highest scientific merit. After team
discussion, the image suggestion can be elevated to values
between 11 and 15. An 11 indicates that the team thinks
this is a valuable suggestion, and a 15 indicates that the
team thinks this is of maximum priority. The goal in this
2-tier priority scheme is to clearly distinguish between
priorities that were developed by a single Co-I versus team
discussion. This is a different scale than the priority
in the Planned_Observations table. This field is the equivalent
STL priority field.
|
ENUM("0 - CO-I Assigned Priority - minimum","1 - CO-I Assigned Priority",
"2 - CO-I Assigned Priority","3 - CO-I Assigned Priority",
"4 - CO-I Assigned Priority","5 - CO-I Assigned Priority",
"6 - CO-I Assigned Priority","7 - CO-I Assigned Priority",
"8 - CO-I Assigned Priority","9 - CO-I Assigned Priority",
"10 - CO-I Assigned Priority - maximum","11 - Team Assigned Priority - minimum",
"12 - Team Assigned Priority","13 - Team Assigned Priority",
"14 - Team Assigned Priority","15 - Team Assigned Priority - maximum"
) |
|
0 to 15 |
|
|
|
|
HiPlan ? |
DATE_PRIORITIZED |
The UTC date that this suggestion was given a priority by the
team.
|
DATETIME |
|
|
|
|
|
|
HiPlan ? |
SCIENCE_RATIONALE |
The scientific rationale for why this suggestion should be acquired.
|
TEXT |
Not Null |
|
|
|
|
|
HiWeb |
DESCRIPTION |
A 75 character description of the image suitable for use in the
RATIONALE_DESC element of the PDS label for the image.
|
VARCHAR(75) |
Not Null |
|
|
|
|
|
HiWeb |
APPROVAL_STATUS |
This field indicates whether the description of a given suggestion has been
approved by an STL. Descriptions submitted by HiRISE team members will be
automatically approved, while suggestions that are rejected by STLs will
most likely be deleted.
|
ENUM("APPROVED","PENDING","REJECTED") |
Not Null |
|
|
|
|
|
HiWeb |
SUGGESTION_DATE |
The date and time the suggestion was made.
|
DATETIME |
|
|
|
|
|
|
HiWeb |
SUCCESS_VALIDATOR_USERNAME |
The username of the person that validated that this suggestion was
successful.
|
VARCHAR(32) |
|
|
|
|
|
|
HiVali ? |
DATE_SUCCESS |
The date this suggestion was retired by a planned or acquired observation.
|
DATETIME |
|
|
|
|
|
|
HiPlan or the Retire_Suggestions utility |
RETIRING_OBSERVATION_ID |
The Observation ID of the image that satisfied this suggestion.
|
VARCHAR(25) |
|
|
|
|
|
|
HiPlan or the Retire_Suggestions utility |
UNRETIREMENT_REQUEST_FLAG |
This field indicates if a suggestion has been unretired
prior to the geometry processing of the retiring observation id. If set
to 1, and the Retire_Suggestions application is passed the -Geometry option,
then the suggestion will not be automatically retired in the HiGeomInit
pipeline, instead, the application will reset this field to zero
without retiring the suggestion.
|
TINYINT(1) |
Not Null |
|
|
|
0 |
|
Suggestion Retirement Applications |
SPECIAL_NOTES |
This field contains any notes that are specific to details of
this suggestion.
|
TEXT |
|
|
|
|
|
|
HiWeb |
TARGET_NAME |
The name of the target for this suggestion. The NONE option in this list
indicates that the suggestion has been marked as "deleted" by the
suggestor. In principle, a HiWeb user will be able to undelete a
suggestion by having HiWeb reset this field back to Mars.
|
ENUM("MARS", "STARS", "PHOBOS", "DEIMOS", "SKY", "CAL", "LUNA", "MOON", "NONE", "NOPROC") |
|
|
|
|
MARS |
|
HiWeb |
NUMBER_OF_OBSERVATIONS |
Is this the number of observations that the suggestor needs for this
suggestion.
|
TINYINT(3) unsigned |
|
|
|
|
|
|
HiWeb |
STL_DESCRIPTION |
A 75 character description of the image suitable for use in the
RATIONALE_DESC element of the PDS label for the image. This column contains
the version of the description approved by the STL.
|
VARCHAR(75) |
Not Null |
|
|
|
|
|
HiWeb |
STL_MUST_HAVE |
Is this suggestion a "must-have?"
|
ENUM("NO","YES") |
Not Null |
|
|
|
NO |
|
HiWeb |
STL_STEREO |
Is suggestion to be part of a stereo observation?
|
ENUM("NO","YES") |
Not Null |
|
|
|
NO |
|
HiWeb |
STL_CRISM_COORDINATION |
Will this suggestion be coordinated with CRISM?
|
ENUM("NO","YES") |
Not Null |
|
|
|
NO |
|
HiWeb |
STL_OFF_NADIR_IO |
Is this suggestion an off nadir IO?
|
ENUM("NO","YES") |
Not Null |
|
|
|
NO |
|
HiWeb |
STL_HIGH_STABILITY_NADIR |
Does this suggestion need High Stability?
|
ENUM("NO","YES") |
Not Null |
|
|
|
NO |
|
HiWeb |
STL_NONINTERACTIVE |
Should this suggestion be planned as non-interactive
observation?
|
ENUM("NO","YES") |
Not Null |
|
|
|
NO |
|
HiWeb |
STL_MAX_BINNING |
The maximum binning allowed for this observation, as determined
by the Science Theme Lead.
|
TINYINT(2) unsigned |
|
1, 2, , 4, 8, or 16 |
|
|
4 |
|
HiWeb |
STL_MAX_PHASE_ANGLE |
The maximum phase angle in degrees as determined by the science theme lead.
|
FLOAT |
|
0 to 180 |
|
|
180 |
|
HiWeb |
STL_MIN_PHASE_ANGLE |
The minimum phase angle in degrees as determined by the science them lead.
|
FLOAT |
|
0 to 180 |
|
|
0 |
|
HiWeb |
STL_MAX_INCIDENCE_ANGLE |
The maximum allowable phase angle for this suggestion in degrees as
determined by the science theme lead.
|
FLOAT |
|
0 to 90 |
|
|
75 |
|
HiWeb |
STL_MIN_INCIDENCE_ANGLE |
The minimum allowable phase angle for this suggestion in degrees as
determined by the science theme lead.
|
FLOAT |
|
0 to 90 |
|
|
0 |
|
HiWeb |
STL_MAX_EMISSION_ANGLE |
The maximum allowable emission angle for this suggestion in degrees as
determined by the science theme lead.
|
FLOAT |
|
0 to 90 |
|
|
40 |
|
HiWeb |
STL_MIN_EMISSION_ANGLE |
The minimum allowable emission angle for this suggestion in degrees as
determined by the science theme lead.
|
FLOAT |
|
0 to 90 |
|
|
0 |
|
HiWeb |
STL_MAX_LSUBS |
The maximum allowable Ls for this suggestion in
degrees as determined by the science theme lead.
|
FLOAT |
|
0 to 360 |
|
|
360 |
|
HiWeb |
STL_MIN_LSUBS |
The minimum allowable Ls for this suggestion in
degrees as determined by the science theme lead.
|
FLOAT |
|
0 to 360 |
|
|
0 |
|
HiWeb |
STL_NUMBER_OF_OBSERVATIONS |
The number of observations needed to satisfy this suggestion as determined
by the science theme lead.
|
TINYINT(3) |
|
|
|
|
1 |
|
HiWeb |
STL_EDIT_DATE |
The date and time when the science theme lead last modified their
preferences for the suggestion. NULL if no modifications have been
made.
|
DATETIME |
|
|
|
|
|
|
HiWeb |
STEREO_COMPLETION_REQUESTED |
Indicates if the suggestion is a stereo completion request on
a previously acquired target.
|
TINYINT |
Not Null |
|
|
|
0 |
|
HiWish
|
LAST_UPDATE |
This column records the last time that a record was updated.
|
TIMESTAMP |
|
|
|
|
|
|
db server |
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.